GB2378534B - SQL execution analysis - Google Patents

SQL execution analysis

Info

Publication number
GB2378534B
GB2378534B GB0119021A GB0119021A GB2378534B GB 2378534 B GB2378534 B GB 2378534B GB 0119021 A GB0119021 A GB 0119021A GB 0119021 A GB0119021 A GB 0119021A GB 2378534 B GB2378534 B GB 2378534B
Authority
GB
United Kingdom
Prior art keywords
execution analysis
sql execution
sql
analysis
execution
Prior art date
Legal status (The legal status 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 status listed.)
Expired - Lifetime
Application number
GB0119021A
Other versions
GB0119021D0 (en
GB2378534A (en
Inventor
David Harris
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Oracle Corp
Original Assignee
Oracle Corp
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 Oracle Corp filed Critical Oracle Corp
Priority to GB0119021A priority Critical patent/GB2378534B/en
Publication of GB0119021D0 publication Critical patent/GB0119021D0/en
Priority to US09/968,913 priority patent/US6708185B2/en
Publication of GB2378534A publication Critical patent/GB2378534A/en
Application granted granted Critical
Publication of GB2378534B publication Critical patent/GB2378534B/en
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Classifications

    • 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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462—Approximate or statistical queries
    • 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
    • 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/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24542—Plan optimisation
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99944—Object-oriented database structure
    • Y10S707/99945—Object-oriented database structure processing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99948—Application of database or data structure, e.g. distributed, multimedia, or image

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Operations Research (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
GB0119021A 2001-08-03 2001-08-03 SQL execution analysis Expired - Lifetime GB2378534B (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
GB0119021A GB2378534B (en) 2001-08-03 2001-08-03 SQL execution analysis
US09/968,913 US6708185B2 (en) 2001-08-03 2001-10-03 SQL execution analysis

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
GB0119021A GB2378534B (en) 2001-08-03 2001-08-03 SQL execution analysis

Publications (3)

Publication Number Publication Date
GB0119021D0 GB0119021D0 (en) 2001-09-26
GB2378534A GB2378534A (en) 2003-02-12
GB2378534B true GB2378534B (en) 2003-08-20

Family

ID=9919794

Family Applications (1)

Application Number Title Priority Date Filing Date
GB0119021A Expired - Lifetime GB2378534B (en) 2001-08-03 2001-08-03 SQL execution analysis

Country Status (2)

Country Link
US (1) US6708185B2 (en)
GB (1) GB2378534B (en)

Families Citing this family (21)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7228300B2 (en) 1998-10-05 2007-06-05 Oracle International Corporation Caching the results of security policy functions
US20050049999A1 (en) * 2003-08-29 2005-03-03 Immo-Gert Birn Database access statement tracing
US7676453B2 (en) * 2004-04-22 2010-03-09 Oracle International Corporation Partial query caching
US20060074872A1 (en) * 2004-09-30 2006-04-06 International Business Machines Corporation Adaptive database buffer memory management using dynamic SQL statement cache statistics
US7725461B2 (en) * 2006-03-14 2010-05-25 International Business Machines Corporation Management of statistical views in a database system
US8214807B2 (en) * 2007-01-10 2012-07-03 International Business Machines Corporation Code path tracking
US7593931B2 (en) * 2007-01-12 2009-09-22 International Business Machines Corporation Apparatus, system, and method for performing fast approximate computation of statistics on query expressions
US8903801B2 (en) 2007-09-14 2014-12-02 Oracle International Corporation Fully automated SQL tuning
US8341178B2 (en) * 2007-09-18 2012-12-25 Oracle International Corporation SQL performance analyzer
US8600977B2 (en) * 2007-10-17 2013-12-03 Oracle International Corporation Automatic recognition and capture of SQL execution plans
EP2157517A1 (en) * 2008-08-19 2010-02-24 Siemens Aktiengesellschaft A process and a system for updating a data structure in a relational database used within a manufacturing execution system
US9866426B2 (en) * 2009-11-17 2018-01-09 Hawk Network Defense, Inc. Methods and apparatus for analyzing system events
US9038184B1 (en) 2010-02-17 2015-05-19 Symantec Corporation Detection of malicious script operations using statistical analysis
US9002813B2 (en) * 2011-12-22 2015-04-07 Sap Se Execution plan preparation in application server
US9274936B2 (en) 2013-05-29 2016-03-01 Sap Portals Israel Ltd Database code testing framework
CN104834634A (en) * 2014-02-07 2015-08-12 西门子公司 Regression-based cost modeling method and device for predicting SQL statement performance
US10621064B2 (en) 2014-07-07 2020-04-14 Oracle International Corporation Proactive impact measurement of database changes on production systems
US11386058B2 (en) 2017-09-29 2022-07-12 Oracle International Corporation Rule-based autonomous database cloud service framework
US11327932B2 (en) 2017-09-30 2022-05-10 Oracle International Corporation Autonomous multitenant database cloud service framework
CN111639096B (en) * 2020-05-29 2024-03-08 北京奇艺世纪科技有限公司 SQL sentence execution method and device, electronic equipment and storage medium
CN113760960A (en) * 2020-06-01 2021-12-07 北京搜狗科技发展有限公司 Information generation method and device for generating information

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1997022939A1 (en) * 1995-12-20 1997-06-26 British Telecommunications Public Limited Company Specifying indexes for relational databases
US5860069A (en) * 1997-04-11 1999-01-12 Bmc Software, Inc. Method of efficient collection of SQL performance measures
US6009271A (en) * 1996-10-28 1999-12-28 Bmc Software, Inc. Method of retrieving data from a relational database

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6339769B1 (en) * 1998-09-14 2002-01-15 International Business Machines Corporation Query optimization by transparently altering properties of relational tables using materialized views
US6356887B1 (en) * 1999-06-28 2002-03-12 Microsoft Corporation Auto-parameterization of database queries

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1997022939A1 (en) * 1995-12-20 1997-06-26 British Telecommunications Public Limited Company Specifying indexes for relational databases
US6009271A (en) * 1996-10-28 1999-12-28 Bmc Software, Inc. Method of retrieving data from a relational database
US5860069A (en) * 1997-04-11 1999-01-12 Bmc Software, Inc. Method of efficient collection of SQL performance measures

Also Published As

Publication number Publication date
GB0119021D0 (en) 2001-09-26
US20030033291A1 (en) 2003-02-13
GB2378534A (en) 2003-02-12
US6708185B2 (en) 2004-03-16

Similar Documents

Publication Publication Date Title
GB2378534B (en) SQL execution analysis
GB0009311D0 (en) Vibration analysis
AU2001262621A1 (en) Semen analysis
GB2401433B (en) Codon-based sequence analysis
AU2003268457A8 (en) Biomap analysis
GB0108968D0 (en) Methods
EP1470421A4 (en) Rapid prion-detection assay
IL148838A0 (en) Otical debris analysis fixture
GB0130845D0 (en) Analysis
GB0120042D0 (en) Methods
GB2381867A8 (en) Analysis device
EP1546985A4 (en) Condition analysis
GB0111146D0 (en) Methods
GB2382263B (en) System analysis
GB0117352D0 (en) Analytical technique
GB0116249D0 (en) Methods
GB0201942D0 (en) Databases
GB0223960D0 (en) Assay methods
GB0118549D0 (en) Methods
GB0203448D0 (en) Protein analysis
GB0118611D0 (en) Methods
GB0116076D0 (en) Methods
GB0122409D0 (en) Urine analysis
GB0102220D0 (en) Databases
GB0131025D0 (en) Protein analysis

Legal Events

Date Code Title Description
732E Amendments to the register in respect of changes of name or changes affecting rights (sect. 32/1977)
PE20 Patent expired after termination of 20 years

Expiry date: 20210802