JP6192800B2 - 個別のデータ値に対する効率よい演算を行うための方法、装置、並びにコンピュータ可読媒体 - Google Patents

個別のデータ値に対する効率よい演算を行うための方法、装置、並びにコンピュータ可読媒体 Download PDF

Info

Publication number
JP6192800B2
JP6192800B2 JP2016502660A JP2016502660A JP6192800B2 JP 6192800 B2 JP6192800 B2 JP 6192800B2 JP 2016502660 A JP2016502660 A JP 2016502660A JP 2016502660 A JP2016502660 A JP 2016502660A JP 6192800 B2 JP6192800 B2 JP 6192800B2
Authority
JP
Japan
Prior art keywords
entity
global
partition
group
domain
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
JP2016502660A
Other languages
English (en)
Japanese (ja)
Other versions
JP2016516246A5 (enExample
JP2016516246A (ja
Inventor
リチャード グロンディン、
リチャード グロンディン、
ユージェニー ファデエイチェフ、
ユージェニー ファデエイチェフ、
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.)
Informatica LLC
Original Assignee
Informatica LLC
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 Informatica LLC filed Critical Informatica LLC
Publication of JP2016516246A publication Critical patent/JP2016516246A/ja
Publication of JP2016516246A5 publication Critical patent/JP2016516246A5/ja
Application granted granted Critical
Publication of JP6192800B2 publication Critical patent/JP6192800B2/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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • G06F16/285—Clustering or classification
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/221—Column-oriented storage; Management thereof
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • 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
    • 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
    • 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G06F16/278—Data partitioning, e.g. horizontal or vertical partitioning
    • 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/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 OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
    • G06F16/84—Mapping; Conversion
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/10—Complex mathematical operations
    • G06F17/16—Matrix or vector computation, e.g. matrix-matrix or matrix-vector multiplication, matrix factorization

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Computing Systems (AREA)
  • Mathematical Physics (AREA)
  • Computational Mathematics (AREA)
  • Mathematical Analysis (AREA)
  • Mathematical Optimization (AREA)
  • Pure & Applied Mathematics (AREA)
  • Algebra (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2016502660A 2013-03-15 2014-03-14 個別のデータ値に対する効率よい演算を行うための方法、装置、並びにコンピュータ可読媒体 Active JP6192800B2 (ja)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US13/835,590 US9218379B2 (en) 2013-03-15 2013-03-15 Method, apparatus, and computer-readable medium for efficiently performing operations on distinct data values
US13/835,590 2013-03-15
PCT/US2014/027907 WO2014143791A1 (en) 2013-03-15 2014-03-14 Efficiently performing operations on distinct data values

Related Child Applications (1)

Application Number Title Priority Date Filing Date
JP2017153599A Division JP6258549B2 (ja) 2013-03-15 2017-08-08 個別のデータ値に対する効率よい演算を行うための方法、装置、並びにコンピュータ可読媒体

Publications (3)

Publication Number Publication Date
JP2016516246A JP2016516246A (ja) 2016-06-02
JP2016516246A5 JP2016516246A5 (enExample) 2017-04-20
JP6192800B2 true JP6192800B2 (ja) 2017-09-06

Family

ID=51532934

Family Applications (2)

Application Number Title Priority Date Filing Date
JP2016502660A Active JP6192800B2 (ja) 2013-03-15 2014-03-14 個別のデータ値に対する効率よい演算を行うための方法、装置、並びにコンピュータ可読媒体
JP2017153599A Active JP6258549B2 (ja) 2013-03-15 2017-08-08 個別のデータ値に対する効率よい演算を行うための方法、装置、並びにコンピュータ可読媒体

Family Applications After (1)

Application Number Title Priority Date Filing Date
JP2017153599A Active JP6258549B2 (ja) 2013-03-15 2017-08-08 個別のデータ値に対する効率よい演算を行うための方法、装置、並びにコンピュータ可読媒体

Country Status (6)

Country Link
US (2) US9218379B2 (enExample)
JP (2) JP6192800B2 (enExample)
CA (1) CA2906669C (enExample)
DE (1) DE112014001361T5 (enExample)
GB (1) GB2528405B (enExample)
WO (1) WO2014143791A1 (enExample)

Families Citing this family (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9218379B2 (en) * 2013-03-15 2015-12-22 Informatica Llc Method, apparatus, and computer-readable medium for efficiently performing operations on distinct data values
US9237006B2 (en) 2013-09-30 2016-01-12 Protegrity Corporation Table-connected tokenization
US9229987B2 (en) * 2013-09-30 2016-01-05 Protegrity Corporation Mapping between tokenization domains
US9705801B2 (en) * 2013-10-07 2017-07-11 Facebook, Inc. Systems and methods for mapping and routing based on clustering
US10353923B2 (en) * 2014-04-24 2019-07-16 Ebay Inc. Hadoop OLAP engine
US10394818B2 (en) 2014-09-26 2019-08-27 Oracle International Corporation System and method for dynamic database split generation in a massively parallel or distributed database environment
US10180973B2 (en) 2014-09-26 2019-01-15 Oracle International Corporation System and method for efficient connection management in a massively parallel or distributed database environment
US10089357B2 (en) * 2014-09-26 2018-10-02 Oracle International Corporation System and method for generating partition-based splits in a massively parallel or distributed database environment
US10380114B2 (en) 2014-09-26 2019-08-13 Oracle International Corporation System and method for generating rowid range-based splits in a massively parallel or distributed database environment
US10387421B2 (en) 2014-09-26 2019-08-20 Oracle International Corporation System and method for generating size-based splits in a massively parallel or distributed database environment
US10089377B2 (en) 2014-09-26 2018-10-02 Oracle International Corporation System and method for data transfer from JDBC to a data warehouse layer in a massively parallel or distributed database environment
US10528596B2 (en) 2014-09-26 2020-01-07 Oracle International Corporation System and method for consistent reads between tasks in a massively parallel or distributed database environment
US10078684B2 (en) 2014-09-26 2018-09-18 Oracle International Corporation System and method for query processing with table-level predicate pushdown in a massively parallel or distributed database environment
FR3031203B1 (fr) 2014-12-24 2017-03-24 Bull Sas Methode d'ordonnancement de taches au niveau des noeuds d'un cluster informatique, ordonnanceur de taches et cluster associes
US10810175B2 (en) 2016-03-31 2020-10-20 King.Com Ltd. Storing segmented data
US20190005078A1 (en) * 2017-07-03 2019-01-03 Leadcrunch, Inc. Method and system for creating and updating entity vectors
US11003693B2 (en) * 2018-04-05 2021-05-11 Sap Se Grouping tables with existing tables in a distributed database
US11010363B2 (en) 2018-04-05 2021-05-18 Sap Se Complementing existing tables while grouping tables in a distributed database
US11544294B2 (en) 2020-12-10 2023-01-03 Sap Se Distributing tables in a distributed database using consolidated grouping sources
US11914624B2 (en) * 2020-12-10 2024-02-27 Coupang Corp. Systems and methods for managing connections in scalable clusters
EP4016320A1 (en) * 2020-12-21 2022-06-22 Dassault Systèmes A hybrid shadow paging for storing a database
CN113742459B (zh) * 2021-11-05 2022-03-04 北京世纪好未来教育科技有限公司 词汇展示方法、装置、电子设备及存储介质
US11954134B2 (en) * 2021-12-08 2024-04-09 Sap Se Visualization of complex hierarchy data with interactive adjustments
US12475124B1 (en) * 2024-05-16 2025-11-18 Sap Se Dictionary sharing for efficient join operation in column store
US12493631B1 (en) * 2024-08-30 2025-12-09 Oracle International Corporation Handling data skew for parallel execution with server mapping plans
CN120929612A (zh) * 2025-10-14 2025-11-11 支付宝(杭州)数字服务技术有限公司 医学问题生成方法及装置

Family Cites Families (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1989004013A1 (en) 1987-10-09 1989-05-05 Nucleus International Corporation A relational database representation with relational database operation capability
US5742806A (en) 1994-01-31 1998-04-21 Sun Microsystems, Inc. Apparatus and method for decomposing database queries for database management system including multiprocessor digital data processing system
GB9604522D0 (en) 1996-03-02 1996-05-01 Univ Strathclyde Databases
JP3584630B2 (ja) * 1996-09-20 2004-11-04 株式会社日立製作所 データベース処理システムにおける分類集計処理方法
US6507846B1 (en) 1999-11-09 2003-01-14 Joint Technology Corporation Indexing databases for efficient relational querying
US6647372B1 (en) * 1999-12-02 2003-11-11 Forecourt Communications Group Method and apparatus for using prior activities to improve the probability of completing transactions for a customer in a retail environment
US7178100B2 (en) 2000-12-15 2007-02-13 Call Charles G Methods and apparatus for storing and manipulating variable length and fixed length data elements as a sequence of fixed length integers
US20030004971A1 (en) 2001-06-29 2003-01-02 Gong Wen G. Automatic generation of data models and accompanying user interfaces
US8694352B1 (en) * 2003-04-22 2014-04-08 Reflexis Systems, Inc. System and method for providing handheld field force data gathering automation in a big box retail environment
US7472107B2 (en) 2003-06-23 2008-12-30 Microsoft Corporation Integrating horizontal partitioning into physical database design
US7243110B2 (en) 2004-02-20 2007-07-10 Sand Technology Inc. Searchable archive
US7653605B1 (en) * 2005-04-15 2010-01-26 Science Applications International Corporation Method of and apparatus for automated behavior prediction
US7443295B2 (en) * 2005-06-28 2008-10-28 Media Cart Holdings, Inc. Media enabled advertising shopping cart system
US20070050379A1 (en) 2005-08-25 2007-03-01 International Business Machines Corporation Highlighting entities in a display representation of a database query, results of a database query, and debug message of a database query to indicate associations
US7979453B2 (en) 2006-08-23 2011-07-12 Innovative Solutions, Inc. Efficient search result update mechanism
US20080062944A1 (en) 2006-09-08 2008-03-13 Motorola, Inc. Apparatus and Method For Automatic Repeat Request Signalling With Reduced Retransmission Indications in a Wireless VoIP Communication System
US8204985B2 (en) 2008-04-28 2012-06-19 Alcatel Lucent Probabilistic aggregation over distributed data streams
CN102239472B (zh) 2008-09-05 2017-04-12 惠普发展公司，有限责任合伙企业 在支持查询的同时高效地存储日志数据
US9218379B2 (en) * 2013-03-15 2015-12-22 Informatica Llc Method, apparatus, and computer-readable medium for efficiently performing operations on distinct data values

Also Published As

Publication number Publication date
US9672272B2 (en) 2017-06-06
CA2906669A1 (en) 2014-09-18
US20140279853A1 (en) 2014-09-18
JP6258549B2 (ja) 2018-01-10
CA2906669C (en) 2019-11-26
JP2017224331A (ja) 2017-12-21
JP2016516246A (ja) 2016-06-02
GB201517897D0 (en) 2015-11-25
GB2528405A (en) 2016-01-20
US9218379B2 (en) 2015-12-22
WO2014143791A1 (en) 2014-09-18
DE112014001361T5 (de) 2015-11-26
US20160070779A1 (en) 2016-03-10
GB2528405B (en) 2021-06-23

Similar Documents

Publication Publication Date Title
JP6258549B2 (ja) 個別のデータ値に対する効率よい演算を行うための方法、装置、並びにコンピュータ可読媒体
US11755575B2 (en) Processing database queries using format conversion
US10963477B2 (en) Declarative specification of visualization queries
US9892178B2 (en) Systems and methods for interest-driven business intelligence systems including event-oriented data
US9298787B2 (en) Star and snowflake schemas in extract, transform, load processes
US20140101093A1 (en) Distributed, real-time online analytical processing (olap)
JP6670097B2 (ja) 関係型データベース表の列横断的検索
US20180144061A1 (en) Edge store designs for graph databases
US20250086173A1 (en) Creating virtualized data assets using existing definitions of etl/elt jobs
US10223421B2 (en) Virtual Aggregation
US9606997B2 (en) Inferred operations for data analysis
US20180357278A1 (en) Processing aggregate queries in a graph database
CN111414410B (zh) 数据处理方法、装置、设备和存储介质
JP2005018778A (ja) ディメンジョン属性およびディメンジョン当たり複数の階層を使用するオンライン分析処理のためのシステムおよび方法
US11113267B2 (en) Enforcing path consistency in graph database path query evaluation
CA2965831C (en) Relation aware aggregation (raa) on normalized datasets
US10983997B2 (en) Path query evaluation in graph databases
JP2008537827A (ja) 階層データベースのリレーショナル・クエリ
US20180144060A1 (en) Processing deleted edges in graph databases
US10558652B2 (en) Merging multiproviders in a database calculation scenario
WO2025251779A1 (zh) 一种数据查询方法、装置及相关设备
CN118760701A (zh) 一种表格自连接优化的方法和数据库

Legal Events

Date Code Title Description
RD04 Notification of resignation of power of attorney

Free format text: JAPANESE INTERMEDIATE CODE: A7424

Effective date: 20160212

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20170314

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20170314

A871 Explanation of circumstances concerning accelerated examination

Free format text: JAPANESE INTERMEDIATE CODE: A871

Effective date: 20170314

A975 Report on accelerated examination

Free format text: JAPANESE INTERMEDIATE CODE: A971005

Effective date: 20170322

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20170328

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20170628

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: 20170711

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20170808

R150 Certificate of patent or registration of utility model

Ref document number: 6192800

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

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

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250