Mapping hierarchical data from a query result into a tabular...

Details Mapping hierarchical data from a query result into a tabular... Mapping hierarchical data from a query result into a tabular...

2007-06-08

2010-06-29

Ali, Mohammad (Department: 2158)

Data processing: database and file management or data structures

Database design

Database and data structure management

Reexamination Certificate

active

07747657

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.

REFERENCES:
patent: 6631497 (2003-10-01), Jamshidi et al.
patent: 6694309 (2004-02-01), Cho et al.
patent: 6948134 (2005-09-01), Gauthier et al.
patent: 6985895 (2006-01-01), Witkowski et al.
patent: 7177855 (2007-02-01), Witkowski et al.
patent: 2008/0162532 (2008-07-01), Daga
Rice, Frank. “Populating an Excel 2003 Worksheet with Multiple Related Records from a Windows Form.” MS Office Excel 2003 Technical Articles (2005) Web. Jul. 14, 2009. <http://msdn.microsoft.com/en-us/library/aa203734(office.11).aspx>.

Affiliated with

Also associated with

Rating

Mapping hierarchical data from a query result into a tabular... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Mapping hierarchical data from a query result into a tabular..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Mapping hierarchical data from a query result into a tabular... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4157326