Shared Flashcard Set

Details

DB Final
DataBase views/triggers/security
62
Computer Science
Graduate
09/13/2009

Additional Computer Science Flashcards

 


 

Cards

Term
DataBase Security
Definition
Protect DB from unauth access, mod, destruction
Term
DB Privacy
Definition
Individual's right to have control over info about them
Term
Types of security threats
Definition
Accidental, Deliberate
Term
Accidental Threat
Definition
Unintentional, Accedidnetal deletion, Caused by weakness or errors in DBMS
Term
Deliberate Threats
Definition
Intentiona access by unauthorized user
Term
Security Goals
Definition
Integrity, Availability, Confidentiality
Term
Integrity
Definition
Requirement info be protected from improper modification
Term
availability
Definition
Making Objects available to user that has right to access
Term
Confidentiality
Definition
Protection of data from unauthorized disclosrue
Term
Physical Security Measures
Definition
Id Checks, Sign Ins
Term
Physical authentication
Definition
Workstation level, CAC cards
Term
authorization language
Definition
Security subsystem designed by DBA using language
Term
Authorization Rules
Definition
DBA uses language toassign privileges to user of DB
Term
Access control
Definition
Means by which authorizations are implemented
Term
Access COntrol Matrix
Definition
Used by DBA to plan access for variable users. Values READ< INSERT< UPDSATE DELETE
Term
Security Log
Definition
Journal records attempted security violations
Term
Audit Trail
Definition
Records all access to DB
Term
Cipher Systems
Definition
Encryption alg/Key Decryption Alg/Key
Term
Firewall
Definition
Barrier that protects organizations internal network
Term
Proxy Server
Definition
Hides actual address of network
Term
Packet filter
Definition
Examines each packet, ensure they follow rules
Term
Online Transaction Process
Definition
real time, needs high availablility and Performance
Term
Online Analytical Processing
Definition
DB warehouse, Multiple sources, Standardized Data, Updates
Term
Data Cleaning
Definition
Check integrity and validity of incoming data
Term
Data Mart
Definition
Segments of data organized into subsets, SPECIFIC SUBJECTS
Term
Updates considerations
Definition
Storage available, Time, How long will it take, Warehouse online or off
Term
Data Cube
Definition
Multi dimensional matrix used for storage
Term
Hyper Cube
Definition
Data cube of 3+ dimensions
Term
Cube Pivot
Definition
Rotating to display different dimensions
Term
Cube rollup
Definition
Display coarser level data by combining data
Term
Cube Drill Down
Definition
Show more Data, requires lower level data be available
Term
Cube Slicing
Definition
Examine portion of cube using selection with equality conditions for one or more dimensions
Term
Cube DIcing
Definition
Specifying range of values in a selection
Term
Cube Cross Tabulation
Definition
Totals for rows and columns
Term
Multi_dimensional OLAP
Definition
old way using multi dimensional arrays
Term
Relational OLAP
Definition
Modern Warehouse Relational Model
Term
Star Schema
Definition
Central table of Unaggregated data, each dimension has its own dimensional table. Use many foreign keys
Term
SnowFlake Schema
Definition
Variation of star schema where normalized dimensions have dimensions
Term
Warehouse Indexing
Definition
Bitmap or Join
Term
Join
Definition
Joins values of dimension tables with rows of fact tables
Term
View Materialization
Definition
Pre-computing views from the definition ans storing them for later accesss
Term
Views Maintenance
Definition
Immediate or deferred - When underlying tables change should we change the views?
Term
Immediate View Maintenance
Definition
done as part of update Transaction - SLOW
Term
Deffered View Maintenance types
Definition
Lazy, Periodic, Force
Term
Data Mining
Definition
Discover new data by observing large amounts of data
Term
inference Engine
Definition
Used to apply logic to facts stored in Warehouse
Term
Associationo
Definition
x-> Y if x happens it is likely Y happens
Term
Association Support
Definition
% of transactions in data set that contain all items in both left/right sides
Term
Association Confidence
Definition
% of when the rule is actually true
Term
Sequential patterns
Definition
xy if x happens it is likely that y happens. (x,y can be sets)
Term
Classificationo
Definition
Training set is set of past instances where the correct classification is known used to develop system
Term
Time series Patterns
Definition
Sequence of events that are all the same type, studied to find patterns
Term
Develop class rules
Definition
Decision trees, regression, neural nets, clustering
Term
Two tier DB
Definition
DBMS and pc/clients
Term
Thin Client
Definition
Serrver runs data access and applications
Term
Thick/Fat client
Definition
Client taks on some applications processing
Term
Two Tier Problems
Definition
Scalablility. Server has limited number of connections
Term
Three Tier Setup
Definition
Presentation, application Data management
Term
Views
Definition
Provide a snapshot of the intension of a table at a given time
Term
triggers
Definition
Allow DBMS to monitor DB like constrainst do with more flexability.
Term
ECA Model
Definition
Event, Condition, Action
Term
Ending Transactions
Definition
COMMIT, ROLLBACK
Supporting users have an ad free experience!