ZA200203961B - A method and apparatus for operating a database. - Google Patents
A method and apparatus for operating a database. Download PDFInfo
- Publication number
- ZA200203961B ZA200203961B ZA200203961A ZA200203961A ZA200203961B ZA 200203961 B ZA200203961 B ZA 200203961B ZA 200203961 A ZA200203961 A ZA 200203961A ZA 200203961 A ZA200203961 A ZA 200203961A ZA 200203961 B ZA200203961 B ZA 200203961B
- Authority
- ZA
- South Africa
- Prior art keywords
- service query
- query
- expression
- results
- service
- Prior art date
Links
- 238000000034 method Methods 0.000 title claims description 34
- 230000014509 gene expression Effects 0.000 claims description 47
- 238000012545 processing Methods 0.000 claims description 12
- 238000013507 mapping Methods 0.000 description 4
- 238000005457 optimization Methods 0.000 description 3
- 238000012360 testing method Methods 0.000 description 3
- 239000002253 acid Substances 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000011156 evaluation Methods 0.000 description 2
- 238000013519 translation Methods 0.000 description 2
- 230000003292 diminished effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000007429 general method Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000008447 perception Effects 0.000 description 1
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
-
- 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/2452—Query translation
- G06F16/24528—Standardisation; Simplification
-
- 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/99931—Database or file accessing
- Y10S707/99932—Access augmentation or optimizing
-
- 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/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
AUPQ4284A AUPQ428499A0 (en) | 1999-11-26 | 1999-11-26 | A method and apparatus for operating a data base |
Publications (1)
Publication Number | Publication Date |
---|---|
ZA200203961B true ZA200203961B (en) | 2003-05-19 |
Family
ID=3818426
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
ZA200203961A ZA200203961B (en) | 1999-11-26 | 2002-05-17 | A method and apparatus for operating a database. |
Country Status (11)
Country | Link |
---|---|
US (1) | US7617183B1 (pt) |
EP (1) | EP1234256A4 (pt) |
JP (1) | JP2003515819A (pt) |
KR (1) | KR20020062310A (pt) |
CN (1) | CN1264105C (pt) |
AU (1) | AUPQ428499A0 (pt) |
BR (1) | BR0015912A (pt) |
CA (1) | CA2396453A1 (pt) |
IL (1) | IL149761A0 (pt) |
WO (1) | WO2001039045A1 (pt) |
ZA (1) | ZA200203961B (pt) |
Families Citing this family (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8065338B2 (en) * | 1995-08-30 | 2011-11-22 | Computer Associates Think, Inc. | Directory searching methods and systems |
US20050222996A1 (en) * | 2004-03-30 | 2005-10-06 | Oracle International Corporation | Managing event-condition-action rules in a database system |
US20080051989A1 (en) * | 2006-08-25 | 2008-02-28 | Microsoft Corporation | Filtering of data layered on mapping applications |
US8661023B1 (en) | 2012-08-01 | 2014-02-25 | Google Inc. | Optimizing search query logic to speed retrieval |
CN103744888A (zh) * | 2013-12-23 | 2014-04-23 | 新浪网技术(中国)有限公司 | 反垃圾邮件网关查询数据库的方法和系统 |
US10437883B2 (en) * | 2015-11-24 | 2019-10-08 | Cisco Technology, Inc. | Efficient graph database traversal |
US10515075B2 (en) | 2017-05-15 | 2019-12-24 | Microsoft Technology Licensing, Llc | Method for optimization of imperative code executing inside a relational database engine |
Family Cites Families (53)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4914571A (en) | 1987-06-15 | 1990-04-03 | International Business Machines Corporation | Locating resources in computer networks |
US5218699A (en) | 1989-08-24 | 1993-06-08 | International Business Machines Corporation | Remote procedure calls in heterogeneous systems |
AU631276B2 (en) | 1989-12-22 | 1992-11-19 | Bull Hn Information Systems Inc. | Name resolution in a directory database |
US5117349A (en) | 1990-03-27 | 1992-05-26 | Sun Microsystems, Inc. | User extensible, language sensitive database system |
US5291583A (en) | 1990-12-14 | 1994-03-01 | Racal-Datacom, Inc. | Automatic storage of persistent ASN.1 objects in a relational schema |
US5317742A (en) | 1991-06-21 | 1994-05-31 | Racal-Datacom, Inc. | Dynamic translation of network management primitives to queries to a database |
US5388255A (en) | 1991-12-19 | 1995-02-07 | Wang Laboratories, Inc. | System for updating local views from a global database using time stamps to determine when a change has occurred |
US5414812A (en) | 1992-03-27 | 1995-05-09 | International Business Machines Corporation | System for using object-oriented hierarchical representation to implement a configuration database for a layered computer network communications subsystem |
US5412804A (en) * | 1992-04-30 | 1995-05-02 | Oracle Corporation | Extending the semantics of the outer join operator for un-nesting queries to a data base |
US5442690A (en) | 1992-08-25 | 1995-08-15 | Bell Communications Research, Inc. | Telecommunication service record structure and method of execution |
JPH0820982B2 (ja) | 1992-11-12 | 1996-03-04 | インターナショナル・ビジネス・マシーンズ・コーポレイション | コンピュータ・アプリケーションプログラム収納体の項目をフィルタ処理する方法 |
US5491817A (en) | 1993-05-25 | 1996-02-13 | Bell Communications Research Inc. | Linking system and method for accessing directory information about an object in one context when information in another context is known |
US5548726A (en) | 1993-12-17 | 1996-08-20 | Taligeni, Inc. | System for activating new service in client server network by reconfiguring the multilayer network protocol stack dynamically within the server node |
US5659725A (en) | 1994-06-06 | 1997-08-19 | Lucent Technologies Inc. | Query optimization by predicate move-around |
US5758144A (en) | 1994-06-24 | 1998-05-26 | International Business Machines Corporation | Database execution cost and system performance estimator |
US5664172A (en) | 1994-07-19 | 1997-09-02 | Oracle Corporation | Range-based query optimizer |
WO1996007147A1 (en) | 1994-09-01 | 1996-03-07 | Datacraft Technologies Pty. Ltd. | X.500 system and methods |
US7315860B1 (en) | 1994-09-01 | 2008-01-01 | Computer Associates Think, Inc. | Directory service system and method with tolerance for data entry storage and output |
EP0727739B1 (en) | 1995-02-17 | 2002-11-06 | International Business Machines Corporation | Object-oriented programming interface for developing and running network management applications on a network communication infrastructure |
US5649182A (en) | 1995-03-17 | 1997-07-15 | Reitz; Carl A. | Apparatus and method for organizing timeline data |
JPH11504451A (ja) | 1995-04-24 | 1999-04-20 | アスペクト・ディベロップメント・インコーポレイテッド | データベース構造に適したオブジェクトのモデリング、リレーショナルデータベース構造への翻訳、それらへの流動的なサーチ |
US5634053A (en) * | 1995-08-29 | 1997-05-27 | Hughes Aircraft Company | Federated information management (FIM) system and method for providing data site filtering and translation for heterogeneous databases |
US8065338B2 (en) | 1995-08-30 | 2011-11-22 | Computer Associates Think, Inc. | Directory searching methods and systems |
US5692181A (en) | 1995-10-12 | 1997-11-25 | Ncr Corporation | System and method for generating reports from a computer database |
US5794232A (en) | 1996-03-15 | 1998-08-11 | Novell, Inc. | Catalog services for distributed directories |
US5953716A (en) | 1996-05-30 | 1999-09-14 | Massachusetts Inst Technology | Querying heterogeneous data sources distributed over a network using context interchange |
US5745900A (en) | 1996-08-09 | 1998-04-28 | Digital Equipment Corporation | Method for indexing duplicate database records using a full-record fingerprint |
US5987446A (en) * | 1996-11-12 | 1999-11-16 | U.S. West, Inc. | Searching large collections of text using multiple search engines concurrently |
US5878415A (en) | 1997-03-20 | 1999-03-02 | Novell, Inc. | Controlling access to objects in a hierarchical database |
US6003050A (en) | 1997-04-02 | 1999-12-14 | Microsoft Corporation | Method for integrating a virtual machine with input method editors |
US6122627A (en) * | 1997-05-09 | 2000-09-19 | International Business Machines Corporation | System, method, and program for object building in queries over object views |
US5806061A (en) | 1997-05-20 | 1998-09-08 | Hewlett-Packard Company | Method for cost-based optimization over multimeida repositories |
US7631012B2 (en) | 1997-05-22 | 2009-12-08 | Computer Associates Think, Inc. | System and method of operating a database |
US6236997B1 (en) | 1997-06-23 | 2001-05-22 | Oracle Corporation | Apparatus and method for accessing foreign databases in a heterogeneous database system |
US6112198A (en) * | 1997-06-30 | 2000-08-29 | International Business Machines Corporation | Optimization of data repartitioning during parallel query optimization |
US5864840A (en) | 1997-06-30 | 1999-01-26 | International Business Machines Corporation | Evaluation of existential and universal subquery in a relational database management system for increased efficiency |
US6016499A (en) | 1997-07-21 | 2000-01-18 | Novell, Inc. | System and method for accessing a directory services respository |
US6112304A (en) | 1997-08-27 | 2000-08-29 | Zipsoft, Inc. | Distributed computing architecture |
GB2329044B (en) | 1997-09-05 | 2002-10-09 | Ibm | Data retrieval system |
US6195653B1 (en) | 1997-10-14 | 2001-02-27 | International Business Machines Corporation | System and method for selectively preparing customized reports of query explain data |
US6044442A (en) | 1997-11-21 | 2000-03-28 | International Business Machines Corporation | External partitioning of an automated data storage library into multiple virtual libraries for access by a plurality of hosts |
US6009422A (en) * | 1997-11-26 | 1999-12-28 | International Business Machines Corporation | System and method for query translation/semantic translation using generalized query language |
US6016497A (en) | 1997-12-24 | 2000-01-18 | Microsoft Corporation | Methods and system for storing and accessing embedded information in object-relational databases |
US6192405B1 (en) | 1998-01-23 | 2001-02-20 | Novell, Inc. | Method and apparatus for acquiring authorized access to resources in a distributed system |
US6085188A (en) * | 1998-03-30 | 2000-07-04 | International Business Machines Corporation | Method of hierarchical LDAP searching with relational tables |
US6115703A (en) | 1998-05-11 | 2000-09-05 | International Business Machines Corporation | Two-level caching system for prepared SQL statements in a relational database management system |
US6119129A (en) | 1998-05-14 | 2000-09-12 | Sun Microsystems, Inc. | Multi-threaded journaling in a configuration database |
US6356892B1 (en) * | 1998-09-24 | 2002-03-12 | International Business Machines Corporation | Efficient implementation of lightweight directory access protocol (LDAP) search queries with structured query language (SQL) |
US6199062B1 (en) | 1998-11-19 | 2001-03-06 | International Business Machines Corporation | Reverse string indexing in a relational database for wildcard searching |
KR100288140B1 (ko) | 1998-12-07 | 2001-05-02 | 이계철 | 이기종 데이터베이스 관리 시스템에 접근 가능한 연결 제공 시스템 및 그 방법 |
US6370522B1 (en) | 1999-03-18 | 2002-04-09 | Oracle Corporation | Method and mechanism for extending native optimization in a database system |
GB9915465D0 (en) | 1999-07-02 | 1999-09-01 | Lenzie Robert S | Identified preferred indexes for databases |
US6879990B1 (en) | 2000-04-28 | 2005-04-12 | Institute For Scientific Information, Inc. | System for identifying potential licensees of a source patent portfolio |
-
1999
- 1999-11-26 AU AUPQ4284A patent/AUPQ428499A0/en not_active Abandoned
-
2000
- 2000-11-24 WO PCT/US2000/032123 patent/WO2001039045A1/en active IP Right Grant
- 2000-11-24 CA CA002396453A patent/CA2396453A1/en not_active Abandoned
- 2000-11-24 US US09/721,806 patent/US7617183B1/en not_active Expired - Lifetime
- 2000-11-24 BR BR0015912-3A patent/BR0015912A/pt not_active IP Right Cessation
- 2000-11-24 CN CNB008161925A patent/CN1264105C/zh not_active Expired - Fee Related
- 2000-11-24 JP JP2001540639A patent/JP2003515819A/ja active Pending
- 2000-11-24 EP EP00980695A patent/EP1234256A4/en not_active Ceased
- 2000-11-24 KR KR1020027006694A patent/KR20020062310A/ko not_active Application Discontinuation
- 2000-11-24 IL IL14976100A patent/IL149761A0/xx unknown
-
2002
- 2002-05-17 ZA ZA200203961A patent/ZA200203961B/en unknown
Also Published As
Publication number | Publication date |
---|---|
KR20020062310A (ko) | 2002-07-25 |
CA2396453A1 (en) | 2001-05-31 |
BR0015912A (pt) | 2002-08-06 |
JP2003515819A (ja) | 2003-05-07 |
IL149761A0 (en) | 2002-11-10 |
AUPQ428499A0 (en) | 1999-12-23 |
CN1264105C (zh) | 2006-07-12 |
US7617183B1 (en) | 2009-11-10 |
EP1234256A4 (en) | 2003-05-21 |
EP1234256A1 (en) | 2002-08-28 |
WO2001039045A1 (en) | 2001-05-31 |
CN1399748A (zh) | 2003-02-26 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP4397978B2 (ja) | 濃度を利用した結合順序付け方法 | |
US7685098B2 (en) | Estimating the size of a join by generating and combining partial join estimates | |
CN110837585A (zh) | 多源异构的数据关联查询方法及系统 | |
JP2004520633A (ja) | 属性又はキー値を選択的に利用することによりクエリ生成を最適化する方法と装置 | |
CN111008020B (zh) | 将逻辑表达式解析为通用查询语句的方法 | |
CN110399395B (zh) | 基于预计算的加速查询方法、存储介质 | |
US7617183B1 (en) | Method and apparatus for operating a database | |
US5721896A (en) | Method for skew resistant join size estimation | |
WO2020079271A1 (en) | Distributed join index for shared-nothing and log-structured databases | |
AU781799B2 (en) | A method and apparatus for operating a database | |
CN114416884B (zh) | 连接分区表的方法和装置 | |
Blockhaus et al. | Combining two worlds: MonetDB with multi-dimensional index structure support to efficiently query scientific data | |
JP2005510777A (ja) | データベースを操作するシステム及び方法 | |
Guinepain et al. | Using cluster computing to support automatic and dynamic database clustering | |
KR100541531B1 (ko) | 객체 지향 디비엠에스에서 경로식의 부질의 변환을 통한 질의 처리 방법 | |
Tsotras et al. | A notation for spatiotemporal queries | |
GB2406666A (en) | Improving the efficiency of SQL statements which use joins | |
KR101460950B1 (ko) | 비정규 테이블 표기법을 기반으로 한 NoSQL 질의 방법 및 장치 | |
Chao et al. | Estimating temporary files sizes in distributed realtional database systems | |
JP2502262B2 (ja) | ネットワ―クデ―タベ―スアクセス方法 | |
CN112162985A (zh) | 一种基于kettle商业智能平台异步下载的方法 | |
CN115563148A (zh) | 数据库查询方法和装置 | |
Schmidt et al. | Basic Building Blocks for Column-Stores | |
Rausch | Stars and models: how to build and maintain star schemas using SAS® data integration server in SAS® 9 | |
CN112100199A (zh) | 一种基于数据集分组的分析方法、装置、设备及介质 |