Type Inheritance and Relational Theory. Subtypes, Supertypes, and Substitutability
- Autor:
- C. J. Date
- Ocena:
- Bądź pierwszym, który oceni tę książkę
- Stron:
- 572
- Dostępne formaty:
-
ePubMobi
Opis ebooka: Type Inheritance and Relational Theory. Subtypes, Supertypes, and Substitutability
Type inheritance is that phenomenon according to which we can say, for example, that every square is also a rectangle, and so properties that apply to rectangles in general apply to squares in particular. In other words, squares are a subtype of rectangles, and rectangles are a supertype of squares. Recognizing and acting upon such subtype / supertype relationships provides numerous benefits: Certainly it can help in data modeling, and it can also provide for code reuse in applications. For these reasons, many languages, including the standard database language SQL, have long supported such relationships. However, there doesn’t seem to be any consensus in the community at large on a formal, rigorous, and abstract model of inheritance. This book proposes such a model, one that enjoys several advantages over other approaches, not the least of which it is that it’s fully compatible with the well known relational model of data.
Topics the model covers include:
- Both 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
All of these topics are described in detail in the book, with numerous illustrative examples, exercises, and answers. The book also discusses several alternative approaches. In particular, it includes a detailed discussion and analysis of inheritance as supported in the SQL standard.
Wybrane bestsellery
-
Firmy z branży IT prześcigają się w tworzeniu rozwiązań zwiększających wydajność pracy, jak również podnoszących poziom specjalizacji pracowników w określonych dziedzinach. Od kilku już lat pozycja full stack developera, który wykonywał wszystkie prace programistyczne, jest wielką rzadkością. Obe...
Postman i SQL. Kurs video. Metody testowania REST API i przeszukiwania baz danych Postman i SQL. Kurs video. Metody testowania REST API i przeszukiwania baz danych
(39.90 zł najniższa cena z 30 dni)79.49 zł
159.00 zł(-50%) -
Ta książka stanowi świetne wprowadzenie do analizy danych. Dzięki niej nauczysz się korzystać z surowych danych, nawet jeśli nie masz odpowiedniego doświadczenia. Zaczniesz od formułowania hipotez i generowania statystyk opisowych, a następnie przystąpisz do pisania zapytań w języku SQL w celu ag...
SQL dla analityków danych. Opanuj możliwości SQL-a, aby wydobywać informacje z danych. Wydanie III SQL dla analityków danych. Opanuj możliwości SQL-a, aby wydobywać informacje z danych. Wydanie III
(65.40 zł najniższa cena z 30 dni)70.85 zł
109.00 zł(-35%) -
Ten przystępny przewodnik jest przeznaczony dla analityków danych, którzy chcą dobrze poznać proces tworzenia analitycznego zbioru danych i samodzielnie pisać kod niezbędny do uzyskania zamierzonego wyniku. Przedstawiono w nim składnię języka SQL oraz zasady budowania szybko działających zapytań ...
SQL dla analityków danych. Tworzenie zbiorów danych dla początkujących SQL dla analityków danych. Tworzenie zbiorów danych dla początkujących
(41.40 zł najniższa cena z 30 dni)44.85 zł
69.00 zł(-35%) -
Relacyjne bazy danych są wszędzie wokół nas, a do podstawowych umiejętności wymaganych od współczesnych programistów należy dobra znajomość języka SQL. Na świecie nie ma jednak osób, którym nie zdarza się czegoś zapomnieć. Jeśli potrzebujesz pomocy w codziennej pracy lub chcesz odświeżyć wiedzę n...(6.90 zł najniższa cena z 30 dni)
8.49 zł
17.00 zł(-50%) -
This practical guide to implementing DeFi in your projects guides you through building full-stack DeFi solutions with popular tools and teaches you how to leverage blockchain technologies to manage crypto assets.
Building Full Stack DeFi Applications. A practical guide to creating your own decentralized finance projects on blockchain Building Full Stack DeFi Applications. A practical guide to creating your own decentralized finance projects on blockchain
-
The Definitive Guide to Data Integration is for data eclectics looking to explore the modern data stack. Complete with practical examples and insights, it covering tools, techniques, and best practices to unleash your data's potential.
The Definitive Guide to Data Integration. Unlock the power of data integration to efficiently manage, transform, and analyze data The Definitive Guide to Data Integration. Unlock the power of data integration to efficiently manage, transform, and analyze data
Pierre-Yves BONNEFOY, Emeric CHAIZE, Raphaël MANSUY, Mehdi TAZI, Stephane Heckel
-
Learn T-SQL Querying, Second Edition, is an up-to-date reference designed to help you write more efficient T-SQL code to perform simple-to-advanced tasks for data management and data analysis tasks.
Learn T-SQL Querying. A guide to developing efficient and elegant T-SQL code - Second Edition Learn T-SQL Querying. A guide to developing efficient and elegant T-SQL code - Second Edition
-
With the help of well-structured and practical recipes, this book will teach you how to integrate data from the cloud and on-premises. You’ll learn how to transform, clean, and consolidate data into a single data platform and get to grips with ADF
Azure Data Factory Cookbook. Build ETL, Hybrid ETL, and ELT pipelines using ADF, Synapse Analytics, Fabric and Databricks - Second Edition Azure Data Factory Cookbook. Build ETL, Hybrid ETL, and ELT pipelines using ADF, Synapse Analytics, Fabric and Databricks - Second Edition
Dmitry Foshin, Tonya Chernyshova, Dmitry Anoshin, Xenia Ireton
-
Learn new techniques to ingest, transform, merge, and deliver trusted data to downstream users using modern cloud data architectures and Scala, and learn end-to-end data engineering that will make you the most valuable asset on your data team.
Data Engineering with Scala and Spark. Build streaming and batch pipelines that process massive amounts of data using Scala Data Engineering with Scala and Spark. Build streaming and batch pipelines that process massive amounts of data using Scala
C. J. Date - pozostałe książki
-
SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put that theory into practice. In this book, Chris Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you c...
SQL and Relational Theory. How to Write Accurate SQL Code. 3rd Edition SQL and Relational Theory. How to Write Accurate SQL Code. 3rd Edition
(126.65 zł najniższa cena z 30 dni)126.65 zł
149.00 zł(-15%) -
All of today’s mainstream database products support the SQL language, and relational theory is what SQL is supposed to be based on. But are those products truly relational? Sadly, the answer is no. This book shows you what a real relational product would be like, and how and why it would be...
Relational Theory for Computer Professionals. What Relational Databases Are Really All About Relational Theory for Computer Professionals. What Relational Databases Are Really All About
(126.65 zł najniższa cena z 30 dni)126.65 zł
149.00 zł(-15%) -
What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in wa...
Database Design and Relational Theory. Normal Forms and All That Jazz Database Design and Relational Theory. Normal Forms and All That Jazz
(143.65 zł najniższa cena z 30 dni)143.65 zł
169.00 zł(-15%) -
Avoid misunderstandings that can affect the design, programming, and use of database systems. Whether you're using Oracle, DB2, SQL Server, MySQL, or PostgreSQL, The Relational Database Dictionary will prevent confusion about the precise meaning of database-related terms (e.g., attribute, 3NF, on...
The Relational Database Dictionary. A Comprehensive Glossary of Relational Terms and Concepts, with Illustrative Examples The Relational Database Dictionary. A Comprehensive Glossary of Relational Terms and Concepts, with Illustrative Examples
(42.42 zł najniższa cena z 30 dni)42.42 zł
49.90 zł(-15%) -
No matter what DBMS you are using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can always arise over the precise meanings of terms, misunderstandings that can have a serious effect on the success of your database projects. For example, here are some common database ter...
The New Relational Database Dictionary. Terms, Concepts, and Examples The New Relational Database Dictionary. Terms, Concepts, and Examples
(101.15 zł najniższa cena z 30 dni)101.15 zł
119.00 zł(-15%) -
Views are virtual tables. That means they should be updatable, just as "real" or base tables are. In fact, view updatability isn’t just desirable, it’s crucial, for practical reasons as well as theoretical ones. But view updating has always been a controversial topic. Ever since the r...
View Updating and Relational Theory. Solving the View Update Problem View Updating and Relational Theory. Solving the View Update Problem
(118.15 zł najniższa cena z 30 dni)118.15 zł
139.00 zł(-15%) -
This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world today. Database in Depth: The Relational Model for Practitioners goes beyond the hype and gets to...
Database in Depth. Relational Theory for Practitioners Database in Depth. Relational Theory for Practitioners
(101.15 zł najniższa cena z 30 dni)109.65 zł
129.00 zł(-15%)
Ebooka "Type Inheritance and Relational Theory. Subtypes, Supertypes, and Substitutability" przeczytasz na:
-
czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
-
systemach Windows, MacOS i innych
-
systemach Windows, Android, iOS, HarmonyOS
-
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi
Masz pytania? Zajrzyj do zakładki Pomoc »
Audiobooka "Type Inheritance and Relational Theory. Subtypes, Supertypes, and Substitutability" posłuchasz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolnych urządzeniach i aplikacjach obsługujących format MP3 (pliki spakowane w ZIP)
Masz pytania? Zajrzyj do zakładki Pomoc »
Kurs Video "Type Inheritance and Relational Theory. Subtypes, Supertypes, and Substitutability" zobaczysz:
-
w aplikacjach Ebookpoint i Videopoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych z dostępem do najnowszej wersji Twojej przeglądarki internetowej
Szczegóły ebooka
- ISBN Ebooka:
- 978-14-919-5994-7, 9781491959947
- Data wydania ebooka:
- 2016-09-08 Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- angielski
- Rozmiar pliku ePub:
- 17.0MB
- Rozmiar pliku Mobi:
- 35.2MB
Spis treści ebooka
- Cover Page
- Title Page
- Copyright Page
- About the Author
- Contents
- Preface
- Foreword
- Part I: Preliminaries
- Chapter 1: Background
- Inheritance arises naturally
- A fundamental concept
- The suppliers-and-parts database
- A little history
- Exercises
- Answers
- Chapter 1: Background
- Chapter 2: Types without Inheritance
- Values vs. variables
- Whats a type?
- Scalar vs. nonscalar types
- Types vs. representations
- The TYPE statement
- Operators
- Type generators
- Miscellaneous issues
- Concluding remarks
- Exercises
- Answers
- Chapter 3: Types with Inheritance
- Why inheritance?
- Toward a model of inheritance
- Single vs. multiple inheritance
- Scalars, tuples, and relations
- The running example
- More terminology
- Substitutability
- A BNF grammar
- More terminology bis
- Concluding remarks
- Exercises
- Answers
- Chapter 4: The Inheritance Model
- The IM prescriptions
- Part II: Scalar Types, Single Inheritance
- Chapter 5: Basic Definitions
- IM Prescription 1: Types are sets
- IM Prescription 2: Subtypes are subsets
- IM Prescription 3: Subtype of is reflexive
- IM Prescription 4: Subtype of is transitive
- IM Prescription 5: Proper and immediate subtypes and supertypes
- IM Prescription 6: Scalar root and leaf types
- IM Prescription 7: Disjoint and overlapping types
- Exercises
- Answers
- Chapter 5: Basic Definitions
- Chapter 6: Scalar Values with Inheritance
- IM Prescription 8: Common subtypes and supertypes
- Common subtypes
- Common supertypes
- Intersection types vs. union types
- Concluding remarks
- Exercises
- Answers
- Chapter 7: Scalar Variables with Inheritance
- IM Prescription 9: Model of a scalar variable
- Inclusion polymorphism
- Implementation versions
- Code reuse
- Overloading polymorphism
- Substitutability
- Exercises
- Answers
- Chapter 8: Specialization by Constraint etc.
- IM Prescription 10: Specialization by constraint
- Specialization constraints
- Specialization by constraint
- IM Prescription 11: Assignment with inheritance
- Generalization by constraint
- Concluding remarks
- Exercises
- Answers
- Chapter 9: Equality Comparisons etc.
- IM Prescription 12: Equality with inheritance
- IM Prescription 13: Join etc. with inheritance
- Equivalence of expressions
- Exercises
- Answers
- Chapter 10: Treating and Type Testing
- IM Prescription 14: TREAT
- IM Prescription 15: Type testing
- Exercises
- Answers
- Chapter 11: Substitutability
- IM Prescription 16: Value substitutability
- IM Prescription 17: Operator signatures
- IM Prescription 18: Read-only parameters to update operators
- IM Prescription 19: Variable substitutability
- Exercises
- Answers
- Chapter 12: Union and Dummy Types
- IM Prescription 20: Union and dummy types etc.
- Union types
- Dummy types
- Types alpha and omega
- Exercises
- Answers
- Chapter 13: Interlude: The S by C Controversy
- The three out of four rule
- What does inheritance really mean?
- Benefits of S by C
- What about objects?
- Some implementation considerations
- Postscript: A note on foreign keys
- Part III: Scalar Types, Multiple Inheritance
- Chapter 14: An Overview of Multiple Inheritance
- The running example
- Possible representations
- Possible representations continued
- Operators
- Type graphs
- Two remarks on operator inheritance
- IM Prescriptions 1-7 revisited
- Type definitions
- Exercises
- Answers
- Chapter 14: An Overview of Multiple Inheritance
- Chapter 15: IM Prescriptions 8 - 9 Revisited
- Least specific common subtypes
- Most specific types
- Leaf types
- Most specific common supertypes
- Overlapping regular types
- An extended example
- Model of a scalar variable
- Exercises
- Answers
- Chapter 16: IM Prescriptions 10 - 20 Revisited
- IM Prescriptions 10-15
- IM Prescriptions 16-20
- Exercises
- Answers
- Part IV: Tuple and Relation Inheritance
- Chapter 17: Tuple / Relation Values with Inheritance
- Tuple / relation prescriptions
- IM Prescription 21: Empty types
- IM Prescription 22: Tuple / relation subtypes and supertypes
- IM Prescription 23: Proper and immediate tuple / relation subtypes and supertypes
- Exercises
- Answers
- Chapter 17: Tuple / Relation Values with Inheritance
- Chapter 18: Tuple / Relation Values with Inheritance (cont.)
- IM Prescription 24: Common tuple / relation subtypes and supertypes
- Common tuple subtypes
- Common tuple supertypes
- Common relation subtypes
- Common relation supertypes
- Closing remarks
- Exercises
- Answers
- Chapter 19: Tuple / Relation Maximal and Minimal Types etc.
- IM Prescription 25: Tuple / relation maximal and minimal types
- IM Prescription 26: Tuple / relation root and leaf types
- Exercises
- Answers
- Chapter 20: Tuple / Relation Variables with Inheritance
- IM Prescription 27: Tuple / relation most specific types
- IM Prescription 28: Model of a tuple / relation variable
- IM Prescriptions 11-15 revisited
- Exercises
- Answers
- Part V: Other Approaches
- Chapter 21: Structural Inheritance
- An introductory example
- Tuple types, values, and variables
- Subtables and supertables
- Scalar types revisited
- Structural inheritance for scalar types using the Manifesto model
- Postscript: A survey of the literature
- Exercises
- Answers
- Chapter 21: Structural Inheritance
- Chapter 22: Inheritance in SQL
- SQL scalar types without inheritance
- SQL nonscalar types without inheritance
- The SQL approach to inheritance
- Appendixes
- Appendix A: Encapsulation Is a Red Herring
- What does encapsulation mean?
- But what about ad hoc query?
- We dont always want encapsulation
- Scalar vs. nonscalar types
- Summary
- Appendix A: Encapsulation Is a Red Herring
- Appendix B: Persistence Not Orthogonal to Type
- POTT violates data independence
- POTT causes additional complexity
- Concluding remarks
- Postscript: The first and second manifestos
- Appendix C Glossary of Terms
- Footnotes
- Preface
- Chapter 1: Background
- Chapter 2: Types without Inheritance
- Chapter 3: Types with Inheritance
- Chapter 5: Basic Definitions
- Chapter 6: Scalar Values with Inheritance
- Chapter 7: Scalar Variables with Inheritance
- Chapter 8: Specialization by Constraint etc.
- Chapter 9: Equality Comparisons etc.
- Chapter 10: Treating and Type Testing
- Chapter 11: Substitutability
- Chapter 12: Union and Dummy Types
- Chapter 13: Interlude: The S by C Controversy
- Chapter 14: An Overviewof Multiple Inheritance
- Chapter 15: IM Prescriptions 89 Revisited
- Chapter 16: IM Prescriptions 1020 Revisited
- Chapter 17: Tuple/Relation Values with Inheritance
- Chapter 18: Tuple / Relation Valueswith Inheritance (cont.)
- Chapter 19: Tuple / Relation Maximaland Minimal Typesetc.
- Chapter 20: Tuple / Relation Variables with Inheritance
- Chapter 21: Structural Inheritance
- Chapter 22: Inheritance in SQL
- Appendix A: Encapsulation Isa Red Herring
- Appendix B: Persistence Not Orthogonal to Type
- Index
- Type Inheritance and Relational Theory
O'Reilly Media - inne książki
-
JavaScript gives web developers great power to create rich interactive browser experiences, and much of that power is provided by the browser itself. Modern web APIs enable web-based applications to come to life like never before, supporting actions that once required browser plug-ins. Some are s...(186.15 zł najniższa cena z 30 dni)
186.15 zł
219.00 zł(-15%) -
How will software development and operations have to change to meet the sustainability and green needs of the planet? And what does that imply for development organizations? In this eye-opening book, sustainable software advocates Anne Currie, Sarah Hsu, and Sara Bergman provide a unique overview...(160.65 zł najniższa cena z 30 dni)
177.65 zł
209.00 zł(-15%) -
OpenTelemetry is a revolution in observability data. Instead of running multiple uncoordinated pipelines, OpenTelemetry provides users with a single integrated stream of data, providing multiple sources of high-quality telemetry data: tracing, metrics, logs, RUM, eBPF, and more. This practical gu...(143.65 zł najniższa cena z 30 dni)
152.15 zł
179.00 zł(-15%) -
Interested in developing embedded systems? Since they don't tolerate inefficiency, these systems require a disciplined approach to programming. This easy-to-read guide helps you cultivate good development practices based on classic software design patterns and new patterns unique to embedded prog...(152.15 zł najniższa cena z 30 dni)
160.65 zł
189.00 zł(-15%) -
If you use Linux in your day-to-day work, then Linux Pocket Guide is the perfect on-the-job reference. This thoroughly updated 20th anniversary edition explains more than 200 Linux commands, including new commands for file handling, package management, version control, file format conversions, an...(92.65 zł najniższa cena z 30 dni)
101.15 zł
119.00 zł(-15%) -
Gain the valuable skills and techniques you need to accelerate the delivery of machine learning solutions. With this practical guide, data scientists, ML engineers, and their leaders will learn how to bridge the gap between data science and Lean product delivery in a practical and simple way. Dav...(245.65 zł najniższa cena z 30 dni)
254.15 zł
299.00 zł(-15%) -
This practical book provides a detailed explanation of the zero trust security model. Zero trust is a security paradigm shift that eliminates the concept of traditional perimeter-based security and requires you to "always assume breach" and "never trust but always verify." The updated edition off...(203.15 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%) -
Decentralized finance (DeFi) is a rapidly growing field in fintech, having grown from $700 million to $100 billion over the past three years alone. But the lack of reliable information makes this area both risky and murky. In this practical book, experienced securities attorney Alexandra Damsker ...(203.15 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%) -
Whether you're a startup founder trying to disrupt an industry or an entrepreneur trying to provoke change from within, your biggest challenge is creating a product people actually want. Lean Analytics steers you in the right direction.This book shows you how to validate your initial idea, find t...(126.65 zł najniższa cena z 30 dni)
126.65 zł
149.00 zł(-15%) -
When it comes to building user interfaces on the web, React enables web developers to unlock a new world of possibilities. This practical book helps you take a deep dive into fundamental concepts of this JavaScript library, including JSX syntax and advanced patterns, the virtual DOM, React reconc...(194.65 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%)
Dzieki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka, którą chcesz zamówić pochodzi z końcówki nakładu. Oznacza to, że mogą się pojawić drobne defekty (otarcia, rysy, zagięcia).
Co powinieneś wiedzieć o usłudze "Końcówka nakładu":
- usługa obejmuje tylko książki oznaczone tagiem "Końcówka nakładu";
- wady o których mowa powyżej nie podlegają reklamacji;
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka drukowana
Oceny i opinie klientów: Type Inheritance and Relational Theory. Subtypes, Supertypes, and Substitutability C. J. Date (0) Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.