Term Glossary (Topic 1.1-1.2) Flashcards
State the difference between Functional and Non-Functional requirements
Functional - Tell us what the system should do
Non-Functional - How the system should work
Describe ‘Data Integration’
Bringing data together from separate sources to speed up data access and improve data consistency
State the four requirements for data integration
1) Records identifiable with unique key (primary key)
2) Data should have consistent format
3) Controlled with standard policies and procedures in place
4) Data integration activities should be logged and properly overseen
State the two reasons why we integrate data
1) Reduce data complexity
2) Allow analysis that would otherwise be impossible
Describe the difference between policies and practices when data integrating
Policies - Policies outline organisational strategy towards combining datasets
Practices - practices describe what to do or avoid when integrating data
Why do we integrate data from multiple sources?
In order to get a holistic view of a process, we must integrate the data. This gives us control as to what data will be combined.
Name the three Common User interfaces with data
1) Dashboards
2) Scorecards
3) Interactive Graphs
Describe ‘Dashboards’ when referring to Common User interfaces
Normally dynamic graphical and tabular displays of data offering functions such as cross filtering and sorting.
Describe ‘Scorecards’ when referring to Common User interfaces
Similar to dashboards but often show a number of key performance indicators often with conditional formatting and highlighting to show issues.
Describe ‘Physical data integration’ when referring to Common User interfaces
Data from multiple locations is joined in one location. This is often done using JOINS or UNIONs. The combined data is then stored physically together.
Describe ‘Virtual Data Integration’ when referring to Common User interfaces
Keeping data sources apart but creating a ‘software layer’ that allows users to access the combined data.
State three advantages of utilising virtual data integration
o Communication channels can be protected and monitored.
o Data transfer is done on request as part of an ETL process.
o Datasets can be stored in smaller, more manageable tables.
Describe ‘Extract, Transform & Load’ when referring to Common User interfaces
An automated process that takes data (often integrating it) (Extract), applying some form of data processing (such as filtering, aggregation or sorting) (Transform), finally the data is loaded to a destination (either a server, user PC or other machine).
State three examples of non-functional requirements
Reliability, Scalability, Usability
