G - Physics – 06 – F
Patent
G - Physics
06
F
G06F 17/30 (2006.01) G06F 17/21 (2006.01) G06F 17/22 (2006.01)
Patent
CA 2312597
The present invention provides a technique by which complex queries can be defined and executed in a very flexible and efficient manner. It allows user to define the relationships between a parent and its different children, which can be nested to n-depth levels. The relationships are mapped to a special tree structure and the query processor executes the query based on the tree in an efficient way. The output data is also constructed in the defined tree structure in XML by default, which eliminates data redundancy. The output can be formatted either in Extensible Markup Language (XML) or HyperText Markup Language (HTML) format. The present invention also provides two mechanisms to allow user to define the query: either through configuration files or through a graphical user interface. It is designed in such a way that it can be easily implemented as stand-alone application, for batch processing, or interacting with other applications. The query processing module and the graphical user interface modules are written in the Java programming language and the Java Database Connectivity (JDBC) technologies. The technique of data retrieval disclosed in this invention is different from existing techniques in its high degree of flexibility and complexity in terms of the query structure, yet efficient processing and accurate output result. Because the output is also in tree structure, it eliminates data redundancy and more readable. Furthermore, it is designed as generic as possible and can be used for any data retrieval as long as a tree structure can be defined among the tables or nodes. It can be used in a wide range of systems for database publishing, content management, supply chain management (CRM), electronic data interchange (EDI), and other e-business applications and middleware.
Datamirror Corporation
Smart & Biggar
Zhang Benjamin
LandOfFree
A method for data retrieval using tree-structured query with... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with A method for data retrieval using tree-structured query with..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and A method for data retrieval using tree-structured query with... will most certainly appreciate the feedback.
Profile ID: LFCA-PAI-O-1523230