Andre's Database Links
Data Architecture
MySQL
Oracle
DB2
PostgreSQL
SQL Server
Open Source
Other DBs
Java
Transactions
Hibernate
iBatis
ORM
Modeling
UML
Temporal
Trees
SQLServer
Tutorials
Microsoft
Pundits
Data Mapping
Joins
Miscellaneous
Data Warehouse
Latest
Extreme Transaction Processing Patterns: Write-behind Caching
- InfoQ - Dec. 2009
Database Constraints: Use Them or Lose Them?
- Artima - Oct. 2009
Performance Anti-Patterns in Database-Driven Applications
- InfoQ - Jan. 2009
Crank DAO
-
Using DAO
War on Soft Deletes
- Obasanjo - Nov. 2009
Primary Keyvil - Berkus - CEO - PostgreSQL
Primary Keyvil
- Jan. 2006
Part 2
Part 3
Basic
Download Toad
SQL92 spec
dbazine.com
- Excellent source of latest database happenings
Trees in SQL: Nested Sets and Materialized Path
- Tropashko - DBAzine - Jan. 2002
Java vs. PL/SQL: Where Do I Put the SQL?
- Moore - DBAzine - Jan. 2002
Timestamps
- Sep. 2003
Database Debunkings
- Where Persistent Prevailing Database Fallacies Are Dispelled - C.J. Date is here!
Models, models, everywhere, nor any time to think
- C.J. Date
Normalization Is No Panacea
- 1998
Third Manifesto
Encapsulation Is a Red Herring
- 1998
Database Journal
TDAN: The Data Administration Newsletter
DB forums
Database Design Resources
Agile Data
- Scott Ambler
Practical Database Design
- IBM - June 2003
Commons Downloads
Jakarta commons dbutils
Latest Or Greatest
Performance Anti-Patterns in Database-Driven Applications
- InfoQ - Jan. 2009 - Good!
Handling two-phase commit in WebSphere Application Server using Oracle RAC
- IBM - Oct. 2007
Example: Handling data access exception - StaleConnectionException
- WAS 6.0
SQL
Use SQL subselects to consolidate queries
- Tech Republic - 2002
SQL Cookbook
- O'Rreilly
Data Architecture
Data Patterns
- MicroSoft - Excellent - June 2003
Workflow Data Patterns
- 2004
Multi-Tenancy
Develop and deploy multitenant Web-delivered solutions using IBM middleware, Part 1: Challenges and architectural patterns
- IBM - April 2008
Ruminations on Multi-Tenant Databases
- Jacobs, Aulbach - slides PDF - 2007
Does Multi-Tenant Architecture Matter?
- ITBusinessEdge - May 2007
Multi-Tenant Data Architecture
- MSDN - June 2006
Cost per feature vs. cost per tenant (or how to choose whether to go multi-tenant or not)
- GianPaolo blog - May 2007
execution approach for the data quality analysis pattern in SOA
- IBM - May 2008
Data Transformation
Data transformation in SOA using WebSphere Transformation Extender (TX)
- IBM - Aug. 2007
Tools
Vienna Database Swing Client
- 2001
Toad - Tools for Oracle Developers
-
TOAD for MySQL
Squirrel - SQL Client
Eclipse SQL plugin
Oracle Raptor
SQL Uniform Lite
Oracle
Oracle Home
-
Oracle Magazine
Oracle Error Codes
Oracle 9i Database Error Messages
Oracle 10 Select syntax
OTN Article Index
Independent Sites
Oracle - Tech on the Net
Cry About Oracle
Oracle FAQs
Oracle Magician
Ari Kaplan
Oracle9i Simplifies SQL Syntax
- Aug. 2002
Oracle JDBC Driver Downloads
Oracle 9i SQL versus Standard SQL
- Stanford
Oracle and Standard SQL
- Oracle 9i
Oracle 10g
- OTN home
An Oracle Instructor's Guide to Oracle10G
- dbazine - Nov. 2003
ANSI/ISO SQL Support In Oracle9i
Paged Result Sets with PHP and Oracle
- Nov. 2005
Stored Procs
PL/SQL Subprograms - Oracle 9.2 Doc
Oracle Procedures 10.2
- psoug
Using Oracle PL/SQL - Stored Procs
- Standford - Good
Dr Tom - Database vs. J2EE SQL
- GOOD
Batch Jobs
Performance Tips for Batch Jobs
- Oracle Magician
Import/Export
SQL*Loader
Oracle SQL*Loader Overview
- Oracle 10g - OTN
Introduction to SQL*Loader
- O'Reilly Ch. 1 - 2001
Oracle SQL*Loader FAQ
- orafaq
Oracle SQL*Loader Version 10.2
- psoug
SQL*Loader Concepts
- Oracle 8i Doc
Using SQL*Loader and Export/Import
- Using Oracle8 - Ch. 25 - Que
SQL*Loader
- 9i
Oracle Utilities Tips
- Burleson - Good
Using the Oracle Bulk Loader
Solutions to common SQL*Loader questions
- 1995
Using the Oracle Bulk Loader
- Ullman
Oracle Data Pump
Oracle Data Pump
- 10g - OTN - summary
Oracle 10g Data Pump
Oracle 9i Import
Transferring with Export and Import
- OTN - Jul. 2002
The ORACLE Import/Export Utilities
Oracle Import/ Export FAQ
- orafaq - 8.1
Oracle9i Database Online Documentation (Release 2 (9.2))
List of Books
Case Expressions And Statements
- Oracle Base
SQL Reference
Constraints
-
Foreign Key Constraint
Alter Table
-
examples
Create Sequence
Oracle 9.2 String Functions
Oracle JDBC FAQ
PL/SQL Users Guide and Reference 9.2
Selecting from the DUAL Table
Instance, Database and Schema
Oracle instance and database
-
Architecture of Oracle Database Management System
- kumar
Database Concepts
Enterprise Manager Concepts Guide
JDBC Developer's Guide and Reference
PL/SQL User's Guide and Reference
Sample Scehmas
Oracle9i Database Generic Documentation Addendum
Functions
Functions
- Tech on the Net
Decode
Datetime
Using Datetime and Interval Datatypes in a Global Environment
Oracle Date Functions 10.1
- poug - Excellent
Datatypes
- Oracle9i SQL Reference
Datetime Functions
Current_timestamp
Datetime/Interval Arithmetic
Oracle Date and Times
- Stanford
New Datetime Data Types in Oracle9i
Finding the Time in Between
- OTN - Oracle 9i - Dec. 2002
to_char
- convert date to string - Tech on the Net
Write Time Zone Aware Code in Oracle
- devx - Feb. 2006
Articles
When Not Exists Should Not Exist
- Oracle Magician - Nov. 2004
Stateless Locking Methods
Keep Your Connections
- Use Implicit Connection Cache for transparent cache access - July 2004
Oracle Installation History
- Christian Bauer - Good!
Toad Oracle Resource Links
Oracle - Load your data faster
Oracle and Regular Expressions
- Database Journal - May 2005
Oracle's HTTP Server
Database Journal - April 2005
Other - Tutorials
Create User for 10.1
Adding users in Oracle databases
- Database Design Resource
Database Management Systems Book
- Basic
Oracle - Dead Links
Oracle Home
-
Oracle8i page
-
Oracle Magazine
-
OTN - Oracle Technology Network
Oracle 9i Home
OTN Oracle 9i Documentation
Oracle9i Database Online Documentation, Release 2 (9.2)
-
book list
:
SQL Plus 10g
OTN
SQL Reference
-
Oracle 8i SQL Ref
SQL Plus
-
Quick Reference
-
User Guide
-
SQLPLUS OS command
Oracle SQL*Plus FAQ
Database Concepts
Introduction to Oracle Server
- ch. 1
Memory Architecture
- ch. 7
Schema Objects -ch. 10
Native Datatypes - ch. 12
SQL, PL/SQL, and Java - ch. 14
Transaction Management - ch. 16
Data Concurrency and Consistency - ch. 20
Data Integrity - ch. 21
Oracle XML DB
Oracle9i Application Developer's Guide - Fundamentals
Maintaining Data Integrity Through Constraints - ch. 4
Using Procedures and Packages - ch. 9
Oracle Java
Overview of Java Stored Procedures, JDBC and SQL
Java vs. PL/SQL
Calling Java Stored Procedures from Triggers
- OTN - Aug. 2001
Java Stored Procedures Developer's Guide
JDBC Developer's Guide and Reference
Stored Procedures for Java Programmers
- O'Reilly - August 2003
DataDirect JDBC page
PL/SQL User's Guide & Ref
PL/SQL FAQ
Oracle PL/SQL samples
Database Administrator's Guide
Distributed Database Management
Creating Temp Table
Security Overview
Real Application Cluster Concepts
Database Performance Tuning Guide and Reference
Advanced Replication
Conflict Resolution and Architecture
- ch. 5
Data Mining Concepts
Data Warehousing Guide
XML Database
Oracle Workspace Manager
-
FAQ
OTN - Oracle Technology Network
Designing Schemas
- design DB first - good - Jan. 2004
Announcing the New MODEL
- multidimensions - Jan. 2004
Oracle 8i
Oracle 8i documentation
Oracle 8i JDBC
Connection Pooling and Caching - ch. 15
Samples for Connection Pooling and Distributed Transactions
Distributed Transactions - ch. 16
Oracle JDBC Notes and Limitations
Oracle library
Papers
JDBC Performance
- PDF
Oracle Magazine articles
Oracle High-Performance SQL Tuning
- excerpts from book
Oracle Programming - The UNIX way
- 2001
Calling Java from PL/SQL
- March 2000
Using Java Classes and Objects in Oracle8i
- May 2000
Speeding up JDBC Access
- Jason Price - OTN - 2002
Other
Stewarts Oracle Links
PL/SQL Documentation
- Good reference - 8.1.5
Oracle Datatypes
- Oracle 8.1.5
Oracle8 Application Development Guide
[PDF]
Internet File System
Using Oracle9i Real Application Clusters for Continuous Availability
Burleson Oracle Consulting
-
prices
Full Outer Joins in Oracle9i
- O'Reilly - April 2002
ORacle SQL Set Operations
- chapter from Sanjay Mishra book
SQL Navigator
- PL/SQL Development Environment
From a Database Developer's Scrapbook: Oracle SQL Tips
Pro-DBA
- Oracle ksh scripts
Oracle JDBC 3.0 Local/Global Transaction Toggling
PostgreSQL
PostgreSQL
PostgreSQL vs. MySQL: A Comparison of Speed, Integrity and Popularity
- odesk - June 2006
Postgres Vs MySQL
MySQL vs PostgreSQL
- Wikivs
Comparison of PostgreSQL 8.4, Microsoft SQL Server 2008, MySQL 5.1
- Postgress - Aug. 2009
PostgreSQL vs MySQL with Rails
- June 2009
PostgreSQL Vs MySQL: Comparative Review
- Aug. 2009 - weak
PostgreSQL vs MySQL: Which is better?
- Dec. 2003
Comparison of Oracle, MySQL and PostgreSQL DBMS
- 2005
Comparison of Oracle, MySQL and Postgres DBMS
- Alice DCOB
SQL Server
SQL Server Home
Technical Resources
On-line Documents
-
online
Transact-SQL Syntax Examples
String Functions
Introductory Transact-SQL
- developer.com
Other Types of Joins
Indexes
Brettb.com Transact-SQL articles
Using the Transact SQL Case Statement
- brettb.com
DateTime
Data and Time
- SQL Server Book 2005
Date, Math and Text Functions in SQL Server 2000
- informIT - 2003
Date and Time Functions
- SQL Server 2000
Working with SQL Server Date/Time Variables: Part Four - Date Math and Universal Time
- Database Journal - 2003
The ultimate guide to the datetime datatypes
- Karaszi
Creating trigger to auto set create/modify dates
- thescripts.com - 2005
Constraints
Using Microsoft SQL Server Constraints
- databasejournal - 2003
Triggers
Using Triggers In MS SQL Server
Implementing Triggers in SQL Server 2000
- SQLServer perf.com
MSDN SQL Server
SQL Function Reference: Oracle vs. SQL Server
VLDB Performance Tuning and Optimization
- www.sql-server-performance - 2001
Other
SQLLite
SQLite Home
SQLite Wikipedia
DB2
DB2 Home
DB2 Connect
DB2 vs Oracle Comparison
Object to Relational Mapping
TopLink
Toplink Mapping Workbench
TopLink Value Add Over EJB 1.1 and 2.0
iBatis
Wiki
-
iBatis articles
Using iBatis SQL Maps for Java Data Access
- developer.com -
DB2 UDB, WebSphere, and iBATIS
- IBM - Feb. 2005
Use iBatis as a data mapping framework instead
- IBM - Barcia - Oct. 2005
Object-Relational Mapping with SQLMaps
- O'Reilly - Feb. 2005
iBatis DAO
- O'Reilly - Aug. 2005
Hibernate and iBatis working togetherHibernate and iBatis working together
- SourceLab - Jan. 2006
Spring and iBatis
- Carlos Sanchez blog - May 2005
Spring - iBATIS SQL Maps
- 1.2.7 doc
Hibernate vs. iBATIS
- Raible blog
iBatis 2.0 Released
- TSS - June 2004
Introduction To iBatis
- Javalobby - 2007
Ebean ORM Persistence Layer
Ebean - wikipedia
Ebean ORM - ORM similar to JPA
- TSS - Nov. 2006
Cayenne
- Open Source
Cayenne
- TSS articel - June 2004
Other Tools
CocoBase
- OR mapping tool -
with WebLogic
Object-Relational Mapping with Apache Jakarta OJB
- O'Reilly - Jan. 2003
JAXOR
- open source - recommended by Fowler
Castor
- open source data binding framework for Java... map Java objects, XML documents, SQL tables and LDAP directories
SODA - Simple Object Data Access
- sourceforge
Table/Inheritance
Mapping Objects To Relational Databases
- Ambler - 2003
Mapping Objects to Tables
- Wolfgang Keller
Object Relational Mapping Strategies
- Object Matter
Mapping Objects to Tables
- Object Architects
Mapping Classes to Relational Tables
- Jensen - Apr. 2004 - JavaPro
Object-Relational Mapping with Apache Jakarta OJB
- O'Reilly - Aug. 2003
Mapping to Relational Databases
- Fowler - Enterprise Architecture book excerpt
Modeling/Mapping Flexibility in EdgeXtend
- Persistence
Articles
Object-relational mapping articles and products
- Service-Architecture
Lightweight JDBC O-R Mapping Framework
- TRC - JavaReport - May 2001
Arthur Keller
- Large number of useful papers by
Persistence
OR guru
Patterns for OR Access Layers
-
Open Source O/R Mappers
- by
Wolfgang Keller
O/R Mapping Strategies
- by
Objectmatter
- cool - inheritance, etc.
Mapping Objects to Relational Databases
- Good article by Scott Ambler
Mapping objects to relational databases"
- Ambler - July 2000
ServerSide discussion on EJB
Other
Databases: Mapping Objects to Relations
- Good old Cetus links
jshoppe - Data Visualization
- GOOD
EJB and OR with IBM's VisualAge
(basic) - by
Kyle Brown
Crossing Chasms - A Pattern Language for Object-RDBMS Integration
- Kyle Brown - 1995 - PDF
Object Database vs. Object-Relational Databases
- by Steve McClue of IDC (1997)
Object-Relational Mapping & Databases
- from Doug Barry
Ontos
- Used to have OR mapper - seems to have been discontinued
Andre's JDO links
Prevayler
Introduction to object prevalence
- IBM - Aug. 2002
Stored Procedures
Implementing CRUD Operations Using Stored Procedures
- database journal - Oct. 2003
Modeling
Reading ERDs
- Glen Ford - 2000
Entity-Relationship Diagrams
- PDF
Richard Barker
Entity Relationship Modeling and Normalization
- Good Course - Holowczak
Entity Relationship Modeling from an ORM perspective: Part 1
- Journal of Conceptual Modeling -
Part 2
-
Part 3
ERwin
Journal of Conceptual Modeling
A Taxonomy for Entity-Relationship Models
UML and Databases
Towards a UML Profile for a Relational Persistence Model: Working Page
Data Modeler
Database Modeling Using Rose 2000
Rational Edge ezine
Rose Architect Magazine
UML and Database - Blaha -
Part 1
-
Part 2
Data Modeling with Rose
by N. Bereny
Data Modeling products
Temporal Databases
Temporal Databases Internet Resources
TSQL
Workshop on Temporal Databases 1995
Archival and Temporal Databases
Temporal dabatabases in medicine (PPT)
Temporal Databases thesis
Slide Show of Temporal Database Interoperability
Temporal databases
Trees
Easy Trees with Oracle and PHP
- OTN - Dec. 2005
Trees in SQL: Nested Sets and Materialized Path
- Tropashko - dbazine - Jan. 2002
More Trees & Hierarchies in SQL
- SQL Team - 2002
Trees in Oracle SQL
- Greenspun
The Link is the Thing, Part 2
- DM Review - Sep. 2003
Oracle Connect By
Hierarchical Query Operators
- Oracle Database SQL Reference 10g Release 1 (10.1) -
Hierarchical Queries
START WITH and CONNECT BY in Oracle SQL
- Nyffenegger -
storing hierarchical data
http://www.adp-gmbh.ch/blog/2005/october/18.html
How does one code a tree-structured query?
- orafaq
New CONNECT BY Features in Oracle Database 10g
- OTN
Oracle "connect by" syntax
- Burleson - short
SELECT... CONNECT BY
- ss64 - good summary
Port CONNECT BY to DB2
- IBM - Oct. 2005
Celko
Graphs, Trees, and Hierarchies
- dbazine - 2003
Trees in SQL
- Intelligent Enterprise - Oct. 2000
A look at trees
- DBMS mag - 1996
Profilers
Elvyx 1.0
p6spy
- 2003
SQL Profiler
- Jahia - 2003
Open Source Databases
Overview
Open Source Database Benchmark
Open source database software comparison
Open-source databases going mainstream
- cnet - March 2004
HyperSonic
- free Java database
Apache Derby
Ingres
Berkely DB
- from SleepyCat
Firebird
Axiom
- open source (used by Britannica)
Open Source Databases Bloom
- Computerworld - 2001
Other Databases
mSQL
-
Extra Stuff
Enhydra
- free Java database
Database tools (TOAD)
tinySQL
- Java-based SQL engine
Tutorials
J. Hoffman's good introduction
W3 Schools - SQL Tutorial
Join Basics
- King County GIS
First SQL Tutorial
-
Transactions
SQLCourse.com
SQL Tutorial W3 Schools
SQL Zoo Interactive Tutorial
SQL Tutorial
- keyword per page
SQL FAQ
- Anderson - 1994
Joins
Oracle Guide - Good intro
Normalization
Database Normalization And Design Techniques
- Barry Wise - 2000
Fagin
- PDF
Pundits
OMT Associates (Blaha)
- author of great book
Object-Oriented Modeling and Design for Database Applications
Scott Ambler's page
- lots of O/R articles
Joe Celko (SQL for Smarties) -
Home
-
Articles
Killing Time
- Joe Celko
Scrubbing Data with non-1NF tables
- Celko
Thinking in Aggregates
- Celko
Graphs, Trees, and Hierarchies
- dbazine -
Trees in SQL
- Intelligent Enterprise - Oct. 2000
A look at trees
- DBMS - 1996
Craig Mullins page
- DB2 & SQL Server guru
A Simple Guide to Five Normal Forms in Relational Database Theory
- William Kent 1982! - dead
Other writings on DB and semantic modeling
- dead
Data Mapping
Morph
- sourceforge
Dozer
- sourceforge
Joins
Left Outer Join
- Wikipedia
SQL Server
Join Fundamentals
- MSDN
Using Joins
Using Outer Joins
Performance Tuning SQL Server Joins
- SQLServer Performance.com - April 2006
Joins Revisited: It's All About Relationships
- informit - Jan. 2004
Miscellaneous
JLINQ: IBM's new paradigm for writing Java database applications
- IBM - Aug. 2007 -
Artima forum
Challenges Involved in Multimaster Replication
- Database Specialists
Dataphor
- a la Date?
Daffodil Data Replicator Open Source
VLDB - Very Large Databases
-
1998 Top 10
RDBMS Repository
- Database comparisons
(circa 1996)
Database Stuff
Using OLE DB and ADO 2.5 to Represent Nonlinear, Nonrelational Types of Data
Java Skyline Database
IBM Redbook on DB2 Tuning
Free TDS
- document and implement the TDS protocol (Sybase and Microsoft)
Database Design for Advanced Decision Suppport
vldb.org
Cache Technology
- PostRelational
Livestore
- Isocra - Transparent JDBC cache
Team Database
Terry Purcell on Outer Joins
-
Part 2
Cetus links
- Ye old links...
Datawarehouse
Ralph Kimball
-
Articles
Dbazine Datawarehousing
Intelligent Enterprise
-
Datawarehousing
Mining gives meaning to complex data
- ADT - Oct. 2000
Everyman's Guide to Data Warehousing
- ADT - Oct. 2000
Oracle
Oracle Data Warehousing page
Oracle Data Warehousing Guide
Oracle Business Intelligence Beans 10g
Getting Answers with BI Beans
Oracle
How to Build a Metadata Bridge for DB2 Cube Views
- IBM - Sep 2004
Implementing Real-Time Data Warehousing Using Oracle 10g
- dbazine
An Introduction to Oracle Warehouse Builder 10g
- dbazine
Data Mining
Data Miners
-
links
KDnuggets
Data Mining Glossary
Datamation Data Mining and Business Intelligence
Megaputer Intelligence
-
Data Mining 101
DM Review
- Data mining, warehouse, etc.
OLAP
Basic
Java OLAP Server
Olap Report
What is OLAP
Database Explosion
Oracle LAP
OLAP AND OLAP Server Definitions
- DSS Resources
Vendors
Hyperion
SQL Server - Analysis Services
EII
EII Portal
- DM Review
Federated views
- IBM DB2
iWay - EII
Materialized Views
Oracle 8i: The Materialized View
- June 2000
Materialized Views in PostgreSQL
Chris Date
An Interview with Chris Date
- O'Reilly - July 2005
Last updated: 13 December 2009