Browse Prior Art Database

Managed Collections For Relational Data

IP.com Disclosure Number: IPCOM000200965D
Publication Date: 2010-Nov-01
Document File: 2 page(s) / 18K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a method for mapping a relational table to an Atom Publishing Protocol (APP) collection and providing read, update, create, and delete operations on the relational data for users who are creating situational applications. The method applies the updating technique of translating document updates to relational data updates.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 53% of the total text.

Page 01 of 2

Managed Collections For Relational Data

Currently, developers or business users who need to create situational applications cannot easily use relational databases to do so. Further, the Structured Query Language (SQL)

API) does not map well to simple Web-based models that

As a result, simple application assembly

techniques cannot directly use a database table as a resource that may be updated.

Existing systems support the creation of Atom Feeds from relational databases, but these are either read-only or do not promote a document collection model that can be updated, as seen on the Web in facilities such as the Atom Publishing Protocol (

APP).

can be a collection of documents with well defined rules pertaining to how a system updates individual documents.

APP is widely used by Web-based, browser-centric applications.

Current research relates to the generation of Atom feeds from enterprise data sources,

might include relational data, but do not provide a means to update the data, nor do they relate to Atom Publishing Protocol-style document collections.

The disclosed invention maps a relational table to an APP collection and provides read, update, create, and delete operations on the relational data. The table is completely hidden and looks like a collection of Extensible Markup Language (XML) documents, each of which can be manipulated like any other document offered on the Web through APP. The invention has an advantage over the basic feed creation offered by existing products in the simple updating technique in which the system translates document updates to relational data updates. This allows full use of relational tables from scripting languages and browser applications in a familiar, database-independent paradigm.

The APP collection is based on an SQL select statement. Each row of the result set forms a document with the column name being the XML element name and all such elements from the row enclosed in...