05-12-2019 дата публикации
Номер: US20190370255A1
Принадлежит:
Embodiments of the present invention provide systems and methods for remote query optimization in multi data sources. The method includes receiving a database query from a remote source requesting data-points from multiple data sources. The method further includes receiving and analyzing the data-points, creating a data set based on the analysis, and transmitting the data set to the remote source. 1. A computer-implemented method for remote query optimization in multi data sources , the computer-implemented method comprising:creating a data set from analyzed one or more groupings of data-points for two or more data sources,transmitting the data set to the remote source; mapping a real number for each of the one or more groupings of data-points,', 'compare each of the groupings from the two or more data sources,', 'converting non-integer data-points to integer values, and', 'computing the mapping function using a recursive equation, 'mapping functions for each of the one or more groupings of data-points, wherein mapping functions for each of the one or more groupings of data-points comprisescomputing a value for each of the one or more mapped functions of the one or more groupings of data-points, wherein the value is based, at least in part, on the mapped functions; andcreating the data set using the values for each of the one or more mapped functions of the one or more groupings of data-points.2. The computer-implemented method of claim 1 , wherein the recursive equation comprises: G(C1)=g(C1) claim 1 , G(C1 claim 1 , C2)=g(C1)+F(G(C2 claim 1 , C3 claim 1 , . . . claim 1 , CN)) claim 1 , . . . claim 1 , G(C1 claim 1 , C2 claim 1 , . . . claim 1 , Cn)=g(C1)+F(G(C2 claim 1 , C3 claim 1 , . . . claim 1 , Cn)) claim 1 , where C1 claim 1 , C2 claim 1 , . . . claim 1 , CN are the groupings for a join claim 1 , g(Ci) is a mapping function for column Ci to convert Ci to integer values claim 1 , F(x) is the probability distribution function claim 1 , and G( ) is the final ...
Подробнее