IN2013MU02853A - - Google Patents

Download PDF

Info

Publication number
IN2013MU02853A
IN2013MU02853A IN2853MU2013A IN2013MU02853A IN 2013MU02853 A IN2013MU02853 A IN 2013MU02853A IN 2853MU2013 A IN2853MU2013 A IN 2853MU2013A IN 2013MU02853 A IN2013MU02853 A IN 2013MU02853A
Authority
IN
India
Prior art keywords
database
query
emulated
access
parameters
Prior art date
Application number
Inventor
Rekha Singhal
Manoj Karunakaran Nambiar
Original Assignee
Tata Consultancy Services Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Tata Consultancy Services Ltd filed Critical Tata Consultancy Services Ltd
Priority to IN2853MU2013 priority Critical patent/IN2013MU02853A/en
Priority to SG2013091160A priority patent/SG2013091160A/en
Priority to EP13196083.3A priority patent/EP2843599A1/en
Priority to US14/105,305 priority patent/US9117030B2/en
Priority to CN201310713239.9A priority patent/CN104424347A/en
Priority to JP2013264633A priority patent/JP6110785B2/en
Publication of IN2013MU02853A publication Critical patent/IN2013MU02853A/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Preventing errors by testing or debugging software
    • G06F11/3668—Software testing
    • G06F11/3696—Methods or tools to render software testable
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/04—Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem"

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Economics (AREA)
  • Strategic Management (AREA)
  • Theoretical Computer Science (AREA)
  • Quality & Reliability (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Operations Research (AREA)
  • Game Theory and Decision Science (AREA)
  • Tourism & Hospitality (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Development Economics (AREA)
  • Computer Hardware Design (AREA)
  • General Engineering & Computer Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Debugging And Monitoring (AREA)

Abstract

A system, method and computer program product to predict elapsed response time of a query during an application stage is disclosed. The query is executed over a database and is classified based on a mode of access of the database by the query. The database is emulated to obtain an emulated database. After classification, an access pattern of the database by the query along with one or more parameters is determined. By applying a classification specific technique over the access pattern and the one or more parameters, an input-access time of the query on the emulated database is then calculated to determine the elapsed response time of the query.
IN2853MU2013 2013-09-02 2013-09-02 IN2013MU02853A (en)

Priority Applications (6)

Application Number Priority Date Filing Date Title
IN2853MU2013 IN2013MU02853A (en) 2013-09-02 2013-09-02
SG2013091160A SG2013091160A (en) 2013-09-02 2013-12-05 System and method to predict elapsed response time for a query during application development stage
EP13196083.3A EP2843599A1 (en) 2013-09-02 2013-12-06 System and method to predict elapsed response time for a query during application development stage
US14/105,305 US9117030B2 (en) 2013-09-02 2013-12-13 System and method to predict elapsed response time for a query during application development stage
CN201310713239.9A CN104424347A (en) 2013-09-02 2013-12-20 System and method to predict elapsed response time for a query during application development stage
JP2013264633A JP6110785B2 (en) 2013-09-02 2013-12-20 System and method for predicting elapsed response time for query in application development stage

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
IN2853MU2013 IN2013MU02853A (en) 2013-09-02 2013-09-02

Publications (1)

Publication Number Publication Date
IN2013MU02853A true IN2013MU02853A (en) 2015-07-03

Family

ID=49726594

Family Applications (1)

Application Number Title Priority Date Filing Date
IN2853MU2013 IN2013MU02853A (en) 2013-09-02 2013-09-02

Country Status (6)

Country Link
US (1) US9117030B2 (en)
EP (1) EP2843599A1 (en)
JP (1) JP6110785B2 (en)
CN (1) CN104424347A (en)
IN (1) IN2013MU02853A (en)
SG (1) SG2013091160A (en)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9535704B2 (en) * 2014-02-03 2017-01-03 University Of Rochester System and method to quantify digital data sharing in a multi-threaded execution
AU2015201361B2 (en) * 2014-11-14 2017-03-02 Tata Consultancy Services Limited A method and system for efficient performance prediction of structured query for big data
CN108370324B (en) 2015-11-13 2021-09-03 电子湾有限公司 Distributed database operation data tilt detection
US10025698B2 (en) 2015-11-16 2018-07-17 Cognizant Technology Solutions India Pvt. Ltd System and method for efficiently predicting testing schedule and stability of applications
US20190042573A1 (en) * 2017-08-01 2019-02-07 Salesforce.Com, Inc. Rules-based synchronous query processing for large datasets in an on-demand environment
US11068483B2 (en) 2017-08-01 2021-07-20 Salesforce.Com, Inc. Dynamic selection and application of rules for processing of queries in an on-demand environment
US11314741B2 (en) 2017-08-01 2022-04-26 Salesforce.Com, Inc. Metadata-based statistics-oriented processing of queries in an on-demand environment
CN110019218B (en) * 2017-12-08 2023-08-25 阿里巴巴集团控股有限公司 Data storage and query method and equipment
CN114179366B (en) * 2021-12-13 2024-02-06 南京铖联激光科技有限公司 Part printing time evaluation system and evaluation method based on 3D printing
KR102679218B1 (en) * 2023-09-26 2024-06-28 쿠팡 주식회사 Method for sharding table for managing data and electronic apparatus therefor

Family Cites Families (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5758144A (en) * 1994-06-24 1998-05-26 International Business Machines Corporation Database execution cost and system performance estimator
IT1275529B (en) * 1995-07-14 1997-08-07 Alcatel Italia EMULATOR FOR A RELATIONAL DATABASE IN SQL LANGUAGE
US7246111B1 (en) * 2000-06-30 2007-07-17 Ncr Corporation Capturing database system information
US6738756B1 (en) * 2000-06-30 2004-05-18 Ncr Corporation Analysis method and apparatus for a parallel system
US6799175B2 (en) 2001-04-23 2004-09-28 International Business Machines Corporation System and method of determining and searching for patterns in a large database
US6795817B2 (en) 2001-05-31 2004-09-21 Oracle International Corporation Method and system for improving response time of a query for a partitioned database object
JP5088668B2 (en) * 2007-03-08 2012-12-05 日本電気株式会社 Computer load estimation system, computer load estimation method, computer load estimation program
US7895192B2 (en) 2007-07-19 2011-02-22 Hewlett-Packard Development Company, L.P. Estimating the loaded execution runtime of a database query
US9189523B2 (en) 2008-07-05 2015-11-17 Hewlett-Packard Development Company, L.P. Predicting performance of multiple queries executing in a database
CN101419625B (en) * 2008-12-02 2012-11-28 西安交通大学 Deep web self-adapting crawling method based on minimum searchable mode
US8244715B2 (en) 2009-04-09 2012-08-14 Paraccel, Inc. System and method for processing database queries
US8930918B2 (en) * 2010-05-18 2015-01-06 Tata Consultancy Services Limited System and method for SQL performance assurance services
CN102436494B (en) * 2011-11-11 2013-05-01 中国工商银行股份有限公司 Device and method for optimizing execution plan and based on practice testing

Also Published As

Publication number Publication date
JP2015049891A (en) 2015-03-16
CN104424347A (en) 2015-03-18
EP2843599A1 (en) 2015-03-04
JP6110785B2 (en) 2017-04-05
US20150067646A1 (en) 2015-03-05
US9117030B2 (en) 2015-08-25
SG2013091160A (en) 2015-04-29

Similar Documents

Publication Publication Date Title
IN2013MU02853A (en)
PH12017550014B1 (en) Methods for understanding incomplete natural language query
WO2014110167A3 (en) Integrated machine learning for a data management product
MX2015012272A (en) Stress-strain relationship simulation method, spring back prediction method, and spring back analyzing device.
WO2015196133A3 (en) Energy infrastructure sensor data rectification using regression models
IN2015CH05184A (en)
CA2961145C (en) Casing wear prediction using integrated physics-driven and data-driven models
MX2016014224A (en) Configuring workflows in a host device operating in a process control system.
WO2013134046A3 (en) Application level speculative processing
WO2014110370A3 (en) Method and apparatus of identifying a website user
WO2015017276A3 (en) Method and system for providing recommended terms
MX2015012847A (en) Systems and methods for texture assessment of a coating formulation.
GB2564975A (en) User interface element for surfacing related results
GB2543183A (en) Improvements related to forecasting systems
PH12016501926B1 (en) Program for predicting day of ovulation and method of predicting the same
WO2015130675A3 (en) Apparatus and method for testing computer program implementation against a design model
TW201611877A (en) Computer-implemented method for determining game mechanics in business process gamification
MX2014012857A (en) Automated generation and dynamic update of rules.
MX2015015328A (en) Detecting edge cracks.
SE1751288A1 (en) Method of controlling an electronic device
TW201711736A (en) Information distribution methods, computer readable media, and information distribution servers
SE1751355A1 (en) Method of controlling an electronic device
WO2012112534A3 (en) Learning to predict effects of compounds on targets
NO341675B1 (en) A method and system for removing a core sample from a borehole
WO2014137893A3 (en) Interactive healthcare modeling