Instruction for execution of scenario to create CUEAV.

1. Creating Row DB that provides CUEAV by data source.
1.1. Download CUEAV 1.01 scripts.

1.2. Create new epmpty SQL DB named Source_DB_For_EAV.

1.3. Generate Source_DB_For_EAV . To generate Source_DB_For_EAV it is necessary to start up sql script named Source_DB_For_EAV.sql. This script forms and populates Row DB consisting of 5 tables describing for example patients, their hospitalizations and tests.

2. Creating CUEAV DB.

2.1. Create new empty SQL DB named CUEAV.

2.2. Generate CUEAV. To generate CUEAV it is necessary to start up sql script named CUEAV.sql. This script forms EAV DB consisting of 5 empty tables (Attribute, Class, ClassLinks, Object, Value) and 10 Store Procedures (sp_ConvertToEAV, sp_ConvertFromEAV, sp_CreateForeignKeyIndexes, sp_CreateForeignKeys, sp_CreatePrimaryKeys, sp_DeleteForeignKeyIndexes, sp_DeleteForeignKeys, sp_DeletePrimaryKeys, sp_DropRowModelTables, sp_ShrinkFile).

3. Population CUEAV tables. To populate CUEAV tables it is necessary to start up store procedure named _sp_ConvertToEAV. This store procedure converts Row data from Source_DB_For_EAV into different structure of CUEAV data.

4. Deployment EAV DB structure into Raw data structure. To deploy EAV DB structure into Row data structure it is necessary to start up store procedure named _sp_ConvertFromEAV.

Samples of T-SQL queries