國立高雄大學圖資館 |

Beginning database design solutionsunderstanding and implementing database design concepts for the cloud and beyond /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Beginning database design solutionsRod Stephens.
Reminder of title:	understanding and implementing database design concepts for the cloud and beyond /
Author:	Stephens, Rod,
Published:	Hoboken, NJ :John Wiley & Sons,c2023.
Description:	1 online resource(736 p.) :ill. (some col.)
Notes:	Includes index.
Subject:	Database design.
Online resource:	https://onlinelibrary.wiley.com/doi/book/10.1002/9781394320646
ISBN:	9781394320646$q(electronic bk.)

Beginning database design solutionsunderstanding and implementing database design concepts for the cloud and beyond /
Stephens, Rod,1961-

Beginning database design solutionsunderstanding and implementing database design concepts for the cloud and beyond /[electronic resource] :Rod Stephens. - 2nd ed. - Hoboken, NJ :John Wiley & Sons,c2023. - 1 online resource(736 p.) :ill. (some col.) - Wrox programmer to programmer. - Wrox programmer to programmer..

Includes index.

Cover -- Title Page -- Copyright Page -- About The Author -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- What You Need to Use This Book -- How This Book Is Structured -- Part I: Introduction to Databases and Database Design -- Part II: Database Design Process and Techniques -- Part III: A Detailed Case Study -- Part IV: Example Programs -- Part V: Advanced Topics -- Appendixes -- How to Use This Book -- Note to Instructors -- Note to Students -- Conventions -- Source Code -- Contacting the Author -- Disclaimer -- Part 1 Introduction to Databases and Database Design -- Chapter 1 Database Design Goals -- The Importance of Design -- Space Spat -- Information Containers -- Strengths and Weaknesses of Information Containers -- Desirable Database Features -- CRUD -- Retrieval -- Consistency -- Validity -- Easy Error Correction -- Speed -- Atomic Transactions -- ACID -- BASE -- NewSQL -- Persistence and Backups -- Low Cost and Extensibility -- Ease of Use -- Portability -- Security -- Sharing -- Ability to Perform Complex Calculations -- CAP Theorem -- Cloud Considerations -- Legal and Security Considerations -- Consequences of Good and Bad Design -- Summary -- Chapter 2 Relational Overview -- Picking a Database -- Relational Points of View -- Table, Rows, and Columns -- Relations, Attributes, and Tuples -- Keys -- Indexes -- Constraints -- Domain Constraints -- Check Constraints -- Primary Key Constraints -- Unique Constraints -- Foreign Key Constraints -- Database Operations -- Popular RDBs -- Spreadsheets -- Summary -- Chapter 3 NoSQL Overview -- The Cloud -- Picking a Database -- NoSQL Philosophy -- NoSQL Databases -- Document Databases -- Key-Value Database -- Column-Oriented Databases -- Graph Databases -- Street Networks -- Communication Networks -- Social Media Apps -- E-Commerce Programs -- Algorithms.

A concise introduction to database design concepts, methods, and techniques in and out of the cloud In the newly revised second edition of Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition, award-winning programming instructor and mathematician Rod Stephens delivers an easy-to-understand guide to designing and implementing databases both in and out of the cloud. Without assuming any prior database design knowledge, the author walks you through the steps you'll need to take to understand, analyze, design, and build databases. In the book, you'll find clear coverage of foundational database concepts along with hands-on examples that help you practice important techniques so you can apply them to your own database designs, as well as: Downloadable source code that illustrates the concepts discussed in the book Best practices for reliable, platform-agnostic database design Strategies for digital transformation driven by universally accessible database design An essential resource for database administrators, data management specialists, and database developers seeking expertise in relational, NoSQL, and hybrid database design both in and out of the cloud, Beginning Database Design Solutions is a hands-on guide ideal for students and practicing professionals alike.

ISBN: 9781394320646$q(electronic bk.)Subjects--Topical Terms:

184445
Database design.

LC Class. No.: QA76.585 / .S747 2023

Dewey Class. No.: 005.74

Beginning database design solutionsunderstanding and implementing database design concepts for the cloud and beyond /
LDR:12103cmm a2200433 a 4500 001 684685
005 20251121072503.0
006 m o d
007 cr cnu---unuuu
008 260128s2023 njua o 001 0 eng d
020 $a 9781394320646$q(electronic bk.)
020 $a 1394320647$q(electronic bk.)
020 $a 9781394155842$q(electronic bk.)
020 $a 1394155840$q(electronic bk.)
020 $a 9781394155835$q(electronic bk.)
020 $z 9781394155729
020 $z 1394155727
035 $a (OCoLC)1371753756
035 $a (OCoLC)1379433045
035 $a (OCoLC-P)1379433045
035 $a 9926170455700041
040 $a MiAaPQ $b eng $c MiAaPQ $d MiAaPQ
041 0 $a eng
050 4 $a QA76.585 $b .S747 2023
082 0 4 $a 005.74 $2 23
100 1 $a Stephens, Rod, $d 1961- $3 998153
245 1 0 $a Beginning database design solutions $h [electronic resource] : $b understanding and implementing database design concepts for the cloud and beyond / $c Rod Stephens.
250 $a 2nd ed.
260 $a Hoboken, NJ : $b John Wiley & Sons, $c c2023.
300 $a 1 online resource(736 p.) : $b ill. (some col.)
490 1 $a Wrox programmer to programmer
500 $a Includes index.
505 0 $a Cover -- Title Page -- Copyright Page -- About The Author -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- What You Need to Use This Book -- How This Book Is Structured -- Part I: Introduction to Databases and Database Design -- Part II: Database Design Process and Techniques -- Part III: A Detailed Case Study -- Part IV: Example Programs -- Part V: Advanced Topics -- Appendixes -- How to Use This Book -- Note to Instructors -- Note to Students -- Conventions -- Source Code -- Contacting the Author -- Disclaimer -- Part 1 Introduction to Databases and Database Design -- Chapter 1 Database Design Goals -- The Importance of Design -- Space Spat -- Information Containers -- Strengths and Weaknesses of Information Containers -- Desirable Database Features -- CRUD -- Retrieval -- Consistency -- Validity -- Easy Error Correction -- Speed -- Atomic Transactions -- ACID -- BASE -- NewSQL -- Persistence and Backups -- Low Cost and Extensibility -- Ease of Use -- Portability -- Security -- Sharing -- Ability to Perform Complex Calculations -- CAP Theorem -- Cloud Considerations -- Legal and Security Considerations -- Consequences of Good and Bad Design -- Summary -- Chapter 2 Relational Overview -- Picking a Database -- Relational Points of View -- Table, Rows, and Columns -- Relations, Attributes, and Tuples -- Keys -- Indexes -- Constraints -- Domain Constraints -- Check Constraints -- Primary Key Constraints -- Unique Constraints -- Foreign Key Constraints -- Database Operations -- Popular RDBs -- Spreadsheets -- Summary -- Chapter 3 NoSQL Overview -- The Cloud -- Picking a Database -- NoSQL Philosophy -- NoSQL Databases -- Document Databases -- Key-Value Database -- Column-Oriented Databases -- Graph Databases -- Street Networks -- Communication Networks -- Social Media Apps -- E-Commerce Programs -- Algorithms.
505 8 $a Hierarchical Databases -- Less Exotic Options -- Flat Files -- XML Files -- XML Basics -- XML Practices -- XML Summary -- JSON Files -- Spreadsheets -- More Exotic Options -- Object -- Deductive -- Dimensional -- Temporal -- Database Pros and Cons -- Relational -- General NoSQL -- Quick Guidelines -- Summary -- Part 2 Database Design Process and Techniques -- Chapter 4 Understanding User Needs -- Make a Plan -- Bring a List of Questions -- Functionality -- Data Needs -- Data Integrity -- Security -- Environment -- Meet the Customers -- Learn Who's Who -- Pick the Customers' Brains -- Walk a Mile in the User's Shoes -- Study Current Operations -- Brainstorm -- Look to the Future -- Understand the Customers' Reasoning -- Learn What the Customers Really Need -- Prioritize -- Verify Your Understanding -- Create the Requirements Document -- Make Use Cases -- Decide Feasibility -- Summary -- Chapter 5 Translating User Needs into Data Models -- What Are Data Models? -- User Interface Models -- Semantic Object Models -- Classes and Objects -- Cardinality -- Identifiers -- Putting It Together -- Semantic Views -- Class Types -- Simple Objects -- Composite Objects -- Compound Objects -- Hybrid Objects -- Association Objects -- Inherited Objects -- Comments and Notes -- Entity-Relationship Models -- Entities, Attributes, and Identifiers -- Relationships -- Cardinality -- Inheritance -- Additional Conventions -- Comments and Notes -- Relational Models -- Converting Semantic Object Models -- Converting ER Diagrams -- Summary -- Chapter 6 Extracting Business Rules -- What Are Business Rules? -- Identifying Key Business Rules -- Extracting Key Business Rules -- Multi-Tier Applications -- Summary -- Chapter 7 Normalizing Data -- What Is Normalization? -- First Normal Form (1NF) -- Second Normal Form (2NF) -- Third Normal Form (3NF) -- Stopping at Third Normal Form.
505 8 $a Boyce-Codd Normal Form (BCNF) -- Fourth Normal Form (4NF) -- Fifth Normal Form (5NF) -- Domain/Key Normal Form (DKNF) -- Essential Redundancy -- The Best Level of Normalization -- NoSQL Normalization -- Summary -- Chapter 8 Designing Databases to Support Software -- Plan Ahead -- Document Everything -- Consider Multi-tier Architecture -- Convert Domains into Tables -- Keep Tables Focused -- Use Three Kinds of Tables -- Use Naming Conventions -- Allow Some Redundant Data -- Don't Squeeze in Everything -- Summary -- Chapter 9 Using Common Design Patterns -- Associations -- Many-to-Many Associations -- Multiple Many-to-Many Associations -- Multiple-Object Associations -- Repeated Attribute Associations -- Reflexive Associations -- One-to-One Reflexive Associations -- One-to-Many Reflexive Associations -- Hierarchical Data -- Hierarchical Data with NoSQL -- Network Data -- Network Data with NoSQL -- Temporal Data -- Effective Dates -- Deleted Objects -- Deciding What to Temporalize -- Logging and Locking -- Audit Trails -- Turnkey Records -- Summary -- Chapter 10 Avoiding Common Design Pitfalls -- Lack of Preparation -- Poor Documentation -- Poor Naming Standards -- Thinking Too Small -- Not Planning for Change -- Too Much Normalization -- Insufficient Normalization -- Insufficient Testing -- Performance Anxiety -- Mishmash Tables -- Not Enforcing Constraints -- Obsession with IDs -- Not Defining Natural Keys -- Summary -- Part 3 A Detailed Case Study -- Chapter 11 Defining User Needs and Requirements -- Meet the Customers -- Pick the Customers' Brains -- Determining What the System Should Do -- Determining How the Project Should Look -- Determining What Data Is Needed for the User Interface -- Determining Where the Data Should Come From -- Determining How the Pieces of Data Are Related -- Determining Performance Needs -- Determining Security Needs.
505 8 $a Determining Data Integrity Needs -- Write Use Cases -- Write the Requirements Document -- Demand Feedback -- Summary -- Chapter 12 Building a Data Model -- Semantic Object Modeling -- Building an Initial Semantic Object Model -- Improving the Semantic Object Model -- Entity-Relationship Modeling -- Building an ER Diagram -- Building a Combined ER Diagram -- Improving the Entity-Relationship Diagram -- Relational Modeling -- Putting It All Together -- Summary -- Chapter 13 Extracting Business Rules -- Identifying Business Rules -- Courses -- CustomerCourses -- Customers -- Pets -- Employees -- Orders -- OrderItems -- InventoryItems -- TimeEntries -- Shifts -- Persons -- Phones -- Vendors -- Drawing a New Relational Model -- Summary -- Exercises -- Chapter 14 Normalizing and Refining -- Improving Flexibility -- Verifying First Normal Form -- Verifying Second Normal Form -- Pets -- TimeEntries -- Verifying Third Normal Form -- Summary -- Part 4 Example Programs -- Chapter 15 Example Overview -- Tool Choices -- Jupyter Notebook -- Visual Studio -- Database Adapters -- Packages in Jupyter Notebook -- Packages in Visual Studio -- Program Passwords -- Summary -- Chapter 16 MariaDB in Python -- Install MariaDB -- Run HeidiSQL -- Create the Program -- Install pymysql -- Create the Database -- Define Tables -- Create Data -- Fetch Data -- Summary -- Exercises -- Chapter 17 MariaDB in C# -- Create the Program -- Install MySqlConnector -- Create the Database -- Define Tables -- Create Data -- Fetch Data -- Summary -- Exercises -- Chapter 18 PostgreSQL in Python -- Install PostgreSQL -- Run pgAdmin -- Design the Database -- Create a User -- Create the Database -- Define the Tables -- Define the customers Table -- Define the orders Table -- Define the order_items Table -- Create the Program -- Install Psycopg -- Connect to the Database -- Delete Old Data.
505 8 $a Create Customer Data -- Create Order Data -- Create Order Item Data -- Close the Connection -- Perform Queries -- Summary -- Chapter 19 PostgreSQL in C# -- Create the Program -- Install Npgsql -- Connect to the Database -- Delete Old Data -- Create Customer Data -- Create Order Data -- Create Order Item Data -- Display Orders -- Summary -- Exercises -- Chapter 20 Neo4j AuraDB in Python -- Install Neo4j AuraDB -- Nodes and Relationships -- Cypher -- Create the Program -- Install the Neo4j Database Adapter -- Action Methods -- delete_all_nodes -- make_node -- make_link -- execute_node_query -- find_path -- Org Chart Methods -- build_org_chart -- query_org_chart -- Main Program -- Summary -- Chapter 21 Neo4j AuraDB in C# -- Create the Program -- Install the Neo4j Driver -- Action Methods -- DeleteAllNodes -- MakeNode -- MakeLink -- ExecuteNodeQuery -- FindPath -- Org Chart Methods -- BuildOrgChart -- QueryOrgChart -- Main -- Summary -- Chapter 22 MongoDB Atlas in Python -- Not Normal but Not Abnormal -- XML, JSON, and BSON -- Install MongoDB Atlas -- Find the Connection Code -- Create the Program -- Install the PyMongo Database Adapter -- Helper Methods -- person_string -- connect_to_db -- delete_old_data -- create_data -- query_data -- Main Program -- Summary -- Chapter 23 MongoDB Atlas in C# -- Create the Program -- Install the MongoDB Database Adapter -- Helper Methods -- PersonString -- DeleteOldData -- CreateData -- QueryData -- Main Program -- Summary -- Chapter 24 Apache Ignite in Python -- Install Apache Ignite -- Start a Node -- Without Persistence -- With Persistence -- Create the Program -- Install the pyignite Database Adapter -- Define the Building Class -- Save Data -- Read Data -- Demonstrate Volatile Data -- Demonstrate Persistent Data -- Summary -- Chapter 25 Apache Ignite in C# -- Create the Program.
505 8 $a Install the Ignite Database Adapter.
520 $a A concise introduction to database design concepts, methods, and techniques in and out of the cloud In the newly revised second edition of Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition, award-winning programming instructor and mathematician Rod Stephens delivers an easy-to-understand guide to designing and implementing databases both in and out of the cloud. Without assuming any prior database design knowledge, the author walks you through the steps you'll need to take to understand, analyze, design, and build databases. In the book, you'll find clear coverage of foundational database concepts along with hands-on examples that help you practice important techniques so you can apply them to your own database designs, as well as: Downloadable source code that illustrates the concepts discussed in the book Best practices for reliable, platform-agnostic database design Strategies for digital transformation driven by universally accessible database design An essential resource for database administrators, data management specialists, and database developers seeking expertise in relational, NoSQL, and hybrid database design both in and out of the cloud, Beginning Database Design Solutions is a hands-on guide ideal for students and practicing professionals alike.
588 $a Description based on print version record.
650 0 $a Database design. $3 184445
650 0 $a Cloud computing. $3 378527
830 0 $a Wrox programmer to programmer. $3 998154
856 4 0 $u https://onlinelibrary.wiley.com/doi/book/10.1002/9781394320646