DBMS and Storage

Vendors (and freeware )

Name Comments
DB2 IBM
Informix  
Informix Answers .pdf form of many manuals
Logic Works ERWin
Oracle  
Oracle Documentation  
Oracle Ideveloper Internet development issues.  Online only.
Oracle Labs Application Server 4.0 Beta
Oracle Magazine Oracle's company publication
Oracle Technet Developer support licenses and betas
___tip of the week  
PostgreSQL  A very functional free, open source DBMS. 
Seagate Software Extract & reporting tools
Sybase  
Teradata  
Granite Digital Disk related products and good tech info.

Publications/Information sources

Name Comments
Databases on the Web How to,  by Dan Keller's staff.
DAMA Data Managment Association
DBMS More business than technical
DBTA DataBase Trends and Analysis
DB Prog & Design More technical than business
DM Review Magazine and newsletter. Outstanding.
Intelligent Enterprise Combined 'DBMS' and 'DB Prod & Design' magazines
DB Prog & Design ID=subscriber PW=eureka (upper case?)
DB2 Magazine Miller Freeman site
Enterprise Warehousing Solutions See their Newsletter 
IDUG International DB2 Users Group
InfoStor
Informix Q&A Much of site is in English
INFUSE UK Informix Users Group
IIUG Informix International Users' Group
InxUtil International Electronic Magazine for Informix Software Users
Informix for Linux
Intraware library ps required home=http://member.intraware.com/services/
DBxperts Edmonton Oracle Users' Group.
IOUG International Oracle Users' Group
Oracle-DBA Independent company, good resource
Oracle on Linux eGroup  
Oracle Review  
Oracle Underground FAQ  
OraFans The ORACLE User Forum and Fan Club 
OraWorld by Animated Learning. Tips, books, classes, jobs.
Osborne-Oracle Press Oracle books and code downloads
Osborne-Oracle Press FAQ Good
ORM (Object Role Modeling) 
RevealNet DBA & Developer tools. Quite a bit of free stuff.
Quest Software Tools and whitepapers. Lots of Oracle related items.
SearchStorage Storage Specific Portal
TeraData Review  
TDAN(The Data Administration Newsletter)
uniF/X  This company has an *OUTSTANDING* link page
WebRef's DB links

Examples

Site: Comments:
Trees in SQL
Joe Celko
Worth the careful study it takes to understand. local copy
Converting an adjacency list model to a nested set model
Joe Celko
Followup to the above article. local copy
Temporal DB series from DMReview 
This series is from DMReview's excellent email news letter.
Local Link - shouldn't need these unless the online DMReview goes out of business.  Sadly, that happens to too many good publications.
1 Part 1 Local Copy
2 Preliminaries Local Copy
3 Version Patterns 1 and 2 Local Copy
4 Preliminaries to Version Pattern 3 Local Copy
5 Version Pattern 3 Local Copy
6 Version Pattern 4 Local Copy
7 Completing Version Pattern 4 Local Copy
8 Version Pattern 5 Local Copy
9 Completing Version Pattern 5 Local Copy
10 Foreign Keys in Version Tables Local Copy
11 Foreign Keys in Version Tables Continued Local Copy
12 Foreign Keys in Version Tables Local Copy
13 A Roadmap of the Rest of This Series Local Copy
14 Versioning with Surrogate Keys Local Copy
15 For and Against Surrogate Keys Local Copy
16 Physical Implementation of Version Pattern 1 Local Copy
17 Physical Implementation of Version Pattern 2 Local Copy
18 Physical Implementation of Version Pattern 3 Local Copy
19 RI and Temporal RI Local Copy
20 RI and Temporal RI (Continued) Local Copy
21 Enforcement Time Options for Temporal RI Local Copy
22 Original and Temporal Deletes Local Copy
23 Original and Temporal Updates Local Copy
24 Original and Temporal Updates (Concluded) Local Copy
25 Original and Temporal Inserts Local Copy
26 Points in Time and Periods of Time Local Copy
27 - Original and Temporal Inserts (Concluded) Local Copy
28 - A Revised Roadmap Local Copy

News Letters and related sites

Site: Comments:
Information Impact Information Quality
Search Database  
Storage.ITWorld.com Good newsletter and site.

Data Warehouse/VLDB

Name Comments
Data Challenge Inc VLDB comparison tests (DB Prog & Design magazine) (looks dead)
DataWarehouse.com Part of DMReview
Data Warehouse Information Center Excellent local content and links
DM Review DW related articles
Kimball, Ralph The Dean of DataWarehouse authors.
Collection of very good articles.
Red Brick  
Winter Corporation Articles by DB consultants.

Data Porting and Cleaning

Name Comments
Carleton Corp &bnsp;
Data Junction Tools for a very wide range of data types
Data Quality Assesments and the Information Quality Life Cycle From www.dmreview.com
Local copy
ETI Solutions Inc &bnsp;
Hardball Software Data Shark, extract tool also replicates(?)
Informatica Corp  
Sagent Technology

Metadata

Name Comments
IEEE Metadata Hosted by Lawrence Livermore Lab
National Library of Australia Metadata as used by libraries
Dublin Core Metadata Metadata for Electronic Resources
W3 Metadata and Resource Description


Logic Works
Rational Software

Software:

Name Comments
Database Group Oracle consultants with inexpensive tools
Free DB list Some look pretty good
GNU SQL From Russia
rrdtool Round Robin Database. ... so it doesn't fill up.
TOAD Tool for Oracle Application Development

Books:

Book Author Publisher Comments
Data Model Patterns: Conventions of Thought David Hay Dorset House, 1995 Highly abstracted patterns

Mixed articles:

Title Author Source Date Description
"Autonumber" Fields as Primary Keys Bob Angell database_manager 2002-03-24 Letter to the editor
[ home ]