Method and system for converting a schema-based hierarchical...

Details Method and system for converting a schema-based hierarchical... Method and system for converting a schema-based hierarchical...

2006-01-06

2011-11-01

Hong, Stephen (Department: 2178)

Data processing: presentation processing of document, operator i

Presentation processing of document

Structured document

C707S999102

Reexamination Certificate

active

08051373

ABSTRACT:
A method and system are provided for converting a hierarchical data structure into a flat data structure based on a schema. The format of the hierarchical data structure may be XML. A hierarchical data structure conforming to a schema is loaded into an application program. The data structure includes elements and attributes linked together in a parent-child relationship. The schema defines the hierarchical relationships between the elements and attributes in the hierarchical data structure. After the hierarchical data structure conforming to the schema has been loaded, a plurality of layout rules is applied to the hierarchical data based on the schema to create a flat data structure. The layout rules determine how the hierarchical data will be inserted in the flat data structure. The layout rules may be applied by identifying properties in the schema which identify occurrence requirements for elements defined in the schema. After the layout rules have been applied to the hierarchical data, the hierarchical data is rendered into a spreadsheet by inserting the data in rows and columns.

REFERENCES:
patent: 5634053 (1997-05-01), Noble et al.
patent: 5767854 (1998-06-01), Anwar
patent: 6418446 (2002-07-01), Lection et al.
patent: 6476833 (2002-11-01), Moshfeghi
patent: 6480860 (2002-11-01), Monday
patent: 6480865 (2002-11-01), Lee et al.
patent: 6487566 (2002-11-01), Sundaresan
patent: 6501101 (2002-12-01), Murakami et al.
patent: 6502101 (2002-12-01), Verprauskus et al.
patent: 6502112 (2002-12-01), Baisley
patent: 6631497 (2003-10-01), Jamshidi et al.
patent: 6684222 (2004-01-01), Cornelius et al.
patent: 6868423 (2005-03-01), Ohta et al.
patent: 7003722 (2006-02-01), Rothchiller
patent: 2003/0172368 (2003-09-01), Alumbaugh et al.
patent: 2003/0187716 (2003-10-01), Lee
patent: 2004/0006563 (2004-01-01), Zwiegincew et al.
patent: 2004/0025114 (2004-02-01), Hiebert
patent: 2004/0167904 (2004-08-01), Wen et al.
patent: 2007/0220022 (2007-09-01), Lankinen et al.
patent: 2002-207721 (2006-07-01), None
patent: WO 01/06418 (2001-01-01), None
patent: WO 01/82133 (2001-11-01), None
patent: WO 01/98927 (2001-12-01), None
Bohannon—IEEE Feb. 26-Mar. 1, 2002—From XML Schema to Relations.pdf.
“From XML Schema to Relations: A Cost-Based Approach to XML Storage”, by Bohannon et al., Bell Laboratories, Proceedings of the 18th International Conference on Data Engineering (ICD' 02), 2002 IEEE.
Petropoulos et al., XML Query Forms (XQForms): Declarative Specification of XML Query Interfaces, WWW10, May 1-5, 2001, Hong Kong.
“Integrating with External Systems: iPlanet™ Unified Development Server”, Sun Microsystems, Inc., Ver. 5.0, Aug. 2001, pp. 127-156.
Sperberg-McQueen, C.M. and Thompson, Henry, “XML Schema”, W3C Architecture Domain, http://web.archive.org/web/20020802155904/http://www.w3.org/XML/Schema, 2000-2002, pp. 1-10.
Quin, Liam, “Extensible Markup Language (XML)”, W3C Architecture Domain, http://web.archive.org/web/2002121962057/http://www.w3.org/XML/, 1996-2002, pp. 1-3.
Clark, James, and DeRose, Steve, “XML Path Language (XPath), Version 1.0”, W3C, http://web.archive.org/web/2021010034434/http://www.w3.org/TR/xpath, 1999-2000, pp. 1-31.
“Microsoft BizTalk Server 2002—Using BizTalk Mapper”, http://msdn.Microsoft.com/library/en-us/bts—2002/htm/lat—xmltools—map—intro—zkqb.asp..., Microsoft Corporation, 1999-2001, pp. 1-2.
“BizTalk Server 2002 Mapper User Interface”, http://msdn.microsoft.com/library/en-us/bts—2002/htm/lat—xmltools—map—concept—codw..., Microsoft Corporation, 1999-2001, pp. 1.
“BizTalk Server 2002 Compiling Data”, http://msdn.microsoft.com/library/en-us/bts—2002/htm/lat—xmltools—map—concept—drgl.a..., Microsoft Corporation, 1999-2001, pp. 1.
“BizTalk Server 2002 Testing Maps”, http://msdn.microsoft.com/library/en-us/bts—2002/htm/lat—xmltools—map—concept—fhhy.a..., Microsoft Corporation, 1999-2001, pp. 1-2.
“BizTalk Server 2002 View Links and Functoids by Using Grid Preview”, http://msdn.microsoft.com/library/en-us/bts—2002/htm/lat—xmltools—map—check—fuwn.as..., Microsoft Corporation, 1999-2001, pp. 1.
“The StarOffice™ 6.0 Suite: New Features Guide”, Sun Microsystems, V. 1.1, Jul. 2002, pp. 1-31.
“New Microsoft Office Family Application Taps Power of Industry-Standard XML”, http://www.microsoft.com/presspass/press/2002/oct02/10-09officefamilypr.mspx, Microsoft Corporation, Oct. 2002-Feb. 2003, pp. 1-2.
“Q&A: How ‘XDocs’ Alters the Paradigm for Gathering Business-Critical Information”, http://www.microsoft.com/presspass/press/2002/oct02/10-09officefamily.mspx, Microsoft Corporation, Oct. 2002-Feb. 2003, pp. 1-4.
“InfoPath: Microsoft Names New Product from Office Group”, http://www.microsoft.com/presspass/press/2003/feb03/02-10infopath.mspx, Microsoft Corporation, Oct. 2002-Feb. 2003, pp. 1-4.
“Microsoft Unveils Visual Studio.NET Enterprise Tools”, Microsoft Corporation, http://microsoft.com/presspass/press/2001/may01/05-21vseepr.mspx, May 2001, pp. 1-4.
“Microsoft Extends XML Web Services Support in .NET Enterprise Servers Through Visual Studio .NET”, http://www.microsoft.com/presspass/press/2002/feb02/02-13servervspr.mspx, Microsoft Corporation, Feb. 2002, pp. 1-3.
“How to Use XSL to Transform Excel XML Spreadsheet for Server-Side Use”, http://support.microsoft.com/default.aspx?scid=kb;en-us;278976, Microsoft Corporation, Aug. 2004, pp. 1-7.
“Integrated Development Environment (IDE)”, http://web.archive.org/web/20020602032242/http://altova.com/products—ide.html, Jun. 2002, pp. 1-2.
“Altova markup your mind!”, http://web.archive.org/web/20021204211721/http://altova.com/products—ide.html, Dec. 2002, pp. 1-3.
“Arbortext and Accessibility”, http://web.archive.org/web/20021219133536/www.arbortext.com/html/accessibility.html, Dec. 2002, pp. 1-5.
“XML Compliance, 100% Pure XML”, http:web.archive.org/web/20021209185855/www.arbortext.com/html/xml—compliance, Dec. 2002, pp. 1-3.
“Schemas”, http://web.archive.org/web/20021221023148/www.arbortext.com/html/schemas.html, Dec. 2002, pp. 1-3.
“Arbortext's Support for XSL-FO”, http://web.archive.org/web/20021221021632/www.arbortext.com/html/xsl-fo.html. Dec. 2002, pp. 1-4.
“Corel XMetal4, Making XML Content Creation Easy”, http://web.archive.org/web/20031118215158/www.corel.com/servlet/Satellite?pagename, Nov. 2003, pp. 1-2.
“Corel XMetal 4 and Interwoven TeamXML”, http://web.archive.org/web/20030807211225/www.corel.com/futuretense—cs/ccurl/corel+xml+4+and+interwoven+teamxml.pdf, Aug. 2003, pp. 1-2.
“The Corel-XyEnterprise XML Solution”, http://web.archive.org/web/20030807154355/www.corel.com/futuretense—cs/ccurl/corel+and+XY+enterprise+XML+solution.pdf, Aug. 2003, pp. 1-2.
Rice, F. C., “Transform XML Files with XSLT When Importing into Microsoft Excel 2002”, Retrieved from the Internet: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc—xlflatnr.asp, Retrieved on Feb. 7, 2006, 11 pages.
Eisenberg, D., “Using XML”, Retrieved from the Internet: http://www.alistapart.com/stories/usingxml/, Retrieved on Feb. 7, 2006, 7 pages.
Tittel Ed, et al.; “XML for Dummies—4thEdition”; Wiley Publishing, Inc.; 2005; XP007910498; 4 pgs.
Tittel Ed; Online document fragment of “XML for Dummies” Snippet view Ed. 3; 2002; accessed at http://books.google.de/books?hl=en&id=QpoQ8A63kpgC&q=%22#search—anchor> on Sep. 7, 2009; XP00797910499; 3 pgs.
Van Der Vliest, E.; “Using W3C XML Schema”; online document accessed at

Affiliated with

Also associated with

Rating

Method and system for converting a schema-based hierarchical... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for converting a schema-based hierarchical..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for converting a schema-based hierarchical... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4272227