• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

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?
0
msberth
Asked:
msberth
  • 3
1 Solution
 
wyliecoyoteukCommented:
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
 
wyliecoyoteukCommented:
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
 
wyliecoyoteukCommented:
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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now