Patents by Inventor Namik Hrle
Namik Hrle has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 8825604Abstract: 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.Type: GrantFiled: September 28, 2012Date of Patent: September 2, 2014Assignee: International Business Machines CorporationInventors: Oliver Draese, Namik Hrle, Claus Kempfert, Oliver Koeth, Ruiping Li, Robert S. Muse, Knut Stolze, Guogen Zhang
-
Publication number: 20140095443Abstract: 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.Type: ApplicationFiled: May 2, 2013Publication date: April 3, 2014Applicant: International Business Machines CorporationInventors: Oliver Draese, Namik Hrle, Claus Kempfert, Oliver Koeth, Ruiping Li, Robert S. Muse, Knut Stolze, Guogen Zhang
-
Publication number: 20140095441Abstract: 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.Type: ApplicationFiled: September 28, 2012Publication date: April 3, 2014Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Oliver Draese, Namik Hrle, Claus Kempfert, Oliver Koeth, Ruiping Li, Robert S. Muse, Knut Stolze, Guogen Zhang
-
Patent number: 8653993Abstract: 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.Type: GrantFiled: December 7, 2010Date of Patent: February 18, 2014Assignee: International Business Machines CorporationInventors: Peter Bendel, Oliver Draese, Namik Hrle, Tianchao Li
-
Patent number: 8626717Abstract: A mechanism is provided 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.Type: GrantFiled: May 7, 2012Date of Patent: January 7, 2014Assignee: International Business Machines CorporationInventors: Amit Bendakovsky, Namik Hrle, Thomas Ritter
-
Publication number: 20130254173Abstract: 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.Type: ApplicationFiled: May 10, 2013Publication date: September 26, 2013Inventors: Curt L. Cotner, Namik Hrle
-
Patent number: 8473515Abstract: 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.Type: GrantFiled: May 10, 2010Date of Patent: June 25, 2013Assignee: International Business Machines CorporationInventors: Curt L. Cotner, Namik Hrle
-
Patent number: 8442988Abstract: 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.Type: GrantFiled: November 4, 2010Date of Patent: May 14, 2013Assignee: International Business Machines CorporationInventors: Oliver Draese, Namik Hrle, Oliver Koeth, Tianchao Li, Vijayshankar Raman, Knut Stolze
-
Publication number: 20130033389Abstract: 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.Type: ApplicationFiled: December 7, 2010Publication date: February 7, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Peter Bendel, Oliver Draese, Namik Hrle, Tianchao Li
-
Publication number: 20120323884Abstract: 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.Type: ApplicationFiled: June 17, 2011Publication date: December 20, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Oliver Draese, Namik Hrle, James A. Ruddy
-
Publication number: 20120221523Abstract: 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.Type: ApplicationFiled: May 7, 2012Publication date: August 30, 2012Applicant: International Business Machines CorporationInventors: Amit Bendakovsky, Namik Hrle, Thomas Ritter
-
Patent number: 8200633Abstract: 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.Type: GrantFiled: May 27, 2010Date of Patent: June 12, 2012Assignee: International Business Machines CorporationInventors: Amit Bendakovsky, Namik Hrle, Thomas Ritter
-
Patent number: 8180762Abstract: A method for tuning a database system is disclosed. A tuning strategy is received comprising a first procedure to determine a suggested tuning action, and a second procedure to measure performance of the database system. The suggested tuning action is determined and pre-action performance measured according to the respective procedures. Undo information that indicates how to undo the database system state change of the suggested tuning action is recorded in a database system state history. After executing the suggested tuning action, post-action database system performance is measured according to the second procedure. When the post-action performance is lower than the pre-action performance, the database system state change is undone using the undo information. Embodiments enabling to create new tuning strategies, downloading existing tuning strategies, sharing own tuning strategies and changing existing tuning strategies are disclosed as well.Type: GrantFiled: August 24, 2006Date of Patent: May 15, 2012Assignee: International Business Machines CorporationInventors: Thorsten Steinbach, Michael Reichert, Holger Karn, Namik Hrle, Norbert Heck
-
Publication number: 20120117064Abstract: 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.Type: ApplicationFiled: November 4, 2010Publication date: May 10, 2012Applicant: International Business Machines CorporationInventors: Oliver Draese, Namik Hrle, Oliver Koeth, Tianchao Li, Vijayshankar Raman, Knut Stolze
-
Patent number: 8161017Abstract: According to one embodiment of the present invention, a method for identifying relevant database indexes is provided. According to one embodiment of the present invention, a method includes determining the importance of a particular database transaction and storing an index name related to the transaction along with an indicator of the importance. A database transaction is initiated and the importance indicator is received in an index advisor. The index advisor then makes an index recommendation based on the index importance.Type: GrantFiled: April 3, 2009Date of Patent: April 17, 2012Assignee: International Business Machines CorporationInventors: Namik Hrle, Johannes Schuetzner, James Teng
-
Publication number: 20120016881Abstract: 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.Type: ApplicationFiled: April 7, 2011Publication date: January 19, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Namik Hrle, Johannes Schuetzner, James Z. Teng
-
Publication number: 20120016851Abstract: 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.Type: ApplicationFiled: April 12, 2011Publication date: January 19, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Namik Hrle, Johannes Schuetzner, Knut Stolze
-
Publication number: 20110276584Abstract: 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.Type: ApplicationFiled: May 10, 2010Publication date: November 10, 2011Applicant: International Business Machines CorporationInventors: Curt L. Cotner, Namik Hrle
-
Patent number: 8055646Abstract: 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.Type: GrantFiled: August 5, 2008Date of Patent: November 8, 2011Assignee: International Business Machines CorporationInventors: Oliver Augenstein, Namik Hrle, Thomas Ritter, Andreas Uhl
-
Publication number: 20110208754Abstract: 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.Type: ApplicationFiled: November 15, 2010Publication date: August 25, 2011Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Tianchao Li, Peter Bendel, Oliver Draese, Namik Hrle