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

1. 发明授权

US10747773B2 Database management system, computer, and database management method 有权
公开(公告)号：US10747773B2
公开(公告)日：2020-08-18
申请号：US14402878
申请日：2012-05-24
申请人： Michiko Yoshida , Akira Shimizu , Seisuke Tokuda , Kazuhiko Mogi , Shinji Fujiwara , Nobuo Kawamura , Masaru Kitsuregawa , Kazuo Goda
发明人： Michiko Yoshida , Akira Shimizu , Seisuke Tokuda , Kazuhiko Mogi , Shinji Fujiwara , Nobuo Kawamura , Masaru Kitsuregawa , Kazuo Goda
IPC分类号： G06F16/25 , G06F16/2455 , G06F16/2453 , G06F16/245
摘要： A database management system (DBMS) manages a database existing in a second storage device with an access speed lower than that of a first storage device. In an execution of a query, the DBMS dynamically generates tasks two or more executable tasks in parallel. The DBMS generates task start information which is information representing a content of the execution of the task, manages the task start information, and executes a content represented by the task start information by the task. The task start information includes a data address set existing in the second storage device. The DBMS controls movement of the data address sets between the first storage device and the second storage device based on a management state of the task start information. In addition, the DBMS selects the task start information based on whether or not the data address set exists in the first storage device.

2. 发明授权

US10417227B2 Database management system, computer, and database management method 有权
公开(公告)号：US10417227B2
公开(公告)日：2019-09-17
申请号：US14397076
申请日：2012-04-27
申请人： Akira Shimizu , Seisuke Tokuda , Michiko Yoshida , Kazuhiko Mogi , Shinji Fujiwara , Nobuo Kawamura , Masaru Kitsuregawa , Kazuo Goda
发明人： Akira Shimizu , Seisuke Tokuda , Michiko Yoshida , Kazuhiko Mogi , Shinji Fujiwara , Nobuo Kawamura , Masaru Kitsuregawa , Kazuo Goda
IPC分类号： G06F16/2453 , G06F16/2455 , G06F9/48
摘要： A database management system (DBMS) generates a query execution plan including information representing one or more database (DB) operations necessary for executing a query and executes the query based on the query execution plan. In the execution of the query, the DBMS dynamically generates a task for executing a DB operation and executes the dynamically generated task. The DBMS executes a task in a plurality of threads executed by a processor core.

3. 发明授权

US09841989B2 Parallel data processing system, computer, and parallel data processing method 有权
公开(公告)号：US09841989B2
公开(公告)日：2017-12-12
申请号：US14404550
申请日：2012-05-31
申请人： Kazuo Goda , Hiroyuki Yamada , Masaru Kitsuregawa , Nobuo Kawamura , Shinji Fujiwara , Kazuhiko Mogi
发明人： Kazuo Goda , Hiroyuki Yamada , Masaru Kitsuregawa , Nobuo Kawamura , Shinji Fujiwara , Kazuhiko Mogi
IPC分类号： G06F9/44 , G06F9/46 , G06F9/54 , G06F9/48 , G06F17/30
CPC分类号： G06F9/466 , G06F9/4843 , G06F9/54 , G06F17/30445 , G06F17/30477
摘要： A parallel data processing system includes a parallel data processing execution unit for reading a data from a data set including a first data set that includes a plurality of first data and a second data set that includes a plurality of second data and executing processing. The parallel data processing execution unit (A) reads the first data from the first data set, and acquires a first value from the first data based on first format information acquired from an application, (B) generates one or more threads for respectively reading one or more second data corresponding to the first value from the second data set based on first reference information acquired from the application, (C) executes (A) and (B) on one or more first data in the first data set, and (D) executes a plurality of the threads in parallel.

4. 发明授权

US08510316B2 Database processing system and method 有权
标题翻译：数据库处理系统和方法
公开(公告)号：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.
摘要翻译：提供了一种数据库系统，其中查询结果的排序加快。数据库系统存储以给定顺序记录数据段的存储位置的存储位置信息。当不存在基于在第一任务中获取的数据而执行的第二任务时，确定在第一任务之前执行的第三任务中请求的每个数据片段是否已被获取。在第三任务中请求的每个数据片段被取出的情况下，输出在第一任务中取出的数据。在第三任务中请求的一些数据尚未获取的情况下，将第一任务中提取的数据保存在临时缓冲区中，直到第三个任务中请求的每个数据片段被提取，然后输出。

5. 发明授权

US07640276B2 Backup system, program and backup method 失效
标题翻译：备份系统，程序和备份方法
公开(公告)号：US07640276B2
公开(公告)日：2009-12-29
申请号：US11132175
申请日：2005-05-19
申请人： Satoru Watanabe , Yoshio Suzuki , Shinji Fujiwara
发明人： Satoru Watanabe , Yoshio Suzuki , Shinji Fujiwara
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , Y10S707/99953
摘要： Provided is a backup method including a step (S1) of reading a log which is a data update difference, and identifying a data storage area (page) of backup data, a step (S2) of determining high/low reusability of the identified data storage area, a step (S3) of storing a log corresponding to a data storage area determined to be low in reusability in a log storage area preset on a memory, and a step (S4) of applying a log corresponding to a data storage area determined to be high in reusability to the identified data storage area in a cache area set on the memory, and updating the data storage area. Thus, by further reducing the number of I/O times in an external storage system of a standby system which backs up data by log transfer, it is possible to reduce introduction costs of a backup system and its normal-time operation's costs at normal times.
摘要翻译：提供了一种备份方法，包括：读取作为数据更新差异的日志的步骤（S1），以及识别备份数据的数据存储区域（页面）;确定所识别的数据的高/低可重用性的步骤（S2）存储与预定在存储器上的日志存储区域中存储对应于确定为可重用性低的数据存储区域的日志的步骤（S3）;以及步骤（S4），对应于数据存储区域被确定为对存储器中设置的高速缓存区域中的识别数据存储区域的可重用性高，并且更新数据存储区域。因此，通过进一步减少通过日志传送备份数据的备用系统的外部存储系统中的I / O次数，可以降低备用系统的引入成本和正常时间操作的成本。

6. 发明授权

US07539703B2 Setup method for disaster recovery system 有权
标题翻译：灾难恢复系统的安装方法
公开(公告)号：US07539703B2
公开(公告)日：2009-05-26
申请号：US11455751
申请日：2006-06-20
申请人： Kazuhiko Mizuno , Shinji Fujiwara , Yoshio Suzuki
发明人： Kazuhiko Mizuno , Shinji Fujiwara , Yoshio Suzuki
IPC分类号： G06F17/30
CPC分类号： G06F11/1662 , G06F11/2038 , G06F11/2048 , G06F11/2056 , G06F2201/80 , Y10S707/99953
摘要： Provided is a technique of setting up a disaster recovery system. In a log-based disaster recovery system including a first site for processing data and a second site for storing a backup of the first site, the first site has a volume where data is stored and a volume that is made quiescent. The disaster recovery system accepts data updates while sequentially copying initial data from the quiescent volume to the second site. A copy of a log of the first site is kept in the second site and is synchronized with the original log. When data of the first site is updated and corresponding initial data has not been copied to the second site, the data to be updated is preferentially copied to the second site. A log is applied to the copied data, thereby matching data of the second site with data of the first site.
摘要翻译：提供了一种设置灾难恢复系统的技术。在基于日志的灾难恢复系统中，包括用于处理数据的第一站点和用于存储第一站点的备份的第二站点，第一站点具有存储数据的卷和静止的卷。灾难恢复系统接受数据更新，同时将初始数据从静态卷逐次复制到第二个站点。第一个站点的日志的副本保存在第二个站点中，并与原始日志同步。当第一站点的数据被更新并且对应的初始数据没有被复制到第二站点时，要更新的数据被优先地复制到第二站点。将日志应用于复制的数据，从而将第二站点的数据与第一站点的数据进行匹配。

7. 发明授权

US07529964B2 Data duplication method in a disaster recovery system 有权
标题翻译：灾难恢复系统中的数据复制方法
公开(公告)号：US07529964B2
公开(公告)日：2009-05-05
申请号：US10930832
申请日：2004-09-01
申请人： Yoshio Suzuki , Nobuo Kawamura , Kota Yamaguchi , Satoru Watanabe , Shinji Fujiwara
发明人： Yoshio Suzuki , Nobuo Kawamura , Kota Yamaguchi , Satoru Watanabe , Shinji Fujiwara
IPC分类号： G06F11/00
CPC分类号： G06F11/2097 , G06F11/1471
摘要： A recovery of a secondary DB is executed by a log including a update difference of a primary DB, and a command is executed by adding the command to the log and analyzing the log by a secondary site. An operation command execution in the secondary site is applied to the DB having the consistency in the transaction at the same timing as a primary site or an intended timing, by transferring and executing the operation command via the log. In the case that the command is constituted by a snap shot generating instruction, a plurality of volumes of a mirror set forming a secondary storage apparatus are set to a pair state and the secondary DB is written in each of the volumes and synchronized, and the mirror set is set to a split state after the synchronization is finished, whereby a secondary DB is stored.
摘要翻译：辅助DB的恢复由包括主DB的更新差异的日志执行，并且通过将命令添加到日志并通过辅助站点分析日志来执行命令。通过经由日志传送和执行操作命令，在辅助站点中的操作命令执行以与主站点相同的定时或预期定时被应用于事务中具有一致性的DB。在命令由快照生成指令构成的情况下，形成副存储装置的多个镜像组的集合被设置为成对状态，并且辅助DB被写入每个卷并同步，并且镜像集在同步完成后设置为分割状态，从而存储辅助数据块。

8. 发明申请

US20080288497A1 Exclusive control method for database and program 有权
标题翻译：数据库和程序的独占控制方法
公开(公告)号：US20080288497A1
公开(公告)日：2008-11-20
申请号：US11819310
申请日：2007-06-26
申请人： Satoru Watanabe , Yoshio Suzuki , Shinji Fujiwara , Nobuo Kawamura
发明人： Satoru Watanabe , Yoshio Suzuki , Shinji Fujiwara , Nobuo Kawamura
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F17/30362 , G06F17/30368
摘要： A technology capable of preventing a problem which occurs when log writing of a preceding transaction fails while reducing waiting time of a subsequent transaction is provided. A database control method for releasing locking of data held by a transaction upon reception of a transaction completion instruction from an operation terminal or the like by a database is provided. The database includes an exclusive control module, a log output module, and a log buffer. The log output module stores a transaction completion log in the log buffer upon reception of the transaction completion instruction from the operation terminal. The exclusive control module releases locking held by the transaction upon reception of storage of the transaction completion log in the log buffer.
摘要翻译：提供一种能够防止在前一事务的日志写入失败同时减少后续事务的等待时间时发生的问题的技术。提供一种数据库控制方法，用于在从数据库的操作终端等接收到交易完成指令时释放由交易持有的数据的锁定。该数据库包括独占控制模块，日志输出模块和日志缓冲区。日志输出模块在从操作终端接收到交易完成指令时将事务完成日志存储在日志缓冲器中。独占控制模块在接收到日志缓冲区中的事务完成日志的存储时释放由事务保持的锁定。

9. 发明申请

US20080256146A1 Query processing method for stream data processing systems 有权
公开(公告)号：US20080256146A1
公开(公告)日：2008-10-16
申请号：US12213042
申请日：2008-06-13
申请人： Itaru Nishizawa , Tsuneyuki Imaki , Shinji Fujiwara
发明人： Itaru Nishizawa , Tsuneyuki Imaki , Shinji Fujiwara
IPC分类号： G06F17/30
CPC分类号： G06F17/30516 , Y10S707/99955
摘要： A stream data processing system capable of highly reliable and highly usable real time data processing, is provided with: (1) a mechanism of copying some or all of stream data, and archiving the stream data in a non-volatile memory to allow real time data and archive data to be used seamlessly; and (2) a mechanism of improving the performance of query processings by using a plurality of stream data processing systems cooperatively.

10. 发明申请

US20080229140A1 System and method of disaster recovery 有权
标题翻译：灾难恢复系统和方法
公开(公告)号：US20080229140A1
公开(公告)日：2008-09-18
申请号：US11802186
申请日：2007-05-21
申请人： Yoshio Suzuki , Nobuo Kawamura , Shinji Fujiwara , Satoru Watanabe , Kazuhiko Mizuno
发明人： Yoshio Suzuki , Nobuo Kawamura , Shinji Fujiwara , Satoru Watanabe , Kazuhiko Mizuno
IPC分类号： G06F11/00
CPC分类号： G06F11/2082 , G06F11/2074 , G06F17/30368 , G06F2201/855
摘要： In a DR system, from the viewpoint of device cost, when search is not carried out, a physical application where log recovery is available by inexpensive DB appliance server is adopted. Further, a local mirror operation at a secondary site is not carried out. Furthermore, from the viewpoint of operation, by a log apply function unit, the tendencies of a log application and operations are monitored, and a search process is accepted according to the progress conditions of the log application. When the log application does not catch up sufficiently, the search is not accepted. Moreover, when a consistency guarantee of a secondary DB is made, not transactions in process at the moment of search instruction are undone (rolled back), but only transactions in process at the moment of a search instruction are redone (rolled forward).
摘要翻译：在DR系统中，从设备成本的观点来看，当不进行搜索时，采用廉价DB设备服务器可以进行日志恢复的物理应用。此外，不执行次要站点处的本地镜像操作。此外，从操作的观点来看，通过日志应用功能单元，监视日志应用和操作的倾向，并且根据日志应用的进度条件接受搜索处理。当日志应用程序没有足够的赶上时，搜索不被接受。此外，当辅助DB的一致性保证被做出时，不是在搜索指令的时刻处理的事务被撤销（回滚），而是仅仅在搜索指令的时刻重新进行正在进行的事务。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式