20-09-2017, 04:01 PM
A database is an organized collection of data. It is a collection of schemas, tables, queries, reports, views and other objects. Database designers typically organize data to model aspects of reality in a way that supports processes that require information, such as modeling the availability of rooms in hotels in a way that supports the search for a hotel with vacancies.
A database management system (DBMS) is a computer application that interacts with end users, other applications and the database itself to capture and analyze data. A general-purpose DBMS allows the definition, creation, query, update and administration of databases. The most popular DBMSs include MySQL, PostgreSQL, EnterpriseDB, MongoDB, MariaDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA, MemSQL, SQLite and IBM DB2.
A database is generally not portable through different DBMS, but different DBMSs can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Computer scientists can classify database management systems according to the database models they support; the most popular database systems since the 1980s have supported the relational model - generally associated with the SQL language. Sometimes a DBMS is known loosely as a "database".
A database management system (DBMS) is a computer application that interacts with end users, other applications and the database itself to capture and analyze data. A general-purpose DBMS allows the definition, creation, query, update and administration of databases. The most popular DBMSs include MySQL, PostgreSQL, EnterpriseDB, MongoDB, MariaDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA, MemSQL, SQLite and IBM DB2.
A database is generally not portable through different DBMS, but different DBMSs can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Computer scientists can classify database management systems according to the database models they support; the most popular database systems since the 1980s have supported the relational model - generally associated with the SQL language. Sometimes a DBMS is known loosely as a "database".