CN107515899A - 数据库联合分片方法、装置以及存储介质 - Google Patents
数据库联合分片方法、装置以及存储介质 Download PDFInfo
- Publication number
- CN107515899A CN107515899A CN201710604810.1A CN201710604810A CN107515899A CN 107515899 A CN107515899 A CN 107515899A CN 201710604810 A CN201710604810 A CN 201710604810A CN 107515899 A CN107515899 A CN 107515899A
- Authority
- CN
- China
- Prior art keywords
- dimension table
- burst
- dimension
- field
- true
- 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.)
- Granted
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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24535—Query rewriting; Transformation of sub-queries or views
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
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)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710604810.1A CN107515899B (zh) | 2017-07-24 | 2017-07-24 | 数据库联合分片方法、装置以及存储介质 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710604810.1A CN107515899B (zh) | 2017-07-24 | 2017-07-24 | 数据库联合分片方法、装置以及存储介质 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107515899A true CN107515899A (zh) | 2017-12-26 |
CN107515899B CN107515899B (zh) | 2020-05-22 |
Family
ID=60722391
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710604810.1A Active CN107515899B (zh) | 2017-07-24 | 2017-07-24 | 数据库联合分片方法、装置以及存储介质 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107515899B (zh) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109542891A (zh) * | 2018-10-18 | 2019-03-29 | 北京新唐思创教育科技有限公司 | 数据融合方法及计算机存储介质 |
CN111625602A (zh) * | 2020-05-26 | 2020-09-04 | 北京思特奇信息技术股份有限公司 | 一种基于客户id的分库方法和装置 |
CN113220719A (zh) * | 2021-06-04 | 2021-08-06 | 上海天旦网络科技发展有限公司 | 一种海量维度数据关联查询优化方法及系统 |
CN113297333A (zh) * | 2021-03-17 | 2021-08-24 | 无锡极数宝大数据科技有限公司 | 数据处理方法、装置、服务器及存储介质 |
CN114327261A (zh) * | 2021-12-06 | 2022-04-12 | 神州融安数字科技(北京)有限公司 | 数据文件的存储方法及数据安全代理 |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102004752A (zh) * | 2009-08-31 | 2011-04-06 | 埃森哲环球服务有限公司 | 灵活的立方体数据入库 |
CN102156714A (zh) * | 2011-03-22 | 2011-08-17 | 清华大学 | 实现自适应垂直划分的关系型数据库的方法及系统 |
CN103336792A (zh) * | 2013-06-07 | 2013-10-02 | 华为技术有限公司 | 数据分区方法和装置 |
CN103631911A (zh) * | 2013-11-27 | 2014-03-12 | 中国人民大学 | 基于数组存储和向量处理的olap查询处理方法 |
CN105517644A (zh) * | 2014-03-05 | 2016-04-20 | 华为技术有限公司 | 一种数据分区方法和设备 |
CN105701209A (zh) * | 2016-01-13 | 2016-06-22 | 广西师范大学 | 一种提高大数据上并行连接性能的负载平衡方法 |
US20170116311A1 (en) * | 2015-10-23 | 2017-04-27 | Oracle International Corporation | System and method for use of automatic slice merge in a multidimensional database environment |
-
2017
- 2017-07-24 CN CN201710604810.1A patent/CN107515899B/zh active Active
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102004752A (zh) * | 2009-08-31 | 2011-04-06 | 埃森哲环球服务有限公司 | 灵活的立方体数据入库 |
CN102156714A (zh) * | 2011-03-22 | 2011-08-17 | 清华大学 | 实现自适应垂直划分的关系型数据库的方法及系统 |
CN103336792A (zh) * | 2013-06-07 | 2013-10-02 | 华为技术有限公司 | 数据分区方法和装置 |
CN103631911A (zh) * | 2013-11-27 | 2014-03-12 | 中国人民大学 | 基于数组存储和向量处理的olap查询处理方法 |
CN105517644A (zh) * | 2014-03-05 | 2016-04-20 | 华为技术有限公司 | 一种数据分区方法和设备 |
US20170116311A1 (en) * | 2015-10-23 | 2017-04-27 | Oracle International Corporation | System and method for use of automatic slice merge in a multidimensional database environment |
CN105701209A (zh) * | 2016-01-13 | 2016-06-22 | 广西师范大学 | 一种提高大数据上并行连接性能的负载平衡方法 |
Non-Patent Citations (2)
Title |
---|
宋雪姣: "面向海量数据的连接查询算法的优化研究", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
梁双 等: "基于聚类分析分库策略的社交网络数据库查询性能与数据迁移", 《计算机应用》 * |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109542891A (zh) * | 2018-10-18 | 2019-03-29 | 北京新唐思创教育科技有限公司 | 数据融合方法及计算机存储介质 |
CN109542891B (zh) * | 2018-10-18 | 2021-04-09 | 北京新唐思创教育科技有限公司 | 数据融合方法及计算机存储介质 |
CN111625602A (zh) * | 2020-05-26 | 2020-09-04 | 北京思特奇信息技术股份有限公司 | 一种基于客户id的分库方法和装置 |
CN113297333A (zh) * | 2021-03-17 | 2021-08-24 | 无锡极数宝大数据科技有限公司 | 数据处理方法、装置、服务器及存储介质 |
CN113220719A (zh) * | 2021-06-04 | 2021-08-06 | 上海天旦网络科技发展有限公司 | 一种海量维度数据关联查询优化方法及系统 |
CN114327261A (zh) * | 2021-12-06 | 2022-04-12 | 神州融安数字科技(北京)有限公司 | 数据文件的存储方法及数据安全代理 |
Also Published As
Publication number | Publication date |
---|---|
CN107515899B (zh) | 2020-05-22 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107515899A (zh) | 数据库联合分片方法、装置以及存储介质 | |
US11537276B2 (en) | Generating data visualizations according to an object model of selected data sources | |
US8447721B2 (en) | Interest-driven business intelligence systems and methods of data analysis using interest-driven data pipelines | |
US6748394B2 (en) | Graphical user interface for relational database | |
US6941311B2 (en) | Aggregate navigation system | |
US7167859B2 (en) | Database security | |
US7080090B2 (en) | Allocation measures and metric calculations in star schema multi-dimensional data warehouse | |
US9223810B2 (en) | Storage advisor for hybrid-store databases | |
US9405812B2 (en) | Systems and methods for providing performance metadata in interest-driven business intelligence systems | |
US20220300525A1 (en) | Systems and Methods for Using Multiple Aggregation Levels in a Single Data Visualization | |
US20150356137A1 (en) | Systems and Methods for Optimizing Data Analysis | |
CN107908733A (zh) | 一种全球贸易数据的查询方法,装置及系统 | |
CN105843842A (zh) | 一种大数据环境下多维聚集查询与展示系统及方法 | |
US7072897B2 (en) | Non-additive measures and metric calculation | |
CN107729500B (zh) | 一种联机分析处理的数据处理方法、装置及后台设备 | |
US6732115B2 (en) | Chameleon measure and metric calculation | |
EP1492026A2 (en) | System and method for expressing and calculating a relationship between OLAP measures | |
US7836052B2 (en) | Selection of attribute combination aggregations | |
JP2005018751A5 (zh) | ||
Lübcke et al. | A decision model to select the optimal storage architecture for relational databases | |
Vaisman et al. | Data warehouse concepts | |
WO2021102902A1 (zh) | 在制产品数量上限推荐的系统和方法、计算机可读介质 | |
CN108491541A (zh) | 一种应用于分布式的多维数据库联合查询方法及系统 | |
Dehne et al. | Cooperative caching for grid-enabled OLAP | |
Sasmita et al. | Design of Data Warehouse for Minimarket’s Sales Information Using Tabular Models |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
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 | ||
CB02 | Change of applicant information |
Address after: 100070 Times Fortune Tiandi Building, No. 1 Hangfeng Road, Fengtai District, Beijing, 28 Floors Applicant after: BEIJING GUODIANTONG NETWORK TECHNOLOGY Co.,Ltd. Applicant after: STATE GRID CORPORATION OF CHINA Applicant after: STATE GRID BEIJING ELECTRIC POWER Co. Applicant after: Beijing Zhongdian Feihua Communications Co.,Ltd. Applicant after: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd. Address before: 100070 Times Fortune Tiandi Building, No. 1 Hangfeng Road, Fengtai District, Beijing, 28 Floors Applicant before: BEIJING GUODIANTONG NETWORK TECHNOLOGY Co.,Ltd. Applicant before: State Grid Corporation of China Applicant before: STATE GRID BEIJING ELECTRIC POWER Co. Applicant before: Beijing Zhongdian Feihua Communications Co.,Ltd. Applicant before: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20190606 Address after: 100085 Beijing city Haidian District Qinghe small Camp Road No. 15 Applicant after: BEIJING CHINA POWER INFORMATION TECHNOLOGY Co.,Ltd. Applicant after: STATE GRID CORPORATION OF CHINA Applicant after: STATE GRID BEIJING ELECTRIC POWER Co. Applicant after: Beijing Zhongdian Feihua Communications Co.,Ltd. Applicant after: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd. Address before: 100070 Times Fortune Tiandi Building, No. 1 Hangfeng Road, Fengtai District, Beijing, 28 Floors Applicant before: BEIJING GUODIANTONG NETWORK TECHNOLOGY Co.,Ltd. Applicant before: STATE GRID CORPORATION OF CHINA Applicant before: STATE GRID BEIJING ELECTRIC POWER Co. Applicant before: Beijing Zhongdian Feihua Communications Co.,Ltd. Applicant before: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd. |
|
GR01 | Patent grant | ||
GR01 | Patent grant |