AU2015353782A1 - Relation aware aggregation (RAA) on normalized datasets - Google Patents

Relation aware aggregation (RAA) on normalized datasets Download PDF

Info

Publication number
AU2015353782A1
AU2015353782A1 AU2015353782A AU2015353782A AU2015353782A1 AU 2015353782 A1 AU2015353782 A1 AU 2015353782A1 AU 2015353782 A AU2015353782 A AU 2015353782A AU 2015353782 A AU2015353782 A AU 2015353782A AU 2015353782 A1 AU2015353782 A1 AU 2015353782A1
Authority
AU
Australia
Prior art keywords
distinct
record
database
value
key value
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.)
Abandoned
Application number
AU2015353782A
Other languages
English (en)
Inventor
Scott Hoover
Lloyd Tabb
Michael Toy
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Looker Data Sciences Inc
Original Assignee
Looker Data Sciences Inc
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Looker Data Sciences Inc filed Critical Looker Data Sciences Inc
Publication of AU2015353782A1 publication Critical patent/AU2015353782A1/en
Priority to AU2018282315A priority Critical patent/AU2018282315B2/en
Abandoned legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/21—Design, administration or maintenance of databases
    • G06F16/211—Schema design and management
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/242—Query formulation
    • G06F16/2433—Query languages
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24554—Unary operations; Data partitioning operations
    • G06F16/24556—Aggregation; Duplicate elimination

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
AU2015353782A 2014-11-26 2015-11-23 Relation aware aggregation (RAA) on normalized datasets Abandoned AU2015353782A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2018282315A AU2018282315B2 (en) 2014-11-26 2018-12-19 Relation aware aggregation (RAA) on normalized datasets

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US14/555,013 US10176226B2 (en) 2014-11-26 2014-11-26 Relation aware aggregation (RAA) on normalized datasets
US14/555,013 2014-11-26
PCT/US2015/062185 WO2016085875A1 (en) 2014-11-26 2015-11-23 Relation aware aggregation (raa) on normalized datasets

Related Child Applications (1)

Application Number Title Priority Date Filing Date
AU2018282315A Division AU2018282315B2 (en) 2014-11-26 2018-12-19 Relation aware aggregation (RAA) on normalized datasets

Publications (1)

Publication Number Publication Date
AU2015353782A1 true AU2015353782A1 (en) 2017-06-15

Family

ID=56010458

Family Applications (2)

Application Number Title Priority Date Filing Date
AU2015353782A Abandoned AU2015353782A1 (en) 2014-11-26 2015-11-23 Relation aware aggregation (RAA) on normalized datasets
AU2018282315A Active AU2018282315B2 (en) 2014-11-26 2018-12-19 Relation aware aggregation (RAA) on normalized datasets

Family Applications After (1)

Application Number Title Priority Date Filing Date
AU2018282315A Active AU2018282315B2 (en) 2014-11-26 2018-12-19 Relation aware aggregation (RAA) on normalized datasets

Country Status (6)

Country Link
US (1) US10176226B2 (enExample)
EP (1) EP3224745B1 (enExample)
JP (1) JP6517930B2 (enExample)
AU (2) AU2015353782A1 (enExample)
CA (1) CA2965831C (enExample)
WO (1) WO2016085875A1 (enExample)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2020024483A (ja) * 2018-08-06 2020-02-13 京セラドキュメントソリューションズ株式会社 データ管理システムおよびデータ管理プログラム
US11921991B2 (en) 2020-01-17 2024-03-05 Target Brands, Inc. Data visualization tool with guided visualization creation and secure publication features, and graphical user interface thereof
US11847170B2 (en) 2020-01-17 2023-12-19 Target Brands, Inc. Data visualization tool with guided visualization creation and secure publication features, and graphical user interface thereof
USD941836S1 (en) 2020-01-17 2022-01-25 Target Brands, Inc. Display panel or portion thereof with a computer-generated graphical user interface

Family Cites Families (27)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6282541B1 (en) * 1997-07-28 2001-08-28 International Business Machines Corporation Efficient groupby aggregation in tournament tree sort
US6480836B1 (en) * 1998-03-27 2002-11-12 International Business Machines Corporation System and method for determining and generating candidate views for a database
US6477525B1 (en) * 1998-12-28 2002-11-05 Oracle Corporation Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joins
US6430550B1 (en) * 1999-12-03 2002-08-06 Oracle Corporation Parallel distinct aggregates
US6947934B1 (en) * 2000-02-16 2005-09-20 International Business Machines Corporation Aggregate predicates and search in a database management system
JP2001243242A (ja) * 2000-02-25 2001-09-07 Hitachi Ltd 問合せ処理方法およびそれを実施するデータベース管理システムその処理プログラムを格納した記録媒体
US6775682B1 (en) * 2002-02-26 2004-08-10 Oracle International Corporation Evaluation of rollups with distinct aggregates by using sequence of sorts and partitioning by measures
US6850927B1 (en) * 2002-05-21 2005-02-01 Oracle International Corporation Evaluating queries with outer joins by categorizing and processing combinations of relationships between table records
US7487140B2 (en) * 2002-12-17 2009-02-03 International Business Machines Corporation Method for executing a query having multiple distinct key columns
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
US7707144B2 (en) * 2003-12-23 2010-04-27 Siebel Systems, Inc. Optimization for aggregate navigation for distinct count metrics
US7469241B2 (en) * 2004-11-30 2008-12-23 Oracle International Corporation Efficient data aggregation operations using hash tables
US7584205B2 (en) * 2005-06-27 2009-09-01 Ab Initio Technology Llc Aggregating data with complex operations
US7930547B2 (en) * 2007-06-15 2011-04-19 Alcatel-Lucent Usa Inc. High accuracy bloom filter using partitioned hashing
US9244974B2 (en) 2007-09-14 2016-01-26 International Business Machines Corporation Optimization of database queries including grouped aggregation functions
US8122033B2 (en) * 2008-01-09 2012-02-21 International Business Machines Corporation Database query optimization
US8005868B2 (en) * 2008-03-07 2011-08-23 International Business Machines Corporation System and method for multiple distinct aggregate queries
US8352458B2 (en) * 2008-05-07 2013-01-08 Oracle International Corporation Techniques for transforming and loading data into a fact table in a data warehouse
US8478775B2 (en) * 2008-10-05 2013-07-02 Microsoft Corporation Efficient large-scale filtering and/or sorting for querying of column based data encoded structures
US8914354B2 (en) * 2009-07-28 2014-12-16 Teradata Us, Inc. Cardinality and selectivity estimation using a single table join index
US9213732B2 (en) * 2012-12-28 2015-12-15 Sap Ag Hash table and radix sort based aggregation
US20120215810A1 (en) 2011-02-11 2012-08-23 Prometheus Research, LLC Database query mechanism using links as an aggregate base
US9305065B2 (en) * 2012-04-26 2016-04-05 Sap Se Calculating count distinct using vertical unions
US10191984B2 (en) 2013-03-15 2019-01-29 Looker Data Sciences Inc. Systems and methods for cancelling a query
EP2790113B1 (en) 2013-04-11 2017-01-04 Hasso-Plattner-Institut für Softwaresystemtechnik GmbH Aggregate query-caching in databases architectures with a differential buffer and a main store
US9471710B2 (en) * 2013-06-14 2016-10-18 International Business Machines Corporation On-the-fly encoding method for efficient grouping and aggregation
US9378264B2 (en) * 2013-06-18 2016-06-28 Sap Se Removing group-by characteristics in formula exception aggregation

Also Published As

Publication number Publication date
AU2018282315B2 (en) 2020-04-16
EP3224745A1 (en) 2017-10-04
US20160147881A1 (en) 2016-05-26
AU2018282315A1 (en) 2019-01-24
EP3224745B1 (en) 2020-09-23
JP2017537383A (ja) 2017-12-14
EP3224745A4 (en) 2018-07-11
CA2965831C (en) 2023-01-03
WO2016085875A1 (en) 2016-06-02
US10176226B2 (en) 2019-01-08
JP6517930B2 (ja) 2019-05-22
CA2965831A1 (en) 2016-06-02

Similar Documents

Publication Publication Date Title
US20230376487A1 (en) Processing database queries using format conversion
US11481403B2 (en) Ranking contextual metadata to generate relevant data insights
US9892178B2 (en) Systems and methods for interest-driven business intelligence systems including event-oriented data
US10824613B2 (en) Preconfiguring measures and dimensions in a database analytics application
US20110218978A1 (en) Operating on time sequences of data
AU2018282315B2 (en) Relation aware aggregation (RAA) on normalized datasets
WO2011090519A1 (en) Accessing large collection object tables in a database
US11354332B2 (en) Enabling data access by external cloud-based analytics system
US20180101622A1 (en) Perform graph traversal with graph query language
US20170195449A1 (en) Smart proxy for datasources
RU2755568C1 (ru) Способ параллельного выполнения операции JOIN при обработке больших структурированных высокоактивных данных
EP3818451B1 (en) Index data structures and graphical user interface
CN118227618A (zh) 数据管理方法及装置、电子设备和存储介质
Shah et al. A systematic review of in-memory database over multi-tenancy
Wang et al. Distributed and parallel construction method for equi-width histogram in cloud database
Rajadnye Is Datawarehouse Relevant in the Era of Big Data?
CN118296046A (zh) 数据表连接方法、装置、设备及介质
Shang et al. Advanced a new vector data query optimization method based on Cost function

Legal Events

Date Code Title Description
MK5 Application lapsed section 142(2)(e) - patent request and compl. specification not accepted