System for controlling concurrent access to data in a database system
    1.
    发明授权
    System for controlling concurrent access to data in a database system 有权
    用于控制数据库系统中数据并发访问的系统

    公开(公告)号:US07890482B2

    公开(公告)日:2011-02-15

    申请号:US12117228

    申请日:2008-05-08

    IPC分类号: G06F7/00 G06F17/00

    摘要: A system for controlling concurrency of access to data in a database system is provided. The system includes receiving a lock request for access to data in the database system, in which the lock request is a request for a page lock or a row lock for a corresponding row or page in the database system containing the data. The method further includes identifying a partition in the database system that contains the row or the page in the database system containing the data; associating the lock request with a partition lock on the partition that contains the row or the page in the database system containing the data; and accessing the data using the partition lock.

    摘要翻译: 提供了一种用于控制数据库系统中数据访问并发性的系统。 该系统包括接收对数据库系统中的数据的访问的锁定请求,其中锁定请求是对包含数据的数据库系统中的页面锁定或对于相应行或页面的行锁的请求。 该方法还包括识别数据库系统中包含包含数据的数据库系统中的行或页面的分区; 将锁定请求与包含包含数据的数据库系统中的行或页面的分区上的分区锁相关联; 并使用分区锁访问数据。

    SYSTEM FOR CONTROLLING CONCURRENT ACCESS TO DATA IN A DATABASE SYSTEM
    2.
    发明申请
    SYSTEM FOR CONTROLLING CONCURRENT ACCESS TO DATA IN A DATABASE SYSTEM 有权
    用于控制数据库系统中数据访问的系统

    公开(公告)号:US20090164468A1

    公开(公告)日:2009-06-25

    申请号:US12117228

    申请日:2008-05-08

    IPC分类号: G06F17/30

    摘要: A system for controlling concurrency of access to data in a database system is provided. The system includes receiving a lock request for access to data in the database system, in which the lock request is a request for a page lock or a row lock for a corresponding row or page in the database system containing the data. The method further includes identifying a partition in the database system that contains the row or the page in the database system containing the data; associating the lock request with a partition lock on the partition that contains the row or the page in the database system containing the data; and accessing the data using the partition lock.

    摘要翻译: 提供了一种用于控制数据库系统中数据访问并发性的系统。 该系统包括接收对数据库系统中的数据的访问的锁定请求,其中锁定请求是对包含数据的数据库系统中的页面锁定或对于相应行或页面的行锁的请求。 该方法还包括识别数据库系统中包含包含数据的数据库系统中的行或页面的分区; 将锁定请求与包含包含数据的数据库系统中的行或页面的分区上的分区锁相关联; 并使用分区锁访问数据。

    System and method for selective partition locking
    3.
    发明授权
    System and method for selective partition locking 有权
    选择性分区锁定的系统和方法

    公开(公告)号:US07480653B2

    公开(公告)日:2009-01-20

    申请号:US10817205

    申请日:2004-04-02

    摘要: A method and system for controlling concurrency of access to data in a database system, includes: partitioning a table in the database system into a plurality of partitions; receiving a request for access to data; determining a partition of the plurality of partitions that contains the data; determining if the data has been committed; and if so, avoiding locking the partition in response to the request. By avoiding locking the partition when the data has been committed, the number of partition locks that need to be requested from a local resource lock manager is reduced, improving performance.

    摘要翻译: 一种用于控制对数据库系统中的数据访问的并发性的方法和系统,包括:将所述数据库系统中的表划分成多个分区; 接收访问数据的请求; 确定包含所述数据的所述多个分区的分区; 确定数据是否已提交; 如果是这样,则避免锁定分区以响应该请求。 通过避免在数据提交时锁定分区,减少了需要从本地资源锁管理器请求的分区锁的数量,从而提高了性能。

    METHOD AND SYSTEM FOR CONTROLLING CONCURRENT ACCESS TO DATA IN A DATABASE SYSTEM
    4.
    发明申请
    METHOD AND SYSTEM FOR CONTROLLING CONCURRENT ACCESS TO DATA IN A DATABASE SYSTEM 审中-公开
    用于控制数据库系统中数据访问的方法和系统

    公开(公告)号:US20080010283A1

    公开(公告)日:2008-01-10

    申请号:US11777921

    申请日:2007-07-13

    IPC分类号: G06F17/30

    CPC分类号: G06F16/2343 Y10S707/99938

    摘要: A method and system for controlling concurrency of access to data in a database system is provided. The method includes receiving a lock request for access to data in the database system, in which the lock request is a request for a page lock or a row lock for a corresponding row or page in the database system containing the data. The method further includes identifying a partition in the database system that contains the row or the page in the database system containing the data; associating the lock request with a partition lock on the partition that contains the row or the page in the database system containing the data; and accessing the data using the partition lock.

    摘要翻译: 提供了一种用于控制对数据库系统中数据访问的并发性的方法和系统。 该方法包括接收对数据库系统中的数据的访问的锁定请求,其中锁定请求是对包含数据的数据库系统中的页面锁定或对应的行或页面的行锁的请求。 该方法还包括识别数据库系统中包含包含数据的数据库系统中的行或页面的分区; 将锁定请求与包含包含数据的数据库系统中的行或页面的分区上的分区锁相关联; 并使用分区锁访问数据。

    Providing persistent refined intermediate results selected from dynamic iterative filtering
    5.
    发明授权
    Providing persistent refined intermediate results selected from dynamic iterative filtering 有权
    提供从动态迭代过滤中选择的持久的精细中间结果

    公开(公告)号:US08521711B2

    公开(公告)日:2013-08-27

    申请号:US11611135

    申请日:2006-12-15

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30646

    摘要: A persistent filter refining system places a search result comprising objects in a dynamic non-persistent bucket and displays the search result in a dynamic non-persistent bucket display for selection of the objects by a user. The system transfers a selected object from the dynamic non-persistent bucket to a persistent bucket and displays the transferred selected object in a persistent bucket display. The system iteratively provides additional search results to the user for selection and transfer of additional selected objects to the persistent bucket to provide access by a user to take action on the transferred selected object and additional selected objects. In one embodiment, the present system displays one or more additional search results for comparison and selection of objects by the user.

    摘要翻译: 持久性过滤器精炼系统将包括对象的搜索结果放置在动态非持久桶中,并将搜索结果显示在用于用户选择对象的动态非持久桶显示中。 系统将所选对象从动态非持久桶传输到持久桶,并将所传送的选定对象显示在持久桶显示中。 该系统迭代地向用户提供额外的搜索结果,用于选择并将附加的选定对象传送到持久桶,以提供用户对所传送的选定对象和附加选择对象采取动作的访问。 在一个实施例中,本系统显示一个或多个附加搜索结果,以供用户对对象进行比较和选择。

    TESTING ENVIRONMENT FOR DATABASE SERVER SIDE LOGIC
    8.
    发明申请
    TESTING ENVIRONMENT FOR DATABASE SERVER SIDE LOGIC 失效
    数据库服务器端逻辑测试环境

    公开(公告)号:US20080256126A1

    公开(公告)日:2008-10-16

    申请号:US12124029

    申请日:2008-05-20

    IPC分类号: G06F17/30

    CPC分类号: G06F11/3664

    摘要: A system for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The system eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

    摘要翻译: 用于为数据库服务器端对象提供测试环境的系统持续存储用于数据库服务器侧对象的多个测试运行的简档,其中简档包括持久存储的测试参数值,预执行脚本和/ 执行脚本。 创建配置文件后,可以为一个或多个对象的后续测试运行选择该配置文件。 还可以创建用于对象的多个简档。 该系统不需要手动设置或破坏每个测试运行的测试环境,从而显着提高数据库服务器端对象开发的效率。

    Method and system for displaying actions and historical content in an output view
    9.
    发明授权
    Method and system for displaying actions and historical content in an output view 失效
    在输出视图中显示动作和历史内容的方法和系统

    公开(公告)号:US06938219B2

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

    申请号:US10056559

    申请日:2002-01-25

    IPC分类号: G06F3/14 G06F11/32 G09G5/00

    CPC分类号: G06F11/328 Y10S715/966

    摘要: A method and system for tracking a plurality of actions against at least one object by a computer system is disclosed. The method and system comprises providing an output view, wherein the output view includes a first output area and a second output area. An action list containing each of the plurality of actions is displayed in one of the first and second output areas. A user is allowed to select one action from the action list, and information associated with the selected action is displayed in the other of the first and second output areas.

    摘要翻译: 公开了一种用于通过计算机系统跟踪针对至少一个对象的多个动作的方法和系统。 该方法和系统包括提供输出视图,其中输出视图包括第一输出区域和第二输出区域。 包含多个动作中的每一个的动作列表被显示在第一和第二输出区域之一中。 允许用户从动作列表中选择一个动作,并且与所选动作相关联的信息显示在第一和第二输出区域中的另一个中。