Index: openacs-4/packages/imsld/www/doc/README.txt
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/doc/README.txt,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/imsld/www/doc/README.txt 30 Jun 2005 10:31:51 -0000 1.2
+++ openacs-4/packages/imsld/www/doc/README.txt 5 Jul 2005 16:13:45 -0000 1.3
@@ -2,15 +2,20 @@
You are welcome to edit this specification, but please do it following the next steps:
-1. Edit the specification using any xml editor you want (we use docbook)
+1. This specification has been written in DocBook format, so edit the specification
+ using any xml editor you want (we use xmlmind)
-2. Edit the specification version number in the imsld-spex.xml file
+2. Edit the specification version number in the imsld-spec.xml file
-3. Generate the html. We use xsltproc like this:
+3. Generate the html. Note that the document has been chunked into several files, with
+ two hierarchy levels. Please keep this organization. We use xsltproc like this:
xsltproc -o out_dir/ --xinclude stylesheets_dir/mychunk.xsl imsld-spec.xml (you can download the stylesheets from http://sourceforge.net/project/showfiles.php?group_id=21935&package_id=16608
+
+ where mychunk.xsl is a customized file where we have just followed the instructions given in the downloaded stylesheets
4. Commit it
-5. Notify the autors and the corresponding package mantainer about the changes
+5. Notify the autors and the corresponding package mantainer about the changes
+Thanks!!!
Index: openacs-4/packages/imsld/www/doc/ch04s01.html
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/doc/ch04s01.html,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/imsld/www/doc/ch04s01.html 30 Jun 2005 10:43:20 -0000 1.4
+++ openacs-4/packages/imsld/www/doc/ch04s01.html 5 Jul 2005 16:13:45 -0000 1.5
@@ -5,114 +5,103 @@
if(pos=="center"){LeftPosition=(screen.width)?(screen.width-w)/2:100;TopPosition=(screen.height)?(screen.height-h)/2:100;}
settings='width='+w+',height='+h+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no';
win=window.open(mypage,myname,settings);}
- </script></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Level A</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch04.html">Prev</a>�</td><th width="60%" align="center">Chapter�4.�Data Model</th><td width="20%" align="right">�<a accesskey="n" href="ch04s02.html">Next</a></td></tr></table><hr></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="id2601140"></a>Level A</h2></div></div></div><div class="itemizedlist"><ul type="disc"><li><p>imsld_imslds: This table is used to store all the units of
+ </script></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Level A</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch04.html">Prev</a>�</td><th width="60%" align="center">Chapter�4.�Data Model</th><td width="20%" align="right">�<a accesskey="n" href="ch04s02.html">Next</a></td></tr></table><hr></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="id2587741"></a>Level A</h2></div></div></div><p>Next, the tables necessary for Level A are draw in the form of an
+ E-R diagram</p><p><a href="resources/imsld_diagram_A.GIF" target="_top"><span class="inlinemediaobject"><img src="resources/imsld_diagram_A.GIF"></span></a></p><div class="itemizedlist"><ul type="disc"><li><p>imsld_imslds: This table is used to store all the units of
learning. This is the high level in the hierarchy. Each IMS-LD file
- loaded in .LRN will generate an entrance in this table. This table
+ loaded in .LRN will generate a row in this table. This table
contains all the different units of learning. Each unit of learning
- will contain global information and also references to other tables
- for having all the required information of a unit of learning</p><div class="itemizedlist"><ul type="circle"><li><p>imsld_id - identifier</p></li><li><p>version - version number</p></li><li><p>uri - uri of the imsld</p></li><li><p>level - A, B or C. It is the level of the IMS-LD file that
- arrive</p></li><li><p>sequence_p - sequence used, true or false. True means
- simple sequencing is being used. Defaults to false</p></li><li><p>learning_objective_id - references
- imsld_learning_objectives</p></li><li><p>title</p></li><li><p>method_id - references imsld_methods</p></li><li><p>prerequisite_id - references imsld_itemmodel</p></li><li><p>component_id - references imsld_components</p></li><li><p>complete_unit_of_learning_id - references
- complete_unit_of_learning</p></li></ul></div></li><li><p>imsld_complete_unit_of_learning. This tables describes the
- actions to do when a unit of learning is completed</p><div class="itemizedlist"><ul type="circle"><li><p>complete_unit_of_learning_id</p></li><li><p>when_property_value_is_set_id ** - references
- imsld_when_property_value_is_set</p></li></ul></div></li><li><p>imsld_prerequisites. It has all the prerequisites of a unit of
- learning. These are the previous knolowdges that are required for
- doing the unit of learning</p><div class="itemizedlist"><ul type="circle"><li><p>prerequisite_id</p></li><li><p>prerequisite_item - references imsld_items</p></li></ul></div></li><li><p>imsld_components: Used to store all the components of the
- IMS-LD</p><div class="itemizedlist"><ul type="circle"><li><p>component_id</p></li><li><p>role_id - references imsld_roles</p></li><li><p>activity_id - references imsld_activities</p></li><li><p>environment_id - references imsld_environments</p></li><li><p>property_id ** - references imsld_properties</p></li></ul></div></li><li><p>imsld_roles. This table contains all the defined roles</p><div class="itemizedlist"><ul type="circle"><li><p>role_id - references imsld_roles</p></li><li><p>role_types - references role_types_id</p></li><li><p>create_new_p - multopleoccurrences of this role may be
- created during runtime?</p></li><li><p>match_n_persons - exclusively-in-roles,
+ will contain global information and also references to other tables,
+ in order to represent completely the information represented by the
+ unit of learning.</p><div class="itemizedlist"><ul type="circle"><li><p>imsld_id - identifier</p></li><li><p>version - version number</p></li><li><p>level - A, B or C. It is the level of the IMS-LD file that
+ arrive</p></li><li><p>sequence_used_p - sequence used, true or false. True means
+ simple sequencing is being used. Defaults to false</p></li><li><p>learning_objective_itemmodel_id - references
+ imsld_itemmodels and contains the objectives of the unit of
+ learning</p></li><li><p>title</p></li><li><p>method_id - references imsld_methods</p></li><li><p>prerequisite_itemmodel_id - references imsld_itemmodels
+ and contains the prerequisites for the unit of learning</p></li><li><p>component_id - references imsld_components</p></li><li><p>when_property_value_is_set** - references
+ imsld_when_property_value_is_set. Treated with more detail in
+ level B</p></li></ul></div></li><li><p>imsld_components: Used to store all the components of the
+ IMS-LD (which are: roles, acitivities and environments. The
+ activities references this table)</p><div class="itemizedlist"><ul type="circle"><li><p>component_id</p></li><li><p>role_id - references imsld_roles</p></li><li><p>environment_id - references imsld_environments</p></li><li><p>property_id ** - references imsld_properties</p></li></ul></div></li><li><p>imsld_roles. This table contains all the defined roles</p><div class="itemizedlist"><ul type="circle"><li><p>role_id - references imsld_roles</p></li><li><p>role_type</p></li><li><p>create_new_p - multopleoccurrences of this role may be
+ created during runtime?</p></li><li><p>match_persons - exclusively-in-roles,
not-exclusively</p></li><li><p>max_persons. Maximum number of persons for this
role</p></li><li><p>min_persons. Minimum number of persons for this
- role</p></li><li><p>role_name. The name of the role</p></li><li><p>information_id - references imsld_items</p></li><li><p>role_parent_id. The parent role. This allows a hierarchy
+ role</p></li><li><p>role_name. The name of the role</p></li><li><p>information_itemmodel_id - references imsld_items</p></li><li><p>parent_role_id. The parent role. This allows a hierarchy
of roles. The root of the hierarchy are learner and stuff, which
- has not a parent role</p></li></ul></div></li><li><p>imsld_activities. This table defines the three types of
- activities in IMS-LD: learning activities, support activities and
- structure activities. These three tables references to this
- table</p><div class="itemizedlist"><ul type="circle"><li><p>activity_id</p></li><li><p>activity_structure_id - references
- imsld_activity_structures</p></li></ul></div></li><li><p>imsld_learning_activities. This table stores all the learning
- activities of IMS-LD</p><div class="itemizedlist"><ul type="circle"><li><p>learning_activity_id - references imsld_activities</p></li><li><p>title</p></li><li><p>isvisible_p - initial visibility attribute. Initial value:
- true</p></li><li><p>learning_objective_id - references
- imsld_learning_objectives</p></li><li><p>prerequisite_id - references imsld_itemmodel</p></li><li><p>parameter_id - references imsld_parameters</p></li><li><p>activity_description_id - references imsld_items</p></li><li><p>complete_activity_id - references
- complete_activities</p></li><li><p>on_completion_id ** - references
- imsld_on_completions</p></li></ul></div></li><li><p>imsld_complete_activities. This is a table where for each
- entry is specified when an activity is considered completed</p><div class="itemizedlist"><ul type="circle"><li><p>complete_activity_id</p></li><li><p>user_choice - the user specifies that this activity is
- completed</p></li><li><p>time_limit - references imsld_time_limits. The activity is
- completed when the time is completed</p></li><li><p>when_property_value_is_set_id ** - references
- imsld_when_property_value_is_set</p></li></ul></div></li><li><p>imsld_learning_activity_environments_map This table maps
- learning activities with environments</p><div class="itemizedlist"><ul type="circle"><li><p>learning_activity_id - references
- imsld_learning_activities</p></li><li><p>environment_id - references imsld_environments</p></li></ul></div></li><li><p>imsld_support_activities. This table stores all the support
+ has not a parent role</p></li></ul></div></li><li><p>imsld_learning_activities. This table stores all the learning
+ activities of IMS-LD</p><div class="itemizedlist"><ul type="circle"><li><p>learning_activity_id - references imsld_activities</p></li><li><p>title</p></li><li><p>component_id - references imsld_components</p></li><li><p>isvisible_p - initial visibility attribute. Initial value:
+ true</p></li><li><p>learning_objective_itemmodel_id - references
+ imsld_itemmodels</p></li><li><p>time_limit_id - references imsld_time_limits</p></li><li><p>prerequisite_itemmodel_id - references
+ imsld_itemmodels</p></li><li><p>parameter_value</p></li><li><p>activity_description_itemmodel_id - references
+ imsld_itemmodels</p></li><li><p>on_completion_id - references imsld_on_completions</p></li><li><p>identifier - unique identifier of the activity</p></li></ul></div></li><li><p>imsld_support_activities. This table stores all the support
activities of IMS-LD</p><div class="itemizedlist"><ul type="circle"><li><p>support_activity_id - references imsld_activities</p></li><li><p>component_id - references imsld_components</p></li><li><p>isvisible_p - initial visibility attribute. Initial value:
- true</p></li><li><p>title. The name of the support activity</p></li><li><p>activity_description_id - references imsld_items</p></li><li><p>complete_activity_id - references
- imsld_complete_activities</p></li><li><p>on_completion_id - references imsld_on_completions</p></li></ul></div></li><li><p>imsld_support_activity_roles_map. This table maps a support
- role to an activity</p><div class="itemizedlist"><ul type="circle"><li><p>support_activity_id - references
- imsld_support_activities</p></li><li><p>role_id - references imsld_roles</p></li></ul></div></li><li><p>imsld_support_activity_environments_map. This table maps
- support activities with environments</p><div class="itemizedlist"><ul type="circle"><li><p>support_activity_id - references
- imsld_support_activities</p></li><li><p>environment_id - references imsld_environments</p></li></ul></div></li><li><p>imsld_activity_structures. This table contains all the
+ true</p></li><li><p>title. The name of the support activity</p></li><li><p>parameter_value</p></li><li><p>activity_description_itemmodel_id - references
+ imsld_itemmodels</p></li><li><p>user_choice - The user decides when the activity is
+ completed</p></li><li><p>time_limit_id - If user_choice is null, the activity will
+ be completed until the time referenced by this id has been
+ expired.</p></li><li><p>on_completion_id - references imsld_on_completions</p></li><li><p>identifier - unique identifier of the acrivity</p></li></ul></div></li><li><p>imsld_activity_structures. This table contains all the
activity structures of IMS-LD. Each entry is one activity
- structure.</p><div class="itemizedlist"><ul type="circle"><li><p>activity_structure_id - references imsld_activities</p></li><li><p>number_to_select - if not null, the activity structure is
+ structure.</p><div class="itemizedlist"><ul type="circle"><li><p>activity_structure_id - references imsld_activities</p></li><li><p>component_id - references imsld_components</p></li><li><p>number_to_select - if not null, the activity structure is
completed when the number of activities completed equals the
- number set</p></li><li><p>sort - possible values: as-is, visibility-order</p></li><li><p>structure_type - sequence or selection</p></li><li><p>title. The name of the activity structure</p></li><li><p>information_id - references imsld_items</p></li></ul></div></li><li><p>imsld_activity_structure_choices</p><div class="itemizedlist"><ul type="circle"><li><p>choice_id</p></li><li><p>learning_activity_id - references
- imsld_learning_activities</p></li><li><p>support_activity_id - references
- imsld_support_atcivities</p></li><li><p>unit_of_learning_id - references imsld_imslds</p></li><li><p>activity_structure_id - references
- imsld_activity_structures</p></li></ul></div></li><li><p>imsld_activity_structure_choices_map</p><div class="itemizedlist"><ul type="circle"><li><p>activity_structure_id - references
- imsld_activity_structures</p></li><li><p>choice_id - references
- imsld_activity_structure_choices</p></li></ul></div></li><li><p>imsld_activity_structure_environments_map</p><div class="itemizedlist"><ul type="circle"><li><p>activity_structure_id - references
- imsld_activity_structures</p></li><li><p>environment_id - references imsld_environments</p></li></ul></div></li><li><p>imsld_environments</p><div class="itemizedlist"><ul type="circle"><li><p>environment_id</p></li></ul></div></li><li><p>imsld_environmnent_instances</p><div class="itemizedlist"><ul type="circle"><li><p>environment_id - references imsld_environments</p></li><li><p>environmen_instance_id</p></li><li><p>title</p></li></ul></div></li><li><p>imsld_environment_instance_choices</p><div class="itemizedlist"><ul type="circle"><li><p>choice_id</p></li><li><p>learning_object_id - references
- imsld_learning_objects</p></li><li><p>service_id - references imsld_services</p></li><li><p>environment_id - references imsld_environments</p></li></ul></div></li><li><p>imsld_environment_instances_environment_instance_choices_map</p><div class="itemizedlist"><ul type="circle"><li><p>choice_id - references
- imsld_environment_instance_choices</p></li><li><p>environment_instance_id - references
- imsld_environmnent_instances</p></li></ul></div></li><li><p>imsld_learning_objects</p><div class="itemizedlist"><ul type="circle"><li><p>learning_object_id</p></li><li><p>class</p></li><li><p>isvisible_p - the user decides when the activity is
- completed?</p></li><li><p>parameter_id - references imsld_parameters</p></li><li><p>type - knowledge-object, tool-object, test-object, etc.
- (learning resource type from the IEEE LTSC LOM)</p></li><li><p>item_sequence_id - references
- ims_leanring_object_item_sequences</p></li><li><p>schema_sequence_id - references
- ims_learning_object_schema_sequences</p></li><li><p>item_id - references imsld_items</p></li><li><p>environment_id - references imsld_environments</p></li></ul></div></li><li><p>imsld_learning_object_item_sequences: First sequence of the
- learning objects</p><div class="itemizedlist"><ul type="circle"><li><p>sequence_id</p></li><li><p>title</p></li></ul></div></li><li><p>ims_learning_object_schema_sequences: Second sequence of the
- learning objects</p><div class="itemizedlist"><ul type="circle"><li><p>sequence_id</p></li><li><p>schema</p></li><li><p>schemaversion</p></li></ul></div></li><li><p>imsld_learning_object_item_sequence_items_map</p><div class="itemizedlist"><ul type="circle"><li><p>sequence_id - references
- imsld_learning_object_item_sequences</p></li><li><p>item_id - references imsld_items</p></li></ul></div></li><li><p>imsld_parameters: Table for holding the parameter values. This
- table will possible dissapear, depending if in the development phase
- there is the need of storing more information about the
- parameters</p><div class="itemizedlist"><ul type="circle"><li><p>parameter_id</p></li><li><p>parameter_value</p></li></ul></div></li><li><p>imsld_services. It contains all the services</p><div class="itemizedlist"><ul type="circle"><li><p>service_id</p></li><li><p>class</p></li><li><p>identifier</p></li><li><p>isvisible_p</p></li><li><p>parameter_id</p></li><li><p>email_service - (send_mail) references
- imsld_email_services</p></li><li><p>conference_service_id - references
- imsld_conference_services</p></li><li><p>index_search_id - refernces
- imsld_index_search_services</p></li></ul></div></li><li><p>imsld_email_services. It describes all the email
- services</p><div class="itemizedlist"><ul type="circle"><li><p>email_id - references imsld_services</p></li><li><p>select - all-persons-in-role, persons-in-role</p></li><li><p>title</p></li></ul></div></li><li><p>imsld_email_data</p><div class="itemizedlist"><ul type="circle"><li><p>email_data_id</p></li><li><p>role_id - references imsld_roles</p></li><li><p>email_property_id - references imsld_properties **</p></li><li><p>username_property_id - references imsld_properties
- **</p></li></ul></div></li><li><p>imsld_email_service_email_data_map</p><div class="itemizedlist"><ul type="circle"><li><p>email_id - references imsld_email_services</p></li><li><p>email_data_id - references imsld_email_data</p></li></ul></div></li><li><p>imsld_conference_services</p><div class="itemizedlist"><ul type="circle"><li><p>conference_id</p></li><li><p>conference_type - synchronous, asynchronous or
- announcement</p></li><li><p>title</p></li><li><p>conference_manager_id - references imsld_roles</p></li><li><p>moderator_id - references imsld_roles</p></li><li><p>item_id - references imsld_items</p></li></ul></div></li><li><p>imsld_conference_participants_or_observers_map</p><div class="itemizedlist"><ul type="circle"><li><p>conference_id - references
- imsld_conference_services</p></li><li><p>role_id - references imsld_roles</p></li></ul></div></li><li><p>imsld_index_search_services</p><div class="itemizedlist"><ul type="circle"><li><p>search_service_id</p></li><li><p>title</p></li><li><p>index_class - this element selects the calss to make the
+ number set</p></li><li><p>sort - possible values: as-is, visibility-order</p></li><li><p>structure_type - sequence or selection</p></li><li><p>title. The name of the activity structure</p></li><li><p>information_itemmodel_id - references
+ imsld_itemmodels</p></li><li><p>identifier</p></li></ul></div></li><li><p>imsld_environments. This table contains the environments of
+ the unit of learning. An environment consists of learning objects,
+ services and other environments, and it can be referentiated by some
+ other tables too.</p><div class="itemizedlist"><ul type="circle"><li><p>environment_id</p></li><li><p>parent_environment_id</p></li><li><p>title</p></li></ul></div></li><li><p>imsld_learning_objects</p><div class="itemizedlist"><ul type="circle"><li><p>learning_object_id</p></li><li><p>class</p></li><li><p>isvisible_p - the user decides when the activity is
+ completed?</p></li><li><p>parameter_value</p></li><li><p>type - knowledge-object, tool-object, test-object, etc.
+ (learning resource type from the IEEE LTSC LOM)</p></li><li><p>environment_id - references imsld_environments</p></li><li><p>schema_version</p></li></ul></div></li><li><p>imsld_email_services. It describes all the email
+ services</p><div class="itemizedlist"><ul type="circle"><li><p>email_service_id</p></li><li><p>select - all-persons-in-role, persons-in-role</p></li><li><p>title</p></li><li><p>is_visible_p</p></li></ul></div></li><li><p>imsld_email_data</p><div class="itemizedlist"><ul type="circle"><li><p>sendmail_service_id - references
+ imsld_email_services</p></li><li><p>role_id - references imsld_roles</p></li><li><p>email_data</p></li><li><p>email_property_id - references imsld_properties **</p></li><li><p>username_property_id - references imsld_properties
+ **</p></li></ul></div></li><li><p>imsld_conference_services</p><div class="itemizedlist"><ul type="circle"><li><p>conference_id</p></li><li><p>conference_type - synchronous, asynchronous or
+ announcement</p></li><li><p>title</p></li><li><p>item_id - references imsld_items</p></li><li><p>is_visible_p</p></li></ul></div></li><li><p>imsld_index_search_services</p><div class="itemizedlist"><ul type="circle"><li><p>search_service_id</p></li><li><p>title</p></li><li><p>index_class - this element selects the calss to make the
index on</p></li><li><p>index_element - this element selects the element to make
- the index on</p></li><li><p>index_type_of_element - type of element to index on</p></li><li><p>search - how a user can access the indexed entities</p></li><li><p>search_type - type of search facility that is expected at
+ the index on</p></li><li><p>index_type_of_element - type of element to index on</p></li><li><p>search_type - type of search facility that is expected at
runtime: free-text-search, index-with-reference,
- index-without-reference</p></li></ul></div></li><li><p>imsld_learning_objectives. This table contains all the
- different objectives of the different unit of learning and
- activities. Each entry of this table is a set of objectives. A set
- of objectives is symbolized by an itemmodel_id</p><div class="itemizedlist"><ul type="circle"><li><p>learning_objective_id</p></li><li><p>itemmodel_id - references imsld_itemmodels</p></li></ul></div></li><li><p>imsld_methods</p><div class="itemizedlist"><ul type="circle"><li><p>method_id</p></li><li><p>time_limit_id - references imsld_time_limits. If not null,
+ index-without-reference</p></li><li><p>is_visible_p</p></li></ul></div></li><li><p>imsld_methods</p><div class="itemizedlist"><ul type="circle"><li><p>method_id</p></li><li><p>time_limit_id - references imsld_time_limits. If not null,
the method is completed when this time has been completed,
otherwise, the method is completed when all the plays mapped to
this method through the imsld_plays_to_complete_method are
- completed</p></li><li><p>on_completion_id - references imsld_on_completions</p></li><li><p>condition_id ** - references imsld_conditions</p></li></ul></div></li><li><p>imsld_plays_to_complete_method. It contains all the plays that
- has a method. Each play can be selected in parallel by an user
- during the delivering of a unit of learning</p><div class="itemizedlist"><ul type="circle"><li><p>method_id</p></li><li><p>play_id</p></li></ul></div></li><li><p>imsld_plays</p><div class="itemizedlist"><ul type="circle"><li><p>play_id</p></li><li><p>isvisible_p - the user decides when the activity is
- completed?</p></li><li><p>title</p></li><li><p>complete_play_id - references imsld_complete_play</p></li><li><p>on_completion_id - references imsld_on_completions</p></li></ul></div></li><li><p>imsld_complete_play</p><div class="itemizedlist"><ul type="circle"><li><p>complete_play_id</p></li><li><p>when_last_act_completed - references imsld_acts. The play
- is completed when this act is completed</p></li><li><p>time_limit_id - references imsld_time_limits. The play is
- completed when this time is completed</p></li><li><p>when_property_value_is_set_id * - references
- imsld_when_property_value_is_set</p></li></ul></div></li><li><p>imsld_method_plays_map</p><div class="itemizedlist"><ul type="circle"><li><p>method_id - references imsld_methods</p></li><li><p>play_id - references imsld_plays</p></li></ul></div></li><li><p>imsld_play_acts_map</p><div class="itemizedlist"><ul type="circle"><li><p>play_id - references imsld_plays</p></li><li><p>act_id - references imsld_acts</p></li></ul></div></li><li><p>imsld_acts</p><div class="itemizedlist"><ul type="circle"><li><p>act_id</p></li><li><p>title</p></li><li><p>complete_act_id - references imsld_complete_acts</p></li><li><p>on_completion_id - references on_completion</p></li><li><p>when_condition_true ** - references
- imsld_when_condition_true</p></li></ul></div></li><li><p>imsld_complete_acts</p><div class="itemizedlist"><ul type="circle"><li><p>complete_act_id</p></li><li><p>time_limit_id - references imsld_complete_acts. When not
- null, the act is completed when this time has been completed,
- otherwise, the act is completed until all role parts mapped to
- this complete_act_id trhoug the imsld_act_role_parts are
- completed</p></li><li><p>when_property_value_is_set_id ** - references
- imsld_when_property_value_is_set</p></li></ul></div></li><li><p>imsld_act_role_parts</p><div class="itemizedlist"><ul type="circle"><li><p>complete_act_id - references imsld_acts</p></li><li><p>role_part_id - references imsld_part_id</p></li></ul></div></li><li><p>imsld_act_role_parts_map</p><div class="itemizedlist"><ul type="circle"><li><p>role_part_id - references imsld_role_parts</p></li><li><p>act_id - references imsld_acts</p></li></ul></div></li><li><p>imsld_role_part_choices</p><div class="itemizedlist"><ul type="circle"><li><p>choice_id</p></li><li><p>learning_activity_id - references
- imsld_learning_activities</p></li><li><p>support_activity_id - references
- imsld_support_activities</p></li><li><p>unit_of_learning_id - references imsld_imslds</p></li><li><p>activity_structure_id - references
- imsld_activity_structures</p></li><li><p>environment_id - references imsld_environments</p></li></ul></div></li><li><p>imsld_role_parts - mapping table between acts and roles</p><div class="itemizedlist"><ul type="circle"><li><p>role_part_id</p></li><li><p>title</p></li><li><p>role_id - references imsld_roles</p></li><li><p>choice_id - references imsld_role_part_choices</p></li></ul></div></li><li><p>imsld_on_completion</p><div class="itemizedlist"><ul type="circle"><li><p>on_completion_id</p></li><li><p>feedback_description_id - references
+ completed</p></li><li><p>on_completion_id - references imsld_on_completions</p></li><li><p>condition_id ** - references imsld_conditions</p></li></ul></div></li><li><p>imsld_plays</p><div class="itemizedlist"><ul type="circle"><li><p>play_id</p></li><li><p>method_id - references imsld_methods</p></li><li><p>is_visible_p - the user decides when the activity is
+ completed?</p></li><li><p>title</p></li><li><p>when_last_act_completed the play is completed until the
+ act referenced by this field is completed</p></li><li><p>time_limit_id - references time_limits. If
+ when_last_act_completed is null, the play is completed when the
+ time indicated here has been completed</p></li><li><p>on_completion_id - references imsld_on_completions</p></li></ul></div></li><li><p>imsld_acts</p><div class="itemizedlist"><ul type="circle"><li><p>act_id</p></li><li><p>play_id - references imsld_plays</p></li><li><p>title</p></li><li><p>time_limit_id - if there are no role_parts mapped to this
+ act throug the mapping table (explained later), the act is
+ completed until the the time indicated here has been
+ completed</p></li><li><p>on_completion_id - references on_completion</p></li><li><p>when_property_value_is_set ** - references
+ imsld_when_property_value_is_set</p></li></ul></div></li><li><p>imsld_role_parts</p><div class="itemizedlist"><ul type="circle"><li><p>role_part_id - references imsld_part_id</p></li><li><p>act_id - references imsld_acts</p></li><li><p>role_id</p></li><li><p>unit_of_learning_id - references imsld_imslds</p></li><li><p>environment_id - references imsld_environments</p></li></ul></div></li><li><p>imsld_on_completion</p><div class="itemizedlist"><ul type="circle"><li><p>on_completion_id</p></li><li><p>feedback_description_id - references
imsld_itemmodels</p></li><li><p>change_property_value_id ** - references
imsld_change_property_value</p></li><li><p>notification_id - references imsld_notifications
***</p></li></ul></div></li><li><p>imsld_itemmodels. This is a table that contains a text and an
id. In conjunction with the tables imsld_itemmodel and
imsld_itemmodel_items_map allow to associate several items to the
- same itemmodel.</p><div class="itemizedlist"><ul type="circle"><li><p>title</p></li><li><p>itemmodel_id</p></li></ul></div></li><li><p>imsld_itemmodel_items_map</p><div class="itemizedlist"><ul type="circle"><li><p>item_id - references imsld_items</p></li><li><p>itemmodel_id - references imsld_itemmodels</p></li></ul></div></li><li><p>imsld_items. Items are used for multiple purposes in other
+ same itemmodel.</p><div class="itemizedlist"><ul type="circle"><li><p>title</p></li><li><p>itemmodel_id</p></li></ul></div></li><li><p>imsld_items. Items are used for multiple purposes in other
tables. For example it can describe objectives, prerequisites,
- references to files, etc.</p><div class="itemizedlist"><ul type="circle"><li><p>item_id</p></li><li><p>identifier. Unique identifier for the IMS-LD</p></li><li><p>identifierref. It references the IMS CP</p></li><li><p>isvisible_p.</p></li><li><p>parameter_id</p></li><li><p>title: A text that can represent a prerequisite, an
- objective, the name of a file, etc.</p></li><li><p>parent_item - references imsld_items. An item can
- reference to another item, which is a sub-item or child of the
- one referencing it.</p></li></ul></div></li><li><p>imsld_time_limits</p><div class="itemizedlist"><ul type="circle"><li><p>time_limit_id</p></li><li><p>time_limit - amount of time in a specific format</p></li><li><p>property_id ** - references imsld_properties</p></li></ul></div></li></ul></div><p>Next, the tables necessary for Level A are draw in the
- form of an E-R diagram</p><p><a href="resources/imsld_diagram_A.GIF" target="_top"><span class="inlinemediaobject"><img src="resources/imsld_diagram_A.GIF"></span></a></p></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="ch04.html">Prev</a>�</td><td width="20%" align="center"><a accesskey="u" href="ch04.html">Up</a></td><td width="40%" align="right">�<a accesskey="n" href="ch04s02.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Chapter�4.�Data Model�</td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top">�Level B</td></tr></table></div></body></html>
+ references to files, etc.</p><div class="itemizedlist"><ul type="circle"><li><p>item_id</p></li><li><p>identifier. Unique identifier for the IMS-LD</p></li><li><p>is_visible_p</p></li><li><p>title: A text that can represent a prerequisite, an
+ objective, the name of a file, etc.</p></li></ul></div></li><li><p>imsld_time_limits</p><div class="itemizedlist"><ul type="circle"><li><p>time_limit_id</p></li><li><p>time_limit - amount of time in a specific format</p></li><li><p>property_id ** - references imsld_properties</p></li></ul></div></li><li><p>imsld_parameters</p><div class="itemizedlist"><ul type="circle"><li><p>parameter_id</p></li><li><p>parameter_value</p></li></ul></div></li><li><p>imsld_imsld_objects_map. This is a very importan table in this
+ data model, because it is used to map almost every imsld_* to every
+ imsld_*. For instance, the activities that are part of a component
+ are mapped by this table, and the acts to complete play are also
+ mapped using this table. This is just a representation of the
+ acs_rels table, because at the implementation phase, acs_rels will
+ be used with different rel_types</p><div class="itemizedlist"><ul type="circle"><li><p>imsld_object_one_id - references imsld_*
+ (acs_objects)</p></li><li><p>imsld_object_one_type - wich can be: learning_object,
+ imsld_item, imsld_role, support_activity, etc</p></li><li><p>imsld_object_two_id - references imsld_*
+ (acs_objects)</p></li><li><p>imsld_object_two_type - same as
+ imsld_object_one_type</p></li></ul></div></li></ul></div><p>IMPORTANT NOTES:</p><div class="orderedlist"><ol type="1"><li><p>The last table will use acs_rels. The rel_types will be
+ completely defined in the implementation phase. By now we can think
+ of: parent_item_rel, role_parts_activites_rel, component_service_rels,
+ service_roles_rel, learning_object_item_rel,
+ plays_to_complete_method_rel and role_parts_to_complete_act.</p></li><li><p>There are some important IMS-LD tags (learning objectives, for
+ instance) that does not have a table for themselves, but this is
+ because such tags consist only of a reference to a itemmodel or
+ another table, so there is no need to create a table just for
+ that.</p></li><li><p>This data model can (and it is 99% sure) change in the
+ implementation phase, but we will base the development on this data
+ model.</p></li><li><p>There are some tables in this data model that will be related to
+ some others of other .LRN packages. For instance, the table
+ imsld_conferences will be used to store the synchronous type (forums)
+ and asynchronous type (chats) of conferences. Also, we will use
+ acs_objects for the imslds, activities, services, learning_objects,
+ components, and for every case we find it useful. We can make use of
+ the cr_items too. But that is something that we will know better in
+ the implementation phase.</p></li></ol></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="ch04.html">Prev</a>�</td><td width="20%" align="center"><a accesskey="u" href="ch04.html">Up</a></td><td width="40%" align="right">�<a accesskey="n" href="ch04s02.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Chapter�4.�Data Model�</td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top">�Level B</td></tr></table></div></body></html>
Index: openacs-4/packages/imsld/www/doc/ch04s02.html
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/doc/ch04s02.html,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/imsld/www/doc/ch04s02.html 30 Jun 2005 10:43:20 -0000 1.4
+++ openacs-4/packages/imsld/www/doc/ch04s02.html 5 Jul 2005 16:13:45 -0000 1.5
@@ -5,7 +5,7 @@
if(pos=="center"){LeftPosition=(screen.width)?(screen.width-w)/2:100;TopPosition=(screen.height)?(screen.height-h)/2:100;}
settings='width='+w+',height='+h+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no';
win=window.open(mypage,myname,settings);}
- </script></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Level B</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch04s01.html">Prev</a>�</td><th width="60%" align="center">Chapter�4.�Data Model</th><td width="20%" align="right">�<a accesskey="n" href="ch04s03.html">Next</a></td></tr></table><hr></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="id2579149"></a>Level B</h2></div></div></div><p>Level B extends the table email_data and add: username_property_id
+ </script></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Level B</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch04s01.html">Prev</a>�</td><th width="60%" align="center">Chapter�4.�Data Model</th><td width="20%" align="right">�<a accesskey="n" href="ch04s03.html">Next</a></td></tr></table><hr></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="id2596546"></a>Level B</h2></div></div></div><p>Level B extends the table email_data and add: username_property_id
and email_property_id (**) Next is shown the E-R diagram for these
tables</p><p><a href="resources/imsld_diagram_B.GIF" target="_top"><span class="inlinemediaobject"><img src="resources/imsld_diagram_B.GIF"></span></a></p><div class="itemizedlist"><ul type="disc"><li><p>imsld_properties (add a reference to properties from
imsld_components and time_limits **)</p><div class="itemizedlist"><ul type="circle"><li><p>property_id</p></li></ul></div></li><li><p>imsld_loc_locpers_locrole_properties: Combined table for the
Index: openacs-4/packages/imsld/www/doc/ch04s03.html
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/doc/ch04s03.html,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/imsld/www/doc/ch04s03.html 30 Jun 2005 10:43:20 -0000 1.4
+++ openacs-4/packages/imsld/www/doc/ch04s03.html 5 Jul 2005 16:13:45 -0000 1.5
@@ -5,7 +5,7 @@
if(pos=="center"){LeftPosition=(screen.width)?(screen.width-w)/2:100;TopPosition=(screen.height)?(screen.height-h)/2:100;}
settings='width='+w+',height='+h+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no';
win=window.open(mypage,myname,settings);}
- </script></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Level C</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch04s02.html">Prev</a>�</td><th width="60%" align="center">Chapter�4.�Data Model</th><td width="20%" align="right">�<a accesskey="n" href="ch04s04.html">Next</a></td></tr></table><hr></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="id2587589"></a>Level C</h2></div></div></div><p>Modify the imsld_email_data (***), add a reference to
+ </script></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Level C</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch04s02.html">Prev</a>�</td><th width="60%" align="center">Chapter�4.�Data Model</th><td width="20%" align="right">�<a accesskey="n" href="ch04s04.html">Next</a></td></tr></table><hr></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="id2583297"></a>Level C</h2></div></div></div><p>Modify the imsld_email_data (***), add a reference to
imsld_notifications table from imsld_on_completion, imsld_thens and
imsld_view_set_properties table (***). Next is shown the E-R diagram that
adds Level C</p><p><a href="resources/imsld_diagram_C.GIF" target="_top"><span class="inlinemediaobject"><img src="resources/imsld_diagram_C.GIF"></span></a></p><div class="itemizedlist"><ul type="disc"><li><p>imsld_notifications</p><div class="itemizedlist"><ul type="circle"><li><p>notification_id</p></li><li><p>choice_id - references imsld_notifications_choice</p></li><li><p>subject</p></li></ul></div></li><li><p>imsld_notification_emails_data_map</p><div class="itemizedlist"><ul type="circle"><li><p>notification_id - references imsld_notifications</p></li><li><p>email_data_id - references imsld_email_data</p></li></ul></div></li><li><p>imsld_notifications_choice</p><div class="itemizedlist"><ul type="circle"><li><p>choice_id</p></li><li><p>learning_activity_id - references
Index: openacs-4/packages/imsld/www/doc/ch04s04.html
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/doc/ch04s04.html,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/imsld/www/doc/ch04s04.html 30 Jun 2005 10:43:20 -0000 1.4
+++ openacs-4/packages/imsld/www/doc/ch04s04.html 5 Jul 2005 16:13:45 -0000 1.5
@@ -5,7 +5,7 @@
if(pos=="center"){LeftPosition=(screen.width)?(screen.width-w)/2:100;TopPosition=(screen.height)?(screen.height-h)/2:100;}
settings='width='+w+',height='+h+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no';
win=window.open(mypage,myname,settings);}
- </script></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Run Tables</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch04s03.html">Prev</a>�</td><th width="60%" align="center">Chapter�4.�Data Model</th><td width="20%" align="right">�<a accesskey="n" href="ch05.html">Next</a></td></tr></table><hr></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="id2583144"></a>Run Tables</h2></div></div></div><p>The previous tables are referred to the IMS-LD specifications level
+ </script></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Run Tables</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch04s03.html">Prev</a>�</td><th width="60%" align="center">Chapter�4.�Data Model</th><td width="20%" align="right">�<a accesskey="n" href="ch05.html">Next</a></td></tr></table><hr></div><div class="section" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="id2584898"></a>Run Tables</h2></div></div></div><p>The previous tables are referred to the IMS-LD specifications level
A, B and C. They have all the information necessary to map an XML
compliant IMS-LD document to the tables in the .LRN platform. But also,
for the ims-ld package to interact with real users, we need additional
Index: openacs-4/packages/imsld/www/doc/xmlfiles/imsld-data-model.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/doc/xmlfiles/imsld-data-model.xml,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/imsld/www/doc/xmlfiles/imsld-data-model.xml 30 Jun 2005 10:31:51 -0000 1.1
+++ openacs-4/packages/imsld/www/doc/xmlfiles/imsld-data-model.xml 5 Jul 2005 16:13:45 -0000 1.2
@@ -33,14 +33,24 @@
<section>
<title>Level A</title>
+ <para>Next, the tables necessary for Level A are draw in the form of an
+ E-R diagram</para>
+
+ <para><ulink url="resources/imsld_diagram_A.GIF"><inlinemediaobject>
+ <imageobject>
+ <imagedata fileref="resources/imsld_diagram_A.GIF" />
+ </imageobject>
+ </inlinemediaobject></ulink></para>
+
<para><itemizedlist>
<listitem>
<para>imsld_imslds: This table is used to store all the units of
learning. This is the high level in the hierarchy. Each IMS-LD file
- loaded in .LRN will generate an entrance in this table. This table
+ loaded in .LRN will generate a row in this table. This table
contains all the different units of learning. Each unit of learning
- will contain global information and also references to other tables
- for having all the required information of a unit of learning</para>
+ will contain global information and also references to other tables,
+ in order to represent completely the information represented by the
+ unit of learning.</para>
<itemizedlist>
<listitem>
@@ -52,22 +62,19 @@
</listitem>
<listitem>
- <para>uri - uri of the imsld</para>
- </listitem>
-
- <listitem>
<para>level - A, B or C. It is the level of the IMS-LD file that
arrive</para>
</listitem>
<listitem>
- <para>sequence_p - sequence used, true or false. True means
+ <para>sequence_used_p - sequence used, true or false. True means
simple sequencing is being used. Defaults to false</para>
</listitem>
<listitem>
- <para>learning_objective_id - references
- imsld_learning_objectives</para>
+ <para>learning_objective_itemmodel_id - references
+ imsld_itemmodels and contains the objectives of the unit of
+ learning</para>
</listitem>
<listitem>
@@ -79,55 +86,26 @@
</listitem>
<listitem>
- <para>prerequisite_id - references imsld_itemmodel</para>
+ <para>prerequisite_itemmodel_id - references imsld_itemmodels
+ and contains the prerequisites for the unit of learning</para>
</listitem>
<listitem>
<para>component_id - references imsld_components</para>
</listitem>
<listitem>
- <para>complete_unit_of_learning_id - references
- complete_unit_of_learning</para>
+ <para>when_property_value_is_set** - references
+ imsld_when_property_value_is_set. Treated with more detail in
+ level B</para>
</listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_complete_unit_of_learning. This tables describes the
- actions to do when a unit of learning is completed</para>
-
- <itemizedlist>
- <listitem>
- <para>complete_unit_of_learning_id</para>
- </listitem>
-
- <listitem>
- <para>when_property_value_is_set_id ** - references
- imsld_when_property_value_is_set</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
- <para>imsld_prerequisites. It has all the prerequisites of a unit of
- learning. These are the previous knolowdges that are required for
- doing the unit of learning</para>
-
- <itemizedlist>
- <listitem>
- <para>prerequisite_id</para>
- </listitem>
-
- <listitem>
- <para>prerequisite_item - references imsld_items</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
<para>imsld_components: Used to store all the components of the
- IMS-LD</para>
+ IMS-LD (which are: roles, acitivities and environments. The
+ activities references this table)</para>
<itemizedlist>
<listitem>
@@ -139,10 +117,6 @@
</listitem>
<listitem>
- <para>activity_id - references imsld_activities</para>
- </listitem>
-
- <listitem>
<para>environment_id - references imsld_environments</para>
</listitem>
@@ -161,7 +135,7 @@
</listitem>
<listitem>
- <para>role_types - references role_types_id</para>
+ <para>role_type</para>
</listitem>
<listitem>
@@ -170,7 +144,7 @@
</listitem>
<listitem>
- <para>match_n_persons - exclusively-in-roles,
+ <para>match_persons - exclusively-in-roles,
not-exclusively</para>
</listitem>
@@ -189,36 +163,18 @@
</listitem>
<listitem>
- <para>information_id - references imsld_items</para>
+ <para>information_itemmodel_id - references imsld_items</para>
</listitem>
<listitem>
- <para>role_parent_id. The parent role. This allows a hierarchy
+ <para>parent_role_id. The parent role. This allows a hierarchy
of roles. The root of the hierarchy are learner and stuff, which
has not a parent role</para>
</listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_activities. This table defines the three types of
- activities in IMS-LD: learning activities, support activities and
- structure activities. These three tables references to this
- table</para>
-
- <itemizedlist>
- <listitem>
- <para>activity_id</para>
- </listitem>
-
- <listitem>
- <para>activity_structure_id - references
- imsld_activity_structures</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
<para>imsld_learning_activities. This table stores all the learning
activities of IMS-LD</para>
@@ -232,82 +188,48 @@
</listitem>
<listitem>
- <para>isvisible_p - initial visibility attribute. Initial value:
- true</para>
+ <para>component_id - references imsld_components</para>
</listitem>
<listitem>
- <para>learning_objective_id - references
- imsld_learning_objectives</para>
+ <para>isvisible_p - initial visibility attribute. Initial value:
+ true</para>
</listitem>
<listitem>
- <para>prerequisite_id - references imsld_itemmodel</para>
+ <para>learning_objective_itemmodel_id - references
+ imsld_itemmodels</para>
</listitem>
<listitem>
- <para>parameter_id - references imsld_parameters</para>
+ <para>time_limit_id - references imsld_time_limits</para>
</listitem>
<listitem>
- <para>activity_description_id - references imsld_items</para>
+ <para>prerequisite_itemmodel_id - references
+ imsld_itemmodels</para>
</listitem>
<listitem>
- <para>complete_activity_id - references
- complete_activities</para>
+ <para>parameter_value</para>
</listitem>
<listitem>
- <para>on_completion_id ** - references
- imsld_on_completions</para>
+ <para>activity_description_itemmodel_id - references
+ imsld_itemmodels</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_complete_activities. This is a table where for each
- entry is specified when an activity is considered completed</para>
-
- <itemizedlist>
<listitem>
- <para>complete_activity_id</para>
+ <para>on_completion_id - references imsld_on_completions</para>
</listitem>
<listitem>
- <para>user_choice - the user specifies that this activity is
- completed</para>
+ <para>identifier - unique identifier of the activity</para>
</listitem>
-
- <listitem>
- <para>time_limit - references imsld_time_limits. The activity is
- completed when the time is completed</para>
- </listitem>
-
- <listitem>
- <para>when_property_value_is_set_id ** - references
- imsld_when_property_value_is_set</para>
- </listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_learning_activity_environments_map This table maps
- learning activities with environments</para>
-
- <itemizedlist>
- <listitem>
- <para>learning_activity_id - references
- imsld_learning_activities</para>
- </listitem>
-
- <listitem>
- <para>environment_id - references imsld_environments</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
<para>imsld_support_activities. This table stores all the support
activities of IMS-LD</para>
@@ -330,49 +252,32 @@
</listitem>
<listitem>
- <para>activity_description_id - references imsld_items</para>
+ <para>parameter_value</para>
</listitem>
<listitem>
- <para>complete_activity_id - references
- imsld_complete_activities</para>
+ <para>activity_description_itemmodel_id - references
+ imsld_itemmodels</para>
</listitem>
<listitem>
- <para>on_completion_id - references imsld_on_completions</para>
+ <para>user_choice - The user decides when the activity is
+ completed</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_support_activity_roles_map. This table maps a support
- role to an activity</para>
-
- <itemizedlist>
<listitem>
- <para>support_activity_id - references
- imsld_support_activities</para>
+ <para>time_limit_id - If user_choice is null, the activity will
+ be completed until the time referenced by this id has been
+ expired.</para>
</listitem>
<listitem>
- <para>role_id - references imsld_roles</para>
+ <para>on_completion_id - references imsld_on_completions</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_support_activity_environments_map. This table maps
- support activities with environments</para>
-
- <itemizedlist>
<listitem>
- <para>support_activity_id - references
- imsld_support_activities</para>
+ <para>identifier - unique identifier of the acrivity</para>
</listitem>
-
- <listitem>
- <para>environment_id - references imsld_environments</para>
- </listitem>
</itemizedlist>
</listitem>
@@ -387,6 +292,10 @@
</listitem>
<listitem>
+ <para>component_id - references imsld_components</para>
+ </listitem>
+
+ <listitem>
<para>number_to_select - if not null, the activity structure is
completed when the number of activities completed equals the
number set</para>
@@ -405,139 +314,38 @@
</listitem>
<listitem>
- <para>information_id - references imsld_items</para>
+ <para>information_itemmodel_id - references
+ imsld_itemmodels</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_activity_structure_choices</para>
-
- <itemizedlist>
<listitem>
- <para>choice_id</para>
+ <para>identifier</para>
</listitem>
-
- <listitem>
- <para>learning_activity_id - references
- imsld_learning_activities</para>
- </listitem>
-
- <listitem>
- <para>support_activity_id - references
- imsld_support_atcivities</para>
- </listitem>
-
- <listitem>
- <para>unit_of_learning_id - references imsld_imslds</para>
- </listitem>
-
- <listitem>
- <para>activity_structure_id - references
- imsld_activity_structures</para>
- </listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_activity_structure_choices_map</para>
+ <para>imsld_environments. This table contains the environments of
+ the unit of learning. An environment consists of learning objects,
+ services and other environments, and it can be referentiated by some
+ other tables too.</para>
<itemizedlist>
<listitem>
- <para>activity_structure_id - references
- imsld_activity_structures</para>
- </listitem>
-
- <listitem>
- <para>choice_id - references
- imsld_activity_structure_choices</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
- <para>imsld_activity_structure_environments_map</para>
-
- <itemizedlist>
- <listitem>
- <para>activity_structure_id - references
- imsld_activity_structures</para>
- </listitem>
-
- <listitem>
- <para>environment_id - references imsld_environments</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
- <para>imsld_environments</para>
-
- <itemizedlist>
- <listitem>
<para>environment_id</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_environmnent_instances</para>
-
- <itemizedlist>
<listitem>
- <para>environment_id - references imsld_environments</para>
+ <para>parent_environment_id</para>
</listitem>
<listitem>
- <para>environmen_instance_id</para>
- </listitem>
-
- <listitem>
<para>title</para>
</listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_environment_instance_choices</para>
-
- <itemizedlist>
- <listitem>
- <para>choice_id</para>
- </listitem>
-
- <listitem>
- <para>learning_object_id - references
- imsld_learning_objects</para>
- </listitem>
-
- <listitem>
- <para>service_id - references imsld_services</para>
- </listitem>
-
- <listitem>
- <para>environment_id - references imsld_environments</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
- <para>imsld_environment_instances_environment_instance_choices_map</para>
-
- <itemizedlist>
- <listitem>
- <para>choice_id - references
- imsld_environment_instance_choices</para>
- </listitem>
-
- <listitem>
- <para>environment_instance_id - references
- imsld_environmnent_instances</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
<para>imsld_learning_objects</para>
<itemizedlist>
@@ -555,7 +363,7 @@
</listitem>
<listitem>
- <para>parameter_id - references imsld_parameters</para>
+ <para>parameter_value</para>
</listitem>
<listitem>
@@ -564,164 +372,56 @@
</listitem>
<listitem>
- <para>item_sequence_id - references
- ims_leanring_object_item_sequences</para>
- </listitem>
-
- <listitem>
- <para>schema_sequence_id - references
- ims_learning_object_schema_sequences</para>
- </listitem>
-
- <listitem>
- <para>item_id - references imsld_items</para>
- </listitem>
-
- <listitem>
<para>environment_id - references imsld_environments</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_learning_object_item_sequences: First sequence of the
- learning objects</para>
-
- <itemizedlist>
<listitem>
- <para>sequence_id</para>
+ <para>schema_version</para>
</listitem>
-
- <listitem>
- <para>title</para>
- </listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>ims_learning_object_schema_sequences: Second sequence of the
- learning objects</para>
+ <para>imsld_email_services. It describes all the email
+ services</para>
<itemizedlist>
<listitem>
- <para>sequence_id</para>
+ <para>email_service_id</para>
</listitem>
<listitem>
- <para>schema</para>
+ <para>select - all-persons-in-role, persons-in-role</para>
</listitem>
<listitem>
- <para>schemaversion</para>
+ <para>title</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_learning_object_item_sequence_items_map</para>
-
- <itemizedlist>
<listitem>
- <para>sequence_id - references
- imsld_learning_object_item_sequences</para>
+ <para>is_visible_p</para>
</listitem>
-
- <listitem>
- <para>item_id - references imsld_items</para>
- </listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_parameters: Table for holding the parameter values. This
- table will possible dissapear, depending if in the development phase
- there is the need of storing more information about the
- parameters</para>
+ <para>imsld_email_data</para>
<itemizedlist>
<listitem>
- <para>parameter_id</para>
- </listitem>
-
- <listitem>
- <para>parameter_value</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
- <para>imsld_services. It contains all the services</para>
-
- <itemizedlist>
- <listitem>
- <para>service_id</para>
- </listitem>
-
- <listitem>
- <para>class</para>
- </listitem>
-
- <listitem>
- <para>identifier</para>
- </listitem>
-
- <listitem>
- <para>isvisible_p</para>
- </listitem>
-
- <listitem>
- <para>parameter_id</para>
- </listitem>
-
- <listitem>
- <para>email_service - (send_mail) references
+ <para>sendmail_service_id - references
imsld_email_services</para>
</listitem>
<listitem>
- <para>conference_service_id - references
- imsld_conference_services</para>
+ <para>role_id - references imsld_roles</para>
</listitem>
<listitem>
- <para>index_search_id - refernces
- imsld_index_search_services</para>
+ <para>email_data</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_email_services. It describes all the email
- services</para>
-
- <itemizedlist>
<listitem>
- <para>email_id - references imsld_services</para>
- </listitem>
-
- <listitem>
- <para>select - all-persons-in-role, persons-in-role</para>
- </listitem>
-
- <listitem>
- <para>title</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
- <para>imsld_email_data</para>
-
- <itemizedlist>
- <listitem>
- <para>email_data_id</para>
- </listitem>
-
- <listitem>
- <para>role_id - references imsld_roles</para>
- </listitem>
-
- <listitem>
<para>email_property_id - references imsld_properties **</para>
</listitem>
@@ -733,20 +433,6 @@
</listitem>
<listitem>
- <para>imsld_email_service_email_data_map</para>
-
- <itemizedlist>
- <listitem>
- <para>email_id - references imsld_email_services</para>
- </listitem>
-
- <listitem>
- <para>email_data_id - references imsld_email_data</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
<para>imsld_conference_services</para>
<itemizedlist>
@@ -764,31 +450,12 @@
</listitem>
<listitem>
- <para>conference_manager_id - references imsld_roles</para>
- </listitem>
-
- <listitem>
- <para>moderator_id - references imsld_roles</para>
- </listitem>
-
- <listitem>
<para>item_id - references imsld_items</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_conference_participants_or_observers_map</para>
-
- <itemizedlist>
<listitem>
- <para>conference_id - references
- imsld_conference_services</para>
+ <para>is_visible_p</para>
</listitem>
-
- <listitem>
- <para>role_id - references imsld_roles</para>
- </listitem>
</itemizedlist>
</listitem>
@@ -819,31 +486,14 @@
</listitem>
<listitem>
- <para>search - how a user can access the indexed entities</para>
- </listitem>
-
- <listitem>
<para>search_type - type of search facility that is expected at
runtime: free-text-search, index-with-reference,
index-without-reference</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_learning_objectives. This table contains all the
- different objectives of the different unit of learning and
- activities. Each entry of this table is a set of objectives. A set
- of objectives is symbolized by an itemmodel_id</para>
-
- <itemizedlist>
<listitem>
- <para>learning_objective_id</para>
+ <para>is_visible_p</para>
</listitem>
-
- <listitem>
- <para>itemmodel_id - references imsld_itemmodels</para>
- </listitem>
</itemizedlist>
</listitem>
@@ -874,31 +524,19 @@
</listitem>
<listitem>
- <para>imsld_plays_to_complete_method. It contains all the plays that
- has a method. Each play can be selected in parallel by an user
- during the delivering of a unit of learning</para>
+ <para>imsld_plays</para>
<itemizedlist>
<listitem>
- <para>method_id</para>
- </listitem>
-
- <listitem>
<para>play_id</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_plays</para>
-
- <itemizedlist>
<listitem>
- <para>play_id</para>
+ <para>method_id - references imsld_methods</para>
</listitem>
<listitem>
- <para>isvisible_p - the user decides when the activity is
+ <para>is_visible_p - the user decides when the activity is
completed?</para>
</listitem>
@@ -907,202 +545,83 @@
</listitem>
<listitem>
- <para>complete_play_id - references imsld_complete_play</para>
+ <para>when_last_act_completed the play is completed until the
+ act referenced by this field is completed</para>
</listitem>
<listitem>
- <para>on_completion_id - references imsld_on_completions</para>
+ <para>time_limit_id - references time_limits. If
+ when_last_act_completed is null, the play is completed when the
+ time indicated here has been completed</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_complete_play</para>
-
- <itemizedlist>
<listitem>
- <para>complete_play_id</para>
+ <para>on_completion_id - references imsld_on_completions</para>
</listitem>
-
- <listitem>
- <para>when_last_act_completed - references imsld_acts. The play
- is completed when this act is completed</para>
- </listitem>
-
- <listitem>
- <para>time_limit_id - references imsld_time_limits. The play is
- completed when this time is completed</para>
- </listitem>
-
- <listitem>
- <para>when_property_value_is_set_id * - references
- imsld_when_property_value_is_set</para>
- </listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_method_plays_map</para>
+ <para>imsld_acts</para>
<itemizedlist>
<listitem>
- <para>method_id - references imsld_methods</para>
+ <para>act_id</para>
</listitem>
<listitem>
<para>play_id - references imsld_plays</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_play_acts_map</para>
-
- <itemizedlist>
<listitem>
- <para>play_id - references imsld_plays</para>
- </listitem>
-
- <listitem>
- <para>act_id - references imsld_acts</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
- <para>imsld_acts</para>
-
- <itemizedlist>
- <listitem>
- <para>act_id</para>
- </listitem>
-
- <listitem>
<para>title</para>
</listitem>
<listitem>
- <para>complete_act_id - references imsld_complete_acts</para>
+ <para>time_limit_id - if there are no role_parts mapped to this
+ act throug the mapping table (explained later), the act is
+ completed until the the time indicated here has been
+ completed</para>
</listitem>
<listitem>
<para>on_completion_id - references on_completion</para>
</listitem>
<listitem>
- <para>when_condition_true ** - references
- imsld_when_condition_true</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
- <para>imsld_complete_acts</para>
-
- <itemizedlist>
- <listitem>
- <para>complete_act_id</para>
- </listitem>
-
- <listitem>
- <para>time_limit_id - references imsld_complete_acts. When not
- null, the act is completed when this time has been completed,
- otherwise, the act is completed until all role parts mapped to
- this complete_act_id trhoug the imsld_act_role_parts are
- completed</para>
- </listitem>
-
- <listitem>
- <para>when_property_value_is_set_id ** - references
+ <para>when_property_value_is_set ** - references
imsld_when_property_value_is_set</para>
</listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_act_role_parts</para>
+ <para>imsld_role_parts</para>
<itemizedlist>
<listitem>
- <para>complete_act_id - references imsld_acts</para>
- </listitem>
-
- <listitem>
<para>role_part_id - references imsld_part_id</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_act_role_parts_map</para>
-
- <itemizedlist>
<listitem>
- <para>role_part_id - references imsld_role_parts</para>
- </listitem>
-
- <listitem>
<para>act_id - references imsld_acts</para>
</listitem>
- </itemizedlist>
- </listitem>
- <listitem>
- <para>imsld_role_part_choices</para>
-
- <itemizedlist>
<listitem>
- <para>choice_id</para>
+ <para>role_id</para>
</listitem>
<listitem>
- <para>learning_activity_id - references
- imsld_learning_activities</para>
- </listitem>
-
- <listitem>
- <para>support_activity_id - references
- imsld_support_activities</para>
- </listitem>
-
- <listitem>
<para>unit_of_learning_id - references imsld_imslds</para>
</listitem>
<listitem>
- <para>activity_structure_id - references
- imsld_activity_structures</para>
- </listitem>
-
- <listitem>
<para>environment_id - references imsld_environments</para>
</listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_role_parts - mapping table between acts and roles</para>
-
- <itemizedlist>
- <listitem>
- <para>role_part_id</para>
- </listitem>
-
- <listitem>
- <para>title</para>
- </listitem>
-
- <listitem>
- <para>role_id - references imsld_roles</para>
- </listitem>
-
- <listitem>
- <para>choice_id - references imsld_role_part_choices</para>
- </listitem>
- </itemizedlist>
- </listitem>
-
- <listitem>
<para>imsld_on_completion</para>
<itemizedlist>
@@ -1145,83 +664,131 @@
</listitem>
<listitem>
- <para>imsld_itemmodel_items_map</para>
+ <para>imsld_items. Items are used for multiple purposes in other
+ tables. For example it can describe objectives, prerequisites,
+ references to files, etc.</para>
<itemizedlist>
<listitem>
- <para>item_id - references imsld_items</para>
+ <para>item_id</para>
</listitem>
<listitem>
- <para>itemmodel_id - references imsld_itemmodels</para>
+ <para>identifier. Unique identifier for the IMS-LD</para>
</listitem>
+
+ <listitem>
+ <para>is_visible_p</para>
+ </listitem>
+
+ <listitem>
+ <para>title: A text that can represent a prerequisite, an
+ objective, the name of a file, etc.</para>
+ </listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_items. Items are used for multiple purposes in other
- tables. For example it can describe objectives, prerequisites,
- references to files, etc.</para>
+ <para>imsld_time_limits</para>
<itemizedlist>
<listitem>
- <para>item_id</para>
+ <para>time_limit_id</para>
</listitem>
<listitem>
- <para>identifier. Unique identifier for the IMS-LD</para>
+ <para>time_limit - amount of time in a specific format</para>
</listitem>
<listitem>
- <para>identifierref. It references the IMS CP</para>
+ <para>property_id ** - references imsld_properties</para>
</listitem>
+ </itemizedlist>
+ </listitem>
- <listitem>
- <para>isvisible_p.</para>
- </listitem>
+ <listitem>
+ <para>imsld_parameters</para>
+ <itemizedlist>
<listitem>
<para>parameter_id</para>
</listitem>
<listitem>
- <para>title: A text that can represent a prerequisite, an
- objective, the name of a file, etc.</para>
+ <para>parameter_value</para>
</listitem>
-
- <listitem>
- <para>parent_item - references imsld_items. An item can
- reference to another item, which is a sub-item or child of the
- one referencing it.</para>
- </listitem>
</itemizedlist>
</listitem>
<listitem>
- <para>imsld_time_limits</para>
+ <para>imsld_imsld_objects_map. This is a very importan table in this
+ data model, because it is used to map almost every imsld_* to every
+ imsld_*. For instance, the activities that are part of a component
+ are mapped by this table, and the acts to complete play are also
+ mapped using this table. This is just a representation of the
+ acs_rels table, because at the implementation phase, acs_rels will
+ be used with different rel_types</para>
<itemizedlist>
<listitem>
- <para>time_limit_id</para>
+ <para>imsld_object_one_id - references imsld_*
+ (acs_objects)</para>
</listitem>
<listitem>
- <para>time_limit - amount of time in a specific format</para>
+ <para>imsld_object_one_type - wich can be: learning_object,
+ imsld_item, imsld_role, support_activity, etc</para>
</listitem>
<listitem>
- <para>property_id ** - references imsld_properties</para>
+ <para>imsld_object_two_id - references imsld_*
+ (acs_objects)</para>
</listitem>
+
+ <listitem>
+ <para>imsld_object_two_type - same as
+ imsld_object_one_type</para>
+ </listitem>
</itemizedlist>
</listitem>
- </itemizedlist>Next, the tables necessary for Level A are draw in the
- form of an E-R diagram</para>
+ </itemizedlist></para>
- <para><ulink url="resources/imsld_diagram_A.GIF"><inlinemediaobject>
- <imageobject>
- <imagedata fileref="resources/imsld_diagram_A.GIF" />
- </imageobject>
- </inlinemediaobject></ulink></para>
+ <para>IMPORTANT NOTES:</para>
+
+ <orderedlist>
+ <listitem>
+ <para>The last table will use acs_rels. The rel_types will be
+ completely defined in the implementation phase. By now we can think
+ of: parent_item_rel, role_parts_activites_rel, component_service_rels,
+ service_roles_rel, learning_object_item_rel,
+ plays_to_complete_method_rel and role_parts_to_complete_act.</para>
+ </listitem>
+
+ <listitem>
+ <para>There are some important IMS-LD tags (learning objectives, for
+ instance) that does not have a table for themselves, but this is
+ because such tags consist only of a reference to a itemmodel or
+ another table, so there is no need to create a table just for
+ that.</para>
+ </listitem>
+
+ <listitem>
+ <para>This data model can (and it is 99% sure) change in the
+ implementation phase, but we will base the development on this data
+ model.</para>
+ </listitem>
+
+ <listitem>
+ <para>There are some tables in this data model that will be related to
+ some others of other .LRN packages. For instance, the table
+ imsld_conferences will be used to store the synchronous type (forums)
+ and asynchronous type (chats) of conferences. Also, we will use
+ acs_objects for the imslds, activities, services, learning_objects,
+ components, and for every case we find it useful. We can make use of
+ the cr_items too. But that is something that we will know better in
+ the implementation phase.</para>
+ </listitem>
+ </orderedlist>
</section>
<section>
Index: openacs-4/packages/imsld/www/doc/xmlfiles/imsld-spec.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/doc/xmlfiles/imsld-spec.xml,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/imsld/www/doc/xmlfiles/imsld-spec.xml 30 Jun 2005 10:31:51 -0000 1.1
+++ openacs-4/packages/imsld/www/doc/xmlfiles/imsld-spec.xml 5 Jul 2005 16:13:45 -0000 1.2
@@ -3,7 +3,7 @@
"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd">
<book lang="en">
<bookinfo>
- <title>IMS-LD: Integration with .LRN Specification (v 1.1)</title>
+ <title>IMS-LD: Integration with .LRN Specification (v 1.1.2)</title>
</bookinfo>
<!-- IMS-LD intro -->
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="imsld-short-intro.xml">