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.
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!
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.
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.