-
公开(公告)号：US10853365B2
公开(公告)日：2020-12-01
申请号：US15113448
申请日：2014-03-28
发明人： Hideomi Idei , Norifumi Nishikawa , Shinji Fujiwara , Kazuhiko Mogi , Kazuo Goda , Masaru Kitsuregawa
IPC分类号： G06F16/245 , G06F16/2453 , G06F16/21
摘要： As an I/O method of issuing an I/O request, there are a synchronous I/O method, in which a task is in a waiting state until an I/O response to the I/O request is returned and an asynchronous I/O method, in which another task can be executed before an I/O response to the I/O request is returned. When issuing an I/O request in execution of a task, a DBMS selects any one of the synchronous I/O method and the asynchronous I/O method, based on an I/O response speed of an I/O destination storage device and issues an I/O request according to the selected I/O method.
-
公开(公告)号：US12086411B2
公开(公告)日：2024-09-10
申请号：US17894196
申请日：2022-08-24
申请人： Hitachi, Ltd.
发明人： Kazuhiko Mogi , Shinji Fujiwara
IPC分类号： G06F3/06
CPC分类号： G06F3/061 , G06F3/0659 , G06F3/0676 , G06F3/0679 , G06F3/0682
摘要： A database is stored in a plurality of pages that are a plurality of logical storage areas constituting a logical storage space. Data writing to a database in the logical storage space is performed in a page unit. A storage control apparatus coupled to an external storage and including a cache device writes data to the cache device in a page unit. The storage control apparatus determines whether an execution condition on external writing that is writing to the external storage is satisfied. When a result of the determination is true, the storage control apparatus writes data stored in the cache device to the external storage in a bulk unit that is larger than a page unit and is a writing unit in which consistency is maintained.
-
公开(公告)号：US12056129B2
公开(公告)日：2024-08-06
申请号：US18113154
申请日：2023-02-23
申请人： Hitachi, Ltd.
IPC分类号： G06F16/30 , G06F11/34 , G06F16/22 , G06F16/2455
CPC分类号： G06F16/2456 , G06F11/3433 , G06F16/2255
摘要： The processing load for joining a plurality of tables by hash join is reduced for a computer system in which the CPU of a node creates a partial bloom filter that manages a first table hash value of a joining key of a row corresponding to a query in an assigned row of a build table. An integrated bloom filter is created from a plurality of partial bloom filters, and a second table hash value of the joining key of the row corresponding to the condition of the query among the rows of a probe table is calculated. The row of the probe table is transmitted to the node containing a row of the build table of the join hash value for that row when the integrated bloom filter includes an identical first table hash value, and an integrated joined table is created and returned to the query request source.
-
公开(公告)号：US12038888B2
公开(公告)日：2024-07-16
申请号：US18110023
申请日：2023-02-15
申请人： Hitachi, Ltd.
发明人： Kazuhiko Mogi
CPC分类号： G06F16/212 , G06F16/22 , G06F16/2365
摘要： A storage control apparatus generates an evaluated compression dictionary from a compression dictionary. The compression dictionary includes, for each of different values included in original data of compressed data, a value and a compression code. The evaluated compression dictionary includes, for each value in the compression dictionary, a value and a compression code. The compressed data includes a compression code for each value in the original data. The storage control apparatus performs, in generation or update of the evaluated compression dictionary, condition evaluation of the value. A compression code of a value determined to correspond to the search condition in the condition evaluation is a condition satisfied code. The storage control apparatus is configured to, in the search, for a compression code in the search range of the compressed data: output, when there is an evaluation dictionary record including a condition satisfied code matching the compression code, a value in the evaluation dictionary record; and output, when there is no evaluation dictionary record including a condition satisfied code matching the compression code, a value that means inconsistency.
-
公开(公告)号：US11061907B2
公开(公告)日：2021-07-13
申请号：US16282342
申请日：2019-02-22
发明人： Yuya Isoda , Kazuhiko Mogi , Kouji Kimura , Kazuo Goda , Yuto Hayamizu , Masaru Kitsuregawa
IPC分类号： G06F16/2455 , G06F16/2453
摘要： If a query indicates joining of N (N is an integer of no less than 3) relation tables, a database management system calculates a query cost that is based on a power consumption amount for query execution, for each of a first query plan candidate in which a temporary table is generated and the temporary table is stored in a storage device unit with a first access cost, a second query plan candidate in which a temporary table is generated and the temporary table is stored in a storage device unit with a second access cost that is higher than the first access cost and a third query plan candidate in which the N relation tables are joined in a pipelined manner without generation of a temporary table, selects a relatively low-query cost query plan candidate and executes the query based on the query plan candidate.
-
公开(公告)号：US10747446B2
公开(公告)日：2020-08-18
申请号：US15805362
申请日：2017-11-07
发明人： Yuya Isoda , Kazuhiko Mogi , Makoto Ootahara , Kazuo Goda , Yuto Hayamizu , Masaru Kitsuregawa
摘要： Since storage devices are activated in the issuance order of I/O commands, the time required for processing of a plurality of I/O commands based on one or more I/O requests may become long. When issuance destinations of two or more I/O commands are two or more storage devices in a non-activated state from among a plurality of storage devices, a computer system determines an activation order of the two or more storage devices on the basis of two or more I/O quantities which respectively correspond to the two or more storage devices. Each of the I/O quantities of the two or more storage devices is an I/O quantity in accordance with one or more I/O commands for the relevant storage device from among the two or more I/O commands. The computer system activates the two or more storage devices in the determined activation order.
-
公开(公告)号：US11709839B2
公开(公告)日：2023-07-25
申请号：US17471267
申请日：2021-09-10
发明人： Hideomi Idei , Kazuhiko Mogi , Norifumi Nishikawa , Akira Shimizu , Kazuo Goda , Yuto Hayamizu , Masaru Kitsuregawa
IPC分类号： G06F16/2455
CPC分类号： G06F16/2455
摘要： A database system includes a plurality of DBMSs included in a plurality of nodes. Each DBMS is a first or a second DBMS. The first DBMS transfers a search query and does not execute data retrieval, and the second DBMS executes data retrieval. The plurality of nodes configure one or more node groups. Each node group includes a first node and one or more second nodes. In each node group, the first node is a logical computer that provides a first storage area and executes a first DBMS and the second node is a logical computer that provides a second storage area and executes a second DBMS, each node in the node group stores the same database therein, and data retrieval from the database in the node group is executed by one or more second DBMSs in the node group.
-
公开(公告)号：US11636107B2
公开(公告)日：2023-04-25
申请号：US16531256
申请日：2019-08-05
发明人： Akira Shimizu , Seisuke Tokuda , Michiko Yoshida , Kazuhiko Mogi , Shinji Fujiwara , Nobuo Kawamura , Masaru Kitsuregawa , Kazuo Goda
IPC分类号： G06F16/2453 , G06F16/2455 , G06F9/48
摘要： A database management system (DBMS) generates a query execution plan including information representing one or more database (DB) operations necessary for executing a query and executes the query based on the query execution plan. In the execution of the query, the DBMS dynamically generates a task for executing a DB operation and executes the dynamically generated task. The DBMS executes a task in a plurality of threads executed by a processor core.
-
公开(公告)号：US11176092B2
公开(公告)日：2021-11-16
申请号：US16575577
申请日：2019-09-19
发明人： Yuya Isoda , Kazuhiko Mogi , Kouji Kimura , Kazuo Goda , Yuto Hayamizu , Masaru Kitsuregawa
IPC分类号： G06F16/14 , G06F16/178 , G06F21/62
摘要： There is provided a database management system (DBMS) in order to make anonymization processing of the database efficient. When receiving a query including a conversion rule, the database management system is configured to process a relationship table in the database based on the conversion rule. At that time, the DBMS is configured to acquire data from a processing result table (result of processing the relationship table) stored in the past for tuples the number of which for each value appearing in a predetermined attribute satisfies a condition required for the anonymization processing. On the other hand, for tuples the number of which for each value appearing in a predetermined attribute does not satisfy the condition required for the anonymization processing, the DBMS is configured to acquire data from the database or from a result of processing the relationship table, the result being stored in rather than the processing result table.
-
公开(公告)号：US10810174B2
公开(公告)日：2020-10-20
申请号：US15561221
申请日：2015-04-13
申请人： Hitachi, Ltd.
摘要： A database includes a plurality of data blocks. Each of the plurality of data blocks includes a plurality of data pages in which a plurality of column values recorded in one or more records corresponding to the data block are stored. Each of the plurality of data pages has two or more column values in one column corresponding to the data page stored therein. A database server selects a data block from the plurality of data blocks and specifies a data page to be scanned from the selected data block.
-
-
-
-
-
-
-
-
-
搜索结果
18 条记录 (耗时 0.017 秒)
