数据库相关概念
分类专栏: Mysql&
简介 NoSql的阐述
<p class="MsoNormal"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: Calibri;">NoSQL </span><span style="font-family: 宋体;">意义</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000;"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: Calibri;">1.</span><span style="font-family: 宋体;">易扩展、高性能、高可用</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000;"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: Calibri;">2.</span><span style="font-family: 宋体;">较容易映射复杂数据</span><span style="font-family: Calibri;">(key-value)</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000;"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: Calibri;">3.</span><span style="font-family: 宋体;">无事务特性要求</span><span style="font-family: Calibri;">(ACID</span><span style="font-family: 宋体;">特性</span><span style="font-family: Calibri;">)</span></span></p>
<p class="MsoNormal"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">数据库相关概念</span></span></p>
<p class="MsoNormal"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">关系型数据库,</span> <span style="font-family: 宋体;">是指采用了关系模型来组织数据的数据库。</span></span></p>
<p class="MsoNormal"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: Calibri;">NoSQL</span><span style="font-family: 宋体;">是对不同于传统的关系数据库的数据库管理系统的统称。</span></span></p>
<p class="MsoNormal"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: Calibri;">NoSQL </span><span style="font-family: 宋体;">设计</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-list: l0 level1 lfo1;"><!-- [if !supportLists]--><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;">1. </span><!--[endif]--><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">常见场景及设计</span><span style="font-family: Calibri;">(</span><span style="font-family: 宋体;">内嵌、父</span><span style="font-family: Calibri;">/</span><span style="font-family: 宋体;">子引用、反范式</span><span style="font-family: Calibri;">)</span></span></p>
<p class="MsoNormal" style="mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"> </span></p>
<p class="MsoNormal" style="mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">什么是内嵌</span><span style="font-family: Calibri;">?</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">内嵌是指存在关联关系的文档,放在同一文档中,以数组的形式存放</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph; mso-list: l1 level1 lfo2;" align="justify"><!-- [if !supportLists]--><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;">1. </span><!--[endif]--><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">减少了关联查询</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph; mso-list: l1 level1 lfo2;" align="justify"><!-- [if !supportLists]--><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;">2. </span><!--[endif]--><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">适合于单类需要描述的属性</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph; mso-list: l1 level1 lfo2;" align="justify"><!-- [if !supportLists]--><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;">3. </span><!--[endif]--><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">不经常变化的属性</span><span style="font-family: Calibri;">(</span><span style="font-family: 宋体;">扩展、嵌套关联</span><span style="font-family: Calibri;">) </span></span></p>
<p class="MsoNormal" style="mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">什么是父引用</span><span style="font-family: Calibri;">?</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">父引用是指存在一对多的情况中,放在同一文档中,以数组的形式存放。</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">子引用是指存在一对非常多的情况中,由于数据库文档存放限制,这个时候进行反向引用。</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph; mso-list: l2 level1 lfo3;" align="justify"><!-- [if !supportLists]--><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;">1. </span><!--[endif]--><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">引用数据内容是否非常多</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph; mso-list: l2 level1 lfo3;" align="justify"><!-- [if !supportLists]--><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;">2. </span><!--[endif]--><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">引用数据量是否非常庞大,而且在增加</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph; mso-list: l2 level1 lfo3;" align="justify"><!-- [if !supportLists]--><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;">3. </span><!--[endif]--><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">数据是否需要单独访问</span></span></p>
<p class="MsoNormal" style="mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">什么是反范式?</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">范式是指按既定的用法,范式就是一种公认的模型或模式。反范式</span><span style="font-family: Calibri;">-></span><span style="font-family: 宋体;">不走寻常路</span><span style="font-family: Calibri;">~~~</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph; mso-list: l3 level1 lfo4;" align="justify"><!-- [if !supportLists]--><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;">1. </span><!--[endif]--><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">是否又提升性能的区间</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph; mso-list: l3 level1 lfo4;" align="justify"><!-- [if !supportLists]--><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;">2. </span><!--[endif]--><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">数据量的变化是否非常庞大,庞大到更新会异常低效</span></span></p>
<p class="MsoNormal" style="text-indent: 21.0000pt; mso-char-indent-count: 0.0000; mso-pagination: none; text-align: justify; text-justify: inter-ideograph; mso-list: l3 level1 lfo4;" align="justify"><!-- [if !supportLists]--><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;">3. </span><!--[endif]--><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">先考虑读写比,才考虑反范式</span></span></p>
<p class="MsoNormal" style="mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"> </span></p>
<p class="MsoNormal" style="mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">总结:</span></span></p>
<p class="MsoNormal" style="mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">优先考虑内嵌,如果单独访问,则不适合</span></span></p>
<p class="MsoNormal" style="mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">数组不应该无限制增长</span></span></p>
<p class="MsoNormal" style="mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"><span style="font-family: 宋体;">考虑读写比,考虑反范式,考虑应用场景</span></span></p>
<p class="MsoNormal" style="mso-pagination: none; text-align: justify; text-justify: inter-ideograph;" align="justify"><span style="mso-spacerun: 'yes'; font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'; font-size: 10.5000pt; mso-font-kerning: 1.0000pt;"> </span></p>
分享到:
转载:
喜欢 2
收藏
暂无评论信息
- 相关文章
- 文章推荐
-
淘宝 NPM 镜像站喊你切换新域名啦
淘宝 NPM 镜像站(npm.taobao.org)自 2014 年 正式对外服务,一开始只是想简单地做 NPM 的中国镜像站点,回馈国内前端社区,不知不觉竟然一直运行到现在。当年参考 Ruby Gems 淘宝镜像 的方式,跟阿里开源组织申请了 taobao.org 的二级域名,镜像站点名称也自然而然地取名为 淘宝 NPM 镜像站 (下称 CNPM)。
-
docker搭建jenkins环境执行宿主机的docker无权限的解决方法
初次搭建jenkins持续集成工具的时候,在运行项目阶段出现 permission denied的情况
-
娱美德旗下MMORPG手游《传奇4》将推出新PVP玩法"比奇掠夺"&
《传奇4》推出新门派PVP玩法!韩国首尔2022年6月29日 /美通社/ -- 《传奇4》(MIR4)的新PVP玩法比奇掠夺(Bicheon Heist)于2022年6月28日推出。
-
乐视官方确认还有 400 多人:消息称员工“没有内卷和 996”,过着“没有老板”的神仙日子
7 月 11 日消息,近期,微博博主 @Fenng 分享了一个冷知识:乐视居然还剩下 400 多人,有不少是五年以上的老员工。这些老员工称“幸福感是很多老乐视人留下来的理由”,没有内卷和 996,没拖欠过留下来的员工的工资,也没停过社保。
- 点击排行
- 站长推荐
- 猜你喜欢
- 网站信息
- 站内问答:12篇
- 站内文章:213篇
- 建站时间:已运行1242天
- 备案号: 浙ICP备2022018799号
- 语言:
- English(USA)
- French(FR)
- Chinese(ZH)
无数据