The CEDS Integrated Data Store factors the complete set of CEDS elements, entities and attributes with standard technical syntax and 3rd normal form database normalization. The IDS Model provides a standard framework for integration of P-20W data systems through a well-normalized “operational data store.” It can be used for transactional education data systems, to perform near real-time reporting, and as a standard staging area to load the CEDS Data Warehouse.
To create a new instance of the CEDS IDS on your SQL Server, perform the following steps.
- Open the database creation script at /src/ddl/CEDS-IDS.sql using your preferred SQL client.
- Connect to the server on which you with to create the CEDS IDS instance.
- Find and replace the existing database name in the script (eg. CEDS-NDS-V7_2_0_0) with the database name of your choice.
- Run the script.
The database is empty by default. Proceed with the following instructions to load CEDS Element metadata and CEDS Option Set values into the reference tables.
The full list of CEDS Element metadata is available to load to the CEDS IDS in the form of two tables-_CEDSElements and _CEDStoIDSMapping. _CEDSElements contains the full list of CEDS Elements and basic metadata. _CEDStoIDSMapping contains mapping information that links CEDS Elemenet metadata to the CEDS IDS tables and columns.
- Open the script at /src/metadata/Populate-CEDS-Element-Tables.sql using your preferred SQL client.
- Connect to your CEDS IDS database instance.
- Execute the SQL script.
The two tables will be created and populated with the CEDS Element metadata.
Many elements in CEDS contain a finite list of options (e.g. Disability Type). To load these options into the reference tables (aka lookup tables), proceed with the following instructions.
- Open the script at /src/Populate-CEDS-Ref-Tables.sql using your preferred SQL client.
- Connect to your CEDS IDS database instance.
- Execute the script.
We will provide rerunable scripts to incrementally upgrade your IDS between compatible, incompatible, and alignment versions of the CEDS IDS. Upgrade scripts will be rerunable to make it safe and easy to perform upgrades. Upgrade scripts contain CEDS metadata and reference table inserts and updates.
- Make sure you know what version of the CEDS IDS you are working with.
- Open the appropriate upgrade script at /src/upgrade using your preferred SQL client.
- Connect to your CEDS IDS database instance.
- Execute the script.
Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.
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.
This project is licensed under the Apache 2.0 License - see the LICENSE file for details.