User:Mrohatg2
Problem Statement
Educational peer-review systems like Expertiza contains a huge volume of data accumulated during the course of its use. Each peer-review system has a different database design. The relational model is so diverse that, it is often difficult to share the data across different peer-review systems.
In order to migrate a student’s data from one peer-review system to another, one will have to do the following:
- Understand the database design/schema of the source peer-review system
- Understand the database design/schema of the destination peer-review system
- Find the equivalent tables and relations in the destination peer-review system for the source peer-review system
- Retrieve the data from the source peer-review system
- Modify it to match the schema of the destination peer-review system
- Insert the data to the destination peer-review system database.
This is a very tedious job. Moreover, with such a diverse schema it is quite difficult to leverage the power of this large structured data and run any sort of analytics on it.
Solution
One solution to the above mentioned problem is to have a common schema which can capture the essence of all the reviews in a peer-review system to its entirety. Moreover, this schema should not capture any information specific to a particular peer-review system. Once such a schema standard is in place the different peer-review systems can export the data in their database to this new standard and the data can be easily shared across different peer-review systems.
PRML
Peer Review Markup Language is such a standard schema which can capture information about different reviews to its entirety.
Scope of the Project
The scope of this project is to export the data from the Expertiza database to PRML format.
Expertiza Design Document
Expertiza Database Diagram
Expertiza database schema to PRML database schema map
| Table Name | Courses | Course | |
|---|---|---|---|
| Attributes | id | CourseId | |
| null | CourseCIPCode | ||
| name | CourseTitle | ||
| info | CourseDescription | ||
| null | CourseLevelID | ||
| created_at | CourseCreated | ||
| null | CourseStarted | ||
| null | CourseEnded | ||
| Table Name | Assignments | Assignment | |
| Attributes | id | AssignmentId | |
| null | AssignmentCIPCode | ||
| name | AssignmentTitle | ||
| spec_location | AssignmentDescription | ||
| course_id | CourseID | ||
| TABLE NAME | due_dates, deadline_types | Task | |
| ATTRIBUTES | due_dates.id | TaskID | |
| due_dates.deadline_type_id | TaskTypeID | ||
| deadline_types.name | TaskTitle | ||
| due_dates.description_url | TaskDescription | ||
| NULL | TaskOpen | ||
| due_dates.due_at | TaskDue | ||
| TABLE NAME | questions, questionnaires | criterion | |
| ATTRIBUTES | questions.id | CriterionID | |
| questions.txt | CriterionTitle | ||
| NULL | CriterionDescription | ||
| questions.type | Type | ||
| questionnaires.max_question_score | MaxLabel | ||
| questionnaires.min_question_score | MinLabel | ||
| TABLE NAME | question_advices | Level | |
| ATTRIBUTES | id | LevelID | |
| score | LevelLabel | ||
| advice | LevelDescription | ||
| TABLE NAME | questions | Rubric | |
| ATTRIBUTES | TaskID | ||
| questions.id | CriterionID | ||
| TABLE NAME | teams | Actor | |
| ATTRIBUTES | id | ActorID | |
| type | |||
| parent_id | |||
| TABLE NAME | participants | Actor | |
| id | ActorID | ||
| type | |||
| parent_id | |||
| ActorTask | |||
| ATTRIBUTES | ActorID | ||
| TaskID | |||
| teams_users | Participant | ||
| user_id | ParticipantID | ||
| team_id | |||
| AppID | |||
| TABLE NAME | participants | Participant | |
| ATTRIBUTES | user_id | ParticipantID | |
| id | |||
| AppID | |||
| TABLE NAME | ActorParticipant | ||
| ATTRIBUTES | ActorID | ||
| ParticipantID | |||
| RoleID | |||
| TABLE NAME | Enrollment | ||
| ATTRIBUTES | ParticipantID | ||
| AppID | |||
| CourseID | |||
| TABLE NAME | Teams | Artifact | |
| ATTRIBUTES | ActorID | ||
| TaskID | |||
| name | ArtifactContent | ||
| NULL | ArtifactCharLength | ||
| NULL | ArtifactOpen | ||
| NULL | ArtifactEnd | ||
| TABLE NAME | Item | ||
| ATTRIBUTES | ItemContent | ||
| ArtifactId | |||
| TABLE NAME | Review | ||
| ATTRIBUTES | AssessorActorID | ||
| TaskID | |||
| AssessedArtifactID | |||
| CritiqueArtifactID | |||
| TABLE NAME | ReviewCriterionLevel | ||
| ATTRIBUTES | AssessorActorID | ||
| TaskID | |||
| AssessedArtifactID | |||
| CriterionID | |||
| CritiqueArtifactID | |||
| EvalMode | |||
| EvalLevelID | |||
| ValueOrdinal | |||
| ValueCardinal | |||
| Comment |