IL137127A - Method and apparatus for optimizing query generation by selectively utilizing attributes or key values - Google Patents
Method and apparatus for optimizing query generation by selectively utilizing attributes or key valuesInfo
- Publication number
- IL137127A IL137127A IL13712799A IL13712799A IL137127A IL 137127 A IL137127 A IL 137127A IL 13712799 A IL13712799 A IL 13712799A IL 13712799 A IL13712799 A IL 13712799A IL 137127 A IL137127 A IL 137127A
- Authority
- IL
- Israel
- Prior art keywords
- key values
- query generation
- dimensions
- selectively utilizing
- forced
- Prior art date
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- 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/24549—Run-time optimisation
-
- 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
- Y10S707/99934—Query formulation, input preparation, or translation
-
- 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
- Y10S707/99935—Query augmenting and refining, e.g. inexact access
-
- 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/99943—Generating database or data structure, e.g. via user interface
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/185,042 US6192357B1 (en) | 1998-11-03 | 1998-11-03 | Method and apparatus for optimizing query generation by selectively utilizing attributes or key values |
PCT/US1999/025939 WO2000028439A1 (en) | 1998-11-03 | 1999-11-03 | Method and apparatus for optimizing query generation by selectively utilizing attributes or key values |
Publications (2)
Publication Number | Publication Date |
---|---|
IL137127A0 IL137127A0 (en) | 2001-07-24 |
IL137127A true IL137127A (en) | 2005-06-19 |
Family
ID=22679320
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
IL13712799A IL137127A (en) | 1998-11-03 | 1999-11-03 | Method and apparatus for optimizing query generation by selectively utilizing attributes or key values |
Country Status (12)
Country | Link |
---|---|
US (1) | US6192357B1 (de) |
EP (1) | EP1049997B1 (de) |
JP (1) | JP2004520633A (de) |
CN (1) | CN1292125A (de) |
AT (1) | ATE358297T1 (de) |
AU (1) | AU755859B2 (de) |
BR (1) | BR9906714A (de) |
CA (1) | CA2325863A1 (de) |
DE (1) | DE69935657T2 (de) |
IL (1) | IL137127A (de) |
WO (1) | WO2000028439A1 (de) |
ZA (1) | ZA200003317B (de) |
Families Citing this family (23)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7130853B2 (en) * | 2000-06-06 | 2006-10-31 | Fair Isaac Corporation | Datamart including routines for extraction, accessing, analyzing, transformation of data into standardized format modeled on star schema |
US6785666B1 (en) * | 2000-07-11 | 2004-08-31 | Revenue Science, Inc. | Method and system for parsing navigation information |
US20030095145A1 (en) * | 2001-10-30 | 2003-05-22 | Jonathan Patrizio | System and method for table row selection in a GUI display |
US20040133583A1 (en) * | 2002-11-20 | 2004-07-08 | Tingey Kenneth B. | system architecture and method for entering and accessing entity data in events accounting |
US7103591B2 (en) * | 2002-12-02 | 2006-09-05 | International Business Machines Corporation | Method of describing business and technology information for utilization |
US7627587B2 (en) * | 2003-09-25 | 2009-12-01 | Unisys Corporation | System and method for improving information retrieval from a database |
KR100619016B1 (ko) * | 2004-05-06 | 2006-08-31 | 삼성전자주식회사 | 광 기록 정보 저장 매체, 기록/재생 장치 및 호스트 장치 |
US7840607B2 (en) * | 2004-08-06 | 2010-11-23 | Siemens Aktiengesellschaft | Data mart generation and use in association with an operations intelligence platform |
US7580922B2 (en) * | 2005-01-04 | 2009-08-25 | International Business Machines Corporation | Methods for relating data in healthcare databases |
US7680781B1 (en) | 2005-03-04 | 2010-03-16 | Teradata Us, Inc. | Automatic search query generation and results set management |
US7650196B2 (en) * | 2005-09-30 | 2010-01-19 | Rockwell Automation Technologies, Inc. | Production monitoring and control system having organizational structure-based presentation layer |
US7590541B2 (en) * | 2005-09-30 | 2009-09-15 | Rockwell Automation Technologies, Inc. | HMI presentation layer configuration system |
US7933900B2 (en) * | 2005-10-23 | 2011-04-26 | Google Inc. | Search over structured data |
US7464083B2 (en) * | 2005-10-24 | 2008-12-09 | Wolfgang Otter | Combining multi-dimensional data sources using database operations |
US8954426B2 (en) * | 2006-02-17 | 2015-02-10 | Google Inc. | Query language |
US20070185870A1 (en) | 2006-01-27 | 2007-08-09 | Hogue Andrew W | Data object visualization using graphs |
US8954412B1 (en) | 2006-09-28 | 2015-02-10 | Google Inc. | Corroborating facts in electronic documents |
CN100498793C (zh) * | 2007-06-08 | 2009-06-10 | 北京神舟航天软件技术有限公司 | 用基于小波的压缩直方图实现二维谓词选择率估计的方法 |
US7702622B2 (en) | 2007-06-29 | 2010-04-20 | Microsoft Corporation | Advanced techniques for SQL generation of performancepoint business rules |
US8200604B2 (en) | 2007-06-29 | 2012-06-12 | Microsoft Corporation | Multi-platform business calculation rule language and execution environment |
US8020144B2 (en) * | 2007-06-29 | 2011-09-13 | Microsoft Corporation | Metadata-based application deployment |
CN102043866B (zh) * | 2011-01-25 | 2013-03-13 | 苏州普达新信息技术有限公司 | 基于表单特征的松弛搜索与优化排序方法 |
US9785704B2 (en) * | 2012-01-04 | 2017-10-10 | Microsoft Technology Licensing, Llc | Extracting query dimensions from search results |
Family Cites Families (18)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5440730A (en) * | 1990-08-09 | 1995-08-08 | Bell Communications Research, Inc. | Time index access structure for temporal databases having concurrent multiple versions |
JPH077422B2 (ja) * | 1991-08-23 | 1995-01-30 | インターナショナル・ビジネス・マシーンズ・コーポレイション | コンピュータ処理データベース・システムにおけるジョインの実行方法及びシステム |
JPH0756652B2 (ja) * | 1992-03-24 | 1995-06-14 | インターナショナル・ビジネス・マシーンズ・コーポレイション | 動画像のフレーム列の検索 |
US5359724A (en) * | 1992-03-30 | 1994-10-25 | Arbor Software Corporation | Method and apparatus for storing and retrieving multi-dimensional data in computer memory |
US5572731A (en) * | 1992-12-30 | 1996-11-05 | Hewlett-Packard Company | Sequentially navigated object oriented computer system |
JP3266351B2 (ja) * | 1993-01-20 | 2002-03-18 | 株式会社日立製作所 | データベース管理システムおよび問合せの処理方法 |
US5713020A (en) * | 1993-09-02 | 1998-01-27 | Microsoft Corporation | Method and system for generating database queries containing multiple levels of aggregation |
WO1995019008A1 (en) * | 1994-01-05 | 1995-07-13 | Covey Peter J | Dynamic-state, multi-dimensional, multi-media database |
GB9417314D0 (en) * | 1994-08-27 | 1994-10-19 | Int Computers Ltd | Method for performing joins in a database system |
US5675785A (en) * | 1994-10-04 | 1997-10-07 | Hewlett-Packard Company | Data warehouse which is accessed by a user using a schema of virtual tables |
US5590324A (en) * | 1995-02-07 | 1996-12-31 | International Business Machines Corporation | Optimization of SQL queries using universal quantifiers, set intersection, and max/min aggregation in the presence of nullable columns |
US5745754A (en) * | 1995-06-07 | 1998-04-28 | International Business Machines Corporation | Sub-agent for fulfilling requests of a web browser using an intelligent agent and providing a report |
US5761652A (en) * | 1996-03-20 | 1998-06-02 | International Business Machines Corporation | Constructing balanced multidimensional range-based bitmap indices |
US5832475A (en) * | 1996-03-29 | 1998-11-03 | International Business Machines Corporation | Database system and method employing data cube operator for group-by operations |
US5897622A (en) * | 1996-10-16 | 1999-04-27 | Microsoft Corporation | Electronic shopping and merchandising system |
US5974418A (en) * | 1996-10-16 | 1999-10-26 | Blinn; Arnold | Database schema independence |
US5799300A (en) * | 1996-12-12 | 1998-08-25 | International Business Machines Corporations | Method and system for performing range-sum queries on a data cube |
US5937408A (en) * | 1997-05-29 | 1999-08-10 | Oracle Corporation | Method, article of manufacture, and apparatus for generating a multi-dimensional record structure foundation |
-
1998
- 1998-11-03 US US09/185,042 patent/US6192357B1/en not_active Expired - Lifetime
-
1999
- 1999-11-03 AT AT99968035T patent/ATE358297T1/de not_active IP Right Cessation
- 1999-11-03 WO PCT/US1999/025939 patent/WO2000028439A1/en active IP Right Grant
- 1999-11-03 CA CA002325863A patent/CA2325863A1/en not_active Abandoned
- 1999-11-03 JP JP2000581554A patent/JP2004520633A/ja active Pending
- 1999-11-03 AU AU24731/00A patent/AU755859B2/en not_active Ceased
- 1999-11-03 BR BR9906714-5A patent/BR9906714A/pt not_active IP Right Cessation
- 1999-11-03 CN CN99803525A patent/CN1292125A/zh active Pending
- 1999-11-03 EP EP99968035A patent/EP1049997B1/de not_active Expired - Lifetime
- 1999-11-03 DE DE69935657T patent/DE69935657T2/de not_active Expired - Lifetime
- 1999-11-03 IL IL13712799A patent/IL137127A/xx not_active IP Right Cessation
-
2000
- 2000-06-30 ZA ZA200003317A patent/ZA200003317B/xx unknown
Also Published As
Publication number | Publication date |
---|---|
CA2325863A1 (en) | 2000-05-18 |
DE69935657D1 (de) | 2007-05-10 |
AU2473100A (en) | 2000-05-29 |
ZA200003317B (en) | 2002-12-02 |
JP2004520633A (ja) | 2004-07-08 |
EP1049997A1 (de) | 2000-11-08 |
BR9906714A (pt) | 2000-10-17 |
DE69935657T2 (de) | 2007-12-13 |
AU755859B2 (en) | 2003-01-02 |
WO2000028439A1 (en) | 2000-05-18 |
ATE358297T1 (de) | 2007-04-15 |
EP1049997B1 (de) | 2007-03-28 |
CN1292125A (zh) | 2001-04-18 |
IL137127A0 (en) | 2001-07-24 |
US6192357B1 (en) | 2001-02-20 |
EP1049997A4 (de) | 2005-08-03 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
IL137127A0 (en) | Method and apparatus for optimizing query generation by selectively utilizing attributes or key values | |
NZ326982A (en) | Evaluation of the content of a data set using multiple and/or complex queries | |
CA2232938A1 (en) | Method and apparatus for performing a join query in a database system | |
TW357526B (en) | Improved generation of encryption key | |
CA2329558A1 (en) | Methods and apparatus for similarity text search based on conceptual indexing | |
AU2002368176A1 (en) | System, method and apparatus for conducting a keyterm search | |
EP0860786A3 (de) | System und Verfahren zum hierarchischen Zusammenstellen und Einordnen eines Satzes von Objekten in einem Abfragekontext | |
TW358288B (en) | Method and apparatus for verifying records in a table the invention relates to a method and apparatus for verifying records in a table | |
WO1997023099A3 (en) | Method and apparatus for tracking connection-oriented communications configurations | |
WO2004029755A3 (en) | Automated report building system | |
AU3092099A (en) | Perspective transformations on relational database tables | |
AU2001287414A1 (en) | Concept identification system and method for use in reducing and/or representing text content of an electronic document | |
ID22088A (id) | Kunci silinder yang dapat dirancang, yang dibuat dengan kunci-kunci induk | |
CA2385814A1 (en) | Document management method and document management system | |
ATE186569T1 (de) | In situ extraktion mikrobieller dna | |
ATE363779T1 (de) | Vorprüfung und zertifizierung von mehrfachzugriffscodes | |
WO2001033314A3 (en) | Adaptive behavior modification system with intelligent agent | |
WO2002027662A3 (en) | System and method for processing layout of graphical objects with elastic properties | |
DE60104658D1 (de) | Datenwiederherstellung in einem verteilten system | |
UA28046C2 (uk) | Приєднувальна колодка для високошвидкісної передачі інформації в телекомунікаційній та обчислювальній техніці | |
TW358190B (en) | Files management system | |
EP0913781A3 (de) | Statische Reduktion von Teilordnungen | |
WO2002033587A3 (en) | Database linking method and apparatus | |
GB2366166B (en) | Methods, systems and computer program products for providing secure client profile completion by network intermediaries | |
WO2005008544A8 (en) | System and method for multiple model object sharing |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
FF | Patent granted | ||
KB | Patent renewed | ||
MM9K | Patent not in force due to non-payment of renewal fees |