Question
Coned
US
Last activity: 4 Oct 2018 11:08 EDT
Difference between local data storage and data tables
Starting from 7.1.7, data tables are replaced by local data storage. what is the difference between data tables and local data storage? what are advantages with new local data storage?
Also, is there any way to delegate local data storage in prpc 7.1.8?
**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!
PEG
IN
You can refer PDN link https://community.pega.com/sites/default/files/help_v718/procomhelpmain.htm
JPMC
IN
Hi,
refer the following:
https://community.pega.com/sites/default/files/help_v718/procomhelpmain.htm the Local Data Storage wizard
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm studio/data designer/data storage/data-storage-configuring-tsk.htm%3FTocPath%3DData%2520creation%2520and%2520management%7CData%2520type%2520management%7CConfiguring%2520local%2520data%2520storage%7C_____0
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm studio/data designer/data storage/data-storage-configuring-a-source-tsk.htm%3FTocPath%3DData%2520creation%2520and%2520management%7CData%2520type%2520management%7CConfiguring%2520local%2520data%2520storage%7C_____1
Hi,
refer the following:
https://community.pega.com/sites/default/files/help_v718/procomhelpmain.htm the Local Data Storage wizard
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm studio/data designer/data storage/data-storage-configuring-tsk.htm%3FTocPath%3DData%2520creation%2520and%2520management%7CData%2520type%2520management%7CConfiguring%2520local%2520data%2520storage%7C_____0
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm studio/data designer/data storage/data-storage-configuring-a-source-tsk.htm%3FTocPath%3DData%2520creation%2520and%2520management%7CData%2520type%2520management%7CConfiguring%2520local%2520data%2520storage%7C_____1
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm studio/data designer/data storage/data-storage-reviewing-properties-tsk.htm%3FTocPath%3DData%2520creation%2520and%2520management%7CData%2520type%2520management%7CConfiguring%2520local%2520data%2520storage%7C_____2
Cognizant
US
Pegasystems Inc.
IN
Hi Aditya,
Are you looking for some specific information within those links shared by the community members?
If your requirement is related to the content listed within the links, do post your queries as a comment here.
If you have a different question, I would suggest you to create a new question with additional details.
Thanks-
Accenture
RO
Hi,
I think he is looking for an answer to the first question, of course. But the links do not offer anything to clear this question, indeed.
Pegasystems Inc.
US
Hi Vasalica,
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.
Where as 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 information might help you.
Regards
Mahesh
-
John Billington
Wipro Ltd
AU
Hi Mahesh,
Even if you create a local data storage for a data type, the system creates a relational database table in the backend and associates the Data Type class with that table just like Data Tables prior to Pega7. I still don't see a major difference (or benefit) between local data storage and data table
Correct me if I am wrong?
JPMorgan Chase & Company
US
Yes Kiran, it will create following :-
Database Table
Database Table Mapping Rule
Report Definition
Single Instance Data Page
List Data Page
Wipro Ltd
AU
Hi Sudhakar,
I want to convey that I still don't see a major difference (or benefit) between local data storage and data table.
Please correct me if I am wrong.
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
-
Dhara Leuva
Wipro Ltd
AU
Hi Mahesh,
Thanks for your response.
I have also read about DataTable wizard which was present prior to Pega7
https://community.pega.com/sites/default/files/help_v62/procomhelpmain.htm
DataTable wizard creates a concrete class and associated properties and other rules (List, EditList, ListView and Validate rules). Instances of classes created through this facility are stored in the PegaRULES database table named pr_other and are limited to 1,000 rows.
Since the data table may eventually contain hundreds of rows, has high turnover, or may be moved to other Process Commander systems, it is advisable to have a database table for the data table class.
As you said that, the main difference I see is " Local storage will allow the user to create the dedicated table in the PegaDATA schema" from Pega Product itself which was not there prior to Pega7.
Thanks !!!