ATE510262T1 - Automatisierte und dynamische verwaltung von anfragen-ansichten für datenbankauslastungen - Google Patents

Automatisierte und dynamische verwaltung von anfragen-ansichten für datenbankauslastungen

Info

Publication number
ATE510262T1
ATE510262T1 AT08701525T AT08701525T ATE510262T1 AT E510262 T1 ATE510262 T1 AT E510262T1 AT 08701525 T AT08701525 T AT 08701525T AT 08701525 T AT08701525 T AT 08701525T AT E510262 T1 ATE510262 T1 AT E510262T1
Authority
AT
Austria
Prior art keywords
cache
data table
required data
queries
automated
Prior art date
Application number
AT08701525T
Other languages
English (en)
Inventor
Wen-Syan Li
Thomas Phan
Original Assignee
Ibm
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 Ibm filed Critical Ibm
Application granted granted Critical
Publication of ATE510262T1 publication Critical patent/ATE510262T1/de

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/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24539—Query rewriting; Transformation using cached or materialised query results
    • 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/22—Indexing; Data structures therefor; Storage structures
    • 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/2454—Optimisation of common expressions

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Memory System Of A Hierarchy Structure (AREA)
AT08701525T 2007-01-19 2008-01-16 Automatisierte und dynamische verwaltung von anfragen-ansichten für datenbankauslastungen ATE510262T1 (de)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US11/624,876 US20080177700A1 (en) 2007-01-19 2007-01-19 Automated and dynamic management of query views for database workloads
PCT/EP2008/050458 WO2008087162A1 (en) 2007-01-19 2008-01-16 Automated and dynamic management of query views for database workloads

Publications (1)

Publication Number Publication Date
ATE510262T1 true ATE510262T1 (de) 2011-06-15

Family

ID=39186078

Family Applications (1)

Application Number Title Priority Date Filing Date
AT08701525T ATE510262T1 (de) 2007-01-19 2008-01-16 Automatisierte und dynamische verwaltung von anfragen-ansichten für datenbankauslastungen

Country Status (4)

Country Link
US (2) US20080177700A1 (de)
EP (1) EP2122502B1 (de)
AT (1) ATE510262T1 (de)
WO (1) WO2008087162A1 (de)

Families Citing this family (27)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9430552B2 (en) * 2007-03-16 2016-08-30 Microsoft Technology Licensing, Llc View maintenance rules for an update pipeline of an object-relational mapping (ORM) platform
US7917462B1 (en) * 2007-11-09 2011-03-29 Teradata Us, Inc. Materializing subsets of a multi-dimensional table
US8108340B2 (en) * 2008-03-28 2012-01-31 Yahoo! Inc. Search engine configured to minimize performance degradation under high load
US9355129B2 (en) * 2008-10-14 2016-05-31 Hewlett Packard Enterprise Development Lp Scheduling queries using a stretch metric
CN101931609B (zh) * 2009-06-22 2014-07-30 Sap股份公司 多租户数据库应用的遵守服务等级协议的布局
US9152668B1 (en) * 2010-01-29 2015-10-06 Asana, Inc. Asynchronous computation batching
US8620899B2 (en) * 2010-02-09 2013-12-31 International Business Machines Corporation Generating materialized query table candidates
US8631030B1 (en) * 2010-06-23 2014-01-14 Google Inc. Query suggestions with high diversity
US8356027B2 (en) * 2010-10-07 2013-01-15 Sap Ag Hybrid query execution plan generation and cost model evaluation
US9569477B1 (en) * 2010-12-29 2017-02-14 EMC IP Holding Company LLC Managing scanning of databases in data storage systems
US8660949B2 (en) 2011-09-09 2014-02-25 Sap Ag Method and system for working capital management
US9224121B2 (en) 2011-09-09 2015-12-29 Sap Se Demand-driven collaborative scheduling for just-in-time manufacturing
US8744888B2 (en) 2012-04-04 2014-06-03 Sap Ag Resource allocation management
US10268721B2 (en) * 2013-11-07 2019-04-23 Salesforce.Com, Inc Protected handling of database queries
US9886463B2 (en) 2014-06-12 2018-02-06 International Business Machines Corporation Generating and accessing a data table
US9679013B2 (en) * 2014-06-12 2017-06-13 International Business Machines Corporation Generating and accessing a data table
EP2966600B1 (de) * 2014-07-07 2018-08-15 derivo GmbH Abstraktionsverfeinerung für skalierbare Argumentation in Ontologie-basierten Datenspeichern
US10037164B1 (en) 2016-06-29 2018-07-31 EMC IP Holding Company LLC Flash interface for processing datasets
US10055351B1 (en) 2016-06-29 2018-08-21 EMC IP Holding Company LLC Low-overhead index for a flash cache
US10146438B1 (en) 2016-06-29 2018-12-04 EMC IP Holding Company LLC Additive library for data structures in a flash memory
US10089025B1 (en) 2016-06-29 2018-10-02 EMC IP Holding Company LLC Bloom filters in a flash memory
US10331561B1 (en) 2016-06-29 2019-06-25 Emc Corporation Systems and methods for rebuilding a cache index
US10261704B1 (en) 2016-06-29 2019-04-16 EMC IP Holding Company LLC Linked lists in flash memory
US10423620B2 (en) * 2017-04-22 2019-09-24 International Business Machines Corporation Runtime creation of remote derived sources for query offload
US10810196B2 (en) 2017-12-13 2020-10-20 Hewlett-Packard Development Company, L.P. Materialized view generation
CN108769729B (zh) * 2018-05-16 2021-01-05 东南大学 基于遗传算法的缓存布置系统及缓存方法
US11663179B2 (en) 2020-12-21 2023-05-30 International Business Machines Corporation Data simulation for regression analysis

Family Cites Families (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6026391A (en) * 1997-10-31 2000-02-15 Oracle Corporation Systems and methods for estimating query response times in a computer system
US6487641B1 (en) * 1999-04-19 2002-11-26 Oracle Corporation Dynamic caches with miss tables
US7783625B2 (en) * 1999-12-22 2010-08-24 International Business Machines Corporation Using data in materialized query tables as a source for query optimization statistics
US7890491B1 (en) * 1999-12-22 2011-02-15 International Business Machines Corporation Query optimization technique for obtaining improved cardinality estimates using statistics on automatic summary tables
CA2365692A1 (en) * 2001-06-21 2002-12-21 International Business Machines Corporation Method for recommending indexes and materialized views for a database workload
US7383247B2 (en) * 2005-08-29 2008-06-03 International Business Machines Corporation Query routing of federated information systems for fast response time, load balance, availability, and reliability
US8200659B2 (en) * 2005-10-07 2012-06-12 Bez Systems, Inc. Method of incorporating DBMS wizards with analytical models for DBMS servers performance optimization
US7769744B2 (en) * 2005-12-02 2010-08-03 Microsoft Cororation Missing index analysis and index useage statistics
US7689538B2 (en) * 2006-01-26 2010-03-30 International Business Machines Corporation Autonomic recommendation and placement of materialized query tables for load distribution
US20070250524A1 (en) * 2006-04-19 2007-10-25 Jian Le Method and apparatus for workload and model based materialized query table or view recommendation technique
US20080091642A1 (en) * 2006-10-12 2008-04-17 Robert Joseph Bestgen Advising the generation of a maintained index over a subset of values in a column of a table
US8224813B2 (en) * 2006-10-20 2012-07-17 Oracle International Corporation Cost based analysis of direct I/O access

Also Published As

Publication number Publication date
US20080177700A1 (en) 2008-07-24
US7716214B2 (en) 2010-05-11
EP2122502B1 (de) 2011-05-18
WO2008087162A1 (en) 2008-07-24
US20080183667A1 (en) 2008-07-31
EP2122502A1 (de) 2009-11-25

Similar Documents

Publication Publication Date Title
ATE510262T1 (de) Automatisierte und dynamische verwaltung von anfragen-ansichten für datenbankauslastungen
DE602006010451D1 (de) Verfahren für Sichere Verwaltung des Ablaufs eines Anwenderprogramms
JP2014525083A5 (de)
ATE509317T1 (de) Verfahren und vorrichtung zur bereitstellung von unabhängigem logischem adressenraum und zugangsverwaltung
GB2445294A (en) Method for proactive synchronization within a computer system
CA2538629A1 (en) Method and system for creating, storing, managing and consuming culture specific data
TW200639665A (en) Query composition using autolists
BR112014030245A2 (pt) métodos e aparelhos para monitorar apresentações de mídia
PE20060087A1 (es) Metodo para almacenar multiples recursos de datos en un sistema de archivo de un dispositivo
WO2008149337A3 (en) Devices for providing distributable middleware data proxy between application servers and database servers
MX2007012403A (es) Sistema y metodos para facilitar una base de datos de red lineal con organizacion de datos por dimension.
JP2014526729A5 (de)
EP2416271A3 (de) Datenbankanonymisierung zur Verwendung beim Testen von datenbankgestützten Anwendungen
RU2008114066A (ru) Обнаружение, допуск и активация программных встраиваемых компонентов
WO2016099902A3 (en) Efficiently providing virtual machine reference points
JP2014523013A5 (de)
RU2007147329A (ru) Метод политики санкционированного домена
BR112014006450A2 (pt) gerenciamento de identidades de dispositivo móvel
DE602007007566D1 (de) Verschleierung von Speicherzugriffsmustern
ATE544119T1 (de) Anfragenverwaltung in einem verteilten datenbanksystem
ATE516543T1 (de) Systeme und verfahren zum zugreifen auf information über verteilte rechnerkomponenten
GB2444451A (en) Building automation system data management
US20120078971A1 (en) Data management method
TW200745882A (en) System and method for out of user space I/O directly between a host system and a physical adapter using file based linear block address translation
EP2761508A1 (de) Dynamische datenbankindizierung

Legal Events

Date Code Title Description
RER Ceased as to paragraph 5 lit. 3 law introducing patent treaties