# US 2012/0254157 A1 · Apparatus, method and computer-readable storage medium for retrieving data from a data source

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2012/0254157 A1
- Document ID: US20120254157A1
- Status: Published application
- Kind: A1
- Application number: 13/075,728
- Filed: 2011-03-30
- Published: 2012-10-04
- Earliest claimed: 2011-03-30
- Assignees: McKesson Financial Holdings
- Inventors: Eldon Wong; Euphine Wong
- Web page: https://patentgrep.com/patent/US20120254157A1

## CPC

- G06F 16/84: Mapping; Conversion
- G06F 16/258: {Data format conversion from or to a database}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

An apparatus is provided that includes a processor and memory storing executable instructions that in response to execution by the processor cause the apparatus to at least perform a number of operations. The apparatus is caused to receive a rowset of data from a data source, where the rowset includes one or more rows of values from the data source. The apparatus is caused to convert the rowset to markup data, and organize the markup data in preparation for its transformation to an output according to a markup transformation language. The markup data includes, for each row of the rowset, a row markup element; and the organized markup data includes an organization of the row elements into a plurality of logical groups. Even further, the organized markup data may be split into a plurality of smaller markup data sets, which may facilitate transformation of the markup data.

## Claims

### Claim 1

An apparatus comprising a processor and a memory storing executable instructions that in response to execution by the processor cause the apparatus to at least:
receive a query for data from a data source including data organized in one or more tables each of which includes one or more columns of attributes and rows of values in respective columns;
receive a rowset of data from the data source in response to the query, the rowset including one or more rows of values from the data source;
convert the rowset to markup data, wherein the markup data includes a plurality of elements each of which has a start tag, an end tag and content therebetween, wherein for each row of the rowset, the elements include a row element for which the content includes one or more column elements, and for which the content of each column element includes a value of the respective row; and
organize the row elements of the markup data into a plurality of logical groups each of which includes one or more rows from the data source, wherein the organized markup data further includes a plurality of group elements, wherein for each group element, the content includes one or more row elements for the one or more rows of a respective logical group,
wherein the rowset is converted to markup data, and the row elements of the markup data are organized, to prepare the organized data for transformation to an output according to a markup transformation language.

### Claim 2 (depends on 1)

The apparatus of claim 1, wherein the apparatus being caused to organize the row elements includes being caused to organize the row organizing the row elements of the markup data according to user-configurable parameters identifying the logical groups and including an indication of the one or more rows of each of the respective logical groups.

### Claim 3 (depends on 1)

The apparatus of claim 1, wherein the apparatus being caused to organize the row elements includes being caused to organize the row elements of the markup data into a plurality of logical groups, and within each logical group, organize the row elements into a plurality of logical sub-groups each of which includes one or more rows from the data source,
wherein the organized markup data further includes a plurality of sub-group elements, wherein for each group element, the content includes at least some of the sub-group elements for each of which the content includes one or more row elements for one or more rows of a respective logical sub-group which are also one or more rows of a respective logical group.

### Claim 4 (depends on 1)

The apparatus of claim 1, wherein the memory stores further executable instructions that in response to execution by the processor cause the apparatus to further:
split the organized markup data into a plurality of smaller markup data sets each of which includes one or more row elements of the organized markup data;
separately transform the plurality of smaller markup data sets to portions of the output according to the markup transformation language; and
combine the portions of the output to form the output.

### Claim 5 (depends on 4)

The apparatus of claim 4, wherein at least two of the logical groups include different numbers of row elements, wherein each of the smaller markup data sets includes one or more row elements of the organized markup data, and
wherein the apparatus being caused to split the organized markup data includes being caused to split the organized markup data such that each of at least some of the plurality of smaller markup data sets includes at least a minimum number of row elements, and such that no two of the smaller markup data sets includes a row element from the same logical group.

### Claim 6 (depends on 5)

The apparatus of claim 5, wherein the apparatus being caused to split the organized markup data includes being caused to split the organized markup data further such that at least one of the smaller markup data sets includes row elements from more than one logical group.

### Claim 7 (depends on 4)

The apparatus of claim 4, wherein the elements of the markup data further include a rowset element for which the content includes the row element for each row of the rowset, and
wherein the apparatus being caused to split the organized markup data includes being caused to split the organized markup data such that each smaller markup data set of the plurality of smaller markup data sets includes a rowset element for which the content includes the one or more row elements of the respective smaller markup data set.

### Claim 8

A method comprising:
receiving a query for data from a data source including data organized in one or more tables each of which includes one or more columns of attributes and rows of values in respective columns;
receiving a rowset of data from the data source in response to the query, the rowset including one or more rows of values from the data source;
converting the rowset to markup data, wherein the markup data includes a plurality of elements each of which has a start tag, an end tag and content therebetween, wherein for each row of the rowset, the elements include a row element for which the content includes one or more column elements, and for which the content of each column element includes a value of the respective row; and
organizing the row elements of the markup data into a plurality of logical groups each of which includes one or more rows from the data source, wherein the organized markup data further includes a plurality of group elements, wherein for each group element, the content includes one or more row elements for the one or more rows of a respective logical group,
wherein the rowset is converted to markup data, and the row elements of the markup data are organized, to prepare the organized data for transformation to an output according to a markup transformation language, and
wherein converting the rowset to markup data and organizing the row elements of the markup data are performed by an apparatus including a processor and a memory storing executable instructions that in response to execution by the processor cause the apparatus to at least convert the rowset to markup data and organize the row elements of the markup data.

### Claim 9 (depends on 8)

The method of claim 8, wherein organizing the row elements includes organizing the row elements of the markup data according to user-configurable parameters identifying the logical groups and including an indication of the one or more rows of each of the respective logical groups.

### Claim 10 (depends on 8)

The method of claim 8, wherein organizing the row elements includes organizing the row elements of the markup data into a plurality of logical groups, and within each logical group, organizing the row elements into a plurality of logical sub-groups each of which includes one or more rows from the data source,
wherein the organized markup data further includes a plurality of sub-group elements, wherein for each group element, the content includes at least some of the sub-group elements for each of which the content includes one or more row elements for one or more rows of a respective logical sub-group which are also one or more rows of a respective logical group.

### Claim 11 (depends on 8)

The method of claim 8 further comprising:
splitting the organized markup data into a plurality of smaller markup data sets each of which includes one or more row elements of the organized markup data;
separately transforming the plurality of smaller markup data sets to portions of the output according to the markup transformation language; and
combining the portions of the output to form the output.

### Claim 12 (depends on 11)

The method of claim 11, wherein at least two of the logical groups include different numbers of row elements, wherein each of the smaller markup data sets includes one or more row elements of the organized markup data, and
wherein splitting the organized markup data includes splitting the organized markup data such that each of at least some of the plurality of smaller markup data sets includes at least a minimum number of row elements, and such that no two of the smaller markup data sets includes a row element from the same logical group.

### Claim 13 (depends on 12)

The method of claim 12, wherein splitting the organized markup data includes splitting the organized markup data further such that at least one of the smaller markup data sets includes row elements from more than one logical group.

### Claim 14 (depends on 11)

The method of claim 11, wherein the elements of the markup data further include a rowset element for which the content includes the row element for each row of the rowset, and
wherein splitting the organized markup data includes splitting the organized markup data such that each smaller markup data set of the plurality of smaller markup data sets includes a rowset element for which the content includes the one or more row elements of the respective smaller markup data set.

### Claim 15

A computer-readable storage medium having computer-readable program code portions stored therein that, in response to execution by a processor, cause an apparatus to at least:
receive a query for data from a data source including data organized in one or more tables each of which includes one or more columns of attributes and rows of values in respective columns;
receive a rowset of data from the data source in response to the query, the rowset including one or more rows of values from the data source;
convert the rowset to markup data, wherein the markup data includes a plurality of elements each of which has a start tag, an end tag and content therebetween, wherein for each row of the rowset, the elements include a row element for which the content includes one or more column elements, and for which the content of each column element includes a value of the respective row; and
organize the row elements of the markup data into a plurality of logical groups each of which includes one or more rows from the data source, wherein the organized markup data further includes a plurality of group elements, wherein for each group element, the content includes one or more row elements for the one or more rows of a respective logical group,
wherein the rowset is converted to markup data, and the row elements of the markup data are organized, to prepare the organized data for transformation to an output according to a markup transformation language.

### Claim 16 (depends on 15)

The computer-readable storage medium of claim 15, wherein the apparatus being caused to organize the row elements includes being caused to organize the row by organizing the row elements of the markup data according to user-configurable parameters identifying the logical groups and including an indication of the one or more rows of each of the respective logical groups.

### Claim 17 (depends on 15)

The computer-readable storage medium of claim 15, wherein the apparatus being caused to organize the row elements includes being caused to organize the row elements of the markup data into a plurality of logical groups, and within each logical group, organize the row elements into a plurality of logical sub-groups each of which includes one or more rows from the data source,
wherein the organized markup data further includes a plurality of sub-group elements, wherein for each group element, the content includes at least some of the sub-group elements for each of which the content includes one or more row elements for one or more rows of a respective logical sub-group which are also one or more rows of a respective logical group.

### Claim 18 (depends on 15)

The computer-readable storage medium of claim 15, wherein the computer-readable storage medium has further computer-readable program code portions stored therein that, in response to execution by the processor, cause the apparatus to further:
split the organized markup data into a plurality of smaller markup data sets each of which includes one or more row elements of the organized markup data;
separately transform the plurality of smaller markup data sets to portions of the output according to the markup transformation language; and
combine the portions of the output to form the output.

### Claim 19 (depends on 18)

The computer-readable storage medium of claim 18, wherein at least two of the logical groups include different numbers of row elements, wherein each of the smaller markup data sets includes one or more row elements of the organized markup data, and
wherein the apparatus being caused to split the organized markup data includes being caused to split the organized markup data such that each of at least some of the plurality of smaller markup data sets includes at least a minimum number of row elements, and such that no two of the smaller markup data sets includes a row element from the same logical group.

### Claim 20 (depends on 19)

The computer-readable storage medium of claim 19, wherein the apparatus being caused to split the organized markup data includes being caused to split the organized markup data further such that at least one of the smaller markup data sets includes row elements from more than one logical group.

### Claim 21 (depends on 4)

The computer-readable storage medium of claim 4, wherein the elements of the markup data further include a rowset element for which the content includes the row element for each row of the rowset, and
wherein the apparatus being caused to split the organized markup data includes being caused to split the organized markup data such that each smaller markup data set of the plurality of smaller markup data sets includes a rowset element for which the content includes the one or more row elements of the respective smaller markup data set.
