Chapter 1 : Database Management Flashcards
(120 cards)
1
Q
why do computers store data?
A
instructions for functioning
data in RAM for app
images/files for app
2
Q
structures commonly used to store data
A
files and databases
3
Q
where is data saved when the user is working on it
A
memory
4
Q
where is data saved when it will be accessed later
A
database/file on more permanent storage devices
5
Q
data
A
unprocessed numbers, facts or signals
6
Q
information
A
processed and organised data into something meaningful
7
Q
most nb tool for data storage by web developers and programmers
A
databases
8
Q
database
A
collection of organised data
9
Q
give an example of how a database can be used in web development / programming
A
settings of app
text and graphics
personal messages, status updates and comments on social networks
10
Q
DMBS
A
database management software
11
Q
database management software
A
the software responsible for managing a database
12
Q
examples of what DMBS does
A
creating DB
creating tables
managing data security
13
Q
examples of DMBS
A
Microsoft SQL Server
Microsoft Access
MySQL
SQLite
14
Q
how was data added to DB in grade 11
A
manually
15
Q
how does this translate to commercial applications of DB
A
ineffective
only suitable for small DB
16
Q
what do most DB do instead for data capture?
A
different automatic techniques
17
Q
techniques for automatic data capture
A
LITTerFooD:
forms
tags
> RFID
» E-Tolls
digital sensors
invisible online data collection
transaction tracking
location based data
18
Q
what does the form method entail
A
web form
19
Q
web form
A
online interactive page that allows user input
20
Q
format of web form
A
imitates physical form
21
Q
what do web forms make use of and why?
A
GUI components
assist with user input + limit errors
22
Q
GUI components used
A
checkboxes
combo boxes
spinners
drop down lists
text boxes
buttons
23
Q
web form limitations
A
sophisticated
sensitive data capture
24
Q
examples of sophisticated web forms
A
banking
shopping
job/enrolment applications
25
how are sophisticated web forms run?
programmed objects
functions
methods
26
effect of web forms on society
changed business processes
limits paperwork/documentation
online documentation favorable
27
what does tags entail?
electronic tags
28
how do electronic tags work?
transmission of radio frequency from tag to tag reader, or vica versa, transmits info to computer program associated with the tag
29
tags primary function
track/ID item
30
examples of how tags used
merchandising warehouses
vehicle tracking
pet tracking
31
examples of types/applications of tags
RFID
e-tolls and RFID
32
RFID stands for
radio frequency identification
33
what does RFID refer to?
tiny chips that can store a few KB of info
34
how is RFID used?
RFID chip scanned to RFID reader
info read + displayed on computer
{software used to add to DB}
35
how popular is RFID :P
thousands of businesses around the world :P
36
RFID used to tag (examples) ...
products
> warehouse
> shop
tools in workshop
tickets
> conference, sports events, concerts
> public transport
37
how are products in a warehouse tagged?
item removed > automatically scanned + removed from DB
38
how are tools in a workshop tagged?
track what used, by who, and when returned
39
how are tickets of events tagged?
arrival at gate opens it automatically
data to DB
40
how are tickets of transport tagged?
Gautrain
trip recorded to DB
cost subtracted from user's balance
41
how are products in shops tagged?
item purchased > scanned > product info retrieved > bill
> removed from inventory
42
what are the two essential parts working together to make RFID usage possible?
RFID
software
43
elaborate on relationship between RFID and software
basic RFID reader scans info on RFID chips > available to computer
software automatically adds that info to DB + additional info (when + where scanned)
44
e-toll meaning
electronic toll
45
what is the RFID chip used in e-tolls?
e-tag
46
how were e-tags employed?
motorists required to purchase one
47
what did e-toll system use to achieve goal?
combo of cameras and RFID readers
auto record info of vehicles driving through toll gantry
info in DB
DB used to generate monthly invoice
48
what is a digital sensor?
an electronic or electrochemical sensor that converts and transmits data digitally
49
examples of data transmitted by digital sensors
temperature
distance
humidity
light
50
what do sensors sense?
wide range of different energy forms:
- mvmt (Ek)
- electrical signals (V)
- radiant energy (Ep)
- pressure (k)
- thermal energy (C/Ep)
- magnetic energy (N)
51
what do wireless sensor tags do?
connect events in physical world
52
examples of events in physical world transmitted
motion sensors
door/window opened/closed
temp/humidity exceed limit
smartphones/web browsers with internet access
53
role of DB in internet
heart/memory
store most info displayed
54
where the role of DB in the internet particularly evident and why?
websites where users create content
impossible to manually add data
info entered automatically added to DB
55
how else are DB used for social networking apps?
DB on devices store user's personal info (login details)
56
example of invisible online data collection?
cookie
57
what is a cookie?
1. a message given to a web browser by a web server
2. the web browser stores the message in a text file
3. each time the browser requests a page from the server the message is sent back to the server
58
what are cookies used for?
1. identifies users > customise accordingly
2. personal info entered once
59
how are cookies used to personalise your internet experience?
advertisements targeted by advertising companies
60
how do adverts use data to send you relevant ads?
a lot of data - massive DBs
software that automatically tracks users and their activity
61
use of software in automatic data capture
read and record info in DB
automate reports
62
what does transaction tracking refer to?
tracking of customer's transaction data
63
examples of transaction data
type
store
employee
customer
payment info
64
where is the transaction data sent?
stores > corporate DB
65
where is transaction data stored?
credit cards
store cards (Edgars)
store loyalty cards (Clicks ClubCard)
66
benefits of transaction tracking
consumer safety
enhancing on-site experience - tracking browsing history + demographic profiles
fraud detection
67
disadvantage of transaction tracking
unauthorised use of personal info
68
what is location based data?
data that provides information about different things that can be shown on maps
69
types of location based data
static and non-static
70
static LBD examples
roadmaps
farming info
government buildings + assets
electric distribution networks (pylons, substations)
military info
71
non-static LBD examples
position/tracking of aeroplanes, transport, people, animals/pets, satellites, traffic
based on input from geographic positioning systems (GPS).
72
What is used for the application of LBD?
LBS location based services
73
What are location based services?
Services that use software applications together with location-based databases to deliver a service
74
Examples of LBS
best route
location of stolen vehicle
lost pet
Pokémon GO
75
What is the third type of location based thing?
Location based computing
76
Location based computing
Software based on a user’s location
77
How do the location based things relate to one another?
LBD + LBC = LBS
78
What is best at LBC
Smartphones and tablets
79
Examples of LBC
Weather apps
Food delivery apps
Car sharing services - Uber
80
What is a warehouse?
Place where you can store a large number of items/products
81
Data warehousing
Technique for storing data from more than one database, similar to how factories and distribution companies store items irl
82
How does a data warehouse differ from most DBs?
Takes data from DBs and store in non-normalised/efficient way
83
What does this mean for the data?
Redundancies
Additional storage space
84
What is normalisation?
The process of refining the structure of a DB to minimise redundancy and improve integrity
85
What is data redundancy?
State in which the same piece of data is held in more than one place in a DB
86
What is data warehousing used in?
BI - business intelligence
87
What is BI?
several technologies and applications that are used to improve business decision making
88
What is the goal of data warehousing?
Make data available and ready for analysis
89
How does a data warehouse differ from the DBs on which it is formed?
- not contain copies of og DBs
- new DB created to hold structured data from multiple sources (DB)
90
Data warehouse access
Usually opened to multiple people in diff dept of company - access data and use to useful create graphs and reports
91
How are data warehouses and DB similar?
Relational data systems
92
How does a db and data warehouse differ?
Purpose
93
Purpose of data warehouse
stores a large quantity of historical data and all the data
from the various databases are available
94
Purpose of DB
stores current transactions and enables easy access to specific
transactions for ongoing business processes
95
What is data mining?
Process used to identify trends/patterns between different data sets in large DBs (big data) by selecting applicable data from them
96
What can data mining improve?
Decision making
97
Area in which data mining is used
Marketing
98
How is data mining used in marketing?
Explores increasingly large DBs to improve market segmentation
99
How does data mining perform market segmentation?
- extracts personal data pertaining to certain demographics
- looks for patterns/trends between them
- guesses behaviour accordingly
- directs personalised loyalty campaigns
100
what can data mining predict in terms of market segmentation?
- subscriptions
- interests based on searches
- mailing list content with successful response
101
give examples of big data
- Amazon sales info
- TV show views
- Tweets
102
what is the basic process used to make sense of big data?
data mining process
103
data mining process
- extract relevant data
- look for patterns in data
- discover knowledge from patterns
104
example of massive DB?
UN DB -info for most countries in world
105
why do you need to extract the data?
- large amounts of data
- select useful, small section of data
- don't filter massive DB, use full DB to create new DB containing only relevant info
106
how is data (mostly) extracted from the DB?
sql :P (I <3 sql)
107
what is sql?
programming language created to manipulate and extract data from a database
108
what can users do with sql?
specify exact data wanting to extract
109
how to make sql query?
- fields
- data table
- conditions
= only data meeting requirements extracted + used for analysis
110
why do we look for patterns in the data?
- large data : impossible to look at individual data points
- understand data set in whole
= knowledge - decisions - strategies
111
how do these steps create knowledge?
- patterns turn large amount of disorganised data into few useful facts
- confirm truth of data
- informed decisions made + strategies developed
112
what does SASSA stand for?
South African Social Security Agency
113
what does SASSA do?
provide social security services against vulnerability and poverty
114
how does SASSA achieve this?
through social grants
115
how are grants provisioned?
'means tested' - assesses value of assets + income > threshold eligible for grant
116
what does the gov issue to determine living circumstances of SA?
annual GHS - general household survey
117
what does the GHS include?
big data on:
- education
- health
- social development
- housing
- service and facility access
- food security
- agriculture
118
how is the GHS used to provide social grants to citizens?
data mining:
- useful data extracted
- data analysed
- obtain knowledge/info
> provides budget for necessary grants + where to set threshold + reports
119
how are social networking sites examples of big data?
- accumulate personal data over time > identifiable data collection
- users don't understand extent
- becomes Big Data
- data integration mixes it with other data sources
120
how is this social networking Big Data used in data mining?
- access, extract relevant, store in smaller DB
- apps using data analytics analyse online presence and behaviour to compile data about users
- info/knowledge > determine emotional state, suggest friends, etc.
