CN110100242B - 表的增量聚类维护 - Google Patents

表的增量聚类维护 Download PDF

Info

Publication number
CN110100242B
CN110100242B CN201780067721.6A CN201780067721A CN110100242B CN 110100242 B CN110100242 B CN 110100242B CN 201780067721 A CN201780067721 A CN 201780067721A CN 110100242 B CN110100242 B CN 110100242B
Authority
CN
China
Prior art keywords
partitions
clustering
partition
overlap
attributes
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
CN201780067721.6A
Other languages
English (en)
Chinese (zh)
Other versions
CN110100242A (zh
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.)
Snowflake Inc
Original Assignee
Snowflake Computing 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 Snowflake Computing Inc filed Critical Snowflake Computing Inc
Publication of CN110100242A publication Critical patent/CN110100242A/zh
Application granted granted Critical
Publication of CN110100242B publication Critical patent/CN110100242B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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/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/2282—Tablespace storage structures; 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/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/245—Query processing
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN201780067721.6A 2016-09-02 2017-09-05 表的增量聚类维护 Active CN110100242B (zh)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US201662383201P 2016-09-02 2016-09-02
US62/383,201 2016-09-02
PCT/US2017/050075 WO2018045372A1 (en) 2016-09-02 2017-09-05 Incremental clustering maintenance of a table

Publications (2)

Publication Number Publication Date
CN110100242A CN110100242A (zh) 2019-08-06
CN110100242B true CN110100242B (zh) 2024-03-12

Family

ID=61281332

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201780067721.6A Active CN110100242B (zh) 2016-09-02 2017-09-05 表的增量聚类维护

Country Status (8)

Country Link
US (4) US10817540B2 (enExample)
EP (2) EP4280075A1 (enExample)
JP (1) JP6870071B2 (enExample)
CN (1) CN110100242B (enExample)
AU (1) AU2017321966B2 (enExample)
CA (1) CA3035445C (enExample)
DE (1) DE202017007212U1 (enExample)
WO (1) WO2018045372A1 (enExample)

Families Citing this family (44)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10817540B2 (en) 2016-09-02 2020-10-27 Snowflake Inc. Incremental clustering maintenance of a table
US10268726B1 (en) * 2017-04-20 2019-04-23 Amazon Technologies, Inc. Partition key management for improved throughput
EP3714367A4 (en) 2018-03-22 2021-01-20 Snowflake Inc. INCREMENTAL DEVELOPMENT OF FUNCTION AND CAPTURE OF WORKLOAD IN DATABASE SYSTEMS
GB201809174D0 (en) * 2018-06-05 2018-07-25 Swarm64 As Data processing
JP6614280B1 (ja) * 2018-06-05 2019-12-04 富士通株式会社 通信装置および通信方法
CN111656340B (zh) * 2018-07-06 2023-07-18 斯诺弗雷克公司 在数据库系统中的数据复制和数据故障转移
CN112437916B (zh) 2018-07-17 2024-08-06 雪花公司 数据库表的增量群集
US11347714B2 (en) * 2018-11-06 2022-05-31 Snowflake Inc. Tracking changes in database data
US10977244B2 (en) 2018-11-06 2021-04-13 Snowflake Inc. Tracking intermediate changes in database data
US11086840B2 (en) * 2018-12-07 2021-08-10 Snowflake Inc. Transactional streaming of change tracking data
US10909121B2 (en) 2019-02-22 2021-02-02 Snowflake Inc. Storing multi-level metadata in database systems
US10977278B2 (en) * 2019-02-22 2021-04-13 Snowflake Inc. Multi-level metadata in database systems
US11138213B2 (en) 2019-04-10 2021-10-05 Snowflake Inc. Internal resource provisioning in database systems
US11163807B2 (en) 2019-06-05 2021-11-02 Premier Healthcare Solutions, Inc. System for data structure clustering based on variation in data attribute performance
US11567939B2 (en) 2019-12-26 2023-01-31 Snowflake Inc. Lazy reassembling of semi-structured data
US11308090B2 (en) 2019-12-26 2022-04-19 Snowflake Inc. Pruning index to support semi-structured data types
US10769150B1 (en) 2019-12-26 2020-09-08 Snowflake Inc. Pruning indexes to enhance database query processing
US10997179B1 (en) 2019-12-26 2021-05-04 Snowflake Inc. Pruning index for optimization of pattern matching queries
US12050605B2 (en) 2019-12-26 2024-07-30 Snowflake Inc. Indexed geospatial predicate search
US11016975B1 (en) 2019-12-26 2021-05-25 Snowflake Inc. Scan set pruning for pattern matching queries
US11372860B2 (en) 2019-12-26 2022-06-28 Snowflake Inc. Processing techniques for queries where predicate values are unknown until runtime
US11681708B2 (en) 2019-12-26 2023-06-20 Snowflake Inc. Indexed regular expression search with N-grams
US11436261B2 (en) 2020-04-14 2022-09-06 Google Llc Shuffle-less reclustering of clustered tables
US11423049B2 (en) 2020-05-11 2022-08-23 Google Llc Execution-time dynamic range partitioning transformations
US11537557B2 (en) * 2020-05-22 2022-12-27 Microsoft Technology Licensing, Llc Incrementally improving clustering of cross partition data in a distributed data system
US10997210B1 (en) * 2020-05-29 2021-05-04 Snowflake Inc. System for implementing sub-database replication
CN113806358B (zh) * 2020-05-29 2023-02-17 斯诺弗雷克公司 实现子表复制的方法和系统以及计算机可读存储介质
WO2022073212A1 (en) 2020-10-09 2022-04-14 Alipay (Hangzhou) Information Technology Co., Ltd. Managing blockchain-based trustable transaction services
WO2022073210A1 (en) 2020-10-09 2022-04-14 Alipay (Hangzhou) Information Technology Co., Ltd. Managing blockchain-based trustable transaction services
US11615095B2 (en) * 2020-10-30 2023-03-28 Snowflake Inc. Automatic pruning cutoff in a database system
KR102450101B1 (ko) * 2020-11-27 2022-10-05 한국전력공사 시계열 데이터 관리 장치 및 방법
US11868346B2 (en) * 2020-12-30 2024-01-09 Oracle International Corporation Automated linear clustering recommendation for database zone maps
US11822582B2 (en) * 2022-01-20 2023-11-21 Snowflake Inc. Metadata clustering
US11593345B1 (en) * 2022-01-21 2023-02-28 Snowflake Inc. Accelerating change data capture determination using row bitsets
US11941029B2 (en) 2022-02-03 2024-03-26 Bank Of America Corporation Automatic extension of database partitions
US12222964B2 (en) 2022-04-28 2025-02-11 Snowflake Inc. Database processing using hybrid key-value tables
US12430315B2 (en) 2022-07-20 2025-09-30 The Toronto-Dominion Bank System, method, and device for uploading data from premises to remote computing environments
US12353843B2 (en) * 2022-08-25 2025-07-08 Databricks, Inc. Efficient merge of tabular data using a processing filter
US12346330B2 (en) * 2022-08-25 2025-07-01 Databricks, Inc. Efficient merge of tabular data using mixing
US11907263B1 (en) 2022-10-11 2024-02-20 Oracle International Corporation Automated interleaved clustering recommendation for database zone maps
CN115755954B (zh) * 2022-10-28 2023-07-25 佳源科技股份有限公司 巡检路径规划方法、系统、计算机设备及存储介质
US11880369B1 (en) 2022-11-21 2024-01-23 Snowflake Inc. Pruning data based on state of top K operator
US12386863B2 (en) * 2023-04-18 2025-08-12 Snowflake Inc. Micro-partition clustering based on expression property metadata
US12399898B1 (en) 2024-05-29 2025-08-26 Ebay Inc. Optimized partitioning method for hive tables

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102804168A (zh) * 2009-06-19 2012-11-28 赛贝斯股份有限公司 在数据库系统中减少存储需求的数据压缩
CN105814562A (zh) * 2013-12-13 2016-07-27 国际商业机器公司 用于在线无共享数据库的扩充的递增和并置的重新分布

Family Cites Families (68)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5448727A (en) * 1991-04-30 1995-09-05 Hewlett-Packard Company Domain based partitioning and reclustering of relations in object-oriented relational database management systems
US5442778A (en) * 1991-11-12 1995-08-15 Xerox Corporation Scatter-gather: a cluster-based method and apparatus for browsing large document collections
CA2124094C (en) * 1994-05-20 1999-07-20 K. Bernhard Schiefer Method and apparatus for optimizing data retrieval using index scanning
CA2150745C (en) * 1995-06-01 2001-05-01 Chaitanya K. Baru Method and apparatus for implementing partial declustering in a parallel database system
US5832182A (en) * 1996-04-24 1998-11-03 Wisconsin Alumni Research Foundation Method and system for data clustering for very large databases
US5960431A (en) * 1996-12-19 1999-09-28 International Business Machines Corporation Method and apparatus for adding data storage bins to a stored computer database while minimizing movement of data and balancing data distribution
US6295367B1 (en) * 1997-06-19 2001-09-25 Emtera Corporation System and method for tracking movement of objects in a scene using correspondence graphs
US6449612B1 (en) * 1998-03-17 2002-09-10 Microsoft Corporation Varying cluster number in a scalable clustering system for use with large databases
US6269375B1 (en) * 1998-04-01 2001-07-31 International Business Machines Corporation Rebalancing partitioned data
US6185666B1 (en) * 1999-09-11 2001-02-06 Powerquest Corporation Merging computer partitions
US6931390B1 (en) 2001-02-27 2005-08-16 Oracle International Corporation Method and mechanism for database partitioning
US6785684B2 (en) * 2001-03-27 2004-08-31 International Business Machines Corporation Apparatus and method for determining clustering factor in a database using block level sampling
US6748393B1 (en) * 2001-04-20 2004-06-08 Microsoft Corporation Transparent updates to partitioned views in a federated database system
US7080081B2 (en) * 2002-04-15 2006-07-18 International Business Machines Corporation Multidimensional data clustering scheme for query processing and maintenance in relational databases
US7295970B1 (en) * 2002-08-29 2007-11-13 At&T Corp Unsupervised speaker segmentation of multi-speaker speech data
US7299239B1 (en) * 2002-12-02 2007-11-20 Oracle International Corporation Methods for partitioning an object
US7739313B2 (en) * 2003-05-30 2010-06-15 Hewlett-Packard Development Company, L.P. Method and system for finding conjunctive clusters
US7747606B2 (en) * 2003-09-06 2010-06-29 Oracle International Corporation Automatic SQL tuning advisor
US20050223046A1 (en) * 2004-04-06 2005-10-06 Smith Rick A Method and system for balancing and scheduling database maintenance tasks
US7447679B2 (en) * 2004-05-07 2008-11-04 Oracle International Corporation Optimizing execution of a database query by using the partitioning schema of a partitioned object to select a subset of partitions from another partitioned object
US7483873B2 (en) 2005-01-18 2009-01-27 International Business Machines Corporation Method, system and article of manufacture for improving execution efficiency of a database workload
US8126870B2 (en) * 2005-03-28 2012-02-28 Sybase, Inc. System and methodology for parallel query optimization using semantic-based partitioning
US8204837B2 (en) * 2006-01-06 2012-06-19 Sony Corporation Information processing apparatus and method, and program for providing information suitable for a predetermined mood of a user
US7885791B2 (en) * 2007-02-21 2011-02-08 British Telecommunications Public Limited Company Method for capturing local and evolving clusters
US8484220B2 (en) * 2007-03-06 2013-07-09 Mcafee, Inc. Clustered index with differentiated subfields
US20080228783A1 (en) * 2007-03-14 2008-09-18 Dawn Moffat Data Partitioning Systems
US7797347B2 (en) 2007-03-21 2010-09-14 International Business Machines Corporation Workload aware checking of database reorganization
AU2008201035A1 (en) * 2007-04-13 2008-10-30 Acei Ab A partition management system
US9853986B2 (en) * 2007-12-28 2017-12-26 Entit Software Llc Clustering event data by multiple time dimensions
WO2009141818A1 (en) 2008-05-19 2009-11-26 Technion Research & Development Foundation Ltd. Apparatus and method for incremental physical data clustering
WO2009153793A1 (en) * 2008-06-20 2009-12-23 Technion Research & Development Foundation Ltd. Incremental clustering of indexed xml data
US8078645B2 (en) * 2008-07-09 2011-12-13 Yahoo! Inc. Operations on multi-level nested data structure
CN101639835A (zh) * 2008-07-30 2010-02-03 国际商业机器公司 多租户场景中应用数据库分区的方法和装置
KR101003842B1 (ko) * 2008-10-24 2010-12-23 연세대학교 산학협력단 다차원 데이터 스트림을 위한 클러스터링 방법 및 시스템
US20100153431A1 (en) 2008-12-11 2010-06-17 Louis Burger Alert triggered statistics collections
US9298761B2 (en) 2009-04-30 2016-03-29 Hewlett Packard Enterprise Development Lp Adaptive merging in database indexes
WO2011149961A2 (en) * 2010-05-24 2011-12-01 Intersect Ptp, Inc. Systems and methods for identifying intersections using content metadata
JP5542530B2 (ja) * 2010-06-04 2014-07-09 株式会社日立ソリューションズ サンプリング位置決定装置
US8805784B2 (en) * 2010-10-28 2014-08-12 Microsoft Corporation Partitioning online databases
JP5825790B2 (ja) * 2011-01-11 2015-12-02 日本ソフトウェアマネジメント株式会社 核酸情報処理装置およびその処理方法
US8903823B1 (en) * 2011-05-25 2014-12-02 Cadence Design Systems, Inc. Coverage-based bug clustering
JP2013080403A (ja) * 2011-10-04 2013-05-02 Nippon Telegr & Teleph Corp <Ntt> テーブルパーティション分割装置及び方法及びプログラム
US8918288B2 (en) * 2011-10-14 2014-12-23 Precision Energy Services, Inc. Clustering process for analyzing pressure gradient data
CN108388632B (zh) * 2011-11-15 2021-11-19 起元科技有限公司 数据分群、分段、以及并行化
US8676772B2 (en) * 2011-12-09 2014-03-18 Telduráðgevin Sp/f Systems and methods for improving database performance
US8667010B2 (en) 2012-01-27 2014-03-04 Microsfot Corporation Database table partitioning allowing overlaps used in full text query
US9852010B2 (en) * 2012-02-03 2017-12-26 Microsoft Technology Licensing, Llc Decoupling partitioning for scalability
US9146988B2 (en) * 2012-06-05 2015-09-29 King Fahd University Of Petroleum And Minerals Hierarchal clustering method for large XML data
US9680915B2 (en) * 2012-09-12 2017-06-13 Infosys Limited Methods for clustering networks based on topology discovery and devices thereof
US9430550B2 (en) * 2012-09-28 2016-08-30 Oracle International Corporation Clustering a table in a relational database management system
US9208257B2 (en) * 2013-03-15 2015-12-08 Oracle International Corporation Partitioning a graph by iteratively excluding edges
EP2804114A1 (en) * 2013-05-16 2014-11-19 Fujitsu Limited Database controller, method, and program for managing a distributed data store
US9489443B1 (en) * 2013-05-24 2016-11-08 Amazon Technologies, Inc. Scheduling of splits and moves of database partitions
WO2014197997A1 (en) * 2013-06-14 2014-12-18 University Of Guelph Systems, methods, and computer program products for merging a new nucleotide or amino acid sequence into operational taxonomic units
US9558221B2 (en) 2013-11-13 2017-01-31 Sybase, Inc. Multi-pass, parallel merge for partitioned intermediate pages
US9639437B2 (en) * 2013-12-13 2017-05-02 Netapp, Inc. Techniques to manage non-disruptive SAN availability in a partitioned cluster
EP3100230A4 (en) * 2014-01-31 2017-10-04 OpenText Corporation Segments of contacts
US20160299961A1 (en) * 2014-02-04 2016-10-13 David Allen Olsen System and method for grouping segments of data sequences into clusters
US9665633B2 (en) 2014-02-19 2017-05-30 Snowflake Computing, Inc. Data management systems and methods
US10002148B2 (en) 2014-07-22 2018-06-19 Oracle International Corporation Memory-aware joins based in a database cluster
US10067969B2 (en) * 2015-05-29 2018-09-04 Nuodb, Inc. Table partitioning within distributed database systems
JP6590606B2 (ja) * 2015-09-11 2019-10-16 キヤノン株式会社 画像処理装置、画像処理方法、プログラム
US10354188B2 (en) * 2016-08-02 2019-07-16 Microsoft Technology Licensing, Llc Extracting facts from unstructured information
US10108691B2 (en) * 2015-09-28 2018-10-23 Memsql, Inc. Atomic clustering operations for managing a partitioned cluster online
US10061841B2 (en) * 2015-10-21 2018-08-28 International Business Machines Corporation Fast path traversal in a relational database-based graph structure
US11176206B2 (en) * 2015-12-01 2021-11-16 International Business Machines Corporation Incremental generation of models with dynamic clustering
US20180165380A1 (en) 2016-03-29 2018-06-14 Hitachi, Ltd. Data processing system and data processing method
US10817540B2 (en) 2016-09-02 2020-10-27 Snowflake Inc. Incremental clustering maintenance of a table

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102804168A (zh) * 2009-06-19 2012-11-28 赛贝斯股份有限公司 在数据库系统中减少存储需求的数据压缩
CN105814562A (zh) * 2013-12-13 2016-07-27 国际商业机器公司 用于在线无共享数据库的扩充的递增和并置的重新分布

Also Published As

Publication number Publication date
CA3035445C (en) 2023-08-22
US11100142B2 (en) 2021-08-24
AU2017321966B2 (en) 2021-01-28
AU2017321966A1 (en) 2019-03-28
US20180068008A1 (en) 2018-03-08
EP3507724A4 (en) 2020-04-08
US20210019335A1 (en) 2021-01-21
US10997215B2 (en) 2021-05-04
EP3507724A1 (en) 2019-07-10
EP4280075A1 (en) 2023-11-22
US20210216574A1 (en) 2021-07-15
WO2018045372A1 (en) 2018-03-08
CA3035445A1 (en) 2018-03-08
CN110100242A (zh) 2019-08-06
US20210019336A1 (en) 2021-01-21
DE202017007212U1 (de) 2020-02-06
US10817540B2 (en) 2020-10-27
JP2019530068A (ja) 2019-10-17
US11106704B2 (en) 2021-08-31
JP6870071B2 (ja) 2021-05-12

Similar Documents

Publication Publication Date Title
CN110100242B (zh) 表的增量聚类维护
US11403275B2 (en) Incremental reclustering of database tables using reclustering-count levels
Nathan et al. Learning multi-dimensional indexes
US11194780B2 (en) Early exit from table scans of loosely ordered and/or grouped relations using nearly ordered maps
Van Renen et al. Why TPC is not enough: An analysis of the Amazon Redshift fleet
US11256852B2 (en) Converting portions of documents between structured and unstructured data formats to improve computing efficiency and schema flexibility
US9110949B2 (en) Generating estimates for query optimization
EP3014488B1 (en) Incremental maintenance of range-partitioned statistics for query optimization
US20110082855A1 (en) Multi-dimensional access to data
Rong et al. Approximate partition selection for big-data workloads using summary statistics
Kim et al. Optimally leveraging density and locality to support limit queries
Wan et al. When Optimizer Chooses Table Scans: How to Make Them More Responsive
US9471545B2 (en) Approximating value densities
Kim et al. Speedy browsing and sampling with needletail
Olma Timely and cost-efficient data exploration through adaptive tuning.
Nguyen Robust data partitioning for ad-hoc query processing

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
CB02 Change of applicant information

Address after: Montana

Applicant after: SNOWFLAKE COMPUTING Inc.

Address before: California, USA

Applicant before: SNOWFLAKE COMPUTING Inc.

CB02 Change of applicant information
GR01 Patent grant
GR01 Patent grant
CP03 Change of name, title or address

Address after: Montana

Patentee after: Snowflake Co.

Country or region after: U.S.A.

Address before: Montana

Patentee before: SNOWFLAKE COMPUTING Inc.

Country or region before: U.S.A.

CP03 Change of name, title or address