18468769. QUERY AND DATA ADAPTIVE SYNOPSIS TABLE (INTERNATIONAL BUSINESS MACHINES CORPORATION)
QUERY AND DATA ADAPTIVE SYNOPSIS TABLE
Organization Name
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventor(s)
Oliver Schiller of Dettingen DE
[[:Category:Tobias Kevin Fr�nzel of Tuebingen DE|Tobias Kevin Fr�nzel of Tuebingen DE]][[Category:Tobias Kevin Fr�nzel of Tuebingen DE]]
James Liam Finnie of Renningen DE
[[:Category:Thomas Friedhelm B�hme of Böblingen DE|Thomas Friedhelm B�hme of Böblingen DE]][[Category:Thomas Friedhelm B�hme of Böblingen DE]]
Toni Bollinger of Weil der Stadt DE
Wieland Philipp Hoffmann of Holzgerlingen DE
QUERY AND DATA ADAPTIVE SYNOPSIS TABLE
This abstract first appeared for US patent application 18468769 titled 'QUERY AND DATA ADAPTIVE SYNOPSIS TABLE
Original Abstract Submitted
Aspects of the invention include techniques for providing a query and data adaptive synopsis table. A non-limiting example method includes building a first synopsis table containing metadata for a database table. Information from queries executed against the database table is collected. The collected information is analyzed, responsive to a number of queries executed against the database table exceeding a query collection threshold, to identify one or more queries for which the first synopsis table was suboptimal. The method includes building, for each of the one or more queries for which the first synopsis table was suboptimal, a second synopsis table.