LESSON-5: DATABASE DEVELOPMENT PROCESSES (Cont’d; Ashraf, Khan, and Mir)
LESSON-5: DATABASE DEVELOPMENT PROCESSES (Cont’d; Ashraf, Khan, and Mir)
5.1 Overview of Processes
1. System Development Life Cycle (SDLC)
2. Enterprise Modeling: project Identification, initiation & planning, analysis logical design, physical design, implementation, and maintenance
3. Conceptual Data Modeling: overall data requirements.
4. Logical Database Design: Functional specifications of all data, forms, reports, displays, and processing rules.
5. Physical Design: Programs, database structures, technology, and organizational redesign.
6. Implementation: build up data files, test and install the new system, train users, finalize documentation.
7. Maintenance: To repair and enhance the system.
5.3 Object Oriented Database Development Processes (SDLC)
Review
It consists of enterprise model, conceptual data model, logical database design, physical database design and creation, database implementation, and database maintenance.
These are further elaborated below;
Enterprise model: Deliverables are project identification and selection.
Process include:
a. Analyze current data processing
b. Analyze the general business functions
c. Justify need for new data and databases in support of business
Conceptual Data Model: Project Initiation and planning
Processes include:
a. Identify scope of database requirements for proposed system
b. Analyze overall data requirements for business function(s) supported by database
c. Develop preliminary conceptual data model, including entities and relationships
d. Compare preliminary model with enterprise data model
e. Develop detailed conceptual model , including all entities, relationships, attributes, and business rules
f. Make conceptual model consistent with other models of information
system
g. Populate repository with all conceptual database specifications
Logical Database Design
a. Analyze in detail the transactions, form, displays, and inquiries (views) required by the business functions supported by the database.
b. Integrate database views into the conceptual model.
c. Identify data integrity/ security requirements, and populate repository.
Physical database design and creation
a. Define database to DBMS provisions (often generated from repository of designing tool.
b. Decide on physical organization of data.
c. Design database processing programs.
Database Implementation
a. Code and test database processing programs.
b. Complete database documentation and training materials.
c. Install database and convert data from prior system.
Database Maintenance
a. Analyze database and database applications to ensure that evolving information requirements are met.
b. Tune database for improved performance.
c. Fix errors in database and database applications and recover database when it is contaminated.
*****
Click To MAIN PAGE: OBJECT- ORIENTED RELATIONAL MODELLING E-MONOGRAPH, By J. Ashraf, M. Khan, and H. Mir
*****
MESSAGE: DEDICATED TO ANONYMOUS COMBATANTS OF KNOWLEDGE
مکتب علم الل مہد منل لحد Learning continues from birth to death
FOR PROMOTION OF LEARNEDNESS SHARE WITH FRIENDS ABOUT;
- CAUSE AND EVENTS – SPATIAL And TEMPORAL RESPECTIVELY: https://be4gen.wordpress.com/2012/11/16/cause-and-events-spatial-temporal-respectively/
- WHETHER ‘BRAIN-POWER’ OR ‘HEART-IMPULSE’ PLINTHS ‘HUMAN GEN’? http://sunedu.wordpress.com/2012/09/17/whether-brain-power-or-heart-impulse-plinths-human-gen/
************
No comments:
Post a Comment