Oracle® Real-Time Decisions Base Application Installation and Reference Guide Release 3.1 Part Number E19020-01 |
|
|
View PDF |
The following diagram shows the main Decision Management metadata and database setup files, as released with Oracle RTD Base Application.
Terminology:
The following terms are used throughout this chapter:Core - refers to the basic elements required for all Oracle RTD Decision Management applications
Base Marketing (or Ref) - refers to the elements for the RTD for Marketing Optimization application
This chapter contains the following topics:
The Core metadata files in this section all appear under the directory clm/Build/metadata.
This section contains the following topics:
The Core config.xml file contains general configuration settings:
workbenchService: the url of the Oracle RTD server running in the same host WebLogic server as Oracle RTD Decision Management.
inlineService: the name of the Core Inline Service (RTD_CLM_Core) that is released with Oracle RTD Base Application.
decisionCenter: the base URL to access embedded decision center reports.
ownership-mode: special mode, which when switched on, allow users (typically administrators) to take ownership control of choices when choices are edited. Initial value after installation is "off".
display-name: the name of the application as it appears on the Decision Manager login page and at the top of the main page.
The Core perspectives.xml file acts as the base file for adding your application perspectives. The Core perspective file contains no specific perspectives.
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.
The Base Marketing (ref) metadata files in this section all appear under the directory clm/Build/metadata.
This section contains the following topics:
The Base Marketing (ref) config.xml file contains general configuration settings:
workbenchService: the url of the Oracle RTD server running in the same host WebLogic server as Oracle RTD Decision Management.
inlineService: the name of the Inline Service (RTD_Base_Marketing) that is released as part of the RTD for Marketing Optimization application.
decisionCenter: the base URL to access embedded decision center reports.
ownership-mode: special mode, which when switched on, allow users (typically administrators) to take ownership control of choices when choices are edited. Initial value after installation is "off".
display-name: the name of the application as it appears on the Decision Manager login page and at the top of the main page.
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.
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.
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.
The database files for Core and Base Marketing in this section all appear under the directory clm/Database.
This section contains the following topics:
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.
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.
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.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.