search

CEDStandards / CEDS-Data-Warehouse

Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.
https://github.com/CEDStandards/CEDS-Data-Warehouse
Apache License 2.0
22 stars 3 forks source link
ceds data-warehouse data-warehouses data-warehousing education-data education-data-standards education-database sql-server

readme

CEDS Data Warehouse Logo

CEDS Data Warehouse

Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.

Getting Started

Fresh Installation

To create a new instance of the CEDS Data Warehouse on your SQL Server, perform the following steps.

  1. Open the database creation script at /src/ddl/CEDS-Data-Warehouse-V11.0.0.0.sql using your preferred SQL client.
  2. Connect to the server on which you want to create the CEDS Data Warehouse instance.
  3. Find and replace the existing database name in the script (i.e. CEDS-Data-Warehouse-V11-0-0-0) with the database name of your choice.
  4. Run the script. This will create the CEDS-Data-Warehouse-V11.0.0.0 database.

The database is empty by default. Proceed with the following instructions to load CEDS Element metadata and CEDS Option Set values into the Dimension tables.

  1. Open the Create CEDS Elements V11.0.0.0 document at /src/dimension-data/CEDS-Elements-V11.0.0.0
  2. Connect to the server on which you created the CEDS Version 11.0.0.0 instance
  3. Run the script. This will create the CEDS-Elements-V11.0.0.0 Database
  4. Open the Junk-Table-Dimension-Population-V11.0.0.0 document at /src/dimension-data/Junk-Table-Dimension-Population-V11.0.0.0
  5. Find and replace the existing database name in the script (i.e. CEDS-Data-Warehouse-V11-0-0-0) with the name of your data warehouse instance.
  6. Run the script. This will populate the dimension tables in the CEDS Data Warehouse Version 11

Contributing

Please read Contributing.md for details on our code of conduct, and the process for submitting pull requests to us.

Versioning

We use a customized version of Explicit Versioning for versioning. To keep the various CEDS Open Source projects in alignment with the CEDS Elements, we are replacing the concept of "disruptive" releases with "alignment" releases. These releases ensure that the data models are in sync with the official, community approved list of CEDS Elements. For the versions available, see the tags on this repository.

Authors

See the list of contributors who participated in this project.

License

This project is licensed under the Apache 2.0 License - see the LICENSE file for details.