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
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:
oLog in using your Audit database account
oExecute the supplied Audit SQL script for your database platform
oLog in using your Learning Management System database account
oExecute the supplied Learning Management System SQL script for your database platform
oLog in using your Delivery account
oExecute 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
