会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 8. 发明申请
    • METHOD AND SYSTEM FOR EFFICIENT PERFORMANCE PREDICTION OF STRUCTURED QUERY FOR BIG DATA
    • 用于大数据的结构查询的有效性能预测的方法和系统
    • US20160140171A1
    • 2016-05-19
    • US14663647
    • 2015-03-20
    • Tata Consultancy Services Limited
    • Rekha SINGHAL
    • G06F17/30
    • G06F17/30442G06F17/30477
    • Disclosed is a system for predicting an Elapsed Response Time (ERT) of a query to be executed in a production database. The system includes a database emulator module for creating an emulated database based on empty schema derived by extrapolating statistical information from the development environment. The system also includes an execution plan generation module for generating a query execution plan of the query. The system further includes a query classifying module for classifying each sub-query based on the operational parameters into at least one of a full table scan, a primary index scan, a fast index scan and a non-unique index scan. The system also includes a time determination module for executing each sub-query on the emulated database to determine an Input Output (IO) access time and an operator time. Moreover, the system includes an ERT prediction module for predicting the ERT of the query to be executed in the production database based on the IO access time, the operator time, and a network time.
    • 公开了一种用于预测要在生产数据库中执行的查询的经过响应时间(ERT)的系统。 该系统包括一个数据库仿真器模块,用于基于通过从开发环境推断统计信息而导出的空模式创建仿真数据库。 该系统还包括用于生成查询的查询执行计划的执行计划生成模块。 该系统还包括一个查询分类模块,用于根据操作参数将每个子查询分类为全表扫描,主索引扫描,快速索引扫描和非唯一索引扫描中的至少一个。 该系统还包括用于执行仿真数据库上的每个子查询的时间确定模块,以确定输入输出(IO)访问时间和操作者时间。 此外,该系统包括ERT预测模块,用于基于IO访问时间,运营商时间和网络时间来预测在生产数据库中执行的查询的ERT。