-
公开(公告)号:US09672231B2
公开(公告)日:2017-06-06
申请号:US14989480
申请日:2016-01-06
Applicant: Oracle International Corporation
Inventor: Shane Robert Vermette
CPC classification number: G06F17/30315 , G06F17/30067 , G06F17/30312 , G06F17/30321 , G06F21/6218
Abstract: Methods, systems, and computer-readable storage mediums are presented for aggregating multiple values for an object using database rows. Each value added to the database for the object may include a same primary key and a unique sequence key. This allows multiple values to be added for an object concurrently by simply adding additional rows to the database table. After values have been added, a process can identify multiple rows having the same primary key and aggregate the values stored in those rows together into a single database row having the primary key. This can be done as part of a garbage-collection routine or in response to other processes attempting to add additional values for the object.
-
公开(公告)号:US09244961B2
公开(公告)日:2016-01-26
申请号:US13714626
申请日:2012-12-14
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Shane Robert Vermette
CPC classification number: G06F17/30315 , G06F17/30067 , G06F17/30312 , G06F17/30321 , G06F21/6218
Abstract: A method of providing concurrent access to a hierarchy in a data structure may include receiving a request from a first process to change a first value associated with an object, where the request may include a second value to be combined with the first value. The method may also include determining that a second process is currently accessing information associated with the object. The method may additionally include associating, in response to determining that the second process is currently accessing information associated with the object, the second value with the object without combining the first value and the second value.
Abstract translation: 提供对数据结构中的层次结构的并发访问的方法可以包括从第一进程接收到改变与对象相关联的第一值的请求,其中请求可以包括要与第一值组合的第二值。 该方法还可以包括确定第二进程当前正在访问与对象相关联的信息。 所述方法可以另外包括:响应于确定所述第二进程当前正在访问与所述对象相关联的信息,将所述第二值与所述对象相关联而不组合所述第一值和所述第二值。
-
公开(公告)号:US20190220820A1
公开(公告)日:2019-07-18
申请号:US16365451
申请日:2019-03-26
Applicant: Oracle International Corporation
Inventor: Shane Robert Vermette
CPC classification number: G06Q10/10 , G06Q10/063
Abstract: Nested hierarchies can be efficiently analyzed by normalizing a portion of the hierarchy as defined by a limiting factor for the hierarchy. In a project hierarchy wherein each project contains a task hierarchy, each task hierarchy can be normalized. Further, the projects can be assigned to levels such that data for each level can be indexed, partitioned, or otherwise differentiated. The data then can be efficiently rolled up by level using the partially normalized hierarchy.
-
公开(公告)号:US09405636B2
公开(公告)日:2016-08-02
申请号:US13906608
申请日:2013-05-31
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Shane Robert Vermette , Vijay Manguluru , Dinakar Hituvalli
CPC classification number: G06F11/1482 , G06F11/1438 , G06F11/1474
Abstract: A method of recovering batch-based processes may include providing an interface for receiving processes recoverability information. The recoverability information may include (i) information describing a mutual exclusivity of data affected by a process, (ii) information describing sub-processes associated with the process, and/or (iii) information describing scope cleanup procedures associated with the process. The method may also include receiving the recoverability information through the interface, and receiving an indication that the process experienced an error while being executed on a client system. The method may additionally include providing the process recoverability information to make a recoverability determination for the process.
Abstract translation: 恢复基于批处理的进程的方法可以包括提供用于接收进程可恢复性信息的接口。 可恢复性信息可以包括(i)描述受过程影响的数据的相互排他性的信息,(ii)描述与该过程相关联的子过程的信息,和/或(iii)描述与该过程相关联的范围清除过程的信息。 该方法还可以包括通过接口接收可恢复性信息,以及接收在客户机系统上执行时进程经历错误的指示。 该方法可以另外包括提供过程可恢复性信息以对该过程进行可恢复性确定。
-
公开(公告)号:US20160117351A1
公开(公告)日:2016-04-28
申请号:US14989480
申请日:2016-01-06
Applicant: Oracle International Corporation
Inventor: Shane Robert Vermette
IPC: G06F17/30
CPC classification number: G06F17/30315 , G06F17/30067 , G06F17/30312 , G06F17/30321 , G06F21/6218
Abstract: Methods, systems, and computer-readable storage mediums are presented for aggregating multiple values for an object using database rows. Each value added to the database for the object may include a same primary key and a unique sequence key. This allows multiple values to be added for an object concurrently by simply adding additional rows to the database table. After values have been added, a process can identify multiple rows having the same primary key and aggregate the values stored in those rows together into a single database row having the primary key. This can be done as part of a garbage-collection routine or in response to other processes attempting to add additional values for the object.
Abstract translation: 呈现方法,系统和计算机可读存储介质,用于使用数据库行聚合对象的多个值。 添加到对象的数据库的每个值可以包括相同的主键和唯一的序列密钥。 这允许通过简单地向数据库表添加额外的行来并行地为对象添加多个值。 添加值之后,进程可以识别具有相同主键的多个行,并将存储在这些行中的值聚合到具有主键的单个数据库行中。 这可以作为垃圾收集例程的一部分来完成,或响应其他尝试为对象添加额外值的进程。
-
公开(公告)号:US10963839B2
公开(公告)日:2021-03-30
申请号:US16365451
申请日:2019-03-26
Applicant: Oracle International Corporation
Inventor: Shane Robert Vermette
Abstract: Nested hierarchies can be efficiently analyzed by normalizing a portion of the hierarchy as defined by a limiting factor for the hierarchy. In a project hierarchy wherein each project contains a task hierarchy, each task hierarchy can be normalized. Further, the projects can be assigned to levels such that data for each level can be indexed, partitioned, or otherwise differentiated. The data then can be efficiently rolled up by level using the partially normalized hierarchy.
-
-
-
-
-