Personalization related tables in Oracle ATG

Personalization related tables in Oracle ATG

Personalization related tables in Oracle ATG

USER DATA TABLES

These are tables related to Personalization module. These tables are used to store user data.

  • dps_user
  • dps_contact_info
  • dps_user_address
  • dps_other_addr
  • dps_credit_card
  • dps_usr_creditcard

USER DIRECTORY TABLES

In Oracle ATG Commerce these tables are used to store information about the organizations and roles. These tables make up a user directory.

  • dps_child_folder
  • dps_folder
  • dps_organization
  • dps_org_ancestors
  • dps_org_chldorg
  • dps_org_role
  • dps_relativerole
  • dps_role
  • dps_rolefold_chld
  • dps_role_rel_org
  • dps_user_org
  • dps_user_org_anc
  • dps_user_roles

LOGGING AND REPORTING TABLES

These tables are related Personalization module. They are used to store logging and reporting information. One thing to note baout these tables is that they are for use of external user profiles only.

  • dps_con_req
  • dps_con_req_sum
  • dps_group
  • dps_log_id
  • dps_pgrp_con_sum
  • dps_pgrp_req_sum
  • dps_request
  • dps_reqname_sum
  • dps_session_sum
  • dps_user_event
  • dps_user_event_sum
  • dps_event_type

TARGETED E-MAIL TABLES

These tables are used to store information about targeted e-mail. These tables corresponds to external users. Another set of tables exist with prefix dpi for external users.

  • dps_mailing
  • dps_mail_server
  • dps_mail_batch
  • dps_user_mailing
  • dps_email_address

Personalization Module Scenario Tables

These tables are related to Personalization module to store user-related information about scenarios. The tables with prefix dps corresponds to external users. Another set of tables for internal users exist with the prefix dpi.

  • dps_scenario_value
  • dps_user_scenario
  • dps_user_slot

You may also like this

seperator

About TechnoStixs.com

Personalization related tables in Oracle ATG

ORACLE ATG ENDECA & JAVA TECHNOLOGY XCHANGE SYSTEM. TechnoStixs.com is a dedicated weblog for Oracle ATG, Oracle Endeca, Java/J2EE and web developers. We take pride in our work. Every publication is carefully analyzed, written and tested to ease the understanding of the topic or subject.

We cover Oracle ATG, Oracle Endeca, Java Core Technologies, eCommerce, J2EE Frameworks, Web Service, Build Tools, Unit Test Frameworks and Others.

1,246 total views, 1 views today

Add comment