1999 results about "Query statement" patented technology

A method and apparatus for generating search results including searching by subdomain and providing sponsored results by subdomain is provided. A search system according to embodiments of the present invention analyzes search queries to determine if they are to be routed to subdomains and presents results include sponsored hits sponsored on a subdomain by subdomain basis.

The invention discloses a mapping knowledge domain questioning and answering system and method based on a template matching technique. The system comprises an offline module and an online module, wherein the offline module is mainly used for offline data preparation, and the online module is mainly used for system service. The system can support a friendly natural language question of a user to serve as a query, grammatical analysis is conducted on the question of the user, an offline-defined manual template library is searched for a matched question template according to a result obtained through grammatical analysis, a final structurized mapping knowledge domain query statement is generated according to an entity matching method and a relation matching method, retrieving is conducted in a mapping knowledge domain according to the structurized query statement, and then a final result is returned. According to the mapping knowledge domain questioning and answering system and method based on the template matching technique, the precise retrieving result can be given for the question of the user, and the searching satisfaction degree of the user is improved.

A system for automating data partitioning in a parallel database includes plural nodes connected in parallel. Each node includes a database server and two databases connected thereto. Each database server includes a query optimizer. Moreover, a partitioning advisor communicates with the database server and the query optimizer. The query optimizer and the partitioning advisor include a program for recommending and evaluating data table partitions that are useful for processing a workload of query statements. The data table partitions are recommended and evaluated without requiring the data tables to be physically repartitioned.

The invention provides a question and answer method based on a knowledge graph, and an agricultural encyclopedia question and answer system. A natural language question raised by a user can be automatically analyzed; a topological structure based on a syntax tree is formed; retrieval and comparison are carried out through the topological structure and a question template in a grammar library; according to a mapping relation between the topological structure and a predicate nominatum, and a mapping relation between a synonym set and a relation or an attribute in the knowledge graph, a question-mapped predicate is obtained; in combination with an entity identified in the question, a final structured knowledge graph query statement is generated; retrieval is carried out in the knowledge graphaccording to the query statement; and a final result is returned. When the relevant topological structure cannot be retrieved in a question template library, the question answering is carried out bycalling common question-answer pairs of an FAQ question library. The question and answer system can give accurate answer retrieval for the question posed by the user, so that the satisfaction degree of the user to the agricultural encyclopedia question retrieval is improved.

Disclosed are embodiments of a system for optimizing query processing in a federated information system. The system may be used to identify alternative query plans in a simulated environment and to calculate cost estimates associated with the alternative query plans, based not only on database statistics and query statements, but also based on workload and processing latencies associated with specific data source and with the federated information system as a whole. In addition the calculated cost estimates may also factor in data source availability and reliability. The system may use the alternative query plans and the associated cost estimates to influence query processing in a federated information system by feeding to the federated information system query plans that allow for cost-efficient query plan-level load distribution, cost-efficient query fragment plan-level load distribution, and load distribution based upon quality of service cost constraints.

A method (and structure) of querying one or more Web-based data sources, includes receiving a compound query statement having at least one first-level query and at least one aggregation operator. An aggregation operator is determined which applies to each first-level query. Each aggregation operator can be either explicit or implicit. An implicit aggregation operator is an aggregation operator defining a default aggregate operation if no explicit aggregation operator is present.

The present application relates to an intelligent question answering method, apparatus, computer device and storage medium. The method comprises the following steps of: acquiring question text of a target domain and extracting a target entity from the question text; obtaining The word vector of the target entity by using the pre-constructed word vector model. inputting The word vector into the pre-trained user intention classification model, and acquiring the user intention types of the question text. Generating A structured query statement according to the user intention type and the target entity, and finding the matching question answers from the knowledge base of the target domain according to the structured query statement. The method realizes intelligent question answering based on natural language processing technology and database technology, which can effectively improve the accuracy of question text matching with the answers in the knowledge base, and improve the accuracy ofintelligent question answering.

The invention discloses a method for answering questions in the petrochemical field based on a knowledge map, which comprises the following steps: constructing conceptual knowledge map and entity knowledge map; receiving the question input by user, segmenting the question, extracting entity, attribute, relation and restriction condition, abstracting the entity into concept, matching the question template and transforming it into structured query statement; query conceptual knowledge map and entity knowledge map, generate answers, match answers to answer sentences template, and transform them into natural language answers. The invention also discloses a petrochemical field question answering system based on knowledge map. The invention can store and express the knowledge in the petrochemical field in the form of knowledge map, establish the connection between the business requirement and the development and production data, provide convenience for the user to obtain the professional knowledge in the form of natural language interactive question answering, improve the user experience, and help to provide the work efficiency of the user.

Methods, systems, and computer program products, implementing techniques for developing applications using configurable patterns. The techniques include determining the functionality of a pre-existing application; selecting one or more patterns based on the functionality of the pre-existing application, and configuring the patterns so that the patterns execute similar functionality as the pre-existing application. The patterns comprise multiple pattern elements including prearranged user interface elements. The patterns specify predefined actions that can be performed using the user interface elements. The predefined actions match actions performed by the pre-existing application. Configuring the patterns includes importing database structure from a database used by the pre-existing application, generating a visual model of a query performed on the database by the pre-existing application, converting the visual model of a query into a query statement, and configuring the patterns to use the query statement.

A database network router (DNR) in a database network includes a client access module and a database resource manager that communicate with each other using a common software interface. The client access module communicates with clients including application servers and external database servers; and the database resource manager communicates with the database servers. The DNR also includes a protocol manager for handling multiple database protocols. The database network router also includes local data cache storage to store commonly used data objects, results of parsed query statement, non-optimized query statements, and optimized alternatives and assigns a priority to each client on log-in. The DNR provides a method for connections pooling, a method for balancing the load in a database networks and a method for synchronizing the data stored in cache memory with the database network and method for synchronizing the data stored in cache memory with the database to insure data reliability. The DNR also provides a method for monitoring and optimizing data queries to improve the performance of the database network. The DNR also provides a method to migrate from an old to a new version of the database.

The invention discloses a Hadoop-based mass stream data storage and query method and a Hadoop-based mass stream data storage and query system. The method comprises the following steps of: constructing a segmented column cluster type storage structure; sequentially storing stream data as column cluster records, compressing the column cluster records from front to back to obtain compressed data pages, writing each compressed data page into a piece of column cluster data, and simultaneously additionally writing the page outline information of the compressed data pages into the tail ends of the column cluster data to obtain an integrated data segment; and in the process of executing query statements, constructing a scan table according to filtering restraints by utilizing the page outline information at the tail ends of data segments to quickly filter the data.

The invention provides a method and a system for converting the query sentence of a database. After a database table and a field are set, the name and field of the required database are selected in the foreground and the self-defined query sentence is inputted by a user according to the service requirement, and the query sentence inputted by the user is subjected to grammar analysis and validation, thus finishing the analysis by scanning the query sentence for only one time. By converting the service Chinese query sentence into a standard English SQL (structured query language) query sentence required by a service system, the invention fulfills the function of converting a service database query sentence into a standard executable SQL sentence, wherein the sentence acquired by the service system is directly available to the system, so that a common user can flexibly and freely use the database without mastering the query tool, SQL syntax and other professional technique of the database.

The invention relates to a method and system for migrating relational data to the HBbase. The system comprises a relational data base, an HBase database, an SQL analysis module, a query conversion module and a data mode management module. As a mapping relation list is designed in the HBase database, a mapping relation of mode information in an original relation database and mode information in the HBase database is stored and mode information of a data form in the original relation database the is completely reserved, a mapping manner can be flexibly configured and more options are provided for users. Due to the efficient data organizing manner of the HBase, the access performance is greatly improved and the storage space is saved. Meanwhile, the data export function is provided and data interaction with other sub-systems is achieved. In addition, the data query function supports SQL query and converts an SQL query statement into a query statement of the HBase database, so that the users can transit to the HBbase database more smoothly.

Disclosed are embodiments of a system for optimizing query processing in a federated information system. The system may be used to identify alternative query plans in a simulated environment and to calculate cost estimates associated with the alternative query plans, based not only on database statistics and query statements, but also based on workload and processing latencies associated with specific data source and with the federated information system as a whole. In addition the calculated cost estimates may also factor in data source availability and reliability. The system may use the alternative query plans and the associated cost estimates to influence query processing in a federated information system by feeding to the federated information system query plans that allow for cost-efficient query plan-level load distribution, cost-efficient query fragment plan-level load distribution, and load distribution based upon quality of service cost constraints.

A database query optimizer includes an access plan storage mechanism that stores execution detail corresponding to a query statement in an access plan cache. By storing execution detail in the access plan cache along with the query statement, the execution detail is available when needed to debug database problems, even after a problem occurs. The execution detail stored in the access plan cache may be mined and analyzed after-the-fact, producing a very powerful tool for debugging database problems. Snapshots of the execution detail may also be created by a user. In addition, the user may setup autonomic snapshots and comparisons so that a user may be alerted from a degradation in database performance between two snapshots.

Infusion devices and related medical devices, patient data management systems, and methods are provided for monitoring a physiological condition of a patient. An exemplary method of querying a database involves receiving an input query from a client device, identifying a logical layer of a plurality of different logical layers of the database for searching based at least in part on the input query, generating a query statement for searching the identified logical layer of the plurality of different logical layers of the database based at least in part on the input query, querying the identified logical layer of the database using the query statement to obtain result data, and providing a search result influenced by the result data.

A system and method for generating an On-Line Analytical Processing (OLAP) query. A query object is provided that supports a plurality of OLAP servers which use different structured query formats. An OLAP server is determined from among the OLAP servers for which the query will be executed based on a property of the query object. The query object is processed to generate a query statement using the structured query format that corresponds to the determined OLAP server.

The invention discloses a query optimization method based on a unified view of a distributed heterogeneous database. The method comprises the following steps of: configuring the unified view for the distributed heterogeneous database for external access; effectively decomposing SQL query statements of the unified view according to a physical table of a database to be queried so as to maximally reduce the number of accesses; querying corresponding physical table by the decomposed SQL query statements and returning back resultant data, wherein a cache region is firstly queried, if the cache region contains corresponding resultant data, the result is directly obtained, and priorities are set for the SQL query statements so as to obtain an optimal result set as much as possible in each time while querying the physical table; and combining the resultant data returned after querying the physical table, and storing the combined resultant data and the corresponding SQL query statements into the cache region. The query optimization method based on the unified view of the distributed heterogeneous database improves efficiency for querying the unified view of the distributed heterogeneous database and reduces usage of resource.

A user-friendly query modeling tool and method, for representing, creating, modifying and modeling a query language statement for use in retrieving data from a database. In accordance with the present invention, the tool includes a user interface for receiving or building and manipulating a query, a query model definition for use in populating instances of one or more query models, and a model content provider for receiving query elements from the user interface and providing them to the query model, and conversely, for retrieving query elements from the query model and providing them to the user interface. A query modeling structure and method are provided for clearly representing query statements which include an atomic element, a combined element and a relationship between the two defined by a combined operator.

A user-friendly query modeling tool and method, for representing, creating, modifying and modeling a query language statement for use in retrieving data from a database. In accordance with the present invention, the tool includes a user interface for receiving or building and manipulating a query, a query model definition for use in populating instances of one or more query models, and a model content provider for receiving query elements from the user interface and providing them to the query model, and conversely, for retrieving query elements from the query model and providing them to the user interface. The user interface dynamically adapts to selections by a user in creating or editing a query statement, thus providing a helpful and user-friendly visual interface.

The invention relates to a data processing method used for implementing a multilist inquiry of a database and used in a computer database inquiring and processing module, including: configuring the relative information to data inquiry, decomposing the data inquiry into many sub-inquiries; as inquiring database, first reading parameter information in the inquiry configuration information; reading the relative information to the inquiry from the configuration information; composing SQL sentences according to the inquiry sentences and the parameter information, connecting the databases the sub-inquiries are related to, then executing the SQL sentences; write the inquiry result in a corresponding memory data region in a form prescribed by a configuration file, and arranging data records according to key words; according to collected attributes of inquiry elements, generating a total record; writing the data column description information in an inquiry memory data region. On the other side, it can complete the multilist and complex database inquiries at a high speed and implement universal inquiries, i.e. it need not compose programs so as to complete complex database inquiry by configuring information.

The invention discloses a resource description framework querying method and system based on a relational database, wherein the method includes the following steps: establishing a result variable table according to the SPARQL query statement input by a user, separating the SPARQL query statement to obtain each basic graphic pattern, and establishing the constant table, the variable table and the blank note table corresponding to the basic graphic patterns and a pattern string identifying the logical relation between the basic graphic patterns; generating a pattern tree based on the pattern string; generating the SQL subquery fragment for each basic graphic pattern according to the corresponding element structural table of each basic graphic pattern, and representing the relationship between the basic graphic patterns based on the pattern tree to connect the SQL subquery fragments into a whole SQL query statement section; utilizing the SQL query statement section obtained through conversion to query the RDF data in the relational database; and semantics wrapping the query result according to the limitation of the SPARQL result set and the user setting and returning the query result to the user.

An inexact query transformation system selects a query element from a query statement. If an inexact transformation improves the query performance, the system prioritizes the candidate transformation rules applicable to the selected query element. The system applies the candidate transformation rules to the selected query element to generate a transformed query element that includes a transformed remote query element. If the transformed remote query element is pushdownable, the system adds the transformed remote query element to a transformed inexact query output. Otherwise, the system applies additional candidate transformation rules to the selected query element to generate the transformed inexact query output. The system applies the transformed inexact query output to a heterogeneous datastore to provide an output query result.

A method and apparatus for generating search results including searching by subdomain and providing sponsored results by subdomain is provided. A search system according to embodiments of the present invention analyzes search queries to determine if they are to be routed to subdomains and presents results include sponsored hits sponsored on a subdomain by subdomain basis.

The invention relates to an intelligent legal instrument generating method and system. The intelligent legal instrument generating system comprises a clause base, a legal knowledge model base, an intelligent question and answer interaction module, a mode recognition module, an inference engine and a generation module. The legal knowledge model base is used for storing legal questions, solutions corresponding to the legal questions, logic of legal clauses and business relations; the intelligent question and answer interaction module is used for recording legal requirement information input by a user and the solutions selected by the user; the mode recognition module is used for transferring the legal requirement information, recorded by the intelligent question and answer interaction module, of the user into inquiry statements, and sending the inquiry statements to the inference engine; the inference engine is used for searching for matched legal problems from the legal knowledge model base according to the inquiry statements, and feeding back the solutions corresponding to the legal problems for the user to select; the generation module is used for searching for the corresponding legal clauses from the clause base according to the solutions selected by the user and the legal knowledge model base and generating an editable legal instrument template. The efficient, accurate and individualized legal instrument generating tool is provided for the user who does not have professional legal knowledge.

This invention discloses a method and a device for optimizing query SQL request, in which, the method includes: standardizing the field names and bynames in the SQL sentences to eliminate the redundant associated relations in them, converting said SQL sentences into a grammar tree to be optimized for logic relation to be converted to standard SQL sentences.

The invention discloses a data query method and system. The data query method includes the steps of firstly, extracting various dimensionalities in a business system, building a plurality of logical tables of business data for describing the business system, building incidence relations between the logical tables and the dimensionalities, then building mapping relations between a physical table and the logical tables according to the physical table of the business system, writing logical query statements according to the logical tables and a logical data query grammar defined according to a rule, finally, according to the mapping relations between the physical table and the logical tables, converting the logical query statements into structuring query statements, and executing the structuring query statements in a database to complete querying of the business data. According to the data query method and system, the complexity of data table understanding and writing can be reduced, and the understandability of a data structure of the business system is improved.

The invention discloses a method and device for aggregate query in distributed databases. The method comprises the steps of receiving an original SQL query statement sent by a client side; obtaining a query column of the original SQL query statement and an aggregate function in condition subquery; in the aggregate function, transforming the complicated aggregate function for multilist computation into a simple aggregate function; according to the simple aggregate function, updating the original SQL query statement into a new SQL query statement; sending the new SQL query statement to two or more databases for querying and receiving the returned query result of the query column; according to the query result and the new SQL query statement, calculating and obtaining the query result of the original SQL query statement. According to the method and device, aggregate query in the databases of multiple computers is achieved, it is not needed to write aggregate processing logic in an application program, and therefore the development time of the application program is shortened.

The invention provides a text search method. The text search method comprises the following steps that an inquiry statement is divided into a key semanteme and a key word according to the input inquiry statement, semantic extension based on the domain ontology is carried out according to the key semanteme so that the extended semanteme can be generated, an extended inquiry statement is generated according to the extended semanteme and the key word, similarity grading is carried out on the extended semanteme, semantic weighing is carried out on the extended inquiry statement, text search is carried out on the extended inquiry statement so as to obtain the corresponding inquiry result, and the searched inquiry result is displayed. According to the method, the search recall ratio and the precision ratio of a search engine can be increased in the text search process. The invention further provides a text search system.

Techniques for managing fast path evaluation of Boolean predicates are provided. In some examples, the fast path evaluation may be based at least in part on received queries and / or query statements associated with a database and / or streaming data. In some examples, a first instruction for enabling execution of a subset of logical operators of the query may be determined. The determination may be based at least in part on the logical operators of the query. Additionally, based at least in part on the first instruction, logical instructions for implementing the query may be generated. Further, the logical instructions may be compiled into machine-readable instructions for implementing only the subset of the logical operators of the query.