Solved

developing a web-based distributed database management system.

Posted on 2003-11-05
4
273 Views
Last Modified: 2013-12-03
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
Comment
Question by:msberth
  • 3
4 Comments
 
LVL 21

Expert Comment

by:wyliecoyoteuk
ID: 9690127
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
 
LVL 21

Expert Comment

by:wyliecoyoteuk
ID: 9690128
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
 

Author Comment

by:msberth
ID: 9700030
web-server- IIS
database backend-MYSQL
sript-ASP
OS- windows

i want multiple backends that synchronise on a regular basis.
0
 
LVL 21

Accepted Solution

by:
wyliecoyoteuk earned 125 total points
ID: 9708205
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

806 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question