Updating hardware information database
A database-management system (DBMS) is a computer-software application that interacts with end-users, other applications, and the database itself to capture and analyze data.
A database is not generally portable across different DBMSs, 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.DBMS may become a complex software system and its development typically requires thousands of human years of development effort.Some general-purpose DBMSs such as Adabas, Oracle and DB2 have been upgraded since the 1970s.This article is concerned only with databases where the size and usage requirements necessitate use of a database management system.Physically, database servers are dedicated computers that hold the actual databases and run only the DBMS and related software.Databases and DBMSs can be categorized according to the database model(s) that they support (such as relational or XML), the type(s) of computer they run on (from a server cluster to a mobile phone), the query language(s) used to access the database (such as SQL or XQuery), and their internal engineering, which affects performance, scalability, resilience, and security.
Databases are used to support internal operations of organizations and to underpin online interactions with customers and suppliers (see Enterprise software).
Because of the close relationship between them, the term "database" is often used casually to refer to both a database and the DBMS used to manipulate it.
Outside the world of professional information technology, the term database is often used to refer to any collection of related data (such as a spreadsheet or a card index).
General-purpose DBMSs aim to meet the needs of as many applications as possible, which adds to the complexity.
However, since their development cost can be spread over a large number of users, they are often the most cost-effective approach.
A relational database, more restrictively, is a collection of schemas, tables, queries, reports, views, and other elements.