Model Based Environment: A Practical Guide for Data Model Implementation with Examples in Powerdesigner

Front Cover
Trafford Publishing, Feb 14, 2013 - Computers - 342 pages
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.
 

Selected pages

Contents

1 Introduction
1
2 Data model development cycle
11
3 Preparation phase
14
4 Conceptual data modeling
33
5 Logical data modeling
36
6 Physical data modeling
77
7 Model implementation
238
8 Implementation validation
284
9 Working with the model repository
292
Conclusion
325
Bibliography
327
Copyright

Other editions - View all

Model Based Environment: A Practical Guide for Data Model Implementation ...
Vladimir Pantic
No preview available - 2013

Common terms and phrases

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

About the author (2013)

Vladimir Pantic has been in Data Modeling and Physical Database Design for over twenty five years. He graduated from the University of Belgrade and worked in Information Technology with companies across the industries of Investment Banking, Insurance, Health Care, and Forestry in Europe, North America and Asia. He has guided these organizations in practicing disciplined logical and physical database design while following rigid processes. This book is an effort to help the data modelers be more efficient in their day-to-day work by providing the basic guidelines of how to use the models to optimize the modeling process.

Bibliographic information

TitleModel Based Environment: A Practical Guide for Data Model Implementation with Examples in Powerdesigner
AuthorVladimir Pantic
PublisherTrafford Publishing, 2013
ISBN1466979682, 9781466979680
Length342 pages
Subjects › 

Computers / General
  
Export CitationBiBTeX EndNote RefMan