2
Greenplum数据库设计开发规范参考
5墨值下载
Greenplum 数据库设计开发运行规范
Greenplum
数据库设计开发规范
参考文档
2016
年
7
月
Greenplum 数据库设计开发运行规范
目 录
GREENPLUM
数据库设计开发规范
............. ....................................... .................... .................... 1
V1.5
................................ .................... .................... ....................................... ............................ ... 1
1
前言
................................ .................... .................... ....................................... ....................... ...... 4
文档目的
........................................................................................................................................4
文档范围
.....................................................................................................................................4
预期读者
.....................................................................................................................................4
参考资料
.....................................................................................................................................4
2
开发规范检查项
................................ .................... .................... ....................................... .......... . 4
3 GP
与
TD
的差异关注点
................................ .................... .................... .................................... 6
4
系统级设计
................................ .................... .................... ....................................... .................. 7
用户设计
.....................................................................................................................................7
4.1.1
超级用户
...............................................................................................................................8
4.1.2
公共查询用户
......................................................................................................... ..............8
4.1.3
公共数据区用户
...................................................................................................................8
4.1.4
集市系统用户
......................................................................................................... ..............8
数据库表空间设计
........................................................................................................................9
资源队列设计
...........................................................................................................................10
系统级的维护工作
...................................................................................................................11
4.4.1
系统表的维护工作
.............................................................................................................11
4.4.2
各种库表的维护工作
.........................................................................................................12
4.4.3
投产前统一收集统计信息
.................................................................................. ...............1 2
5
命名规范
................................ .................... .................... ....................................... .................... 12
6
数据库对象设计规范
................................ .................... .................... ........................................ 13
数据库对象数据量
...................................................................................................................13
表创建规范
...............................................................................................................................13
表设计
.......................................................................................................................................14
6.3.1
数据类型
............................................................................................................................. 14
6.3.2
数据分布
............................................................................................................................. 16
6.3.3
数据分区
............................................................................................................................. 17
6.3.4
数据表压缩
.........................................................................................................................21
6.3.5
数据表行列存储
........................................................................................................ .........22
索引设计
......................................................................................................................................23
视图设计
...................................................................................................................................25
设计
........................................................................................................................26
其他数据库对象设计
...............................................................................................................26
6.7.1 Schema
...................................................................................................................... .......26
6.7.2
函数
.....................................................................................................................................26
of 73
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论