JP6517930B2 - 正規化されたデータセットの関係認識集約（ｒａａ） - Google Patents

正規化されたデータセットの関係認識集約（ｒａａ） Download PDF

Info

Publication number
JP6517930B2
JP6517930B2 JP2017522387A JP2017522387A JP6517930B2 JP 6517930 B2 JP6517930 B2 JP 6517930B2 JP 2017522387 A JP2017522387 A JP 2017522387A JP 2017522387 A JP2017522387 A JP 2017522387A JP 6517930 B2 JP6517930 B2 JP 6517930B2
Authority
JP
Japan
Prior art keywords
value
record
unique
database
sum
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.)
Active
Application number
JP2017522387A
Other languages
English (en)
Japanese (ja)
Other versions
JP2017537383A (ja
JP2017537383A5 (enExample
Inventor
ロイド タブ
ロイド タブ
マイケル トイ
マイケル トイ
スコット フーバー
スコット フーバー
Original Assignee
ルッカー データ サイエンシズ インコーポレイテッド
ルッカー データ サイエンシズ インコーポレイテッド
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 ルッカー データ サイエンシズ インコーポレイテッド, ルッカー データ サイエンシズ インコーポレイテッド filed Critical ルッカー データ サイエンシズ インコーポレイテッド
Publication of JP2017537383A publication Critical patent/JP2017537383A/ja
Publication of JP2017537383A5 publication Critical patent/JP2017537383A5/ja
Application granted granted Critical
Publication of JP6517930B2 publication Critical patent/JP6517930B2/ja
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

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)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (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)
JP2017522387A 2014-11-26 2015-11-23 正規化されたデータセットの関係認識集約（ｒａａ） Active JP6517930B2 (ja)

Applications Claiming Priority (3)

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

Publications (3)

Publication Number Publication Date
JP2017537383A JP2017537383A (ja) 2017-12-14
JP2017537383A5 JP2017537383A5 (enExample) 2019-01-10
JP6517930B2 true JP6517930B2 (ja) 2019-05-22

Family

ID=56010458

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2017522387A Active JP6517930B2 (ja) 2014-11-26 2015-11-23 正規化されたデータセットの関係認識集約（ｒａａ）

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
WO1999050762A1 (en) * 1998-03-27 1999-10-07 Informix Software, Inc. Processing precomputed views
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
WO2016085875A1 (en) 2016-06-02
JP2017537383A (ja) 2017-12-14
AU2015353782A1 (en) 2017-06-15
EP3224745A4 (en) 2018-07-11
US20160147881A1 (en) 2016-05-26
EP3224745B1 (en) 2020-09-23
AU2018282315A1 (en) 2019-01-24
EP3224745A1 (en) 2017-10-04
CA2965831A1 (en) 2016-06-02
CA2965831C (en) 2023-01-03
AU2018282315B2 (en) 2020-04-16
US10176226B2 (en) 2019-01-08

Similar Documents

Publication Publication Date Title
US10860598B2 (en) Systems and methods for interest-driven business intelligence systems including event-oriented data
JP6258549B2 (ja) 個別のデータ値に対する効率よい演算を行うための方法、装置、並びにコンピュータ可読媒体
US9244976B1 (en) Just-in-time analytics on large file systems and hidden databases
JP2021511582A (ja) Ｓｑｌクエリプランを最適化するための次元コンテキスト伝搬技術
US7627555B2 (en) Combining multidimensional expressions and data mining extensions to mine OLAP cubes
US20150081353A1 (en) Systems and Methods for Interest-Driven Business Intelligence Systems Including Segment Data
AU2018282315B2 (en) Relation aware aggregation (RAA) on normalized datasets
US9633077B2 (en) Query of multiple unjoined views
US20160162521A1 (en) Systems and Methods for Data Ingest in Interest-Driven Business Intelligence Systems
EP2526479A1 (en) Accessing large collection object tables in a database
US20180357278A1 (en) Processing aggregate queries in a graph database
US20160379148A1 (en) System and Methods for Interest-Driven Business Intelligence Systems with Enhanced Data Pipelines
Hamoud et al. Using OLAP with diseases registry warehouse for clinical decision support
US10496948B1 (en) Computer trend visualization using quadratic simplified closed form linear regression
Aydin et al. Data modelling for large-scale social media analytics: design challenges and lessons learned
US10318524B2 (en) Reporting and data governance management
Xie et al. Cohort analysis with ease
US10423629B2 (en) Intelligent tabular big data presentation in search environment based on prior human input configuration
Shah et al. A systematic review of in-memory database over multi-tenancy
US9195690B2 (en) Iterative measures
Bouchakri et al. A coding template for handling static and incremental horizontal partitioning in data warehouses
Elsayed et al. Towards large-scale scientific dataspaces for e-science applications
US20150006228A1 (en) Stock coverage calculation in an olap engine
Kiruthika et al. Performance Analysis of Faculty and Students Using Neo 4j
Martín et al. Enabling cross constraint satisfaction in RDF-based heterogeneous database integration

Legal Events

Date Code Title Description
RD02 Notification of acceptance of power of attorney

Free format text: JAPANESE INTERMEDIATE CODE: A7422

Effective date: 20180411

RD04 Notification of resignation of power of attorney

Free format text: JAPANESE INTERMEDIATE CODE: A7424

Effective date: 20180530

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20181120

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20181120

A871 Explanation of circumstances concerning accelerated examination

Free format text: JAPANESE INTERMEDIATE CODE: A871

Effective date: 20181120

A975 Report on accelerated examination

Free format text: JAPANESE INTERMEDIATE CODE: A971005

Effective date: 20181204

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20190304

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20190409

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20190418

R150 Certificate of patent or registration of utility model

Ref document number: 6517930

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

S111 Request for change of ownership or part of ownership

Free format text: JAPANESE INTERMEDIATE CODE: R313113

R350 Written notification of registration of transfer

Free format text: JAPANESE INTERMEDIATE CODE: R350

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250