📚

Database

TagsComputer science
Created
Updated

Resources

Key questions

How to choose a database for your project?

Are spreadsheets -Excel-, Access, Notion,... a database?

Yes, they are. But they won't either scale very well or fit with your needs. Remember they are not real relational databases.

Why we should create an electronic database?

This is an organizational decision.

Is digital more secure than paper?

Yes, it is.

Information, data, and database

Concepts

NameSyntagma
Storage
InformationHuman-readableSynthesized databasecontextual database
DataAssumed factsAtomic datumCharactersQuantitiesSymbols
Databasecoherent dataorganized datarecorded datastorage medium
KnowledgePredict future from information

How to keep documents, images, and other blobs?

You shouldn't use your database to keep blobs; Use a file system or object storage.

Story

The data is an organizational asset since at least Egyptian times.

🔥
Financial industry

Y2K Problem

Foundations

Database

💡
Database means organized and atomic collections of the data since the types, structures, and constraints of his storage medium (which usually is electronic), his domain, and his management system.

Archaic. Data bank is an obsolete term for databases.

Types

Data model

  1. Structure.
  1. Operations.
  1. Constraints.

Database management system

A database management system (DBMS) is a software system for defining, constructing, and sharing databases among various clients. It abstracts storage medium.

Good database model to deliver good information

Quickly, reliably, and consistently. It also won't be useful if it is stolen, lost, or corrupted when the system crashed.

User Needs and Requirements

This is no book about software engineering, so we’re not able to talk about how to extract business rules -requirements-. Here we’re assuming them, that is, you’re going to learn about database paradigms, their drawbacks, their advantages, building a Data Model such that it fits with requirements.

Relational databases and SQL

If you don't have a special constraint or requirement, you should use a relational database.

XML and JSON

JSON VS XML

http://www.json.org/xml.html

Database

Spreadsheets

Storage

Flat Files

INI Files

Spreadsheets

Hierarchical Databases

XML

Geographical Information System Database

NoSQL or non-relational

Key-value store, Redis case

JSON-like document store, Firestore case

JSON-like document store, MongoDB case

Wide-column store, Cassandra case

Graph database

Object database

Tabular

Tuple store

Triple/quad store (RDF) database

Multivalue database

Multimodel database

Information Retrieval

Next steps