Contents for Database Administration Guide
Database Configuration Roadmap
Overview of Database Configuration for WebLogic Portal
Manually Creating Database Objects and JDBC Settings
Database Setup and Maintenance Overview
Character Sets and Sort Orders
Oracle
SQL Server
Sybase
DB2
Disk and Data Placement
Placement of Indexes
Data Storage for Tables with CLOB/BLOB/TEXT/IMAGE Data
Behavior Tracking
Reporting on Behavior Tracking data
Database Table Caching
Page and Block Size
Sybase Locking
Database Sizing
Behavior Tracking
Personalization
Portal Framework and WSRP
Content Management & Virtual Content Management (Versioning)
Content Search (Oracle)
Updating Database Statistics
Database Reorganizations
Database Backup and Recovery
Commerce Functionality in an XA Domain
WebLogic Portal Propagation Utility
Colocation of Database and WebLogic Portal
Using PointBase
PointBase Documentation
PointBase JAR Files
PointBase Tools
WebLogic Portal PointBase Databases
Administering the WebLogic Portal PointBase Database
Launching the PointBase Console from the Windows Start Menu
Launching the PointBase Console from the startPointBaseConsole Script
Using a Microsoft SQL Server Database
Configuring a Microsoft SQL Server Database
Manually Creating Database Objects
Manually Configuring Your Domain's JDBC Driver Settings
Creating a Separate Database for Behavior Tracking Events
Using an Oracle Database
Configuring an Oracle Database
Manually Creating Database Objects
Manually Configuring Your Domain's JDBC Driver Settings
Creating a Separate Database for Behavior Tracking Events
WebLogic Platform Support for Oracle9i RAC
Using a Sybase Database
Configuring a Sybase Database
Using a Supported Version
Defining an 8K Page Size
Running Upgrade Script for 7.0 to 8.1
Install and Configure the Sybase Client
Manually Creating Database Objects
Manually Configuring Your Domain's JDBC Driver Settings
Creating a Separate Database for Behavior Tracking Events
Using a DB2 Database
Configuring a DB2 Database
DB2 Configuration Parameter Minimum Settings
Manually Creating Database Objects
Manually Configuring Your Domain's JDBC Driver Settings
Creating a Separate Database for Behavior Tracking Events
Data Dictionary
Information Provided
Portal Database Components Covered
Behavior Tracking Database Objects
The BT_EVENT_TYPE Database Table
The BT_EVENT Database Table
The BT_EVENT_ACTION Database Table
Commerce Services Database Objects
Product Catalog Database Tables
The CATALOG_ENTITY Database Table
The CATALOG_PROPERTY_KEY Database Table
The CATALOG_PROPERTY_VALUE Database Table
The WLCS_CATEGORY Database Table
The WLCS_PRODUCT Database Table
The WLCS_PRODUCT_CATEGORY Database Table
The WLCS_PRODUCT_KEYWORD Database Table
Order and Discount Database Objects
The Order Processing Data Dictionary Tables
The DISCOUNT Database Table
The DISCOUNT_ASSOCIATION Database Table
The ORDER_ADJUSTMENT Database Table
The ORDER_LINE_ADJUSTMENT Database Table
The WLCS_CREDIT_CARD Database Table
The WLCS_CUSTOMER Database Table
The WLCS_ORDER Database Table
The WLCS_ORDER_LINE Database Table
The WLCS_SAVED_ITEM_LIST Database Table
The WLCS_SECURITY Database Table
The WLCS_SHIPPING_ADDRESS Database Table
The WLCS_SHIPPING_METHOD Database Table
The WLCS_TRANSACTION Database Table
The WLCS_TRANSACTION_ENTRY Database Table
Personalization Database Objects
The Portal Personalization Database Tables
The GROUP_HIERARCHY Database Table
The GROUP_SECURITY Database Table
The USER_GROUP_CACHE Database Table
The USER_GROUP_HIERARCHY Database Table
The USER_PROFILE Database Table
The USER_SECURITY Database Table
The ENTITY Database Table
The PROPERTY_KEY Database Table
The PROPERTY_VALUE Database Table
The SEQUENCER Database Table
The WEBLOGIC_IS_ALIVE Database Table
Data Synchronization Database Objects
The DATA_SYNC_APPLICATION Database Table
The DATA_SYNC_ITEM Database Table
The DATA_SYNC_SCHEMA_URI Database Table
The DATA_SYNC_VERSION Database Table
WebLogic Portal Services Database Objects
The Portal Services Database Tables
The AD_BUCKET Database Table
The AD_COUNT Database Table
The PLACEHOLDER_PREVIEW Database Table
The MAIL_ADDRESS Database Table
The MAIL_BATCH Database Table
The MAIL_BATCH_ENTRY Database Table
The MAIL_HEADER Database Table
The MAIL_MESSAGE Database Table
The SCENARIO_END_STATE Database Table
Portal Framework Database Objects
The Portal Framework Database Tables
The PF_BOOK_DEFINITION Database Table
The PF_BOOK_GROUP Database Table
The PF_BOOK_INSTANCE Database Table
The PF_DESKTOP_DEFINITION Database Table
The PF_DESKTOP_INSTANCE Database Table
The PF_LAYOUT_DEFINITION Database Table
The PF_LOOK_AND_FEEL_DEFINITION Database Table
The PF_MARKUP_DEFINITION Database Table
The PF_MENU_DEFINITION Database Table
The PF_PAGE_DEFINITION Database Table
The PF_PAGE_INSTANCE Database Table
The PF_PLACEHOLDER_DEFINITION Database Table
The PF_PLACEMENT Database Table
The PF_PORTAL Database Table
The PF_PORTLET_CATEGORY Database Table
The PF_PORTLET_CATEGORY_DEFINITION Database Table
The PF_PORTLET_DEFINITION Database Table
The PF_PORTLET_INSTANCE Database Table
WSRP (Web Services for Remote Portlets) Objects
The PF_CONSUMER_PORTLETS Database Table
The PF_CONSUMER_PROPERTIES Database Table
The PF_CONSUMER_REGISTRY Database Table
The PF_PRODUCER_PROPERTIES Database Table
The PF_PRODUCER_REGISTRY Database Table
The PF_PROXY_PORTLET_INSTANCE Database Table
The PF_PORTLET_PREFERENCE Database Table
The PF_PORTLET_PREFERENCE_VALUE Database Table
The PF_SHELL_DEFINITION Database Table
The PF_THEME_DEFINITION Database Table
Content Management Database Objects
The Content Management Data Dictionary Tables
The CM_NODE Database Table
The CM_OBJECT_CLASS Database Table
The CM_PROPERTY Database Table
The CM_PROPERTY_CHOICE Database Table
The CM_PROPERTY_DEFINITION Database Table
Content Management Virtual Database Objects
The CMV_NODE Table
The CMV_NODE_ASSIGNED_ROLE Table
The CMV_NODE_VERSION Table
The CMV_PROPERTY Table
The CMV_VALUE Table
The CMV_NODE_VERSION_PROPERTY Table
Localization Database Objects
The Localization Dictionary Tables
The L10N_INTERSECTION Database Table
The L10N_LOCALE Database Table
The L10N_RESOURCE Database Table
The L10N_RESOURCE_TYPE Database Table
Tracked Anonymous User Database Objects
The Tracked Anonymous User Dictionary Tables
The P13N_ANONYMOUS_PROPERTY Database Table
The P13N_ANONYMOUS_USER Database Table
Entitlement Reference Database Objects
The Entitlement Reference Dictionary Tables
The P13N_ENTITLEMENT_APPLICATION Database Table
The P13N_ENTITLEMENT_POLICY Database Table
The P13N_ENTITLEMENT_RESOURCE Database Table
The P13N_ENTITLEMENT_ROLE Database Table
The P13N_DELEGATED_HIERARCHY Database Table
WebLogic Portal DDL Modules
WebLogic Portal DDL Modules
Property Files and Database Scripts
The db_settings.properties file
Definitions Section
Database Parameters
Scripts to Create or Upgrade Databases