目录
1 引言 .................................................................................................................. 5
1.1 本文目的 .................................................................................................. 5
1.2 预期的读者和阅读建议.............................................................................. 5
1.3 参考资料 .................................................................................................. 5
2 为什么要迁移到LightDB ..................................................................................... 6
2.1 强大的功能及Oracle兼容性 ...................................................................... 6
2.2 更低的总拥有成本(TCO) ...................................................................... 8
2.3 原生HTAP ................................................................................................ 8
2.4 适配国产信创 ........................................................................................... 8
2.5 7*24原厂服务 .......................................................................................... 8
3 LightDB vs. Oracle基础特性比较 ....................................................................... 9
3.1 术语差异 .................................................................................................. 9
3.2 LightDB vs. Oracle 架构对比 ................................................................... 9
3.3 LightDB vs. Oracle 容量规格 ................................................................. 11
3.4 常用字符集 ............................................................................................ 12
4 LightDB vs. Oracle 结构比较 ........................................................................... 15
4.1 数据库(database)、模式(schema)与用户(user) ......................... 15
4.2 表空间 ................................................................................................... 15
4.3 数据类型映射 ......................................................................................... 17
4.4 表和分区 ................................................................................................ 19
4.5 主键ID ................................................................................................... 23
4.6 索引 ...................................................................................................... 24
5 LightDB vs. Oracle常用函数 ............................................................................ 28
6 LightDB vs. Oracle开发特性 ............................................................................ 29
6.1 全文检索 ................................................................................................ 32
7 应用程序开发 ................................................................................................... 33
7.1 客户端工具 ............................................................................................ 33
7.2 存储过程/函数 ....................................................................................... 40
7.3 JDBC驱动包 ........................................................................................... 44
7.4 C客户端库 ............................................................................................. 46
7.5 其它编程语言 ......................................................................................... 47
7.6 大数据导入导出 ...................................................................................... 47
8 数据库管理 ...................................................................................................... 48
相关文档
评论