Database Processing and DBMS Functions

Database Processing

• DBMS provides a set of functions to manage data, including:
  • Insert
  • Update
  • Delete
  • Search/View

Functions of DBMS

• Defining a database:
  • Specifying data types, structures, and constraints
  • Constructing the database
• Manipulating a database:
  • Querying the database to retrieve specific data
  • Updating the database to reflect changes
  • Generating reports from the data
• Sharing a database:
  • Allowing multiple users to access the database
• Protecting the database:
  • System protection against hardware or software malfunction
  • Security protection against unauthorized or malicious access
• Maintaining the database system:
  • Evolving the system as requirements change over time

Database Users

• Database Administrators:
  • Administering resources such as database, DBMS, and related software
• Database Designers:
  • Identifying data to be stored in the database
  • Choosing appropriate structures to represent and store data
• End users:
  • Accessing the database for querying, updating, and generating reports
• System Analysts and Application Programmers (Software Engineers):
  • Determining the requirements of end users and developing specifications
  • Implementing these specifications as programs

Advantages of DBMS

• Controlling redundancy
• Improving data consistency
• Restricting unauthorized access
• Sharing of data
• Providing multiple user interfaces
• Representing complex relationships among data
• Enforcing standards and integrity constraints
• Providing backup and recovery
• Increasing concurrency

Disadvantages of DBMS

• Complexity
• Cost of DBMS
• Additional hardware costs
• Cost of conversion
• Performance
• Higher impact of failures

Classification of DBMS

• According to the data model:
  • Relational Model
  • Network Model
  • Hierarchical Model
  • Object Data Model
  • Object-relational Model
• According to the number of users:
  • Single user Systems
  • Multi-user Systems
• According to the distribution:
  • Centralized DBMS
  • Distributed DBMS

Characteristics of Database System

• Real World Entity:
  • Using real-world entities to design databases
• Self-Describing Nature:
  • A DBMS should be self-describing, containing the database and metadata
• Support ACID Properties:
  • Accuracy, Completeness, Isolation, and Durability
• Concurrent Use of Database:
  • Multiple users can access the data at the same time
• Insulation Between Data and Program:
  • Changes in data do not affect application software
• Transactions:
  • Only completed or uncompleted
• Data Persistency:
  • Data is protected from system failure
• Backup and Recovery:
  • Enables more effectiveness
• Data integrity:
  • Protects unauthorized access and ensures data quality
• Multiple Views:
  • Users can have multiple views of the database depending on their department and interest
• Store any kind of data:
  • Any kind of data can be stored in DBMS
• Security:
  • Provides different rights to access the database
• Represent complex relationships between data:
  • Able to represent complex relationships between data for efficient and accurate use

Learn about the functions of a Database Management System (DBMS) including defining, constructing, and managing a database. Understand the different operations that can be performed on a database.