IBM G210-1784-00 Manuale Utente

 

The Learning Management System requires a number of different logical database schemas to function. These are 
the following:  

•  LMM database – this database resides on the Learning Management System Server and stores all 

information about courses, users, progress, resources, deployment, status, etc. It is used for learning 
management and reporting. 

•  Audit database – this database stores information about all actions taken on the Learning Management 

System Server. 

•  DS (Delivery Server) database – this database contains a subset of the information on the Learning 

Management System Server. It has the information that is required to deliver and track content to learners. It 
only contains information about courses that are deployed to an individual delivery server. You can have 
multiple delivery servers for a single Learning Management System Server. Each Delivery Server will be 
associated with a unique Delivery Server database - the database is not shared among several distinct 
Delivery Servers). 

There is an LMM and Audit schema to support the Learning Management System on the Learning Management 
System Server and one schema for each DS database. 

To begin, make sure that the desired database server software is installed on all the desired systems. After you have 
done that, use your vendor-supplied database utilities to run the SQL scripts supplied with the Learning 
Management System product. These SQL scripts create and initialize the needed databases. 

The scripts are named for their logical database and database platform. For example, the script to create the Audit 
database on IBM’s DB2 is audit_db2.sql while lmm_oracle.sql creates the Learning Management System 
database on an Oracle system. 

To create and initialize the three databases as well as keep them logically separated, perform the following steps: 

1.  If you are running Oracle, obtain three separate accounts for your DB system: one each for Audit, Learning, 

and Delivery databases. If you are running SQL Server or DB2, you will create three separate databases 
rather than a single partitioned database. 

2.  Do the following general tasks using your database vendor’s tools: 

o

 

Log in using your Audit database account 

o

 

Execute the supplied Audit SQL script for your database platform 

o

 

Log in using your Learning Management System database account 

o

 

Execute the supplied Learning Management System SQL script for your database platform 

o

 

Log in using your Delivery account 

o

 

Execute the supplied Delivery Server SQL script for your database platform 

The procedure for each database platform is basically the same. The major difference is the set of SQL scripts that 
are run. As mentioned, there is a specific set of scripts for each database platform.