Vor Ort
Merkzettel Warenkorb
Produktbild: Beginning Database Design Solutions

Beginning Database Design Solutions Understanding and Implementing Database Design Concepts for the Cloud and Beyond

Aus der Reihe John Wiley & Sons

49,99 €

inkl. gesetzl. MwSt., Versandkostenfrei

Beschreibung

Produktdetails

Einband

Taschenbuch

Erscheinungsdatum

04.04.2023

Verlag

John Wiley & Sons Inc

Seitenzahl

736

Maße (L/B/H)

23,2/18,3/3,8 cm

Gewicht

1324 g

Auflage

2nd edition

Sprache

Englisch

ISBN

978-1-394-15572-9

Beschreibung

Produktdetails

Einband

Taschenbuch

Erscheinungsdatum

04.04.2023

Verlag

John Wiley & Sons Inc

Seitenzahl

736

Maße (L/B/H)

23,2/18,3/3,8 cm

Gewicht

1324 g

Auflage

2nd edition

Sprache

Englisch

ISBN

978-1-394-15572-9

Herstelleradresse

Libri GmbH
Europaallee 1
36244 Bad Hersfeld
DE

Email: gpsr@libri.de

Noch keine Bewertungen vorhanden

Verfassen Sie die erste Bewertung zu diesem Artikel

Helfen Sie anderen Kundinnen und Kunden durch Ihre Meinung.

Kundinnen und Kunden meinen

Bewertungen (0)
Die Leseprobe wird geladen.
  • Produktbild: Beginning Database Design Solutions
  • Introduction xxv
     
    Part 1: Introduction to Databases and Database Design
     
    Chapter 1: Database Design Goals 3
     
    The Importance of Design 4
     
    Information Containers 6
     
    Strengths and Weaknesses of Information Containers 8
     
    Desirable Database Features 9
     
    Crud 10
     
    Retrieval 10
     
    Consistency 11
     
    Validity 11
     
    Easy Error Correction 12
     
    Speed 13
     
    Atomic Transactions 13
     
    Acid 14
     
    Base 16
     
    NewSQL 17
     
    Persistence and Backups 17
     
    Low Cost and Extensibility 18
     
    Ease of Use 19
     
    Portability 19
     
    Security 20
     
    Sharing 21
     
    Ability to Perform Complex Calculations 21
     
    CAP Theorem 22
     
    Cloud Considerations 22
     
    Legal and Security Considerations 23
     
    Consequences of Good and Bad Design 24
     
    Summary 26
     
    Chapter 2: Relational Overview 29
     
    Picking a Database 30
     
    Relational Points of View 31
     
    Table, Rows, and Columns 32
     
    Relations, Attributes, and Tuples 34
     
    Keys 34
     
    Indexes 36
     
    Constraints 37
     
    Domain Constraints 37
     
    Check Constraints 37
     
    Primary Key Constraints 38
     
    Unique Constraints 38
     
    Foreign Key Constraints 38
     
    Database Operations 40
     
    Popular RDBs 41
     
    Spreadsheets 43
     
    Summary 44
     
    Chapter 3: NoSQL OVERVIEW 47
     
    The Cloud 47
     
    Picking a Database 50
     
    NoSQL Philosophy 50
     
    NoSQL Databases 50
     
    Document Databases 51
     
    Key- Value Database 52
     
    Column- Oriented Databases 53
     
    Graph Databases 53
     
    Street Networks 54
     
    Communication Networks 55
     
    Social Media Apps 55
     
    E- Commerce Programs 55
     
    Algorithms 56
     
    Hierarchical Databases 56
     
    Less Exotic Options 59
     
    Flat Files 59
     
    XML Files 60
     
    XML Basics 61
     
    XML Practices 64
     
    XML Summary 66
     
    JSON Files 67
     
    Spreadsheets 69
     
    More Exotic Options 70
     
    Object 70
     
    Deductive 70
     
    Dimensional 70
     
    Temporal 71
     
    Database Pros and Cons 72
     
    Relational 72
     
    General NoSQL 73
     
    Quick Guidelines 74
     
    Summary 76
     
    Part 2: Database Design Process and Techniques
     
    Chapter 4: Understanding User Needs 83
     
    Make a Plan 84
     
    Bring a List of Questions 85
     
    Functionality 85
     
    Data Needs 86
     
    Data Integrity 86
     
    Security 87
     
    Environment 88
     
    Meet the Customers 88
     
    Learn Who's Who 89
     
    Pick the Customers' Brains 93
     
    Walk a Mile in the User's Shoes 93
     
    Study Current Operations 94
     
    Brainstorm 94
     
    Look to the Future 95
     
    Understand the Customers' Reasoning 96
     
    Learn What the Customers Really Need 97
     
    Prioritize 98
     
    Verify Your Understanding 99
     
    Create the Requirements Document 101
     
    Make Use Cases 102
     
    Decide Feasibility 106
     
    Summary 106
     
    Chapter 5: Translating User Needs Into Data Models 111
     
    What Are Data Models? 112
     
    User Interface Models 114
     
    Semantic Object Models 118
     
    Classes and Objects 119
     
    Cardinality 120
     
    Identifiers 120
     
    Putting It Together 121
     
    Semantic Views 122
     
    Class Types 124
     
    Simple Objects 124
     
    Composite Objects 124
    &n