| Patent application number | Description | Published |
|---|
| 20130124475 | System and Method of Performing Snapshot Isolation in Distributed Databases - A system and method of performing snapshot isolation in distributed databases. Each node stores local snapshot information that enforces snapshot isolation for that node. The method includes partially processing a distributed transaction by a first node, receiving a global commit identifier from a coordinator, and continuing to process the distributed transaction, by the first node and a second node, in accordance with the global commit identifier. | 05-16-2013 |
| 20130159631 | TRANSACTIONAL-CONSISTENT CACHE FOR DATABASE OBJECTS - A system and method for providing a transactional-consistent cache for database objects is disclosed. New data is received by a cache manager. The cache manager updates an entry of a cache with the new data received by the cache manager, by registering the updating of the entry with the new data with an invalidator. The registering includes a timestamp. An invalidation event is then generated by the invalidator. The invalidation event includes a notification about the updating of the entry of the cache with the new data received by the cache manager according to the timestamp. | 06-20-2013 |
| 20130166522 | TIME SLIDER OPERATOR FOR TEMPORAL DATA AGGREGATION - Calculation of aggregated values in a history database table can be optimized using an approach in which an ordered history table is accessed. The ordered history table can include a sequential listing of commit identifiers associated with updates, insertions, and/or deletions to values in the database table. The ordered history table can be traversed in a single pass to calculate an aggregation function using an optimized algorithm. The optimized algorithm can enable calculation of an aggregated metric of the values based on a selected method for tracking invalidated values to their corresponding commit identifiers. The calculated metric is generated for a current version of the database table; and promoted. | 06-27-2013 |
| 20140114728 | METHOD AND SYSTEM FOR DATABASE BENCHMARKING - A method and system to define a plurality of benchmark component types, each of the benchmark component types being a meta model defining the benchmark component type; generate instances of the plurality of benchmark component types; define parameters associated with the plurality of benchmark component types; and combine one or more of the instances of the plurality of benchmark component types and the defined parameters associated with the benchmark component types being combined. | 04-24-2014 |
| 20140172804 | Timeline Index for Managing Temporal Data - Embodiments described herein generally relate to creating a timeline index for executing queries on temporal data. A computer-implemented method is described. The method includes creating a first list of tuples that are invalidated in a temporal table and sorting the first list of the invalidated tuples. The method can further include creating a second list of tuples that are activated in the temporal table and combining the first list and the second list into a third list that includes the activated tuples and the invalidated tuples, wherein the third list contains ROW_IDs of both the activated tuples and the invalidated tuples. | 06-19-2014 |
| 20140236912 | Time Slider Operator For Temporal Data Aggregation - Calculation of aggregated values in a history database table can be optimized using an approach in which an ordered history table is accessed. The ordered history table can include a sequential listing of commit identifiers associated with updates, insertions, and/or deletions to values in the database table. The ordered history table can be traversed in a single pass to calculate an aggregation function using an optimized algorithm. The optimized algorithm can enable calculation of an aggregated metric of the values based on a selected method for tracking invalidated values to their corresponding commit identifiers. The calculated metric is generated for a current version of the database table; and promoted. | 08-21-2014 |
| 20140379693 | METHODS AND SYSTEMS FOR ONE DIMENSIONAL HETEROGENEOUS HISTOGRAMS - A method and system to generate cardinality estimates for at least one query execution plan for a query using a histogram, the cardinality estimation being constrained by a q-error that is a factor by which the estimate deviates, at most, from a true value of the cardinality and a threshold value which the cardinality does not exceed; use the cardinality estimation to determine an optimal query plan for executing the query; and produce an output of the optimal query plan. | 12-25-2014 |
