Database

Introduction

---

Database is now the indivisible part of every internet application. With the English-like SQL, Relational DB and Object-Relational DB is now dominating the DB world. There are also many active researches about improving the query preformance using various data structures and algorithms. PostgreSQL vs. MySQL vs. Commercial Databases: It's All About What You Need.

Query Languages

---

• SQL
• XPath
• XSLT
• XQuery
• SQL/XML

Database Server (or DBMS, DataBase Management System)

---

Comparison of different SQL implementations

• Commercial
  • Oracle
  • IBM DB2
  • Sybase
    • Sybase Adaptive Server Enterprise Express Edition for Linux
  • Microsoft SQL Server
    • SwisSQL - Oracle to SQL Server Migration Tool
  • Access
• Open Source
  • IBM Cloudscape - A lightweight, pure Java technology-based database
  • Apache Derby
  • ASE Quick Install Guide
  • PostgreSQL - PostgreSQL? 8.0 natively run on Microsoft Windows as a server.
  • mSQL
  • MySQL
  • PointBase
  • Firebird - NOT Mozilla Firebird
  • MaxDB - Previously marketed as SAP DB
  • Mckoi SQL Database - An Open Source Java SQL Database System.
  • SQLite
  • Ingres

Database Client

---

• MySQL-Front
• WebMySQL
• SQLExecMS
• SmartDBA
• Abeille
• SQLite Database Browser
• Aqua Data Studio : bundled with JDBC drivers to connect to nearly all database servers (a strong competitor to SmartDBA?)
• SQLCreator : need to download and instll JDBC drivers yourself
• SQuirreL SQL : need to download and install JDBC drivers yourself
• DBBrowser : need to download and install JDBC drivers yourself
• SQL Support in Mozilla - let Mozilla grab data directly from the database using JavaScript
• PKLite SQL Client
• CuteSQL

JDBC Drivers

---

• xlSQL - Excel JDBC Driver

DB Courses

---

• CS4482 Advanced Database Systems
• CS3402 Database Systems

Articles

• Choosing an Open-Source Database
• Backing up your MySQL data