Leanpub Header

Skip to main content
Go to Leanpub.comLeanpub

The Oracle database in modern IT architectures

Intelligent Persistence for applications, microservices, business processes, data analytics, documents and more

Peter de Vaal

Wondered why you should still use a relational database such as Oracle? Any reason why you should not go for noSQL databases such as MongoDB or Cassandra? Want to find the best way to fit the relational database into an object oriented framework or a javascript based front-end application? This is the book that answers your questions.

The author is letting you choose the price you pay for this book!

Pick Your Price...
PDF
EPUB
WEB
About

About

About the Book

As the number one relational database Oracle has had a prominent role in many IT applications over the past decades. Although other technologies emerged, such as NoSQL databases, document databases and object databases, the relational database still survives as the better solution in most cases. This book discusses best practices for using the Oracle database for different purposes.

Share this book

Categories

OracleAPIsSoftware ArchitectureSystem Integration

Feedback

Email the author

Price

Pick Your Price...

Minimum price

$27.99

$27.99

You pay

$27.99

Author earns

$22.39
$

All prices are in US $. You can pay in US $ or in your local currency when you check out.

EU customers: prices exclude VAT, which is added during checkout.

...Or Buy With Credits!

Number of credits (Minimum 2)

2
The author will earn $24.00 from your purchase!
You can get credits monthly with a Reader Membership

Author

About the Author

Peter de Vaal

I have been working as an Oracle professional since 1992, after having worked in science (1989 PhD physical organic chemistry at Leiden University, the Netherlands, and chimie quantique at the university of Strasbourg, France). It brought me to places such as Mumbai (India), Minneapolis (MI) and Greenville (SC) in the USA and many European countries. And the industries where I could apply my skills ranged from airport baggage handling to chemistry, food industry, hospitals, banking and insurance, governmental institutions etc. Outside my working hours I have two other passions: riding bicycles (MTB and race) and playing the card game bridge.

Contents

Table of Contents

Foreword

Preface

  1. Why this book and why now?
  2. This book is a work-in-progress
  3. Who is this book for?
  4. How to read this book?
  5. Please help improve this book!
  6. About the author
  7. IBest practices for the relational model

1Introduction

  1. 1.1Why a new book about the relational database?
  2. 1.2Is the RDBMS becoming less relevant?
  3. 1.3The foundation of the RDBMS revisited

2A common question of life: What makes me unique?

  1. 2.1The database recognises all its rows: Internal unique identifiers
  2. 2.2The unchallenged unique identifier: Primary key constraints
  3. 2.3Being more unique than just a number: Unique Key constraints
  4. 2.4Uniqueness as inheritance: Unique indexes
  5. 2.5Some examples of unique identifiers
  6. 2.6Best practices when defining unique identifiers
  7. 2.7Best practices for sequences and identity columns

3A foreigner is not a stranger

  1. 3.1Happy together: The pure Master-detail relationships
  2. 3.2When relationships break up
  3. 3.3Join the club: Many-to-many relationships
  4. 3.4Click for more information : A one-to-many relationship for look-up data
  5. 3.5Limiting the choice: Restricted foreign keys
  6. 3.6The family tree: Self-references, tree-structures and networks
  7. 3.7To whom do I belong? The exclusive-arc relation
  8. 3.8Without relations data will not be coherent
  9. IIImplementing Data Integrity

4A brief history of business rule implementation

  1. 4.1Java rules the world!
  2. 4.2It’s the process, stupid!
  3. 4.3Keep it simple: everything in the database!
  4. 4.4The proper way: Use all three methods

5Implementing Data Integrity Rules

  1. 5.1What is a data integrity rule?
  2. 5.2Why data integrity rules should always be implemented in the database
  3. 5.3Specifying business rules
  4. 5.4Categories of business rules
  5. 5.5Implicit Data Integrity Rules of table definitions
  6. 5.6Implementing Data Integrity using constraints
  7. 5.7Implementing Data Integrity Rules using database triggers
  8. 5.8Implementing business rules and functionality using APIs
  9. IIIThe relational database in an Object Oriented world

6Which language do we speak? Communicating with the database

  1. 6.1Application development frameworks using Object Relational Mapping
  2. 6.2Why objects are not tables and vice versa
  3. 6.3Integration, what integration?
  4. 6.4Choosing between object type, XML or JSON for data manipulation APIs
  5. 6.5Choosing between object type, XML, JSON or SQL methods for data retrieval APIs

7PL/SQL APIs for data manipulation and retrieval

  1. 7.1Using PL/SQL functions with object type parameters
  2. 7.2Using PL/SQL functions with JSON parameters
  3. 7.3Using PL/SQL functions with XML parameters

8Database APIs for data retrieval

  1. 8.1Using database views as APIs
  2. 8.2Using Pipelined PL/SQL functions for data retrieval
  3. 8.3Using PL/SQL functions that return a ref cursor

9Using Oracle REST Data Services (ORDS) for database APIs

10Using JSON Duality Views as database APIs

  1. 10.1Declarative ORM Mapping using JSON Duality Views
  2. 10.2Using JSON Duality Views for ACID compliant transactions

11Summary of best practices for Object-Relational mapping

Afterword

Get the free sample chapters

Click the buttons to get the free sample in PDF or EPUB, or read the sample online here

Download Sample PDFDownload Sample EPUBRead Sample OnlineRead online

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

Earn $8 on a $10 Purchase, and $16 on a $20 Purchase

We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earned over $14 million writing, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub