公开(公告)号：US20060161539A1

公开(公告)日：2006-07-20

申请号：US11302174

申请日：2005-12-14

申请人： Masaaki Narita ,  Nobuo Kawamura ,  Kiyomi Hirohata ,  Ryuichi Hoshino

发明人： Masaaki Narita ,  Nobuo Kawamura ,  Kiyomi Hirohata ,  Ryuichi Hoshino

IPC分类号： G06F17/30

CPC分类号： G06F17/30575 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99953

摘要： Database processing including processing for a shared table is efficiently executed. Processing for a database including a shared table which can be referred to by a plurality of database processing devices is managed. Table information indicating database processing devices allocated according to an attribute of a table in a database and a processing type is referred to via a storage. According to whether or not a processing request for the database includes processing for a shared table, a database processing device to execute the processing request is selected. The database processing request is issued to the selected database processing. According to the database processing request, the database processing deviceaccesses the database.

摘要翻译： 包括对共享表的处理的数据库处理被有效地执行。 管理包括可由多个数据库处理装置参照的共享表的数据库的处理。 根据数据库中的表的属性和处理类型分配的指示数据库处理装置的表信息经由存储器被引用。 根据对数据库的处理请求是否包括对共享表的处理，选择执行处理请求的数据库处理装置。 数据库处理请求被发布到所选择的数据库处理。 根据数据库处理请求，数据库处理设备访问数据库。

公开(公告)号：US07526469B2

公开(公告)日：2009-04-28

申请号：US11302174

申请日：2005-12-14

申请人： Masaaki Narita ,  Nobuo Kawamura ,  Kiyomi Hirohata ,  Ryuichi Hoshino

发明人： Masaaki Narita ,  Nobuo Kawamura ,  Kiyomi Hirohata ,  Ryuichi Hoshino

IPC分类号： G06F17/30

CPC分类号： G06F17/30575 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99953

摘要： Database processing including processing for a shared table is efficiently executed. Processing for a database including a shared table which can be referred to by a plurality of database processing devices is managed. Table information indicating database processing devices allocated according to an attribute of a table in a database and a processing type is referred to via a storage. According to whether or not a processing request for the database includes processing for a shared table, a database processing device to execute the processing request is selected. The database processing request is issued to the selected database processing. According to the database processing request, the database processing device accesses the database.

摘要翻译： 包括对共享表的处理的数据库处理被有效地执行。 管理包括可由多个数据库处理装置参照的共享表的数据库的处理。 根据数据库中的表的属性和处理类型分配的指示数据库处理装置的表信息经由存储器被引用。 根据对数据库的处理请求是否包括对共享表的处理，选择执行处理请求的数据库处理装置。 数据库处理请求被发布到所选择的数据库处理。 根据数据库处理请求，数据库处理设备访问数据库。

公开(公告)号：US06427145B1

公开(公告)日：2002-07-30

申请号：US09516778

申请日：2000-03-01

申请人： Norihiro Hara ,  Nobuo Kawamura ,  Tomohiro Nakayama ,  Kiyomi Hirohata

发明人： Norihiro Hara ,  Nobuo Kawamura ,  Tomohiro Nakayama ,  Kiyomi Hirohata

IPC分类号： G06F1730

CPC分类号： G06F17/30463 ,  G06F17/30312 ,  G06F17/30483 ,  G06F17/30492 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99937

摘要： A database processing system for analyzing a query issued to a database to generate a corresponding execution procedure for performing database processing in accordance therewith. A plurality of columns for storing data each constituted by a set of instances and conditions concerning the instances constituting the plurality of columns are entered. A query is inputted which contains a predicate for evaluating whether a set of instances which meet the designated conditions and which can be identified with the same subscript exists among the sets of instances stored in the plurality of columns. In response to the query, a decision is made as to whether or not an index has been generated for one or plural columns specified in the query predicate. When the index is generated, the index is accessed to acquire an identifier of table data which is “true” for a predicate. Unless the index is generated, a decision is then made as to whether or not column data acquired by accessing the database meet the conditions specified in the predicate contained in the query.

摘要翻译： 一种数据库处理系统，用于分析发给数据库的查询，以生成相应的执行过程，用于执行数据库处理。 输入用于存储数据的多个列，每个列由关于构成多个列的实例的一组实例和条件构成。 输入查询，该查询包含用于评估在多个列中存储的实例组中是否存在满足指定条件并且可以被标识具有相同下标的一组实例的谓词。 响应于该查询，作出关于是否已经在查询谓词中指定的一个或多个列生成了索引的决定。 当生成索引时，访问索引以获取对于谓词为“true”的表数据的标识符。 除非生成索引，否则决定是否通过访问数据库获取的列数据满足查询中包含的谓词中指定的条件。

公开(公告)号：US06675160B2

公开(公告)日：2004-01-06

申请号：US10167435

申请日：2002-06-13

申请人： Norihiro Hara ,  Nobuo Kawamura ,  Tomohiro Nakayama ,  Kiyomi Hirohata

发明人： Norihiro Hara ,  Nobuo Kawamura ,  Tomohiro Nakayama ,  Kiyomi Hirohata

IPC分类号： G06F1730

CPC分类号： G06F17/30463 ,  G06F17/30312 ,  G06F17/30483 ,  G06F17/30492 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99937

摘要： A database processing system for analyzing a query issued to a database to generate a corresponding execution procedure for performing database processing in accordance therewith. A plurality of columns for storing data each constituted by a set of instances and conditions concerning the instances constituting the plurality of columns are entered. A query is inputted which contains a predicate for evaluating whether a set of instances which meet the designated conditions and which can be identified with the same subscript exists among the sets of instances stored in the plurality of columns. In response to the query, a decision is made as to whether or not an index has been generated for one or plural columns specified in the query predicate. When the index is generated, the index is accessed to acquire an identifier of table data which is “true” for a predicate. Unless the index is generated, a decision is then made as to whether or not column data acquired by accessing the database meet the conditions specified in the predicate contained in the query.

摘要翻译： 一种数据库处理系统，用于分析发给数据库的查询，以生成相应的执行过程，用于执行数据库处理。 输入用于存储数据的多个列，每个列由关于构成多个列的实例的一组实例和条件构成。 输入查询，该查询包含用于评估在多个列中存储的实例组中是否存在满足指定条件并且可以被标识具有相同下标的一组实例的谓词。 响应于该查询，作出关于是否已经在查询谓词中指定的一个或多个列生成了索引的决定。 当生成索引时，访问索引以获取对于谓词为“true”的表数据的标识符。 除非生成索引，否则就决定通过访问数据库获取的列数据是否满足查询中包含的谓词中指定的条件。

公开(公告)号：US06745191B2

公开(公告)日：2004-06-01

申请号：US10424720

申请日：2003-04-29

申请人： Hideaki Kasao ,  Keisuke Toda ,  Kota Yamaguchi ,  Kazuo Masai ,  Kiyomi Hirohata

发明人： Hideaki Kasao ,  Keisuke Toda ,  Kota Yamaguchi ,  Kazuo Masai ,  Kiyomi Hirohata

IPC分类号： G06F1730

CPC分类号： G06F17/30445 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99937 ,  Y10S707/99944 ,  Y10S707/99945

摘要： 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.

摘要翻译： 公开了一种具有划分为多​​个外部存储器单元的数据库的并行数据库管理系统。 控制CPU在接收到访问数据库的请求时，决定访问请求是存储还是搜索记录。 对于记录存储请求，控制CPU使用散列函数确定外部存储单元来存储记录。 另一方面，在记录搜索请求的情况下，并行地搜索所有外部存储器单元，而不使用散列函数从而获得所需的记录。 添加外部存储单元后，哈希函数会被更改。

公开(公告)号：US06925462B2

公开(公告)日：2005-08-02

申请号：US10041577

申请日：2002-01-10

申请人： Norifumi Nishikawa ,  Shigekazu Inohara ,  Koichi Shimazaki ,  Kiyomi Hirohata ,  Kohsaku Yamahira ,  Shigetoshi Hayashi

发明人： Norifumi Nishikawa ,  Shigekazu Inohara ,  Koichi Shimazaki ,  Kiyomi Hirohata ,  Kohsaku Yamahira ,  Shigetoshi Hayashi

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30557 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933

摘要： The present invention relates to an optimization method in a database management system having the function of accessing external databases. Conventionally, whether functions contained in a query can be executed in external databases depends on a database management system having the functions, and therefore there has been a problem in that a database utilization method cannot apply to query optimization and query execution performance is reduced. To solve the above problem, a database management system having the function of accessing external databases is provided with an optimization step comprising the steps of: obtaining specification about whether to execute functions in a query in external databases; determining whether data referred to in a query is confined to one database; and determining whether a user specifies that the functions in the query are executed in external databases.

摘要翻译： 本发明涉及具有访问外部数据库的功能的数据库管理系统中的优化方法。 通常，查询中包含的功能是否能够在外部数据库中执行取决于具有该功能的数据库管理系统，因此存在数据库利用方法不能应用于查询优化并且查询执行性能降低的问题。 为了解决上述问题，提供了具有访问外部数据库的功能的数据库管理系统，其优化步骤包括以下步骤：获取关于是否在外部数据库中执行查询中的功能的规范; 确定查询中引用的数据是否限于一个数据库; 以及确定用户是否指定在外部数据库中执行查询中的功能。

公开(公告)号：US06584457B1

公开(公告)日：2003-06-24

申请号：US09662911

申请日：2000-09-15

申请人： Hideaki Kasao ,  Keisuke Toda ,  Kota Yamaguchi ,  Kazuo Masai ,  Kiyomi Hirohata

发明人： Hideaki Kasao ,  Keisuke Toda ,  Kota Yamaguchi ,  Kazuo Masai ,  Kiyomi Hirohata

IPC分类号： G06F1730

CPC分类号： G06F17/30445 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99937 ,  Y10S707/99944 ,  Y10S707/99945

摘要： 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.

摘要翻译： 公开了一种具有划分为多​​个外部存储器单元的数据库的并行数据库管理系统。 控制CPU在接收到访问数据库的请求时，决定访问请求是存储还是搜索记录。 对于记录存储请求，控制CPU使用散列函数确定外部存储单元来存储记录。 另一方面，在记录搜索请求的情况下，并行地搜索所有外部存储器单元，而不使用散列函数从而获得所需的记录。 添加外部存储单元后，哈希函数会被更改。

公开(公告)号：US06169982A

公开(公告)日：2001-01-02

申请号：US09292606

申请日：1999-04-15

申请人： Hideaki Kasao ,  Keisuke Toda ,  Kota Yamaguchi ,  Kazuo Masai ,  Kiyomi Hirohata

发明人： Hideaki Kasao ,  Keisuke Toda ,  Kota Yamaguchi ,  Kazuo Masai ,  Kiyomi Hirohata

IPC分类号： G06F1730

CPC分类号： G06F17/30445 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99937 ,  Y10S707/99944 ,  Y10S707/99945

摘要： 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.

摘要翻译： 公开了一种具有划分为多​​个外部存储器单元的数据库的并行数据库管理系统。 控制CPU在接收到访问数据库的请求时，决定访问请求是存储还是搜索记录。 对于记录存储请求，控制CPU使用散列函数确定外部存储单元来存储记录。 另一方面，在记录搜索请求的情况下，并行地搜索所有外部存储器单元，而不使用散列函数从而获得所需的记录。 添加外部存储单元后，哈希函数会被更改。

公开(公告)号：US5987462A

公开(公告)日：1999-11-16

申请号：US840643

申请日：1997-04-25

申请人： Hideaki Kasao ,  Keisuke Toda ,  Kota Yamaguchi ,  Kazuo Masai ,  Kiyomi Hirohata

发明人： Hideaki Kasao ,  Keisuke Toda ,  Kota Yamaguchi ,  Kazuo Masai ,  Kiyomi Hirohata

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30445 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99937 ,  Y10S707/99944 ,  Y10S707/99945

摘要： 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.