Databases In SQL
The software used to store, manage, query, and retrieve data stored in a relational database is called a relational database management system (RDBMS). The RDBMS provides an interface between users and applications and the database, as well as administrative functions for managing data storage, access, and performance.
There are many popular RDBMS available to work with. This blog gives a brief overview of some of the most popular RDBMS’s. This would help you to compare their basic features.
MySQL is an open source SQL database, which is developed by a Swedish company MySQL AB.
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 (non-commercial/commercial) and features.
MySQL comes with a very fast, multi-threaded, multi-user and robust SQL database server.
Features of MySQL
Scalability and Flexibility Run anything.
Robust Transactional Support.
Web and Data Warehouse Strengths.
Strong Data Protection.
Comprehensive Application Development.
Open Source Freedom and 24 x 7 Support.
Lowest Total Cost of Ownership.
MS SQL Server
MS SQL Server is a Relational Database Management System developed by Microsoft Inc. Its primary query languages are
Row version-based isolation levels
It is a very large multi-user based database management system.
Oracle is a relational database management system developed by ‘Oracle Corporation’.
Oracle works to efficiently manage its resources, a database of information among the multiple clients requesting and sending data in the network.
It is an excellent database server choice for client/server computing.
Oracle supports all major operating systems for both clients and servers, including MSDOS, NetWare, UnixWare, OS/2 and most UNIX flavors.
This 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 uses the Jet database engine, which utilizes a specific SQL language dialect (sometimes referred to as Jet SQL).
MS Access comes with the professional edition of MS Office package.
MS Access has easyto-use intuitive graphical interface.
Users can create tables, queries, forms and reports and connect them together with macros.
Option of importing and exporting the data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc.
There is also the Jet Database format (MDB or ACCDB in Access 2007), which can contain the application and data in one file.
This makes it very convenient to distribute the entire application to another user, who can run it in disconnected environments.
Microsoft Access offers parameterized queries.
These queries and Access tables can be referenced from other programs like VB6 and .NET through DAO or ADO.
The desktop editions of Microsoft SQL Server can be used with Access as an alternative to the Jet Database Engine.