DE69610509T2 - Spezifizierende indexierungen für datenbanken - Google Patents

Spezifizierende indexierungen für datenbanken

Info

Publication number
DE69610509T2
DE69610509T2 DE69610509T DE69610509T DE69610509T2 DE 69610509 T2 DE69610509 T2 DE 69610509T2 DE 69610509 T DE69610509 T DE 69610509T DE 69610509 T DE69610509 T DE 69610509T DE 69610509 T2 DE69610509 T2 DE 69610509T2
Authority
DE
Germany
Prior art keywords
database
index
indices
indexes
data
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
DE69610509T
Other languages
German (de)
English (en)
Other versions
DE69610509D1 (de
Inventor
S Lenzie
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.)
British Telecommunications PLC
Original Assignee
British Telecommunications PLC
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 British Telecommunications PLC filed Critical British Telecommunications PLC
Application granted granted Critical
Publication of DE69610509D1 publication Critical patent/DE69610509D1/de
Publication of DE69610509T2 publication Critical patent/DE69610509T2/de
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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
    • G06F16/2228—Indexing structures
    • G06F16/2272—Management thereof
    • 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/99942—Manipulating data structure, e.g. compression, compaction, compilation
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Software Systems (AREA)
  • Probability & Statistics with Applications (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Measurement And Recording Of Electrical Phenomena And Electrical Characteristics Of The Living Body (AREA)
  • Liquid Crystal Substances (AREA)
DE69610509T 1995-12-20 1996-12-16 Spezifizierende indexierungen für datenbanken Expired - Lifetime DE69610509T2 (de)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
GBGB9526096.4A GB9526096D0 (en) 1995-12-20 1995-12-20 Specifying indexes for relational databases
PCT/GB1996/003102 WO1997022939A1 (en) 1995-12-20 1996-12-16 Specifying indexes for relational databases

Publications (2)

Publication Number Publication Date
DE69610509D1 DE69610509D1 (de) 2000-11-02
DE69610509T2 true DE69610509T2 (de) 2001-05-03

Family

ID=10785778

Family Applications (1)

Application Number Title Priority Date Filing Date
DE69610509T Expired - Lifetime DE69610509T2 (de) 1995-12-20 1996-12-16 Spezifizierende indexierungen für datenbanken

Country Status (9)

Country Link
US (1) US6182079B1 (enExample)
EP (1) EP0868699B1 (enExample)
JP (1) JP4285770B2 (enExample)
AU (1) AU712636B2 (enExample)
CA (1) CA2240155C (enExample)
DE (1) DE69610509T2 (enExample)
ES (1) ES2152578T3 (enExample)
GB (1) GB9526096D0 (enExample)
WO (1) WO1997022939A1 (enExample)

Families Citing this family (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
AUPO476197A0 (en) * 1997-01-24 1997-02-20 Kuypers, Johannes Antonius A hierarchical relational definition system and method of defining an object
US6317875B1 (en) * 1999-01-15 2001-11-13 Intel Corporation Application execution performance through disk block relocation
US6542854B2 (en) * 1999-04-30 2003-04-01 Oracle Corporation Method and mechanism for profiling a system
GB9915465D0 (en) * 1999-07-02 1999-09-01 Lenzie Robert S Identified preferred indexes for databases
US6920458B1 (en) 2000-09-22 2005-07-19 Sas Institute Inc. Model repository
JP2002259442A (ja) * 2001-02-28 2002-09-13 Fujitsu Ltd データベース検索方法ならびに記憶媒体
US7124104B2 (en) 2001-03-30 2006-10-17 Ge Corporate Financial Services, Inc. Methods and systems for implementing a profitability model
GB2378534B (en) * 2001-08-03 2003-08-20 Oracle Corp SQL execution analysis
US7039622B2 (en) * 2001-09-12 2006-05-02 Sas Institute Inc. Computer-implemented knowledge repository interface system and method
US7325016B1 (en) * 2001-12-11 2008-01-29 Sprint Communications Company L.P. Monitoring database performance by obtaining SQL addresses for SQL statements
CA2477580A1 (en) * 2002-03-01 2003-09-12 Software Engineering Gmbh Getpage - workload based index optimizer
US7047231B2 (en) * 2002-03-01 2006-05-16 Software Engineering Gmbh Getpage-workload based index optimizer
US7251659B1 (en) * 2003-12-04 2007-07-31 Sprint Communications Company L.P. Method and system for managing resource indexes in a networking environment
US7647280B1 (en) * 2003-12-08 2010-01-12 Teradata Us, Inc. Closed-loop estimation of request costs
FI20035235A0 (fi) * 2003-12-12 2003-12-12 Nokia Corp Järjestely tiedostojen käsittelemiseksi päätelaitteen yhteydessä
US7406477B2 (en) * 2004-03-12 2008-07-29 Sybase, Inc. Database system with methodology for automated determination and selection of optimal indexes
US8510269B2 (en) * 2004-05-21 2013-08-13 Ca, Inc. Uninterrupted database index reorganization/movement
US7676513B2 (en) * 2006-01-06 2010-03-09 Microsoft Corporation Scheduling of index merges
US8024296B1 (en) * 2007-06-15 2011-09-20 Symantec Corporation Method and apparatus for agent-less auditing of server
US8903801B2 (en) * 2007-09-14 2014-12-02 Oracle International Corporation Fully automated SQL tuning
JP5320787B2 (ja) * 2008-03-24 2013-10-23 富士通株式会社 検索キー最適化装置及び検索キー最適化プログラム
US10417611B2 (en) 2010-05-18 2019-09-17 Salesforce.Com, Inc. Methods and systems for providing multiple column custom indexes in a multi-tenant database environment
US10108648B2 (en) * 2011-07-13 2018-10-23 Salesforce.Com, Inc. Creating a custom index in a multi-tenant database environment
US9773032B2 (en) * 2011-09-30 2017-09-26 Bmc Software, Inc. Provision of index recommendations for database access
US10372709B2 (en) * 2016-11-11 2019-08-06 Sap Se Estimating string intersections for database systems
CN110287211B (zh) * 2019-07-01 2022-11-04 四川新网银行股份有限公司 基于大数据平台的动态sql语句的执行方法

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4805099A (en) * 1987-04-17 1989-02-14 Wang Laboratories, Inc. Retrieval of related records from a relational database
US5043872A (en) * 1988-07-15 1991-08-27 International Business Machines Corporation Access path optimization using degrees of clustering
US4956774A (en) * 1988-09-02 1990-09-11 International Business Machines Corporation Data base optimizer using most frequency values statistics
US5404510A (en) * 1992-05-21 1995-04-04 Oracle Corporation Database index design based upon request importance and the reuse and modification of similar existing indexes

Also Published As

Publication number Publication date
EP0868699A1 (en) 1998-10-07
CA2240155C (en) 2002-02-05
ES2152578T3 (es) 2001-02-01
WO1997022939A1 (en) 1997-06-26
AU712636B2 (en) 1999-11-11
DE69610509D1 (de) 2000-11-02
CA2240155A1 (en) 1997-06-26
AU1384097A (en) 1997-07-14
JP4285770B2 (ja) 2009-06-24
JP2000502201A (ja) 2000-02-22
EP0868699B1 (en) 2000-09-27
GB9526096D0 (en) 1996-02-21
US6182079B1 (en) 2001-01-30

Similar Documents

Publication Publication Date Title
DE3382808T2 (de) Datenbankzugriffsverfahren mit einem benutzerfreundlichen Menü
DE68926849T2 (de) Struktur und Verfahren zur Anordnung rekursiv abgeleiteter Daten in einer Datenbank
DE69431351T2 (de) Verfahren und gerät zum indexieren, suchen und anzeigen von daten
DE69425711T2 (de) Computerverfahren und -system zur Optimierung von Beta-Bäumen
DE4323947C2 (de) Verfahren zum Steuern von Datenbankabfragen in einem heterogenen, verteilten Datenbanksystem
DE69533193T2 (de) Paralleles verarbeitungssystem zum durchlaufen einer datenbank
DE69433165T2 (de) Assoziatives textsuch- und wiederauffindungssystem
DE69619213T2 (de) System und Verfahren zur Lastverteilung eines Datei-Servers
DE69229888T2 (de) Netzwerkverwaltungssystem und relationelle Datenbank dafür
DE3855212T2 (de) Verfahren zur Berechnung eines transitiven Abschlusses
CA2240155C (en) Specifying indexes for relational databases
DE10255125A1 (de) Dezentralisierte Automatische Testung von Grafischen Benutzerschnittstellen(GUI) von Software
DE69815819T2 (de) Adaptives verteiltes informationsnetzwerk
DE69031164T2 (de) Zeitlich begrenztes zentrumsystem für dezentralisiertes datenbanksystem
WO2000011581A1 (de) Verfahren zur fortschrittlichen mengenorientierten kostenzuweisung unter verwendung verschiedener informationsquellen
DE10107928A1 (de) Expertensystem
DE69130350T2 (de) Verfahren und Gerät, um Daten von vereinten Tabellen in einer Rechnerdatenbank aufzufinden
DE69232452T2 (de) Expertensystem mit einem Wissenserfassungsunterstützungssystem
DE19534819B4 (de) Verfahren und Vorrichtung zum Konfigurieren einer Datenbank
DE69130935T2 (de) Informationsdienstsystem und Verfahren zum Antworten auf eine Anfrage
DE60032258T2 (de) Bestimmen ob eine variable numerisch oder nicht numerisch ist
DE60013138T2 (de) Ein verfahren und ein gerät für die verarbeitung von abfragen einer datenbank
DE69517887T2 (de) Verfahren und System zum Herstellen von Verbindungen in einem Datenbanksystem
WO1996033470A1 (de) Abbildung eines graphen in einen speicher
DE19914326A1 (de) Verfahren zur Nutzung von fraktalen semantischen Netzen für alle Arten von Datenbank-Anwendungen

Legal Events

Date Code Title Description
8364 No opposition during term of opposition