what is the best RDBMS system?
100322
Oracle is in my opinion the best RDBMS. But I am also a big MySQL fan. If needed one can also try DB2.\nIMHO Ms Access and SQL server are not the best of products for organisations to adopt.
206160
My guess is MySQL from looking at the front page of mysql.com.  I doubt they have only 1 solution for their entire company though.
887001
Oracle - and Microsoft's SQL Server - are good for large scale (think web based or Wide-Area-Network) database applications.  Access is good for SMALL scale - single computer, or very small, local area network database applications.  Also, an Access database can't have very many users logged in at the same time.  SQL Server and Oracle can have lots of users logged in at once.
1031966
Oracle\nDb2\nSQL Server \nSybase\nNCR Tera data/ PostGres\n\n\nand then you have MySQL too
227104
Microsoft Access might be a nice choice to start.  If you decide to go to something else, the database file itself can be easily converted to another database program, and it is compatible with SQL and ODBC
484774
Query the RDBMS's internal schema for that information. Also can check data types using regex on values, as well as defining meta-data for test you want to run, and a utility script to use it against defined tables.  (If the database is set up correctly, you shouldn't experience anomalies in the first place.)
350481
If you want to keeps your costs low.  Then you'll probably be using PHP and MySQL, or possibly Postgres.  The last two are the database programs to store your data.
775862
A version of MySQL is available for Windows, and it rocks\n\nEdit:\nAll the info for downloading and installing is here:\nhttp://dev.mysql.com/doc/refman/5.0/en/windows-installation.html
70564
http://dev.mysql.com/doc/refman/5.0/en/sql-syntax.html\nYour best bet is to Start with MySQL, which is an Open Source Implementation, then learn SQL and then Database Design, and shortly after you will be a full fledged DBA
580927
Well, usually depends on what type of hosting solution you have. If the host is ran on a unix/linux box, you will often find MySQL installed. If it is a windows solution, you usually find MS SQL Server.\n\nHere are some advantages of both...\n\n1) MySQL is usually very fast database because it is strongly based on an index lookup type of structure. \n\n2) Works great with languages like PHP which I highly recommend you use for a website.\n\n3) Very memory efficient and takes less space to run on a server (usually).\n\n\nMS SQL Server\n\n1) Integrates well with other Microsoft products. If you have an all microsoft hosting solution going, you will probably want SQL Server.\n\n2) It allows the use of Stored Procedures which allows you to execute groups of commands on the server independent of user activity.\n\n3) Some of the later versions also offer great reporting utilities and statistics.\n\n\nBut this is all usually dependent on what you are running for an Operating system on the host. PHP and MySQL are great for unix/linux systems and ASP/MS SQL Server is good for windows environments.\n\nEven though you will find people on here leaning one way or the other, it all really depends on what you are looking for out of your website. Generally unix/linux is more stable but a bit harder for newbies to use and windows uses a lot of resources and less stable, but easier for newbies to use and understand.\n\nI hope I have made things a bit more clear for you.
87947
There are several options for a database here.  The three off the top of my head are MySQL, PostgreSQL, and Oracle.  MySQL (http://dev.mysql.com/) and PostgreSQL (http://www.postgresql.org/) are open source and are freely available.  Oracle allows developers to download their database for free for developing your applications, but you must pay for it when you deploy your application.  Of the three I would recommend MySQL on the Windows platform.  Setting up PostgreSQL on Windows was much less simple, though that may have changed since I last tried (about a year and a half ago).  All 3 offer JDBC drivers that you will need for Java servlets to connect.\n\nBy the way what are you using for your servlet container?  If you haven't already chosen one, you might consider Tomcat (http://tomcat.apache.org/).  It is one of the most popular, so there is plenty of information available out there.
81
Define "best". Oracle is like a BMW. Expensive but has all the fixings. But not everyone needs a BMW. MySQL is like a VW Beetle (the old model). Its cheap, and gets you where you need to go. But you have to tweak it to suit your needs.
723480
The main database vendors in Microsoft, Oracle and IBM all now have a free express version of the database that can be downloaded and installed on a windows desktop.  I suggest you download and try it out for yourself.  It is difficult to get an independant opinion on the difference between each database as people will prefer the ones they are familiar with.\n\nAll three database types have relational tables, a simple SQL language, common objects such as procedures, indexes and triggers.  \n\nSQL Server used to be easier to install and administer but over time the three express versions are becoming easier to run so it is hard to seperate them.
668500
1. PHP/Mysql is good combination for your forum\n2. You try the best resources below also if they suit you these are php/mysql based strong
78843
Goto borland.com or oracle.com and look at the success stories link. It tells you which customers are using what systems to get their IT infrastructure going.
325354
MySQL is the easiest to install and use which uses a client-server architecture.  It runs on windows and Unix-derivitives such as Linux.  It is also extremely fast and blows the pants off of SQL Server.\n\nMicrosoft SQL Server is a good choice for an enterprise-level windows database.  You will need very good hardware to get good performance from SQL Server.\n\nOracle is overpriced and very complex.  It's powerful, but convoluted and takes a lot of skill to manage properly.\n\nOthers to look at include Postgres (like MySQL but not as widely used),  IBM DB2, Sybase, Interbase (Borland)
143941
1) Oracle has a program call SQL Loader that loads tables from external data.  You can write a module in Access to create a flat fiel from your data and put it in a form where SQL Loader understands.\n\n2) A solution that works with almost any RDBMS is to write a module in Access to create SQL Insert statement for each record in your Access table, and write them to a file.  Then, using the RDBMS's batch execution engine (SQL PLus for Oracle, OSQL for SQL Server, MySQL command prompt, etc, ISQL for Sybase, etc), simply create yout table and run those insert statements.\n\nAn example of 2) would be ...\n\nFunction doIt()\n\nDim rs As Recordset\n\nSet rs = CurrentDb.OpenRecordset("Select f1, f2 from t1;")\nOpen "c:&#92;statements.sql" For Output As #1\nWhile Not rs.EOF\n    Print #1, "Insert into T1 (F1, F2) values ('" & rs("f1") & "', '" & rs("f2") & ")';"\n    rs.MoveNext\nWend\nClose\nrs.Close\n\nEnd Function