EDS Flashcards
Key issues with availablity
Ensuring data is accessible when needed
Rac to allow multiple servers
ASM to simply management with disk mirroring
Key issues with Intergirty
Ensuring data is accurate + consistent
Primary + foreign key maintains unique records
Acid - oracles transaction system to ensure reliable process
Key issues with Security
Protecting data from unauthorized access
Oracle identity management - enforce access control
RBAC - assign permissions based on user roles to ensure users have appropriate access
Key issues with backup and recovery
Ensuring data can be restored
Oracle recovery manager - used for backups
Data pump - allow for high speed data movement
Static and transactional data differences
Static - not volatile e.g student detail
Transation - volatile e.g discount
Issues to be considered storing transactional and static data
static = not changeable
transactional = changeable
How do organisition capture data
App info - in app purchases, location
Social media - interactions on social media
Online transactions - browsing history, purchase details
How companies use transaction data
Customer Insight - targeted market, behaviour analysis
Financial Analysis - Fraud detection, revenue forecast
GDPR rights
Notification of issues
Enhanced rights (erasure and access)
Major inputs into physical design and build process of a database
Database requirements (data volume, transaction rates)
Backup strategy
Data access
Decisions influenced by inputs physical database
Storage media (HDD)
Caching (query performance)
The basic Data storage options available
Tablespaces - logic storage units that group
Data files - File that store tablespace data
Archive log files - archive copies of log files for back usage
What is Primary and Secondary storage
primary - accessible by cpu
eg. buffer cache - stores data block
shared pool - cached sql code and info
secondary - unaccessible by cpu
e.g Hard drive, SSD
Storage options available in terms of primary and secondary
HDD - storage based application
SDD - performance based application
Oracle cloud system
Tablespace benefits
Allows for easy management of data storage
Provide flexibilty in db object management
Performance tuning
