41 results about "Prepared statement" patented technology

The present invention relates to method for assisting a user in generating an itemised medical report from at least one medical image. The at least one medical image is displayed in a display area of single computer display unit. In the same display area, a sub-region containing a checklist specific to the one or more images is displayed. Items from the checklist can be de-selected. This checklist comprises a list of selectable items, each item representing an organ, structure, or abnormality that has to be checked by the user. Linked to each item in the checklist is a default statement that is a pre-prepared statement indicative of the normality of the item. The default statement is not displayed by default as part of the checklist. The user can select an item from the checklist for providing comments by dictation thereon responsive to an observation in the radiological image. At the end of the image analysis, an editable itemised medical report is generated containing each item of the checklist as a heading and either the dictated comment or the default statement associated with the item as an observation. The editable itemised medical report is rapidly and accurately generated, information is confined to a single screen reducing the look-away time and general discomfort over time for the user.

A dynamic foldering system automatically manages the creation and deletion of run-time dynamic folders and selection of documents, items, or object graphs found in the run-time dynamic folders. The system comprises a query/predicate for a design-time folder group based on which dynamic folders are automatically managed, a variable binding mechanism, automatic identifications of dynamic folders containing a particular object, parallel navigation, and customized combination of foldering results. The query/predicate for a design-time folder group can be a parameterized query. The dynamic folder hierarchy is defined by a hierarchy of design-time folder groups defined by a query/predicate on a document comprising structured or semi-structured data. Modifiable criteria for creating the dynamic folder hierarchy are provided by the user. Variable binding provides powerful query/predicate definitions on hierarchical data or graph-structured data. Given a document, the system automatically identifies which dynamic folders contain the document. Parallel navigation allows a user to navigate along additional paths in a hierarchy and combine the navigation results using set operations.

A distributed query system includes a distributed collection of dynamically created compiled queries. As each client submits a query, a parameterized query skeleton is identified, which identifies the general form of the query, and the parameters associated with the particular query. If a compiled form of the skeletal query is available within the distributed system, it is executed with the parameters of the current query. If the compiled form of the skeletal query is not available within the distributed system, a compiled form is created, and the location of this compiled skeletal query is stored for subsequent access by this client, or other clients. The executable compiled skeletal queries may be stored at each client system, in a commonly available server storage system, or within one or more database servers. A routing system may be provided to efficiently route parameterized queries to the appropriate location(s) of the compiled skeletal query.

The present invention includes a method for providing parameterized queries in complex event processing (CEP). The method includes providing a query template which includes one or more bind variables, providing sets of parameters corresponding to the one or more bind variables, and parsing the query template to determine positions of the one or more bind variables. The method further includes scanning the provided sets of parameters to determine which of the sets of parameters are to be bound to the one or more bind variables, binding the one or more bind variables which are determined to be bound to the sets of parameters, and substituting the bound one or more bind variables with the corresponding sets of parameters. The method further includes injecting all incarnations of the parameterized queries into the system, and one template/parameterized query is configured to run them all.

A query processor caches data retrieved from executing prepared statements, and uses the cached data for subsequent accesses to the data, if certain conditions for using the cached data are met. The preferred embodiments also include a data staleness handler that takes care of issues that arise from data that may have changed in the database but is not reflected in the cache. One way to handle data staleness in the cache is to specifically enable or disable caching in a query. If caching is disabled, the query processor will access the data in the database. Another way to handle data staleness in the cache is to provide a timer that causes the cache to be invalidated when the timer times out. Yet another way to handle data staleness in the cache is to provide specified conditions that must be met for caching to occur, such as time or date limitations. Still another way to handle data staleness in the cache is to provide an update trigger for the data in the database that corresponds to the cached data. When the data in the database is updated, the update trigger fires, causing the cache to be invalidated. Note that invalidating the cache could also be followed by automatically updating the cache. By caching the results of processing a prepared statement, other queries that use the same prepared statement may be able to access data in the cache instead of going to the database.

A method of processing a query in a system in an object oriented programming environment, includes using a code to create a condition filter in a standard query language statement, the condition filter defining properties to be satisfied by a result of the query, and the condition filter using an object to execute a precompiled query language statement, and sending the standard query language statement to a database.

A method for cloning of prepared statements for execution against a database is described. In one embodiment, for example, a method for executing a database statement comprises steps of: preparing at least one template for execution of a statement against a database; storing the at least one template in a shared cache available to a plurality of database connections; in response to a request to execute a particular statement on a given database connection, determining whether a template for the particular statement is available in the shared cache; if the template is available in the shared cache, creating a database statement based on the template for execution on the given database connection; and executing the database statement on the given database connection.

Described are data source objects, which provide data from a resource to an application program, such as a data collection for binding to user interface elements. A data source that matches a resource type is specified by an application program, such as via markup language (e.g., XAML). At runtime, a data source object is instantiated as an indirection between the resource and the application data, e.g., the data collection bound to a user interface element. The data source object retrieves data from the data provider resource via asynchronous and/or background communication operations, and with marshaling the data as necessary to deliver it on the original user interface context. Data sources provide integration to major data models, including CLR objects, XML, Sql/ADO, and WinFS, supporting straightforward declarative and parameterized queries while allowing customized behavior using code for more advanced scenarios. An application can define its own customized data source objects.

A software tool and method is provided in which a user can ask questions about their computer programs. As the subject program is executed, information is collected about the units of code that are executed and the changes to data. The user can pause the program, for example by pressing a button labeled “Why”, which will prompt the user to select what they want to ask about. For example, the user can ask about why units of code did or did not get executed. The tool and method provide answers that can be in the form of prepared statements and interactive data and control flow visualizations that show the values of data and the particular units of code that caused the execution to occur or not occur. The user can ask further questions using the visualization.

A Database Management System (DBMS)-based Semantic Web query system and method using parameterized SPARQL queries are provided. The present invention is configured to include output means that creates a parameter list from a SPARQL query statement, converts the query statement into an SQL statement and stores a PREPARED STATEMENT (PS) object in association with the SQL statement, thereby outputting query results. Accordingly, the query time of a Semantic Web service can be reduced, thereby improving QoS.

The invention discloses a collective tax declaration management system and method. The collective tax declaration management system comprises: an application server used for providing a collective tax declaration function interface; a processing server used for processing a data access request from the application server, and transmitting the data corresponding to the data access request to the application server; and a client used for making a data access request to the processing server, and receiving the data transmitted by the processor server and corresponding to the data access request according to the collective tax declaration function interface provided by the application server, and performing tax declaration on the collective tax declaration function interface provided by the application server based on received data. According to the scheme, enterprises can conveniently utilize an information method instead of a manually prepared statement to complete related work, and improve enterprise office efficiency and statement summarization management capabilities.

An apparatus, program product and method dynamically optimize prepared statements resident in a statement pool to permit subsequent reuses of such statements to utilize the optimized representations of such statements. The optimization of pooled statements may be performed responsive to the tracked usage of the statements in a statement pool, to direct the overhead associated with such optimization to those statements that are more likely to be utilized in the future. Among a multitude of possible optimizations, a pooled statement that requests data in a format other than that utilized by the database being accessed may be modified to request the data in the format used by the database, thereby decreasing the overhead in the database associated with format conversions.

An apparatus, program product and method dynamically optimize prepared statements resident in a statement pool to permit subsequent reuses of such statements to utilize the optimized representations of such statements. The optimization of pooled statements may be performed responsive to the tracked usage of the statements in a statement pool, to direct the overhead associated with such optimization to those statements that are more likely to be utilized in the future. Among a multitude of possible optimizations, a pooled statement that requests data in a format other than that utilized by the database being accessed may be modified to request the data in the format used by the database, thereby decreasing the overhead in the database associated with format conversions.