Abstract: A method and system for providing data integration of multiple data stores with diverse formats. The data integration engine accepts queries using a standard query language such as XML-QL, executes those queries against the multiple data stores, and returns the results. The data stores may include relational databases, hierarchical databases, file systems, application data available via APIs, and so on. A query may reference data that resides in different data stores. The data integration engine allows operations such as joins across multiple data stores.

Abstract: In response to the provision of a collection of semi-structured data (or its schema), a mapper generates a structured organization to store the collection of semi-structured data. The mapper further collaterally generates a description of how the semi-structured data are stored under the structured organization. In one embodiment, normalized relational tables are used for the structured organization. In alternate embodiments, non-normalized relational tables or other structured organization may also be used. The reverse, that is, the creation of a semistructured data organization for a collection of structured data may also be performed.

Abstract: A method and system for querying data sources. The query system provides a query definition for defining queries in a uniform manner. The query definition includes a query specification, a data source identifier, and optionally, one or more results transforms. The query definition may be stored as a data structure on computer-readable media, such as a CD-ROM. The query specification includes query text and parameters. The query text specifies the query expression that is to be applied to the identified data source to generate the results. The parameters specify portions of the query text that can be changed by a user before a query is executed.

Abstract: In response to the provision of a collection of semi-structured data (or its schema), a mapper generates a structured organization to store the collection of semi-structured data. The mapper further collaterally generates a description of how the semi-structured data are stored under the structured organization. In one embodiment, normalized relational tables are used for the structured organization. In alternate embodiments, non-normalized relational tables or other structured organization may also be used. The reverse, that is, the creation of a semistructured data organization for a collection of structured data may also be performed.

Abstract: In response to the provision of a collection of semi-structured data (or its schema), a mapper generates a structured organization to store the collection of semi-structured data. The mapper further collaterally generates a description of how the semi-structured data are stored under the structured organization. In one embodiment, normalized relational tables are used for the structured organization. In alternate embodiments, non-normalized relational tables or other structured organization may also be used. The reverse, that is, the creation of a semi-structured data organization for a collection of structured data may also be performed.

Abstract: A method and system for providing data integration of multiple data stores with diverse formats. The data integration engine accepts queries using a standard query language such as XML-QL, executes those queries against the multiple data stores, and returns the results. The data stores may include relational databases, hierarchical databases, file systems, application data available via APIs, and so on. A query may reference data that resides in different data stores. The data integration engine allows operations such as joins across multiple data stores.

Abstract: Semi-structured queries in an information page employing semi-structured data are pre-processed to identify the data to be selectively retrieved from the semi-structured data, and the storage locations of the data in a collection of structured data comprising the semi-structured data. The pre-processing references a description of how the semi-structured data are stored in the collection of structured data. Equivalent structured queries to retrieve the data from the collection of structured data are generated; and the semi-structured queries are replaced with the equivalent structured queries. In one application, these pre-processed information pages are stored to fulfill requests from remote clients, to enhance response time to requests. In response to a request, the requested information page is dynamically completed, executing the replacement equivalent structured queries instead, without having to determine in real time where the semi-structured data are stored in the structured organization.

Abstract: In response to the provision of a collection of semi-structured data (or its schema), a mapper generates a structured organization to store the collection of semi-structured data. The mapper further collaterally generates a description of how the semi-structured data are stored under the structured organization. In one embodiment, normalized relational tables are used for the structured organization. In alternate embodiments, non-normalized relational tables or other structured organization may also be used. The reverse, that is, the creation of a semistructured data organization for a collection of structured data may also be performed.