Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add a LG for improving database #35

Open
hoch4 opened this issue Feb 21, 2024 · 0 comments
Open

Add a LG for improving database #35

hoch4 opened this issue Feb 21, 2024 · 0 comments
Assignees
Labels
enhancement New feature or request V2024

Comments

@hoch4
Copy link
Collaborator

hoch4 commented Feb 21, 2024

The curriculum has a focus on IT systems. Since databases are a substantial part of most systems, it is important to consider database topics in the curriculum.

Some of the subsequent topics could be part of the learning goal.

Split-up Database

  • Shared Database
  • Database View
  • Database Wrapping Service
  • Database-as-a-Service Interface
  • Aggregate Exposing Monolith
  • Change Data Ownership
  • Split Table
  • Move Foreign-key Relationship to Code

Data quality criteria

  • Credibility
  • Usefulness
  • Interpretability
  • Key integrity

Clean data:

  • Remove irrelevant data
  • Save data with the right data type
  • Drop or merge duplicates
  • Scale, transform, normalize
  • Deal with missing values: drop, impute, hot-deck, flag
  • Handle wrong data: outliers, in-record & cross-dataset errors

References:

  • See: Newman, S. (2020). Monolith to microservices: Evolutionary patterns to transform your monolith. O’Reilly Media, Inc.
  • Taxonomie von Datenqualitätskriterien (vgl. [Hinrichs 2002, S. 30])

#page:03-module-block-3/LZ-3-01.adoc

@gernotstarke gernotstarke self-assigned this Feb 26, 2024
@gernotstarke gernotstarke added enhancement New feature or request V2024 labels Jul 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request V2024
Projects
Status: Backlog
Development

No branches or pull requests

2 participants