Method and System of Database Management for Replica Database
    2.
    发明申请
    Method and System of Database Management for Replica Database 审中-公开
    复制数据库数据库管理方法与系统

    公开(公告)号:US20090049107A1

    公开(公告)日:2009-02-19

    申请号:US12239393

    申请日:2008-09-26

    IPC分类号: G06F17/30

    摘要: When a database area multi-written or replicated in an external storage unit is separated, a database management system writes consistent data into the external storage unit. A method and system capable of controlling a timing of separating the replicated database area is provided. Furthermore, new data directory information necessary to access the replicated database is dynamically added based on the data directory information of the replication source database. A method and system capable of selecting whether to access the database which is the source of the replication or access the replicated database are provided. Thus, when the database area multi-written or replicated in an external storage unit is separated and physical replicated databases are created, it is possible to maintain consistency of the replicated databases while continuing transaction processing.

    摘要翻译: 当在外部存储单元中多重写入或复制的数据库区域被分离时,数据库管理系统将一致的数据写入外部存储单元。 提供了一种能够控制分离复制数据库区域的定时的方法和系统。 此外,基于复制源数据库的数据目录信息动态地添加访问复制数据库所需的新的数据目录信息。 提供了一种能够选择是否访问作为复制源或访问复制数据库的数据库的方法和系统。 因此,当在外部存储单元中多重写入或复制的数据库区域被分离并且创建物理复制数据库时,可以在继续事务处理的同时保持复制数据库的一致性。

    Secure multi database system including a plurality of database devices
    4.
    发明授权
    Secure multi database system including a plurality of database devices 有权
    安全的多数据库系统,包括多个数据库设备

    公开(公告)号:US07152067B2

    公开(公告)日:2006-12-19

    申请号:US10928056

    申请日:2004-08-26

    IPC分类号: G06F17/30

    摘要: A definition tool of the present invention declares columns which are concealed in external tables to a multi-database server. The multi-database server controls a decomposition and an execution of query messages such that the multi-database server does not perform an arithmetic using the concealed columns. The external database server encrypts the data of concealed columns in tables of query result tables. The multi-database server designates a range to be decrypted at the time of acquiring and integrating respective result tables. A client program acquires an integrated result table and decrypts the designated range. Since the data encrypted by the external database server is decrypted by and is referred to the client program, it becomes difficult for the multi-database server to refer to a content of the concealed columns.

    摘要翻译: 本发明的定义工具将隐藏在外部表中的列声明到多数据库服务器。 多数据库服务器控制查询消息的分解和执行,使得多数据库服务器不使用隐藏列执行算术。 外部数据库服务器加密查询结果表的表中隐藏列的数据。 多数据库服务器在获取并集成各个结果表时指定要解密的范围。 客户程序获取一个综合结果表并解密指定范围。 由于由外部数据库服务器加密的数据被解密并被称为客户机程序,因此多数据库服务器难以引用隐藏列的内容。

    Application design supporting method and apparatus for client/server
system
    5.
    发明授权
    Application design supporting method and apparatus for client/server system 失效
    客户/服务器系统的应用设计支持方法和装置

    公开(公告)号:US6032198A

    公开(公告)日:2000-02-29

    申请号:US38000

    申请日:1998-03-11

    CPC分类号: G06F8/20 G06F9/465

    摘要: In a method for supporting the design of a plurality of programs distributed on a network and operated through the communication between the programs, each program is defined, a relation between programs is defined, interface information of each program is defined, and the interface defined for each program is converted into an interface definition language (IDL) format to generate an IDL file. The definition of each program and the definition of the relation between programs are performed by providing a graphic display screen to which a program represented by a symbol and a relation between programs represented by an arrow are inputted as definition information by a user. The definition of interface information is performed by inputting information defined by the user in an interactive manner.

    摘要翻译: 在支持分布在网络上并通过程序之间的通信进行操作的多个程序的设计的方法中,定义每个程序,定义程序之间的关系,定义每个程序的接口信息,并为 每个程序被转换为接口定义语言(IDL)格式以生成IDL文件。 每个程序的定义和程序之间的关系的定义通过提供图形显示屏幕来执行,图形显示屏幕由用户表示的由符号表示的程序和由箭头表示的程序之间的关系作为定义信息被输入到该图形显示屏幕。 通过以交互方式输入由用户定义的信息来执行接口信息的定义。

    Secure multi database system including a client, multi database server, and database server
    7.
    发明授权
    Secure multi database system including a client, multi database server, and database server 失效
    安全的多数据库系统,包括客户端,多数据库服务器和数据库服务器

    公开(公告)号:US06792425B2

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

    申请号:US09853348

    申请日:2001-05-11

    IPC分类号: G06F1730

    摘要: A definition tool of the present invention declares columns which are concealed in external tables to a multi-database server. The multi-database server controls a decomposition and an execution of query messages such that the multi-database server does not perform an arithmetic using the concealed columns. The external database server encrypts the data of concealed columns in tables of query result tables. The multi-database server designates a range to be decrypted at the time of acquiring and integrating respective result tables. A client program acquires an integrated result table and decrypts the designated range. Since the data encrypted by the external database server is decrypted by and is referred to the client program, it becomes difficult for the multi-database server to refer to a content of the concealed columns.

    摘要翻译: 本发明的定义工具将隐藏在外部表中的列声明到多数据库服务器。 多数据库服务器控制查询消息的分解和执行,使得多数据库服务器不使用隐藏列执行算术。 外部数据库服务器加密查询结果表的表中隐藏列的数据。 多数据库服务器在获取并集成各个结果表时指定要解密的范围。 客户程序获取一个综合结果表并解密指定范围。 由于由外部数据库服务器加密的数据被解密并被称为客户机程序,因此多数据库服务器难以引用隐藏列的内容。

    DYNAMIC WEB PAGE GENERATION METHOD AND SYSTEM
    8.
    发明申请
    DYNAMIC WEB PAGE GENERATION METHOD AND SYSTEM 审中-公开
    动态网页生成方法和系统

    公开(公告)号:US20070198924A1

    公开(公告)日:2007-08-23

    申请号:US11687387

    申请日:2007-03-16

    IPC分类号: G06F13/10

    CPC分类号: G06F16/972

    摘要: In comparison to unnecessary page generation of the prior art, the page generation time according to the current invention is substantially reduced, and the generated page is efficiently accessed. Since in response to at least one of a predetermined set of update events, a page is dynamically generated in advance of a user page request and the dynamically generated page is stored, the current invention allows the efficient page access. The use of the prior art technologies such as proxy servers in combination further improves the cost of transmission of the page to the user according to the current invention.

    摘要翻译: 与现有技术的不必要的页面生成相比,根据本发明的页面生成时间显着减少,并且生成的页面被有效地访问。 由于响应于预定的一组更新事件中的至少一个,在用户页面请求之前动态地生成页面并且存储动态生成的页面,所以本发明允许有效的页面访问。 组合使用诸如代理服务器的现有技术的技术进一步根据本发明提高了向用户传送页面的成本。

    Dynamic web page generation method and system
    9.
    发明授权
    Dynamic web page generation method and system 失效
    动态网页生成方法和系统

    公开(公告)号:US07194678B1

    公开(公告)日:2007-03-20

    申请号:US09516699

    申请日:2000-03-01

    IPC分类号: G06F17/24 G06F17/27

    CPC分类号: G06F17/30893

    摘要: In comparison to unnecessary page generation of the prior art, the page generation time according to the current invention is substantially reduced, and the generated page is efficiently accessed. Since in response to at least one of a predetermined set of update events, a page is dynamically generated in advance of a user page request and the dynamically generated page is stored, the current invention allows the efficient page access. The efficient page access is accomplished by storing the dynamically generated page as a static page at a URL identified by a page access call with an argument. Thus, the user accesses the previously generated dynamic page at a high-speed. The use of the prior art technologies such as proxy servers in combination further improves the cost of transmission of the page to the user according to the current invention.

    摘要翻译: 与现有技术的不必要的页面生成相比,根据本发明的页面生成时间显着减少,并且生成的页面被有效地访问。 由于响应于预定的一组更新事件中的至少一个,在用户页面请求之前动态地生成页面并且存储动态生成的页面,所以本发明允许有效的页面访问。 通过将动态生成的页面作为静态页面存储在由具有参数的页面访问调用所标识的URL处来实现高效的页面访问。 因此,用户以高速访问先前生成的动态页面。 组合使用诸如代理服务器的现有技术的技术进一步根据本发明提高了向用户传送页面的成本。

    Database management system, and query method and query execution program in the database management system
    10.
    发明授权
    Database management system, and query method and query execution program in the database management system 失效
    数据库管理系统,查询方法和查询执行程序在数据库管理系统中

    公开(公告)号:US06925462B2

    公开(公告)日:2005-08-02

    申请号:US10041577

    申请日:2002-01-10

    IPC分类号: G06F12/00 G06F17/30

    摘要: The present invention relates to an optimization method in a database management system having the function of accessing external databases. Conventionally, whether functions contained in a query can be executed in external databases depends on a database management system having the functions, and therefore there has been a problem in that a database utilization method cannot apply to query optimization and query execution performance is reduced. To solve the above problem, a database management system having the function of accessing external databases is provided with an optimization step comprising the steps of: obtaining specification about whether to execute functions in a query in external databases; determining whether data referred to in a query is confined to one database; and determining whether a user specifies that the functions in the query are executed in external databases.

    摘要翻译: 本发明涉及具有访问外部数据库的功能的数据库管理系统中的优化方法。 通常,查询中包含的功能是否能够在外部数据库中执行取决于具有该功能的数据库管理系统,因此存在数据库利用方法不能应用于查询优化并且查询执行性能降低的问题。 为了解决上述问题,提供了具有访问外部数据库的功能的数据库管理系统,其优化步骤包括以下步骤:获取关于是否在外部数据库中执行查询中的功能的规范; 确定查询中引用的数据是否限于一个数据库; 以及确定用户是否指定在外部数据库中执行查询中的功能。