smartidiot

First of all, SQL is not a DBMS. It's a language for DBMS, abbreviation of Structured Query Language. If you are planning to use it for a web application then I would suggest MySQL with PHP as server side language. You can use Zend if you are really looking for a large scale application. Oracle is also an option but its not free and for web apps, MySQL is as good as Oracle and is free of cost. Even if cost is not an issue, I would prefer using MySQL.

Yahoo is possible the largest and most popular site on Internet. It's also built using PHP and MySQL. And there is no doubt that your site is going to be bigger than Yahoo ...

Jenniferlinn

SQL is not database, it is query language, MySQL and Oracle are databases and you can chhose any of them depending upon your requirement. Here are intro of both RDBMS:

What is MySQL?

MySQL is a database.

The data in MySQL is stored in database objects called tables.

A table is a collections of related data entries and it consists of columns and rows.

MySQL is a relational database management system (RDBMS)[1] which has more than 11 million installations.[2] The program runs as a server providing multi-user access to a number of databases.

MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now a subsidiary of Sun Microsystems,[3] which holds the copyright to most of the codebase. The project's source code is available under terms of the GNU General Public License, as well as under a variety of proprietary agreements.

The Oracle Database (commonly referred to as Oracle RDBMS or simply Oracle) consists of a relational database management system (RDBMS) produced and marketed by Oracle Corporation. As of 2008[update], Oracle had become a major presence in database computing.

Larry Ellison and his friends and former co-workers Bob Miner and Ed Oates started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex.

nimtree

In terms of scalability , I would say Oracle is the best database. Its grid computing is superb!!

I am an Oracle certified professional and also have used other databases however Oracle is superb. Oracle is moving from traditional databases to ERP systems very fast.

seo services uk

seo services glasgow

melina386

* Sometimes it's because their boss tells them that they need to make data more secure. Developers at the Veteran's Administration are probably doing that as we speak and so are lots of other shops big and small dealing with government-mandated security constraints or the results of a hacked data store.
* Perhaps the existing data storage system has exceeded its capacity or the capacity of the system to support it. This could mean the database can't store the volume of data, can't support the number of users trying to access it, or the company has run out of places to store the 3x5 card boxes. This might also mean that the application or database is so poorly designed that no amount of upgrading or tuning can cure its ills.
* Sometimes they need to choose a way to share data among co-workers or to publish data in a way that's not only secure but easily implemented with the existing infrastructure. Increasingly, companies are finding new requirements to share data or simply expose it to their customers or the public. Once a useful database is created, it can spread uncontrollably like a virus or a video on YouTube. That's the downside of data sharing.
* Perhaps the data source has changed or a new source of data has been introduced that does not work with the existing system. Data import and export issues are a perennial problem often introduced as companies and departments merge. Many developers spend much of their bandwidth writing import/export/transform utilities simply to move data from place to place.
* Sometimes the choice of a data storage system is a function of long-term study, skill, experience, or simply ignorance. All too often, you hear about people (and companies) that choose their DBMS because that's the engine they know—or it's the one chosen by the CEO's son-in-law. When choosing any tool or DBMS engine, developers, consultants, managers, and relatives all need to make an effort to understand the strengths and weaknesses of all the alternatives.

Data Entry India

freezea

How to choose the best database management system software is an interesting problem and it takes on many different forms. For example, should I answer it based on you having no existing DBMS and you're just looking to buy one for the first time? That is a valid, though not too common, situation. On the other hand, you are more likely asking something like "Which of the several different DBMS platforms that we already have should we use for Project X?" This is also a valid question. So, let me answer both for you.

First of all, if you are brand new to DBMS it would be a very wise course of action to hire a database consultant (or two) to help you with your selection process. There are several very good choices out there. My preference is that new users should generally choose from the market leaders, and that means one of the big three: IBM's DB2, Oracle, or Microsoft SQL Server. Of course, you also have other options such as an open source DBMS like MySQL or PostgreSQL. These are up-and-coming platforms and they can be used for some types of production work (mostly lower-end or simpler web-based development projects). For high-end mission-critical applications, stick with the Big Three.

OK, which of the big three? Well, if you are a large organization with a mainframe and want to run your DBMS on that mainframe, you really should go with IBM DB2. Oracle has a mainframe version of their database server, but IBM is far and away the market leader here. For Unix and Linux installations, your choices are Oracle and DB2. Oracle is the market leader on those platforms, though IBM has a nice presence there, too. For Windows development, all three are viable options, but Microsoft is obviously the leader.

What about other options? Well, Sybase, Informix, and Teradata are the next biggest players in the market. Sybase has lost ground in the market, but their DBMS is still solid and they are firmly entrenched in the financial market. Informix was purchased by IBM and it is still being maintained, but DB2 is obviously IBM's primary DBMS – so I personally would not choose it for new work. Teradata is a high-speed DBMS that is geared for data warehousing and OLAP work and you might want to choose it for those types of projects.

Finally, what if you have several DBMSs installed and need to choose one for a new project? In that case, it is best to base your decision on internal company issues. Consider the existing support and expertise that you have in-house for each DBMS. If the project is highly visible it makes sense to go with the DBMS that is best supported by your in-house experts because they can give it the care and feeding it needs to perform optimally. Also, think about the hardware platform. For your very high availability needs go with the mainframe if you have one. After that, it is Linux and Unix… then Windows.

Ankit87

Oracle is the best database...

Golem911

Thanks to all

nice123

I believe by SQL you mean SQL Server.
The best database is still Oracle, but you can go nicely with MySQL until your database size and number of transaction exceed some limit.

pradeep

Of course Oracle is very useful one..