Invention Grant
- Patent Title: Query plan management in shared distributed data stores
-
Application No.: US14679870Application Date: 2015-04-06
-
Publication No.: US09646051B1Publication Date: 2017-05-09
- Inventor: Gavin Sherry , Radhika Reddy , Caleb E. Welton
- Applicant: Pivotal Software, Inc.
- Applicant Address: US CA San Francisco
- Assignee: Pivotal Software, Inc.
- Current Assignee: Pivotal Software, Inc.
- Current Assignee Address: US CA San Francisco
- Agency: Fish & Richardson P.C.
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F17/30

Abstract:
The invention identifies and caches query plans in a shared-nothing distributed data store that are unlikely to become invalid because they do not reference objects that are likely to be changed or deleted. Plans that are likely to become invalid and are not cached are those plans that reference data that is partitioned across segment/query execution nodes of the data store, plans that are complex, and plans that reference objects that are not “built-in” (primitive) objects. The effect is that most plans which are generated on a query dispatch (master) node are not cached, whereas most plans generated on an execution (segment) node are cached.
Information query