Bank of America Corporation
Resource offloading process using machine learning for database

Abstract:

A resource offloading system comprises a relational database configured to store relational queries including searching features, a server configured to offload the relational queries to non-relational queries, and a non-relational database configured to store the non-relational queries. The server is configured to generate access patterns for each relational query based on searching features included in the relational query, classify the access pattern based on a terminology defined by a searching feature into a classification, rank the classified access patterns, generate candidate access patterns from the ranked access patterns, create non-relational queries based on the candidate access patterns which are ranked beyond a threshold, and store the non-relational queries in the non-relational database.