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
-
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)76.30 zł
109.00 zł(-30%) -
Dzięki tej książce nauka zarządzania relacyjną bazą danych staje się łatwiejsza. Szczególnie docenią ją czytelnicy myślący o zmianie kariery zawodowej i rozpoczęciu pracy z obsługą danych. Opisano tu przede wszystkim podstawowe narzędzia SQL potrzebne do zrozumienia i wyodrębnienia przydatnych in...
SQL. Przewodnik dla początkujących. Jak zacząć efektywną pracę z danymi SQL. Przewodnik dla początkujących. Jak zacząć efektywną pracę z danymi
(35.40 zł najniższa cena z 30 dni)41.30 zł
59.00 zł(-30%) -
To trzecie, poprawione i zaktualizowane wydanie praktycznego przewodnika po języku SQL i relacyjnych bazach danych. Przemyślana, uporządkowana struktura podręcznika sprzyja sprawnemu nabywaniu wiedzy i doskonaleniu umiejętności — pracę z nim ułatwiają przystępny sposób prezentowania materia...(41.40 zł najniższa cena z 30 dni)
48.30 zł
69.00 zł(-30%) -
Cathy Tanimura jest analityczką danych z ponad dwudziestoletnim doświadczeniem. Odnosiła również sukcesy, budując zespoły do spraw analizy danych i tworząc potrzebną infrastrukturę. Zajmowała się także zarządzaniem zespołami w kilku czołowych firmach technologicznych. Od wielu lat używa języka SQ...
Analiza danych z wykorzystaniem SQL-a. Zaawansowane techniki przekształcania danych we wnioski Analiza danych z wykorzystaniem SQL-a. Zaawansowane techniki przekształcania danych we wnioski
(41.40 zł najniższa cena z 30 dni)48.30 zł
69.00 zł(-30%) -
This book provides a highly focused view of real business outcomes powered by data governance, that resonate with non-data executives such as CFOs and CEOs. You’ll also find useful insights into how to implement data governance initiatives.
Data Governance Handbook. A practical approach to building trust in data Data Governance Handbook. A practical approach to building trust in data
-
This book shows you how to use Apache Spark, Delta Lake, and Databricks to build data pipelines, manage and transform data, optimize performance, and more. Additionally, you’ll implement DataOps and DevOps practices, and orchestrate data workflows.
Data Engineering with Databricks Cookbook. Build effective data and AI solutions using Apache Spark, Databricks, and Delta Lake Data Engineering with Databricks Cookbook. Build effective data and AI solutions using Apache Spark, Databricks, and Delta Lake
-
This book will guide you through the fundamental and advanced features of the Snowpark framework in Python. You’ll learn how to use Snowpark for implementing workloads in the fields of data engineering, data science, and data applications.
The Ultimate Guide to Snowpark. Design and deploy Snowpark with Python for efficient data workloads The Ultimate Guide to Snowpark. Design and deploy Snowpark with Python for efficient data workloads
-
This report highlights the vital role of data quality in your data strategy, offering actionable steps to make it the foundation of your data culture, unlocking greater value and informed decisions in the evolving landscape of AI.
Data Quality in the Age of AI. Building a foundation for AI strategy and data culture Data Quality in the Age of AI. Building a foundation for AI strategy and data culture
-
Jeśli myślisz o karierze analityka danych albo starasz się o pracę na stanowisku, na którym będziesz analizować dane, ten kurs jest specjalnie dla Ciebie. Opanujesz dzięki niemu między innymi niezbędne podstawy języka SQL i dowiesz się, jak funkcjonuje i do czego może Ci posłużyć system zarządzan...
SQL dla analityków danych. Kurs video. Kompleksowe przygotowanie do pracy SQL dla analityków danych. Kurs video. Kompleksowe przygotowanie do pracy
(124.50 zł najniższa cena z 30 dni)161.84 zł
249.00 zł(-35%)
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
(123.28 zł najniższa cena z 30 dni)122.78 zł
149.00 zł(-18%) -
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
(122.23 zł najniższa cena z 30 dni)122.13 zł
149.00 zł(-18%) -
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
(139.22 zł najniższa cena z 30 dni)139.17 zł
169.00 zł(-18%) -
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
(39.41 zł najniższa cena z 30 dni)38.91 zł
49.90 zł(-22%) -
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
(96.98 zł najniższa cena z 30 dni)96.88 zł
119.00 zł(-19%) -
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
(114.05 zł najniższa cena z 30 dni)113.55 zł
139.00 zł(-18%) -
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)104.59 zł
119.00 zł(-12%)
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
-
Keeping up with the Python ecosystem can be daunting. Its developer tooling doesn't provide the out-of-the-box experience native to languages like Rust and Go. When it comes to long-term project maintenance or collaborating with others, every Python project faces the same problem: how to build re...(203.15 zł najniższa cena z 30 dni)
207.64 zł
239.00 zł(-13%) -
Bringing a deep-learning project into production at scale is quite challenging. To successfully scale your project, a foundational understanding of full stack deep learning, including the knowledge that lies at the intersection of hardware, software, data, and algorithms, is required.This book il...(237.15 zł najniższa cena z 30 dni)
249.75 zł
289.00 zł(-14%) -
Frontend developers have to consider many things: browser compatibility, usability, performance, scalability, SEO, and other best practices. But the most fundamental aspect of creating websites is one that often falls short: accessibility. Accessibility is the cornerstone of any website, and if a...(194.65 zł najniższa cena z 30 dni)
207.20 zł
239.00 zł(-13%) -
In this insightful and comprehensive guide, Addy Osmani shares more than a decade of experience working on the Chrome team at Google, uncovering secrets to engineering effectiveness, efficiency, and team success. Engineers and engineering leaders looking to scale their effectiveness and drive tra...(118.15 zł najniższa cena z 30 dni)
121.29 zł
149.00 zł(-19%) -
Data modeling is the single most overlooked feature in Power BI Desktop, yet it's what sets Power BI apart from other tools on the market. This practical book serves as your fast-forward button for data modeling with Power BI, Analysis Services tabular, and SQL databases. It serves as a starting ...(194.65 zł najniższa cena z 30 dni)
206.44 zł
239.00 zł(-14%) -
C# is undeniably one of the most versatile programming languages available to engineers today. With this comprehensive guide, you'll learn just how powerful the combination of C# and .NET can be. Author Ian Griffiths guides you through C# 12.0 and .NET 8 fundamentals and techniques for building c...(228.65 zł najniższa cena z 30 dni)
249.84 zł
289.00 zł(-14%) -
Learn how to get started with Futures Thinking. With this practical guide, Phil Balagtas, founder of the Design Futures Initiative and the global Speculative Futures network, shows you how designers and futurists have made futures work at companies such as Atari, IBM, Apple, Disney, Autodesk, Luf...(152.15 zł najniższa cena z 30 dni)
155.30 zł
179.00 zł(-13%) -
Augmented Analytics isn't just another book on data and analytics; it's a holistic resource for reimagining the way your entire organization interacts with information to become insight-driven.Moving beyond traditional, limited ways of making sense of data, Augmented Analytics provides a dynamic,...(181.25 zł najniższa cena z 30 dni)
181.15 zł
219.00 zł(-17%) -
Learn how to prepare for—and pass—the Kubernetes and Cloud Native Associate (KCNA) certification exam. This practical guide serves as both a study guide and point of entry for practitioners looking to explore and adopt cloud native technologies. Adrián González Sánchez ...
Kubernetes and Cloud Native Associate (KCNA) Study Guide Kubernetes and Cloud Native Associate (KCNA) Study Guide
(169.14 zł najniższa cena z 30 dni)177.65 zł
209.00 zł(-15%) -
Python is an excellent way to get started in programming, and this clear, concise guide walks you through Python a step at a time—beginning with basic programming concepts before moving on to functions, data structures, and object-oriented design. This revised third edition reflects the gro...(148.67 zł najniższa cena z 30 dni)
148.56 zł
179.00 zł(-17%)
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.