Data Modeling Fundamentals – A Practical Guide for IT Professionals
Home > Computing and Information Technology > Computer programming / software engineering > Algorithms and data structures > Data Modeling Fundamentals – A Practical Guide for IT Professionals
Data Modeling Fundamentals – A Practical Guide for  IT Professionals

Data Modeling Fundamentals – A Practical Guide for IT Professionals

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

The purpose of this book is to provide a practical approach for IT professionals to acquire the necessary knowledge and expertise in data modeling to function effectively. It begins with an overview of basic data modeling concepts, introduces the methods and techniques, provides a comprehensive case study to present the details of the data model components, covers the implementation of the data model with emphasis on quality components, and concludes with a presentation of a realistic approach to data modeling. It clearly describes how a generic data model is created to represent truly the enterprise information requirements.

Table of Contents:
Preface. Acknowledgments. PART I: INTRODUCTION TO DATA MODELING. 1. Data Modeling: An Overview. Chapter Objectives. Data Model Defined. What is a Data Model? Why Data Modeling? Who Performs Data Modeling? Information Levels. Classification of Information Levels. Data Models at Information Levels. Conceptual Data Modeling. Data Model Components. Data Modeling Steps. Data Model Quality. Significance of Data Model Quality. Data Model Characteristics. Ensuring Data Model Quality. Data System Development. Data System Development Life Cycle (DDLC). Roles and Responsibilities. Modeling the Information Requirements. Applying Agile Modeling Principles. Data Modeling Approaches and Trends. Data Modeling Approaches. Modeling for Data Warehouse. Other Modeling Trends. Chapter Summary. Review Questions. 2. Methods, Techniques, and Symbols. Chapter Objectives. Data Modeling Approaches. Semantic Modeling. Relational Modeling. Entity-Relationship Modeling. Binary Modeling. Methods and Techniques. Peter Chen (E-R) Modeling. Information Engineering. IDEF1X. Richard Barker's. ORM (Object Role Modeling). XML (eXtensible Markup Language). Summary and Comments. Unified Modeling Language (UML). Data Modeling Using UML. UML in the Development Process. Chapter Summary. Review Questions. PART II. DATA MODELING FUNDAMENTALS. 3. Anatomy of a Data Model. Chapter Objectives. Data Model Composition. Models at Different Levels. Conceptual Model: Review Procedure. Conceptual Model: Identifying Components. Case Study. Description. E-R Model. UML Model. Creation of Models. User Views. View Integration. Entity Types. Specialization/Generalization. Relationships. Attributes. Identifiers. Review of the Model Diagram. Logical Model: Overview. Model Components. Transformation Steps. Relational Model. Physical Model: Overview. Model Components. Transformation Steps. Chapter Summary. Review Questions. 4. Objects or Entities in Detail. Chapter Objectives. Entity Types or Object Sets. Comprehensive Definition. Identifying Entity Types. Homonyms and Synonyms. Category of Entity Types. Exploring Dependencies. Dependent or Weak Entity Types. Classifying Dependencies. Representation in the Model. Generalization and Specialization. Why Generalize or Specialize? Super-types and Sub-types. Generalization Hierarchy. Inheritance of Attributes. Inheritance of Relationships. Constraints. Rules Summarized. Special Cases and Exceptions. Recursive Structures. Conceptual and Physical. Assembly Structures. Entity Type Vs Attribute. Entity Type Vs Relationship. Modeling Time Dimension. Categorization. Entity Validation Checklist. Completeness. Correctness. Chapter Summary. Review Questions. 5. Attributes and Identifiers in Detail. Chapter Objectives. Attributes. Properties or Characteristics. Attributes as Data. Attribute Values. Names and Descriptions. Attribute Domains. Definition of a Domain. Domain Information. Attribute Values and Domains. Split Domains. Misrepresented Domains. Resolution of Mixed Domains. Constraints for Attributes. Value Set. Range. Type. Null Values. Types of Attributes. Single-Valued and Multi-Valued Attributes. Simple and Composite Attributes. Attributes with Stored and Derived Values . Optional Attributes. Identifiers or Keys. Need for Identifiers. Definitions of Keys. Guidelines for Identifiers. Key in Generalization Hierarchy. Attribute Validation Checklist. Completeness. Correctness. Chapter Summary. Review Questions. 6. Relationships in Detail. Chapter Objectives. Relationships. Associations. Relationship?Two-sided. Relationship Sets. Double Relationships. Relationship Attributes. Degree of Relationships. Unary Relationship. Binary Relationship. Ternary Relationship. Quaternary Relationship. Structural Constraints. Cardinality Constraint. Participation Constraint. Dependencies. Entity Existence. Relationship Types. Identifying Relationship . Non-identifying Relationship. Maximum and Minimum Cardinalities. Mandatory Conditions - Both Ends. Optional Condition - One End. Optional Condition - Other End. Optional Conditions - Both Ends. Special Cases. Gerund. Aggregation. Access Pathways. Design Issues. Relationship Or Entity Type? Ternary Relationship Or Aggregation? Binary Or N-ary Relationship? One-to-One Relationships. One-to-Many Relationships. Circular Structures. Redundant Relationships. Multiple Relationships. Relationship Validation Checklist. Completeness. Correctness. Chapter Summary. Review Questions. PART III. DATA MODEL IMPLEMENTATION. 7. Data Modeling to Database Design. Chapter Objectives. Relational Model: Fundamentals. Basic Concepts. Structure and Components. Data Integrity Constraints. Transition to Database Design. Design Approaches. Conceptual to Relational Model. Traditional Method. Evaluation of Design Methods. Model Transformation Method. The Approach. Mapping of Components. Entity Types to Relations. Attributes to Columns. Identifiers to Keys. Transformation of Relationships. Transformation Summary . Chapter Summary. Review Questions. 8. Data Normalization. Chapter Objectives. Informal Design. Forming Relations from Requirements. Potential Problems. Update Anomaly. Deletion Anomaly. Addition Anomaly. Normalization Methodology. Strengths of the Method. Application of the Method. Normalization Steps. Fundamental Normal Forms. First Normal Form. Second Normal Form. Third Normal Form. Boyce-Codd Normal Form. Higher Normal Forms. Fourth Normal Form. Fifth Normal Form. Domain-Key Normal Form. Normalization Summary. Review of the Steps. Normalization as Verification. Chapter Summary. Review Questions. 9. Modeling for Decision-Support Systems. Chapter Objectives. Decision-Support Systems. Need for Strategic Information. History of Decision-Support Systems. Operational Vs Informational Systems. System Types and Modeling Methods. Data Warehouse. Data Warehouse Defined. Major Components. Data Warehousing Applications. Modeling: Special Requirements. Dimensional Modeling. Dimensional Modeling Basics. STAR Schema. Snowflake Schema. Families of STARS. Transition to Logical Model. OLAP Systems. Features and Functions of OLAP. Dimensional Analysis. Hypercubes. OLAP Implementation Approaches. Data Modeling for OLAP. Data Mining Systems. Basic Concepts. Data Mining Techniques. Data Preparation and Modeling. Data Preprocessing. Data Modeling. Chapter Summary. Review Questions. PART IV. PRACTICAL APPROACH TO DATA MODELING. 10. Ensuring Quality in the Data Model. Chapter Objectives. Significant of Quality. Why Emphasize Quality? Good and Bad Models. Approach to Good Modeling. Quality of Definitions. Importance of Definitions. Aspects of Quality Definitions. Correctness. Completeness. Clearness. Format. Checklists. High-Quality Data Model. Meaning of Data Model Quality. Quality Dimensions. What is a High-Quality Model? Benefits of High-Quality Models. Quality Assurance Process. Aspects of Quality Assurance. Stages of Quality Assurance Process. Data Model Review. Data Model Assessment. Chapter Summary. Review Questions. 11. Agile Data Modeling in Practice. Chapter Objectives. The Agile Movement. How It Got Started. Principles of Agile Development. Philosophies. Generalizing Specialists. Agile Modeling. What is Agile Modeling? Basic Principles. Auxiliary Principles. Practicing Agile Modeling. Primary Practices. Additional Practices. Role of Agile DBA. Agile Documentation. Recognizing an Agile Model. Feasibility. Evolutionary Data Modeling. Traditional Approach. Need for Flexibility. Nature of Evolutionary Modeling. Benefits. Chapter Summary. Review Questions. 12. Data Modeling: Practical Tips. Chapter Objectives. Tips and Suggestions. Nature of Tips. How Specified. How to Use Them. Requirements Definition. Interviews. Group Sesssions. Geographically Dispersed Groups. Documentation. Change Management. Notes for Modeling. Stakeholder Participation. Organizing Participation. User Liaison. Continuous Interaction. Multiple Sites. Iterative Modeling. Establishing Cycles. Determining Increments. Requirements--Model Interface. Integration of Partial Models. Special Cases. Legal Entities. Locations and Places. Time Periods. Persons. Bill-of-Materials. Conceptual Model Layout. Readability and Usability. Component Arrangement. Adding Texts. Visual Highlights. Logical Data Model. Enhancement Motivation. Easier DB Implementation. Performance Improvement. Storage Management. Enhanced Representation. Chapter Summary. Review Questions. References. Glossary. Index.


Best Sellers


Product Details
  • ISBN-13: 9780470141021
  • Publisher: John Wiley and Sons Ltd
  • Binding: Other digital
  • No of Pages: 464
  • ISBN-10: 0470141026
  • Publisher Date: 17 Nov 2006
  • Language: English
  • Weight: 10 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Data Modeling Fundamentals – A Practical Guide for  IT Professionals
John Wiley and Sons Ltd -
Data Modeling Fundamentals – A Practical Guide for IT Professionals
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Data Modeling Fundamentals – A Practical Guide for IT Professionals

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!