Integrating databases
    1.
    发明授权
    Integrating databases 有权
    集成数据库

    公开(公告)号:US08965912B2

    公开(公告)日:2015-02-24

    申请号:US11926504

    申请日:2007-10-29

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30557 G06F17/30545

    摘要: A system for integrating databases comprises a first virtual table, a second virtual table, a common table, a list, a generating section, and a selecting section. The first virtual table corresponds to a first data. The second virtual table corresponds to a second data. The common table is associated with the first and second virtual tables. The list indicates information about associations between the first and second virtual tables and the common table. The generating section generates two or more access plans from a database query on the common table. The two or more access plans involve at least one of the first and second virtual tables in accordance with the list. The selecting section selects one of the two or more access plans generated by the generating section to be used to execute the database query.

    摘要翻译: 用于集成数据库的系统包括第一虚拟表,第二虚拟表,公用表,列表,生成部分和选择部分。 第一虚拟表对应于第一数据。 第二虚拟表对应于第二数据。 公用表与第一个和第二个虚拟表相关联。 该列表指示关于第一和第二虚拟表与公用表之间的关联的信息。 生成部分从公用表上的数据库查询生成两个或多个访问计划。 两个或多个访问计划涉及根据列表的第一和第二虚拟表中的至少一个。 选择部分选择由生成部分生成的用于执行数据库查询的两个或多个访问计划之一。

    Technique of controlling access to database
    2.
    发明授权
    Technique of controlling access to database 有权
    控制数据库访问的技术

    公开(公告)号:US08949192B2

    公开(公告)日:2015-02-03

    申请号:US12254697

    申请日:2008-10-20

    IPC分类号: G06F17/00 G06F17/30

    CPC分类号: G06F17/30557 G06F17/30575

    摘要: A method of controlling access to a database includes autonomously archiving data within a database from a first storage device into a second storage device, according to an archive condition; the archive condition being input in conjunction with the data and being associated with the data; accepting an input of an access command to the database; determining whether data to be accessed in response to the access command input has already been archived in the second storage device based on the access command and the archive condition; and accessing data included in the database or data archived in the second storage device according to the access command based on the determination.

    摘要翻译: 控制对数据库的访问的方法包括根据存档条件自动地将数据库内的数据从第一存储设备归档到第二存储设备中; 归档条件与数据一起输入并与数据相关联; 接受对数据库的访问命令的输入; 基于访问命令和存档条件,确定响应于访问命令输入要访问的数据是否已经被存档在第二存储设备中; 以及基于所述确定,根据所述访问命令访问包括在所述数据库中的数据或存储在所述第二存储设备中的数据。

    Information processor, information processing system, data archiving method, and data deletion method
    3.
    发明授权
    Information processor, information processing system, data archiving method, and data deletion method 有权
    信息处理器,信息处理系统,数据归档方法和数据删除方法

    公开(公告)号:US08849766B2

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

    申请号:US12972565

    申请日:2010-12-20

    申请人: Masahiro Ohkawa

    发明人: Masahiro Ohkawa

    IPC分类号: G06F17/00 G06F17/30 G06F13/00

    摘要: An information processor may include a command receiving unit that receives an immediate processing command in which a deletion target to be deleted from the database is conditioned, and a registration processing unit that registers information defining the deletion target into a management data unit. In addition, the information processor may include a deletion processing unit that deletes the deletion target from a database, and deregisters the deleted deletion target from the management data unit. The information processor can also include a data manipulation command processing unit, which, in the case where a data manipulation command having a manipulation target that coincides with a table of the deletion target registered in the management data unit is received, processes the data manipulation command in a state where a condition to exclude the deletion target from the manipulation target is added to the data manipulation command.

    摘要翻译: 信息处理器可以包括命令接收单元,其接收其中要从数据库中删除的删除目标被调节的立即处理命令;以及注册处理单元,其将定义删除目标的信息登记到管理数据单元中。 此外,信息处理器可以包括删除处理单元,其从数据库中删除删除目标,并且从管理数据单元注销已删除的删除目标。 信息处理器还可以包括数据操作命令处理单元,在接收到具有与登记在管理数据单元中的删除目标的表一致的操作对象的数据操作命令的情况下,处理数据操作命令 在从操作对象排除删除对象的条件被附加到数据操作命令的状态下。

    INFORMATION PROCESSOR, INFORMATION PROCESSING SYSTEM, DATA ARCHIVING METHOD, AND DATA DELETION METHOD
    4.
    发明申请
    INFORMATION PROCESSOR, INFORMATION PROCESSING SYSTEM, DATA ARCHIVING METHOD, AND DATA DELETION METHOD 有权
    信息处理器,信息处理系统,数据存档方法和数据删除方法

    公开(公告)号:US20110178990A1

    公开(公告)日:2011-07-21

    申请号:US12972565

    申请日:2010-12-20

    申请人: Masahiro Ohkawa

    发明人: Masahiro Ohkawa

    IPC分类号: G06F17/30

    摘要: An information processor may include a command receiving unit that receives an immediate processing command in which a deletion target to be deleted from the database is conditioned, and a registration processing unit that registers information defining the deletion target into a management data unit. In addition, the information processor may include a deletion processing unit that deletes the deletion target from a database, and deregisters the deleted deletion target from the management data unit. The information processor can also include a data manipulation command processing unit, which, in the case where a data manipulation command having a manipulation target that coincides with a table of the deletion target registered in the management data unit is received, processes the data manipulation command in a state where a condition to exclude the deletion target from the manipulation target is added to the data manipulation command.

    摘要翻译: 信息处理器可以包括命令接收单元,其接收其中要从数据库中删除的删除目标被调节的立即处理命令;以及注册处理单元,其将定义删除目标的信息登记到管理数据单元中。 此外,信息处理器可以包括删除处理单元,其从数据库中删除删除目标,并且从管理数据单元注销已删除的删除目标。 信息处理器还可以包括数据操作命令处理单元,在接收到具有与登记在管理数据单元中的删除目标的表一致的操作对象的数据操作命令的情况下,处理数据操作命令 在从操作对象排除删除对象的条件被附加到数据操作命令的状态下。

    Apparatus, method and program for refreshing a summary table
    7.
    发明授权
    Apparatus, method and program for refreshing a summary table 失效
    用于刷新汇总表的装置,方法和程序

    公开(公告)号:US08271440B2

    公开(公告)日:2012-09-18

    申请号:US11876520

    申请日:2007-10-22

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30377

    摘要: An apparatus is provided with base table storage sections that store base tables and delta tables for the base tables, a summary table storage section that stores a summary table for storing results of queries to a plurality of base tables and delta information about the summary table, delta data processing sections that insert delta data of the base tables into the delta tables, and a delta computation processing section that generates delta information about the summary table. The delta computation processing section is provided with a generation section that generates delta information about a specified base table on the basis of an update that has been performed for the base table, in a situation where a subsequent update of the specified base table is permitted; and a control section that performs control so that, when a different base table is specified, delta information is generated in a different transaction.

    摘要翻译: 提供了一种设备,用于存储用于基表的基表和增量表的基表存储部分,汇总表存储部分,其将用于存储查询结果的汇总表存储到多个基表和关于汇总表的增量信息, 增量数据处理部分,其将基本表的增量数据插入增量表;以及增量计算处理部分,其生成关于汇总表的增量信息。 增量计算处理部分具有生成部,其在允许指定的基表的后续更新的情况下,基于对基表进行的更新,生成关于指定的基表的增量信息; 以及控制部,其执行控制,使得当指定不同的基表时,在不同的事务中生成增量信息。

    TECHNIQUE OF CONTROLLING ACCESS TO DATABASE
    9.
    发明申请
    TECHNIQUE OF CONTROLLING ACCESS TO DATABASE 有权
    控制访问数据库的技术

    公开(公告)号:US20090187612A1

    公开(公告)日:2009-07-23

    申请号:US12254697

    申请日:2008-10-20

    IPC分类号: G06F12/16 G06F17/30 G06F12/00

    CPC分类号: G06F17/30557 G06F17/30575

    摘要: A method of controlling access to a database includes autonomously archiving data within a database from a first storage device into a second storage device, according to an archive condition; the archive condition being input in conjunction with the data and being associated with the data; accepting an input of an access command to the database; determining whether data to be accessed in response to the access command input has already been archived in the second storage device based on the access command and the archive condition; and accessing data included in the database or data archived in the second storage device according to the access command based on the determination.

    摘要翻译: 控制对数据库的访问的方法包括根据存档条件自动地将数据库内的数据从第一存储设备归档到第二存储设备中; 归档条件与数据一起输入并与数据相关联; 接受对数据库的访问命令的输入; 基于访问命令和存档条件,确定响应于访问命令输入要访问的数据是否已经被存档在第二存储设备中; 以及基于所述确定,根据所述访问命令访问包括在所述数据库中的数据或存档在所述第二存储设备中的数据。

    SYSTEM, METHOD, AND PROGRAM PRODUCT FOR INTEGRATING DATABASES
    10.
    发明申请
    SYSTEM, METHOD, AND PROGRAM PRODUCT FOR INTEGRATING DATABASES 有权
    用于集成数据库的系统,方法和程序产品

    公开(公告)号:US20080306904A1

    公开(公告)日:2008-12-11

    申请号:US11926504

    申请日:2007-10-29

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30557 G06F17/30545

    摘要: A system for integrating databases comprises a first virtual table, a second virtual table, a common table, a list, a generating section, and a selecting section. The first virtual table corresponds to a first data. The second virtual table corresponds to a second data. The common table is associated with the first and second virtual tables. The list indicates information about associations between the first and second virtual tables and the common table. The generating section generates two or more access plans from a database query on the common table. The two or more access plans involve at least one of the first and second virtual tables in accordance with the list. The selecting section selects one of the two or more access plans generated by the generating section to be used to execute the database query.

    摘要翻译: 用于集成数据库的系统包括第一虚拟表,第二虚拟表,公用表,列表,生成部分和选择部分。 第一虚拟表对应于第一数据。 第二虚拟表对应于第二数据。 公用表与第一个和第二个虚拟表相关联。 该列表指示关于第一和第二虚拟表与公用表之间的关联的信息。 生成部分从公用表上的数据库查询生成两个或多个访问计划。 两个或多个访问计划涉及根据列表的第一和第二虚拟表中的至少一个。 选择部分选择由生成部分生成的用于执行数据库查询的两个或多个访问计划之一。