Organizational Aspects of Data Management
9 important questions on Organizational Aspects of Data Management
What is the role of metadata?
Provides
- an extensible metamodel
- import/export facilities
- support for maintenance and reuse of metadata
- monitoring of integrity rules
- facilities for user access
- statistics about the data and its usage for the DBA and query optimizer
What is metadata modelling?
A database design process can be used to design a database storing metadata
Design a conceptual model of the metadata: EER or UML
Intrinsic data dimensions?
Objectivity: unbiased, unprejudiced, facts, impartial
Reputation: highly regarded in terms of source or content
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
Contextual data dimensions?
Appropriate: volume is enough
Value-added: provides advantages from use
Relevance: applicable and helpful
Timeless: sufficiently up-to-date
Actionable: ready for use
Representation data dimensions?
Easily-understandable: comprehension
Consistency: presented in the same format
Concisely-represented: compact, well presented, organized, and formatted
Alignment: reconcilable
-
Access data dimensions?
Security: wether data restricted to maintain security
Traceability: traceable to the source
What are common causes of bad data quality?
- subjective judgment in data production: objectivity
- limited computing resources: accessibility
- volume of data: accessibility
- changing data needs: relevance
- different processes updating the same data: consistency
Decoupling of data producers and consumers contributes to data quality problems
What is data governance?
Wang frame
Define, Measure, Analyze and Improve
Most efforts are mostly reactive and adhoc. Also annotate the data with data quality metadata as a short term solution??
What roles are the in data management?
Database designer
Data owner
Data steward
Database administrator
Data scientis
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding