Data Warehousing with MySql

[e]

Data Warehousing with MySql

Data Warehousing is the idea of setting up a separate database structure for purely reporting purposes, so you can stop compromising between reporting and transactional demands.
MySql is a database that is fast, easy to use, and (generally) free.

> Aggregation
> Benchmarks
> ClickstreamData
> DatesAndTimes
> Home
> Indexing
> KPIs
> Links
> MathML
> Money
> MysqlCompared
> PhpPlugins
> Recipe
> Regression
> Scripting
> Sudoku
> SummaryData
> TableTypes
> TuningMysql

New Page:

search:
>

edit css

show debugging

contact: tom (.) cunningham (at) gmail (dot) com

[e]

MySql Compared to Other Databases

Optimizing MySql. [mysql.com] -- has some benchmarks against other databases: SELECTs are 3 times quicker than DB2 / SQL-Server, & 20 times quicker than Oracle. INSERTs are 10 times quicker than DB2 / SQL server, and 20 times quicker than Oracle.

June 05 AnandTech Linux Server Benchmark. [anandtech.com] Compares MyISAM, InnoDB, and DB2; and compares various AMD and Intel processors. Generally: for quickness, use MyISAM, InnoDB, then DB2. But as the application scales (in concurrency, and in number of processors), the other two engines catch up to MyISAM.

2002 eweek DB benchmark Feb 02. [eweek.com] shows all servers performing remarkably the same, then dropping out when they hit max connections. Oracle & MySql stay the longest.

Feature Comparison. [mysql.com] -- testing all the SQL features supported using crash-me. Compares most big DBs.

Feature Comparison. [wikipedia.org] -- good, up-to-date list of main features each DB has.

D-Warehouse Features in Different Versions of MySql

MySql 5

FEDERATED table type -- access remote MySql servers.

Table Partitioning & Parallel Scans in MySql 5 (April 05)