What programs are needed to build a database?

Asked By 40 points N/A Posted on -
qa-featured

 

Can someone please tell me the programs needed to build a database together with their advantages and disadvantages, bearing in mind the following:

  1. All the machines we have in our company are running on Windows OS but we might migrate to Linux OS in the future.
  2. We are currently working on building a database program that will have several entries with a main server situated at the capital city and data shall be entered from all over the nation.

Is it possible to have it built in a complex script? Can it run on Linux OS should we choose to develop it on windows platform? Thanks in advance for your help.

SHARE
Answered By 55 points N/A #103407

What programs are needed to build a database?

qa-featured

I am a student of computer sciences and I have learned a lot about the database and their softwares. There are a lot of applications that you can use in order to build a database. But the best one out there is the ORACLE database. It comes in various flavours and versions. I currently use the Oracle 9i but it also has the Oracle 10g and 11g. 9i is the most stable one.

Now I will answer your queries specifically here.

1- Oracle 9i is the best candidate for you right now.

2- Yes it can be run both on LINUX and windows. I am currently running it on 3 different computers, one with windows 7 with windows xp installed on VMWARE and running Oracle in windows XP VMWARE. A second one with only windows xp and the last one with LINUX Fedora. All work well, there are just some tweaks file installing it which are very easy to follow.

3- I think that you want to use a Centralized Database system where the server is hosted at one spot and rest of the data comes from different sources. YES, Oracle does support this feature.

4- Yes you can write as much complex script as you can. I would suggest you to develop it on LINUX because unlike windows, LINUX faces less crashes and has more security features than windows

Related Questions