DE69610509D1 - Spezifizierende indexierungen für datenbanken - Google Patents

Spezifizierende indexierungen für datenbanken

Info

Publication number: DE69610509D1
Authority: DE; Germany
Prior art keywords: databases; specific indexes; indexes; specific
Prior art date: 1995-12-20
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

English (en)

Other versions

DE69610509T2 (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.)

1995-12-20

Filing date

1996-12-16

Publication date

2000-11-02

1996-12-16 Application filed by British Telecommunications PLC filed Critical British Telecommunications PLC

2000-11-02 Application granted granted Critical

2000-11-02 Publication of DE69610509D1 publication Critical patent/DE69610509D1/de

2001-05-03 Publication of DE69610509T2 publication Critical patent/DE69610509T2/de

2016-12-17 Anticipated expiration legal-status Critical

Status 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/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

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 true DE69610509D1 (de)	2000-11-02
DE69610509T2 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 (de)
EP (1)	EP0868699B1 (de)
JP (1)	JP4285770B2 (de)
AU (1)	AU712636B2 (de)
CA (1)	CA2240155C (de)
DE (1)	DE69610509T2 (de)
ES (1)	ES2152578T3 (de)
GB (1)	GB9526096D0 (de)
WO (1)	WO1997022939A1 (de)

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
WO2003075174A2 (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
WO2005114480A2 (en) *	2004-05-21	2005-12-01	Computer Associates Think, 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

1995
- 1995-12-20 GB GBGB9526096.4A patent/GB9526096D0/en active Pending
1996
- 1996-12-16 JP JP52257597A patent/JP4285770B2/ja not_active Expired - Fee Related
- 1996-12-16 ES ES96944107T patent/ES2152578T3/es not_active Expired - Lifetime
- 1996-12-16 AU AU13840/97A patent/AU712636B2/en not_active Ceased
- 1996-12-16 DE DE69610509T patent/DE69610509T2/de not_active Expired - Lifetime
- 1996-12-16 EP EP96944107A patent/EP0868699B1/de not_active Expired - Lifetime
- 1996-12-16 US US09/091,601 patent/US6182079B1/en not_active Expired - Lifetime
- 1996-12-16 CA CA002240155A patent/CA2240155C/en not_active Expired - Fee Related
- 1996-12-16 WO PCT/GB1996/003102 patent/WO1997022939A1/en active IP Right Grant

Also Published As

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

Legal Events

Date	Code	Title	Description
2001-10-18	8364	No opposition during term of opposition

Publication	Publication Date	Title
DE69610509T2 (de)	2001-05-03	Spezifizierende indexierungen für datenbanken
DE69521839T2 (de)	2002-04-04	Datenbanksystem
DE69606738T2 (de)	2000-10-19	Anwincklungsvorrichtung für Befestigungselemente
DE69419678T2 (de)	1999-12-02	Entwurfsverfahren für luftreifen
DE69331228T4 (de)	2002-09-05	Heilmittel für thrombozytopenia
DE29500054U1 (de)	1995-04-06	Schulterstütze für Violinen
DE69523142T2 (de)	2002-01-31	Verteiltes datenbanksystem
DE69322437D1 (de)	1999-01-21	Schnittstelle für Jontophorese
DE69620057T2 (de)	2002-09-05	Optimierer
DE69700954T2 (de)	2000-07-27	Datenbanken
DE69320411D1 (de)	1998-09-24	Reibungsloser Dynamometer für Fahrwerk
ATE177293T1 (de)	1999-03-15	Ausziehführungsgarnitur für schubladen
DE69519727D1 (de)	2001-02-01	Datenbanksuchsystem
DE29517576U1 (de)	1996-03-21	Gehrad für Behinderte
DE29510543U1 (de)	1995-09-07	Selbstzentrierende Lünette
DE9420328U1 (de)	1995-02-16	Fahrzeug für Gehbehinderte
DE29515877U1 (de)	1995-11-30	Halterungskopfband für Taschenlampen
DE29605120U1 (de)	1996-05-09	Schaftkappe für eine Schußwaffe
DE29518382U1 (de)	1996-01-11	Dose für Flüssigkeiten
DE9318299U1 (de)	1994-01-27	Auffangwanne für Flüssigkeiten
DE29512303U1 (de)	1995-10-05	Uringefäß für Frauen
DE9417145U1 (de)	1995-02-09	Fußbeschleunigertreppe für Gleitsegel-seblstausrichtend
DE9409278U1 (de)	1994-08-04	Verkaufseinrichtung für Sets
KR950030004U (ko)	1995-11-20	주행거리 표시장치
KR960028269U (ko)	1996-09-17	욕조용 지수부재