DenkzeitWiki

DBMS

• Wikipedia:Database_management_system
  

Database management is a core competency of Web 2.0 companies, so much so that we have sometimes referred to these applications as "infoware" rather than merely software. [1]

• Wiki:DatabaseBestPractices

• Database Fundamentals
• four kinds of data models:
  • hierarchical
    • IMS, used in the Apollo project
  • network
    • CODASYL
  • relational (from relations of SetTheory)
  • objectOriented
  • (navigational: hierarchical and network, manually following links)
    • The DOM "engine" is essentially a light-weight navigational database.

Books

• Datenbanksysteme by AlfonsKemper, AndreEickler?
• Datenmodelle, Datenbanksprachen und Datenbankmanagementsysteme by GottfriedVossen?
• Sams Teach Yourself SQL in 10 Minutes by BenForta?
• A Visual Introduction to SQL by DavidChappell?, JHTrimble?

Magazines

• http://www.dbazine.com/ -- online

Discussion

• http://www.dbdebunk.com/

Locking

• optimistic locking
  • Inconsistency are checked when data is written.
  • It is assumed that data will not likely change.
• pessimistic locking
  • Lock is established upon accessing data (read or write) and freed upon commit (or rollback).
  • 2PhaseLocking

ConnectionPooling

Stored Procedure

• Wikipedia:Stored_procedure
• http://dev.mysql.com/doc/mysql/en/stored-procedures.html --for MySQL

Data Cubes

• http://research.microsoft.com/research/pubs/view.aspx?type=Technical%20Report&id=144 --Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals (AdamBosworth?; SurajitChaudhuri?; JimGray?; ...)