NoSQL & SQL Data Modeling

所需积分/C币:21 2018-05-24 16:49:35 9.13MB PDF
收藏 收藏

NoSQL & SQL Data Modeling NoSQL & SQL Data Modeling
Published by Tch∩ics Publications 2 Lindsley road Basking ridge, NJ 07920 USA Cover design by john Fiorentino Technical reviews by laurel shifrin Dave wells, and steve hoberman All rights reserved. No part of this book may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording or by any information storage and retrieval system, without written permission from the publisher, except for the inclusion of brief quotations in a review The author and publisher have taken care in the preparation of this book, but make no expressed or implied warranty of any kind and assume no responsibility for errors or omissions. No liability is assumed for incidental or consequential damages in connection with or arising out of the use of the information or programs contained herein All trade and product names are trademarks, registered trademarks, or service marks of their respective companies, and are the property of their respective holders and should be treated as such Copyright (C 2016 by Theodore S. Hills, thills(@acm. org ISBN, print ed.9781634621090 ISBN. Kindle ed. 9781634621106 ISBN, epub ed.9781634621113 ISBN, PDF ed.9781634621120 First printing 2016 Library of Congress Control Number: 2016930173 To my wife Daphne Woods, who has always believed in me, and gave me the space and support I needed to write this book Contents at a glance Part I: real words in the real world Chapter 1: It's All about the words Chapter 2: Things: Entities, Objects, and Concepts Chapter 3: Containment and composition Chapter 4: Types and Classes in the real world Part II: The Tyranny of Confusion Chapter 5: Entity-Relationship Modeling Chapter 6 The Unified Modeling Language Chapter 7: Fact-Based Modeling Notations Chapter 8: Semantic Notations Chapter 9: Object-Oriented Programming Languages Part III: Freedom in Meaning Chapter 10: Objects and classes Chapter 11: Types in Data and Software Chapter 12: Composite Types Chapter 13: Subtypes and subclasses Chapter 14: Data and Information Chapter 15: Relationships and roles Chapter 16: The Relational Theory of Data Chapter 17: NoSQL and SQL Physical Design Part IV: Case study Chapter 18: The Common Coffee Shop APPENDIX: COMN Quick Reference Table of contents Acknowledgements Introduction Taking Care of Data Plant Change Control 2.0 Where did the savings Come From? Why Model? Why COMN? Book Outline Book audience NOSQL Database Developer SQL Database Developer Data modeler Software developer Ontologies Part I Real words in the real world Chapter 1 It's All about the Words References Chapter 2 Things: Entities, Objects, and Concepts Chapter glossary Chapter 3 Containment and Composition Containment Composition Chapter glossary Chapter 4 Types and Classes in the Real World Collections of Objects Sets of Concepts Sets of Objects ypes and classes Types Designate Sets Classes describe objects Three aspects of Types and classes Chapter glossary Part II The Tyranny of Confusion Chapter 5 Entity-Relationship Modeling Logical E-R Data Models Multiple levels of abstraction Limitations of E-R Modeling Notation NoSQL Arrays and Nested Data Structures Lack of Reusable Composite Types Lack of place Modeling the Real World Representing Individual Entities Mapping Between Modcls Data in Software Terminology Entity Conceptual E-R Terms Mapped to COMN Terms References Chapter 6 The Unified Modeling Language Class Diagrams Stereotyping Limitations of the UMl Lack of Keys Middling level of abstraction Lack of Concept Subclassing versus Subtyping Terminology Relationship, Composition and Aggregation Type and Implementation Class UML Terms Mapped to COMN Terms References Chapter 7 Fact-Based Modeling Notations Facts and Relationships Limitations of Fact-Based Modeling Lack of instances Incompletely Difficulty Terminology Fact-Based Modeling Terms Mapped to COMN Terms References Chapter 8 Semantic Notations Predicates and rdf statements Doubles and Quadruples OWL Graphical Notations for Semantics Terminology Chapter 9 bject-Oriented Programming Languages Classes, Objects, Types, and variables erminology Part III Freedom in Meaning Chapter 10 Objects and Classes Material objects Objects with States Meaning of States Objects with More States Methods Material Obiects in Computers Summary Computer Object Defined Composing objects Summary Chapter Glossary Chapter 11 Types in Data and Software Types in Programming and Databases What Does a Type Tell Us? Classes in Object-Oriented Software Separating Type and class Simple Types References Chapter glossary Chapter 12 Composite Types Composite Types as Logical Record Types Types Representing Things in the Real World: Identification Stepwise refinement and completeness Types Representing Other Types Measures as Composite Types Nested Types Modeling Documents Arrays Chapter glossary References Chapter 13 Subtypes and Subclasses Subtypes Restriction is Subtyping Subclasses Subtypes and Extensions: Perfect Together Inheritance Using Subtype Variables and valucs Using Extending Types and Classes Projection: The Inverse of Extension Chapter glossary Chapter 14 Data and Information Information Is Information Always True? From Information to data Data en masse Variable names Summary Information and Data as Colloquialisms Information en masse

试读 127P NoSQL & SQL Data Modeling
立即下载 低至0.43元/次 身份认证VIP会员低至7折
julianjing 非常棒的书
    NoSQL & SQL Data Modeling 21积分/C币 立即下载
    NoSQL & SQL Data Modeling第1页
    NoSQL & SQL Data Modeling第2页
    NoSQL & SQL Data Modeling第3页
    NoSQL & SQL Data Modeling第4页
    NoSQL & SQL Data Modeling第5页
    NoSQL & SQL Data Modeling第6页
    NoSQL & SQL Data Modeling第7页
    NoSQL & SQL Data Modeling第8页
    NoSQL & SQL Data Modeling第9页
    NoSQL & SQL Data Modeling第10页
    NoSQL & SQL Data Modeling第11页
    NoSQL & SQL Data Modeling第12页
    NoSQL & SQL Data Modeling第13页
    NoSQL & SQL Data Modeling第14页
    NoSQL & SQL Data Modeling第15页
    NoSQL & SQL Data Modeling第16页
    NoSQL & SQL Data Modeling第17页
    NoSQL & SQL Data Modeling第18页
    NoSQL & SQL Data Modeling第19页
    NoSQL & SQL Data Modeling第20页

    试读结束, 可继续阅读

    21积分/C币 立即下载 >