Data consistency management

A data consistency management system comprising:

• a memory storing machine readable instructions executed by at least one hardware processor to:
• receive a query;
• determine a suitability of the query for processing by a relational database management system (RDBMS) by
• ranking data tables based on a combination of read queries for the data tables and query patterns suitable for a not-only structured query language (NoSQL) data store for the data tables, at least one of the data tables containing information for responding to the query,
• based on the ranking, determining data tables from the ranked data tables that are to be managed by the NoSQL data store, or by the RDBMS, and
• determining whether the query is for at least one data table managed by the RDBMS;
• and
• in response to a determination that the query is for the at least one data table managed by the RDBMS, forward the query to the RDBMS for processing the query.

A method for data consistency management, the method comprising:

• receiving a query;
• determining, by a processor, a suitability of the query for processing by a relational database management system (RDBMS) by
• ranking data tables based on a combination of read queries for the data tables and query patterns suitable for a not-only structured query language (NoSQL) data store for the data tables, at least one of the data tables containing information for responding to the query,
• outputting the ranked data tables for selection for management by the NoSQL data store,
• receiving selection of data tables from the ranked data tables that are to be managed by the NoSQL data store,
• assigning the selected data tables from the ranked data tables for management by the NoSQL data store, and remaining data tables from the ranked data tables for management by the RDBMS, and
• determining whether the query is for at least one data table managed by the RDBMS;
• and
• in response to a determination that the query is for the at least one data table managed by the RDBMS, forwarding the query to the RDBMS for processing the query.

A non-transitory computer readable medium having stored thereon machine readable instructions for data consistency management, the machine readable instructions when executed cause a computer system to:

• receive a query;
• determine a suitability of the query for processing by a relational database management system (RDBMS), wherein a not-only structured query language (NoSQL) data store provides lower data consistency than the RDBMS, by
• ranking, by a processor, data tables based on a combination of read queries for the data tables and query patterns suitable for the NoSQL data store for the data tables, at least one of the data tables containing information for responding to the query, and
• based on the ranking, determining data tables from the ranked data tables that are to be managed by the NoSQL data store, or by the RDBMS;
• and
• use, based on a determination that the query is for at least one data table managed by the RDBMS, the RDBMS to respond to the query.