 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / General DB Topics / General DB Topics / November 2004best "large" database on the net
I have to manage a very large database on a remote server. Wich is the best dbms? Oracle, Ms SQL or what else (obviously not access)? Thanx  Signature-Diego (Atos)- -L'uomo è superiore agli animali- -Fanno eccezione il nano e la giraffa- -A.Bergonzoni- -Per rispondere in privato potare "POTA" dall'indirizzo- Check out Cache' (www.intersystems.com) We offer alternative web application technologies for it that allow very high scalability (www.mgateway.com) >I have to manage a very large database on a remote server. > >Wich is the best dbms? Oracle, Ms SQL or what else (obviously not >access)? > >Thanx --- Rob Tweed M/Gateway Developments Ltd Global DOMination with eXtc : http://www.mgateway.tzo.com --- Centuries ago, Nostradamus foresaw when Diego_Atos <didi_diego@POTAbigfoot.com> would write: > I have to manage a very large database on a remote server. > > Wich is the best dbms? Oracle, Ms SQL or what else (obviously not > access)? You would have to give a great deal more information about the nature of your application for someone to be able to fit it in with their prejudices about which DBMS they might prefer. Signature"cbbrowne","@","acm.org" http://www3.sympatico.ca/cbbrowne/advocacy.html Signs of a Klingon Programmer #3: "By filing this TPR you have challenged the honor of my family. Prepare to die!" > I have to manage a very large database on a remote server. > Wich is the best dbms? Oracle, Ms SQL or what else (obviously not > access)? If you're already using Access, go with SQL Server. It's the most similar, especially as far as SQL language itself, so the skills you have will translate more from Access to SQL Server than to Oracle or InterBase. ( Both of which are better products, but a lot more different than even SQL is. ) Atos, As of Last of year I had seen a comparion by someone with SQL server and Oracle, the conslusion was Oracle is a much more database with the functionalites and worth of money. I have been managing databases over the years and had managed database of Tera byte and it was under oracle. I had worked with SQL/DS , DB2, DL1, Adabas and Oracle database Management system and I can say it with confident that Oracle is much more robust , reliable, scalable and manageble than others. Nisar Tareen > I have to manage a very large database on a remote server. > > Wich is the best dbms? Oracle, Ms SQL or what else (obviously not > access)? > > Thanx Risposta a: Nisar Tareen (ntareen@yahoo.com) _________________ > Atos, > [quoted text clipped - 11 lines] > Nisar Tareen > thanx you all Signature-Diego (Atos)- -L'uomo è superiore agli animali- -Fanno eccezione il nano e la giraffa- -A.Bergonzoni- -Per rispondere in privato potare "POTA" dall'indirizzo- check out Ingres at www.ca.com it does the same as Oracle and its free. > check out Ingres at www.ca.com > > it does the same as Oracle and its free. Oh come on Mike. You know it isn't the same. Its free because no one would buy it. Gee I wonder why? (rhetorical question) >>check out Ingres at www.ca.com >> >>it does the same as Oracle and its free. > > Oh come on Mike. You know it isn't the same. Its free because no one would > buy it. Gee I wonder why? (rhetorical question) So MySQL is free as well, because nobody would buy it? So what can we agree on ? Oracle has a few more check boxes (but I have never needed them) Ingres has been around this long because it works perfectly well. CA made a mistake in taking their time to OpenSource Ingres, but now that they have, people can take full advantage of NOT paying for it. Oracle costs a lot of money. These reasons make Ingres the best large database on the net. Regards Michael Newport The reason that Oracle is the best at large applications, Ingres is free, Informix is semi-retired, and Sybase is now only a niche player is because only Oracle supports row-level locking. > So what can we agree on ? > [quoted text clipped - 11 lines] > Regards > Michael Newport > The reason that Oracle is the best at large applications, Ingres is free, Informix is semi-retired, and Sybase is now > only a niche player is because only Oracle supports row-level locking. Get your facts straight... Sybase ASE and ASA (iAnywhere) both support row-level locking. Sybase has a demonstrated higher TPC benchmarks and a lower TCO than both Oracle and DB2. http://www.sybase.com/content/1019951/ASE1252_DSV2.pdf From a personal perspective, I've developed applications on nearly all major dbms platforms. Sybase is a joy to work with, and Oracle is a complete PITA. SignaturePaul Horan Sr. Architect VCI Springfield, Mass www.vcisolutions.com > The reason that Oracle is the best at large applications, Ingres is > free, Informix is semi-retired, and Sybase is now only a niche player is > because only Oracle supports row-level locking. not true. Ingres also supports row-level locking. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.