Please enable JavaScript.
Coggle requires JavaScript to display documents.
Wk2_L Data Storage Formats (Delimiter-separated Values Format (2D array -…
Wk2_L Data Storage Formats
Delimiter-separated Values Format
Delimiter Collision
Exchange files b/w MS Win & Linux/Mac OS
2D array - table
Delimiter character
Double quotes
Extracting Data
Extract Columns
Awk
Cut
Extract Rows
Tail
awk, sed
Head
Data-interchange Format
XML
Data represented as attribute-value pairs
Different standards for syntax
Older format than JSON - larger file size
JSON
Data represented as attribute-value pairs
Values
Nested structure:
Object { }
Contains 4 attribute-value pairs
Array [ ]
Each element is object
strings
digits
boolean
null
Readable to humans & interpreted by computer
Converting nested/structured data
JSON, XML, HTML nested
CLI tools treat files as plain text
Databases
SQL - programming language
Data Manipulation Language (DML)
Delete
Extract (query)
Insert
Data Definition Language (DDL)
Constraints
Primary Key
Entity Integrity
NOT Null
Foreign Key
Referential integrity
Domain
Value of attribute
From domain assigned to that attribute
Relational Schema
Refers to set of relations
Attributes
Constraints
No Data
Relational Databases
Data in a table
About one specific entity
logically related
Tables linked by relationaships
Data is stored in tables (relations)