Title: Database Management Systems Author: Kriko Published: Jun 6, 2023 Last modified: Jul 7, 2026 --- 1. [Home](https://kriko.io/) / 2. [Glossary](https://kriko.io/glossary) / 3. D Letter # Database Management Systems **Database Management Systems**, commonly abbreviated as DBMS, are software systems used to store, organise, manage, query, update and delete data. A DBMS creates a management layer between the database and the users or applications that access it. Through the interfaces and tools provided by these systems, large volumes of [data](https://kriko.io/services/data-analysis-insight) can be managed in a more organised, secure and efficient manner. In relational database management systems, one of the most widely used query languages is **SQL**, which stands for Structured Query Language. Rather than being a general- purpose programming language, SQL is a domain-specific language designed for working with relational databases. SQL commands can be used to retrieve records, insert new [data](https://kriko.io/services/data-analysis-insight), update existing information and delete unnecessary entries. [Data](https://kriko.io/services/data-analysis-insight) security is another core function of database management systems. Methods such as user authentication, role- based authorisation, access controls, encryption and activity logging help prevent unauthorised access, use or modification of data. DBMS platforms also use various optimisation methods to improve database performance. For example, **indexing** enables specific records to be located more quickly and helps queries run more efficiently. Query optimisation, caching and resource management can also support overall system performance. Database management systems are used across many industries. In e-commerce, they can store and manage product information, inventory levels, order records, payment details and customer profiles. In healthcare, databases may be used to manage patient records and appointment information. Financial institutions use them for account activity and transaction records, while educational organisations use them to manage student [data](https://kriko.io/services/data-analysis-insight), course information and academic results. Research institutions, government organisations, logistics companies, media platforms and telecommunications providers also rely on DBMS solutions to organise large volumes of information. MySQL, PostgreSQL, Microsoft SQL Server, Oracle Database and IBM Db2 are among the most widely used relational database management systems. Open-source solutions such as MySQL and PostgreSQL are frequently selected because of their broad community support and ability to integrate with different applications. A **database** is an organised collection of related information. A database management system is the software layer that controls how this information is stored, accessed, protected and processed. A properly structured database can help organisations retrieve information more quickly, improve operational processes and make better-informed decisions. In the media and entertainment industry, for example, databases may be used to store and manage films, music, games, user preferences and content engagement data. ## Discover it in the dictionary ### Net Promoter Score (NPS) Net Promoter Score, commonly abbreviated as NPS, is a customer experience metric used to measure how likely customers are to recommend a brand, product… ### Churn Rate Churn Rate is an important customer metric that shows the percentage of customers a business loses within a specific period. It is calculated based… ### Business to Business (B2B) Business to Business, commonly abbreviated as B2B, is a business model in which companies offer their products or services to other companies. In this… ### Augmented Reality Augmented Reality, commonly abbreviated as AR, is a technology that enriches the real-world environment with digital layers such as visuals, sound, text, animation, 3D… ### Call to Action A Call to Action, commonly abbreviated as CTA, is a message, button, link or directional element used to guide users toward a specific action.… ### Pattern Recognition Pattern recognition is a field of machine learning concerned with identifying, analysing and interpreting recurring structures within data. It enables computer systems to detect… ### Metadata Metadata is information used to describe, explain and provide context for other data. It can contain details about a data source's content, structure, origin,… ### Demand Forecasting Demand forecasting is the process of estimating future demand for a product or service by using data, assumptions and analytical methods. Businesses use this… ### Meta Description Meta description is an HTML element that briefly summarises the content of a web page. It usually appears as the short description text below… ## Track the digital heartbeat with Kriko Subscribe to receive curated insights, news, and ideas shaping the digital landscape. By checking this box, you acknowledge and accept our [privacy policy](https://kriko.io/privacy-policy).