公开(公告)号：EP3365811A1

公开(公告)日：2018-08-29

申请号：EP16788924.5

申请日：2016-10-22

Applicant: Oracle International Corporation

Inventor： MACNICOL, Roger D. ,  SHAH, Viral ,  HUA, Xia ,  KAMP, Jesse ,  CHAVAN, Shasank K. ,  COLGAN, Maria ,  LAHIRI, Tirthankar ,  NG, Adrian Tsz Him ,  MEIYYAPPAN, Krishnan ,  GANESH, Amit ,  LOAIZA, Juan R. ,  UMAMAGESWARAN, Kothanda ,  QIN, Yiran

IPC: G06F17/30

CPC classification number: G06F17/30457 ,  G06F3/061 ,  G06F3/0647 ,  G06F3/065 ,  G06F3/067 ,  G06F12/0811 ,  G06F12/0897 ,  G06F17/30312 ,  G06F17/30315 ,  G06F2212/1016 ,  G06F2212/163 ,  G06F2212/225

Abstract: Techniques are provided for storing in in-memory unit (IMU) in a lower-storage tier and copying the IMU to DRAM when needed for query processing. Techniques are also provided for copying IMUs to lower tiers of storage when evicted from the cache of higher tiers of storage. Techniques are provided for implementing functionality of IMUs within a storage system, to enable database servers to push tasks, such as filtering, to the storage system where the storage system may access IMUs within its own memory to perform the tasks. Metadata associated with a set of data may be used to indicate whether an IMU for the data should be created by the database server machine or within the storage system.

公开(公告)号：EP2788901A1

公开(公告)日：2014-10-15

申请号：EP12809022.2

申请日：2012-12-07

Applicant: Oracle International Corporation

Inventor： ELLISON, Lawrence J. ,  GANESH, Amit ,  MARWAH, Vineet ,  KAMP, Jesse ,  PATTHAK, Anindya C. ,  CHAVAN, Shasank K. ,  GLEESON, Michael J. ,  HOLLOWAY, Allison L. ,  BHATTACHARYYA, Manosiz

IPC: G06F17/30

CPC classification number: G06F17/30315 ,  G06F9/3887 ,  G06F17/30339 ,  G06F17/30595

Abstract: Techniques are provided for more efficiently using the bandwidth of the I/O path between a CPU and volatile memory during the performance of database operation. Relational data from a relational table is stored in volatile memory as column vectors, where each column vector contains values for a particular column of the table. A binary-comparable format may be used to represent each value within a column vector, regardless of the data type associated with the column. The column vectors may be compressed and/or encoded while in volatile memory, and decompressed/decoded on-the-fly within the CPU. Alternatively, the CPU may be designed to perform operations directly on the compressed and/or encoded column vector data. In addition, techniques are described that enable the CPU to perform vector processing operations on the column vector values.