2
Greenplum数据库设计开发规范参考
644
73页
9次
2019-09-06
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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜