Technical Tip for June: Progress OE 10 ProDataSets

Here's a great technical note from Progress on the new ProDataSet datatype in Progress OpenEdge 10. [This information is reposted from the PSDN newsletter.]

ProDataSets in OpenEdge Release 10

May 2004

In a recent OpenEdge™ 10 technical overview, Gus Bjorkland, Wizard and Vice President of Technology for Progress Software, said "Without a doubt, the best feature in Version 9 was dynamic queries. In OpenEdge 10, we have a new best feature - it's called ProDataSets." The Progress DataSet (commonly referred to as a ProDataSet) feature, extends the functionality of the already rich Progress programming environment by providing an effective way to define complex business objects (with numerous levels of related data) and the relationships between those levels of data.

In other words, a ProDataSet provides a mapping between a set of database tables or other data sources and their "in-memory" representation. Since a ProDataSet is defined independent of the data structure, it provides a convenient, powerful, and consistent method of separating application data access from the specifics of the underlying data definition or data access mechanism. A ProDataSet can be passed from one procedure to another as a single object and it can be shared with .NET and other open technologies. For these reasons, ProDataSets enable developers to more easily develop and transform applications that are in step with the latest advancements in application development methodologies, including the OpenEdge Reference Architecture.

Prior to the availability of Open Edge 10, the Progress 4GL developer would write 4GL procedure code to manually handle many of the automatic features of ProDataSets. The ProDataSet structure itself automates and encapsulates much of the "by-hand" programming in earlier releases. In addition, it enables features that were difficult to develop using traditional methods.

ProDataSets allow you to define a structure that represents organized tables, regardless of the external structure of the databases. This primary benefit allows you to write business logic and data display logic to reference the ProDataSet in the format best suited to the application. In addition, ProDataSets:

ProDataSets can be utilized on the client-side for processing of user activity and data display, on the server-side for processing of business logic, data retrieval, and data storage, and they can be used to transport complex data structures from one procedure to another.

Read more about ProDataSets in the OpenEdge Release 10 Documentation:

OpenEdge White Paper: Introducing the Progress DataSet
OpenEdge White Paper: ProDataSet Parameters and Events
OpenEdge White Paper: Dynamic Access to the ProDataSet
OpenEdge White Paper: Updating Data Using ProDataSets
OpenEdge White Paper: Advanced Read Operations for ProDataSets
OpenEdge White Paper: Advanced Update Operations for ProDataSets
ProDataSet Examples

(Posted 18 Jun 2004 / Archived 08 Jul 2004)