Data Modeling Made Simple with ER/Studio Data Architect - Softcover

Hoberman, Steve

Softcover

ISBN 10: 1935504487 ISBN 13: 9781935504481

Verlag: Technics Publications LLC, 2013

Inhaltsangabe

Data Modeling Made Simple with ER/Studio Data Architect will provide the business or IT professional with a practical working knowledge of data modeling concepts and best practices, along with how to apply these principles with ER/Studio. You'll build many ER/Studio data models along the way, applying best practices to master these ten objectives:

1. You will know why a data model is needed and which ER/Studio models are the most appropriate for each situation
2. You will be able to read a data model of any size and complexity with the same confidence as reading a book
3. You will know how to apply all the key features of ER/Studio
4. You will be able to build relational and dimensional conceptual, logical, and physical data models in ER/Studio
5. You will be able to apply techniques such as indexing, transforms, and forward engineering to turn a logical data model into an efficient physical design
6. You will improve data model quality and impact analysis results by leveraging ER/Studio's lineage functionality and compare/merge utility
7. You will achieve enterprise architecture through ER/Studio's repository and portal functionality
8. You will be able to apply ER/Studio's data dictionary features
9. You will learn ways of sharing the data model through reporting and through exporting the model in a variety of formats
10. You will leverage ER/Studio's naming functionality to improve naming consistency

This book contains four sections:
Section I introduces data modeling and the ER/Studio landscape. Learn why data modeling is so critical to software development and even more importantly, why data modeling is so critical to understanding the business. You will also learn about the ER/Studio environment. By the end of this section, you will have created and saved your first data model in ER/Studio and be ready to start modeling in Section II!

Section II explains all of the symbols and text on a data model, including entities, attributes, relationships, domains, and keys. By the time you finish this section, you will be able to 'read' a data model of any size or complexity, and create a complete data model in ER/Studio.

Section III explores the three different levels of models: conceptual, logical, and physical. A conceptual data model (CDM) represents a business need within a defined scope. The logical data model (LDM) represents a detailed business solution, capturing the business requirements without complicating the model with implementation concerns such as software and hardware. The physical data model (PDM) represents a detailed technical solution. The PDM is the logical data model compromised often to improve performance or usability. The PDM makes up for deficiencies in our technology. By the end of this section you will be able to create conceptual, logical, and physical data models in ER/Studio.

Section IV discusses additional features of ER/Studio. These features include data dictionary, data lineage, automating tasks, repository and portal, exporting and reporting, naming standards, and compare and merge functionality.

Über diesen Titel

Über die Autorin bzw. den Autor

Steve Hoberman has trained more than 10,000 people in data modeling since 1992. Steve is known for his ability to translate from business requirements to technical specifications. Steve is the author of nine books on data modeling, including the bestseller Data Modeling Made Simple. Steve is also the author of Blockchainopoly. One of Steve's frequent data modeling consulting assignments is to review BTMs using his Data Model Scorecard® technique. He is the creator of the Data Modeling Institute's Data Modeling Certification exam, Data Modeling Zone Conference Chair, lecturer at Columbia University, and recipient of the Data Administration Management Association International Professional Achievement Award.

Aus dem Klappentext

Data Modeling Made Simple with ER/Studio Data Architect will provide the business or IT professional with a practical working knowledge of data modeling concepts and best practices, along with how to apply these principles with ER/Studio. You'll build many ER/Studio data models along the way, applying best practices to master these ten objectives: 1. You will know why a data model is needed and which ER/Studio models are the most appropriate for each situation 2. You will be able to read a data model of any size and complexity with the same confidence as reading a book 3. You will know how to apply all the key features of ER/Studio 4. You will be able to build relational and dimensional conceptual, logical, and physical data models in ER/Studio 5. You will be able to apply techniques such as indexing, transforms, and forward engineering to turn a logical data model into an efficient physical design 6. You will improve data model quality and impact analysis results by leveraging ER/Studio's lineage functionality and compare/merge utility 7. You will achieve enterprise architecture through ER/Studio's repository and portal functionality 8. You will be able to apply ER/Studio's data dictionary features 9. You will learn ways of sharing the data model through reporting and through exporting the model in a variety of formats 10. You will leverage ER/Studio's naming functionality to improve naming consistency

Details zur Ausgabe

• Verlag: Technics Publications LLC
• Erscheinungsdatum: 2013
• Sprache: Englisch
• ISBN 10: 1935504487
• ISBN 13: 9781935504481
• Einband: Tapa blanda
• Auflage: 1
• Anzahl der Seiten: 300
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: eucomply OÜ; hello@eucompliancepartner.com; ; Pärnu mnt 139b-14; Tallinn; 11317; Estland