Skip to main content
Disciplines
Automotive Business IT + Informatics Construction + Real Estate Electrical Engineering + Electronics Energy + Sustainability Insurance + Risk Finance + Banking Management + Leadership Marketing + Sales Mechanical Engineering + Materials
Events
DE
EN
Books
Journals
Topic Page
Marketing
Start single access now
Access for companies
EXTENDED SEARCH
Log in
Top
Published in:
Cover of the book

2019 | OriginalPaper | Chapter

1. Understand Relational Databases

Author : Jon Heller

Published in: Pro Oracle SQL Development

Publisher: Apress

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

Understanding the history and theory behind relational databases helps us make sense of things and avoid common traps. But there are also many times when we need to ignore the theory and build practical solutions. This book assumes you are already familiar with relational databases and SQL; the information provided here is not merely introductory, it is foundational.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

inform now
next chapter Create an Efficient Database Development Process
Footnotes
1
Codd, E. F. (1970). “A Relational Model of Data for Large Shared Data Banks.” Communications of the ACM. 13 (6): 377–387.
 
4
The Oracle manual lists its compliance with different standards, although I’m not sure why they bother: https://docs.oracle.com/cd/B19306_01/server.102/b14200/ap_standard_sql004.htm .
 
5
Joel Spolsky discusses this strategy here: www.joelonsoftware.com/2002/01/06/fire-and-motion/ .
 
6
“!” is the factorial operation. It can be used to calculate the number of ways to order N items. It is the product of all integers less than or equal to N. For example, 3! = 3 * 2 * 1 = 6. The numbers grow very rapidly, even faster than exponential growth. 4! = 24, 5! = 120, 6! = 720, etc. This operation will show up a few times throughout the book.
 
7
SQL was the second most used language on the Stack Overflow developer survey, https://insights.stackoverflow.com/survey/2017/#technology , and is in the top 5 for Stack Overflow questions when we combine the SQL tag with specific SQL implementations, https://stackoverflow.com/tags?tab=popular .
 
8
PL/SQL is consistently in the top 20 of this common programming language ranking: www.tiobe.com/tiobe-index/ .
 
9
The JOOQ blog makes a good argument that using Venn diagrams here is just plain wrong and that Venn diagrams can only accurately represent relational operations such as union, intersection, and difference. They may be right, but at the end of the day, whatever works for you is fine. https://blog.jooq.org/2016/07/05/say-no-to-venn-diagrams-when-explaining-joins/ .
 
Metadata
Title
Understand Relational Databases
Author
Jon Heller
Copyright Year
2019
Publisher
Apress
Book
Pro Oracle SQL Development

Print ISBN: 978-1-4842-4516-3

Electronic ISBN: 978-1-4842-4517-0

Copyright Year: 2019

DOI
https://doi.org/10.1007/978-1-4842-4517-0_1

Premium Partner

    Image Credits