by Chris Date | Released February 2017 | ISBN: 9781491974209

The basic ideas of type inheritance—and the languages and products supporting those ideas—have been around for many years. However, those languages and products are typically quite ad hoc, and they all exhibit surprising—not to say undesirable—behavior on occasion. Why? Because there has never been any consensus on a well-defined type inheritance model on which such languages and products might be built. In this video seminar, internationally recognized relational database expert Chris Date describes a formal, abstract, rigorous, and robust alternative to this state of affairs by taking you through a detailed explanation of the inheritance model that he and his colleague Hugh Darwen first described in The Third Manifesto. Designed for data and database professionals, the course examines single and multiple inheritance; scalar, tuple, and relation inheritance; type lattices and union and intersection types; polymorphism and substitutability; compile time and run time binding; and a detailed discussion and analysis of inheritance as supported in the SQL standard. Explore and understand the inheritance model proposed in The Third ManifestoUnderstand why the model is necessary, its components, and its unifying characteristicsExamine alternative inheritance schemes and the pertinent features of the SQL standardEnjoy a rare opportunity to learn from one of the model's co-inventorsExamine the model in detailChris Date is an internationally known author, lecturer, researcher, and consultant, specializing in relational database technology. A Computing Industry Hall of Fame inductee, Chris is best known for his book An Introduction to Database Systems (8th edition, Addison-Wesley, 2004), which has sold more than 900,000 copies and is used in colleges and universities worldwide. In addition to the O'Reilly title Type Inheritance and Relational Theory: Subtypes, Supertypes, and Substitutability, Chris has authored more than twenty other O'Reilly titles including, SQL and Relational Theory, The New Relational Database Dictionary, and Relational Theory for Computer Professionals. Show and hide more Publisher resources View/Submit Errata

1. Background 00:26:47
2. Types Without Inheritance - Part 1 00:30:00
3. Types Without Inheritance - Part 2 00:28:12
4. Types With Inheritance 00:37:36
5. Basic Definitions 00:29:14
6. Scalar Values with Inheritance 00:14:44
7. Scalar Variables with Inheritance 00:31:18
8. Specialization by Constraint 00:24:46
9. Equality Comparisons and Dyadic Relational Operators 00:27:26
10. Treating and Type Testing 00:15:18
11. Substitutability - Part 1 00:19:19
12. Substitutability - Part 2 00:26:00
13. Union and Dummy Types 00:30:16
14. Interlude: The S by C Controversy 00:32:14
15. Multiple Inheritance - Part 1 00:31:27
16. Multiple Inheritance - Part 2 00:17:06
17. Multiple Inheritance - Part 3 00:23:06
18. Multiple Inheritance - Part 4 00:05:44
19. Tuple / Relation Values with Inheritance - Part 1 00:36:20
20. Tuple / Relation Values with Inheritance - Part 2 00:23:40
21. Tuple / Relation Maximal and Minimal Types - Part 3 00:15:30
22. Tuple / Relation Variables with Inheritance - Part 4 00:16:18
23. Structural Inheritance - Part 1 00:29:13
24. Structural Inheritance - Part 2 00:19:48
25. Structural Inheritance - Part 3 00:24:38
26. SQL - Part 1 00:27:20
27. SQL - Part 2 00:17:16
28. SQL - Part 3 00:27:50
29. SQL - Part 4 00:46:08
Show and hide more



9781491974216.type.inheritance.and.OR.part1.rar

9781491974216.type.inheritance.and.OR.part2.rar

9781491974216.type.inheritance.and.OR.part3.rar

9781491974216.type.inheritance.and.OR.part4.rar

9781491974216.type.inheritance.and.OR.part5.rar

9781491974216.type.inheritance.and.OR.part6.rar

9781491974216.type.inheritance.and.OR.part7.rar