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
what an index and the benefits
Index - object for quick lookup
Improves retrieval speed
Provides path to data
Improves performance
Explain Query optimization (oracle)
Choosing an efficient way to execute SQL
Oracle optimizer generates execution plans and picks one with low cost
What are DCL commands? 2 types
DCL commands control access
Grant
Revoke
Activities that can help writing DCl durint design phase
Documentation
Permission Set up
Role definition
Security policies
why is a vital part of db managing database backup and recovery
DB backup and recovery are essential for ensuring data availability and integrity in event of hardware failure and events
Key issues with database and backup recobery
Data loss prevention
Recovering time
Componenet of disaster recovery session
Testing
Communication
Documentation
Potential of cloud computing solution
Security
Reliable
Cost effective
Example Azure
Google cloud
what are views trigger procedure
View - table representing query result
trigger - a proc that executes in response to events on table
Procedure - Set of operations to perform a task
