Database Sample Code Overview

All ChartDirector database sample scripts described in this documentation are based on a MySQL database. The sample scripts are provided for reference purposes. To actually run the sample scripts, you would need to set up your database system as follows:

Set up a MySQL database server to run on the same machine as your web server. The MySQL database can be downloaded from http://www.mysql.com.
Install the Perl DBI module and DBI Driver for MySQL (MySQL module). These modules allow your Perl to access MySQL. They are available from CPAN (http://www.cpan.org).
Create a database called "sample" in your MySQL server.
Create an account with username "test" and password "test" that can be used to access "sample".
Import the table "sample.sql" (located in the "perldemo_cgi" subdirectory) into the "sample" database.

Set up a MySQL database server to run on the same machine as your web server. The MySQL database can be downloaded from http://www.mysql.com.
Install the Perl DBI module and DBI Driver for MySQL (MySQL module). These modules allow your Perl to access MySQL. They are available from CPAN (http://www.cpan.org).
Create a database called "sample" in your MySQL server.
Create an account with username "test" and password "test" that can be used to access "sample".
Import the table "sample.sql" (located in the "perldemo_cgi" subdirectory) into the "sample" database.

The sample database that contains only one table called "Revenue" . The table stores the monthly revenue data for three business units - Hardware, Software and Services. It contains four columns as follows:

Column Name	Type
TimeStamp	Date/Time
Hardware	Number
Software	Number
Services	Number

Each row in the database table contains monthly revenues for the business units, where the date is stored in the "TimeStamp" column. The sample database contains rows from Jan 1990 to Dec 2001.