Question
Pegasystems Inc.
IN
Last activity: 16 Oct 2018 12:03 EDT
Difference between datatable/local data storage and database table
What is the difference between datatable / local data storage and database table?
***Updated by moderator: Lochan to add Categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Pegasystems Inc.
IN
Hi Praveen,
With Pega 7.1.7 local data storage replaces data tables. Local data storage is a feature that lets you store data records for a data type within Pega 7 Platform without having to manually create or maintain database tables.
A database table instance associates an existing class (and other classes derived by pattern inheritance from that class) with an existing relational database table or view, in the PegaRULES database or an external database.
Hope this helps!
Thanks,
Gisela
Wipro Ltd
AU
Hi Gisela,
1. Even if you create a local data storage for a data type, the system still creates a relational database table in the backend and associates the Data Type class with that table just like Data Tables prior to Pega7.
2. Also, I cannot see a big difference between Data Tables (prior to Pega7) and local data storage in Pega7 except that data pages are created automatically
Please help me if I am understanding is incorrect
JPMorgan Chase & Company
US
Yes Kiran, the terminology is different.
Wipro Ltd
AU
Hi Sudhakar,
I still did not understand the difference between datatable/local data storage and database table except that in datatable/local data storage, the system creates rules for us instead of we creating manually.
Please correct my understanding
Pegasystems Inc.
US
Hi Kiran,
Earlier we have the data table concept which will associate an existing class(and other classes derived by pattern inheritance from that class) with an existing relational database table or view, in the PegaRULES database or an external database. And we don't have the option to create the table in database from Pega product for users in PegaDATA schema as the data should be stored in the PegaDATA schema.
So here comes the concept called Data Type which will create a class derived from Data- class. So when you create a Data Type then it will create a class inherited from Data- class and the properties which were added in your Data Type will be stored in pr_other table in the blob column.
Now if you want to store your data in the dedicated table instead of storing it in pr_other table then you can create the local storage to that data type, which will create the dedicated table in PegaDATA schema with the properties you have added in your data type and a data page, data page list to retrieve your data into Pega product.
So finally the Data Type contains the concept of Local storage which will allow the user to create the dedicated table in the PegaDATA schema along with the data page and page list to retrieve the data into the product.
Apart from these there are no further differences related to these two concepts as per my understanding.
Hope its clear for you.
Regards
Mahesh
Wipro Ltd
AU
Hi Mahesh,
Thanks for your response. I believe we have discussed the same in below thread as well.
https://collaborate.pega.com/question/difference-between-local-data-storage-and-data-tables
-
CHATRAGADDA Madhavi
Vishnu Institute of technology
IN
Hi...
Now I am working on a project. In that Manager has to remove the records present in Local Data Source, While processing the case. How to do that?