公开(公告)号：US10303682B2

公开(公告)日：2019-05-28

申请号：US14935345

申请日：2015-11-06

Applicant: Oracle International Corporation

Inventor： Roger MacNicol ,  Amit Ganesh ,  Teck Hua Lee ,  Vineet Marwah ,  Aurosish Mishra

IPC: G06F17/30 ,  G06F16/245 ,  G06F3/06 ,  G06F11/07 ,  G06F11/14 ,  G06F12/0866

Abstract: Techniques are provided for automatic verification of query results obtained from data formatted different from row-major format. Techniques are also provided for automatic triage of query results obtained from data formatted different from row-major format. In an embodiment, the query results may be obtained from querying data formatted in column-major format. In an embodiment, when the query results are determined to be incorrect, a cause of the error in the query results can be automatically identified.

公开(公告)号：US11126620B2

公开(公告)日：2021-09-21

申请号：US16274476

申请日：2019-02-13

Applicant: Oracle International Corporation

Inventor： Roger MacNicol ,  Amit Ganesh ,  Teck Hua Lee ,  Vineet Marwah ,  Aurosish Mishra

IPC: G06F16/245 ,  G06F3/06 ,  G06F11/07 ,  G06F11/14 ,  G06F16/27 ,  G06F16/22 ,  G06F12/0866

Abstract: Techniques are provided for automatic verification of query results obtained from data formatted different from row-major format. Techniques are also provided for automatic triage of query results obtained from data formatted different from row-major format. In an embodiment, the query results may be obtained from querying data formatted in column-major format. In an embodiment, when the query results are determined to be incorrect, a cause of the error in the query results can be automatically identified.

公开(公告)号：US20190179813A1

公开(公告)日：2019-06-13

申请号：US16274476

申请日：2019-02-13

Applicant: Oracle International Corporation

Inventor： Roger MacNicol ,  Amit Ganesh ,  Teck Hua Lee ,  Vineet Marwah ,  Aurosish Mishra

IPC: G06F16/245 ,  G06F3/06 ,  G06F16/27 ,  G06F11/07 ,  G06F11/14 ,  G06F16/22

Abstract: Techniques are provided for automatic verification of query results obtained from data formatted different from row-major format. Techniques are also provided for automatic triage of query results obtained from data formatted different from row-major format. In an embodiment, the query results may be obtained from querying data formatted in column-major format. In an embodiment, when the query results are determined to be incorrect, a cause of the error in the query results can be automatically identified.

公开(公告)号：US10025820B2

公开(公告)日：2018-07-17

申请号：US14480009

申请日：2014-09-08

Applicant: Oracle International Corporation

Inventor： Vineet Marwah ,  Vikram Kapoor ,  Jesse Kamp ,  Kam Shergill ,  Roger MacNicol ,  Sachin Kulkarni ,  Amit Ganesh

IPC: G06F17/30

Abstract: A method and apparatus is provided for optimizing queries received by a database system that relies on an intelligent data storage server to manage storage for the database system. Storing compression units in hybrid columnar format, the storage manager evaluates simple predicates and only returns data blocks containing rows that satisfy those predicates. The returned data blocks are not necessarily stored persistently on disk. That is, the storage manager is not limited to returning disc block images. The hybrid columnar format enables optimizations that provide better performance when processing typical database workloads including both fetching rows by identifier and performing table scans.