-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathDatabases.Rpres
137 lines (103 loc) · 3.24 KB
/
Databases.Rpres
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
Databases
========================================================
author: John Yocum
date: `r format(Sys.Date(), format="%B %d, %Y")`
transition: fade
Research Computing and Data Management
-------------------------------------------------------
[http://github.com/brianhigh/research-computing](http://github.com/brianhigh/research-computing)
<small style="font-size:.5em">
This work is licensed under a <a rel="license" href="http://creativecommons.org/licenses/by-sa/4.0/">Creative Commons Attribution-ShareAlike 4.0 International License</a>.<br />
<a rel="license" href="http://creativecommons.org/licenses/by-sa/4.0/"><img alt="Creative Commons License" style="border-width:0" src="https://i.creativecommons.org/l/by-sa/4.0/88x31.png" /></a>
</small>
Databases
========================================================
- Types
- Flat
- Relational
- NoSQL (various storage models)
- Query Languages
- SQL
- CQL
- Etc.
Key Terms
========================================================
- CRUD: Create, Read, Update, Delete
- ACID: Atomicity, Consistency, Isolation, Durability
- Normalization
- CAP Theorem
- Schema
Types
========================================================
- Flat
- Relational
- NoSQL (various storage models)
Flat File
========================================================
- Lightweight to a point
- Limited scalability
- No builtin concurrent access
- No indexing
- Lacks builtin consistency checking
Flat File Continued
========================================================
- show screenshot or demo of flat file
Flat File Examples
========================================================
- When to use it
- Recording temperature from a single sensor
Relational
========================================================
- General purpose
- Wide application support through ODBC
- Less duplicate data
- Example Engines
- MySQL
- SQLite
- Microsoft SQL Server
Relational Continued
========================================================
- Show screenshot or demo of relational DB
Relational Examples
========================================================
- When to use it
- Tracking multiple samples and locations
- Recording survey and interview answers
NoSQL
========================================================
- "Not Only SQL"
- Big Data
- Example Engines
- Apache Cassandra
- mongoDB
NoSQL Continued
========================================================
- Show the different data storage models
- Key/Value
- Document
- Tabular
NoSQL Examples
========================================================
- When to use it
- Recording high resolution (frequent) data from multiple sensors or locations
Query Languages
========================================================
- SQL
- Procedural Language, e.g. PL/Perl
- CQL
- Etc
Structured Query Language
========================================================
- ANSI Standard
- Proprietary Extensions
- Widely Supported
Other Query Languages
========================================================
- CQL: Cassandra
- PL/SQL: Oracle
- Transact-SQL: Microsoft SQL Server
Summary
========================================================
- Key Terms: CRUD, ACID, Normalization, Schema, CAP Theorem
- Types: Flat, Relational, NoSQL
- Query Languages: SQL, CQL, etc