- Trending Categories
- Data Structure
- Operating System
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What are the different phases of database development Life cycle (DBMS)?
The different phases of database development life cycle (DDLC) in the Database Management System (DBMS) are explained below −
Evaluation and selection.
Logical database design.
Physical database design.
Testing and performance tuning.
Now, let us understand these phases one by one.
The most important step in implementing a database system is to find out what is needed i.e what type of a database is required for the business organization, daily volume of data, how much data needs to be stored in the master files etc.
In order to collect all this information, a database analyst spends a lot of time within the business organization talking to people, end users and getting acquainted with the day-to-day process.
In this phase the database designers will make a decision on the database model that perfectly suits the organization’s requirement. The database designers will study the documents prepared by the analysis in the requirement analysis stage and then start development of a system model that fulfils the needs.
Evaluation and selection
In this phase, we evaluate the diverse database management systems and choose the one which perfectly suits the requirements of the organization.
In order to identify the best performing database, end users should be involved.
Logical database design
Once the evaluation and selection phase is completed successfully, the next step is logical database design.
This design is translated into internal model which includes mapping of all objects i.e design of tables, indexes, views, transaction, access privileges etc.,
Physical Database Design
This phase selects and characterizes the data storage and data access of the database.
The data storage depends on the type of devices supported by the hardware, the data access methods.
Physical design is very vital because of bad design which results in poor performance.
Database implementation needs the formation of special storage related constructs.
These constructs consist of storage groups, table spaces, data files, tables etc.
Once the database has been created, the data must be loaded into the database.
The data required to be converted, if the loaded date is in a different format.
In this phase, the database is accessed by the end users and application programs.
This stage includes adding of new data, modifying existing data and deletion of absolute data.
This phase provides useful information and helps management to make a business decision.
It is one of the ongoing phases in DDLC.
The major tasks included are database backup and recovery, access management, hardware maintenance etc.
- What are the phases of Software Development Life Cycle (SDLC)?
- Life Cycle Phases of Data Analytics
- Project Management Life Cycle Phases
- Software Testing Life Cycle (STLC) Phases
- Security System Development Life Cycle
- Database Life Cycle
- Bug Life Cycle in Software Development
- Robotic Process Automation Development Life Cycle (RDLC)
- Different Participants of Defect Life Cycle
- Comparison of different Life Cycle Models
- What are the Different Phases of a Compiler?
- Explain the stages and their examples of database development lifecycle (DBMS)?
- What are the different types of DBMS?
- Project Life Cycle Vs. Product Life Cycle
- What are different types of DBMS languages?