RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS) HAVING INTEGRATED AGGREGATION ENGINE AND NON-RELATIONAL MULTI-DIMENSIONAL DATA STORE OF AGGREGATED DATA ELEMENTS

Patent №

US 6,385,604

Granted

2002-05-07

Filed 2000

Owner

HYPERROLL, ISRAEL LIMITED, A CORPORATION OF ISRAEL

+4 more

Lab

—

AI components

ml · nlp · planning

Assignment

Recorded

Dataset

AIPD

2023_r1 edition

Application

09634748

View graph

Improved method of and apparatus for joining and aggregating data elements integrated within a relational database management system (RDBMS) using a non-relational multi-dimensional data structure (MDD). The improved RDBMS system of the present invention can be used to realize achieving a significant increase in system performance (e.g. [deceased] decreased access/search time), user flexibility and ease of use. The improved RDBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system or the like.

Machine learning Natural language PlanningC03B 37/02718G06F 16/283C03B 2203/36C03B 2205/42C03B 2205/55Y10S 707/99933Y10S 707/99935Y10S 707/99943

Google Patents

AI classification

Planning1.00

Natural language0.99

Machine learning0.61

AI hardware0.10

Knowledge representation0.01

Vision0.00

Evolutionary computation0.00

Speech0.00

Ownership

HYPERROLL, ISRAEL LIMITED, A CORPORATION OF ISRAEL

assignment · 114680106

HYPEROLL ISRAEL, LTD.

assignment · 234560688

HYPERROLL ISRAEL, LTD.

correct · 237200943

YANICKLO TECHNOLOGY LIMITED LIABILITY COMPANY

assignment · 242780604

TAMIRAS PER PTE. LTD., LLC

merger · 369380644

Assignors

BAKALASH, REUVEN, SHAKED, GUY, CASPI, JOSEPH

On an employer assignment, the assignors are typically the inventors.

Cites (23)

INTEGRATED DATABASE AND DATA-MINING SYSTEMUS 6,324,533 · 2001 METHOD AND APPARATUS FOR STORING, RETRIEVING, AND PROCESSING MULTI-DIMENSIONAL CUSTOMER TRANSACTION AND ASSOCIATED DEMOGRAPHIC DATA SETS IN MEMORY CELLS AND DATA LISTSUS 6,182,060 · 2001 SYSTEM AND METHOD FOR AUTOMATIC TRANSMISSION OF ON-LINE ANALYTICAL PROCESSING SYSTEM REPORT OUTPUTUS 6,173,310 · 2001 METHOD AND APPARATUS FOR CREATING AGGREGATES FOR USE IN A DATAMARTUS 6,161,103 · 2000 COMPPUTER ARCHITECTURE AND METHOD FOR COLLECTING ANALYZING AND/OR TRANSFORMING INTERNET AND/OR ELECTRONIC COMMERCE DATA FOR STORAGE INTO A DATA STORAGE AREAUS 6,151,601 · 2000 A METHOD AND APPARATUS FOR OPTIMIZING AND STRUCTURING DATA BY DESIGNING A CUBE FOREST DATA STRUCTURE FOR A HIERARCHICALLY SPLIT CUBE FOREST TEMPLATEUS 6,141,655 · 2000 METHOD, APPARATUS AND PROGRAMMED MEDIUM FOR APPROXIMATING THE DATA CUBE AND OBTAINING APPROXIMATE ANSWERS TO QUERIES IN RELATIONAL DATABASESUS 6,108,647 · 2000 SUMMARY TABLE MANAGEMENT IN A COMPUTER SYSTEMUS 6,023,695 · 2000 AUTOMATIC SUBSPACE CLUSTERING OF HIGH DIMENSIONAL DATA FOR DATA MINING APPLICATIONSUS 6,003,029 · 1999 REWRITING A QUERY IN TERMS OF A SUMMARY BASED ON AGGREGATE COMPUTABILITY AND CANONICAL FORMAT AND WHEN A DIMENSION TABLE IS ON THE CHILD SIDE OF AN OUTER JOINUS 5,991,754 · 1999 METHOD OF CALCULATING TUPLES FOR DATA CUBESUS 5,987,467 · 1999 METHOD AND SYSTEM FOR PERFORMING RANGE MAX/MIN QUERIES ON A DATA CUBEUS 5,926,820 · 1999 METHOD AND SYSTEM FOR PERFORMING PARTIAL-SUM QUERIES ON A DATA CUBEUS 5,890,151 · 1999 LANGUAGE AND METHOD FOR CREATING, ORGANIZING , AND RETRIEVING DATA FROM A DATABASEUS 5,857,184 · 1999 IMPROVED METHOD AND APPARATUS FOR PARALLEL PROCESSING AGGREGATES USING INTERMEDIATE AGGREGATE VALUESUS 5,850,547 · 1998 DATABASE SYSTEM AND METHOD EMPLOYING DATA CUBE OPERATOR FOR GROUP-BY OPERATIONSUS 5,832,475 · 1998 EFFICIENT MULTIDIMENSIONAL DATA AGGREGATION OPERATOR IMPLEMENTATIONUS 5,822,751 · 1998 METHOD AND SYSTEM FOR AGGREGATING OBJECTSUS 5,805,885 · 1998 METHOD AND SYSTEM FOR PERFORMING RANGE-SUM QUERIES ON A DATA CUBEUS 5,799,300 · 1998 METHOD AND SYSTEM FOR EFFICIENTLY PERFORMING DATABASE TABLE AGGREGATION USING AN AGGREGATION INDEXUS 5,781,896 · 1998 METHOD AND SYSTEM FOR AGGREGATING OBJECTSUS 5,745,764 · 1998 METHODS AND APPARATUS FOR ACCESSING NON-RELATIONAL DATA FILES USING RELATIONAL QUERIESUS 5,379,419 · 1995 DATABASE SYSTEM WITH MULTI-DIMENSIONAL SUMMARY SEARCH TREE NODES FOR REDUCING THE NECESSITY TO ACCESS RECORDSUS 5,257,365 · 1993

Cited by (228)

METHOD AND SYSTEM FOR ADAPTING PROGRAMS FOR INTEROPERABILITY AND ADAPTERS THEREFORUS 11,714,822 · 2023 Using an Object Model of Heterogeneous Data to Facilitate Building Data VisualizationsUS 11,620,315 · 2023 SYSTEMS AND METHODS FOR MANAGING DISTRIBUTED DATABASE DEPLOYMENTSUS 11,615,115 · 2023 SYSTEMS AND METHODS FOR MONITORING DISTRIBUTED DATABASE DEPLOYMENTSUS 11,544,154 · 2023 AGGREGATION FRAMEWORK SYSTEM ARCHITECTURE AND METHOD

Related research

Multi Relational Data Mining Approaches: A Data Mining TechniquearXiv Efficient Model-Relational Data Management: Challenges and OpportunitiesSemantic Scholar Relational Database Distillation: From Structured Tables to Condensed Graph DataarXiv Joining Entities Across Relation and Graph with a Unified ModelOpenAlex Web3DB: Web 3.0 RDBMS for Individual Data OwnershipOpenAlex

Full text

Google Patents