Class Hierarchies with SQL

Explore how to model class hierarchies and inheritance in databases for front-end apps using plain JavaScript. Understand SQL standards, key-value storage, and three common inheritance mapping approaches with practical examples.

We'll cover the following...

Alternative approaches

A standard DBMS stores information, such as objects, in the rows of the tables, conceived as set-theoretic relations in classical relational database systems. The relational database language SQL is used to define, populate, update, and query these kinds of databases. However, there are also simpler data storage techniques that don’t support SQL, but allow us to store data in table rows. For example, key-value storage systems, such as JavaScript’s Local Storage API, allow us to store a serialization of a JavaScript entity table as a key. This serialization, which is a map of entity records, is saved as a string value associated with the table name.

While there is no support for subtyping and inheritance in the classical version of SQL ...

1.Introduction

2.The Foundations of Web Apps

3.Javascript Fundamentals

4.Building a Minimal Web App with Plain JS in Seven Steps

5.Integrity Constraints and Data Validation

6.Constraint Validation in Plain JS

7.Enumerations

8.Enumeration Attributes in Plain JS

9.Reference Properties and Unidirectional Associations

10.Implementing Unidirectional Functional Associations

11.Implementing Unidirectional Non-Functional Associations

12.Bidirectional Associations

13.Implementing Bidirectional Associations

14.Subtyping and Inheritance

15.Subtyping with Plain JS

16.Conclusion

Class Hierarchies with SQL