Patent application number | Description | Published |
20080235183 | Workload Aware Checking of Database Reorganization - The present solution addresses the need to carry out reorganization of a database storage. A statistics-based reorganization check procedure is performed on at least first database tables and indexes, resulting in a preliminary reorganization recommendation. Information on workload on tables and indexes of said database storage is received. Based on the information on workload and the preliminary reorganization recommendation, it is decided whether to carry out reorganization of the database storage in accordance with the preliminary reorganization recommendation. | 09-25-2008 |
20100036864 | PREVENTION OF REDUNDANT INDEXES IN A DATABASE MANAGEMENT SYSTEM - A method and system for preventing redundant indexes in a database management system (DBMS). A received create-index command specifies a new index to be created for retrieving data from a table created by the DBMS and a redundancy check to be performed for the new index in conjunction with an action parameter in the create-index command. If the action parameter includes a REPORT value, each redundant index is stored and/or displayed and the new index is created. If the action parameter includes a PREVENT value and an existing index is redundant in view of the new index and the new index is not redundant in view of the existing index, the existing index is deleted and the new index is created. If the action parameter includes a PREVENT value and the new index is redundant in view of an existing index, the new index is not created. | 02-11-2010 |
20110035359 | Database Backup and Restore with Integrated Index Reorganization - According to an embodiment of the present invention, a method for reorganizing a source index tree of a database table resulting in a target index tree of the database table is provided. A backup process reads source leaf pages of the source index tree in a logical order defined by a sequence of index keys. The logical order can be different from a physical order of the source leaf pages defined by a sequence of respective storage locations. The backup process constructs target leaf pages of the target index tree maintaining the logical order. A restore process constructs target non-leaf pages of the target index tree based on the distribution of the index keys among the constructed leaf pages and stores the target leaf and non-leaf pages. | 02-10-2011 |
20110208754 | Organization of Data Within a Database - A computer implemented method is provided for processing data representing a data entity having sub entities. The method includes analyzing queries to the data entity for deriving information about sets of the sub entities frequently queried together, and grouping the sub entities to a number of banks, each bank having a maximum width, based on the information about sets of sub entities frequently queried together, in order to reduce an average number of banks to be accessed for data retrieval. | 08-25-2011 |
20110276584 | MULTI-TENANCY IN DATABASE NAMESPACE - Database systems are presented including: a database; a database instance of the database, where the database instance includes a set of instance database objects, and where the database instance is accessible by an instance user; and a database tenant associated with the database instance, where the database tenant includes a set of tenant database objects, where the database tenant provides access to the database instance by the tenant user, such that the instance user and the tenant user may independently access the database instance without affecting one another where each of the instance user and the tenant user are configured with independent accessibility. In some embodiments, systems further include: an instance production table associated with the database instance and a tenant production table associated with the database instance. | 11-10-2011 |
20120016851 | System and Method for Partially Deferred Index Maintenance - Methods and Apparatus, including computer program products, for maintaining indexes in a database management system. The database management system includes a table having table entries and an index data structure having index data structure entries, the index data structure relating to the table. The index data structure is updated synchronously with an insertion of table entries. The index data structure is maintained unchanged when the table entries are deleted. It is verified by an index-scan on the index data structure that a valid criterion is fulfilled for index data structure entries, and those index data structure entries that pass the valid criterion from the index-scan are returned. | 01-19-2012 |
20120016881 | Automatic Maintenance of a Set of Indexes with Different Currency Characteristics in a Database Management System - Methods and apparatus, including computer program products, for maintaining a set of indexes in a database management system (DBMS) having at least one table. A current, stale or deferred status is defined for at least a part of the indexes, resulting in at least a part of a set of current, stale, or deferred indexes in the DBMS. Current indexes are maintained by refreshing a current index synchronously with a table change relating to the current index. Stale indexes are maintained by refreshing a stale index continuously and asynchronously to table modifications of tables relating to the stale index based on log information relating to the modifications. Deferred indexes are maintained by building a deferred index in response to a query to a table relating to the deferred index, thereby bringing the deferred index in accordance with the current query time status to the table relating to the deferred index. | 01-19-2012 |
20120117064 | ADAPTIVE CELL-SPECIFIC DICTIONARIES FOR FREQUENCY-PARTITIONED MULTI-DIMENSIONAL DATA - A cell-specific dictionary is applied adaptively to adequate cells, where the cell-specific dictionary subsequently optimizes the handling of frequency-partitioned multi-dimensional data. This includes improved data partitioning with super cells or adjusting resulting cells by sub-dividing very large cells and merging multiple small cells, both of which avoid the highly skewed data distribution in cells and improve the query processing. In addition, more efficient encoding is taught within a cell in case the distinct values that actually appear in that cell are much smaller than the size of the column dictionary. | 05-10-2012 |
20120221523 | Database Backup and Restore with Integrated Index Reorganization - According to an embodiment of the present invention, a method for reorganizing a source index tree of a database table resulting in a target index tree of the database table is provided. A backup process reads source leaf pages of the source index tree in a logical order defined by a sequence of index keys. The logical order can be different from a physical order of the source leaf pages defined by a sequence of respective storage locations. The backup process constructs target leaf pages of the target index tree maintaining the logical order. A restore process constructs target non-leaf pages of the target index tree based on the distribution of the index keys among the constructed leaf pages and stores the target leaf and non-leaf pages. | 08-30-2012 |
20120323884 | TRANSPARENT ANALYTICAL QUERY ACCELERATOR - A method and apparatus for transparent analytical query acceleration identifies within a database management system (DBMS) if a query is an analytical type. The query is processed with an analytical query processor if the query is the analytical type. In addition, the query is processed within the DBMS if the query is not the analytical type. | 12-20-2012 |
20130033389 | DATA VALUE OCCURRENCE INFORMATION FOR DATA COMPRESSION - A method for generating occurrence data of data values for enabling encoding of a data set includes determining occurrences of data values in a first data batch and determining occurrence count information for a first number of most frequent data values in the first data batch, the occurrence count information identifying the most frequent data values and their occurrence counts. The method also includes generating for rest of the data values in the first data batch at least a first histogram having a second number of buckets and merging the occurrence count information of the first data batch with occurrence count information of a second data batch. The method further includes merging the first histogram of the first data batch to a merged histogram corresponding to the second data batch and processing a next data batch as a first data batch until the data set to be encoded is processed. | 02-07-2013 |
20130254173 | MULTI-TENANCY IN DATABASE NAMESPACE - Methods for processing a query in a multi-tenancy environment utilizing an electronic computing device are presented, the methods including: causing the electronic computing device to receive the query to a database, where the query includes a number of objects; causing the electronic computing device to determine whether any of the number of objects correspond with the set of tenant database objects; if any of the number of objects correspond with the set of tenant database objects, causing the electronic computing device to process the number of objects from the tenant production table; and if any of the number of objects correspond with the set of instance database objects, causing the electronic computing device to process the number of objects from the instance production table. | 09-26-2013 |
20140095441 | Archiving Data in Database Management Systems - According to one embodiment of the present invention, at least a portion of data from a first processing system is archived onto a second processing system based on partitions of the data. A query received at the first processing system is processed at the second processing system to retrieve archived data satisfying the received query in response to determining at the first processing system that the received query encompasses archived data. Embodiments of the present invention further include methods, systems, and computer program products for archiving and accessing data in substantially the same manner described above. | 04-03-2014 |
20140095443 | Archiving Data in Database Management Systems - At least a portion of data from a first processing system is archived onto a second processing system based on partitions of the data. A query received at the first processing system is processed at the second processing system to retrieve archived data satisfying the received query in response to determining at the first processing system that the received query encompasses archived data. Embodiments of the present invention further include methods, systems, and computer program products for archiving and accessing data in substantially the same manner described above. | 04-03-2014 |
Patent application number | Description | Published |
20100236529 | FUEL INJECTION PUMP WITH AN IMPROVED DRIVE CLUTCH - The invention relates to a fuel injection pump for an internal combustion engine, which fuel injection pump, for the drive of the same, is connected in a torque-transmitting manner through a clutch unit to a drive input member. The clutch unit has a claw hub which is arranged on the drive input member and is axially fixed and is driven in rotation. The rotational movement can be transmitted to a reciprocating and rotating pump member. The claw hub and the pump member have respective claws which are aligned counter to one another and which have lateral claw faces between which is arranged a star-shaped and/or tongue-groove-like transmission body which, for the transmission of the torque, adjoins the respective claw faces. The claw faces are formed with an outwardly arched, spherical surface in order to create at least one defined zone of force introduction from the transmission body into the claw face, such that the stresses which occur in the claw as a result of the force transmission can be reduced. In this way, a fuel injection pump for an internal combustion engine with a clutch unit is created which permits a long service life while at the same time permitting the transmission of large torques, and at the same time has a simple structural design. | 09-23-2010 |
20120080013 | HIGH PRESSURE PUMP AND TAPPET ASSEMBLY - The invention relates to a high pressure pump for a fuel injection device of an internal combustion engine, comprising at least one pump element having a pump piston delimiting a pump working chamber, wherein between the pump piston and a rotationally driven drive shaft of the high pressure pump, a tappet assembly having a tappet body and a roller shoe pressed into a receptacle of the tappet body is provided, wherein the tappet body comprises a centering guide for pressing in the roller shoe. The invention further relates to a tappet assembly for a high pressure pump for a fuel injection device of an internal combustion engine comprising a tappet body and a roller shoe pressed into a receptacle of the tappet body, wherein the tappet body comprises a centering guide for pressing in the roller shoe. | 04-05-2012 |