Relational Theory for Computer Professionals. What Relational Databases Are Really All About

- Autor:
- C. J. Date
- Promocja Przejdź


- Ocena:
- Bądź pierwszym, który oceni tę książkę
- Stron:
- 284
- Dostępne formaty:
-
ePubMobi
Opis książki: 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
-
Jeżeli sięgniesz po tę książkę, będziesz mieć niepowtarzalną okazję błyskawicznego poznania jego potencjału. Na kolejnych stronach znajdziesz informacje na temat podstaw pracy z PL/SQL, a następnie przejdziesz do bardziej zaawansowanych zagadnień. Zdobędziesz wiedzę na temat struktur sterujących,...
Oracle Database 12c. Programowanie w języku PL/SQL Oracle Database 12c. Programowanie w języku PL/SQL
(0,00 zł najniższa cena z 30 dni)89.40 zł
149.00 zł(-40%) -
Znajdziesz tu klarowne, jasne informacje dotyczące kolejnych etapów projektowania oraz implementacji bazy danych, z podziałem na dwie odrębne metody — modelowanie i normalizację. Poznasz obszerne podstawy języka SQL — pojęcia, typy danych, składnię i całe zestawy poleceń — i na ...(0,00 zł najniższa cena z 30 dni)
20.94 zł
34.90 zł(-40%) -
Praktyczny przewodnik po podstawach SQL Database Rozszerz swoje umiejętności i samodzielnie poznaj podstawy platformy Microsoft Azure SQL Database. Jeśli jesteś doświadczonym projektantem oprogramowania lub specjalistą od baz danych, ale nowicjuszem w dziedzinie chmury Microsoft Azure lub SQL Dat...(0,00 zł najniższa cena z 30 dni)
83.16 zł
92.40 zł(-10%) -
There’s a lot of information about big data technologies, but splicing these technologies into an end-to-end enterprise data platform is a daunting task not widely covered. With this practical book, you’ll learn how to build big data infrastructure both on-premises and in the cloud an...
Architecting Modern Data Platforms. A Guide to Enterprise Hadoop at Scale Architecting Modern Data Platforms. A Guide to Enterprise Hadoop at Scale
(0,00 zł najniższa cena z 30 dni)296.65 zł
349.00 zł(-15%) -
This book teaches you everything you need to know to create stunning Vaadin applications for all your web development needs. Deep dive into advanced Vaadin concepts while creating your very own sample Vaadin application.
-
The infrastructure-as-code revolution in IT is also affecting database administration. With this practical book, developers, system administrators, and junior to mid-level DBAs will learn how the modern practice of site reliability engineering applies to the craft of database architecture and ope...
Database Reliability Engineering. Designing and Operating Resilient Database Systems Database Reliability Engineering. Designing and Operating Resilient Database Systems
(0,00 zł najniższa cena z 30 dni)169.15 zł
199.00 zł(-15%) -
Build data-intensive applications locally and deploy at scale using the combined powers of Python and Spark 2.0About This BookLearn why and how you can efficiently use Python to process data and build machine learning models in Apache Spark 2.0Develop and deploy efficient, scalable real-time Spar...
-
Wiedza statystyczna jest cenna dla przedstawicieli wszystkich zawodów, ponieważ przed podjęciem działań należy najpierw stawiać pytania, a następnie uzyskiwać właściwe informacje. W dzisiejszym świecie istnieje potrzeba myślenia statystycznego. Jesteśmy otoczeni wyzwaniami różnorodn...
Testy statystyczne w procesie podejmowania decyzji Testy statystyczne w procesie podejmowania decyzji
Czesław Domański, Dorota Pekasiewicz, Aleksandra Baszczyńska, Anna Witaszczyk
(0,00 zł najniższa cena z 30 dni)21.42 zł
25.20 zł(-15%) -
Get ready to unlock the power of your data. With the fourth edition of this comprehensive guide, youâ??ll learn how to build and maintain reliable, scalable, distributed systems with Apache Hadoop. This book is ideal for programmers looking to analyze datasets of any size, and for administra...
Hadoop: The Definitive Guide. Storage and Analysis at Internet Scale. 4th Edition Hadoop: The Definitive Guide. Storage and Analysis at Internet Scale. 4th Edition
(0,00 zł najniższa cena z 30 dni)220.15 zł
259.00 zł(-15%) -
With Bluetooth Low Energy (BLE), smart devices are about to become even smarter. This practical guide demonstrates how this exciting wireless technology helps developers build mobile apps that share data with external hardware, and how hardware engineers can gain easy and reliable access to mobil...
Getting Started with Bluetooth Low Energy. Tools and Techniques for Low-Power Networking Getting Started with Bluetooth Low Energy. Tools and Techniques for Low-Power Networking
(0,00 zł najniższa cena z 30 dni)126.65 zł
149.00 zł(-15%)
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
(152.15 zł najniższa cena z 30 dni)152.15 zł
179.00 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
(109.65 zł najniższa cena z 30 dni)109.65 zł
129.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
(135.15 zł najniższa cena z 30 dni)135.15 zł
159.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
(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
(152.15 zł najniższa cena z 30 dni)152.15 zł
179.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%) -
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
(109.65 zł najniższa cena z 30 dni)109.65 zł
129.00 zł(-15%)
Ebooka przeczytasz na:
-
czytnikach Inkbook, Kindle, Pocketbook 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 posłuchasz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolonych urządzeniach i aplikacjach obsługujących format MP3 (pliki spakowane w ZIP)
Masz pytania? Zajrzyj do zakładki Pomoc »
Kurs Video zobaczysz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolonych urządzeniach i aplikacjach obsługujących format MP4 (pliki spakowane w ZIP)
Szczegóły książki
- 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@helion.pl.
- Język publikacji:
- angielski
- Rozmiar pliku ePub:
- 1.9MB
- Rozmiar pliku Mobi:
- 1.9MB
- Kategorie:
Bazy danych
Spis treści książki
- 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
-
FinOps brings financial accountability to the variable spend model of cloud. Used by the majority of global enterprises, this management practice has grown from a fringe activity to the de facto discipline managing cloud spend. In this book, authors J.R. Storment and Mike Fuller outline the proce...(0,00 zł najniższa cena z 30 dni)
262.65 zł
309.00 zł(-15%) -
Edge AI is transforming the way computers interact with the real world, allowing IoT devices to make decisions using the 99% of sensor data that was previously discarded due to cost, bandwidth, or power limitations. With techniques like embedded machine learning, developers can capture human intu...(0,00 zł najniższa cena z 30 dni)
262.65 zł
309.00 zł(-15%) -
Why is it difficult for so many companies to get digital identity right? If you're still wrestling with even simple identity problems like modern website authentication, this practical book has the answers you need. Author Phil Windley provides conceptual frameworks to help you make sense of all ...(0,00 zł najniższa cena z 30 dni)
186.15 zł
219.00 zł(-15%) -
Python was recently ranked as today's most popular programming language on the TIOBE index, thanks to its broad applicability to design and prototyping to testing, deployment, and maintenance. With this updated fourth edition, you'll learn how to get the most out of Python, whether you're a profe...(0,00 zł najniższa cena z 30 dni)
296.65 zł
349.00 zł(-15%) -
With the accelerating speed of business and the increasing dependence on technology, companies today are significantly changing the way they build in-house business solutions. Many now use low-code and no code technologies to help them deal with specific issues, but that's just the beginning. Wit...
Building Solutions with the Microsoft Power Platform Building Solutions with the Microsoft Power Platform
(0,00 zł najniższa cena z 30 dni)262.65 zł
309.00 zł(-15%) -
Companies are scrambling to integrate AI into their systems and operations. But to build truly successful solutions, you need a firm grasp of the underlying mathematics. This accessible guide walks you through the math necessary to thrive in the AI field such as focusing on real-world application...(0,00 zł najniższa cena z 30 dni)
262.65 zł
309.00 zł(-15%) -
DevOps engineers, developers, and security engineers have ever-changing roles to play in today's cloud native world. In order to build secure and resilient applications, you have to be equipped with security knowledge. Enter security as code.In this book, authors BK Sarthak Das and Virginia Chu d...(0,00 zł najniższa cena z 30 dni)
186.15 zł
219.00 zł(-15%) -
With the increasing use of AI in high-stakes domains such as medicine, law, and defense, organizations spend a lot of time and money to make ML models trustworthy. Many books on the subject offer deep dives into theories and concepts. This guide provides a practical starting point to help develop...(0,00 zł najniższa cena z 30 dni)
262.65 zł
309.00 zł(-15%) -
Why are so many companies adopting GitOps for their DevOps and cloud native strategy? This reliable framework is quickly becoming the standard method for deploying apps to Kubernetes. With this practical, developer-oriented book, DevOps engineers, developers, IT architects, and SREs will learn th...(0,00 zł najniższa cena z 30 dni)
262.65 zł
309.00 zł(-15%) -
Learn the essentials of working with Flutter and Dart to build full stack applications that meet the needs of a cloud-driven world. Together, the Flutter open source UI software development kit and the Dart programming language for client development provide a unified solution to building applica...(0,00 zł najniższa cena z 30 dni)
220.15 zł
259.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.
W przypadku usługi "Druk na żądanie" termin dostarczenia przesyłki może obejmować także czas potrzebny na dodruk (do 10 dni roboczych)
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.


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.