SG11202005197QA - Systems and methods for monitoring execution of structured query language (sql) queries - Google Patents

Systems and methods for monitoring execution of structured query language (sql) queries

Info

Publication number
SG11202005197QA
SG11202005197QA SG11202005197QA SG11202005197QA SG11202005197QA SG 11202005197Q A SG11202005197Q A SG 11202005197QA SG 11202005197Q A SG11202005197Q A SG 11202005197QA SG 11202005197Q A SG11202005197Q A SG 11202005197QA SG 11202005197Q A SG11202005197Q A SG 11202005197QA
Authority
SG
Singapore
Prior art keywords
sql
queries
systems
methods
query language
Prior art date
Application number
SG11202005197QA
Inventor
Glenn John Allin
Ian Robert Schechter
Original Assignee
Ab Initio Technology Llc
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 Ab Initio Technology Llc filed Critical Ab Initio Technology Llc
Publication of SG11202005197QA publication Critical patent/SG11202005197QA/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/32—Monitoring with visual or acoustical indication of the functioning of the machine
    • G06F11/323—Visualisation of programs or trace data
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21—Design, administration or maintenance of databases
    • G06F16/217—Database tuning
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/30—Creation or generation of source code
    • G06F8/34—Graphical or visual programming
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80—Database-specific techniques
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/10—Requirements analysis; Specification techniques

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Quality & Reliability (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • User Interface Of Digital Computer (AREA)
SG11202005197QA 2017-12-08 2018-12-06 Systems and methods for monitoring execution of structured query language (sql) queries SG11202005197QA (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US15/835,823 US11188434B2 (en) 2017-12-08 2017-12-08 Systems and methods for monitoring execution of structured query language (SQL) queries
PCT/US2018/064217 WO2019113293A1 (en) 2017-12-08 2018-12-06 Systems and methods for monitoring execution of structured query language (sql) queries

Publications (1)

Publication Number Publication Date
SG11202005197QA true SG11202005197QA (en) 2020-07-29

Family

ID=64949441

Family Applications (1)

Application Number Title Priority Date Filing Date
SG11202005197QA SG11202005197QA (en) 2017-12-08 2018-12-06 Systems and methods for monitoring execution of structured query language (sql) queries

Country Status (8)

Country Link
US (1) US11188434B2 (en)
EP (1) EP3721338A1 (en)
JP (1) JP2021506043A (en)
CN (1) CN111492344B (en)
AU (1) AU2018380147B2 (en)
CA (1) CA3082186A1 (en)
SG (1) SG11202005197QA (en)
WO (1) WO2019113293A1 (en)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110612513B (en) 2017-03-29 2024-01-30 起元技术有限责任公司 System and method for performing data processing operations in parallel using variable stages
TW202042242A (en) * 2019-05-07 2020-11-16 大陸商深圳大心電子科技有限公司 Data reading method, storage controller and storage device
CN111290929B (en) * 2020-02-10 2023-06-27 珠海图思科软件有限公司 Test method, computer device and computer readable storage medium for equivalent SQL statement performance
US11645284B2 (en) 2020-03-16 2023-05-09 International Business Machines Corporation Distributed join filters in a dynamic distributed data processing service
US11971909B2 (en) 2021-01-31 2024-04-30 Ab Initio Technology Llc Data processing system with manipulation of logical dataset groups

Family Cites Families (30)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5966072A (en) 1996-07-02 1999-10-12 Ab Initio Software Corporation Executing computations expressed as graphs
US6438741B1 (en) 1998-09-28 2002-08-20 Compaq Computer Corporation System and method for eliminating compile time explosion in a top down rule based system using selective sampling
JP2003256221A (en) 2002-02-28 2003-09-10 Fujitsu Ltd Parallel process executing method and multi-processor type computer
US7249141B2 (en) 2003-04-30 2007-07-24 Microsoft Corporation Automated layout of relational databases
US7155612B2 (en) * 2003-04-30 2006-12-26 International Business Machines Corporation Desktop database data administration tool with row level security
US20060095406A1 (en) * 2004-10-29 2006-05-04 International Business Machines Corporation Displaying explain data for a SQL query of a database
US7716630B2 (en) 2005-06-27 2010-05-11 Ab Initio Technology Llc Managing parameters for graph-based computations
US7870556B2 (en) 2006-05-16 2011-01-11 Ab Initio Technology Llc Managing computing resources in graph-based computations
US20080140622A1 (en) 2006-12-12 2008-06-12 Bestgen Robert J Displaying Explain Data for a SQL Query of a Database
US20090077013A1 (en) * 2007-09-19 2009-03-19 International Business Machines Corporation Methods, systems, and computer program products for user-driven targeted query re-optimizations using delta values
US7979578B2 (en) 2009-09-02 2011-07-12 International Business Machines Corporation Dynamic and evolutionary placement in an event-driven component-oriented network data processing system
US9208141B2 (en) * 2010-02-05 2015-12-08 Oracle International Corporation Generating and displaying active reports
US8356027B2 (en) 2010-10-07 2013-01-15 Sap Ag Hybrid query execution plan generation and cost model evaluation
US8195643B2 (en) 2010-10-28 2012-06-05 Sap Ag Database calculation engine
US9116955B2 (en) * 2011-05-02 2015-08-25 Ab Initio Technology Llc Managing data queries
US8838579B2 (en) 2012-04-26 2014-09-16 Sap Ag Data flow graph optimization using adaptive rule chaining
US8856766B2 (en) 2012-05-11 2014-10-07 International Business Machines Corporation Generating layouts for graphs of data flow applications
CN103713958B (en) * 2012-09-28 2016-12-21 国际商业机器公司 Method and apparatus at the machinery compartment synchronizing pattern operating user interface of different language
US10515118B2 (en) 2013-06-24 2019-12-24 Micro Focus Llc Processing a data flow graph of a hybrid flow
US20150039587A1 (en) * 2013-07-31 2015-02-05 Oracle International Corporation Generic sql enhancement to query any semi-structured data and techniques to efficiently support such enhancements
JP6204753B2 (en) * 2013-08-28 2017-09-27 Kddi株式会社 Distributed query processing apparatus, processing method, and processing program
US9990398B2 (en) 2013-09-20 2018-06-05 Oracle International Corporation Inferring dimensional metadata from content of a query
WO2017019879A1 (en) 2015-07-29 2017-02-02 Algebraix Data Corp. Multi-query optimization
US10657134B2 (en) 2015-08-05 2020-05-19 Ab Initio Technology Llc Selecting queries for execution on a stream of real-time data
US10133778B2 (en) 2015-11-20 2018-11-20 Sap Se Query optimization using join cardinality
US10877816B2 (en) 2016-04-20 2020-12-29 Samsung Electronics Co., Ltd. Optimal task scheduler
US10437821B2 (en) 2016-10-26 2019-10-08 Sap Se Optimization of split queries
US10528599B1 (en) 2016-12-16 2020-01-07 Amazon Technologies, Inc. Tiered data processing for distributed data
US9798527B1 (en) 2017-01-06 2017-10-24 Google Inc. Loop and library fusion
CN110612513B (en) 2017-03-29 2024-01-30 起元技术有限责任公司 System and method for performing data processing operations in parallel using variable stages

Also Published As

Publication number Publication date
AU2018380147A1 (en) 2020-05-21
US11188434B2 (en) 2021-11-30
WO2019113293A1 (en) 2019-06-13
CA3082186A1 (en) 2019-06-13
AU2018380147B2 (en) 2024-05-02
CN111492344B (en) 2023-10-24
CN111492344A (en) 2020-08-04
EP3721338A1 (en) 2020-10-14
US20190179723A1 (en) 2019-06-13
JP2021506043A (en) 2021-02-18

Similar Documents

Publication Publication Date Title
SG11202005197QA (en) Systems and methods for monitoring execution of structured query language (sql) queries
EP3545435A4 (en) Database system and method for compiling serial and parallel database query execution plans
HK1254071A1 (en) Systems and methods of secure provenance for distributed transaction databases
EP3718024A4 (en) High-throughput distributed transaction management for globally consistent sharded oltp system and method of implementing
IL239717A0 (en) System and method for distributed database query engines
EP3134821A4 (en) System and method for parallel optimization of database query using cluster cache
GB201815317D0 (en) Method and system for replicating data to heterogeneous database and detecting synchronization error of heterogeneous database through SQL packet analysis
EP3170107A4 (en) Systems and methods for searching a machining knowledge database
IL279651A (en) Systems and methods for translating natural language sentences into database queries
EP3679683A4 (en) Systems and methods of providing immutable records
EP3456360A4 (en) Device and method for tuning relational database
EP3403170A4 (en) Methods and systems for search engines selection&optimization
GB201615745D0 (en) System for analysing data relationships to support query execution
EP3039574A4 (en) Queries involving multiple databases and execution engines
EP3077918A4 (en) Systems and methods for in-memory database search
GB2542053A (en) Automatically generating a semantic mapping for a relational database
EP3341865A4 (en) System and method for database query
EP3954407C0 (en) Systems and methods for optimization of plasma collection volumes
EP3850559A4 (en) Systems and methods for graph-based query analysis
BR112017001758A2 (en) directly compressible polyvinyl alcohols
EP2981908A4 (en) Query integration across databases and file systems
EP2948890A4 (en) System and method for database searching
EP3221799A4 (en) Systems and methods for search query rewrites
GB201805731D0 (en) Systems and methods for multi-dimensional computer-aided searching
GB201504536D0 (en) A method and system for efficient peformance prediction of structured query for big data