Skip Headers
Oracle® Real-Time Decisions Base Application Installation and Reference Guide
Release 3.1

Part Number E19020-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

10 Decision Management Setup Files

The following diagram shows the main Decision Management metadata and database setup files, as released with Oracle RTD Base Application.

Figure 10-1 Main Oracle RTD Decision Management Metadata and Database Files

Surrounding text describes Figure 10-1 .

Terminology:

The following terms are used throughout this chapter:

This chapter contains the following topics:

10.1 Core Metadata Files

The Core metadata files in this section all appear under the directory clm/Build/metadata.

This section contains the following topics:

core/config/config.xml

The Core config.xml file contains general configuration settings:

core/config/perspectives.xml

The Core perspectives.xml file acts as the base file for adding your application perspectives. The Core perspective file contains no specific perspectives.

core/config/security.xml

The Core security.xml file contains the configuration entries for the three application roles CLMConsumer, CLMAuthor, CLMAdministrator, and the choice group, project, and perspective permissions selected for those application roles. It contains no entries for any enterprise roles nor users.

10.2 Base Marketing (Ref) Metadata Files

The Base Marketing (ref) metadata files in this section all appear under the directory clm/Build/metadata.

This section contains the following topics:

ref/config/config.xml

The Base Marketing (ref) config.xml file contains general configuration settings:

ref/config/perspectives.xml

The Base Marketing (ref) perspectives.xml file contains the properties for the perspectives released with the RTD for Marketing Optimization application: Campaigns, Channels, Creatives by Slot Type, Slots by Slot Type, Draft Campaigns, Pending Approval Campaigns, and Approved Campaigns.

The Base Marketing Choice Group xml files

For each of the choice groups defined in the RTD for Marketing Optimization application - Campaign, Offer, Creative, Channel, Placement, Slot, Slot Type - there is a corresponding choice group xml file in the ref directory.

Each choice group xml file contains the properties to define the choice group and its attributes. Other properties control whether the choice group appears in Decision Manager dropdown lists, and whether its attributes appear by default in Decision Manager Advanced Search screens. Type restriction associations are defined for several attributes in the Campaign, Offer, and Creative choice groups.

ref/relationship-types.xml

The Base Marketing (ref) relationship-types.xml file describes the relationship types between the choice groups in the RTD for Marketing Optimization application.

For each relationship, the "from" and "to" choice groups are defined as well as the cardinality of the relationship.

In addition, there are properties to control the Delete logic (whether the delete applies just to one of the choice groups, or "cascades" to delete choices of the related choice group), rule propagation, and event propagation.

ref/security.xml

The Base Marketing (ref) security.xml file contains the configuration entries for the three application roles CLMConsumer, CLMAuthor, CLMAdministrator, and the choice group, project, and perspective permissions selected for those application roles. It contains no entries for any enterprise roles nor users.

ref/sql/insert ils data.sql and ref/sql/insert marketing data.sql

The insert ils data.sql and insert marketing data.sql files contain instructions to load some sample data for the Oracle RTD Decision Management database. These scripts are for demonstrations only.

10.3 Database Files for Core and Base Marketing

The database files for Core and Base Marketing in this section all appear under the directory clm/Database.

This section contains the following topics:

sql/drop core.sql

The sql/drop core.sql file contains instructions to drop all the generic metadata for a Oracle RTD Decision Management database - the tables, views, and sequences that provide the infrastructure for Oracle RTD Decision Management application data.

sql/load core.sql

The sql/load core.sql file contains instructions to create and initialize all the generic tables, views, and sequences required for a Oracle RTD Decision Management database. These tables, views, and sequences provide the infrastructure for Oracle RTD Decision Management application data.

sql/ils/drop ils.sql

The sql/ils/drop core.sql file, as released with Oracle RTD Base Application, contains instructions to drop all the tables and views specific to the individual choice groups defined in the released application RTD for Marketing Optimization.

Note:

After choice groups or choice group attributes are added to, removed from, or have their definition properties altered in any Oracle RTD Decision Management application, and the application is then regenerated, the sql/ils/drop core.sql file is overwritten, and then reflects the new proposed data structure. The file is not automatically run after application regeneration.

sql/ils/load ils.sql

The sql/ils/load core.sql file, as released with Oracle RTD Base Application, contains instructions to create and initialize all the tables and views that implement the choice groups and the inter-choice group relationships defined in the released application RTD for Marketing Optimization.

Note:

After choice groups or choice group attributes are added to, removed from, or have their definition properties altered in any Oracle RTD Decision Management application, and the application is then regenerated, the sql/ils/load core.sql file is overwritten, and then reflects the new proposed data structure. The file is not automatically run after application regeneration.