Invention Grant
- Patent Title: Data model design supporting low latency time-series volume planning and analysis
-
Application No.: US17034819Application Date: 2020-09-28
-
Publication No.: US11243966B1Publication Date: 2022-02-08
- Inventor: Carey Kai-Bun Wong
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Holland & Hart LLP
- Main IPC: G06F16/2458
- IPC: G06F16/2458 ; G06F16/242 ; G06F16/28 ; G06F16/23

Abstract:
Methods, systems, and devices supporting data storage are described. A database system may implement a hierarchical organization in which child data objects store hierarchical data for parent data objects. However, to support low latency time-series volume planning and analysis, the database system may additionally store a data object with a first set of data fields that includes object-specific data for the data object and a second set of data fields that includes hierarchical data (e.g., time-based hierarchical data organized into separate data fields for different time segments) for the data object. The database system may support both transactions and analytical queries using the data model. For example, the database system may receive a query indicating a time period for predictive analysis and may execute the query on the second set of data fields for the data object (e.g., without searching for child data objects storing the time-based hierarchical data).
Information query