Abstract: Implementations are directed to receiving, by an application, query data, the query data indicating a conditional query and a selection of files on which to execute the conditional query; identifying a subset of selected files for which copies of the selected files are not stored in a file database of the application; extracting, from a file system, a copy of each file of the subset of selected files into the file database of the application; parsing the copies of the selected files from the file database into a dataframe; executing the conditional query on the selected files in the dataframe; and providing a result of the conditional query. Actions include executing, by a discovery engine, a discovery process to provide metadata comprising, for a file in the file system: a name of the file; corresponding column names and data types; and a file alias.

Abstract: Methods, systems, and computer-readable storage media for determining for each query in a set of high-cost queries, an access pattern to data objects accessed by the query in a legacy system, determining for each query in a set of low-cost queries, an access pattern to each data object accessed by the query in the legacy system, providing a first set of design patterns representative of first data objects of the legacy system to be offloaded to the target system and a second set of design patterns representative of second data objects of the legacy system to remain on the legacy system, and executing at least one design pattern of the first set of design patterns to offload one or more first data objects to the target system.