公开(公告)号：US20060253435A1

公开(公告)日：2006-11-09

申请号：US11485272

申请日：2006-07-13

申请人： Itaru Nishizawa ,  Shinji Fujiwara ,  Kazutomo Ushijima ,  Shigekazu Inohara

发明人： Itaru Nishizawa ,  Shinji Fujiwara ,  Kazutomo Ushijima ,  Shigekazu Inohara

IPC分类号： G06F17/30

CPC分类号： G06F16/24524 ,  G06F16/25 ,  G06F16/27 ,  Y10S707/99952

摘要： In order to realize a practical data warehouse system with the use of a network in a distributed environment, for example, data collectors for creating/managing each replica of server data for clients shown in FIG. 1 are connected to a network. A data collector holds a data request condition given from a user via a client and negotiates with a server which supplies data according to such resources as a storage unit, a CPU, etc., usable by the data collector, thereby the range and quality of the data for which a replica is to be created can be adjusted. For query processing, a part or the whole of a query from a client is processed with the use of a replica created in the data collector. Queries which cannot be processed with any replica in the data collector are transferred to the server. Because a replica created in the data collector can be used to process a query from a client in such a way, the server load can be reduced.

摘要翻译： 为了在分布式环境中实现使用网络的实用数据仓库系统，例如，用于创建/管理图1所示的客户端的服务器数据的每个副本的数据收集器。 1连接到网络。 数据收集器通过客户端保存从用户发出的数据请求条件，并与根据数据收集器可使用的存储单元，CPU等资源提供数据的服务器进行协商，从而达到数据收集器的范围和质量 可以调整要创建副本的数据。 对于查询处理，使用在数据收集器中创建的副本来处理来自客户机的部分或全部查询。 无法用数据收集器中的任何副本处理的查询将传输到服务器。 由于在数据收集器中创建的副本可以用于以这种方式处理来自客户端的查询，所以可以减少服务器负载。

公开(公告)号：US07111019B1

公开(公告)日：2006-09-19

申请号：US09435034

申请日：1999-11-05

申请人： Itaru Nishizawa ,  Shinji Fujiwara ,  Kazutomo Ushijima ,  Shigekazu Inohara

发明人： Itaru Nishizawa ,  Shinji Fujiwara ,  Kazutomo Ushijima ,  Shigekazu Inohara

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

CPC分类号： G06F17/30433 ,  G06F17/30557 ,  G06F17/30575 ,  Y10S707/99952

摘要： In order to realize a practical data warehouse system with the use of a network in a distributed environment, for example, data collectors (101 and 102) for creating/managing each replica of server data for clients (103 and 104) as shown in FIG. 1 are connected to a network (113). A data collector holds a data request condition given from a user via a client and negotiates with a server (114, 122) which supplies data according to such resources as a storage unit, a CPU, etc. usable by the data collector, thereby the range and quality of the data for which a replica is to be created can be adjusted. For query processing, a part or the whole of a query from a client is processed with the use of a replica (123) created in the data collector. Queries which cannot be processed with any replica in the data collector are transferred to the server. Because a replica created in the data collector can be used to process a query from a client device such a way, the server load can be reduced.

摘要翻译： 为了在分布式环境中实现使用网络的实用数据仓库系统，例如，用于创建/管理客户机（103和104）的每个服务器数据副本的数据收集器（101和102），如图 。 1连接到网络（113）。 数据收集器保存从用户经由客户端给出的数据请求条件，并与根据数据收集器可用的诸如存储单元，CPU等的资源提供数据的服务器（114,122）进行协商，由此 可以调整要创建副本的数据的范围和质量。 对于查询处理，使用在数据收集器中创建的副本（123）来处理来自客户端的查询的一部分或全部。 无法用数据收集器中的任何副本处理的查询将传输到服务器。 由于在数据收集器中创建的副本可以用于以这种方式处理来自客户端设备的查询，所以可以减少服务器负载。

公开(公告)号：US06381601B1

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

申请号：US09469615

申请日：1999-12-22

申请人： Shinji Fujiwara ,  Kazutomo Ushijima ,  Itaru Nishizawa

发明人： Shinji Fujiwara ,  Kazutomo Ushijima ,  Itaru Nishizawa

IPC分类号： G06F1730

CPC分类号： G06F17/30489 ,  Y10S707/954 ,  Y10S707/99937

摘要： In order to realize high speed process for grouping the records having the identical values of one or more columns of the input list, the input list is canned, a hash value is generated using a hash function in which a value of the column as the non-vacant partial aggregation of the columns for the grouping is used as the argument, and it is determined whether two or more records having the hash values exist or not. The input list is scanned again and the calculating process of the aggregation columns is immediately executed for the records having the hash value for which it is determined by the first scanning that there is only one record having the identical hash value, the result of such calculating process is output and the records are defined as the input of the ordinary grouping process for the records which are determined to exist as the two or more records.

摘要翻译： 为了实现用于对具有输入列表的一个或多个列的相同值的记录进行分组的高速处理，输入列表被装入，使用散列函数生成哈希值，其中列的值为非 用于分组的列的消除性部分聚合用作参数，并且确定是否存在具有哈希值的两个或更多个记录。 再次对输入列表进行扫描，并且立即对具有通过第一次扫描确定的散列值的记录执行聚合列的计算处理，即只有一个具有相同散列值的记录，这样计算的结果 处理被输出，并且记录被定义为被确定作为两个或更多个记录存在的记录的普通分组处理的输入。

公开(公告)号：US5890150A

公开(公告)日：1999-03-30

申请号：US12207

申请日：1998-01-23

申请人： Kazutomo Ushijima ,  Shinji Fujiwara ,  Kazuo Masai ,  Yori Takahashi ,  Itaru Nishizawa

发明人： Kazutomo Ushijima ,  Shinji Fujiwara ,  Kazuo Masai ,  Yori Takahashi ,  Itaru Nishizawa

IPC分类号： G06F17/30

CPC分类号： G06F17/30536 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

摘要： 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. Reduction in the random access to the secondary storage device further enhances that efficiency.

摘要翻译： 提供了一种查询问题处理方法，查询转换处理方法和数据控制处理方法，用于提高在数据库处理系统中使用的随机抽样处理的效率。 在查询问题处理2中，发出包括随机抽样处理的查询。 在查询转换处理8中，通过考虑随机抽样处理的抽样单位来交换随机抽样处理和另一查询处理的应用程序。 此外，在记录控制处理4中，减少对二次存储装置的随机访问，从而提高随机抽样处理效率。 与不考虑采样单元的常规查询转换处理不同，通过考虑采样单元来执行随机抽样处理和执行查询转换的查询的发布允许随机抽样也适用于包括聚合处理的查询，从而提高查询的效率 在更广泛的范围。 减少对二次存储设备的随机访问进一步提高了该效率。

公开(公告)号：US07526509B2

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

申请号：US10991528

申请日：2004-11-19

申请人： Kazutomo Ushijima ,  Shinji Fujiwara

发明人： Kazutomo Ushijima ,  Shinji Fujiwara

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

CPC分类号： G06Q10/06

摘要： Even when information lifecycle management is applied to management object data of a database management system, inquiry service performance offered by the database management system can be guaranteed. Data arrangement managing system performs data arrangement settings in respect of management object data of the database management system and has a data arrangement setting creating module for determining possible data arrangement candidates and a data arrangement setting exchanging module for transferring the data arrangement candidates to the database management system. In the database management system, in respect of the individual data arrangement candidates transmitted to the database management system, execution profiles of service presupposing the candidates are created which are decided as to whether to satisfy a condition on database performance designated by a user and a narrowing down module narrows down the candidates to only data arrangement candidates satisfying the condition.

摘要翻译： 即使将信息生命周期管理应用于数据库管理系统的管理对象数据，也可以保证数据库管理系统提供的查询服务性能。 数据配置管理系统对数据库管理系统的管理对象数据执行数据排列设置，并具有用于确定可能的数据排列候选的数据排列设置创建模块和用于将数据排列候选转移到数据库管理的数据排列设置交换模块 系统。 在数据库管理系统中，针对发送到数据库管理系统的各个数据排列候补，创建预先考虑候选的服务的执行简档，其被确定为是否满足用户指定的数据库性能的条件和缩小 下降模块将候选者缩小到仅满足条件的数据排列候选者。

公开(公告)号：US08510316B2

公开(公告)日：2013-08-13

申请号：US12543826

申请日：2009-08-19

申请人： Akira Shimizu ,  Kazutomo Ushijima ,  Seisuke Tokuda ,  Michiko Tanaka ,  Shinji Fujiwara ,  Nobuo Kawamura

发明人： Akira Shimizu ,  Kazutomo Ushijima ,  Seisuke Tokuda ,  Michiko Tanaka ,  Shinji Fujiwara ,  Nobuo Kawamura

IPC分类号： G06F7/24

CPC分类号： G06F17/30454

摘要： Provided is a database system in which sorting of query results is sped up. The database system stores storage location information in which storage locations of the pieces of data are recorded in a given order. When there is no second task, which is executed based on data that is fetched in a first task, whether every piece of data requested in a third task, which is executed before the first task, has been fetched is determined. In the case where every piece of data requested in the third task has been fetched, data fetched in the first task is output. In the case where some of the data requested in the third task has not been fetched, data fetched in the first task is kept in a temporary buffer until every piece of data requested in the third task is fetched, and then output.

摘要翻译： 提供了一种数据库系统，其中查询结果的排序加快。 数据库系统存储以给定顺序记录数据段的存储位置的存储位置信息。 当不存在基于在第一任务中获取的数据而执行的第二任务时，确定在第一任务之前执行的第三任务中请求的每个数据片段是否已被获取。 在第三任务中请求的每个数据片段被取出的情况下，输出在第一任务中取出的数据。 在第三任务中请求的一些数据尚未获取的情况下，将第一任务中提取的数据保存在临时缓冲区中，直到第三个任务中请求的每个数据片段被提取，然后输出。

公开(公告)号：US20080163237A1

公开(公告)日：2008-07-03

申请号：US12071827

申请日：2008-02-27

申请人： Daisuke Ito ,  Kazutomo Ushijima ,  Frederico Buchholz Maciel ,  Shinji Fujiwara

发明人： Daisuke Ito ,  Kazutomo Ushijima ,  Frederico Buchholz Maciel ,  Shinji Fujiwara

IPC分类号： G06F9/46 ,  G06F7/06

CPC分类号： G06F17/30595 ,  Y10S707/99932 ,  Y10S707/99943

摘要： A shared-nothing database management system employs a method of adding and removing a database server without significantly affecting the processing performance for accessing a table from a user or an application. A scheduler module creates a schedule which separately handles the addition of a CPU resource and the addition of a storage I/O resource, and a server is added in accordance with the created schedule. A common disk is used to remove a disk at an arbitrary timing. Further, a data region is previously subdivided on the common disk to eliminate a movement of data associated with the addition of a server.

摘要翻译： 无共享数据库管理系统采用添加和删除数据库服务器的方法，而不会显着影响从用户或应用程序访问表的处理性能。 调度器模块创建分别处理CPU资源的添加和添加存储I / O资源的调度，并且根据创建的调度添加服务器。 常用磁盘用于在任意时刻删除磁盘。 此外，数据区域先前细分在公共盘上以消除与添加服务器相关联的数据的移动。

公开(公告)号：US07167854B2

公开(公告)日：2007-01-23

申请号：US10835055

申请日：2004-04-30

申请人： Frederico Buchholz Maciel ,  Daisuke Ito ,  Kazutomo Ushijima ,  Shinji Fujiwara

发明人： Frederico Buchholz Maciel ,  Daisuke Ito ,  Kazutomo Ushijima ,  Shinji Fujiwara

IPC分类号： G06F17/30

CPC分类号： G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99938

摘要： The present invention aims to dynamically re-configure hosts and storage in a shared-nothing database. In the shared-nothing database, processes 24 to 29 executed in the hosts 11 to 14 access data of a storage device 30. A system manager 70 and a database manager 10 manage the hosts 11 to 14 and the storage device 30. The processes 24 to 29 access one or more disks 51 to 54 of the storage device. To add or reduce the number of the hosts, the processes 24 to 29 are reassigned among the hosts 11 to 14.

摘要翻译： 本发明旨在在无共享数据库中动态地重新配置主机和存储。 在无共享数据库中，在主机11〜14中执行的处理24〜29访问存储装置30的数据。 系统管理器70和数据库管理器10管理主机11至14和存储设备30。 处理24至29访问存储设备的一个或多个盘51至54。 为了增加或减少主机数量，进程24到29在主机11到14之间重新分配。

公开(公告)号：US08296286B2

公开(公告)日：2012-10-23

申请号：US12712662

申请日：2010-02-25

申请人： Michiko Tanaka ,  Kazutomo Ushijima ,  Akira Shimizu ,  Seisuke Tokuda ,  Shinji Fujiwara ,  Nobuo Kawamura

发明人： Michiko Tanaka ,  Kazutomo Ushijima ,  Akira Shimizu ,  Seisuke Tokuda ,  Shinji Fujiwara ,  Nobuo Kawamura

IPC分类号： G06F17/30

CPC分类号： G06F17/30306

摘要： Provided is a database processing system including: a computer for outputting data in response to a received query request; and a storage system including a storage device for storing the data, in which: the storage device stores a plurality of partial indices indicating a storage location of the data; the data stored in the storage device is grouped; and the computer is configured to: receive the query request for the data; acquire one of the plurality of partial indices; specify, based on the query request for the data and the acquired one of the plurality of partial indices, a location at which the requested data is stored; and send a request to acquire the data stored at the specified location to the storage system. Accordingly, in the database processing system, a time period necessary to input and output the data is shortened.

摘要翻译： 提供了一种数据库处理系统，包括：计算机，用于响应于接收的查询请求输出数据; 以及存储系统，包括用于存储数据的存储装置，其中：所述存储装置存储指示所述数据的存储位置的多个部分索引; 存储在存储设备中的数据被分组; 并且计算机被配置为：接收对数据的查询请求; 获取所述多个部分索引中的一个; 基于所述数据的查询请求和所述多个部分索引中获取的一个部分索引，指定存储所请求的数据的位置; 并发送请求以将存储在指定位置的数据存储到存储系统。 因此，在数据库处理系统中，输入和输出数据所需的时间段被缩短。

公开(公告)号：US20120151138A1

公开(公告)日：2012-06-14

申请号：US13389893

申请日：2010-08-10

申请人： Seisuke Tokuda ,  Kazutomo Ushijima ,  Akira Shimizu ,  Michiko Tanaka ,  Shinji Fujiwara ,  Nobuo Kawamura

发明人： Seisuke Tokuda ,  Kazutomo Ushijima ,  Akira Shimizu ,  Michiko Tanaka ,  Shinji Fujiwara ,  Nobuo Kawamura

IPC分类号： G06F12/00

CPC分类号： G06F3/0665 ,  G06F3/061 ,  G06F3/064 ,  G06F3/0689

摘要： According to this invention, a data arrangement method, the computer connected to a storage system which provides a plurality of logical storage devices comprising a plurality of physical storage devices arranges data in a logical storage volume constructed by integrating the plurality of logical storage devices. The method includes: a step wherein the computer receives an instruction to build the logical storage volume using the plurality of logical storage devices or to rebuild the constructed logical storage volume; a step wherein the computer obtains information about the plurality of physical storage devices constituting each of the plurality of logical storage devices included in the received instruction; and a step wherein the arrangement position of data into the logical storage volume is determined on the basis of the obtained information about the plurality of physical storage devices.

摘要翻译： 根据本发明，一种数据配置方法，连接到存储系统的计算机，其提供包括多个物理存储装置的多个逻辑存储装置，将数据排列在通过集成多个逻辑存储装置构成的逻辑存储卷中。 该方法包括：一个步骤，其中计算机接收使用多个逻辑存储设备构建逻辑存储卷的指令或重建构造的逻辑存储卷; 计算机获取构成接收到的指令中包含的多个逻辑存储装置中的每一个的多个物理存储装置的信息的步骤; 以及基于获得的关于多个物理存储设备的信息来确定数据到逻辑存储卷中的布置位置的步骤。