Wednesday, October 07, 2009

Create sample database

Creating a sample database

When you create a schema repository, you can also create a sample user database. A sample user database is a working user database that provides 40 sample defect records of user information, plus sample queries and reports. Sample user databases can be used to learn how Rational ClearQuest software works and to help train users.
Before you create any Rational ClearQuest database, you must create an empty database container with tools provided by the database vendor.

For information about configuring vendor databases, see the IBM Rational ClearQuest and ClearQuest MultiSite Installation and Upgrade Guide.

To create a sample database:

  1. Start the Maintenance Tool. Then click Schema Repository > Create.
  2. In the Existing Connections pane, enter a name for the schema repository connection in the highlighted item and press Enter.

    By default, the first connection name is 7.0.0. You can rename the connection later.

  3. In the Schema Repository Properties area, select a database vendor and enter the required properties. The properties for each database are different.
    • If you select Microsoft SQL Server, Oracle DBMS, or IBM DB2, enter the physical database name of one of the empty databases that you created with the vendor database tools.

      When you create a DB2 schema repository, the User Name property must be a user identity that has database administrator authority for the DB2 database.

    • If you select Microsoft Access, enter a physical database name; the Maintenance Tool creates a new database with that name.
  4. Click Next.
  5. In the ClearQuest Data Code Page window, select the data code page to use with the new schema repository. You can choose any supported data code page supported by Rational ClearQuest. The default data code page is the one associated with the user-interface language for the operating system on which the Maintenance Tool is running, if that code page is supported. If that code page is not supported, the default data code page is ASCII.
  6. Click Create sample database.

Schema Repository

Creating a schema repository

A schema repository is a database used to store and manage a group of schemas including all versions of those schemas, and their associated user databases.
Before you create a schema repository, you must create an empty database container with tools provided by the database vendor. For information about configuring vendor databases, see the IBM Rational ClearQuest and ClearQuest MultiSite Installation and Upgrade Guide.

To create a schema repository:

  1. Start the Maintenance Tool. Then click Schema Repository > Create.
  2. In the Existing Connections pane, enter a name for the schema repository connection in the highlighted item and press Enter.

    By default, the first connection name is 7.0.0. You can rename the connection later.

  3. In the Schema Repository Properties area, select a database vendor and enter the required properties. The properties for each database are different.
    • If you select Microsoft SQL Server, Oracle DBMS, or IBM DB2, enter the physical database name of one of the empty databases that you created with the vendor database tools.

      When you create a DB2 schema repository, the User Name property must be a user identity that has database administrator authority for the DB2 database.

    • If you select Microsoft Access, enter a physical database name; the Maintenance Tool creates a new database with that name.
  4. Click Next.
  5. In the ClearQuest Data Code Page window, select the data code page to use with the new schema repository. You can choose any supported data code page supported by Rational ClearQuest. The default data code page is the one associated with the user-interface language for the operating system on which the Maintenance Tool is running, if that code page is supported. If that code page is not supported, the default data code page is ASCII.
  6. You have the option of creating a sample user database.
  7. Click Finish.

Shemas and Schema Repository

Schemas and schema repositories

A Rational ClearQuest schema is a complete description of the process model for all the components of a user database. This includes a description of states and actions of the model, the structure of the data that can be stored about the individual component, hook code or scripts that can be used to implement business rules, and the forms and reports used to view and input information about the component. Rational ClearQuest provides out of the box-schemas that can be customized for a client installation.

A schema is a pattern or blueprint for Rational ClearQuest user databases. When you create a user database to hold records, the database follows the blueprint defined in a schema. However, a schema is not a database itself; it does not hold any records about change requests, and it does not change when users add or modify records in the user database.

Rational ClearQuest stores schemas in the schema repository. The schema repository is the master database that contains metadata about the user databases. It does not contain user data.

A schema repository can store multiple schemas, for example, one schema for defect change requests and another schema for feature enhancement change requests. [Source:IBM]