Method and database system for duplicating transactions between remote sites
    2.
    发明申请
    Method and database system for duplicating transactions between remote sites 有权
    用于复制远程站点之间的事务的方法和数据库系统

    公开(公告)号:US20040193583A1

    公开(公告)日:2004-09-30

    申请号:US10637556

    申请日:2003-08-11

    Applicant: Hitachi, Ltd.

    Abstract: A method for duplicating transactions in a disaster recover system is disclosed. In this method, transactions and queries input to a primary database system are copied to a secondary database system and both database systems execute the queries and save the results permanently to each database, thereby maintaining duplicated data. When executing a query on the primary database system, if the query is a commit, the primary system simultaneously copies uncopied queries placed in a queue to the secondary database system and then executes the query. By using this processing procedure, the invention realizes a disaster recovery system which carries out copying transactions from one site to another site without losing the transactions, while reducing the influence of copy operation on the transaction processing performance.

    Abstract translation: 公开了一种在灾难恢复系统中复制事务的方法。 在这种方法中,将输入到主数据库系统的事务和查询复制到辅助数据库系统,并且两个数据库系统都执行查询并将结果永久保存到每个数据库,从而保留重复的数据。 当在主数据库系统上执行查询时,如果查询是提交,则主系统会同时将放入队列中的未查找的查询复制到辅助数据库系统,然后执行查询。 通过使用该处理过程,本发明实现了在不丢失事务的情况下执行从一个站点到另一站点的复制事务的灾难恢复系统,同时减少了复制操作对事务处理性能的影响。

    Database system, server, query posing method, and data updating method
    3.
    发明申请
    Database system, server, query posing method, and data updating method 有权
    数据库系统,服务器,查询构造方法和数据更新方法

    公开(公告)号:US20040186829A1

    公开(公告)日:2004-09-23

    申请号:US10751419

    申请日:2004-01-06

    Applicant: Hitachi, Ltd.

    Abstract: An object of the present invention is to avoid contention for resources in a parallel/decentralized database system so as to improve the performance of the system. A query posing method is implemented in a database system comprising a plurality of database servers each of which includes a database from which the same content can be retrieved and searches the database in response to a query request a front-end server that poses a query according to a predetermined rule and a management server that manages rules to be used by the front-end server. The management server acquires a processed query log relevant to a database server, and produces a rule according to the compatibility value of a query calculated using the acquired processed query log. Moreover, the front-end server poses the query according to the rule produced by the management server.

    Abstract translation: 本发明的目的是避免对并行/分散数据库系统中的资源的争用,从而提高系统的性能。 查询构成方法在包括多个数据库服务器的数据库系统中实现,每个数据库服务器包括数据库,从该数据库中可以检索相同的内容,并且响应于查询请求搜索数据库,根据查询请求提供查询的前端服务器 到预定规则和管理由前端服务器使用的规则的管理服务器。 管理服务器获取与数据库服务器相关的处理的查询日志,并根据使用获取的已处理查询日志计算的查询的兼容性值生成规则。 此外,前端服务器根据管理服务器生成的规则提出查询。

Patent Agency Ranking