Change data capturing during an upgrade
    1.
    发明授权
    Change data capturing during an upgrade 有权
    在升级过程中更改数据捕获

    公开(公告)号:US09213728B2

    公开(公告)日:2015-12-15

    申请号:US13325896

    申请日:2011-12-14

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30309 G06F17/30002

    摘要: In one general aspect, a computer system can include instructions stored on a non-transitory computer-readable storage medium. The computer system can include a logging table generator configured to generate a logging table corresponding with an original table targeted for an upgrade, and a control table generator configured to generate a control table configured to store a version identifier for changes logged in the logging table. The computer system can include a change recorder configured to receive an indicator of a change to a record of the original table during execution of at least a portion of the upgrade of the original table, and a key recorder configured to store in the logging table a primary key identifying the record of the original table and the version identifier stored in the control table.

    摘要翻译: 在一个一般方面,计算机系统可以包括存储在非暂时计算机可读存储介质上的指令。 计算机系统可以包括记录表生成器,其被配置为生成与用于升级的原始表对应的日志记录表,以及控制表生成器,被配置为生成被配置为存储登录表中记录的更改的版本标识符的控制表。 计算机系统可以包括变更记录器,配置成在执行原始表的升级的至少一部分期间接收对原始表的记录的改变的指示符,以及被配置为在记录表中存储的密钥记录器 主键标识原始表的记录和存储在控制表中的版本标识符。

    CHANGE DATA CAPTURING DURING AN UPGRADE
    3.
    发明申请
    CHANGE DATA CAPTURING DURING AN UPGRADE 有权
    在升级过程中更改数据捕获

    公开(公告)号:US20130159247A1

    公开(公告)日:2013-06-20

    申请号:US13325896

    申请日:2011-12-14

    IPC分类号: G06F17/00

    CPC分类号: G06F17/30309 G06F17/30002

    摘要: In one general aspect, a computer system can include instructions stored on a non-transitory computer-readable storage medium. The computer system can include a logging table generator configured to generate a logging table corresponding with an original table targeted for an upgrade, and a control table generator configured to generate a control table configured to store a version identifier for changes logged in the logging table. The computer system can include a change recorder configured to receive an indicator of a change to a record of the original table during execution of at least a portion of the upgrade of the original table, and a key recorder configured to store in the logging table a primary key identifying the record of the original table and the version identifier stored in the control table.

    摘要翻译: 在一个一般方面,计算机系统可以包括存储在非暂时计算机可读存储介质上的指令。 计算机系统可以包括记录表生成器,其被配置为生成与用于升级的原始表对应的记录表,以及控制表生成器,被配置为生成被配置为存储登录表中记录的更改的版本标识符的控制表。 计算机系统可以包括变更记录器,配置成在执行原始表的升级的至少一部分期间接收对原始表的记录的改变的指示符,以及被配置为在记录表中存储的密钥记录器 主键标识原始表的记录和存储在控制表中的版本标识符。

    Systems and methods for mapping large object data content in a database table to a work area
    4.
    发明授权
    Systems and methods for mapping large object data content in a database table to a work area 有权
    将数据库表中的大对象数据内容映射到工作区的系统和方法

    公开(公告)号:US08219561B2

    公开(公告)日:2012-07-10

    申请号:US13295314

    申请日:2011-11-14

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30421

    摘要: According to some embodiments, a programming language in an application server may access different database server implementations, wherein the programming language accesses content of database tables via work areas derived from the database tables. A database table may be mapped to a work area such that each column in the database table is mapped to a corresponding component of the work area (having a default component type based on the column type of the associated column). It may be determined that a particular column in the database table is to store large object data content, and a new mapping to a work area may be defined such that a particular column maps to a corresponding component having a component type other than the default component type.

    摘要翻译: 根据一些实施例,应用服务器中的编程语言可以访问不同的数据库服务器实现,其中编程语言通过从数据库表导出的工作区来访问数据库表的内容。 数据库表可以被映射到工作区,使得数据库表中的每个列被映射到工作区的相应组件(具有基于相关联列的列类型的默认组件类型)。 可以确定数据库表中的特定列是存储大对象数据内容,并且可以定义对工作区的新映射,使得特定列映射到具有除默认组件之外的组件类型的对应组件 类型。

    Systems and method for mapping large object data content in a database table to a work area
    5.
    发明授权
    Systems and method for mapping large object data content in a database table to a work area 有权
    将数据库表中的大对象数据内容映射到工作区的系统和方法

    公开(公告)号:US08135716B2

    公开(公告)日:2012-03-13

    申请号:US12331799

    申请日:2008-12-10

    IPC分类号: G07F17/30

    CPC分类号: G06F17/30421

    摘要: According to some embodiments, a programming language in an application server may include access to different database server implementations, wherein the programming language accesses content of database tables via work areas derived from the database tables. A database table, having columns to store content, each column being associated with a column type, may be mapped to a work area such that, at a database server, each column in the database table is mapped to a corresponding component of the work area, the corresponding component having a default component type based on the column type of the associated column in the database table. It may be determined that a particular column in the database table is to store large object data content, and, in response to the determination, a new mapping to a work area may be defined such that the particular column maps to a corresponding component having a component type other than the default component type.

    摘要翻译: 根据一些实施例,应用服务器中的编程语言可以包括对不同数据库服务器实现的访问,其中编程语言通过从数据库表导出的工作区来访问数据库表的内容。 具有存储内容的列的数据库表,每列与列类型相关联,可以被映射到工作区,使得在数据库服务器处将数据库表中的每一列映射到工作区的对应组件 ,相应的组件具有基于数据库表中关联列的列类型的默认组件类型。 可以确定数据库表中的特定列是存储大对象数据内容,并且响应于该确定,可以定义对工作区的新映射,使得特定列映射到具有 组件类型,而不是默认组件类型。

    System and method for an optimistic database access
    7.
    发明申请
    System and method for an optimistic database access 有权
    用于乐观数据库访问的系统和方法

    公开(公告)号:US20060036574A1

    公开(公告)日:2006-02-16

    申请号:US10917548

    申请日:2004-08-11

    IPC分类号: G06F17/30

    摘要: In an embodiment, a database interface performs a three-step optimistic database access. The database interface initially performs an optimistic read of a database object. The database object is checked for consistency after the optimistic read. If the database object is inconsistent, a first pessimistic read is performed with an isolation level that does not guarantee consistency (e.g., with an isolation level of committed read). The database object is checked again for consistency after the first pessimistic read. If the database object is inconsistent, a second pessimistic read is performed with an isolation level that may guarantee consistency (e.g., with an isolation level of repeatable read).

    摘要翻译: 在一个实施例中,数据库接口执行三步乐观的数据库访问。 数据库接口最初执行数据库对象的乐观读取。 数据库对象在乐观阅读后进行一致性检查。 如果数据库对象不一致,则使用不保证一致性的隔离级别(例如,具有提交读取的隔离级别)执行第一次悲观读取。 在第一次悲观读取之后,再次检查数据库对象的一致性。 如果数据库对象不一致,则使用可以保证一致性(例如,具有可重复读取的隔离级别)的隔离级别执行第二悲观读取。

    System and method for an optimistic database access
    9.
    发明授权
    System and method for an optimistic database access 有权
    用于乐观数据库访问的系统和方法

    公开(公告)号:US07774319B2

    公开(公告)日:2010-08-10

    申请号:US10917548

    申请日:2004-08-11

    IPC分类号: G06F17/00

    摘要: In an embodiment, a database interface performs a three-step optimistic database access. The database interface initially performs an optimistic read of a database object. The database object is checked for consistency after the optimistic read. If the database object is inconsistent, a first pessimistic read is performed with an isolation level that does not guarantee consistency (e.g., with an isolation level of committed read). The database object is checked again for consistency after the first pessimistic read. If the database object is inconsistent, a second pessimistic read is performed with an isolation level that may guarantee consistency (e.g., with an isolation level of repeatable read).

    摘要翻译: 在一个实施例中,数据库接口执行三步乐观的数据库访问。 数据库接口最初执行数据库对象的乐观读取。 数据库对象在乐观阅读后进行一致性检查。 如果数据库对象不一致,则使用不保证一致性的隔离级别(例如,具有提交读取的隔离级别)执行第一次悲观读取。 在第一次悲观读取之后,再次检查数据库对象的一致性。 如果数据库对象不一致,则使用可以保证一致性(例如,具有可重复读取的隔离级别)的隔离级别执行第二悲观读取。

    SYSTEMS AND METHODS FOR MAPPING LARGE OBJECT DATA CONTENT IN A DATABASE TABLE TO A WORK AREA
    10.
    发明申请
    SYSTEMS AND METHODS FOR MAPPING LARGE OBJECT DATA CONTENT IN A DATABASE TABLE TO A WORK AREA 有权
    将数据库中的大量对象数据内容映射到工作区域的系统和方法

    公开(公告)号:US20120096050A1

    公开(公告)日:2012-04-19

    申请号:US13295314

    申请日:2011-11-14

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30421

    摘要: According to some embodiments, a programming language in an application server may access different database server implementations, wherein the programming language accesses content of database tables via work areas derived from the database tables. A database table may be mapped to a work area such that each column in the database table is mapped to a corresponding component of the work area (having a default component type based on the column type of the associated column). It may be determined that a particular column in the database table is to store large object data content, and a new mapping to a work area may be defined such that a particular column maps to a corresponding component having a component type other than the default component type.

    摘要翻译: 根据一些实施例,应用服务器中的编程语言可以访问不同的数据库服务器实现,其中编程语言通过从数据库表导出的工作区来访问数据库表的内容。 数据库表可以被映射到工作区,使得数据库表中的每个列被映射到工作区的相应组件(具有基于相关联列的列类型的默认组件类型)。 可以确定数据库表中的特定列是存储大对象数据内容,并且可以定义对工作区的新映射,使得特定列映射到具有除默认组件之外的组件类型的对应组件 类型。