Filter
Top Products
Chapter 9
Installing and Configuring Database Servers and Schema
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.
Database Creation Overview
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.
Chapter 9: Installing and Configuring Database Servers and Schema 37