SQL Database

A database is object within DBMS software like MS Sql Server or My Sql or Oracle which is used to store data and accessed by an application or any electronic devices. In this chapter we will discuss about few database management system like MS Sql Server, My Sql, Microsoft Access, Oracle etc...

MS Sql Server:

Microsoft SQL Server is a relational database management system developed by Microsoft. MS Sql server is a software product which is widely used to store and retrieve data as per our request or our applications request. MS Sql server you can install in your local machine and use it for your local application and also you may use it for your live application on internet.

There are many different version available like MS Sql 2005, MS Sql 2008, MS Sql 2012, MS Sql Server 2014, MS Sql Server 2015, MS Sql 2016, MS Sql Server 2017 etc...

MS Sql server is primarily use two languages for SQL query. One is T-SQl and another is ANSI-SQL. We will learn about them in upcoming chapters in more details.

Sql server was first time launched by “Sybase” for Unix operating system in 1987. Then later in 1988, few more companies like Microsoft, Sybase released it for OS/2. There was another who joined later is Astone-Tat to release SQL server 1.o version along with Microsoft and Sybase in 1989.

In 1990 they released SQL server 1.1 for Window 3.0 client. From this release, Aston-Tat finally leave from development server. They are no longer works with Microsoft and Sybase for Sql Server upgrades.

Then later Microsoft has released few more versions of MS Sql Server like MS Sql 2000, MS Sql 2001(SQLXML), MS Sql Server 2002(SQLXML),MS Sql 2005, MS Sql 2008, MS Sql 2012, MS Sql Server 2014, MS Sql Server 2015, MS Sql Server 2016 and MS Sql 2017(Latest).

Note: Microsoft Sql Server database is widely used in .Net technologies now days because, in .Net technologies there are so many packages inbuilt available which support easily and integrated with MS Sql server as well.

Functionality:

  • Data storage, retrieval and update
  • Better Performance
  • Data Protections
  • Service Broker
  • User accessible catalog or data dictionary describing the metadata
  • Support for transactions and concurrency
  • Facilities for recovering the database should it become damaged
  • Support for authorization of access and update of data
  • Access support from remote locations
  • Mail and XML Integration
  • Enforcing constraints to ensure data in the database abides by certain rules

View history of MS Sql Server

Microsoft Access

Microsoft Access is also software product which is developed by Microsoft. It’s also known as MS Access which is available to use in MS Office software. MS Access is widely used by small companies as its small system but yet powerful database to store data and retrieve it and also it’s not an expensive product like MS Sql Server software product from Microsoft.

Microsoft Access is very easy to learn for developer because they provide clean interface to create tables and write queries to manage our data.

MS Access it rely on Jet database engine, it’s also known as Jet Sql because it use different Sql language. In 1992, Microsoft Access was released first time with version 1.0. Later Access 1.1 launched in 1993 and Access 97 launched in 2000.

Latest version of MS Access is 2007 which is available in MS Office 2007 software package with better graphical interface and few more features like ACCDB(Very useful to store attachments and complex data types).

Functionality:

  • Easy integration with other applications like Outlook, MS Sql Server, Oracle, Excel etc...
  • Powerful Macro feature to objects each other (Tables, Forma, Queries, Reports etc...)
  • Use database file to disconnected system or environments easily.
  • Easy integration with .net technologies and VB as well.
  • Faster access because application and database work on same platform, they doesn’t work like client and server connecting option.

My Sql

My Sql database management system is widely used in many open source technologies like PHP, Wordpress, Java etc... Mainly it run on Linux operating system but it’s also used in Window and Unix platforms.

My Sql is developed by company “MySQL AB”.

Paid version is also available for MySql which is widely used for commercial purpose. Free version is mostly used by small websites and mobile application development. My Sql is free but yet its very powerful and robust database server.

Michael Widenius and David Axmark started development of My Sql database system in 1994 first time. Later in 1995, they have released its first version which is 1.0. Later again, in 1998 they ahve released My Sql for Window server with operating system NT and Window 98.

In 2001, My Sql 3.23 launched and My Sql version 4.0 launched in 2003. My Sql 4.1 in 2004 and My Sql 5.0 in 2005 released.

MySql is acquired by Sun Microsystem later in 2008 and they have launched My Sql version 5.1 in later 2008.

Functionality:

  • Data storage, retrieval and update
  • User accessible catalog or data dictionary describing the metadata
  • Support for transactions and concurrency
  • Data Protection
  • Open Source
  • Facilities for recovering the database should it become damaged
  • Support for authorization of access and update of data
  • Access support from remote locations
  • Better cost and powerful performance
  • Enforcing constraints to ensure data in the database abides by certain rules