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

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
- 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:
OTN - Oracle Technology Network
- Designing Schemas - design DB first - good - Jan. 2004
- Announcing the New MODEL - multidimensions - Jan. 2004
Oracle 8i
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

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

Trees

Easy Trees with Oracle and PHP

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

p6spy - 2003
SQL Profiler - Jahia - 2003

Open Source Databases

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

Enhydra - free Java database
Database tools (TOAD)
tinySQL - Java-based SQL engine

Tutorials

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
- 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