摘要:
A framework for a query compiler and run-time environment for resolving a table reference to a dynamic table that is first identified at run-time but is initially unknown at compile-time. A parser parses the table reference and creates a parsed representation for the table that identifies the type of dynamic table. A code generator creates executable plans containing run-time table object representations (TAOB), from the parsed representations, that contain the type of dynamic table. The TAOB is also extended to provide for parameters that are definable at run-time, including a table ID of the actual table entity being referenced. A routine is embedded in a run-time routine that checks the type of dynamic table in the TAOB and dispatches control to one of a plurality of corresponding routines, depending upon the type of dynamic table. The corresponding routines use the extended TAOB to dynamically link the table reference to the dynamic table, depending upon the type of dynamic table. Once the dynamic table has been linked to the table reference, query processing continues as if that table were a base or derived table.
摘要:
Embodiments of the invention concern finding correlations between related traded items, such as securities, commodities, currencies, or contracts. The pricing information of multiple traded items from one or more markets is analyzed and a user is provided with a listing of pairs or larger groups of traded items which are most closely correlated. Another embodiment of the invention is a system and method for finding the most related traded item to a particular predefined item. Another embodiment of the invention is a system and method for finding the traded item whose trading history is closest to a predefined curve.
摘要:
Embodiments of the invention concern finding correlations between related traded items, such as securities, commodities, currencies, or contracts. The pricing information of multiple traded items from one or more markets is analyzed and a user is provided with a listing of pairs or larger groups of traded items which are most closely correlated. Another embodiment of the invention is a system and method for finding the most related traded item to a particular predefined item. Another embodiment of the invention is a system and method for finding the traded item whose trading history is closest to a predefined curve.
摘要:
A method, apparatus, and article of manufacture for a computer implemented modification system for supporting localized data changes in a computer. A change is executed to data in a computer having a local database. The change is performed by the computer to modify data in the local database stored within a data storage device at the computer. The change is indicated as being global. When the local database on the computer is synchronized with a main database on another computer, only global changes are transmitted from the local database to the main database.
摘要:
Provided is a method, system, and program for accessing rows of data from a base table satisfying a search criteria. An initial request to access rows in the base table is received, including the search criteria specifying predicates for one or more columns in the base table. A data structure is generated to include information on qualifying base table rows that satisfy the search criteria. Notification is provided that the qualifying base table rows are accessible before information on all the qualifying base table rows is included in the data structure. A request is then received for one qualifying base table row. A determination is made as to whether the data structure includes information on the requested qualifying base table row. If so, the information in the data structure is used to provide access to the requested qualifying base table row.
摘要:
A technique is provided for generating one or more XML documents from a single SQL query. Data stored on a data storage device that is connected to a computer is transformed. A query is received that selects data stored in a relational database management system on the data storage device, wherein a data access definition defines: (1) a collection of one or more tables in the relational database management system for storing attributes from an XML document, (2) how data stored in the tables maps to the XML document, (3) a query for mapping the data stored in the tables to the XML document, and (4) a table that will contain the XML document after the XML document is generated. Then, one or more XML documents are generated from the selected data using the data access definition.
摘要:
An extender for a computer-implemented relational database system is disclosed for storing, querying, and retrieving structured documents. The extender provides a new abstract data type and includes a plurality of user defined functions for storing, querying, and retrieving structured documents internally, as character-based large objects (CLOB), or externally, in flat files or URLs, for example. A method and apparatus using an extender having a “conditional select” functionality is further disclosed for querying structured documents. The “conditional select” functionality is based on user defined functions residing within the extender being applied to a projection in a structured query in the database system. A method and apparatus using an extender having a set of user defined functions is further disclosed for creating one or more indexes for structured documents stored in the relational database system. The method uses the set of functions to create the indexes and uses already created B+ tree index structures implemented in the database system to support the indexes. A method and apparatus using an extender is further disclosed for creating and supporting structure indexes. The method includes a tag counting system for indexing structured documents and for implementing the structure indexes within the relational database.
摘要:
Techniques are described herein for generating and displaying a confusion matrix wherein a data item belonging to one or more actual classes is predicted into a class. The classes in which the data item may be predicted (the “predicted classes”) are ranked according to a score that in one embodiment indicates the confidence of the prediction. If the data item is predicted into a class that is one of the top K ranked predicted classes, then the prediction is considered accurate and an entry is created in a cell of a confusion matrix indicating the accurate prediction. If the data item is not predicted into a class that is not one of the top K ranked predicted classes, then the prediction is considered inaccurate and an entry is created in a cell of a confusion matrix indicating the inaccurate prediction.
摘要:
A computerized self-service platform assists merchants in creating and managing stores on a computer network. In one aspect, a system for managing a store includes a product database and an ecommerce storefront, with the ecommerce storefront referencing information in the product database. A product administration module (e.g., a catalog manager) allows the merchant to manage the product database on a self-serve basis. Separating the storefront from the product database can yield numerous advantages.
摘要:
An extender for a computer-implemented relational database system is disclosed for storing, querying, and retrieving structured documents. The extender provides a new abstract data type and includes a plurality of user defined functions for storing, querying, and retrieving structured documents internally, as character-based large objects (CLOB), or externally, in flat files or URLs, for example. A method and apparatus using an extender having a “conditional select” functionality is further disclosed for querying structured documents. The “conditional select” functionality is based on user defined functions residing within the extender being applied to a projection in a structured query in the database system. A method and apparatus using an extender having a set of user defined functions is further disclosed for creating one or more indexes for structured documents stored in the relational database system. The method uses the set of functions to create the indexes and uses already created B+ tree index structures implemented in the database system to support the indexes. A method and apparatus using an extender is further disclosed for creating and supporting structure indexes. The method includes a tag counting system for indexing structured documents and for implementing the structure indexes within the relational database.