ES2152578T3 - Indices identificadores para bases de datos. - Google Patents
Indices identificadores para bases de datos.Info
- Publication number
- ES2152578T3 ES2152578T3 ES96944107T ES96944107T ES2152578T3 ES 2152578 T3 ES2152578 T3 ES 2152578T3 ES 96944107 T ES96944107 T ES 96944107T ES 96944107 T ES96944107 T ES 96944107T ES 2152578 T3 ES2152578 T3 ES 2152578T3
- Authority
- ES
- Spain
- Prior art keywords
- database
- indexes
- indices
- databases
- storage space
- 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
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
Abstract
SE ESPECIFICA UN CONJUNTO DE INDICES PARA UNA BASE DE DATOS ANALIZANDO UNA MUESTRA (718) DE INSTRUCCIONES DE SQL APLICADAS A LA BASE DE DATOS (701). SE IDENTIFICAN INDICES (707) QUE PUEDAN AYUDAR A LA EJECUCION DE LAS INSTRUCCIONES ANALIZADAS Y SE EVALUAN NIVELES DE OPERACION MEJORADA PARA CADA UNO DE LOS CITADOS INDICES. DESPUES SE PROCESAN LOS NIVELES EVALUADOS (708) PARA ESPECIFICAR UN CONJUNTO DE INDICES PARA SU INCLUSION EN LA BASE DE DATOS. PUEDE QUE LA BASE DE DATOS NO DISPONGA DE ESPACIO DE ALMACENAMIENTO SUFICIENTE (702) PARA TODOS LOS INDICES ESPECIFICADOS, POR LO QUE SE REPARTE EL ESPACIO DE ALMACENAMIENTO DISPONIBLE Y SE SELECCIONAN LOS INDICES EN FUNCION DE LAS PRIORIDADES.
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
GBGB9526096.4A GB9526096D0 (en) | 1995-12-20 | 1995-12-20 | Specifying indexes for relational databases |
Publications (1)
Publication Number | Publication Date |
---|---|
ES2152578T3 true ES2152578T3 (es) | 2001-02-01 |
Family
ID=10785778
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
ES96944107T Expired - Lifetime ES2152578T3 (es) | 1995-12-20 | 1996-12-16 | Indices identificadores para bases de datos. |
Country Status (9)
Country | Link |
---|---|
US (1) | US6182079B1 (es) |
EP (1) | EP0868699B1 (es) |
JP (1) | JP4285770B2 (es) |
AU (1) | AU712636B2 (es) |
CA (1) | CA2240155C (es) |
DE (1) | DE69610509T2 (es) |
ES (1) | ES2152578T3 (es) |
GB (1) | GB9526096D0 (es) |
WO (1) | WO1997022939A1 (es) |
Families Citing this family (26)
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 |
US7047231B2 (en) * | 2002-03-01 | 2006-05-16 | Software Engineering Gmbh | Getpage-workload based index optimizer |
CA2477580A1 (en) * | 2002-03-01 | 2003-09-12 | 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)
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 DE DE69610509T patent/DE69610509T2/de not_active Expired - Lifetime
- 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 US US09/091,601 patent/US6182079B1/en not_active Expired - Lifetime
- 1996-12-16 JP JP52257597A patent/JP4285770B2/ja not_active Expired - Fee Related
- 1996-12-16 EP EP96944107A patent/EP0868699B1/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 |
---|---|
DE69610509T2 (de) | 2001-05-03 |
GB9526096D0 (en) | 1996-02-21 |
EP0868699A1 (en) | 1998-10-07 |
WO1997022939A1 (en) | 1997-06-26 |
US6182079B1 (en) | 2001-01-30 |
CA2240155A1 (en) | 1997-06-26 |
AU712636B2 (en) | 1999-11-11 |
EP0868699B1 (en) | 2000-09-27 |
AU1384097A (en) | 1997-07-14 |
JP4285770B2 (ja) | 2009-06-24 |
JP2000502201A (ja) | 2000-02-22 |
CA2240155C (en) | 2002-02-05 |
DE69610509D1 (de) | 2000-11-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
ES2152578T3 (es) | Indices identificadores para bases de datos. | |
Buxton et al. | The variation in the information content of titles of research papers with time and discipline | |
ATE188050T1 (de) | Datenbanksuchsystem | |
ATE260486T1 (de) | Auffindung von zeichenketten in einer datenbank von zeichenketten | |
DE10196212T1 (de) | Verfahren und Vorrichtung zum Identifizieren von Verwandten suchen in einem Datenbanksuchsystem | |
RU2001102589A (ru) | Способ поиска данных и устройство, позволяющее работать со многими источниками | |
ATE264523T1 (de) | Verfahren zur herstellung einer bio-informatik- datenbank | |
DK1307833T3 (da) | Fremgangsmåde til sögning i en lyddatabase | |
ES2132769T3 (es) | Arquitectura de consulta ampliable independiente del metodo aplicado, para sistemas para la recuperacion de informacion. | |
ATE446547T1 (de) | Themenspezifische suchmaschine | |
SE0004043D0 (sv) | Method and apparatus for document indexing and searching | |
DE68925182D1 (de) | Zuverlässige Anordnung zur Datenbankverwaltung | |
EA200400855A1 (ru) | Система и способ создания многоязычной базы данных | |
BR9810138A (pt) | Processo e aparelho para estruturar uma base de dados | |
NO933146L (no) | Fremgangsmåte ved undersökelse av Lupus antikoagulerende middel | |
Monniot | Ascidies littorales de Guadeloupe II: Phlebobranches | |
WO2003085552A3 (en) | Comparison of source files | |
Soergel | Data models for an integrated thesaurus database | |
KR960705281A (ko) | 퍼지 데이타 처리 장치 및 방법(Fuzzy data processing device and method therefor) | |
Raisin | Indexing a local planning inquiry the experience of Belvoir | |
YASUHARA et al. | Identification of Unknown Compounds by Library Search of Mass Spectra Obtained by Gas Chromatography/Mass Spectrometry (Part2) | |
Shlater et al. | Social science methodology | |
ATE304193T1 (de) | Vergleich von quelldateien | |
JPH04153736A (ja) | 行番号情報付加方式 | |
Ifie | Nature and symbolism in six sacred dirges |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
FG2A | Definitive protection |
Ref document number: 868699 Country of ref document: ES |