N/APosted on - 01/21/2012
Can someone please tell me the programs needed to build a database together with their advantages and disadvantages, bearing in mind the following:
All the machines we have in our company are running on Windows OS but we might migrate to Linux OS in the future.
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.
What programs are needed to build a database?
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