专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08209697B2 Resource allocation method for a physical computer used by a back end server including calculating database resource cost based on SQL process type 有权
标题翻译：后端服务器使用的物理计算机的资源分配方法，包括基于SQL进程类型计算数据库资源成本
公开(公告)号：US08209697B2
公开(公告)日：2012-06-26
申请号：US12022547
申请日：2008-01-30
申请人： Kazuhito Kobayashi , Masaaki Narita , Akira Ito , Sansei Ooshima , Norihiro Hara
发明人： Kazuhito Kobayashi , Masaaki Narita , Akira Ito , Sansei Ooshima , Norihiro Hara
IPC分类号： G06F9/50
CPC分类号： G06F9/5077 , G06F17/30445
摘要： A resource allocation method, a resource allocation program, and a resource allocation apparatus in which a request reception server subjects an inputted SQL to a syntax analysis. At least one SQL process is extracted from the input SQL, and a resource cost of a database required by a BES (Back End Server) to perform the SQL process for each of one or more process types contained in the SQL process is calculated. Further, an allocation ratio is determined for allocating the resource of a request executing server to a virtualized server in accordance with a resource cost ratio required by each of the BES to execute the SQL process. Additionally, requests are made for execution of the respective BES on the virtualized server to which the resource has been allocated so as to execute the SQL process.
摘要翻译：一种资源分配方法，资源分配程序和资源分配装置，其中请求接收服务器将输入的SQL进行语法分析。从输入SQL中提取至少一个SQL进程，并计算BES（后端服务器）为SQL过程中包含的一个或多个进程类型中的每一个执行SQL进程所需的数据库的资源成本。此外，根据用于执行SQL处理的BES中的每一个所需的资源成本比，确定分配比率以将请求执行服务器的资源分配给虚拟化服务器。此外，还要求在分配资源的虚拟化服务器上执行相应的BES，以便执行SQL进程。

2. 发明申请

US20090013325A1 RESOURCE ALLOCATION METHOD, RESOURCE ALLOCATION PROGRAM AND RESOURCE ALLOCATION APPARATUS 有权
标题翻译：资源分配方法，资源分配方案和资源分配装置
公开(公告)号：US20090013325A1
公开(公告)日：2009-01-08
申请号：US12022547
申请日：2008-01-30
申请人： Kazuhito KOBAYASHI , Masaaki Narita , Akira Ito , Sansei Ooshima , Norihiro Hara
发明人： Kazuhito KOBAYASHI , Masaaki Narita , Akira Ito , Sansei Ooshima , Norihiro Hara
IPC分类号： G06F9/46
CPC分类号： G06F9/5077 , G06F17/30445
摘要： A resource allocation method, a resource allocation program, and a resource allocation apparatus in which a request reception server subjects an inputted SQL to a syntax analysis, extracts at least one SQL process from the SQL, calculates a resource cost of a database required by the BES to perform the SQL process for each of process types contained in the SQL process, decides an allocation ratio for allocating the resource of a request executing server to a virtualized server in accordance with a resource cost ratio required by each of the BES to execute the SQL process, and requests for execution of the respective BES on the virtualized server to which the resource has been allocated so as to execute the SQL process.
摘要翻译：一种资源分配方法，资源分配程序和资源分配装置，其中请求接收服务器将输入的SQL对象进行语法分析，从SQL中提取至少一个SQL进程，计算数据库所需的资源成本 BES为SQL进程中包含的每个进程类型执行SQL进程，根据每个BES所需的资源成本比决定用于将请求执行服务器的资源分配给虚拟化服务器的分配比率，以执行 SQL进程，以及在分配资源的虚拟化服务器上执行相应BES的请求，以执行SQL进程。

3. 发明授权

US08595728B2 System for judging an execution status of batch processing, and based on judgement result to send post-update data to terminal device 失效
标题翻译：用于判断批量处理的执行状态的系统，并且基于将更新后数据发送到终端设备的判断结果
公开(公告)号：US08595728B2
公开(公告)日：2013-11-26
申请号：US12714243
申请日：2010-02-26
申请人： Shinsuke Hamada , Norihiro Hara , Yasuhiro Tahara
发明人： Shinsuke Hamada , Norihiro Hara , Yasuhiro Tahara
IPC分类号： G06F9/46 , G06F17/30
CPC分类号： G06F9/52
摘要： An execution system executes an update batch according to an update batch execution request from a terminal device and gives a batch execution command to each standby system. Each system stores the content of updated data in its update buffer; and subject to termination of the update batch by each system, the post-update data content is reflected in a database. While the above processing is performed, the execution system and the standby systems accept a reference request from the terminal device; and in a case of “batch not executed” or “batch in execution”, each system searches the database and then returns the pre-update data content to the terminal device; and in a case of “update content being reflected”, each system searches the database or the update buffer and then returns the post-update data content to the terminal device.
摘要翻译：执行系统根据来自终端设备的更新批处理执行请求执行更新批处理，并向每个备用系统发出批处理执行命令。每个系统将更新数据的内容存储在其更新缓冲区中; 并且由每个系统终止更新批次，则更新后数据内容被反映在数据库中。在执行上述处理的同时，执行系统和备用系统接受来自终端装置的参照请求; 在“批次未执行”或“批处理”的情况下，每个系统搜索数据库，然后将更新前的数据内容返回给终端设备; 在“更新内容被反映”的情况下，每个系统搜索数据库或更新缓冲器，然后将更新后的数据内容返回给终端设备。

4. 发明授权

US08195777B2 System and method for adding a standby computer into clustered computer system 有权
标题翻译：将备用计算机添加到群集计算机系统中的系统和方法
公开(公告)号：US08195777B2
公开(公告)日：2012-06-05
申请号：US12071774
申请日：2008-02-26
申请人： Tomohiro Hanai , Norihiro Hara , Tsunehiko Baba
发明人： Tomohiro Hanai , Norihiro Hara , Tsunehiko Baba
IPC分类号： G06F15/177
CPC分类号： G06F15/16
摘要： There is provided a method of adding a new computer as a standby computer to a computer system that includes an active computer for performing service processing and a standby computer for storing replica of data stored in the active computer. The replica of the data stored in the standby computer is updated when the data stored in the active computer is updated. The method comprising the steps of: selecting the standby computer from the computer system; transferring the replica of the data stored in the selected standby computer to the new computer; and transferring update information on data updated in the active computer after the transferring the replica of the data is started, to the new computer.
摘要翻译：提供了一种将新计算机作为备用计算机添加到包括用于执行服务处理的活动计算机和用于存储存储在活动计算机中的数据的备用计算机的计算机系统的方法。当更新存储在活动计算机中的数据时，更新存储在备用计算机中的数据的副本。该方法包括以下步骤：从计算机系统中选择备用计算机; 将存储在所选待机计算机中的数据的副本传送到新计算机; 并且在将数据的副本传送到新的计算机之后，传送关于在活动计算机中更新的数据的更新信息。

5. 发明授权

US07536422B2 Method for process substitution on a database management system 失效
标题翻译：数据库管理系统上的进程替换方法
公开(公告)号：US07536422B2
公开(公告)日：2009-05-19
申请号：US11037134
申请日：2005-01-19
申请人： Masataka Kan , Norihiro Hara , Katsushi Yako , Tetsuya Suzuki , Keisuke Matsubara , Tooru Kawashima , Masami Hikawa , Yoshihide Sato
发明人： Masataka Kan , Norihiro Hara , Katsushi Yako , Tetsuya Suzuki , Keisuke Matsubara , Tooru Kawashima , Masami Hikawa , Yoshihide Sato
IPC分类号： G06F17/30
CPC分类号： G06F17/30575 , Y10S707/99953
摘要： In a database management system using a shared-nothing architecture and adopting a system takeover in a DB storage area unit, correspondence information is provided which indicates a relation between a DB storage area and a DB processing server in charge of an access to the DB storage area, when a takeover occurs to some DB storage area, the correspondence information is changed in such a manner that an access process to the DB storage area is made in charge of another running DB processing server, and when some DB storage area is accessed in response to an inquiry request from a user, a DB processing server as an access request destination is determined by referring to the correspondence information.
摘要翻译：在使用无共享架构并在DB存储区域单元中采用系统接管的数据库管理系统中，提供了指示DB存储区域和负责对DB存储器的访问的DB处理服务器之间的关系的对应信息区域，当对一些DB存储区域进行接管时，对应信息被改变为对DB存储区域进行访问处理以负责另一个正在执行的DB处理服务器，并且当一些DB存储区域被访问时通过参照对应信息来确定来自用户的查询请求的响应，作为访问请求目的地的DB处理服务器。

6. 发明申请

US20080301161A1 Method and system for data processing with high availability 有权
公开(公告)号：US20080301161A1
公开(公告)日：2008-12-04
申请号：US12216269
申请日：2008-07-02
申请人： Katsushi Yako , Norihiro Hara , Tooru Kawashima , Masami Hikawa
发明人： Katsushi Yako , Norihiro Hara , Tooru Kawashima , Masami Hikawa
IPC分类号： G06F7/00
CPC分类号： G06F11/2048 , G06F11/1658 , G06F11/2033 , G06F11/2035
摘要： A server to be changed is added to a destination unit in terms of configuration. The server to be changed is started to restore the database in the database storage region to which the server has access and to restore the transaction for the process that was executed when the server failed. The destination of the failed server (a system destination unit) when failure occurs is determined to stabilize the throughput of the entire system after the switchover of the system in the event of failure. The destination server is determined according to an instruction given in advance by the user. The database management system statistically determines the destination server in accordance with a policy designated by the user. Alternatively, the database management system dynamically determines the destination server according to the policy designated by the user when failure occurs.

7. 发明申请

US20070226179A1 Querying database system to execute stored procedures using abstract data type attributes, retrieving location information of data, sub-data between first and second servers 审中-公开
公开(公告)号：US20070226179A1
公开(公告)日：2007-09-27
申请号：US11730242
申请日：2007-03-30
申请人： Morihiro Iwata , Masashi Tsuchida , Yukio Nakano , Norihiro Hara
发明人： Morihiro Iwata , Masashi Tsuchida , Yukio Nakano , Norihiro Hara
IPC分类号： G06F17/30
CPC分类号： G06F16/2438 , G06F16/2443 , G06F16/24561 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945
摘要： A parallel database system retrieval method and system for transferring from database operation servers to a front end server only those data items that are used in subsequent processing, thereby shortening the query time when the unused data are massive. The invention allows an initial retrieval query to transfer only location information about the target data from a database operation server to the front end server. Using the location information the invention permits a subsequent query to get variable-bound location information so that the latter query will retrieve a desired sub-data item according to the acquired location information and dictionary information about the sub-data item locations within the data.

8. 发明申请

US20050283493A1 Querying database system to execute stored procedures using abstract data type attributes, retrieving location information of data, sub-data between first and second servers 失效
标题翻译：查询数据库系统使用抽象数据类型属性执行存储过程，检索数据的位置信息，第一和第二服务器之间的子数据
公开(公告)号：US20050283493A1
公开(公告)日：2005-12-22
申请号：US11208533
申请日：2005-08-23
申请人： Morihiro Iwata , Masahi Tsuchida , Yukio Nakano , Norihiro Hara
发明人： Morihiro Iwata , Masahi Tsuchida , Yukio Nakano , Norihiro Hara
IPC分类号： G06F12/00 , G06F7/00 , G06F17/30
CPC分类号： G06F17/30415 , G06F17/3041 , G06F17/30501 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945
摘要： A parallel database system retrieval method and system for transferring from database operation servers to a front end server only those data items that are used in subsequent processing, thereby shortening the query time when the unused data are massive. The invention allows an initial retrieval query to transfer only location information about the target data from a database operation server to the front end server. Using the location information the invention permits a subsequent query to get variable-bound location information so that the latter query will retrieve a desired sub-data item according to the acquired location information and dictionary information about the sub-data item locations within the data.
摘要翻译：一种并行数据库系统检索方法和系统，用于从数据库操作服务器向前端服务器传输仅在后续处理中使用的数据项，从而缩短了未使用数据量大时的查询时间。本发明允许初始检索查询仅将关于目标数据的位置信息从数据库操作服务器传送到前端服务器。使用位置信息，本发明允许随后的查询获得可变约束的位置信息，使得后一查询将根据所获取的位置信息和关于数据内的子数据项位置的字典信息来检索期望的子数据项。

9. 发明授权

US06349305B1 Method and system for database processing by invoking a function related to index type definition, generating an execution plan based on index type name 有权
标题翻译：通过调用与索引类型定义相关的功能进行数据库处理的方法和系统，根据索引类型名称生成执行计划
公开(公告)号：US06349305B1
公开(公告)日：2002-02-19
申请号：US09715120
申请日：2000-11-20
申请人： Norihiro Hara , Nobuo Kawamura , Shunichi Torii , Yoshito Kamegi
发明人： Norihiro Hara , Nobuo Kawamura , Shunichi Torii , Yoshito Kamegi
IPC分类号： G06F1730
CPC分类号： G06F17/30342 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936 , Y10S707/99942 , Y10S707/99943 , Y10S707/99944
摘要： A method and a system for executing a general database processing independent of a specific user-defined function are provided. In an implementation method, index definition information for setting a specific user-defined function in correspondence to a specific index which is used to carry out an index access to data in a database region is created, and module definition information for setting the specific index which is used to carry out the index access to the data in the database region in correspondence to an implementation module for subjecting the data in the database region to a specific processing is created. When it is determined in response to a processing request for the database issued from an end user, that the user-defined function contained therein is set in correspondence to the specific index on the basis of the index definition information, a specific implementation module for carrying out an access using the specific index is selected from the module definition information, and a database processing is performed using the implementation module thus selected.
摘要翻译：提供了用于执行独立于特定用户定义功能的一般数据库处理的方法和系统。在实现方法中，创建用于根据用于对数据库区域中的数据进行索引访问的特定索引来设置特定用户定义函数的索引定义信息，以及用于设置特定索引的模块定义信息用于对与数据库区域中的数据进行特定处理的实现模块相对应地执行对数据库区域中的数据的索引访问。当响应于从最终用户发出的对数据库的处理请求而确定，根据索引定义信息将其中包含的用户定义功能与特定索引相对应地设置时，用于承载的特定实现模块从模块定义信息中选择使用特定索引的访问，并且使用由此选择的实现模块执行数据库处理。

10. 发明授权

US5758356A High concurrency and recoverable B-tree index management method and system 失效
标题翻译：高并发和可恢复的B树索引管理方法和系统
公开(公告)号：US5758356A
公开(公告)日：1998-05-26
申请号：US527224
申请日：1995-09-12
申请人： Norihiro Hara , Nobuo Kawamura , Junichiro Soshiki
发明人： Norihiro Hara , Nobuo Kawamura , Junichiro Soshiki
IPC分类号： G06F12/00 , G06F17/30 , G06F7/00
CPC分类号： G06F17/30327 , G06F17/30362 , Y10S707/956 , Y10S707/99932 , Y10S707/99933 , Y10S707/99938 , Y10S707/99939 , Y10S707/99952 , Y10S707/99953
摘要： A database management system for accessing the same B-tree index by a plurality of transactions. When a transaction is intercepted at the intermediate stage of an index structure modification process executed by an index structure modification execution unit, the logs of the index structure modification operation at rollback is analyzed by an index structure modification operation log analysis unit. Then, an incomplete index structure change process is completed by an uncompleted index structure modification operation completion and control unit, i.e., the roll-forward operation is performed. In this manner, it is possible to provide an efficient access to the B-tree index wherein even if the tree structure modification operation by one transaction is intercepted at its intermediate stage, another transaction is allowed to access the B-tree index thereafter.
摘要翻译：一种用于通过多个事务访问相同B树索引的数据库管理系统。当在由索引结构修改执行单元执行的索引结构修改处理的中间阶段拦截事务时，通过索引结构修改操作对数分析单元来分析回滚时的索引结构修改操作的日志。然后，通过未完成的索引结构修改操作完成和控制单元完成不完整的索引结构改变处理，即执行前滚操作。以这种方式，可以提供对B树索引的有效访问，其中即使在其中间阶段截取了一个事务的树结构修改操作，则允许另一事务在其后访问B树索引。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式