The database is essential for every project. This is the place where the entire data stores. It is considered as the heart of the project.  This database plays a major at the time of retrieval of data.  The databases that we use today would be of varied sized and varies from company to company. We usually store the data in the databases in the form of tables.   The size of the table depends on the amount of data that we store in the database. Today we have different types of databases. Each database provides the access to create the certain type of tables. Today, in this article I would like to share with you the types of database tables in PEGA.

Get the best training on pega at PEGA Online Training Bangalore.

Types of  Database tables in PEGA :

Before going to explain the types of database in PEGA. Let me give you the definition of PEGA and then ill directly jump to types of databases in PEGA

PEGA is the powerful BPM tool in the  IT industry.  It performs software for the Client relationship management (CRM), Digital processing automation and Business Process Management(BPM). This trending tool supports different types of databases today. The types of tables that PEGA provides is different from the other databases. Depending upon the types of table, the data model of the databases would be varied. So let me explain to you each and every tool in detail.

Types of Database tables in PEGA is usually classified into 4 categories :

Assignment tables :

Three major items would fall under this category.

PC_assign_workbasket: This table holds the assessments and instances of                                the Assign –work-basket class.

PC _assign _ work-list: It is responsible for holding all the assignments  on                                  the work list

Pr_assign: This table holds the external assessment. This uses the directed web access feature and assignments of all other types. Assignments in Assign-Corr and Assign-  Service classes would store as rows in the Pr- assign table.

Types of database tables in PEGA

Data Object tables:

 Under this table, we have seven items.

  Pr-operators: This  operator table  stores the data that correspond to the                                     instances of Data-admin operator

 Pi_data_connect: This table is associated with data –admin connect class.                               Excluding which are mapped to the other tables.

 Pc_data_unique id: This table corresponds to the Data-unique Id class. Usually, it contains a  single row for each work_Id format in use. It records the most recently assigned work item  ID of that format.

Pc_ data_work_attach: It contains the attachments of work –items that contain the instances of the concrete classes. These concrete classes are usually derived from Data-work Attach class and linked to this table.

 Pr4_base: This table holds the instance of three foundation classes.  Those are Data-Admin DB- table, Data-Admin DB-Name, Data-Admin-DB-Class Group.

 Pr_data_file: Data content image class is associated with the table.

History  tables :

Pc_history_work:  The data of the History- Work –class will be stored by this table.

P4_history _rule:  It is responsible for storing the instances of the various rule related work like Restore, Recovers and detailed history.

Case Tables :

Pc-Work: This table saves the case instance of a concrete class which is derived from the work –based class.

Along with these main category tables .there are some other tables which need to keep it in mind. Let me explain to you all those.

Link _ table: This tables store the information regarding the paired object instances. According to the rules of pega,  the names of link tables start with the value pc-link (or) pr_link.

Log table: This table stores the instances of Log classes.

Index table: This is supported by most of the pega platforms. This pega platform DB supports indexes that have table names start with pr_index (or) Pc _ index which fall under this category.

Along with this, there are some other features added recently. And now PEGA  becoming the most important tool for the IT developer. Today  PEGA CSA  and PEGA CSSA have to become the most common certifications.

Connect with OnlineITGuru for  Pega Online Course Now!

Recommended Audience:

This course is for all audience those who are interested in working business development in any organization. Stakeholders, project managers and who can understand the basic core concepts of Pega marketing. It is used for Pega certified system Architects and providing Pega 7 related support in decision management.

Prerequisites :              

It better to have the essential thing information of Html and XML lastly, should have the comprehension of the rationale to engineers and should have some learning of object-oriented programming dialects like Java or C++. Henceforth the class structure and legacy utilized as a part of the item.

 
Drop Us A Query

100% Secure Payments. All major credit & debit cards accepted.