Database Administration Guide

Introduction to Database Administration for WebLogic Portal

Overview of Database Configuration for WebLogic Portal

Manually Creating Database Objects and JDBC Settings

Using PointBase

PointBase Documentation

PointBase JAR Files

PointBase Tools

WebLogic Portal PointBase Databases

Administering the WebLogic Portal PointBase Database

To Launch PointBase Console from the Windows Start menu

To Launch 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 Database for Behavior Tracking Events

Using an Oracle Database

Configuring an Oracle Database

Manually Creating Database Objects

Manually Configure Your Domain's JDBC Driver Settings

Creating a Database for Behavior Tracking Events

Using a Sybase Database

Configuring a Sybase Database

Manually Creating Database Objects

Manually Configuring Your Domain's JDBC Driver Settings

Creating a Database for Behavior Tracking Events

Using a DB2 Database

Configuring a DB2 Database

DB2 Configuration Parameters Minimum Settings for DB2

Manually Creating Database Objects

Manually Configuring Your Domain's JDBC Driver Settings

Creating a Database for Behavior Tracking Events

The 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

Tracked Anonymous User Database Objects

The Tracked Anonymous User Dictionary Tables

The P13N_ANONYMOUS_PROPERTY Database Table

The P13N_ANONYMOUS_USER Database Table

WebLogic Portal DDL Modules