公开(公告)号：US20150088824A1

公开(公告)日：2015-03-26

申请号：US14337045

申请日：2014-07-21

Applicant: Oracle International Corporation

Inventor： Jesse Kamp ,  Vineet Marwah ,  Amit Ganesh ,  Michael Gleeson ,  Maheswaran Venkatachalam ,  Allison Holloway ,  Niloy Mukherjee ,  Sanket Hase

IPC: G06F17/30

CPC classification number: G06F17/30315 ,  G06F3/0604 ,  G06F3/064 ,  G06F3/065 ,  G06F3/0689 ,  G06F12/0815 ,  G06F12/1018 ,  G06F15/78 ,  G06F15/8007 ,  G06F15/8076 ,  G06F15/8084 ,  G06F17/30312 ,  G06F17/30377 ,  G06F17/30477 ,  G06F17/30595 ,  G06F2003/0697 ,  G06F2212/1021 ,  G06F2212/1032 ,  G06F2212/2542 ,  G06F2212/313

Abstract: Techniques are provided for granular load and refresh of columnar data. In an embodiment, a particular data object that contains particular data formatted different from column-major format is maintained, the particular data including first data and second data. First and second data objects contain the first and second data, respectively, organized in the column-major format. In response to changes being committed to the first data in the particular data object, invalidating one or more rows of the first data object. In response to a number of invalidated rows of the first data object exceeding a threshold, automatically performing a refresh operation on the first data object independent of any refresh operation on the second data object.

Abstract translation: 提供了粒度负载和刷新柱状数据的技术。 在一个实施例中，保持包含格式不同于列主格式的特定数据的特定数据对象，该特定数据包括第一数据和第二数据。 第一和第二数据对象分别包含以列主格式组织的第一和第二数据。 响应于对特定数据对象中的第一数据提交的更改，使第一数据对象的一行或多行无效。 响应于第一数据对象的多个无效行超过阈值，自动对第一数据对象执行刷新操作，而与第二数据对象上的任何刷新操作无关。

公开(公告)号：US09606921B2

公开(公告)日：2017-03-28

申请号：US14337045

申请日：2014-07-21

Applicant: Oracle International Corporation

Inventor： Jesse Kamp ,  Vineet Marwah ,  Amit Ganesh ,  Michael Gleeson ,  Maheswaran Venkatachalam ,  Allison Holloway ,  Niloy Mukherjee ,  Sanket Hase

IPC: G06F17/30 ,  G06F12/0815 ,  G06F15/78 ,  G06F12/1018 ,  G06F3/06

CPC classification number: G06F17/30315 ,  G06F3/0604 ,  G06F3/064 ,  G06F3/065 ,  G06F3/0689 ,  G06F12/0815 ,  G06F12/1018 ,  G06F15/78 ,  G06F15/8007 ,  G06F15/8076 ,  G06F15/8084 ,  G06F17/30312 ,  G06F17/30377 ,  G06F17/30477 ,  G06F17/30595 ,  G06F2003/0697 ,  G06F2212/1021 ,  G06F2212/1032 ,  G06F2212/2542 ,  G06F2212/313

Abstract: Techniques are provided for granular load and refresh of columnar data. In an embodiment, a particular data object that contains particular data formatted different from column-major format is maintained, the particular data including first data and second data. First and second data objects contain the first and second data, respectively, organized in the column-major format. In response to changes being committed to the first data in the particular data object, invalidating one or more rows of the first data object. In response to a number of invalidated rows of the first data object exceeding a threshold, automatically performing a refresh operation on the first data object independent of any refresh operation on the second data object.