Relational Theory for Computer Professionals. What Relational Databases Are Really All About
- Autor:
- C. J. Date
- Ocena:
- Bądź pierwszym, który oceni tę książkę
- Stron:
- 284
- Dostępne formaty:
-
ePubMobi
Opis ebooka: Relational Theory for Computer Professionals. What Relational Databases Are Really All About
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 so much better than what’s currently available.
With this unique book, you will:
- Learn how to see database systems as programming systems
- Get a careful, precise, and detailed definition of the relational model
- Explore a detailed analysis of SQL from a relational point of view
There are literally hundreds of books on relational theory or the SQL language or both. But this one is different. First, nobody is more qualified than Chris Date to write such a book. He and Ted Codd, inventor of the relational model, were colleagues for many years, and Chris’s involvement with the technology goes back to the time of Codd’s first papers in 1969 and 1970. Second, most books try to use SQL as a vehicle for teaching relational theory, but this book deliberately takes the opposite approach. Its primary aim is to teach relational theory as such. Then it uses that theory as a vehicle for teaching SQL, showing in particular how that theory can help with the practical problem of using SQL correctly and productively.
Any computer professional who wants to understand what relational systems are all about can benefit from this book. No prior knowledge of databases is assumed.
Wybrane bestsellery
-
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
-
This hands-on guide will help you learn various strategies for managing data integrity and data quality using effective frameworks, tools, and strategies. Get ready to explore a range of methods and solutions for finance projects and requirements.
Managing Data Integrity for Finance. Discover practical data quality management strategies for finance analysts and data professionals Managing Data Integrity for Finance. Discover practical data quality management strategies for finance analysts and data professionals
-
Explore the full potential of MongoDB 7.0 with this comprehensive guide that offers powerful techniques for efficient data manipulation, application integration, and security. This intermediate-to-advanced level book empowers you to harness the power of the latest version of MongoDB.
Mastering MongoDB 7.0. Achieve data excellence by unlocking the full potential of MongoDB - Fourth Edition Mastering MongoDB 7.0. Achieve data excellence by unlocking the full potential of MongoDB - Fourth Edition
Marko Aleksendrić, Arek Borucki, Leandro Domingues, Malak Abu Hammad, Elie Hannouch
-
Discover the multi-model capabilities of Redis Stack to work with JSON and hash documents and manage vectors for unstructured data modeling. Manage data flows and resolve data modeling problems through examples using popular programming languages.
Redis Stack for Application Modernization. Build real-time multi-model applications at any scale with Redis Redis Stack for Application Modernization. Build real-time multi-model applications at any scale with Redis
-
The book takes an objective, personalized and practical approach to designing the best database models while focusing on real-world examples and implementations with Google Cloud.
Database Design and Modeling with Google Cloud. Learn database design and development to take your data to applications, analytics, and AI Database Design and Modeling with Google Cloud. Learn database design and development to take your data to applications, analytics, and AI
-
This PostgreSQL book gets you up to speed with PostgreSQL 16. It helps you get quick solutions to all your basic and advanced DBA challenges with a hands-on approach that helps you resolve problems while understanding the reasoning
PostgreSQL 16 Administration Cookbook. Solve real-world Database Administration challenges with 180+ practical recipes and best practices PostgreSQL 16 Administration Cookbook. Solve real-world Database Administration challenges with 180+ practical recipes and best practices
Gianni Ciolli, Boriss Mejías, Jimmy Angelakos, Vibhor Kumar, Simon Riggs
C. J. Date - pozostałe książki
-
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 squar...
Type Inheritance and Relational Theory. Subtypes, Supertypes, and Substitutability Type Inheritance and Relational Theory. Subtypes, Supertypes, and Substitutability
(143.65 zł najniższa cena z 30 dni)143.65 zł
169.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%) -
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%) -
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)101.15 zł
119.00 zł(-15%)
Ebooka "Relational Theory for Computer Professionals. What Relational Databases Are Really All About" 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 "Relational Theory for Computer Professionals. What Relational Databases Are Really All About" 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 "Relational Theory for Computer Professionals. What Relational Databases Are Really All About" 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-493-6945-3, 9781449369453
- Data wydania ebooka:
- 2013-05-21 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:
- 1.9MB
- Rozmiar pliku Mobi:
- 4.5MB
Spis treści ebooka
- Relational Theory for Computer Professionals: What Relational Databases Are Really All About
- Dedication
- About the Author
- Preface
- Who Should Read This Book
- Structure of the Book
- Acknowledgments
- I. Foundations
- 1. Basic Database Concepts
- Whats a database?
- The Running Example
- Whats a database?
- Whats a DBMS?
- Data Independence
- Other DBMS Functions
- 1. Basic Database Concepts
- Whats a relational DBMS?
- Database systems vs. programming systems
- More on Types
- Exercises
- Answers
- 2. Relations and Relvars
- Relations
- Attributes
- Tuples
- Properties of Relations
- Relations
- Relvars
- Exercises
- Answers
- 3. Keys, Foreign Keys, and Related Matters
- Integrity constraints
- Keys
- Foreign keys
- Relvar definitions
- Loading the database
- Database systems vs. programming systems bis
- Exercises
- Answers
- 4. Relational Operators I
- Codds original algebra
- Restrict
- Project
- Closure Revisited
- Exercises I
- Answers I
- Union, intersection, and difference
- Union
- Intersection
- Difference
- Some Formal Properties
- Rename
- Exercises II
- Answers II
- Join
- Cartesian Product
- Intersection Revisited
- Primitive Operators
- Relational comparisons
- Update operator expansions
- Exercises III
- Answers III
- 5. Relational Operators II
- MATCHING and NOT MATCHING
- EXTEND
- Image relations
- Aggregation and summarization
- Summarization
- Explicit SUMMARIZE
- Generalized Restriction
- Exercises
- Answers
- 6. Constraints and Predicates
- Database constraints
- Relvar predicates
- Relations vs. Types
- Predicates vs. constraints
- Exercises
- Answers
- 7. The Relational Model
- The relational model defined
- Types
- The RELATION type generator
- Relation variables
- Relational assignment
- Relational operators
- Security
- Views
- Concluding remarks
- II. Transactions and Database Design
- 8. Transactions
- Whats a transaction?
- Recovery
- The Recovery Log
- The ACID Properties
- Concurrency
- Locking
- A remark on SQL
- Exercises
- Answers
- 8. Transactions
- 9. Database Design
- Nonloss decomposition
- Functional dependencies
- Irreducible FDs
- Second normal form
- Third normal form
- Boyce/Codd normal form
- Concluding remarks
- Exercises
- Answers
- III. SQL
- 10. SQL Tables
- A little history
- Basic concepts
- Properties of tables
- More on Terminology
- Table updates
- Equality comparisons
- Table definitions
- Table Literals
- 10. SQL Tables
- SQL systems vs. programming systems
- Exercises
- Answers
- 11. SQL Operators I
- Restrict
- Project
- Union, intersection, and difference
- Formal Properties
- Rename
- Exercises I
- Answers I
- Join
- Alternative Formulations
- Formal Properties
- Cartesian Product
- Evaluating table expressions
- Table comparisons
- Displaying results
- Exercises II
- Answers II
- 12. SQL Operators II
- MATCHING and NOT MATCHING
- EXTEND
- Image relations
- Aggregation and summarization
- Summarization
- Generalized Restriction
- Exercises
- Answers
- 13. SQL Constraints
- Database constraints
- Type constraints
- Exercises
- Answers
- 14. SQL vs. the Relational Model
- Some generalities
- Some SQL departures from the relational model
- Exercises
- Answers
- IV. Appendixes
- A. A Tutorial D Grammar
- Expressions
- Assignments
- A. A Tutorial D Grammar
- B. TABLE_DUM and TABLE_DEE
- C. Set Theory
- Whats a set?
- Subsets and supersets
- Exercises
- Answers
- Set operators
- Exercises
- Answers
- Some identities
- Exercises
- Answers
- The algebra of sets
- Cartesian product
- Concluding remarks
- D. Relational Calculus
- Sample queries
- Sample constraints
- A simplified grammar
- Exercises
- Answers
- E. A Guide to Further Reading
- Papers by E. F. Codd
- Books by C. J. Date
- Books by C. J. Date and Hugh Darwen
- Other Publications Related to SQL
- Miscellaneous
- Index
- About the Author
- Copyright
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...(177.65 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)
169.14 zł
199.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)
143.65 zł
169.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...(237.15 zł najniższa cena z 30 dni)
245.65 zł
289.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: Relational Theory for Computer Professionals. What Relational Databases Are Really All About 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.