Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Building A Unified Query That Spans Heterogeneous Environments

a heterogeneous environment and query technology, applied in the field of data storage, can solve the problems of cumbersome querying process of xml data and relational data, the need for such a solution has remained unsatisfactory, and the complexity of the query required to find, manipulate, and publish data stored in a conventional database has increased

Inactive Publication Date: 2008-11-13
INT BUSINESS MASCH CORP
View PDF2 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

The present invention is a system, service, computer program product, and method for creating a unified query that can be used across different data sources. The system allows users to generate a source structure from a data source, add nodes to a design query canvas, and create a unified query that can be used with different data sources. The system provides a logical view of the query function and allows users to modify the query objects. The technical effect of the invention is to provide a more efficient and flexible way to create unified queries that can be used across different data sources.

Problems solved by technology

With the addition of native XML support in databases, the queries required to find, manipulate, and publish data stored in a conventional database have become more complex.
Consequently, the process of querying over XML data and relational data is cumbersome; a user is required to build combined queries using more than one tool, each with a different user experience.
The need for such a solution has heretofore remained unsatisfied.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Building A Unified Query That Spans Heterogeneous Environments
  • Building A Unified Query That Spans Heterogeneous Environments
  • Building A Unified Query That Spans Heterogeneous Environments

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025]The following definitions and explanations provide background information pertaining to the technical field of the present invention, and are intended to facilitate the understanding of the present invention without limiting its scope:

[0026]Data source: any source of data. Examples of data sources comprise a database in any format (relational, XML, etc.), a file system, a web site, web services, a file system, any program, any computer, any network, etc. additionally, the data source may comprise data passed in an argument.

[0027]FLWOR: an XQuery expression that contains the following clauses: For, Where, Let, Order By, and Return.

[0028]World Wide Web (WWW, also Web): An Internet client-server hypertext distributed information retrieval system.

[0029]XML: eXtensible Markup Language. A standard format used to describe semi-structured documents and data. During a document authoring stage, XML “tags” are embedded within the informational content of the document. When the XML docume...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

A unified query building system generates a source structure comprising nodes from a data structure input of an identified data source, displays the generated source structure in a logical view, adds a selected node or element from the nodes to a design query canvas, generates a query object from the selected node based on a source type of the selected node, presents a logical view of a query function of a selected query object, and generates a unified query comprising the generated query objects. The logical view is displayed in a graphical user interface comprising a design query canvas comprising grids corresponding to functions in a query language such as SQL or XML. The generated unified query is displayed in an actual query view and is outlined in a query outline view.

Description

CROSS-REFERENCE TO RELATED APPLICATIONS[0001]Under 35 USC §120, this application is a continuation application and claims the benefit of priority to U.S. patent application Ser. No. 11 / 368,293, filed Mar. 3, 2006, entitled “Building a Unified Query that Spans Heterogeneous Environments”, all of which is incorporated herein by reference.[0002]The present application relates to co-pending U.S. patent application, titled “System and Method for Generating an Xpath Expression,” Ser. No. 11 / 368,292, which is filed concurrently herewith, and to co-pending U.S. patent application, titled “Query Builder Using Context Sensitive Grids,” Ser. No. 10 / 985,431, filed on Nov. 10, 2004, both of which applications are assigned to the same assignee as the present application.FIELD OF THE INVENTION[0003]The present invention generally relates to data storage in structured or semi-structured, or unstructured format. In particular, the present invention relates to a method for generically constructing a ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(United States)
IPC IPC(8): G06F17/30
CPCG06F17/30908Y10S707/99934G06F17/30545G06F17/30566G06F16/256G06F16/80G06F16/2471
Inventor PETERSON, TRENTENSINGH, HARDEEP
Owner INT BUSINESS MASCH CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com