Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ole-cfg-dbs Project Structure

Directory

Description

db-impex

The database import/export tool used to process the contents of the directory below. Loaded automatically from the Kuali SVN repository.

development

The OLE database description - see below.

rice

The matching Rice database description - loaded from the rice project.

Within the ole-cfg-dbs project/development directory, there are four major items:

File/Directory

Description

schema.xml

This file represents the structure for the entire database schema. This contains all tables, views, sequences, indexes, and constraints.

data

Each file in this directory contains the data for a single table. These files are maintained in a pipe (|) delimited flat file format.

graphs

The "programs" used by Clover ETL to perform the import. Their main purpose is to map between the files and the database, translating any placeholders for pipes in the data. Graphs only exist for tables which contain data. For performance reasons, tables without any data have their graphs purged during the export process.

formats

The structure used for both the data file and the import into the database. Referenced by the graphs during execution.

Also, the ole-cfg-dbs project directory contains an svn:externals property which pulls in the correct version of Rice for OLE. (See the subversion documentation for more information.) This causes SVN to pull the needed definitions directly from the Rice project.

Rice Data Locations and Structure

...

The Rice data needed by OLE is stored within the main ole project in the locations below:

Directory

Description

ole/work/db/rice-data

Rice KNS and KIM data

...

. (Parameters, Roles, Permissions, etc...)

ole/work/

...

workflow

OLE workflow document definitions.

Document TODO Notes

  • structure
  • data
    Note
    • DBA schema
    • satellite databases
    • database refresh
    • Rice data
      • master schema from Rice project
      • OLE Data Overlay
        • Liquibase
        • Workflow