Invention Grant
- Patent Title: Hybrid dynamic database schema
-
Application No.: US17039466Application Date: 2020-09-30
-
Publication No.: US11620265B2Publication Date: 2023-04-04
- Inventor: Yifei Hong , Xiaoyun DePrano
- Applicant: BANK OF AMERICA CORPORATION
- Applicant Address: US NC Charlotte
- Assignee: BANK OF AMERICA CORPORATION
- Current Assignee: BANK OF AMERICA CORPORATION
- Current Assignee Address: US NC Charlotte
- Agency: Moore & Van Allen PLLC
- Agent James C. Edwards
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/21 ; G06F16/2453 ; G06F16/2455 ; G06F16/22

Abstract:
A hybrid dynamic database schema is described. The schema is a hybrid of both horizontal and vertical database schema, in that, while a vertical schema has only one dimension—dimension value pair per table/record, the hybrid schema of the present invention provides for multiple dimension—dimension value pairs per table/record. The schema provides for additional fields, so called “DimSet” fields, with each additional field comprising one and typically multiple dimension—dimension value pairs. Thus, while a vertical database schema can only perform aggregation/segregation using one isolated dimension—dimension pair, the hybrid schema of the present invention is capable of performing multiple aggregations/segregation processes simultaneously (i.e., in parallel) using the multiple dimension fields. The dynamic nature of the database schema is realized by the ability of the schema to support various different additional fields (i.e., additional “DimSet” fields) with different combinations of dimension-dimension value pairs.
Public/Granted literature
- US20220100713A1 HYBRID DYNAMIC DATABASE SCHEMA Public/Granted day:2022-03-31
Information query