Model Based Environment: A Practical Guide for Data Model Implementation with examples in PowerDesigner
Information Systems are a synthesis of complex components where data plays a critical role. Data Modeling requires a disciplined approach making use of business and technical knowledge. Using data models for database design, implementation, and maintenance requires the implementation of procedures that will secure successful database deployment and validation. This book teaches you the basic technical knowledge required for physical data modeling as well as procedures for model implementation and maintenance. With examples in two major Relational Database Management Systems (Oracle and DB2) the book presents procedures for model design, implementation and maintenance in PowerDesigner modeling tool.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Other editions - View all
allows approach attributes buffer pool business analyst business rules code deployment column completed concept conceptual data model constraint CREATE TYPE data requirements data structures data team data type database administration database implementation database modifications database objects DDL code default value definition document enforced explicitly foreign key functionality Illustration impact infrastructure objects instance Legal Entity logical data domains logical data model logical domain logical model manually materialized view meta-data model and database Model Based Environment model implementation model modifications model repository model transition model validation model walk-through naming conventions NULL object names optimization Oracle and DB2 Oracle database parameters partitioning performance permissions phase physical data domains physical data model physical model PowerDesigner primary key problem RDBMS referential integrity rules relationship roles script SDLC security model sequence specified standard stored procedures supertype synchronization tablespace tool trigger unique update user defined