
Effective Oracle by design
Thomas Kyte · 2003
Programming and computer science › Databases and distributed data
#14,812 most recommended
Hacker News
2
mentions by 2 people · top 79% of 15,732 books
Open Library
—
No ratings yet
1 want to read
Wikipedia
—
No article yet
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
In the commenters’ own words
Optimistic locking in a stateless environment is actually not difficult to implement. The hardest part is actually making sure #devops are aware of the…
1. Godel, Escher, Bach -- Because it sparked my interest and got me started down the path. 2. The Pragmatic Programmer -- a classic. Reminds me that I need to…
What Open Library readers say
No Open Library reader has rated it yet.
- 1 want to read
- 0 reading
- 0 have read
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
Read next: its neighbours on the mosaic
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
Effective JavaJoshua Bloch · 2001 · recommended by 172 people · similar by subject and what people say about it
Domain-Driven DesignEric Evans · 2003 · recommended by 104 people · similar by subject and what people say about it
Database design and implementationEdward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it
SoftwarMatthew Symonds · 2003 · recommended by 10 people · similar by subject and what people say about it
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · similar by subject and what people say about it
Structured designEdward Yourdon · 1975 · recommended by 3 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
Data and RealityWilliam Kent · 1978 · recommended by 15 people · similar by subject and what people say about it
Design PatternsErich Gamma · 1994 · recommended by 95 people · similar by subject and what people say about it
Logical Chess, Move by MoveIrving Chernev · 1957 · recommended by 2 people · loosely similar by subject
A Philosophy of Software DesignJohn K. Ousterhout · 2018 · recommended by 163 people · similar by subject and what people say about it
Object-Oriented Analysis and Design with ApplicationsGrady Booch · 1990 · recommended by 7 people · similar by subject and what people say about it
Data-oriented designMr Richard Fabian · 2018 · recommended by 12 people · similar by subject and what people say about it
Reliable software through composite designGlenford J. Myers · 1975 · recommended by 3 people · similar by subject and what people say about it
Database System ConceptsKorth · 2005 · recommended by 4 people · similar by subject and what people say about it
Design of the Unix Operating SystemMaurice J. Bach · 1986 · recommended by 23 people · similar by subject and what people say about it
Composite/structured designGlenford J. Myers · 1978 · recommended by 2 people · similar by subject and what people say about it
Pro SQL Server InternalsDmitri Korotkevitch · 2014 · recommended by 2 people · similar by subject and what people say about it
Code CompleteSteve McConnell · 1993 · recommended by 393 people · similar by subject and what people say about it
Design by ContractBertrand Meyer · 2020 · recommended by 4 people · similar by subject and what people say about it
Beautiful CodeAndy Oram · 2007 · recommended by 48 people · similar by subject and what people say about it
Pearls of functional algorithm designBird, Richard · 2010 · recommended by 17 people · similar by subject and what people say about it
Design Patterns in RubyRuss Olsen · 2007 · recommended by 15 people · similar by subject and what people say about it