A Database Management System (DBMS) is a set of computer programs that controls the creation, maintenance, and the use of a database. It allows organizations to place control of database development in the hands of database administrators (DBAs) and other specialists. A DBMS is a system software package that helps the use of integrated collection of data records and files known as databases. It allows different user application programs to easily access the same database.
Now, let see the top five open source dbms softwares. Although, Microsoft SQL service is a considerable option but I hate it because of its restrictions and worst of all, it’s a closed source.
1.MySql: MySQL is a relational database management system (RDBMS)[1] that runs as a server providing multi-user access to a number of databases.But it imposes terms on usage of this on a commercial project.MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google and Facebook.
2.Oracle : The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.
3.Apache Derby : Apache Derby is a Java relational database management system that can be embedded in Java programs and used for online transaction processing.It’s database utilities like Derby Network Server,Derby Embedded Database Engine, Embedded Network Server. Considerably good option for networking and also the firm is advancing in cloud computing using this technology.
4.Postgre SQL : PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS). It is released under an MIT-style license and is thus free and open source software. This database suits well for django and turbogears which’re the famous web frameworks. PostgreSql 9 is released last October.
5.SqLite : SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library.SQLite uses a dynamically and weakly typed SQL syntax that does not guarantee the domain integrity, which gives rise to criticism. Unlike client–server database management systems, the SQLite engine has no standalone processes with which the application program communicates. Instead, the SQLite library is linked in and thus becomes an integral part of the application program.
0 comments:
Post a Comment