Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A method and system for efficient performance prediction of structured query for big data

A database and sub-query technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as inability to accurately predict response time

Active Publication Date: 2016-10-19
TATA CONSULTANCY SERVICES LTD
View PDF3 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, such a model cannot accurately predict the response time of queries as the amount of data increases linearly within a certain period of time.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A method and system for efficient performance prediction of structured query for big data
  • A method and system for efficient performance prediction of structured query for big data
  • A method and system for efficient performance prediction of structured query for big data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] Some embodiments of the present disclosure showing all their functionality will now be discussed in detail. The words "comprising," "having," "comprising," and "comprising," and other forms thereof, are intended to mean equivalents in meaning and their openness ends when any of these words is followed by an item One or more items is not meant to be an exhaustive list of the item or items, or to be limited to an exhaustive list of only one or more of the items listed. It must also be noted that, as used herein and in the appended claims, the singular forms "a," "an," and "the" include plural referents unless the context clearly dictates otherwise. Although any systems and methods similar or equivalent to those described herein can be used in the practice or testing of embodiments of the present disclosure, exemplary systems and methods are now described. The disclosed embodiments are merely examples of the disclosure, which may be embodied in various forms.

[0018] Va...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

A system for predicting an Elapsed Response Time (ERT) of a query to be executed in a production database comprises a db emulator module for creating an emulated database based on empty schema derived by extrapolating statistical information from the development environment, an execution plan generation module for generating a query execution plan of the query, 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, 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, and an ERT prediction module for predicting the ERT of the query to be executed in the production database based on the I0 access time, the operator time, and a network time.

Description

[0001] priority information [0002] This patent application claims priority from Indian Patent Application No. 3600 / MUM / 2014 filed on November 14, 2014. technical field [0003] The disclosure described herein relates generally to a database management system, and more particularly, to a database management system for predicting elapsed response times of queries to be executed in an off-the-shelf database. Background technique [0004] The big data paradigm has led to impactful performance of applications due to large amounts of data. The performance of the application has been evaluated based on various parameters. A key parameter that is convenient for evaluating performance is the response time of queries. For structured database applications, the response time of queries is tested against a subset of the large amount of data deployed in the production database. It is generally accepted that sometimes the response time in such database applications may increase non-li...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2453G06F16/2455
Inventor 列哈·辛哈尔
Owner TATA CONSULTANCY SERVICES LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com