Tuesday, April 7, 2015

PeopleSoft Database : How it works.

Peoplesoft Database
Image Credits : Oracle.com
The image in left can describes three distinct and integrated database layers for PeopleSoft system.

System Tables:
System tables also called as system catalog tables, are related to a table of contents for a book or to file allocation tables on a hard drive. The structure and table names depends upon which RDBMS ( i.e Oracle,Microsoft,DB2 etc) you use. 
System catalog tables:
  • Keep track of all of the objects that reside in the database instance.
  • Are created by and owned by the RDBMS.
  • Are often described as system metadata.

PeopleTools metadata:
PeopleTools tables provide the infrastructure for PeopleSoft applications by storing and managing PeopleSoft application metadata. This metadata consists of information that defines the application, such as records, fields, pages, PeopleCode, and security. 
PeopleTools tables:
  • Define the structure of all object definitions that make up an application.
  • Use the same table structure for all applications.
  • Contain data that is added and updated only when the application is installed, or when using development tools such as PeopleSoft Application Designer or Data Mover.

PeopleSoft application data tables:
Application data tables store data entered through a PeopleSoft application. The specific tables and their structures vary by application. 
Application data tables:
  • Contain transactional data entered by users.
  • Are empty prior to data entry (except the demo databases).
In my next post i'll share the list of  PeopleTools Tables (Where the MetaData is Stored)

1 comments:

A few 3D printers with a number of} extruders Direct CNC can print objects in two or more colors. Most are dual-extruder fashions, with each extruder being fed a special color of filament. Each materials has a special melting point, so use of some exotic filaments is proscribed to printers designed for them or ones with software permits you to|that permits you to} control the extruder temperature. Make sure that a 3D printer's construct area is massive sufficient for the type of objects that you simply intend to print with it. The construct area is the dimensions, in three dimensions, of the most important object that can a given printer can produce (at least in theory—it additionally be} somewhat less if the construct platform isn't exactly degree, for example).

Post a Comment