simply a way or a model, for you to store data, in an organised manner

even a csv, excel, or json file can be a database.

database paradigms

https://tudip.com/blog-post/7-database-paradigms/

Relational

https://www.seas.upenn.edu/~zives/03f/cis550/codd.pdf

op paradigm

data is segregated and represented as tables, made of rows (each entry), column (each field)

relational because you can define a relation between tables

cardinality - how 2 tables are related to one another i.e one to one, one to many, many to many

primary key - key of each row in a table

Indexing

https://stackoverflow.com/a/1130/11750752

creating an index means we can search via that field faster

DBMS

A software that handles a database, interacting with it etc. It basically exposes an API for you to interact with the data it’s stored wherever. Might be storage/memory(redis)

https://www.reddit.com/r/AskComputerScience/comments/k3608d/comment/ge228uf

https://www.reddit.com/r/AskComputerScience/comments/k3608d/comment/ge426g7

ORM

instead of interacting with your DB via SQL as the api, you can interact w it in the same OO language you’re working with, in an OO manner i.e objects are query inputs and results. essentially, a wrapper around SQL. internally, anything can happen.

https://www.linkedin.com/posts/vb-software_performance-how-to-make-prisma-perform-a-activity-7117747401464905730-yMGG?utm_source=share&utm_medium=member_desktop