KR20070026421A - 초 무공유 병렬 데이터베이스 - Google Patents
초 무공유 병렬 데이터베이스 Download PDFInfo
- Publication number
- KR20070026421A KR20070026421A KR1020067019203A KR20067019203A KR20070026421A KR 20070026421 A KR20070026421 A KR 20070026421A KR 1020067019203 A KR1020067019203 A KR 1020067019203A KR 20067019203 A KR20067019203 A KR 20067019203A KR 20070026421 A KR20070026421 A KR 20070026421A
- Authority
- KR
- South Korea
- Prior art keywords
- slave
- query
- node
- database
- tables
- Prior art date
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F15/00—Digital computers in general; Data processing equipment in general
- G06F15/16—Combinations of two or more digital computers each having at least an arithmetic unit, a program unit and a register, e.g. for a simultaneous processing of several programs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/24532—Query optimisation of parallel queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/40—Data acquisition and logging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computer Hardware Design (AREA)
- Computing Systems (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Multi Processors (AREA)
Abstract
Description
Claims (29)
- 마스터 노드;다수의 슬레이브 노드; 및팩트(fact) 테이블과 다수의 차원(dimension) 테이블로 구성된 데이터베이스를 상기 다수의 슬레이브 노드를 가로질러 분배하는 수단을 포함하는 병렬 데이터베이스 시스템에 있어서,상기 팩트 테이블과 제1 차원 테이블은 상기 다수의 슬레이브 노드를 가로질러 구분되고,상기 데이터베이스의 모든 다른 차원 테이블은 상기 다수의 슬레이브 노드 각각과 쌍을 이루며, 그리고최소의 크기를 갖는 다수의 상기 다른 차원 테이블 또한 상기 다수의 슬레이브 노드를 가로질러 구분되는 것을 특징으로 하는 병렬 데이터 베이스 시스템.
- 제1항에 있어서,다수의 상기 다른 차원 테이블은 열(row)로 구분된 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제1항에 있어서,다수의 상기 다른 차원 테이블은 행(column)으로 구분된 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제1항에 있어서,다수의 상기 다른 차원 테이블은 열과 행으로 구분된 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제1항에 있어서,상기 팩트 테이블과 제1 차원 테이블은 열로 구분된 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제5항에 있어서,상기 팩트 테이블과 제1 차원 테이블은 공유키를 사용하여 해쉬(hash) 구분된 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제5항에 있어서,상기 팩트 테이블과 제1 차원 테이블은 행으로 구분된 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제1항에 있어서,상기 데이터베이스 테이블은 상기 다수의 슬레이브 노드를 가로질러 날짜별 로 구분된 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제1항에 있어서,상기 구분 수단은 상기 다수의 슬레이브 노드를 가로질러 데이터베이스 테이블을 자동으로 구분하고 분배하는 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제1항에 있어서,상기 데이터베이스에 대한 질의어를, 상기 슬레이브 노드 간의 데이터 전송을 요하지 않고 상기 병렬 데이터베이스 시스템에 의해 실행 가능한 하나 이상의 하위-질의어로 번역하는 수단을 더 포함하는 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제10항에 있어서,상기 병렬 데이터베이스 시스템에 의해 산출된 질의어 결과를 저장하는 수단을 더 포함하는 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제11항에 있어서,상기 마스터 노드는, 상기 마스터 노드에 의해 산출된 질의어 결과를 저장하기 위한 수단을 포함하는 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제12항에 있어서,상기 다수의 슬레이브 노드 각각은, 상기 각각의 슬레이브 노드에 의해 산출된 하위-질의어 결과를 저장하기 위한 수단을 포함하는 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제1항에 있어서,상기 다수의 슬레이브 노드를 위해, 상기 각각의 슬레이브 노드상에 저장된 데이터세트의 복사본이, 상기 각각의 슬레이브 노드에 시스템 대체 동작 파트너로서 할당된 상기 다수의 슬레이브 중 다른 하나의 노드에 저장되는 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 제14항에 있어서,실패가 발생한 노드에서 실행될 예정이었던 하위-질의어가 상기 실패가 발생한 노드의 시스템 대체 동작 파트너에 의해 실행되는 것을 특징으로 하는 병렬 데이터베이스 시스템.
- 데이터베이스 내의 팩트 테이블과 제1 차원 테이블을 확인하는 단계;다수의 슬레이브 노드를 가로질러 상기 팩트 테이블과 제1 차원 테이블을 분배하는 단계;데이터베이스의 모든 다른 차원 테이블은 상기 다수의 슬레이브 노드 각각과 쌍을 이루는 단계; 그리고최소의 크기를 갖는 다수의 상기 다른 차원 테이블을 상기 다수의 슬레이브 노드를 가로질러 구분하는 단계로 이루어지는, 팩트 테이블과 다수의 차원 테이블을 포함하는 병렬 데이터베이스 시스템의 데이터베이스 관리방법.
- 제16항에 있어서,다수의 상기 다른 차원 테이블은 열로 구분된 것을 특징으로 하는 데이터베이스 관리방법.
- 제16항에 있어서,다수의 상기 다른 차원 테이블은 행으로 구분된 것을 특징으로 하는 데이터베이스 관리방법.
- 제16항에 있어서,다수의 상기 다른 차원 테이블은 열과 행으로 구분된 것을 특징으로 하는 데이터베이스 관리방법.
- 제16항에 있어서,상기 팩트 테이블과 제1 차원 테이블은 열로 구분된 것을 특징으로 하는 데이터베이스 관리방법.
- 제20항에 있어서,상기 팩트 테이블과 제1 차원 테이블은 공유키를 사용하여 해쉬 구분된 것을 특징으로 하는 데이터베이스 관리방법.
- 제20항에 있어서,상기 팩트 테이블과 제1 차원 테이블은 행으로도 구분된 것을 특징으로 하는 데이터베이스 관리방법.
- 제16항에 있어서,상기 데이터베이스 테이블은 상기 다수의 슬레이브 노드를 가로질러 날짜별로 구분된 것을 특징으로 하는 데이터베이스 관리방법.
- 제16항에 있어서,상기 데이터베이스에 대한 질의어를, 상기 슬레이브 노드 간의 데이터 전송을 요하지 않고 상기 병렬 데이터베이스 시스템에 의해 실행 가능한 하나 이상의 하위-질의어로 번역하는 것을 더 포함하는 데이터베이스 관리방법.
- 제24항에 있어서,마스터 노드의 상기 질의어 결과를 저장하는 것을 더 포함하는 데이터베이스 관리방법.
- 제25항에 있어서,상기 각각의 슬레이브 노드의 상기 하나 이상의 하위-질의어 결과를 저장하는 것을 더 포함하는 데이터베이스 관리방법.
- 제16항에 있어서,상기 슬레이브 노드에 할당된 시스템 대체 동작 파트너에 슬레이브 노드의 데이터 세트의 복사본을 저장하는 것을 더 포함하는 데이터베이스 관리방법.
- 제27항에 있어서,실패가 발생한 슬레이브 노드에서 실행될 예정이었던 하위-질의어를 상기 슬레이브 노드의 시스템 대체 동작 파트너에서 실행하는 것을 더 포함하는 데이터베이스 관리방법.
- 제16항 내지 제28항에 있어서,상기 묘사된 방법을 수행하기 위한, 컴퓨터로 판독가능한 메모리 매개체에 저장된, 처리과정을 수행할 수 있는 컴퓨터.
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US54642804P | 2004-02-21 | 2004-02-21 | |
US60/546,428 | 2004-02-21 | ||
PCT/US2005/005199 WO2005098655A2 (en) | 2004-02-21 | 2005-02-17 | Ultra-shared-nothing parallel database |
Publications (2)
Publication Number | Publication Date |
---|---|
KR20070026421A true KR20070026421A (ko) | 2007-03-08 |
KR101114149B1 KR101114149B1 (ko) | 2012-03-08 |
Family
ID=35125731
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
KR1020067019203A KR101114149B1 (ko) | 2004-02-21 | 2006-09-18 | 초 무공유 병렬 데이터베이스 |
Country Status (9)
Country | Link |
---|---|
US (1) | US7818349B2 (ko) |
EP (1) | EP1716505B1 (ko) |
JP (1) | JP4777972B2 (ko) |
KR (1) | KR101114149B1 (ko) |
CN (1) | CN101120340B (ko) |
AU (1) | AU2005231230B2 (ko) |
CA (1) | CA2556979A1 (ko) |
MX (1) | MXPA06009355A (ko) |
WO (1) | WO2005098655A2 (ko) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
KR101472257B1 (ko) * | 2014-07-22 | 2014-12-11 | (주)카디날정보기술 | 예측 논리적 데이터 지역성을 이용한 병렬질의 처리 방법 및 장치 |
KR20180021994A (ko) * | 2016-08-23 | 2018-03-06 | 주식회사 한컴시큐어 | 대용량 데이터베이스에 최적화된 암호화 스케줄링의 자동화가 가능한 데이터베이스 암호화 장치 및 그 동작 방법 |
Families Citing this family (163)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7010538B1 (en) * | 2003-03-15 | 2006-03-07 | Damian Black | Method for distributed RDSMS |
US7406691B2 (en) | 2004-01-13 | 2008-07-29 | International Business Machines Corporation | Minimizing complex decisions to allocate additional resources to a job submitted to a grid environment |
US7562143B2 (en) | 2004-01-13 | 2009-07-14 | International Business Machines Corporation | Managing escalating resource needs within a grid environment |
US7552437B2 (en) | 2004-01-14 | 2009-06-23 | International Business Machines Corporation | Maintaining application operations within a suboptimal grid environment |
US7266547B2 (en) * | 2004-06-10 | 2007-09-04 | International Business Machines Corporation | Query meaning determination through a grid service |
US7778997B1 (en) | 2004-06-11 | 2010-08-17 | Seisint, Inc. | System and method for managing throughput in the processing of query requests in a database system |
US7797333B1 (en) | 2004-06-11 | 2010-09-14 | Seisint, Inc. | System and method for returning results of a query from one or more slave nodes to one or more master nodes of a database system |
US7693826B1 (en) * | 2004-06-11 | 2010-04-06 | Seisint, Inc. | System and method for pre-compiling a query and pre-keying a database system |
US8266234B1 (en) * | 2004-06-11 | 2012-09-11 | Seisint, Inc. | System and method for enhancing system reliability using multiple channels and multicast |
US7801911B1 (en) * | 2004-06-11 | 2010-09-21 | Seisint, Inc. | System and method for using activity identifications in a database system |
US7917495B1 (en) | 2004-06-11 | 2011-03-29 | Seisint, Inc. | System and method for processing query requests in a database system |
US7739287B1 (en) | 2004-06-11 | 2010-06-15 | Seisint, Inc. | System and method for dynamically creating keys in a database system |
US7873650B1 (en) * | 2004-06-11 | 2011-01-18 | Seisint, Inc. | System and method for distributing data in a parallel processing system |
US7406461B1 (en) | 2004-06-11 | 2008-07-29 | Seisint, Inc. | System and method for processing a request to perform an activity associated with a precompiled query |
US7457796B2 (en) * | 2004-07-08 | 2008-11-25 | International Business Machines Corporation | Method using virtual replicated tables in a cluster database management system |
US7712100B2 (en) | 2004-09-14 | 2010-05-04 | International Business Machines Corporation | Determining a capacity of a grid environment to handle a required workload for a virtual grid job request |
US7761557B2 (en) | 2005-01-06 | 2010-07-20 | International Business Machines Corporation | Facilitating overall grid environment management by monitoring and distributing grid activity |
US7502850B2 (en) | 2005-01-06 | 2009-03-10 | International Business Machines Corporation | Verifying resource functionality before use by a grid job submitted to a grid environment |
US7590623B2 (en) | 2005-01-06 | 2009-09-15 | International Business Machines Corporation | Automated management of software images for efficient resource node building within a grid environment |
US7707288B2 (en) | 2005-01-06 | 2010-04-27 | International Business Machines Corporation | Automatically building a locally managed virtual node grouping to handle a grid job requiring a degree of resource parallelism within a grid environment |
US7793308B2 (en) | 2005-01-06 | 2010-09-07 | International Business Machines Corporation | Setting operation based resource utilization thresholds for resource use by a process |
US7533170B2 (en) | 2005-01-06 | 2009-05-12 | International Business Machines Corporation | Coordinating the monitoring, management, and prediction of unintended changes within a grid environment |
US7571120B2 (en) | 2005-01-12 | 2009-08-04 | International Business Machines Corporation | Computer implemented method for estimating future grid job costs by classifying grid jobs and storing results of processing grid job microcosms |
US7562035B2 (en) | 2005-01-12 | 2009-07-14 | International Business Machines Corporation | Automating responses by grid providers to bid requests indicating criteria for a grid job |
US7467196B2 (en) | 2005-01-12 | 2008-12-16 | International Business Machines Corporation | Managing network errors communicated in a message transaction with error information using a troubleshooting agent |
US7472079B2 (en) | 2005-01-12 | 2008-12-30 | International Business Machines Corporation | Computer implemented method for automatically controlling selection of a grid provider for a grid job |
JP4675174B2 (ja) * | 2005-07-12 | 2011-04-20 | 株式会社日立製作所 | データベース処理方法、システム及びプログラム |
US20070078809A1 (en) * | 2005-09-30 | 2007-04-05 | Rockwell Automation Technologies, Inc. | Robust data availability system having decentralized storage and multiple access paths |
US8688780B2 (en) * | 2005-09-30 | 2014-04-01 | Rockwell Automation Technologies, Inc. | Peer-to-peer exchange of data resources in a control system |
US7860865B2 (en) * | 2005-12-19 | 2010-12-28 | Yahoo! Inc. | System of a hierarchy of servers for query processing of column chunks in a distributed column chunk data store |
US8214388B2 (en) * | 2005-12-19 | 2012-07-03 | Yahoo! Inc | System and method for adding a storage server in a distributed column chunk data store |
US20070143248A1 (en) * | 2005-12-19 | 2007-06-21 | Yahoo! Inc. | Method using query processing servers for query processing of column chunks in a distributed column chunk data store |
US7921132B2 (en) * | 2005-12-19 | 2011-04-05 | Yahoo! Inc. | System for query processing of column chunks in a distributed column chunk data store |
US7921087B2 (en) * | 2005-12-19 | 2011-04-05 | Yahoo! Inc. | Method for query processing of column chunks in a distributed column chunk data store |
US7921131B2 (en) * | 2005-12-19 | 2011-04-05 | Yahoo! Inc. | Method using a hierarchy of servers for query processing of column chunks in a distributed column chunk data store |
US20100257135A1 (en) * | 2006-07-25 | 2010-10-07 | Mypoints.Com Inc. | Method of Providing Multi-Source Data Pull and User Notification |
US10007686B2 (en) * | 2006-08-02 | 2018-06-26 | Entit Software Llc | Automatic vertical-database design |
US8086598B1 (en) | 2006-08-02 | 2011-12-27 | Hewlett-Packard Development Company, L.P. | Query optimizer with schema conversion |
US8671091B2 (en) * | 2006-08-02 | 2014-03-11 | Hewlett-Packard Development Company, L.P. | Optimizing snowflake schema queries |
US8504598B2 (en) | 2007-01-26 | 2013-08-06 | Information Resources, Inc. | Data perturbation of non-unique values |
US9390158B2 (en) * | 2007-01-26 | 2016-07-12 | Information Resources, Inc. | Dimensional compression using an analytic platform |
US9262503B2 (en) * | 2007-01-26 | 2016-02-16 | Information Resources, Inc. | Similarity matching of products based on multiple classification schemes |
US8160984B2 (en) | 2007-01-26 | 2012-04-17 | Symphonyiri Group, Inc. | Similarity matching of a competitor's products |
US20080270363A1 (en) * | 2007-01-26 | 2008-10-30 | Herbert Dennis Hunt | Cluster processing of a core information matrix |
US10621203B2 (en) * | 2007-01-26 | 2020-04-14 | Information Resources, Inc. | Cross-category view of a dataset using an analytic platform |
US20080288522A1 (en) * | 2007-01-26 | 2008-11-20 | Herbert Dennis Hunt | Creating and storing a data field alteration datum using an analytic platform |
US20090006309A1 (en) * | 2007-01-26 | 2009-01-01 | Herbert Dennis Hunt | Cluster processing of an aggregated dataset |
US20080294996A1 (en) * | 2007-01-31 | 2008-11-27 | Herbert Dennis Hunt | Customized retailer portal within an analytic platform |
US8782075B2 (en) | 2007-05-08 | 2014-07-15 | Paraccel Llc | Query handling in databases with replicated data |
US9002827B2 (en) * | 2007-07-11 | 2015-04-07 | Teradata Us, Inc. | Database query table substitution |
US20090024570A1 (en) * | 2007-07-20 | 2009-01-22 | Oracle Internatonal Corporation | User defined query rewrite mechanism |
US7885969B2 (en) * | 2007-09-17 | 2011-02-08 | International Business Machines Corporation | System and method for executing compute-intensive database user-defined programs on an attached high-performance parallel computer |
US9626421B2 (en) | 2007-09-21 | 2017-04-18 | Hasso-Plattner-Institut Fur Softwaresystemtechnik Gmbh | ETL-less zero-redundancy system and method for reporting OLTP data |
US7917574B2 (en) * | 2007-10-01 | 2011-03-29 | Accenture Global Services Limited | Infrastructure for parallel programming of clusters of machines |
US8412548B2 (en) * | 2007-11-27 | 2013-04-02 | International Business Machines Corporation | Linked decision nodes in a business process model |
US20090198703A1 (en) * | 2008-01-31 | 2009-08-06 | Hewlett-Packard Development Company, L.P. | Intelligent data storage system |
US9177079B1 (en) * | 2009-01-22 | 2015-11-03 | Joviandata, Inc. | Apparatus and method for processing multi-dimensional queries in a shared nothing system through tree reduction |
US8893131B2 (en) * | 2008-04-11 | 2014-11-18 | Yahoo! Inc. | System and/or method for bulk loading of records into an ordered distributed database |
US8195712B1 (en) | 2008-04-17 | 2012-06-05 | Lattice Engines, Inc. | Lattice data set-based methods and apparatus for information storage and retrieval |
US8682853B2 (en) | 2008-05-16 | 2014-03-25 | Paraccel Llc | System and method for enhancing storage performance in analytical database applications |
JP5392254B2 (ja) * | 2008-05-30 | 2014-01-22 | 日本電気株式会社 | データベースシステム、データベース管理方法、データベース構造およびコンピュータプログラム |
US8099440B2 (en) * | 2008-08-15 | 2012-01-17 | International Business Machines Corporation | Method for laying out fields in a database in a hybrid of row-wise and column-wise ordering |
US20100088309A1 (en) * | 2008-10-05 | 2010-04-08 | Microsoft Corporation | Efficient large-scale joining for querying of column based data encoded structures |
US9251212B2 (en) * | 2009-03-27 | 2016-02-02 | Business Objects Software Ltd. | Profiling in a massive parallel processing environment |
US8700674B2 (en) * | 2009-07-14 | 2014-04-15 | Hewlett-Packard Development Company, L.P. | Database storage architecture |
US8972346B2 (en) * | 2009-12-11 | 2015-03-03 | International Business Machines Corporation | Method and system for minimizing synchronization efforts of parallel database systems |
US8346714B1 (en) * | 2009-12-17 | 2013-01-01 | Teradota Us, Inc. | Transactiontime and validtime timestamping in an enterprise active data warehouse |
JP5353682B2 (ja) * | 2009-12-22 | 2013-11-27 | 富士通株式会社 | 構成情報管理装置、分散情報管理システム、分散情報管理方法および分散情報管理プログラム |
US8990185B2 (en) | 2010-02-19 | 2015-03-24 | International Business Machines Corporation | Evaluating reference based operations in shared nothing parallelism systems |
US8290931B2 (en) * | 2010-02-22 | 2012-10-16 | Hewlett-Packard Development Company, L.P. | Database designer |
US8375047B2 (en) * | 2010-03-31 | 2013-02-12 | Emc Corporation | Apparatus and method for query prioritization in a shared nothing distributed database |
US8935248B2 (en) | 2010-05-17 | 2015-01-13 | United States Postal Service | Localized data affinity system and hybrid method |
US8768973B2 (en) | 2010-05-26 | 2014-07-01 | Pivotal Software, Inc. | Apparatus and method for expanding a shared-nothing system |
CN101916261B (zh) * | 2010-07-28 | 2013-07-17 | 北京播思软件技术有限公司 | 一种分布式并行数据库系统的数据分区方法 |
CN101916280A (zh) * | 2010-08-17 | 2010-12-15 | 上海云数信息科技有限公司 | 并行计算系统及按查询内容进行负载均衡的方法 |
WO2012035665A1 (ja) | 2010-09-17 | 2012-03-22 | 富士通株式会社 | データ共有プログラム、データ配信プログラム、端末、サーバ、データ共有方法、およびデータ配信方法 |
JP5276639B2 (ja) * | 2010-10-01 | 2013-08-28 | 日本電信電話株式会社 | 分散データベース管理装置および分散データベース管理プログラム |
US8442988B2 (en) | 2010-11-04 | 2013-05-14 | International Business Machines Corporation | Adaptive cell-specific dictionaries for frequency-partitioned multi-dimensional data |
US9292523B1 (en) * | 2011-03-23 | 2016-03-22 | Emc Corporation | Managing data storage |
CN102737033B (zh) * | 2011-03-31 | 2015-02-04 | 国际商业机器公司 | 数据处理设备及其数据处理方法 |
US9798831B2 (en) | 2011-04-01 | 2017-10-24 | Google Inc. | Processing data in a MapReduce framework |
US8924426B2 (en) * | 2011-04-29 | 2014-12-30 | Google Inc. | Joining tables in a mapreduce procedure |
US8793287B2 (en) | 2011-05-27 | 2014-07-29 | Sap Ag | Equi-joins between split tables |
US8965879B2 (en) | 2011-06-03 | 2015-02-24 | Microsoft Technology Licensing, Llc | Unique join data caching method |
CN102323946B (zh) * | 2011-09-05 | 2013-03-27 | 天津神舟通用数据技术有限公司 | 并行数据库中算子复用的实现方法 |
US8862606B1 (en) * | 2011-09-22 | 2014-10-14 | Emc Corporation | Executing correlated and multi-row subqueries in a MPP database |
CN103092886B (zh) * | 2011-11-07 | 2016-03-02 | 中国移动通信集团公司 | 一种数据查询操作的实现方法、装置及系统 |
US8892502B2 (en) * | 2011-12-07 | 2014-11-18 | Sap Se | Parallel processing of semantically grouped data in data warehouse environments |
US8914353B2 (en) * | 2011-12-20 | 2014-12-16 | Sap Se | Many-core algorithms for in-memory column store databases |
US8676787B2 (en) | 2011-12-22 | 2014-03-18 | International Business Machines Corporation | Distributed multi-step abstract queries |
US8762378B2 (en) * | 2011-12-23 | 2014-06-24 | Sap Ag | Independent table nodes in parallelized database environments |
US8868594B2 (en) * | 2011-12-23 | 2014-10-21 | Sap Ag | Split processing paths for a database calculation engine |
US8880565B2 (en) * | 2011-12-23 | 2014-11-04 | Sap Se | Table creation for partitioned tables |
US9164864B1 (en) * | 2011-12-28 | 2015-10-20 | Emc Corporation | Minimizing false negative and duplicate health monitoring alerts in a dual master shared nothing database appliance |
US8938444B2 (en) * | 2011-12-29 | 2015-01-20 | Teradata Us, Inc. | Techniques for external application-directed data partitioning in data exporting from a database management system |
US9239851B1 (en) | 2012-07-12 | 2016-01-19 | Cross Commerce Media, Inc. | Advanced database systems and methods |
WO2014015492A1 (zh) * | 2012-07-26 | 2014-01-30 | 华为技术有限公司 | 数据分布的方法、装置及系统 |
US9015721B2 (en) * | 2012-07-30 | 2015-04-21 | Hewlett-Packard Development Company, L. P. | Managing array computations during programmatic run-time in a distributed computing environment |
CN103678368B (zh) * | 2012-09-14 | 2017-02-08 | 华为技术有限公司 | 查询处理方法和装置 |
CN103714073B (zh) * | 2012-09-29 | 2017-04-12 | 国际商业机器公司 | 数据查询的方法和装置 |
CN104871153B8 (zh) * | 2012-10-29 | 2019-02-01 | 华为技术有限公司 | 用于分布式大规模并行处理数据库的方法和系统 |
US9195701B2 (en) * | 2012-10-29 | 2015-11-24 | Futurewei Technologies, Inc. | System and method for flexible distributed massively parallel processing (MPP) database |
US8799284B2 (en) | 2012-11-30 | 2014-08-05 | Futurewei Technologies, Inc. | Method for automated scaling of a massive parallel processing (MPP) database |
US20140214886A1 (en) | 2013-01-29 | 2014-07-31 | ParElastic Corporation | Adaptive multi-client saas database |
US10585896B2 (en) * | 2013-03-12 | 2020-03-10 | Red Hat, Inc. | Managing data in relational database management system |
US10049159B2 (en) * | 2013-03-15 | 2018-08-14 | Sas Institute Inc. | Techniques for data retrieval in a distributed computing environment |
CN104252452B (zh) * | 2013-06-25 | 2019-03-15 | 腾讯科技(深圳)有限公司 | 数据管理的方法及装置 |
CN105308579B (zh) * | 2013-07-01 | 2018-06-08 | 株式会社日立制作所 | 系列数据并行分析基础设施及其并行分散处理方法 |
US20150113314A1 (en) * | 2013-07-11 | 2015-04-23 | Brian J. Bulkowski | Method and system of implementing a distributed database with peripheral component interconnect express switch |
CN103412897B (zh) * | 2013-07-25 | 2017-03-01 | 中国科学院软件研究所 | 一种基于分布式结构的并行数据处理方法 |
US9600514B2 (en) | 2013-09-09 | 2017-03-21 | VoltDB, Inc. | Methods and systems for detecting data divergence and inconsistency across replicas of data within a shared-nothing distributed database |
US10176240B2 (en) | 2013-09-12 | 2019-01-08 | VoltDB, Inc. | Methods and systems for real-time transactional database transformation |
US9836519B2 (en) * | 2013-09-20 | 2017-12-05 | Oracle International Corporation | Densely grouping dimensional data |
US9684682B2 (en) | 2013-09-21 | 2017-06-20 | Oracle International Corporation | Sharding of in-memory objects across NUMA nodes |
US9606921B2 (en) | 2013-09-21 | 2017-03-28 | Oracle International Corporation | Granular creation and refresh of columnar data |
US10061789B2 (en) * | 2013-10-28 | 2018-08-28 | Excalibur Ip, Llc | Dynamic database indexes for entity attribute value stores |
CN103559255B (zh) * | 2013-11-01 | 2017-01-04 | 北京理工大学 | 一种分布式液压系统的可视化数据处理方法 |
US9898398B2 (en) | 2013-12-30 | 2018-02-20 | Microsoft Technology Licensing, Llc | Re-use of invalidated data in buffers |
US9430508B2 (en) | 2013-12-30 | 2016-08-30 | Microsoft Technology Licensing, Llc | Disk optimized paging for column oriented databases |
US9723054B2 (en) | 2013-12-30 | 2017-08-01 | Microsoft Technology Licensing, Llc | Hierarchical organization for scale-out cluster |
US9639571B2 (en) | 2013-12-30 | 2017-05-02 | VoltDB, Inc. | Methods and systems for increasing capacity and performing data rebalancing without downtime to a distributed shared-nothing database with serializable isolation |
US9569493B2 (en) | 2013-12-31 | 2017-02-14 | International Business Machines Corporatin | Avoidance of intermediate data skew in a massive parallel processing environment |
US9555378B2 (en) * | 2014-01-09 | 2017-01-31 | Dow Global Technologies Llc | Composite polyamide membrane having preferred azo content |
US11386085B2 (en) | 2014-01-27 | 2022-07-12 | Microstrategy Incorporated | Deriving metrics from queries |
US9952894B1 (en) * | 2014-01-27 | 2018-04-24 | Microstrategy Incorporated | Parallel query processing |
US10635669B1 (en) | 2014-01-27 | 2020-04-28 | Microstrategy Incorporated | Data engine integration and data refinement |
US10255320B1 (en) | 2014-01-27 | 2019-04-09 | Microstrategy Incorporated | Search integration |
US11921715B2 (en) | 2014-01-27 | 2024-03-05 | Microstrategy Incorporated | Search integration |
US9576039B2 (en) | 2014-02-19 | 2017-02-21 | Snowflake Computing Inc. | Resource provisioning systems and methods |
US9824106B1 (en) | 2014-02-20 | 2017-11-21 | Amazon Technologies, Inc. | Hash based data processing |
US9679012B1 (en) * | 2014-02-28 | 2017-06-13 | Pivotal Software, Inc. | Parallel streaming of external data |
US9684666B1 (en) * | 2014-02-28 | 2017-06-20 | Pivotal Software, Inc. | Parallel streaming of external data |
US9684671B1 (en) * | 2014-02-28 | 2017-06-20 | Pivotal Software, Inc. | Parallel streaming of external data |
CN103927337B (zh) * | 2014-03-26 | 2017-12-19 | 北京国双科技有限公司 | 用于联机分析处理中关联关系的数据处理方法和装置 |
US9552390B2 (en) | 2014-04-29 | 2017-01-24 | Futurewei Technologies, Inc. | System and method for out of order multiple query execution within stored procedure |
US10002148B2 (en) | 2014-07-22 | 2018-06-19 | Oracle International Corporation | Memory-aware joins based in a database cluster |
US9875259B2 (en) | 2014-07-22 | 2018-01-23 | Oracle International Corporation | Distribution of an object in volatile memory across a multi-node cluster |
CN105468651B (zh) * | 2014-09-12 | 2020-03-27 | 阿里巴巴集团控股有限公司 | 一种关系数据库数据查询方法及系统 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
US9767149B2 (en) | 2014-10-10 | 2017-09-19 | International Business Machines Corporation | Joining data across a parallel database and a distributed processing system |
WO2016191995A1 (zh) | 2015-05-31 | 2016-12-08 | 华为技术有限公司 | 一种分布式数据库中关联表分区的方法和设备 |
WO2016206100A1 (zh) | 2015-06-26 | 2016-12-29 | 华为技术有限公司 | 一种数据表的分区管理方法及装置 |
US10482076B2 (en) | 2015-08-14 | 2019-11-19 | Sap Se | Single level, multi-dimension, hash-based table partitioning |
US10198228B2 (en) | 2016-03-03 | 2019-02-05 | Ricoh Company, Ltd. | Distributed data tables for print jobs in a print workflow system |
WO2018028797A1 (en) * | 2016-08-12 | 2018-02-15 | Telefonaktiebolaget Lm Ericsson (Publ) | Methods and systems for bulk loading of data into a distributed database |
CN106339432A (zh) * | 2016-08-19 | 2017-01-18 | 上海巨数信息科技有限公司 | 一种按查询内容进行负载均衡的系统及其方法 |
US10846318B1 (en) | 2017-04-18 | 2020-11-24 | Microstrategy Incorporated | Natural language visualizations |
US11003662B2 (en) * | 2017-10-30 | 2021-05-11 | Salesforce.Com, Inc. | Trigger-free asynchronous maintenance of custom indexes and skinny performance meta-structures |
US10776229B2 (en) * | 2017-12-22 | 2020-09-15 | Teradata Us, Inc. | Dedicated fallback processing for a distributed data warehouse |
CN110019274B (zh) | 2017-12-29 | 2023-09-26 | 阿里巴巴集团控股有限公司 | 一种数据库系统以及查询数据库的方法和装置 |
US11138230B2 (en) * | 2018-03-26 | 2021-10-05 | Mcafee, Llc | Methods, apparatus, and systems to aggregate partitioned computer database data |
CN108664560A (zh) * | 2018-04-09 | 2018-10-16 | 宁波诺信睿聚投资有限责任公司 | 数据查询方法、装置、计算机设备及计算机可读存储介质 |
US11195050B2 (en) | 2019-02-05 | 2021-12-07 | Microstrategy Incorporated | Machine learning to generate and evaluate visualizations |
US11614970B2 (en) | 2019-12-06 | 2023-03-28 | Microstrategy Incorporated | High-throughput parallel data transmission |
US11567965B2 (en) | 2020-01-23 | 2023-01-31 | Microstrategy Incorporated | Enhanced preparation and integration of data sets |
WO2021162911A1 (en) * | 2020-02-10 | 2021-08-19 | Choral Systems, Llc | Data analysis and visualization using structured data tables and nodal networks |
US20220021953A1 (en) * | 2020-07-16 | 2022-01-20 | R9 Labs, Llc | Systems and methods for processing data proximate to the point of collection |
Family Cites Families (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP0562251A2 (en) * | 1992-03-24 | 1993-09-29 | Universities Research Association, Inc. | Parallel data transfer network controlled by a dynamically reconfigurable serial network |
US5737549A (en) * | 1994-01-31 | 1998-04-07 | Ecole Polytechnique Federale De Lausanne | Method and apparatus for a parallel data storage and processing server |
US5909681A (en) * | 1996-03-25 | 1999-06-01 | Torrent Systems, Inc. | Computer system and computerized method for partitioning data for parallel processing |
JP3952518B2 (ja) | 1996-03-29 | 2007-08-01 | 株式会社日立製作所 | 多次元データ処理方法 |
US5848408A (en) * | 1997-02-28 | 1998-12-08 | Oracle Corporation | Method for executing star queries |
US6092062A (en) | 1997-06-30 | 2000-07-18 | International Business Machines Corporation | Relational database query optimization to perform query evaluation plan, pruning based on the partition properties |
JPH1153232A (ja) * | 1997-08-05 | 1999-02-26 | Hitachi Software Eng Co Ltd | データベース管理方法 |
JPH11110262A (ja) * | 1997-10-01 | 1999-04-23 | Toshiba Corp | 情報管理システム |
CA2345309A1 (en) * | 2000-09-18 | 2002-03-18 | Linmor Technologies Inc. | High performance relational database management system |
US7668740B1 (en) * | 2000-09-22 | 2010-02-23 | Ita Software, Inc. | Method, system, and computer program product for interfacing with information sources |
US7085769B1 (en) | 2001-04-26 | 2006-08-01 | Ncr Corporation | Method and apparatus for performing hash join |
US6968335B2 (en) * | 2002-11-14 | 2005-11-22 | Sesint, Inc. | Method and system for parallel processing of database queries |
-
2005
- 2005-02-17 JP JP2007503912A patent/JP4777972B2/ja active Active
- 2005-02-17 CN CN2005800054941A patent/CN101120340B/zh active Active
- 2005-02-17 MX MXPA06009355A patent/MXPA06009355A/es active IP Right Grant
- 2005-02-17 US US11/059,510 patent/US7818349B2/en active Active
- 2005-02-17 AU AU2005231230A patent/AU2005231230B2/en not_active Ceased
- 2005-02-17 EP EP05713785.3A patent/EP1716505B1/en active Active
- 2005-02-17 WO PCT/US2005/005199 patent/WO2005098655A2/en active Application Filing
- 2005-02-17 CA CA002556979A patent/CA2556979A1/en not_active Abandoned
-
2006
- 2006-09-18 KR KR1020067019203A patent/KR101114149B1/ko active IP Right Grant
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
KR101472257B1 (ko) * | 2014-07-22 | 2014-12-11 | (주)카디날정보기술 | 예측 논리적 데이터 지역성을 이용한 병렬질의 처리 방법 및 장치 |
KR20180021994A (ko) * | 2016-08-23 | 2018-03-06 | 주식회사 한컴시큐어 | 대용량 데이터베이스에 최적화된 암호화 스케줄링의 자동화가 가능한 데이터베이스 암호화 장치 및 그 동작 방법 |
Also Published As
Publication number | Publication date |
---|---|
EP1716505B1 (en) | 2018-01-10 |
CN101120340A (zh) | 2008-02-06 |
JP4777972B2 (ja) | 2011-09-21 |
EP1716505A2 (en) | 2006-11-02 |
JP2007531087A (ja) | 2007-11-01 |
US20050187977A1 (en) | 2005-08-25 |
WO2005098655A2 (en) | 2005-10-20 |
KR101114149B1 (ko) | 2012-03-08 |
AU2005231230A1 (en) | 2005-10-20 |
EP1716505A4 (en) | 2009-10-21 |
AU2005231230B2 (en) | 2010-05-27 |
CA2556979A1 (en) | 2005-10-20 |
CN101120340B (zh) | 2010-12-08 |
WO2005098655A3 (en) | 2007-09-27 |
MXPA06009355A (es) | 2007-03-01 |
US7818349B2 (en) | 2010-10-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
KR101114149B1 (ko) | 초 무공유 병렬 데이터베이스 | |
US11580070B2 (en) | Utilizing metadata to prune a data set | |
US11157478B2 (en) | Technique of comprehensively support autonomous JSON document object (AJD) cloud service | |
US11461356B2 (en) | Large scale unstructured database systems | |
AU2015219103B2 (en) | Transparent discovery of semi-structured data schema | |
US8935232B2 (en) | Query execution systems and methods | |
US20120109926A1 (en) | Scoped database connections | |
US6618729B1 (en) | Optimization of a star join operation using a bitmap index structure | |
US20130110873A1 (en) | Method and system for data storage and management | |
JP2001084257A (ja) | 問合せ処理方法及びシステム | |
US20210004712A1 (en) | Machine Learning Performance and Workload Management | |
Borkar et al. | Have your data and query it too: From key-value caching to big data management | |
US20180018343A1 (en) | Data pruning based on metadata | |
Romero et al. | Tuning small analytics on Big Data: Data partitioning and secondary indexes in the Hadoop ecosystem | |
US6470331B1 (en) | Very large table reduction in parallel processing database systems | |
US20100082600A1 (en) | System, method, and computer-readable medium for optimizing the performance of outer joins | |
Kurunji et al. | Optimizing aggregate query processing in cloud data warehouses |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
A201 | Request for examination | ||
E902 | Notification of reason for refusal | ||
E701 | Decision to grant or registration of patent right | ||
GRNT | Written decision to grant | ||
FPAY | Annual fee payment |
Payment date: 20150121 Year of fee payment: 4 |
|
FPAY | Annual fee payment |
Payment date: 20160104 Year of fee payment: 5 |
|
FPAY | Annual fee payment |
Payment date: 20170119 Year of fee payment: 6 |
|
FPAY | Annual fee payment |
Payment date: 20180118 Year of fee payment: 7 |
|
FPAY | Annual fee payment |
Payment date: 20190116 Year of fee payment: 8 |
|
FPAY | Annual fee payment |
Payment date: 20200115 Year of fee payment: 9 |