Mapping hierarchical data from a query result into a tabular format with jagged rows
US7747657B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Jun 8, 2007 |
| Grant date | Jun 29, 2010 |
| Priority date | — |
| Expiry date | May 13, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/258
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Embodiments of the present invention provide techniques for mapping hierarchical data from a query result into a tabular display, such as a spreadsheet. The tabular display allows some (or all) of the elements included in the hierarchical display to be mapped to positions on the report. In one embodiment, a field of the result that stores hierarchical data with repeating elements (e.g., an XML document) is mapped into the tabular report using jagged rows. This approach allows a user to map both the hierarchical and relational data in the result set to cells in the spreadsheet, and in the process, handle any embedded collection (repeated element) in the hierarchical data.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.