Contents

List of Examples

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• 1.1 Introduction to Using Databases with WebLogic Portal
• 1.2 How This Guide Fits into the Portal Life Cycle

2 Database Configuration Overview

• 2.1 Overview of Enterprise-Quality Database Configuration for WebLogic Portal
• 2.2 Manually Creating Database Objects and JDBC Settings
  • 2.2.1 Creating Additional Content Management Databases

3 Database Setup and Maintenance Overview

• 3.1 Encrypting Passwords
• 3.2 Choosing Internationalization and Localization Settings
  • 3.2.1 Changing the Language Settings in SQL Server
  • 3.2.2 Supporting Unicode Languages in SQL Server
  • 3.2.3 Choosing Character Sets and Sort Orders
    • 3.2.3.1 Oracle
    • 3.2.3.2 SQL Server
    • 3.2.3.3 MySQL
    • 3.2.3.4 Sybase
    • 3.2.3.5 DB2
• 3.3 Performance Considerations
  • 3.3.1 Collocating the Database and WebLogic Portal
  • 3.3.2 Using Caching to Reduce Database Access
  • 3.3.3 Caching Database Tables Using Database-Specific Settings
  • 3.3.4 Improving Concurrency Using Sybase Locking
  • 3.3.5 Improving Content Search Response Time for Oracle
  • 3.3.6 Using Database Statistics for Table and Index Organization
  • 3.3.7 Optimizing Table Data and Index Placement
    • 3.3.7.1 Choosing Index Placement
    • 3.3.7.2 Choosing Data Storage for Tables with CLOB/BLOB/TEXT/IMAGE Data
    • 3.3.7.3 Choosing Behavior Tracking Data Placement
• 3.4 Sizing Considerations
  • 3.4.1 Database Sizing
    • 3.4.1.1 Monitoring Behavior Tracking Tables
    • 3.4.1.2 Monitoring Personalization Tables
    • 3.4.1.3 Monitoring Portal Framework and WSRP Tables
    • 3.4.1.4 Monitoring Content Management Database Tables
    • 3.4.1.5 Monitoring Community Database Tables
  • 3.4.2 Setting Page and Block Sizes
  • 3.4.3 Setting BLOB/CLOB Data Type Size Limits
• 3.5 Performing Database Backup and Recovery
• 3.6 Propagating Portal Environments
• 3.7 Support for Asynchronous Proliferation Requires XA
• 3.8 Note About Creating or Refreshing Database Objects

4 Using Microsoft SQL Server

• 4.1 Configuring Microsoft SQL Server Databases
• 4.2 Configuring the Main WebLogic Portal Database
• 4.3 Manually Creating a Separate Database and Database Objects for Behavior Tracking
• 4.4 Database Scripts and Usage Notes

5 Using Derby

• 5.1 About Derby
• 5.2 Derby Documentation

6 Using MySQL

• 6.1 Configuring MySQL Databases
• 6.2 Configuring the Main WebLogic Portal Database
• 6.3 Manually Creating a Separate Database and Database Objects for Behavior Tracking
• 6.4 Database Scripts and Usage Notes

7 Using Oracle

• 7.1 Configuring Oracle Databases
• 7.2 Configuring the Main WebLogic Portal Database
• 7.3 Manually Creating a Separate Database and Database Objects for Behavior Tracking
• 7.4 Database Scripts and Usage Notes
• 7.5 Using WebLogic Portal with Oracle RAC
  • 7.5.1 Supported Configuration
  • 7.5.2 Configuration Considerations for Oracle RAC
    • 7.5.2.1 Multi-Data Source vs. Oracle Thin Driver
    • 7.5.2.2 Fail-over vs. Load-Balancing
    • 7.5.2.3 XA Considerations
    • 7.5.2.4 Supported Configurations
  • 7.5.3 Procedure for Using Oracle RAC with WebLogic Portal
  • 7.5.4 Sample Configuration Files

8 Using Sybase

• 8.1 Configuring Sybase Databases
• 8.2 Configuring the Main WebLogic Portal Database
• 8.3 Manually Creating a Separate Database and Database Objects for Behavior Tracking
• 8.4 Database Scripts and Usage Notes

9 Using DB2

• 9.1 Configuring DB2 Databases
• 9.2 Configuring the Main WebLogic Portal Database
• 9.3 Manually Creating a Separate Database and Database Objects for Behavior Tracking
• 9.4 Database Scripts and Usage Notes

10 Data Dictionary

• 10.1 Personalization Database Objects
  • 10.1.1 Base Personalization Database Tables
    • 10.1.1.1 USER_PROFILE Database Table
    • 10.1.1.2 ENTITY Database Table
    • 10.1.1.3 PROPERTY_KEY Database Table
    • 10.1.1.4 PROPERTY_VALUE Database Table
    • 10.1.1.5 SEQUENCER Database Table
    • 10.1.1.6 USERS Database Table
    • 10.1.1.7 GROUPS Database Table
    • 10.1.1.8 GROUPMEMBERS Database Table
    • 10.1.1.9 P13N_QUIESCENT_STATE Database Table
    • 10.1.1.10 P13N_LEASE Database Table
    • 10.1.1.11 Credential Service Dictionary Tables
    • 10.1.1.12 P13N_CREDENTIAL Database Table
    • 10.1.1.13 P13N_CREDENTIAL_APPLICATION Database Table
    • 10.1.1.14 P13N_CREDENTIAL_MASTER Database Table
    • 10.1.1.15 P13N_CREDENTIAL_METADATA Database Table
    • 10.1.1.16 Job Scheduler Dictionary Tables
    • 10.1.1.17 P13N_JOB_DEFINITION Database Table
    • 10.1.1.18 P13N_JOB_LISTENER Database Table
    • 10.1.1.19 P13N_JOB_PARAMETER Database Table
    • 10.1.1.20 P13N_JOB_RUN_HEADER Database Table
    • 10.1.1.21 P13N_JOB_RUN_DATA Database Table
    • 10.1.1.22 Entitlement Reference Dictionary Tables
    • 10.1.1.23 P13N_ENTITLEMENT_APPLICATION Database Table
    • 10.1.1.24 P13N_ENTITLEMENT_POLICY Database Table
    • 10.1.1.25 P13N_ENTITLEMENT_RESOURCE Database Table
    • 10.1.1.26 P13N_ENTITLEMENT_ROLE Database Table
    • 10.1.1.27 P13N_DELEGATED_HIERARCHY Database Table
  • 10.1.2 Tracked Anonymous User Dictionary Tables
    • 10.1.2.1 P13N_ANONYMOUS_PROPERTY Database Table
    • 10.1.2.2 P13N_ANONYMOUS_USER Database Table
  • 10.1.3 Behavior Tracking Database Tables
    • 10.1.3.1 BT_EVENT_TYPE Database Table
    • 10.1.3.2 BT_EVENT Database Table
    • 10.1.3.3 BT_EVENT_ACTION Database Table
  • 10.1.4 Data Synchronization Database Tables
    • 10.1.4.1 DATA_SYNC_APPLICATION Database Table
    • 10.1.4.2 DATA_SYNC_ITEM Database Table
    • 10.1.4.3 DATA_SYNC_SCHEMA_URI Database Table
    • 10.1.4.4 DATA_SYNC_VERSION Database Table
• 10.2 Portal Services Database Objects
  • 10.2.1 AD_BUCKET Database Table
  • 10.2.2 AD_COUNT Database Table
  • 10.2.3 PLACEHOLDER_PREVIEW Database Table
  • 10.2.4 MAIL_ADDRESS Database Table
  • 10.2.5 MAIL_BATCH Database Table
  • 10.2.6 MAIL_BATCH_ENTRY Database Table
  • 10.2.7 MAIL_HEADER Database Table
  • 10.2.8 MAIL_MESSAGE Database Table
  • 10.2.9 SCENARIO_END_STATE Database Table
• 10.3 Portal Framework Database Objects
  • 10.3.1 Portal Framework Database Tables
    • 10.3.1.1 PF_BOOK_DEFINITION Database Table
    • 10.3.1.2 PF_BOOK_GROUP Database Table
    • 10.3.1.3 PF_BOOK_INSTANCE Database Table
    • 10.3.1.4 PF_DESKTOP_DEFINITION Database Table
    • 10.3.1.5 PF_DESKTOP_INSTANCE Database Table
    • 10.3.1.6 PF_LAYOUT_DEFINITION Database Table
    • 10.3.1.7 PF_LOOK_AND_FEEL_DEFINITION Database Table
    • 10.3.1.8 PF_MARKUP_DEFINITION Database Table
    • 10.3.1.9 PF_MARKUP_XML Database Table
    • 10.3.1.10 PF_MENU_DEFINITION Database Table
    • 10.3.1.11 PF_PAGE_DEFINITION Database Table
    • 10.3.1.12 PF_PAGE_INSTANCE Database Table
    • 10.3.1.13 PF_PLACEHOLDER_DEFINITION Database Table
    • 10.3.1.14 PF_PLACEMENT Database Table
    • 10.3.1.15 PF_PORTAL Database Table
    • 10.3.1.16 PF_PORTLET_CATEGORY Database Table
    • 10.3.1.17 PF_PORTLET_CATEGORY_DEFINITION Database Table
    • 10.3.1.18 PF_PORTLET_DEFINITION Database Table
    • 10.3.1.19 PF_PORTLET_INSTANCE Database Table
    • 10.3.1.20 PF_PORTLET_PREFERENCE Database Table
    • 10.3.1.21 PF_PORTLET_PREFERENCE_VALUE Database Table
    • 10.3.1.22 PF_PORTLET_USER_PROPERTIES Database Table
    • 10.3.1.23 PF_SHELL_DEFINITION Database Table
    • 10.3.1.24 PF_SHELL_PLACEMENT Database Table
    • 10.3.1.25 PF_THEME_DEFINITION Database Table
    • 10.3.1.26 PF_URL_COMPRESSION Database Table
  • 10.3.2 Localization Dictionary Tables
    • 10.3.2.1 L10N_INTERSECTION Database Table
    • 10.3.2.2 L10N_LOCALE Database Table
    • 10.3.2.3 L10N_RESOURCE Database Table
    • 10.3.2.4 L10N_RESOURCE_TYPE Database Table
• 10.4 WSRP Portal Framework Database Objects
  • 10.4.1 PF_CONSUMER_PORTLETS Database Table
  • 10.4.2 PF_CONSUMER_PROPERTIES Database Table
  • 10.4.3 PF_CONSUMER_REGISTRY Database Table
  • 10.4.4 PF_PRODUCER_REGISTRY Database Table
  • 10.4.5 PF_PROXY_PORTLET_INSTANCE Database Table
  • 10.4.6 PF_PROXY_BOOK Database Table
  • 10.4.7 PF_PROXY_PAGE Database Table
• 10.5 Communities Framework Database Objects
  • 10.5.1 Communities Portal Framework Data Dictionary Tables
    • 10.5.1.1 PF_COMMUNITY_DEFINITION Database Table
    • 10.5.1.2 PF_COMMUNITY_MEMBER Database Table
    • 10.5.1.3 PF_COMMUNITY_MEMBERSHIP Database Table
    • 10.5.1.4 PF_MEMBERSHIP_CAPABILITY Database Table
    • 10.5.1.5 PF_COMMUNITY_PROPERTY Database Table
    • 10.5.1.6 PF_COMMUNITY_PROPERTY_VALUE Database Table
    • 10.5.1.7 PF_FILE_TEMPLATE Database Table
    • 10.5.1.8 PF_INVITATION Database Table
    • 10.5.1.9 PF_INVITEE Database Table
    • 10.5.1.10 PF_INVITEE_PROPERTY Database Table
    • 10.5.1.11 PF_MESSAGING_ADDR Database Table
    • 10.5.1.12 PF_NOTIFICATION Database Table
    • 10.5.1.13 PF_NOTIFICATION_PAYLOAD Database Table
• 10.6 Content Management Database Objects
  • 10.6.1 Content Management Data Dictionary Tables
    • 10.6.1.1 CM_NODE Database Table
    • 10.6.1.2 CM_COLLABORATION_API_METADATA Database Table
    • 10.6.1.3 CM_OBJECT_CLASS Database Table
    • 10.6.1.4 CM_PROPERTY Database Table
    • 10.6.1.5 CM_PROPERTY_CHOICE Database Table
    • 10.6.1.6 CM_PROPERTY_DEFINITION Database Table
    • 10.6.1.7 CM_PROPERTY_TEXT Database Table
    • 10.6.1.8 CM_WORKFLOW Database Table
• 10.7 Content Management Virtual Content Repository Database Objects
  • 10.7.1 Content Management Virtual Object Data Dictionary Tables
    • 10.7.1.1 CMV_NODE Table
    • 10.7.1.2 CMV_NODE_ASSIGNED_ROLE Table
    • 10.7.1.3 CMV_NODE_VERSION Table
    • 10.7.1.4 CMV_PROPERTY Table
    • 10.7.1.5 CMV_VALUE Table
    • 10.7.1.6 CMV_VALUE_TEXT Table
    • 10.7.1.7 CMV_NODE_VERSION_PROPERTY Table
• 10.8 RDBMS Security Store Tables

A Scripts and Properties Files

• A.1 WebLogic Portal DDL Modules
• A.2 Content Management DDL Modules
• A.3 Personalization DDL Modules
• A.4 Using the database.properties File
  • A.4.1 Setting the Database Parameters in the Properties File
• A.5 Scripts to Create an Additional Content Management Repository
• A.6 Scripts to Manually Upgrade from Previous Versions
• A.7 Scripts to Drop Deprecated Compoze Database Tables
• A.8 Scripts to Drop Deprecated RDBMS Authenticator Tables

B Database Schema Diagrams