SQL Databases
SQL RDBMS Databases
In this tutorila we discuss - what is databases? How many types of databases are there? There are many popular Relational Database Management System available to work with.
- MySQL Database
- MS SQL Server
- Oracle Database
- MS Access
MySQL Database
MySQL was developed by Michael Widenius and David Axmark in 1994. Presently MySQL is maintained by Oracle. MySQL is an open source SQL database, which is developed by a Swedish company – MySQL AB. MySQL is pronounced as "my ess-que-ell," in contrast with SQL, pronounced "sequel."
MySQL Features
- MySQL is supporting many different platforms including Microsoft Windows, the major Linux distributions, UNIX, and Mac OS X.
- MySQL has free and paid versions, depending on its usage commercial / non-commercial and features.
- MySQL comes with a very fast, multi-threaded, multi-user and robust SQL database server.
- High Performance, High Availability, Scalability and Flexibility Run anything, Robust Transactional Support, Web and Data Warehouse Strengths & Strong Data Protection.
MySQL Version Released
| VERSION |
DATE |
| First internal release |
23rd May 1995 |
| Windows Version was released |
8th January 1998 |
| Version 3.23: beta |
June 2000, production release January 2001 |
| Version 4.0: beta |
August 2002, production release March 2003 |
| Version 4.01: beta |
August 2003 |
| Version 4.1: beta |
June 2004, production release October 2004 |
| Version 5.0: beta |
March 2005, production release October 2005 |
| MySQL AB |
26th February 2008 |
| Version 5.1 |
27th November 2008 |
MySQL supported third party tools
- Drivers - ODBC, JDBC, .NET and C++
- Languages - C, C++, C#, Java, Delphi, Visual Basic, Perl, Python and PHP
- Tools - Microsoft Visual Studio, Borland Delphi and JBuilder, Eclipse and NetBeans
MS SQL Server
MS SQL Server is a Relational Database Management System developed by Microsoft Inc. Its primary query languages are T-SQL, ANSI SQL
MS SQL Version Released
| VERSION |
DATE |
| Sybase releases SQL Server for UNIX |
1987 |
| Microsoft, Sybase, and Aston-Tate port SQL Server to OS/2 |
1988 |
| SQL Server 1.0 for OS/2 |
1989 |
| SQL Server 1.1 is released with support for Windows 3.0 clients |
1990 |
| SQL Server 2000 |
2000 |
| XML for SQL Server Web |
2001 |
| SQLXML 2.0 / SQLXML 3.0 |
2002 |
| SQL Server 2005 |
2005 |
Oracle
Oracle is a relational database management system developed by 'Oracle Corporation'. Oracle supports all major operating systems for both clients and servers, including MSDOS, NetWare, UnixWare, OS/2 and most UNIX flavors.
Oracle Version Released
| VERSION |
DATE |
| Oracle began |
1977 |
| Version 2.0 |
1979 |
| Oracle released version 3.0 |
1983 |
| Oracle version 4.0 was released |
1984 |
| Oracle released Oracle11g |
2007 |
Oracle Features
- Oracle is an excellent database server choice for client/server computing.
- Oracle works to efficiently manage its resources, a database of information among the multiple clients requesting and sending data in the network.
- Quiesce Database, Portability, Self-managing database, SQL*Plus, ASM, Scheduler, Resource Manager, Data Warehousing, Materialized views, Bitmap indexes, Table compression etc.
MS Access
MS Access means that Micrsoft Access; it is one of the most popular Microsoft products. Microsoft Access is an entry-level database management software. MS Access database is not only inexpensive but also a powerful database for small-scale projects.
MS Access Features
- Importing and exporting the data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc.
- Users can create tables, queries, forms and reports and connect them together with macros.