A method and apparatus enables partitioning of data to efficiently store and retrieve data relating to a database system (either a parallel or non-parallel database system). Such partitioning may be performed by receiving information associated with at least one characteristic of the data and performing an algorithm to divide the data into related data segments. The data segments may be stored in a distributive database system based on the characteristic associated with the data.

Method and apparatus for partitioning data for storage in a database

A system and methodology for parallel query optimization using semantic-based partitioning is described. In one embodiment, for example, in a database system comprising a database storing data in database tables, a method is described for improving query performance by dynamically partitioning the data, the method comprises steps of: receiving a query requesting data from the database; generating a plurality of subplans for executing the query, each subplan including one or more operators for performing relational operations; adding operators for partitioning data and performing a given relational operation in parallel to at least some of the plurality of subplans; and building a plan for execution of the query based, at least in part, upon selecting subplans having favorable execution costs.

System and Methodology for Parallel Query Optimization Using Semantic-Based Partitioning

A computer-implemented method of processing a geotext query, said method involving: receiving a first free-text query string from a user; and decomposing the first free-text query into a non-geographic query and a geographic query, wherein the non-geographic query is a second free-text query string derived from the first free-text query string and the geographic query is a geographical location description.

User interface for geographic search

Under one aspect, an interface program stored on a computer-readable medium causes a computer system with a display device to perform the functions of: displaying a document on the display device; displaying a selectable button for requesting location-related information pertaining to the document; accepting a user selection of the button as a request to view the location-related information pertaining to the document; in response to the request, requesting and receiving metadata identifying candidate location references within the document; displaying on the display device a map with visual indicators representing at least a subset of the plurality of location references within the document; and displaying on the display device the document with visual indicators representing at least a subset of the plurality of location references within the document.

Systems and methods for generating and correcting location references extracted from text

Exemplary systems and methods for linking entity references to entities and identifying associations between entities are presented. In particular, a method for delinking one or more entity references linked to a same entity is provided, where the one or more entity references have at least one common data field. The method comprises the steps of evaluating at least one actual measurement of the entity based at least in part on one or more field values of the one or more entity references, determining a difference between the at least one actual measurement and at least one predefined measurement associated with the entity and delinking the one or more entity references based at least in part on a comparison of the difference and a defined threshold.

Method and system for linking and delinking data records

A method, apparatus, and an article of manufacture for parallel execution of SQL operations from within user defined functions. One or more embodiments of the invention provide the user defined function (UDF) with a C++ class (hereinafter referred to as “dispatcher”) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling UDF. To provide the single stream to the calling UDF, one or more embodiments of the invention utilize a class that provides the UDF with a simple and easy-to-use interface to access the results of the nested SQL execution.

Method and apparatus for parallel execution of SQL-from within user defined functions

A method, apparatus, and an article of manufacture for parallel execution of SQL operations from stored procedures. One or more embodiments of the invention provide the stored procedure (stored procedure) with a C++ class (hereinafter referred to as “dispatcher”) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling stored procedure. To provide the single stream to the calling stored procedure, one or more embodiments of the invention utilize a class that provides the stored procedure with a simple and easy-to-use interface to access the results of the nested SQL execution.

Method and apparatus for parallel execution of sql from stored procedures

A method and apparatus for parallel execution of trigger actions. One or
more embodiments of the invention comprise providing a C++ class (hereinafter
referred to as "dispatcher") that can take an SQL query or trigger action and start
parallel execution of the trigger action. The trigger action is optimized and
parallelized. The dispatcher executes the trigger action, sets up the communication
links between the various operators in the trigger action, and ensures that all the
results are sent back to the trigger.

Method and apparatus for parallel execution of trigger actions

A method, apparatus, article of manufacture, and a memory structure for providing access to an array-based data object to a client is disclosed. The method comprises the steps of receiving a database query from a client; generating a first execution plan from the database query; transmitting at least a portion of the first execution plan to a data server; compiling a query result from the execution of the first execution plan; and transmitting the query result to the client on a first communication path wherein the query result comprises an identification for a master data object responsive to the database query and the master data object comprises an identification for a plurality of array-based objects associated with the master data object. Further, the method comprises the establishment of a second communication path between the data server and the client and the transmission of the master data object to the client via this second communication path. This is followed by a third request by the client for the required array-based objects. This results in the generation of a third execution plan which is executed by the appropriate data server. The resultant array-based objects are then tagged with the corresponding object identification and sent in batched fashion directly to the client via the second communication path.

Jie-Bing Yu

Papers

Method and apparatus for parallel execution of SQL-from within user defined functions

Method and apparatus for parallel execution of sql from stored procedures

Method and apparatus for parallel execution of trigger actions

Method and apparatus for fetching array based objects by direct delivery and batching