30 results about "Graphical query" patented technology

A graphical query interface provides visual feedback to a user during the construction of a query. In a first embodiment, the visual feedback helps the user determine the quality of the query as the query is being built. The relationship of columns in the database is graphically displayed to a user. When the user selects a column in the database, a filtered display mechanism displays only those columns or records that satisfy the portion of the query already constructed. In a second embodiment, the visual feedback eliminates some possible selections in the query tree due to previously-made selections that eliminate the eliminated selections as possibilities. In the second embodiment, the visual feedback mechanism may function according to data values in columns, and may also function according to known relationships between columns themselves.

The invention discloses a method and system based on a browser for visually dragging and querying data. The method comprises the following steps: step one, an operational database and structure information of the same are extracted; step two, the database and the structure information of the same are obtained in the browser and rendered in WEB pages; step three, graphic components and canvases of query operation are rendered in the browser; step four, users arrange procedures of the query operation in graphical interfaces by dragging configuration; step five, a graphical query flow-process diagram is resolved for SQL statements; step six, the SQL query statements are carried out in the back-end; step seven, query results are output in the browser. The method and system based on the browser for visually dragging and querying the data has the advantages that querying the data in the WEB system is more flexible, and SQL query statement writing is simplified; the current situation that the database query is only carried out by inputting the SQL statement is changed; the use threshold of the system can be lowered, and the query process is arranged in a graphical mode; then the description of establishing the query process becomes clearer and more intuitive, and the learning threshold can be lowered.

Certain example embodiments relate to techniques for creating queries on model data of at least one data source (DS1, . . . , DS3) in accordance with at least one data source specific format. A graphical query builder (QB) is configured to enable a user to graphically define a query including multiple building blocks in accordance with a data source independent format (MM). At least one adapter (A1, . . . , A3) for the at least one data source (DS1, . . . , DS3) is configured to translate the query in the data source independent format (MM) into at least one corresponding query in the data source specific format.

A system for geographic mobile customer relations management, using a mobile customer relations management system manager connected to at least one mobile-capable network-connected computing device configured to graphically identify, manage and update customer relations management data in a geographic context and configured to organize customer relations management data based on at least one specific real-time queried variable using a selective graphical encapsulating function and / or graphical query mode to yield optimal routes to location-based customers, with an option to optimize schedules and appointments based on real-time customer relations management data available in a customer relations management system.

Embodiments of the present invention disclose a method, computer program product, and system. In an embodiment, a computing device receives a connection between a first object and a second object, wherein the connection represents a query. The computing device, responsive to receiving the connection, executes the query of the connection and obtains a result, and displays the result between the first object and the second object on the computing device.

The invention discloses a method and system based on a browser for visually dragging and querying data. The method comprises the following steps: step one, an operational database and structure information of the same are extracted; step two, the database and the structure information of the same are obtained in the browser and rendered in WEB pages; step three, graphic components and canvases of query operation are rendered in the browser; step four, users arrange procedures of the query operation in graphical interfaces by dragging configuration; step five, a graphical query flow-process diagram is resolved for SQL statements; step six, the SQL query statements are carried out in the back-end; step seven, query results are output in the browser. The method and system based on the browser for visually dragging and querying the data has the advantages that querying the data in the WEB system is more flexible, and SQL query statement writing is simplified; the current situation that the database query is only carried out by inputting the SQL statement is changed; the use threshold of the system can be lowered, and the query process is arranged in a graphical mode; then the description of establishing the query process becomes clearer and more intuitive, and the learning threshold can be lowered.

A large-scale complex layout resistance extraction acceleration method, comprising the following steps: cutting the complex graph into a plurality of simple sub-graphs; storing the simple sub-graph data into a fast graph query data structure; matching all the simple sub-graph associations The complex graph of the corresponding port graph; calculates all port-to-port parasitic resistances. The large-scale complex layout resistance extraction acceleration method of the present invention can divide a complex graph into multiple simple sub-graphs, and each port graph (or block graph) can quickly query sub-graphs with connections, which are different from simple sub-graphs. The efficiency of graphic geometric calculation is very high, and the matching relationship between port graphics and resistor graphics can be quickly found, which greatly shortens the resistance extraction time, improves efficiency, and also ensures the correctness of matching between ports and resistor graphics, ensuring port-to-port parasitic resistance Extraction accuracy.

The invention discloses a large-scale complex layout resistance extraction acceleration method. The method comprises the following steps of: segmenting a complex graph into a plurality of simple sub-graphs; storing the simple sub-graph data into a quick graph query data structure; matching the complex graphs associated with all the simple sub-graphs with the corresponding port graphs; and calculating parasitic resistances from all ports to the ports. According to the large-scale complex layout resistance extraction acceleration method, a complex graph can be segmented into a plurality of simple sub-graphs, each port graph (or blocking graph) can quickly inquire the sub-graphs with a connection relationship, and the graph geometric operation efficiency of the port graphs (or blocking graphs) and the simple sub-graphs is very high; the matching relationship between the port pattern and the resistor pattern can be quickly found, so that the resistance extraction time is greatly shortened,the efficiency is improved, the matching correctness of the port and the resistor pattern is ensured, and the port-to-port parasitic resistance extraction accuracy is ensured.

Provided is a method and system for supporting imperative graph queries on a relational database, the method comprising: parsing the imperative graph queries into operations of an execution plan; translating operations of the execution plan supported by the relational database into common table expressions query; executing said translated common table expression query on said relational database.

An apparatus and method modify a saved query based on a change in a query value meaning that changes over time. In preferred embodiments a graphical query interface displays an option to adjust query values of a saved database query. A query adjustment mechanism then adjusts the value of the query to compensate for the change in the meaning of the query value since the query was created such that the adjusted query will have the same basic meaning as when the query was originally created. Preferred Embodiments allow the user to specify to adjust the query to the current date or to a specified date in the past.

An apparatus and method modify a saved query based on a change in a query value meaning that changes over time. In preferred embodiments a graphical query interface displays an option to adjust query values of a saved database query. A query adjustment mechanism then adjusts the value of the query to compensate for the change in the meaning of the query value since the query was created such that the adjusted query will have the same basic meaning as when the query was originally created. Preferred Embodiments allow the user to specify to adjust the query to the current date or to a specified date in the past.

An apparatus and method modify a saved query based on a change in a query value meaning that changes over time. In preferred embodiments a graphical query interface displays an option to adjust query values of a saved database query. A query adjustment mechanism then adjusts the value of the query to compensate for the change in the meaning of the query value since the query was created such that the adjusted query will have the same basic meaning as when the query was originally created. Preferred Embodiments allow the user to specify to adjust the query to the current date or to a specified date in the past.

The invention discloses a real-time query method for graph structure data in passenger flow data of a rail transit network. The data graph with attributes and labels is divided based on hops, and a relevant index is established; the query graph is input, and the radius of the query graph is calculated. and select the query starting point; generate the query sequence of the query graph; filter the query starting point of the data graph that meets the conditions according to the characteristics of the query starting point of the query graph in each partition; perform a cascaded graph query process; collect all partitions The query result is completed, and the distributed graph query process is completed. The invention transmits the query graph instead of the data graph in the cross-partition query process, thereby reducing the amount of data transmission; the cascaded query process is based on the starting point and is not performed within the entire data graph range, thereby greatly reducing the query range; asynchronous concurrency is adopted. It can maximize the query efficiency and meet the real-time query processing requirements of the graph structure data in the passenger flow data of the rail transit network.

A method and system of processing graph query are provided. A graph query is received by a relational database graph module. The graph query is translated into one or more relational database queries. One or more relational database queries are translated to be performed on data stored within a relational database. One or more results from the relational database are received based on the sent one or more relational database queries. A synergistic graph is generated on a display, based on the received one or more results.