CEDS Integrated Data Store (IDS)
CEDS supports standardizing educational organizations and their relationships with other organizations,
people, and time. The Integrated Data Store is a reference model for operational implementations
aligned to the CEDS standards. The P-20W focus of CEDS is supporting a transition from siloed,
domain-specific, or location-specific, data sets to data that is compatible across domains and geographic
boundaries. In addition to existing state and federal reporting and for analysis and comparison of
aggregate statistics, the standards support data that moves with a learner from an early learning program
to K12 to postsecondary to adult education and workforce learning programs. The latest release of CEDS
also focuses on use cases that support people’s relationship with learning processes — the inputs, process
steps (work), and outputs of learning — beginning with learning standards and assessments.
The IDS is a 3rd normal form structure organized around the key concepts of organization, person, and role.
The IDS was developed with the goal of supporting physical implementations that could function as an
“operational data store” for integrated P-20W data providing the most current available view of each
organization, person, and role.
The IDS starts with a flexible directory of organizations that may have multiple parent-child relationships
with each other. People exist independently, but they do not have roles outside of their relationship to a
specific organization for a specific date range. Each person shares common attributes, or data points, that
allow us to represent all levels as ‘Persons.’ Each Person has one or more ‘roles.’ Roles are a time-aware
association between a Person and an Organization
At the intersection of organizations, persons, and learning resources are key learning processes. CEDS
includes learning resources and process data elements definitions, such as learning standards,
learning goals, learner assignments, learner activity, and learner achievements. Also defined in CEDS
are the data elements and relationships covering formative, summative, and benchmark assessment
processes.
Links:
Integrated Data Store
- IDS factors the entities and attributes of the DES with standard technical syntax
and 3rd normal form.
- The IDS Logical Model provides a standard framework for integration of P-20 data
systems through a well-normalized “operational data store”.
- A “record” is generally added for each Person-Organization Relationship change event in the
system. This CEDS logical model does not directly address the production
aspects of log and change management.
Presentation
|
|
|
|
|
CEDS IDS
This video describes how the CEDS Integrated Data Store (IDS) can help developers with new education software projects.
|
|
Data Model Documentation
|
|
Documents providing a printable representation of the CEDS Data Model, including entity relationship diagrams,
case studies, and the integrated data store tables and fields, can be found
on the CEDStandards/CEDS-IDS GitHub repository in the /doc/ directory.
|
Database Model Downloads
SQL Script
A database script to generate a sample database is provided for those users who would like to take the entities shown on the entity relationship diagrams and work with them on a sample database representing the IDS model.
Scripts for creating a new instance of the latest CEDS IDS, upgrading existing instances of the IDS, load CEDS Element metadata, and load CEDS Option Set values to reference tables,
can be found on the CEDStandards/CEDS-IDS GitHub repository in the /src/ directory.
Releases
Archive files for each release of CEDS IDS can be found
on the CEDStandards/CEDS-IDS GitHub repository in the Releases tab.
|
|
|
Clicking on any of the buttons or links above, except the CEDS IDS presentation, will exit the CEDS website.
We have provided access to these external sites because they have information that may be of interest to our users.
CEDS does not necessarily endorse the views expressed or the data and facts presented on these external sites.
|