DeepRead
Cover of Effective Oracle by design

Effective Oracle by design

Thomas Kyte · 2003

Programming and computer science › Databases and distributed data

#14,812 most recommended

About the book

A practical guide to designing applications around the Oracle database, covering how schema design, data integrity, and application code interact with the database engine. It treats Oracle as the foundation of an application rather than as a passive store behind it. Its central claim is that the database should be used for what it is built to do: enforce integrity with constraints and triggers, manage concurrency through its locking and read-consistency model, and process data set-wise in SQL instead of row by row in application code. It argues that developers who understand the server's architecture make better design decisions, and that many correctness and performance problems come from ignoring those features. The argument is made through design guidance and worked examples rather than a command reference.

Written by Claude from what it knows of this book.

What Hacker News says 50% recommend · 0% critical

02420162018202020212016 peak · 1
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say

No Open Library reader has rated it yet.

  • 1 want to read
  • 0 reading
  • 0 have read

Open Library’s page for the book

What critics say, via Wikipedia

No Wikipedia article about this book yet, so no critics to quote.

Reddit communities — coming later

The threads it came up in

Details

First published
2003
ISBN
9780072230659
Editions known
2 at Open Library
Open Library
OL5748932W

Database designOracle (Computer file)Oracle (computer system)Relational databases

Explore in the mosaic

Read next: its neighbours on the mosaic