JP7424501B2 - 結合テーブル特定システム、結合テーブル探索装置、方法およびプログラム - Google Patents

結合テーブル特定システム、結合テーブル探索装置、方法およびプログラム Download PDF

Info

Publication number
JP7424501B2
JP7424501B2 JP2022546785A JP2022546785A JP7424501B2 JP 7424501 B2 JP7424501 B2 JP 7424501B2 JP 2022546785 A JP2022546785 A JP 2022546785A JP 2022546785 A JP2022546785 A JP 2022546785A JP 7424501 B2 JP7424501 B2 JP 7424501B2
Authority
JP
Japan
Prior art keywords
join
index
search
column
records
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
JP2022546785A
Other languages
English (en)
Japanese (ja)
Other versions
JPWO2022049680A1 (https=
JPWO2022049680A5 (https=
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.)
NEC Corp
Original Assignee
NEC Corp
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 NEC Corp filed Critical NEC Corp
Publication of JPWO2022049680A1 publication Critical patent/JPWO2022049680A1/ja
Publication of JPWO2022049680A5 publication Critical patent/JPWO2022049680A5/ja
Application granted granted Critical
Publication of JP7424501B2 publication Critical patent/JP7424501B2/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/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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24542—Plan optimisation
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Operations Research (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2022546785A 2020-09-02 2020-09-02 結合テーブル特定システム、結合テーブル探索装置、方法およびプログラム Active JP7424501B2 (ja)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/JP2020/033308 WO2022049680A1 (ja) 2020-09-02 2020-09-02 結合テーブル特定システム、結合テーブル探索装置、方法およびプログラム

Publications (3)

Publication Number Publication Date
JPWO2022049680A1 JPWO2022049680A1 (https=) 2022-03-10
JPWO2022049680A5 JPWO2022049680A5 (https=) 2023-05-23
JP7424501B2 true JP7424501B2 (ja) 2024-01-30

Family

ID=80491870

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2022546785A Active JP7424501B2 (ja) 2020-09-02 2020-09-02 結合テーブル特定システム、結合テーブル探索装置、方法およびプログラム

Country Status (3)

Country Link
US (1) US12222916B2 (https=)
JP (1) JP7424501B2 (https=)
WO (1) WO2022049680A1 (https=)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US12411840B2 (en) * 2023-09-26 2025-09-09 International Business Machines Corporation Embedding based heterogenous dataset evaluation

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2001155028A (ja) 1999-11-29 2001-06-08 Hitachi Ltd リレーショナルデータベースにおける集約演算処理方法、その装置及び集約演算処理プログラムを記録したコンピュータ読み取り可能な記録媒体
JP2010176327A (ja) 2009-01-28 2010-08-12 Sony Corp 学習装置、学習方法、情報処理装置、データ選択方法、データ蓄積方法、データ変換方法、及びプログラム
JP2017188137A (ja) 2016-03-31 2017-10-12 スマートインサイト株式会社 異種データソース混在環境におけるフィールド間の関係性の自動的発見のための方法、プログラム、および、システム

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7343367B2 (en) * 2005-05-12 2008-03-11 International Business Machines Corporation Optimizing a database query that returns a predetermined number of rows using a generated optimized access plan
US9342553B1 (en) * 2012-05-13 2016-05-17 Google Inc. Identifying distinct combinations of values for entities based on information in an index
US20160154851A1 (en) * 2013-04-24 2016-06-02 Hitachi Ltd. Computing device, storage medium, and data search method
US10120851B2 (en) * 2016-06-30 2018-11-06 Microsoft Technology Licensing, Llc Automatic semantic data enrichment in a spreadsheet
WO2018025706A1 (ja) 2016-08-05 2018-02-08 日本電気株式会社 テーブル意味推定システム、方法およびプログラム
US11093494B2 (en) 2016-12-06 2021-08-17 Microsoft Technology Licensing, Llc Joining tables by leveraging transformations
CN111259004B (zh) * 2020-01-08 2023-04-14 腾讯科技（深圳）有限公司 一种存储引擎中数据索引的方法以及相关装置

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2001155028A (ja) 1999-11-29 2001-06-08 Hitachi Ltd リレーショナルデータベースにおける集約演算処理方法、その装置及び集約演算処理プログラムを記録したコンピュータ読み取り可能な記録媒体
JP2010176327A (ja) 2009-01-28 2010-08-12 Sony Corp 学習装置、学習方法、情報処理装置、データ選択方法、データ蓄積方法、データ変換方法、及びプログラム
JP2017188137A (ja) 2016-03-31 2017-10-12 スマートインサイト株式会社 異種データソース混在環境におけるフィールド間の関係性の自動的発見のための方法、プログラム、および、システム

Also Published As

Publication number Publication date
US20230394016A1 (en) 2023-12-07
WO2022049680A1 (ja) 2022-03-10
JPWO2022049680A1 (https=) 2022-03-10
US12222916B2 (en) 2025-02-11

Similar Documents

Publication Publication Date Title
CN104756107B (zh) 采用位置信息剖析数据
CN104424296B (zh) 查询词分类方法和装置
CN104573130B (zh) 基于群体计算的实体解析方法及装置
JP2022037955A (ja) 学習モデルを選択するシステム
KR102438923B1 (ko) 시계열 분포 특징을 고려한 딥러닝 기반 비트코인 블록 데이터 예측 시스템
JP2019184852A (ja) データ分析サーバ、データ分析システム、及びデータ分析方法
JP7485057B2 (ja) 相関索引構築装置、相関テーブル探索装置、方法およびプログラム
JP5780036B2 (ja) 抽出プログラム、抽出方法及び抽出装置
Mitheran et al. Introducing self-attention to target attentive graph neural networks
Qinl et al. Synthesizing privacy preserving entity resolution datasets
JP7424501B2 (ja) 結合テーブル特定システム、結合テーブル探索装置、方法およびプログラム
CN119474479B (zh) 一种基于同态加密的数据安全检索方法
JP7444269B2 (ja) テーブル統合システム、方法およびプログラム
JP2018060379A (ja) 検索手段選択プログラム、検索手段選択方法及び検索手段選択装置
Bertalan et al. Using transformer models and textual analysis for log parsing
CN117633328B (zh) 基于数据挖掘的新媒体内容监测方法及系统
JP6677624B2 (ja) 分析装置、分析方法、および分析プログラム
CN114547231B (zh) 一种数据溯源的方法和系统
CN112001176B (zh) 文本数据的同质化检测方法及装置
Keskin et al. Optimizing approximate nearest neighbor search for fashion image retrieval
Abinaya et al. Effective Feature Selection For High Dimensional Data using Fast Algorithm
Paganelli et al. Evaluating the integration of datasets
Buono et al. A framework to evaluate the quality of integrated datasets
CN119809648B (zh) 交易风险分析方法和装置
JP7646091B2 (ja) 情報処理装置、検索方法、及び検索プログラム

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20230301

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20230301

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

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20240101

R151 Written notification of patent or utility model registration

Ref document number: 7424501

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R151