{"id":1138,"date":"2025-01-13T20:25:21","date_gmt":"2025-01-14T01:25:21","guid":{"rendered":"https:\/\/pressbooks.bccampus.ca\/nelson\/chapter\/chapter-8-implementation\/"},"modified":"2025-01-13T20:43:26","modified_gmt":"2025-01-14T01:43:26","slug":"chapter08thirdedition","status":"publish","type":"chapter","link":"https:\/\/pressbooks.bccampus.ca\/nelson\/chapter\/chapter08thirdedition\/","title":{"raw":"Chapter 8 Implementation","rendered":"Chapter 8 Implementation"},"content":{"raw":"
\r\n

Original Chapter 13 Author: Adrienne Watt<\/p>\r\n

Rewrite: Fred Strickland<\/p>\r\n\r\n

Learning Outcomes<\/h2>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

Computing Sub Discipline<\/strong><\/p>\r\n<\/td>\r\n

\r\n

Document Code, Reference Code, and Page Number<\/strong><\/p>\r\n<\/td>\r\n

\r\n

Text<\/strong><\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Computer Science<\/p>\r\n<\/td>\r\n

\r\n

CS2023<\/p>\r\n

DM-NoSQL: NoSQL Systems<\/p>\r\n

(Pages 120-121)<\/p>\r\n

<\/p>\r\n<\/td>\r\n

\r\n

KA Core 1. Why NoSQL? (e.g., Impedance mismatch between Application [CRUD] and RDBMS)<\/p>\r\n

KA Core 2. Key-Value and Document data model<\/p>\r\n

Non-core 5. Graph Databases<\/p>\r\n

Non-core 3. Storage systems (e.g., Key-Value systems, Data Lakes)<\/p>\r\n

ILO KA Core 1. Develop a use case for the use of NoSQL over RDBMS<\/p>\r\n

ILO KA Core 2. Describe the defining characteristics behind Key-Value and Document-based data models<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Data Science<\/p>\r\n<\/td>\r\n

\r\n

DS2021<\/p>\r\n

Data Mining (DM)<\/p>\r\n

DM-Information Retrieval -- T2<\/p>\r\n

(Pages 80-81)<\/p>\r\n<\/td>\r\n

\r\n

Students need to have knowledge of<\/p>\r\n\r\n

    \r\n \t
  • Various relational, non-relational, and other database formats.<\/li>\r\n<\/ul>\r\n<\/td>\r\n<\/tr>\r\n
\r\n

Information Systems<\/p>\r\n<\/td>\r\n

\r\n

IS2020<\/p>\r\n

A3.2 Data \/ Information Competency Realm<\/p>\r\n

A3.2.1 Competency Area \u2013 Data \/ Information Management<\/p>\r\n

(Page 5)<\/p>\r\n<\/td>\r\n

\r\n

5. Compare tradeoffs of different concurrency modes (Page 103)<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Information Technology<\/p>\r\n<\/td>\r\n

\r\n

IT2017<\/p>\r\n

ITE-IMA-05 Data organization architecture<\/p>\r\n

(Page 92)<\/p>\r\n<\/td>\r\n

\r\n

b. Contrast and compare relational databases concepts and non-relational databases including object-oriented, XML, NewSQL and NoSQL databases.<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

IT2017<\/p>\r\n

ITE-IMA-06 Special purpose databases<\/p>\r\n

(Page 92)<\/p>\r\n<\/td>\r\n

\r\n

a. Describe major concepts of object oriented, XML, NewSQL, and NoSQL databases.<\/p>\r\n<\/td>\r\n<\/tr>\r\n

<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

Introduction to Chapter 8<\/h2>\r\n

Chapter 6 addressed the mechanisms for preventing bad or duplicate data from being entered into a database. We looked at integrity rules, constraints, and cardinality for ensuring the high quality of the data. From the \u201cseat of the pants,\u201d we figured out what tables we might need. What if you are starting with no suggestions and with no guidance? Chapter 7 provided the tools for dividing a \u201cmonster\u201d spreadsheet into a collection of workable database tables.<\/p>\r\n

The second edition\u2019s Chapter 13 used the software development life cycle to explain how to create a database. This edition placed those concepts throughout the early chapters. This chapter will look at the selection of a database management system.<\/p>\r\n\r\n

The Third Edition Style Guide<\/h2>\r\n

This is the style guide that this book will follow for this chapter and for the other chapters.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

Naming Convention:<\/p>\r\n\r\n

    \r\n \t
  • All English names<\/li>\r\n \t
  • Plural table names<\/li>\r\n \t
  • Singular column names<\/li>\r\n \t
  • Capitalized words<\/li>\r\n \t
  • Pascal Case for composite names<\/li>\r\n \t
  • No underscores or special characters<\/li>\r\n \t
  • No unique SQL commands<\/li>\r\n \t
  • No object prefixes<\/li>\r\n<\/ul>\r\n

    Using the IE\u2019s Notation with Crow\u2019s Foot Notation.<\/p>\r\n<\/td>\r\n<\/tr>\r\n

<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

Figure 8.1 The database style guide. Adapted from https:\/\/vertabelo.com\/blog\/database-schema-naming-conventions\/<\/p>\r\n\r\n

Selecting the Best Database Management System<\/h2>\r\n

Our interest is in the situation where a client is interacting with data in a DBMS. We are not interested in a real-time DBMS1<\/a><\/sup>, which is beyond the scope of this chapter.<\/p>\r\n

There are various websites that provide reviews of DBMS. Capterra\u2019s website lists 410 products. You can sort the list in various ways:<\/p>\r\n\r\n