Re: [osdldbt-general] Re: PostgreSQL and OSDL Database Tests

[Jenny Z. <je...@os...>]

For Justin's page, I would like to add "why these test kits are
important for database developer and user".

And I have a list of things to do for dbt3:-)

The attached is an old e-mail being passed around about porting dbt3 to
PostgreSQL.  It is just a draft of things to do.  The dbt3 structure on
SourceForge will be changed to fit for multiple databases.  But the
structure is not determined yet.
========
Porting:
-Download dbt3 from SourceForge CVS tree.  The documents are in
 dbt3/doc.  'README.txt', dbt3-implement and dbt3-user-manual are 
 helpful to understand the kit.
-Change the scripts in dbt3/scripts/sapdb so that the database 
 creation/loading commands fit PostgreSQL grammar
-Change the query template in /dbt3/datagen/queries so that the SQL 
 works in PostgreSQL
 The original query templates are in dbt3/datagen/original-queries.  
 They should be rewritten to fit PostgreSQL grammar and take advantage
 of PostgreSQL features to enhance query performance.  The query
 templates in dbt3/datagen/queries are rewritten for SAP DB.
-In dbt3/data_collect, there is a scripts 'db_stat.sh' to collect  
 database monitor statistics.  This script needs to be changed or get
 rid of.
-In dbt3/dbdriver, get_composite.sh, get_power.sh, get_throughput.sh an 
 q_time.sh query the database and get query execution time.  The logic 
 is the same, but the SQL need to be changed.
-In dbt3/dbdriver/utils, 'main.c' has SAP DB SQL hardcoded to update
 time_statistics table, this need to be changed to PostGres grammar.
-Changes may be needed for dbt3/datagen/dbgen.  Mostly adding PostGres
 as a defined database, and make sure the raw data is in a format that
 is ready to be loaded to a PostGres database. Please refer to the patch
 'patch_dbgen_sapdb' under dbt3/datagen.

Performance Tuning:
-Very long running queries may need to be rewritten to overcome any
 weaknesses in the optimizer.  
-The scripts create_index.sh creates the indexes that are allowed by
 tpc-h, and useful to SAP DB.  This script, as well as other scripts
 should be tailored to take advantage of PostgreSQL.
-- 
Jenny Zhang
Open Source Development Lab Inc 
15275 SW Koll Parkway - Suite H
Beaverton, OR 97006
(503)626-2455 ext 31