1988 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.

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.

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.

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.

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. 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 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.

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 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.