US 12,277,141 B2
System and method for analysis and management of data distribution in a distributed database environment
Doron Levari, Newton, MA (US); Petr Dvorak, Winchester, MA (US); and Vladimir Vexler, Bat-Yam (IL)
Assigned to Ignite ScalArc Solutions, Inc., Austin, TX (US)
Filed by Ignite ScalArc Solutions, Inc., Austin, TX (US)
Filed on Aug. 4, 2023, as Appl. No. 18/365,942.
Application 18/365,942 is a continuation of application No. 17/747,434, filed on May 18, 2022, granted, now 11,762,882.
Application 17/747,434 is a continuation of application No. 16/423,647, filed on May 28, 2019, granted, now 11,366,829, issued on Jun. 21, 2022.
Application 16/423,647 is a continuation of application No. 14/615,903, filed on Feb. 6, 2015, granted, now 10,303,702, issued on May 28, 2019.
Claims priority of provisional application 61/936,921, filed on Feb. 7, 2014.
Prior Publication US 2023/0376506 A1, Nov. 23, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/278 (2019.01) 17 Claims
OG exemplary drawing
 
1. A system for analysis and management of data distribution in a distributed database environment, comprising:
one or more processors;
a first agent executing on the one of more processors to collect statements between an application and a database located in at least one data server in a plurality of data servers, wherein the statements collected include a command stream; and
a second agent exeuting on the one or more processors to perform operations comprising:
analyze results by analyzing the information including the collected statements, to produce analysis results;
producing analysis results, wherein producing analysis results includes:
identifying in the command stream of the collected statements patterns of command that appear together; and
identifying related tables in the database from the identified patterns of command; and
using the analysis results to produce a data distribution policy having one or more rules for defining logical data chunks of the database that include at least the related tables and for distributing and managing the logical data chunks for storage among the plurality of data servers in a horizontally partitioned database.