Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2001-04-13
2004-05-04
Mizrahi, Diane D. (Department: 2175)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06732095
ABSTRACT:
FIELD OF INVENTION
This invention relates to computer systems, and more specifically to a method and system for conversion between a relational database and an XML document.
BACKGROUND OF THE INVENTION
The WWW is a distributed hypermedia system constructed on the Internet, a global system of heterogeneous networked computers. Advances in networking and Web/Internet technology are leading to a network-centric computing model, and the Web and Internet are evolving into the infrastructure for global network computing. By populating this infrastructure with object-based components and combining them in various ways, one can enable the development and deployment of interoperable distributed object systems on the Web. The marriage of the Web with objects presents a compelling computing model. The object model provides the ability to mimic real world process in a fluid, dynamic and natural way. The Web allows for objects to be distributed to servers thereby centralizing access, processing, and maintenance, provides a multiplexing interface to distributed objects, and allows thin-clients. There is an emergence of an industry that provides Web and object interfaces to distributed object tools. Additionally, the Web is considered to be the platform for next-generation business applications. Business objects mirror the business itself, allow process, policy, data and definitions to be shared, and enable the business process to be re-engineered.
XML (extensible markup language) is a markup language for documents containing structured information. Structured information contains both content (words, pictures, etc.) and some indication of what role that content plays or an indication of relationships between the content items. A markup language is a mechanism to identify these structures in a document. The XML specification defines a standard way to add markup to documents, and was created so that richly structured documents could be used over the web. XML documents have three major features. The first feature is that Elements have a name, zero or more attributes, and zero or more children where these children may be either text or additional elements. Second, Attributes are name/value pairs that appear inside of elements, and finally, Arbitrary text may appear within an element.
The XML markup language has several properties that make it useful for representing business data. XML documents are hierarchical—each element in the document has a parent (except the document root, which has no parent) and zero or more children. The ordering of elements and text in a document is significant and there are standard “metadata” formats for defining the allowable structures of a document that includes DTD and XML Schema.
Most business data is stored at some point in a relational database. Relational databases have a different structure for representing data than XML documents. Relational schemas contain a set of tables where each table contains an un-ordered set of records that have a fixed set of data fields known as columns. Tables are related to each other through foreign key relationships, which may take the form of an arbitrary graph. Business applications may access this database directly or provide a layer of software on the data model that is more convenient for access in memory.
XML is frequently used to pass business data between applications or partner companies, while the relational data model is used for the internal storage of the same data. This implies that the data must be transformed between the relational representation and the XML representation. This can be labor intensive if software must be written for each unique XML document type.
SUMMARY OF THE INVENTION
A method to convert data between a relational format and an XML document, by creating a set of XML Mapping Definition metadata from XML schema metadata or DTD using a Wizard. Relational data can be selected from a relational application database and converted to an XML document using the set of XML Mapping Definition.
The method can convert an XML document back to the relational data using the set of XML Mapping Definition; and the relational data converted from the XML document can be stored in an application database.
REFERENCES:
patent: 6189011 (2001-02-01), Lim et al.
patent: 6209124 (2001-03-01), Vermeire et al.
patent: 6366934 (2002-04-01), Cheng et al.
patent: 6418448 (2002-07-01), Sarkar
patent: 6584507 (2003-06-01), Bradley et al.
“Siebel Delivers the First Completely Web-Based Architecture,” Siebel Magazine, vol. 2, No. 3, www.siebel.com/siebelimag/issue7/web.html, 4 pages.
Internet 2 Site Map of Middleware, www.middleware.internet2.edu/, 1 page.
J. Kyrnin, “What is a DTD?,” www.about.com/compute/html/library/weekly/aa101700a.htm, 12 pages.
J. Kyrnin, “What is XML?,” www.about.com/compute/html/library/weekly/aa091500a.htm, 9 pages.
J. Kyrnin, “Meta Tags,” www.about.com/compute/html/cs/metatags/index.htm, 3 pages.
P. Sprenger, “Relational DBMSes Trail Objects In XML Race,” CMP Net, www.wcmh.com/98/98jul/807b001c.html, 6 pages.
“Meta Data Coalition,” www.mdcinfo.com, 2 pages.
“Open Information Model Proposed XML Document Type Definitions,” www.mdcinfo.com/OIM/xmldtds.html, 1 page.
“Competing Data Warehousing Standards To Merge In The OMG,” Meta Deta Coalition Press Release, www.mdcinfo.com/press/pr20000925.html, Sep. 25, 2000, 4 pages.
A. Weiss, “Refresher: XML, ” Web Developer's Virtual Library, wdvl.com/authoring/languages/XML/DOM/intro/refresh_xml.html, Dec. 1998, 4 pages.
A. Weiss, “XML Via the Document Object Model: A Preliminary Course,” www.wdvl.com/authoring/languages/XML/DOM/Intro/index.com, Dec. 21, 1998, 3 pages.
“eBusiness Applications, eBusiness Architecture” Siebel eBusiness, www.siebel.com/products-solutions/architecture.html, 2 pages.
S. Greenberg, “What is Thin Client Computing?” For The Record, , www.thinclient.net/technology/history-short.htm, Jul. 11, 2000, 7 pages.
R. Weston, “Siebel Systems Ships New Suite,” www.news.cnet.com
ews/0,10000,0-1003-200-335848,00.html, Nov. 30, 1998, 2 pages.
N. Walsh, “What is XML?” www.xml.com/pub/a/98/01/guide1.html, Oct. 3, 1998, 5 pages.
“General EAI Information, What is EAI,” IT toolbox, Inc., eia.ittoolbox.com
av/t.asp?t=307&hl=307, 1 page.
D. Norfolk, “Systems Link Up With EAI,” IT Week, ZD Net UK, www.zdnet.co.uk/itweek/brief/1999/29/eai, 11 pages.
M. Buyens, “Enterprise Application Integration (EAI),” www.xpragma.com/eai_wp.htm, 6 pages.
“Web+Object Integration,” www.objs.com/survey/web-object-integration.htm, 54 pages.
“Smart Parsing Tools,” www.datatools.com.au/dt5947.htm, 5 pages.
R. Cover, “The XML Cover Pages,” www.oasis-open.org/cover/xml.html, 111 pages.
“Using the EAI Siebel Adapter,” Siebel eBusiness Application Integration (EAI) Guide, Version 6.2, Section 4-4, 26 pages.
“Using Integration Objects,” Siebel eBusiness Application Integration (EAI) Guide, Version 6.2,Section 2-1, 47 pages.
“Siebel eCommunications 2000 Integration With SLP InfoWare Predictive CRM,” Brochure, 2000, 2 pages.
Bhavsar Chandrakant R.
Fischer Jeffrey M.
Warshavsky Alex S.
Mizrahi Diane D.
Siebel Systems Inc.
Siebel Systems, Inc.
Soong James W.
Wu Yicun
LandOfFree
Method and apparatus for mapping between XML and relational... 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 apparatus for mapping between XML and relational..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for mapping between XML and relational... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3248181