A system and method for analysis and management of data distribution in a distributed database environment. A method may include analyzing information related to transactions between an application and a plurality of data storage systems to produce analysis results. Analysis results may be used to produce a set of rules for defining logical data chunks. A logical data chunk may include at least a portion a data set stored in the plurality of data storage systems. A data distribution policy may be defined based on the set of rules. Other embodiments are described and claimed.