← Back to catalogue
Research draft

database

vr.tr.database · INF.MED

Let an agent help design, query, secure and maintain databases, choose database types, and handle personal data lawfully.

Thing Registry Information and virtual systems

Research draft, second pass

A second pass drafted this model: the structure a model of this thing needs, and what is known about it in the world. The line under this one says how the second half was obtained - researched against sources, or recalled without web access, in which case nothing here was read anywhere and every claim is a lead to verify. Unreviewed either way.

written by Claude from model knowledge without web access - no source was read, every claim is a lead to verify

Researched by: Claude

Purpose and description

Let an agent help design, query, secure and maintain databases, choose database types, and handle personal data lawfully.

An organised collection of data stored and accessed electronically, managed by a database management system, in models such as relational, document, key-value, graph and time-series databases; related systems include institutional and code repositories, which store files and history rather than structured records.

What it is for: Storing, retrieving and managing data.

It can be choose a database model; design schemas and write queries; secure and back up databases; comply with data protection rules.

Distinguishing features

Structured storage

Managed by a DBMS

Queryable

Needs security and backups

What it looks like

Not physical; tables, collections and graphs managed by software on servers.

How it is recognised

Tables, documents or graphs

Query languages such as SQL

Spreadsheets and code repositories are different tools

Related models

is a kind of - category

data set

is managed by - software

database management system

stores - content

personal data

is used in - practice

computer programming

In practice

Families and kinds

relational databases

document and key-value stores

graph databases

time-series and analytical databases

repositories (related sense)

Standards and regulation

ISO/IEC 9075 SQL

GDPR and data protection law

Database rights in the EU

Failure modes and hazards

SQL injection and breaches

Data loss without backups

Unlawful processing of personal data

Also called

source code repositoryinstitutional repositorygit repositoryGitHub repositoryHugging Face modelmonorepoCity of Santa Monica Designated Historic Landmarkquality registercancer registrygeographic names boardHakata Revival Plantriplestorepublic administration information system in the Czech Republiclegal information systemlegal databasetimetables portalsports databasedatabase driverMawsūʻat Al-Muṣannafāt Al-ʻArabīyahrisk registerfinding aidontologyelectoral rollarchival inventoryspecial listrepository guideonline finding aidslocation catalogcalendarblack bookbusiness registerheritage registerInternational Monohull Open Classes Associationservice cataloghealth registryunit ontologyorphaned ontologyinactive ontologybiomedical ontologyformal ontology

+197

Where this came from

wikidata · CC0 1.0

Source repository Registry entry point

Drafted structure

Bundle to layer to finding to question, as the second pass will find it: 4 bundles · 8 layers · 8 findings · 16 questions.

Design Choosing and designing.

Requirements drive design.

Model

Database type.

Model

Database type.

  1. Which database model suits this data and workload? action
  2. What are the trade-offs? boundary

Schema

Schema design.

Schema

Schema design.

  1. How should the schema be designed and normalised? action
  2. Which indexes are needed? measurement
Query Using data.

Queries retrieve data.

SQL

Writing queries.

SQL

Queries.

  1. How can this query be written and optimised? action
  2. Is it safe against injection? boundary

Performance

Tuning.

Performance

Performance.

  1. Why is this query slow, and how can it be improved? measurement
  2. What does the query plan show? definition
Security Protection.

Data must be protected.

Access

Access control.

Access

Access control.

  1. Are access controls, encryption and auditing in place? boundary
  2. Which guidance applies? provenance

Backup

Backups.

Backup

Backups.

  1. Are backups taken and tested for restore? boundary
  2. What recovery objectives are needed? measurement
Law Personal data.

Law governs data.

GDPR

Data protection.

GDPR

Data protection.

  1. Does the database hold personal data, and what legal basis and retention apply? provenance
  2. Is a data protection impact assessment needed? provenance

Senses

Repositories.

Senses

Repositories.

  1. Is a code or institutional repository meant rather than a database? boundary
  2. Which entry fits? action

What the second pass must settle

  • Should database models be separate entries?
  • How should products be linked?
  • How should repositories be split off?
Draft as JSON