Types of DBMS

Database available in Market

What is DBMS?

“A collection of programs that enables you to store, modify, and extract information from  database”.

There are many different types of DBMS, ranging from small systems that run on personal       computers to huge systems that run on mainframes.

DBMS used for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data, and much more. 

The following are examples of database applications:

·         automated teller machines

·         flight reservation systems

·         computerized parts inventory systems

·         computerized library systems

In Simple word: “DBMS is the software or Instance or Tool to access        RDBMS concepts”.

  Database available in Market?

            There are many DBMS are available in market. I am listing top 10 DBMS as follows;

• Oracle Database - 70%
• Microsoft SQL Server - 68%
• MySQL (Oracle Corporation) - 50%
• IBM DB2 - 39%
• IBM Informix - 18%
• SAP Sybase Adaptive Server Enterprise - 15%
• SAP Sybase IQ - 14%
• Teradata - 11%

i) Oracle: Oracle began its journey in 1979 as the first commercially available relational database management system (RDBMS).

ii) SQL SERVER: Microsoft's desktop operating system is everywhere, but if you're running a Microsoft Server, you're likely running SQL Server on it. SQL Server's ease of use, availability and tight Windows operating system integration makes it an easy choice for firms that choose Microsoft products for their enterprises. Currently, Microsoft SQL Server 2008 as the platform for business intelligence solutions.

iii) DB2: Big Blue puts the big into data centers with DB2. DB2 runs on Linux, UNIX, Windows and        mainframes.

IBM released its DB2 (9.7) system squarely in competition with Oracle's 11g, via the International Technology Group, and shows significant cost savings for those that migrate to DB2 from Oracle.

iv) Sybase:  Sybase is still a major force in the enterprise market after 25 years of success and improvements to its Adaptive Server Enterprise product.

Although its market is dwindled for a few years, it's returning with powerful positioning in the next-generation transaction processing space. Sybase has also thrown a considerable amount of weight behind the mobile enterprise. 

v) MySQL:  Oracle's ownership of this popular open source product,

MySQL began as database system for developers but grew into a major contender in the   enterprise database market.

Sold to Sun Microsystems in 2008, MySQL is currently part of the Oracle (January 2010).      MySQL powers commercial websites by the hundreds of thousands and a huge number of internal enterprise applications.

vi) PostgreSQL: PostgreSQL, the world's most advanced open source database, hides in online gaming applications, data center automation suites and domain registries.

It also in some high-profile duties at Skype, Yahoo! and MySpace.

vii) TeraData:     If you've built a large data warehouse in your enterprise, you probably come across about Teradata.

As early as the late 1970s, Teradata was the first data warehouse. It created the first terabyte database for Wal-Mart in 1992. Since that time, data warehousing experts almost say Teradata in the same sentence as enterprise data warehouse.

viii) Informix:  It’s IBM Product available in market.

IBM offers several Informix versions; Limited Developer Edition To Entry-level Express Edition. Low-maintenance online transaction processing (OLTP)

Workgroup Edition To its high-performance OLTP Enterprise Edition.

ix) Ingres:  Ingres is the parent open source project of PostgreSQL and other database systems.

Ingres will lower your total cost of ownership for an enterprise database system. Other than an attractive pricing structure, Ingres has ability to ease your transition from costlier database systems.

“Try to List more Database available in market”