developing a web-based distributed database management system.

hi experts!thanx so much for all the guidelines you have been giving me,i have really made great progress in my studies,thanx to you!

This time i need you to help me with guidelines as to the steps to follow when developing ;a web-based distributed database management system.this is a project i am working on,so i want some tips on how to tackle it.at the moment i am learning the java as i will be using this language.i understand the web-based part but im not too sure about the distributing part,thus how i will be able to access databases at different sites in one database that i call the headquaters database.i know i have to concern myself with things like the protocols but can u pliz enlighten me on this topic?
msberthAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wyliecoyoteukIT directorCommented:
You need to supply a little more info

what webserver? e.g. Apache, IIS, etc
what database backend? e.g. SQL,MySQL,etc
what scripting? e.g. PHP,ASP,etc
What OS? E.G. wINDOWS, uNIX, lINUX,ETC.

Do you want one backend accessed by multiple clients, or do you want multiple backends that synchronise on a regular basis?

I am not a database or web programmer, just trying to help you ask the right questions.

good luck
0
wyliecoyoteukIT directorCommented:
You need to supply a little more info

what webserver? e.g. Apache, IIS, etc
what database backend? e.g. SQL,MySQL,etc
what scripting? e.g. PHP,ASP,etc
What OS? E.G. wINDOWS, uNIX, lINUX,ETC.

Do you want one backend accessed by multiple clients, or do you want multiple backends that synchronise on a regular basis?

I am not a database or web programmer, just trying to help you ask the right questions.

good luck
0
msberthAuthor Commented:
web-server- IIS
database backend-MYSQL
sript-ASP
OS- windows

i want multiple backends that synchronise on a regular basis.
0
wyliecoyoteukIT directorCommented:
oops, sorry for the double post (and the capslock error)

I have been without Internet acces for a few days, due to my providers incompetence.

There are solutions out there, but the only ones I know of ( and have used) are Apache and PHP based.

They tend to be WAMP or LAMP
(Windows, Apache, MySQL, PHP, or Linux, Apache, MySQL, PHP)

That might be because Apache, MySQL, and PHP are all open source solutions.

I don`t think that IIS, ASP and MySQL should be too problematic, except for Microsoft licensing issues with regard to any opensource software being used in conjunction with theirs.

I have a friend who uses ASP and IIS for some of his clients, but he uses Access, Oracle or Microsoft SQL, Mainly because they had that in place when he took them on.

The only sites I know of that he uses MySQL with (My company site is one of them), he uses Apache and PHP.

Have a look at www.PHProjekt.org for an example of a WAMP/LAMP solution with source available.

If you want to synchronise backends, you will be limited with regard to what data is changeable per backend or client.

I can`t really help more than that,  Might be worth reposting in WebDev or Programming Forums.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.