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

1. 发明专利

JP2007065978A Computer system and database management system program 有权
标题翻译：计算机系统和数据库管理系统程序
公开(公告)号：JP2007065978A
公开(公告)日：2007-03-15
申请号：JP2005251111
申请日：2005-08-31
申请人： Hitachi Ltd , Univ Of Tokyo , 国立大学法人東京大学 , 株式会社日立製作所
发明人： KIREGAWA MASARU , MOGI KAZUHIKO , NISHIKAWA NORIFUMI , IDEI HIDEOMI , KAWAMURA NOBUO
IPC分类号： G06F12/00
摘要： PROBLEM TO BE SOLVED: To reduce necessary memory quantity when operating a look-ahead function on a computer where a DBMS is operating. SOLUTION: This computer system includes a computer for storing a database management system program in a memory, and a storage device for storing data. The computer is provided with: a shared DB data management part for assigning a buffer on the memory, and for managing the buffer, a data processing part for acquiring the requested data; and a look-ahead part for operating the look-ahead of the data by referring to the data stored in the buffer. The shared DB data management part is characterized in that the data in the buffer is locked when the data are acquired by the data processing part. COPYRIGHT: (C)2007,JPO&INPIT
摘要翻译：要解决的问题：在DBMS运行的计算机上运行预览功能时，减少必要的存储量。解决方案：该计算机系统包括用于在存储器中存储数据库管理系统程序的计算机和用于存储数据的存储装置。计算机具有：共享DB数据管理部分，用于在存储器上分配缓冲器，并用于管理缓冲器;数据处理部分，用于获取所请求的数据; 以及用于通过参考存储在缓冲器中的数据来操作数据的前视的预览部分。共享DB数据管理部分的特征在于，当数据被数据处理部分获取时，缓冲器中的数据被锁定。版权所有（C）2007，JPO＆INPIT

2. 发明专利

JP2006004147A Disaster recovery system, program and method for recovering database 有权
标题翻译：灾难恢复系统，恢复数据库的程序和方法
公开(公告)号：JP2006004147A
公开(公告)日：2006-01-05
申请号：JP2004179433
申请日：2004-06-17
申请人： Hitachi Ltd , Univ Of Tokyo , 国立大学法人東京大学 , 株式会社日立製作所
发明人： SUZUKI YOSHIO , KAWAMURA NOBUO , YAMAGUCHI KOTA , FUJIWARA SHINJI , WATANABE SATOSHI , KIREGAWA MASARU
IPC分类号： G06F12/00 , G06F3/06
CPC分类号： G06F11/2028 , G06F11/2025 , G06F11/2097
摘要： PROBLEM TO BE SOLVED: To reduce an operation management cost in a usual mode while maintaining the recovery of a deficit-free database and the online performance of a site. SOLUTION: A first system is comprised of a main storage 103 storing a DB (Data Base) 107 and a main computer 100 running a main DBMS (Data Base Management System) 101 providing the DB. A second system includes a sub storage 113 receiving the copy of a log indicative of the update difference of the DB 107 from the main storage 103 and storing a sub-DB 117, and a subset 500 recovering the sub-DB 117 based on the log copied from the main storage 103. When the first system fails, the first system is switched to the second system, and a second computer 110 operating a second DBMS 111 is added to the second system. Then, the second computer 110 takes over the sub-DB 117 recovered or under recovery in the subset 500. COPYRIGHT: (C)2006,JPO&NCIPI
摘要翻译：要解决的问题：在保持无赤字数据库的恢复和站点的在线性能的同时，降低通常模式下的操作管理成本。解决方案：第一系统包括存储DB（数据库）107的主存储器103和运行提供DB的主DBMS（数据库管理系统）101的主计算机100。第二系统包括子存储器113，其接收指示DB 107与主存储器103的更新差异并存储子DB 117的日志的副本，以及基于日志恢复子DB 117的子集500 复制自主存储器103.当第一系统发生故障时，第一系统被切换到第二系统，并且将操作第二DBMS 111的第二计算机110添加到第二系统。然后，第二计算机110接管在子集500中恢复或恢复的子DB 117。（C）版权所有（C）2006，JPO＆NCIPI

3. 发明专利

JP2006119822A Method for reorganizing database, storage device and storage system 有权
标题翻译：重组数据库，存储设备和存储系统的方法
公开(公告)号：JP2006119822A
公开(公告)日：2006-05-11
申请号：JP2004305680
申请日：2004-10-20
申请人： Hitachi Ltd , Univ Of Tokyo , 国立大学法人東京大学 , 株式会社日立製作所
发明人： KIREGAWA MASARU , AIDA KAZUO , KAWAMURA NOBUO
IPC分类号： G06F12/00 , G06F3/06
CPC分类号： G06F17/30339
摘要： PROBLEM TO BE SOLVED: To provide a storage system for executing the process of reorganizing a database. SOLUTION: A method for reorganizing a database stored in the disk drive of a storage device at a request from a host computer is provided. The disk drive includes a first volume for storing the database and a second volume that is paired with the first volume to store a copy of the database. The method includes steps of: stopping the transaction of the host computer; dividing the pair of the first and second volumes; setting only the first volume to access the database; canceling the stop of the transaction; reorganizing the second volume; copying the content of the second volume into the first volume; and re-synchronizing the pair of the first and second volumes. COPYRIGHT: (C)2006,JPO&NCIPI
摘要翻译：要解决的问题：提供一种用于执行重组数据库的过程的存储系统。提供了一种用于根据来自主计算机的请求重新组织存储在存储设备的磁盘驱动器中的数据库的方法。磁盘驱动器包括用于存储数据库的第一卷和与第一卷配对以存储数据库的副本的第二卷。该方法包括以下步骤：停止主计算机的交易; 划分一对第一和第二卷; 仅设置第一个访问数据库的卷; 取消交易的停止; 重组第二卷; 将第二卷的内容复制到第一卷中; 并重新同步该对第一和第二卷。版权所有（C）2006，JPO＆NCIPI

4. 发明专利

JP2012014739A Computer system and database management system program 有权
标题翻译：计算机系统和数据库管理系统程序
公开(公告)号：JP2012014739A
公开(公告)日：2012-01-19
申请号：JP2011224911
申请日：2011-10-12
申请人： Hitachi Ltd , Univ Of Tokyo , 国立大学法人東京大学 , 株式会社日立製作所
发明人： KIREGAWA MASARU , MOGI KAZUHIKO , NISHIKAWA NORIFUMI , IDEI HIDEOMI , KAWAMURA NOBUO
IPC分类号： G06F12/00
摘要： PROBLEM TO BE SOLVED: To reduce an amount of memory required to activate a read-ahead capability in a computer where a DBMS operates.SOLUTION: In a system, a computer comprises: a shared DB data management unit for managing actions including exclusive lock control for data stored in a buffer, reference thereto and acquisition thereof; a data processing unit for acquiring and processing requested data; and a read-ahead unit for referring to data stored in the buffer and reading the data ahead. The shared DB data management unit executes data acquisition request processing at the request of the data processing unit, and executes data reference request processing at the request of the read-ahead unit. The shared DB data management unit adjusts an I/O issuing interval when implementing the data read processing in the data reference request processing, and it executes exclusive lock control for data and acquisition thereof in the data acquisition request processing.
摘要翻译：要解决的问题：减少在DBMS操作的计算机中激活预读能力所需的内存量。解决方案：一种计算机，包括：共享DB数据管理单元，用于管理包括存储在缓冲器中的数据的独占锁定控制的动作，参考和获取; 数据处理单元，用于获取和处理所请求的数据; 以及用于参考存储在缓冲器中的数据并读取数据的预读单元。共享DB数据管理单元根据数据处理单元的请求执行数据获取请求处理，并且根据预读单元的请求执行数据参考请求处理。共享DB数据管理单元在数据参照请求处理中进行数据读取处理时调整I / O发布间隔，在数据采集请求处理中执行用于数据的独占锁定控制和获取数据。版权所有（C）2012，JPO＆INPIT

5. 发明专利

JP2007026062A Reorganization method and system for database 有权
标题翻译：数据库的重组方法和系统
公开(公告)号：JP2007026062A
公开(公告)日：2007-02-01
申请号：JP2005206999
申请日：2005-07-15
申请人： Hitachi Ltd , Univ Of Tokyo , 国立大学法人東京大学 , 株式会社日立製作所
发明人： KIREGAWA MASARU , AIDA KAZUO , KAWAMURA NOBUO
IPC分类号： G06F12/00
CPC分类号： G06F17/30312
摘要： PROBLEM TO BE SOLVED: To quickly and efficiently attain the reorganization of a database. SOLUTION: The transaction of a database is made static (1401), and a pair of a first volume and a previous volume is divided (1402), and the access of the database is performed to the first volume, and the making static of a transaction is released (1403), and a non-dense space is specified from the database of a second volume, and only the specified non-dense space of the second volume is partially reorganized (S1404), and the content of the partially reconfigured second volume is copied to the first volume, and the pair of the first volume and the second volume is re-synchronized (S1405). COPYRIGHT: (C)2007,JPO&INPIT
摘要翻译：要解决的问题：快速有效地实现数据库的重组。解决方案：数据库的事务是静态的（1401），并且一对第一卷和前一个卷被分割（1402），并且对第一卷执行数据库的访问，并且进行发布事务的静态（1403），并且从第二卷的数据库指定非密集空间，并且仅部分重组第二卷的指定非密集空间（S1404），并且内容部分重新配置的第二卷被复制到第一卷，并且第一卷和第二卷的对被重新同步（S1405）。版权所有（C）2007，JPO＆INPIT

6. 发明专利

JP2013033517A Database processing method and database processing system 有权
标题翻译：数据库处理方法和数据库处理系统
公开(公告)号：JP2013033517A
公开(公告)日：2013-02-14
申请号：JP2012244730
申请日：2012-11-06
申请人： Hitachi Ltd , 株式会社日立製作所
发明人： TANAKA MICHIKO , USHIJIMA KAZUTOMO , SHIMIZU AKIRA , TOKUDA SEISUKE , KAWAMURA NOBUO
IPC分类号： G06F17/30 , G06F12/00
摘要： PROBLEM TO BE SOLVED: To speed up extraction of sorted data.SOLUTION: In a computer in which a database management system for managing a database that stores data is executed, a database processing method for outputting requested data comprises steps of: receiving an inquiry request to output extracted data in designated order; generating an inquiry execution plan for extracting data on the basis of the inquiry request; obtaining the requested data on the basis of the inquiry execution plan; generating interim results including the obtained data; sorting the generated interim results into designated order; determining whether the sorted order of the interim results is set or not for each interim result; and outputting the interim results in the set order as an inquiry result.
摘要翻译：要解决的问题：加快排序数据的提取。解决方案：在其中执行用于管理存储数据的数据库的数据库管理系统的计算机中，用于输出请求数据的数据库处理方法包括以下步骤：接收查询请求以按指定顺序输出提取的数据; 生成查询执行计划，用于根据查询请求提取数据; 根据查询执行计划获得要求的数据; 产生包括获得的数据的中期结果; 将生成的中期业绩按指定顺序排列; 确定每个中期结果是否设定了中期业绩的排序顺序; 并以所设定的顺序输出中期结果作为查询结果。版权所有（C）2013，JPO＆INPIT

7. 发明专利

JP2012048332A Database processing method, database processing system, and database server 有权
标题翻译：数据库处理方法，数据库处理系统和数据库服务器
公开(公告)号：JP2012048332A
公开(公告)日：2012-03-08
申请号：JP2010187798
申请日：2010-08-25
申请人： Hitachi Ltd , 株式会社日立製作所
发明人： TANAKA MICHIKO , USHIJIMA KAZUTOMO , SHIMIZU AKIRA , TOKUDA SEISUKE , KAWAMURA NOBUO
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30463 , G06F17/30486
摘要： PROBLEM TO BE SOLVED: To improve the speed in extracting sorted data.SOLUTION: A database processing method for outputting requested data in a calculator in which a database management system for managing a database which stores data is implemented comprises: a step for receiving an inquiry request to output extracted data in a specified order; a step for generating an inquiry execution plan for extracting data on the basis of the inquiry request; a step for acquiring the requested data on the basis of the inquiry execution plan; a step for generating an intermediate result including the acquired data; a step for sorting the generated intermediate result into the specified order; a step for determining, with respect to each intermediate result, whether or not the order of the sorted intermediate result is confirmed; and a step for outputting, as an inquiry result, the intermediate result the order of which is confirmed.
摘要翻译：要解决的问题：提高排序数据的提取速度。解决方案：一种用于在其中实现用于管理存储数据的数据库的数据库管理系统的计算器中输出所请求的数据的数据库处理方法，包括：接收询问请求的步骤，以指定顺序输出提取的数据; 生成用于根据查询请求提取数据的查询执行计划的步骤; 基于查询执行计划获取所请求的数据的步骤; 用于生成包括所获取的数据的中间结果的步骤; 将生成的中间结果分类为指定顺序的步骤; 针对每个中间结果确定分类中间结果的顺序是否得到确认的步骤; 以及作为查询结果输出确认顺序的中间结果的步骤。版权所有（C）2012，JPO＆INPIT

8. 发明专利

JP2010266996A Database processing method, database processing system and database server 有权
标题翻译：数据库处理方法，数据库处理系统和数据库服务器
公开(公告)号：JP2010266996A
公开(公告)日：2010-11-25
申请号：JP2009116517
申请日：2009-05-13
申请人： Hitachi Ltd , 株式会社日立製作所
发明人： TANAKA MICHIKO , USHIJIMA KAZUTOMO , SHIMIZU AKIRA , TOKUDA SEISUKE , FUJIWARA SHINJI , KAWAMURA NOBUO
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30306
摘要： PROBLEM TO BE SOLVED: To reduce the time necessary for data input/output, in a database processing system. SOLUTION: The database processing system includes: a computer that outputs data based on a received inquiry request; and a storage system including a storage device that stores the data. An index indicating a location of the data is stored in the storage device, and the index comprises a plurality of partial indexes. The data stored in the storage device is grouped based on the location of the data, and constitute a plurality of data groups. The partial index indicates the location of the data included in the data group, and the computer receives the inquiry request of the data, acquires the partial index, specifies a location where the requested data is stored based on the acquired partial index and the inquiry request of the data, and transmits a request to acquire the data stored in the specified location, to the storage system. COPYRIGHT: (C)2011,JPO&INPIT
摘要翻译：要解决的问题：在数据库处理系统中减少数据输入/输出所需的时间。解决方案：数据库处理系统包括：基于接收到的查询请求输出数据的计算机; 以及包括存储数据的存储装置的存储系统。指示数据位置的索引被存储在存储装置中，索引包括多个部分索引。存储在存储装置中的数据基于数据的位置被分组，并且构成多个数据组。部分索引表示包含在数据组中的数据的位置，并且计算机接收数据的查询请求，获取部分索引，基于获取的部分索引和查询请求指定存储所请求数据的位置并且将存储在指定位置的数据的请求发送到存储系统。版权所有（C）2011，JPO＆INPIT

9. 发明专利

JP2010039819A Database management method, database management device and database management program 有权
标题翻译：数据库管理方法，数据库管理设备和数据库管理程序
公开(公告)号：JP2010039819A
公开(公告)日：2010-02-18
申请号：JP2008202920
申请日：2008-08-06
申请人： Hitachi Ltd , 株式会社日立製作所
发明人： KAWAMURA NOBUO
IPC分类号： G06F12/00
CPC分类号： G06F11/1458 , G06F11/1456 , G06F11/1466 , G06F17/30306 , G06F2201/80
摘要： PROBLEM TO BE SOLVED: To reduce the time necessary for operation and maintenance of a database.
SOLUTION: This database management device managing the database stored in a storage device performs loading for storing data read from the storage device into a memory, reads/writes the data stored in the memory for task processing, performs unloading for writing the data stored in the memory into the storage device, and performs operation processing of the database by use of the data stored in the memory either at the loading or unloading.
COPYRIGHT: (C)2010,JPO&INPIT

10. 发明专利

JP2008181274A Management device and management method 有权
标题翻译：管理设备和管理方法
公开(公告)号：JP2008181274A
公开(公告)日：2008-08-07
申请号：JP2007013393
申请日：2007-01-24
申请人： Hitachi Ltd , 株式会社日立製作所
发明人： MOGI KAZUHIKO , NISHIKAWA NORIFUMI , OEDA TAKASHI , KAWAMURA NOBUO
IPC分类号： G06F12/00
CPC分类号： G06F11/1469 , G06F11/1435 , G06F11/1464 , G06F11/1471 , G06F2201/80 , G06F2201/84
摘要： PROBLEM TO BE SOLVED: To easily perform DB recovery processing for recovering DB data at a certain past time point and constructing a system configuration wherein the DB data can be accessed. SOLUTION: This management device stores configuration history information expressing a change history of the system configuration, specifies the system configuration at a recovery time point that is the certain past time point from the information, specifies the system configuration at the present time point, compares the system configuration at the recovery time point and the system configuration at the present time point, and specifies whether or not a system configuration portion necessary for a setting change is present in the system configuration at the present time point so as to access the recovered data when recovering the data at the recovery time point based on a result of the comparison. When the system configuration portion is specified, an instruction related to the necessary setting change is issued to an element allowing the setting change of the system configuration portion to construct the system configuration allowing a data use part to access the recovered data. COPYRIGHT: (C)2008,JPO&INPIT
摘要翻译：要解决的问题：为了容易地执行用于在特定过去时间点恢复数据库数据的数据库恢复处理，并且构建可以访问数据库数据的系统配置。解决方案：该管理设备存储表示系统配置的更改历史的配置历史信息，在从该信息起的特定过去时间点的恢复时间点处指定系统配置，指定当前时间点的系统配置比较在当前时间点的恢复时间点的系统配置和系统配置，并指定当前时间点在系统配置中是否存在设置改变所需的系统配置部分，以访问基于比较的结果在恢复时间点恢复数据时恢复数据。当指定了系统配置部分时，向允许系统配置部分的设置改变的元素发出与必要的设置改变相关的指令来构建允许数据使用部分访问恢复的数据的系统配置。版权所有（C）2008，JPO＆INPIT

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式