Data Architecture
15 important questions on Data Architecture
What is transient data?
What is exhaust data?
What is derived data?
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What are the main kinds of data?
- Form (qualitative and quantitative)
- Structure (structured, semi-structured, unstructured)
- Source (captured, derived, exhaust, transient)
- Producer (primary, secondary, tertiary)
- Type (indexical, attribute, metadata)
What unstructured data?
What are some issues with spreadsheet data?
It is loosely structured, and there is limited space available.
Data volume is an issue.
What are the different ways of structuring your data?
- Tabular
- Hierarchical (relationships between data points)
- Matrix (relationships between entities)
What are the characteristics of operational databases?
- Data Integration = Low, dedicated to different application environments, such as Point of Sale, Inventory, Accounting and Logistics.
- Orientation = Transaction oriented (order entry, purchasing, invoicing)
- Data retention = limited because of performance and security concerns (weeks to months)
- Volatility = High (recording and fetching single transactions, for example, inserting/updating/deleting fields)
- Role of time = real-time, where time is an indicative record (represents current values when accessed, such as transaction time stamps)
Exam: What is the difference between operational databases and data warehouses?
Where operational database data is concerned with current data, the data warehouses are usually concerned with historic data.
Exam: What is the difference between dimensions and measures, provide examples
Measures contain quantitative, numeric values that you can measure.
What is an approach to deal with big data?
What is the SAC paradigm?
What does distributing computing mean?
What are the elements of the knowledge pyramid of Adler?
What are the the three types of data discussed in the 'kinds of data' slide?
- Indexical
- Attribute
- Metadata
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