CN104503966B - PostgreSQL大数据高效免维护自动分区方法 - Google Patents
PostgreSQL大数据高效免维护自动分区方法 Download PDFInfo
- Publication number
- CN104503966B CN104503966B CN201410550641.4A CN201410550641A CN104503966B CN 104503966 B CN104503966 B CN 104503966B CN 201410550641 A CN201410550641 A CN 201410550641A CN 104503966 B CN104503966 B CN 104503966B
- Authority
- CN
- China
- Prior art keywords
- partition
- data
- subregion
- fixed
- active
- 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
Links
Classifications
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (4)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410550641.4A CN104503966B (zh) | 2014-10-16 | 2014-10-16 | PostgreSQL大数据高效免维护自动分区方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410550641.4A CN104503966B (zh) | 2014-10-16 | 2014-10-16 | PostgreSQL大数据高效免维护自动分区方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104503966A CN104503966A (zh) | 2015-04-08 |
CN104503966B true CN104503966B (zh) | 2017-12-12 |
Family
ID=52945364
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410550641.4A Active CN104503966B (zh) | 2014-10-16 | 2014-10-16 | PostgreSQL大数据高效免维护自动分区方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104503966B (zh) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107818167A (zh) * | 2017-11-08 | 2018-03-20 | 顺丰科技有限公司 | MySQL分区自动管理方法、***、设备、存储介质 |
Families Citing this family (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105354315B (zh) * | 2015-11-11 | 2018-10-30 | 华为技术有限公司 | 分布式数据库中子表***的方法、子表节点和*** |
CN107943412B (zh) * | 2016-10-12 | 2021-10-22 | 阿里巴巴集团控股有限公司 | 一种分区***、删除分区中数据文件的方法、装置及*** |
CN106649552B (zh) * | 2016-11-07 | 2020-05-12 | 湖北省农村信用社联合社网络信息中心 | 常态化数据清理方法 |
CN112597160A (zh) * | 2020-12-23 | 2021-04-02 | 网宿科技股份有限公司 | 数据库表维护方法、装置、服务器及存储介质 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2003271494A (ja) * | 2002-03-13 | 2003-09-26 | Ntt Comware Corp | 情報収集システム、情報収集方法、情報収集プログラムおよび記録媒体 |
CN1645336A (zh) * | 2005-01-20 | 2005-07-27 | 上海复旦光华信息科技股份有限公司 | 基于模板的异构日志信息自动提取与分析方法 |
CN101957748A (zh) * | 2009-07-17 | 2011-01-26 | ***通信集团黑龙江有限公司 | 一种数据逻辑分析方法、装置及*** |
GB2505210A (en) * | 2012-08-22 | 2014-02-26 | Datashaka Ltd | Processing time series data |
-
2014
- 2014-10-16 CN CN201410550641.4A patent/CN104503966B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2003271494A (ja) * | 2002-03-13 | 2003-09-26 | Ntt Comware Corp | 情報収集システム、情報収集方法、情報収集プログラムおよび記録媒体 |
CN1645336A (zh) * | 2005-01-20 | 2005-07-27 | 上海复旦光华信息科技股份有限公司 | 基于模板的异构日志信息自动提取与分析方法 |
CN101957748A (zh) * | 2009-07-17 | 2011-01-26 | ***通信集团黑龙江有限公司 | 一种数据逻辑分析方法、装置及*** |
GB2505210A (en) * | 2012-08-22 | 2014-02-26 | Datashaka Ltd | Processing time series data |
Non-Patent Citations (1)
Title |
---|
基于PostgreSQL数据库的GML数据存储;张爱国等;《测绘科学》;20080131;第194-196页 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107818167A (zh) * | 2017-11-08 | 2018-03-20 | 顺丰科技有限公司 | MySQL分区自动管理方法、***、设备、存储介质 |
CN107818167B (zh) * | 2017-11-08 | 2020-06-30 | 顺丰科技有限公司 | MySQL分区自动管理方法、***、设备、存储介质 |
Also Published As
Publication number | Publication date |
---|---|
CN104503966A (zh) | 2015-04-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104503966B (zh) | PostgreSQL大数据高效免维护自动分区方法 | |
CN103488704B (zh) | 一种数据存储方法及装置 | |
CN103765381B (zh) | 对b+树的并行操作 | |
CN105426373B (zh) | 一种数据库同步方法与设备 | |
CN106484906A (zh) | 一种分布式对象存储***闪回方法及装置 | |
CN107562931A (zh) | 数据抽取***和数据抽取方法 | |
CN101763415B (zh) | 一种数据库的b树索引的生成方法及装置 | |
US20160342667A1 (en) | Managing database with counting bloom filters | |
CN105657567A (zh) | 一种展示赛事信息的方法、装置及*** | |
CN105045535B (zh) | 一种自动删除过期数据的方法和*** | |
CN1936864A (zh) | 不定长记录的数据组织方法 | |
CN107193869A (zh) | 工业物联网云平台中数据存取的方法及装置 | |
CN113010523A (zh) | 数据仓库拉链表存储方法、刷新方法及可读存储介质 | |
US8412701B2 (en) | Multi-dataset global index | |
CN102982186A (zh) | 基于oracle数据库***的range分区表的维护方法和*** | |
CN103020201B (zh) | 一种存储***自动精简配置存储池及组织管理的方法 | |
CN106354775A (zh) | 一种基于自定义字段的数据动态配置***及配置方法 | |
WO2017106765A1 (en) | Log fragmentation method and apparatus | |
CN103399904B (zh) | 数据处理方法及数据处理*** | |
CN107273443A (zh) | 一种基于大数据模型元数据的混合索引方法 | |
CN110018794A (zh) | 一种垃圾回收方法、装置、存储***及可读存储介质 | |
CN109908590B (zh) | 一种游戏推荐方法、装置、设备及介质 | |
CN106202293B (zh) | 一种突发事件语料库的更新方法及装置 | |
CN109992573B (zh) | 一种实现hdfs文件占用率自动监控的方法及*** | |
Lindh | Gender switching in the clonal understory herb Coptis laciniata (Ranunculaceae) |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP02 | Change in the address of a patent holder | ||
CP02 | Change in the address of a patent holder |
Address after: 310000 room 821, building 1, Xinjun building, 330 Internet of things street, Xixing street, Binjiang District, Hangzhou City, Zhejiang Province Patentee after: Hangzhou Sky-mobi Technology Co., Ltd. Address before: 10, building 2, block B, The Union Buildings, No. 310013, Bauhinia Road, Zhejiang, Hangzhou Patentee before: Hangzhou Sky-mobi Technology Co., Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210409 Address after: 355200 no.181 erbatou, taimuyang village, Qinyu Town, Fuding City, Ningde City, Fujian Province Patentee after: Chen Ximei Address before: Room 821, building 1, Xinjun building, 330 Internet of things street, Xixing street, Binjiang District, Hangzhou City, Zhejiang Province 310000 Patentee before: HANGZHOU SKY NETWORK TECHNOLOGY Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210705 Address after: 21f-a, Shenmao business center, 59 Xinwen Road, Meiling community, Lianhua street, Futian District, Shenzhen, Guangdong 518000 Patentee after: Shenzhen Hanfei Network Technology Co.,Ltd. Address before: 355200 no.181 erbatou, taimuyang village, Qinyu Town, Fuding City, Ningde City, Fujian Province Patentee before: Chen Ximei |