I have problem in choosing a data base working with open source linux
Hi,
I have to choose an open source data base to work with it on Linux, but I have many criteria, first it must be open source, and stable working, which accept a great amount of data going untill 500 table, which works with sql and jdbc and of course with GNU/Linux. is there any one who have an idea about what i search, I was thinking in MySql, Ingrs and Postgresql what do you think about these program, are they compatible with what i search, are they stable and accept a big charge? |
I can vouch for postgres, have seen ingres (commercial version) work reasonably
well, and personally stay clear from MySQL (even though some will argue that it qualifies). Cheers, Tink |
Quote:
for now your parameters are : open source sql interface jdbc connectivity i would need to know where you want to run it, how much data you want to put in and out - what's the profile of the application - dss, oltp etc. is it a distributed env, how many clients will be connected etc. in other words - the more details you give, the more qualified answer you will expect to receive. good luck |
Don't know if it'll help you but I run multiple data bases with MySQL with no problems. One of these is roughly 50 tables where about 90% of them contain upwards of 10 million rows (a few over 40 million rows) and I've found query performance more than acceptable even with multi-table joins and the like. I also run GIS data bases with upwards of 20 million rows in tables and have no complaints there either. I have found MySQL to be robust, reliable and efficient. And, combined with Apache and PHP, well, no complaints on either Linux or Solaris (SPARC) platforms.
|
Hello
I believe that it misses some details and this what I have to add, i need to argument my choice: The database will work with a java program the load is very hight it is biger than one hundred user and more. the size will be very hight, because it will work for at least 3 years, so maybe it will reach many GO. Sure it will work under Linux and we don't care for the distribution. I don't know with which machines they will work. I know that Ingres can do this, but is it the best to do this, I knew that there is other open source data base like: Postgresql, FireBird Entreprise DB and if there is other choice with resonable argument it will be welcome. So I am waiting for your help freinds. for any specific details, do not hesitate |
You're not really asking for anything specific, still.
Go to each RDBMs web-site and check out the testimonies of people who use them? http://www.postgresql.org/about/casestudies/ http://www.postgresqlfr.org/?q=node/1538 Cheers, Tink |
Postgresql and Mysql are each quite fine products. Each of them will handle large databases without flinching. You might find that Mysql will be a bit easier to administer. You might check to see with a Google person to verify their table sizes. Google and Nasa use Mysql significantly. 100 users does not sound like a very large number. Good luck with your exploration.
|
All times are GMT -5. The time now is 03:55 AM. |