WO2001073608A3 - System and method for providing cross-dimensional computation and data access in an on-line analytical processing (olap) environment - Google Patents
System and method for providing cross-dimensional computation and data access in an on-line analytical processing (olap) environment Download PDFInfo
- Publication number
- WO2001073608A3 WO2001073608A3 PCT/US2001/006824 US0106824W WO0173608A3 WO 2001073608 A3 WO2001073608 A3 WO 2001073608A3 US 0106824 W US0106824 W US 0106824W WO 0173608 A3 WO0173608 A3 WO 0173608A3
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- olap
- environment
- analytical processing
- data access
- line analytical
- 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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured databases
-
- 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/99941—Database schema or data structure
- Y10S707/99943—Generating database or data structure, e.g. via user interface
Abstract
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
DE10195968T DE10195968B4 (en) | 2000-03-24 | 2001-03-01 | System and method for providing a cross-dimensional computation and a cross-dimensional data access in an on-line analytical processing environment (ON-LINE ANALYTICAL PROCESSING = OLAP) |
AU2001240022A AU2001240022A1 (en) | 2000-03-24 | 2001-03-01 | System and method for providing cross-dimensional computation and data access in an on-line analytical processing (olap) environment |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/535,905 US6574619B1 (en) | 2000-03-24 | 2000-03-24 | System and method for providing cross-dimensional computation and data access in an on-line analytical processing (OLAP) environment |
US09/535,905 | 2000-03-24 |
Publications (2)
Publication Number | Publication Date |
---|---|
WO2001073608A2 WO2001073608A2 (en) | 2001-10-04 |
WO2001073608A3 true WO2001073608A3 (en) | 2004-03-25 |
Family
ID=24136283
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US2001/006824 WO2001073608A2 (en) | 2000-03-24 | 2001-03-01 | System and method for providing cross-dimensional computation and data access in an on-line analytical processing (olap) environment |
Country Status (5)
Country | Link |
---|---|
US (1) | US6574619B1 (en) |
AU (1) | AU2001240022A1 (en) |
DE (1) | DE10195968B4 (en) |
TW (1) | TW580626B (en) |
WO (1) | WO2001073608A2 (en) |
Families Citing this family (32)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7096220B1 (en) | 2000-05-24 | 2006-08-22 | Reachforce, Inc. | Web-based customer prospects harvester system |
US7082427B1 (en) | 2000-05-24 | 2006-07-25 | Reachforce, Inc. | Text indexing system to index, query the archive database document by keyword data representing the content of the documents and by contact data associated with the participant who generated the document |
US7003517B1 (en) * | 2000-05-24 | 2006-02-21 | Inetprofit, Inc. | Web-based system and method for archiving and searching participant-based internet text sources for customer lead data |
US7120629B1 (en) * | 2000-05-24 | 2006-10-10 | Reachforce, Inc. | Prospects harvester system for providing contact data about customers of product or service offered by business enterprise extracting text documents selected from newsgroups, discussion forums, mailing lists, querying such data to provide customers who confirm to business profile data |
TW577003B (en) * | 2000-09-29 | 2004-02-21 | Manugistics Inc | System, network, storage device, and method for supply chain management, including collaboration |
US7330850B1 (en) | 2000-10-04 | 2008-02-12 | Reachforce, Inc. | Text mining system for web-based business intelligence applied to web site server logs |
US7043531B1 (en) | 2000-10-04 | 2006-05-09 | Inetprofit, Inc. | Web-based customer lead generator system with pre-emptive profiling |
TW541483B (en) * | 2000-10-27 | 2003-07-11 | Manugistics Inc | System and method for ensuring order fulfillment |
US6988104B2 (en) * | 2001-04-02 | 2006-01-17 | I2 Technologies U.S., Inc. | System and method for allocating data in a hierarchical organization of data |
US20020184260A1 (en) * | 2001-05-30 | 2002-12-05 | Paul Martin | Multidimensional data entry in a spreadsheet |
US20030009649A1 (en) * | 2001-05-30 | 2003-01-09 | Paul Martin | Dynamic conversion of spreadsheet formulas to multidimensional calculation rules |
US7447687B2 (en) * | 2002-05-10 | 2008-11-04 | International Business Machines Corporation | Methods to browse database query information |
US9704108B2 (en) * | 2002-06-07 | 2017-07-11 | Jda Software Group, Inc. | System and method for network visualization and plan review |
US7716167B2 (en) * | 2002-12-18 | 2010-05-11 | International Business Machines Corporation | System and method for automatically building an OLAP model in a relational database |
US7181450B2 (en) | 2002-12-18 | 2007-02-20 | International Business Machines Corporation | Method, system, and program for use of metadata to create multidimensional cubes in a relational database |
US8683016B1 (en) | 2002-12-20 | 2014-03-25 | Versata Development Group, Inc. | Data recording components and processes for acquiring selected web site data |
US7953694B2 (en) * | 2003-01-13 | 2011-05-31 | International Business Machines Corporation | Method, system, and program for specifying multidimensional calculations for a relational OLAP engine |
US7895191B2 (en) | 2003-04-09 | 2011-02-22 | International Business Machines Corporation | Improving performance of database queries |
US7366725B2 (en) * | 2003-08-11 | 2008-04-29 | Descisys Limited | Method and apparatus for data validation in multidimensional database |
US7734661B2 (en) * | 2003-08-11 | 2010-06-08 | Descisys Limited | Method and apparatus for accessing multidimensional data |
US7707143B2 (en) | 2004-06-14 | 2010-04-27 | International Business Machines Corporation | Systems, methods, and computer program products that automatically discover metadata objects and generate multidimensional models |
US9002778B2 (en) * | 2004-06-22 | 2015-04-07 | International Business Machines Corporation | Designing aggregates based on access patterns in dimensions |
US20050283494A1 (en) * | 2004-06-22 | 2005-12-22 | International Business Machines Corporation | Visualizing and manipulating multidimensional OLAP models graphically |
US7480663B2 (en) * | 2004-06-22 | 2009-01-20 | International Business Machines Corporation | Model based optimization with focus regions |
US20070078698A1 (en) * | 2005-10-05 | 2007-04-05 | International Business Machines Corporation | Supply and demand planning by omitting order item |
US7970735B2 (en) * | 2006-03-20 | 2011-06-28 | Microsoft Corporation | Cross varying dimension support for analysis services engine |
US7756854B2 (en) * | 2007-04-25 | 2010-07-13 | International Business Machines Corporation | Minimization of calculation retrieval in a multidimensional database |
US20090006455A1 (en) * | 2007-06-30 | 2009-01-01 | Microsoft Corporation | Automated time metadata deduction |
US20090287666A1 (en) * | 2008-05-13 | 2009-11-19 | International Business Machines Corporation | Partitioning of measures of an olap cube using static and dynamic criteria |
US9110970B2 (en) * | 2008-07-25 | 2015-08-18 | International Business Machines Corporation | Destructuring and restructuring relational data |
US8972463B2 (en) * | 2008-07-25 | 2015-03-03 | International Business Machines Corporation | Method and apparatus for functional integration of metadata |
US8943087B2 (en) * | 2008-07-25 | 2015-01-27 | International Business Machines Corporation | Processing data from diverse databases |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5905985A (en) * | 1997-06-30 | 1999-05-18 | International Business Machines Corporation | Relational database modifications based on multi-dimensional database modifications |
Family Cites Families (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5359724A (en) | 1992-03-30 | 1994-10-25 | Arbor Software Corporation | Method and apparatus for storing and retrieving multi-dimensional data in computer memory |
US5943668A (en) * | 1997-06-30 | 1999-08-24 | International Business Machines Corporation | Relational emulation of a multi-dimensional database |
US6317750B1 (en) * | 1998-10-26 | 2001-11-13 | Hyperion Solutions Corporation | Method and apparatus for accessing multidimensional data |
US6381605B1 (en) * | 1999-05-29 | 2002-04-30 | Oracle Corporation | Heirarchical indexing of multi-attribute data by sorting, dividing and storing subsets |
US6374234B1 (en) * | 1999-06-22 | 2002-04-16 | Microsoft Corporation | Aggregations performance estimation in database systems |
US6408292B1 (en) * | 1999-08-04 | 2002-06-18 | Hyperroll, Israel, Ltd. | Method of and system for managing multi-dimensional databases using modular-arithmetic based address data mapping processes on integer-encoded business dimensions |
-
2000
- 2000-03-24 US US09/535,905 patent/US6574619B1/en not_active Expired - Lifetime
-
2001
- 2001-03-01 AU AU2001240022A patent/AU2001240022A1/en not_active Abandoned
- 2001-03-01 WO PCT/US2001/006824 patent/WO2001073608A2/en active Application Filing
- 2001-03-01 DE DE10195968T patent/DE10195968B4/en not_active Expired - Fee Related
- 2001-03-23 TW TW090106929A patent/TW580626B/en not_active IP Right Cessation
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5905985A (en) * | 1997-06-30 | 1999-05-18 | International Business Machines Corporation | Relational database modifications based on multi-dimensional database modifications |
Also Published As
Publication number | Publication date |
---|---|
US6574619B1 (en) | 2003-06-03 |
WO2001073608A2 (en) | 2001-10-04 |
TW580626B (en) | 2004-03-21 |
DE10195968B4 (en) | 2010-04-22 |
AU2001240022A1 (en) | 2001-10-08 |
DE10195968T1 (en) | 2003-02-27 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2001073608A3 (en) | System and method for providing cross-dimensional computation and data access in an on-line analytical processing (olap) environment | |
WO2000067194A3 (en) | Method and apparatus for scalable probabilistic clustering using decision trees | |
CA2304646A1 (en) | Online database mining | |
WO2005019997A3 (en) | System and method for cross attribute analysis and manipulation in online analytical processing (olap) and multi-dimensional planning applications by dimension splitting | |
CA2276036A1 (en) | Method and apparatus for secure storage of data | |
EP1182597A3 (en) | Electronic sourcing system | |
MXPA05009733A (en) | System and method to acquire information from a database. | |
EP1161092A3 (en) | Electronic-program-guide retrieval method and system | |
WO1997015015A3 (en) | Information system and process for storing data therein | |
WO2000042553A3 (en) | Method and apparatus for processing business information from multiple enterprises | |
CA2448223A1 (en) | System and method for web server with a reconfigurable processor operating under single operation system image | |
CA2204797A1 (en) | Multiple database access server for application programs | |
WO1998037474A3 (en) | An information organization and collaboration tool for processing notes and action requests in computer systems | |
CA2291077A1 (en) | A reference based parametric dimensioning method and system | |
HUP0301073A2 (en) | Method, systems and computer for finding value and reducing risk in purchasing portfolios of assets | |
AU1713500A (en) | Video description system and method | |
WO2000023863A3 (en) | Determining differences between two or more metadata models | |
WO1999046662A3 (en) | System for operating on client defined rules | |
WO2005048038A3 (en) | Personal information space management system and method | |
CA2392675A1 (en) | Database system and method | |
WO2001042882A3 (en) | Timeshared electronic catalog system and method | |
WO2002091135A3 (en) | Global compliance system | |
EP1128277A3 (en) | Data processing method and system, program for realizing the method, and computer readable storage medium storing the program | |
WO2004029762A3 (en) | System and method for providing enhanced services in a multi-channel interactive distributed environment | |
EP0822504A3 (en) | Method and system for locating and sampling of data in parallel processing systems |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A2 Designated state(s): AE AG AL AM AT AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ CZ DE DE DK DK DM DZ EE EE ES FI FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SK SL TJ TM TR TT TZ UA UG UZ VN YU ZA ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A2 Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
122 | Ep: pct application non-entry in european phase | ||
NENP | Non-entry into the national phase |
Ref country code: JP |
|
REG | Reference to national code |
Ref country code: DE Ref legal event code: 8607 |