APPROACHES OF DBMS AND RDBMS
Introduction of DBMS and RDBMS
A database management system (DBMS) is a software application that helps users to create, maintain, and use databases here data stored in file. A relational database management system (RDBMS) is a type of DBMS that stores data in tables called schema.
A practical approach of DBMS
- Modeling : The first step in any DBMS project is to model the data that will be stored in the database. This involves identifying the entities, attributes, and relationships between the data.
- Design : Once the data has been modeled, the next step is to design the database. This involves creating the tables, indexes, and constraints that will be used to store the data.
- Programming : SQL is the language used to interact with databases. It is important to learn how to use SQL to create, modify, and query databases.
- Database administration : Database administrators are responsible for the day-to-day operations of a database. This includes tasks such as backup, recovery, and security.
- Performance tuning : Databases can become slow over time as they grow in size. It is important to perform regular performance tuning to ensure that the database is running efficiently.
Data Models of DBMS
- Entity-Relationship Model
The entity-relationship (ER) model is a data modeling technique that is used to represent the structure of a database. It is a high-level conceptual model that does not consider physical implementation details.
The ER model is based on three basic concepts that are Entity, attributes and Relationship.
Example : Boy (name, address, phone) Ice cream(manufacturer, flavor, Price).
2. Relational Model
The relational model is a data model that represents data as a collection of tables. Each table consists of rows and columns, where the rows represent tuples and the columns represent attributes. The relational model is the most popular data model for database management systems (DBMSs).
The concept of Relational model Relation ,Tuple, Attribute, Domain, Relational schema, Relational instance.
A Modern Approach of RDBMS
- Scalability : RDBMSs need to be able to scale to handle large amounts of data and concurrent users. This can be done by using a distributed database architecture or by using a cloud-based database service.
- Performance : RDBMSs need to be able to perform queries quickly and efficiently. This can be done by using indexes, partitioning, and other performance tuning techniques.
- Security : RDBMSs need to be able to protect the data in a database from unauthorized access. This can be done by using encryption, firewalls, and other security measures.
- Flexibility : RDBMSs need to be able to handle a variety of data types and structures. This can be done by using a flexible data model and by providing support for advanced features such as object-relational mapping (ORM).
- Interoperability : RDBMSs need to be able to interoperate with other systems. This can be done by using standard protocols such as SQL and JDBC.