Solved

developing a web-based distributed database management system.

Posted on 2003-11-05
4
271 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
upgrading flat network to VLAN 3 79
Cisco MRA Phones 4 28
Copy a file to a share on a Domain 3 58
Route Summarization 2 33
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 …
PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
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…

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now