发明申请
- 专利标题: TABLE-PER-PARTITION
-
申请号: US15586119申请日: 2017-05-03
-
公开(公告)号: US20180322127A1公开(公告)日: 2018-11-08
- 发明人: Joseph Michael Davis , Joey Mart
- 申请人: ServiceNow, Inc.
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
The present approach improves the query performance of a database in a manner that is transparent to a user. In one aspect, this approach creates separate partition tables that are not directly accessible to a user of the database. A client-facing aspect of the database is a logical model which may correspond to a single, main table with which the user interacts. Thus, queries or operations may be generated on the client side in the context of the logical model. A database or query layer can then, transparent to the user, translate the user generated requests into query language that addresses the proper partitions to generate a result set or otherwise perform a database operation.
公开/授权文献
- US10936613B2 Table-per-partition 公开/授权日:2021-03-02