final exam Flashcards
Enterprise architecture definition
The plans for how a business will build, deploy, use and share its data, processes and IT assets.
Enterprise architecture principles
- Ease of use
- Speed and quality
- Buy over build
- Flexibility (ability to change) and agility (how fast the change can be)
- Innovative
- Data security
Common architectures
- Centralised / mainframe architecture
- Decentralised / server-based architecture
- Service oriented / web-based architecture
Issues in enterprise architecture
- Understanding existing architecture
- Designing for scalability
- Designing for security
- Assessing strategic timeframe
- Designing for standardisation
- Cost
- Designing for adaptability
- Designing for maintainability
Databases
Store operational / transactional information which is then transformed into analytical information
Causes of bad data
Garbage in => Garbage out
- Innacurate information
- Different standards around the world
- Abbreviations
- bad sources or fabricated data
Lenses to judge high-quality information
- Accuracy
- Timeliness
- Completeness
- Uniqueness
- Consistency
Databases definition
A database is an organised collection of logically related data (not necessarily electronic)
The data hierarchy
Database; then below
Table; then below
Record; then below
Field
Relational databases
The most popular way to store information is to use a relational database - can be represented using an Entity Relationship Diagram
Database management systems
A software system that is used to create, maintain, and provide controlled access to user databases
To use data for internet of things:
- Integrate isolated systems together
2. Get insight from that data
A data warehouse
A logical collection of information gathered from many different operational databases, that support business analysis activities and decision-making tasks. This gives you a single version of truth.
How to create a data warehouse:
ETL (Extract, Transform (cleanse), Load)
General characteristics of a data warehouse
- Subject oriented - when we create a data warehouse we generally want to improve something so for example we might collect all our sales data in one place
- Integrated between systems
- Time variant (i.e. has historical dividers)
- Non-volatile (the data doesn’t change)
Categories of data analysis for insights:
- OLAP (online analytical processing) tools to slice and dice data - kind of like a pivot table
- Data mining - the process of analysing data to extract information not offered by the raw data alone.
- Data visualisation
Data mining tools to uncover business intelligence - unsupervised learning
- Cluster analysis - a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible.
- Association detection - reveals the degree to which variables are related and the nature and frequency of these relationships in the information e.g. shopping cart
Hardware, software, networks definitions
Hardware = the physical components of the systems that physically enable it to operate Software = the intangible element of the system or the brain of the system Networks = the communication of the physical hardware components
Naming of software
SEE TUTORIAL
Moore’s law
The number of transistors on a chip will double approximately every two years (exponentially more powerful)
Networks
A communication mechanism created by:
- Linking two or more devices
- Establishing a protocol by which they can exchange data (protocol means communication language)
Wired links vs wireless links
Note that all links are physical - even if using radiowaves
Wired: faster, more reliable, better safety and security - broadcasting through the air makes it vulnerable to hacking
Wireless: more flexibility and ability to connect from wherever
Sustaining vs Disruptive technologies
Sustaining: the technology is faster, more stable, better features - the competitive advantage of the businesses that use this technology stays the same
Disruptive: Creates a new way of doing things that initially may not meet needs of existing customers e.g. smartphones. they 1) redefine the competitive playing fields of their markets and 2) tend to open new markets and destroy old ones