-
DBMS: A software application that allows users to create, store, retrieve, manage, and manipulate data in a structured and organized way.
-
Types of DBMS:
- Relational DBMS (RDBMS): Most common type, stores data in tables with rows and columns. Data is linked between tables using relationships. (e.g., MySQL, Microsoft SQL Server, Oracle Database)
- Object-Oriented DBMS (OODBMS): Stores data and related functionalities like objects in a programming language. Offers advanced features for complex data modeling. (e.g., ObjectStore, GemStone)
- NoSQL DBMS: Designed for handling large and unstructured datasets. More flexible schema compared to RDBMS. (e.g., MongoDB, Cassandra, Couchbase)
- Hierarchical DBMS: Data organized in a tree-like structure with parent-child relationships. Less common today. (e.g., IBM IMS)
Database Structure:
- Field: An individual data point within a record. It represents a specific characteristic or attribute of the entity stored in the database. (e.g., In a customer table, a field could be “Customer Name”, “Email Address”, or “Phone Number”)
- Record: A collection of fields that represents a single entity or instance in the database. It’s like a row in a table containing all the relevant data points about a particular customer, product, or any other entity the table represents.
- Table: A fundamental unit of data storage in a relational database. It’s a structured collection of records with columns (fields) defining the data attributes and rows containing the actual data entries for each record. (Imagine a spreadsheet with rows and columns)
Data Access and Manipulation:
- View: A virtual table based on a query that provides a specific perspective of the underlying data. Views don’t store actual data but offer a customized way to see and interact with subsets of data from one or more tables. (Imagine a filtered view of a customer table showing only customers from a certain location)
- Report: A formatted presentation of data retrieved from the database, often used for summarizing or analyzing information. Reports can be generated from queries and can include calculations, charts, and graphs for better visualization.
- Query: A specific instruction or question posed to the database to retrieve, filter, manipulate, or analyze data. SQL (Structured Query Language) is the most common language used to create and execute queries in relational databases. (e.g., A query might find all customers who placed an order in the last month)
In essence, a DBMS provides the tools to organize data (tables, fields, records), control access (views), and generate meaningful insights from that data (reports, queries). These components work together to efficiently manage and utilize information within a database system.