Patents by Inventor Kazuo Masai
Kazuo Masai 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: 20100042637Abstract: A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BES's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.Type: ApplicationFiled: August 13, 2009Publication date: February 18, 2010Inventors: Masashi TSUCHIDA, Kazuo Masai, Shunichi Torii
-
Patent number: 7599910Abstract: A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BES's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.Type: GrantFiled: September 19, 2000Date of Patent: October 6, 2009Assignee: Hitachi, Ltd.Inventors: Masashi Tsuchida, Kazuo Masai, Shunichi Torii
-
Patent number: 7225178Abstract: Bookmark information indicative of a time corresponding to a given time series data piece for a predetermined time, state transition information indicative of a state of the time series data piece for the predetermined time, and the time series data piece are loaded in a database. The state transition information has one of a value indicative of an online state, a value indicative of a loading state, and a value indicative of a state in which data in the data area is empty. The time series data pieces for the predetermined times are loaded in a plurality of data areas of the database in sequence of times. In accordance with a data deletion request, state transition information corresponding to a data piece of information corresponding to a data piece of interest is set to a value indicating that the data piece of interest is empty.Type: GrantFiled: February 28, 2002Date of Patent: May 29, 2007Assignee: Hitachi, Ltd.Inventors: Takayoshi Shimokawa, Kazuo Masai
-
Patent number: 7039660Abstract: Judgement is made to determine whether or not an access request from a host computer is a write request and whether or not the contents of the write request are log information indicating contents of database processing executed in a buffer by the host computer. When the contents of the write request are the log information, position information indicated in the log information is converted into physical position information in a primary storage system using a conversion table indicating a correspondence between logical position information recognized by the host computer and physical position information in the primary storage system. According to the contents of the log information, data is updated in a database area of the primary storage system represented by the physical position information converted using the conversion table. The access request is sent to a secondary storage system.Type: GrantFiled: July 29, 2003Date of Patent: May 2, 2006Assignee: Hitachi, Ltd.Inventors: Masaru Kitsuregawa, Nobuo Kawamura, Kazuo Masai
-
Patent number: 7031984Abstract: Judgement is made to determine whether or not an access request from a host computer is a write request and whether or not the contents of the write request are log information indicating contents of database processing executed in a buffer by the host computer. When the contents of the write request are the log information, position information indicated in the log information is converted into physical position information in a primary storage system using a conversion table indicating a correspondence between logical position information recognized by the host computer and physical position information in the primary storage system. According to the contents of the log information, data is updated in a database area of the primary storage system represented by the physical position information converted using the conversion table. The access request is sent to a secondary storage system.Type: GrantFiled: July 29, 2003Date of Patent: April 18, 2006Assignee: Hitachi, Ltd.Inventors: Nobuo Kawamura, Masaru Kitsuregawa, Kazuo Masai
-
Publication number: 20050193034Abstract: Judgement is made to determine whether or not an access request from a host computer is a write request and whether or not the contents of the write request are log information indicating contents of database processing executed in a buffer by the host computer. When the contents of the write request are the log information, position information indicated in the log information is converted into physical position information in a primary storage system using a conversion table indicating a correspondence between logical position information recognized by the host computer and physical position information in the primary storage system. According to the contents of the log information, data is updated in a database area of the primary storage system represented by the physical position information converted using the conversion table. The access request is sent to a secondary storage system.Type: ApplicationFiled: July 29, 2003Publication date: September 1, 2005Inventors: Masaru Kitsuregawa, Nobuo Kawamura, Kazuo Masai
-
Publication number: 20040139124Abstract: Judgement is made to determine whether or not an access request from a host computer is a write request and whether or not the contents of the write request are log information indicating contents of database processing executed in a buffer by the host computer. When the contents of the write request are the log information, position information indicated in the log information is converted into physical position information in a primary storage system using a conversion table indicating a correspondence between logical position information recognized by the host computer and physical position information in the primary storage system. According to the contents of the log information, data is updated in a database area of the primary storage system represented by the physical position information converted using the conversion table. The access request is sent to a secondary storage system.Type: ApplicationFiled: July 29, 2003Publication date: July 15, 2004Inventors: Nobuo Kawamura, Masaru Kitsuregawa, Kazuo Masai
-
Patent number: 6745191Abstract: A parallel database management system with a database divided into a plurality of external memory units is disclosed. A control CPU, upon receipt of a request for access to the database, decides whether the access request is for storing or searching a record. For a record storage request, the control CPU determines an external memory unit to store the record using a hash function. In the case of a record search request, on the other hand, all the external memory units are searched in parallel without using the hash function thereby to obtain the desired record. The hash function is altered upon addition of an external memory unit.Type: GrantFiled: April 29, 2003Date of Patent: June 1, 2004Assignees: Hitachi, Ltd., Hitachi Software Engineering Co., Ltd.Inventors: Hideaki Kasao, Keisuke Toda, Kota Yamaguchi, Kazuo Masai, Kiyomi Hirohata
-
Publication number: 20030195893Abstract: A parallel database management system with a database divided into a plurality of external memory units is disclosed. A control CPU, upon receipt of a request for access to the database, decides whether the access request is for storing or searching a record. For a record storage request, the control CPU determines an external memory unit to store the record using a hash function. In the case of a record search request, on the other hand, all the external memory units are searched in parallel without using the hash function thereby to obtain the desired record. The hash function is altered upon addition of an external memory unit.Type: ApplicationFiled: April 29, 2003Publication date: October 16, 2003Inventors: Hideaki Kasao, Keisuke Toda, Kota Yamaguchi, Kazuo Masai, Kiyomi Hirohata
-
Patent number: 6584457Abstract: A parallel data base management system with a data base divided into a plurality of external memory units is disclosed. A control CPU, upon receipt of a request for access to the data base, decides whether the access request is for storing or searching a record. For a record storage request, the control CPU determines an external memory unit to store the record using a hash function. In the case of a record search request, on the other hand, all the external memory units are searched in parallel without using the hash function thereby to obtain the desired record. The hash function is altered upon addition of an external memory unit.Type: GrantFiled: September 15, 2000Date of Patent: June 24, 2003Assignees: Hitachi, Ltd., Hitachi Software Engineering Co., Ltd.Inventors: Hideaki Kasao, Keisuke Toda, Kota Yamaguchi, Kazuo Masai, Kiyomi Hirohata
-
Patent number: 6510428Abstract: A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BES's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.Type: GrantFiled: March 14, 2001Date of Patent: January 21, 2003Assignee: Hitachi, Ltd.Inventors: Masashi Tsuchida, Kazuo Masai, Shunichi Torii
-
Publication number: 20020091675Abstract: Bookmark information having bookmark information indicative of a time corresponding to a given time series data piece for a predetermined time and state transition information indicative of a state of the time series data piece for the predetermined time is loaded, along with the time series data piece, in a database. The state transition information has one of a value indicative of an online state in which the data area is permitted to be retrieved, a value indicative of a loading state in which loading of data in the data area has not yet been completed and the data area is not permitted to be retrieved and a value indicative of a state in which data in the data area is empty. The time series data pieces for the predetermined times are loaded in a plurality of data areas of the database in sequence of times. Even during deletion or addition of data, all data retrieval requests need not be suppressed.Type: ApplicationFiled: February 28, 2002Publication date: July 11, 2002Inventors: Takayoshi Shimokawa, Kazuo Masai
-
Publication number: 20010011278Abstract: Bookmark information having bookmark information indicative of a time corresponding to a given time series data piece for a predetermined time and state transition information indicative of a state of the time series data piece for the predetermined time is loaded, along with the time series data piece, in a database. The state transition information has one of a value indicative of an online state in which the data area is permitted to be retrieved, a value indicative of a loading state in which loading of data in the data area has not yet been completed and the data area is not permitted to be retrieved and a value indicative of a state in which data in the data area is empty. The time series data pieces for the predetermined times are loaded in a plurality of data areas of the database in sequence of times. Even during deletion or addition of data, all data retrieval requests need not be suppressed.Type: ApplicationFiled: March 19, 1998Publication date: August 2, 2001Inventors: TAKAYOSHI SHIMOKAWA, KAZUO MASAI
-
Publication number: 20010011268Abstract: A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BES's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.Type: ApplicationFiled: March 14, 2001Publication date: August 2, 2001Inventors: Masashi Tsuchida, Kazuo Masai, Shunichi Torii
-
Patent number: 6192359Abstract: A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BES's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.Type: GrantFiled: October 28, 1999Date of Patent: February 20, 2001Assignee: Hitachi, Ltd.Inventors: Masashi Tsuchida, Kazuo Masai, Shunichi Torii
-
Patent number: 6169982Abstract: A parallel data base management system with a data base divided into a plurality of external memory units is disclosed. A control CPU, upon receipt of a request for access to the data base, decides whether the access request is for storing or searching a record. For a record storage request, the control CPU determines an external memory unit to store the record using a hash function. In the case of a record search request, on the other hand, all the external memory units are searched in parallel without using the hash function thereby to obtain the desired record. The hash function is altered upon addition of an external memory unit.Type: GrantFiled: April 15, 1999Date of Patent: January 2, 2001Assignees: Hitachi, Ltd, Hitachi Software Engineering Co., Ltd.Inventors: Hideaki Kasao, Keisuke Toda, Kota Yamaguchi, Kazuo Masai, Kiyomi Hirohata
-
Patent number: 6101495Abstract: A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BEST's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.Type: GrantFiled: September 15, 1998Date of Patent: August 8, 2000Assignee: Hitachi, Ltd.Inventors: Masashi Tsuchida, Kazuo Masai, Shunichi Torii
-
Patent number: 5987462Abstract: A parallel data base management system with a data base divided into a plurality of external memory units is disclosed. A control CPU, upon receipt of a request for access to the data base, decides whether the access request is for storing or searching a record. For a record storage request, the control CPU determines an external memory unit to store the record using a hash function. In the case of a record search request, on the other hand, all the external memory units are searched in parallel without using the hash function thereby to obtain the desired record. The hash function is altered upon addition of an external memory unit.Type: GrantFiled: April 25, 1997Date of Patent: November 16, 1999Assignees: Hitachi, Ltd., Hitachi Software Engineering Co., Ltd.Inventors: Hideaki Kasao, Keisuke Toda, Kota Yamaguchi, Kazuo Masai, Kiyomi Hirohata
-
Patent number: 5890150Abstract: A query issue processing method, a query conversion processing method, and a data control processing method are provided for enhancing the efficiency of random sampling processing for use in a database processing system. In query issue processing 2, a query including random sampling processing is issued. In query conversion processing 8, application sequences of random sampling processing and another query processing are exchanged by considering a sampling unit of the random sampling processing. Further, in record control processing 4, random access to a secondary storage device is reduced, thereby enhancing random sampling processing efficiency. Unlike the conventional query conversion processing not considering the sampling unit, the issuance of the query including random sampling processing and performing query conversion by considering the sampling unit allow random sampling to be applied also to a query including aggregation processing, thereby enhancing the efficiency of queries in a wider range.Type: GrantFiled: January 23, 1998Date of Patent: March 30, 1999Assignee: Hitachi, Ltd.Inventors: Kazutomo Ushijima, Shinji Fujiwara, Kazuo Masai, Yori Takahashi, Itaru Nishizawa
-
Patent number: 5813005Abstract: A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BES's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.Type: GrantFiled: November 16, 1994Date of Patent: September 22, 1998Assignee: Hitachi, Ltd.Inventors: Masashi Tsuchida, Kazuo Masai, Shunichi Torii