Patents by Inventor Akiko Hoshikawa
Akiko Hoshikawa 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).
-
Publication number: 20220237160Abstract: Trace processing in a database system is facilitated by obtaining database trace data collected from database tracing a database system, and data analyzing, by one or more processors, the database trace data to determine one or more field-related rules to, in part, reduce impact on system performance of database tracing in the database system. Trace processing is further facilitated by applying the one or more field-related rules to a database trace in the database system to adjust trace fields of the database trace according to the one or more field-related rules, thereby reducing impact on system performance of the database trace in the database system.Type: ApplicationFiled: January 28, 2021Publication date: July 28, 2022Inventors: Xiaobo WANG, Shuo LI, Leilei LI, Akiko HOSHIKAWA, Sheng Yan SUN
-
Patent number: 11379444Abstract: Trace processing in a database system is facilitated by obtaining database trace data collected from database tracing a database system, and data analyzing, by one or more processors, the database trace data to determine one or more field-related rules to, in part, reduce impact on system performance of database tracing in the database system. Trace processing is further facilitated by applying the one or more field-related rules to a database trace in the database system to adjust trace fields of the database trace according to the one or more field-related rules, thereby reducing impact on system performance of the database trace in the database system.Type: GrantFiled: January 28, 2021Date of Patent: July 5, 2022Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Xiaobo Wang, Shuo Li, Leilei Li, Akiko Hoshikawa, Sheng Yan Sun
-
Patent number: 11275720Abstract: An improved database-management system determines that a near-capacity leaf page of its database index must be split into multiple pages in order to store newly added index entries. The system determines whether the page should be “multi-split” into more than two pages, the total number of new pages to be added, and the range of indexed values assigned to each new page. These determinations are made as functions of the frequency with which the index page, and other index pages for the same index, have been split in the past, of the data distribution of values indexed by the leaf page, and of the degree of sequentiality of entries added to the leaf page. Leaf pages approaching capacity may also be scheduled for “pre-split” splitting during a period of lower utilization. These multi-split and pre-split operations reduce the numbers of index splits and of corresponding synchronous database-log writes.Type: GrantFiled: January 29, 2020Date of Patent: March 15, 2022Assignee: International Business Machines CorporationInventors: Ying Zhang, Xiaobo Wang, Shuo Li, Ping Wang, Leilei Li, Akiko Hoshikawa
-
Publication number: 20210232557Abstract: An improved database-management system determines that a near-capacity leaf page of its database index must be split into multiple pages in order to store newly added index entries. The system determines whether the page should be “multi-split” into more than two pages, the total number of new pages to be added, and the range of indexed values assigned to each new page. These determinations are made as functions of the frequency with which the index page, and other index pages for the same index, have been split in the past, of the data distribution of values indexed by the leaf page, and of the degree of sequentiality of entries added to the leaf page. Leaf pages approaching capacity may also be scheduled for “pre-split” splitting during a period of lower utilization. These multi-split and pre-split operations reduce the numbers of index splits and of corresponding synchronous database-log writes.Type: ApplicationFiled: January 29, 2020Publication date: July 29, 2021Inventors: Ying Zhang, Xiaobo Wang, Shuo LI, Ping Wang, Leilei Li, Akiko Hoshikawa
-
Patent number: 10089379Abstract: A sequence of one or more input objects are sorted by identifying a property that is exhibited by a sequence of one or more input objects, determining whether each input object from the sequence of one or more input objects exhibits the property, storing each of the one or more input objects into a buffer, wherein an input object is stored in a first buffer if it exhibits the property and an input object is stored in a second buffer if it does not exhibit the property, sorting each of the one or more input objects in each buffer, and merging the one or more input objects in each buffer into a sequence of one or more input objects.Type: GrantFiled: August 18, 2008Date of Patent: October 2, 2018Assignee: International Business Machines CorporationInventors: Hong Min, Yefim Shuf, Hubertus Franke, Allan Benjamin Lebovitz, Christopher John Crone, Akiko Hoshikawa
-
Patent number: 7792825Abstract: A method for fetching an ordered first N rows of a table, includes: reading a row in the table; determining that the read row qualifies as the first N rows of the table for rows read so far, and storing data of the read row; and determining an order of data of qualifying rows and storing the order. Only data in rows that qualify to be among the first N rows are ordered and stored. This provides a significantly more efficient processing. It eliminates tournament tree sorts, corresponding work file read and write I/O's, and associated CPU time. This reduces the time for the running of a query and improves the performance of other applications sharing the use of work files. Further, the improved performance is particular significant when the buffer sizes are within a page of records or rows, although multiple pages may be used.Type: GrantFiled: September 8, 2005Date of Patent: September 7, 2010Assignee: International Business Machines CorporationInventors: Akiko Hoshikawa, Allan B. Lebovitz, Akira Shibamiya
-
Publication number: 20100042624Abstract: Techniques for sorting a sequence of one or more input objects are provided. The techniques include identifying a property that is exhibited by a sequence of one or more input objects, determining whether each input object from the sequence of one or more input objects exhibits the property, storing each of the one or more input objects into a buffer, wherein an input object is stored in a first buffer if it exhibits the property and an input object is stored in a second buffer if it does not exhibit the property, sorting each of the one or more input objects in each buffer, and merging the one or more input objects in each buffer into a sequence of one or more input objects.Type: ApplicationFiled: August 18, 2008Publication date: February 18, 2010Applicant: International Business Machines CorporationInventors: Hong Min, Yefim Shuf, Hubertus Franke, Allan Benjamin Lebovitz, Christopher John Crone, Akiko Hoshikawa
-
Publication number: 20080288495Abstract: Fetching an ordered first N rows of a table, includes: reading a row in the table; determining that the read row qualifies as the first N rows of the table for rows read so far, and storing data of the read row; and determining an order of data of qualifying rows and storing the order. Only data in rows that qualify to be among the first N rows are ordered and stored. This provides a significantly more efficient processing. It eliminates tournament tree sorts, corresponding work file read and write I/O's, and associated CPU time. This reduces the time for the running of a query and improves the performance of other applications sharing the use of work files. Further, the improved performance is particular significant when the buffer sizes are within a page of records or rows, although multiple pages may be used.Type: ApplicationFiled: August 3, 2008Publication date: November 20, 2008Applicant: International Business Machines CorporationInventors: Akiko Hoshikawa, Allan B. Lebovitz, Akira Shibamiya
-
Publication number: 20070061280Abstract: A method for fetching an ordered first N rows of a table, includes: reading a row in the table; determining that the read row qualifies as the first N rows of the table for rows read so far, and storing data of the read row; and determining an order of data of qualifying rows and storing the order. Only data in rows that qualify to be among the first N rows are ordered and stored. This provides a significantly more efficient processing. It eliminates tournament tree sorts, corresponding work file read and write I/O's, and associated CPU time. This reduces the time for the running of a query and improves the performance of other applications sharing the use of work files. Further, the improved performance is particular significant when the buffer sizes are within a page of records or rows, although multiple pages may be used.Type: ApplicationFiled: September 8, 2005Publication date: March 15, 2007Applicant: International Business Machines CorporationInventors: Akiko Hoshikawa, Allan Lebovitz, Akira Shibamiya