首页>
外国专利>
Data lake workload optimization through index modeling and recommendation
Data lake workload optimization through index modeling and recommendation
展开▼
机译:通过索引建模和推荐优化数据湖工作负载
展开▼
页面导航
摘要
著录项
相似文献
摘要
Methods, systems and computer program products are described herein that enable data workload optimization through “what-if” modeling of indexes and index recommendation. In an example aspect, a system is configured to accept a workload in the form of a plurality of data queries, extract indexable columns from the queries, generate candidate indexes from the indexable columns, select and then build the best candidate indexes. Furthermore, the system may receive a query, generate a query plan for the query configured to use one or more of the built candidate indexes, and execute the query plan to generate a query result.
展开▼