Term
|
Definition
| Protect DB from unauth access, mod, destruction |
|
|
Term
|
Definition
| Individual's right to have control over info about them |
|
|
Term
| Types of security threats |
|
Definition
|
|
Term
|
Definition
| Unintentional, Accedidnetal deletion, Caused by weakness or errors in DBMS |
|
|
Term
|
Definition
| Intentiona access by unauthorized user |
|
|
Term
|
Definition
| Integrity, Availability, Confidentiality |
|
|
Term
|
Definition
| Requirement info be protected from improper modification |
|
|
Term
|
Definition
| Making Objects available to user that has right to access |
|
|
Term
|
Definition
| Protection of data from unauthorized disclosrue |
|
|
Term
| Physical Security Measures |
|
Definition
|
|
Term
|
Definition
| Workstation level, CAC cards |
|
|
Term
|
Definition
| Security subsystem designed by DBA using language |
|
|
Term
|
Definition
| DBA uses language toassign privileges to user of DB |
|
|
Term
|
Definition
| Means by which authorizations are implemented |
|
|
Term
|
Definition
| Used by DBA to plan access for variable users. Values READ< INSERT< UPDSATE DELETE |
|
|
Term
|
Definition
| Journal records attempted security violations |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Encryption alg/Key Decryption Alg/Key |
|
|
Term
|
Definition
| Barrier that protects organizations internal network |
|
|
Term
|
Definition
| Hides actual address of network |
|
|
Term
|
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
|
Definition
| Check integrity and validity of incoming data |
|
|
Term
|
Definition
| Segments of data organized into subsets, SPECIFIC SUBJECTS |
|
|
Term
|
Definition
| Storage available, Time, How long will it take, Warehouse online or off |
|
|
Term
|
Definition
| Multi dimensional matrix used for storage |
|
|
Term
|
Definition
| Data cube of 3+ dimensions |
|
|
Term
|
Definition
| Rotating to display different dimensions |
|
|
Term
|
Definition
| Display coarser level data by combining data |
|
|
Term
|
Definition
| Show more Data, requires lower level data be available |
|
|
Term
|
Definition
| Examine portion of cube using selection with equality conditions for one or more dimensions |
|
|
Term
|
Definition
| Specifying range of values in a selection |
|
|
Term
|
Definition
| Totals for rows and columns |
|
|
Term
|
Definition
| old way using multi dimensional arrays |
|
|
Term
|
Definition
| Modern Warehouse Relational Model |
|
|
Term
|
Definition
| Central table of Unaggregated data, each dimension has its own dimensional table. Use many foreign keys |
|
|
Term
|
Definition
| Variation of star schema where normalized dimensions have dimensions |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Joins values of dimension tables with rows of fact tables |
|
|
Term
|
Definition
| Pre-computing views from the definition ans storing them for later accesss |
|
|
Term
|
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
|
|
Term
|
Definition
| Discover new data by observing large amounts of data |
|
|
Term
|
Definition
| Used to apply logic to facts stored in Warehouse |
|
|
Term
|
Definition
| x-> Y if x happens it is likely Y happens |
|
|
Term
|
Definition
| % of transactions in data set that contain all items in both left/right sides |
|
|
Term
|
Definition
| % of when the rule is actually true |
|
|
Term
|
Definition
| xy if x happens it is likely that y happens. (x,y can be sets) |
|
|
Term
|
Definition
| Training set is set of past instances where the correct classification is known used to develop system |
|
|
Term
|
Definition
| Sequence of events that are all the same type, studied to find patterns |
|
|
Term
|
Definition
| Decision trees, regression, neural nets, clustering |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Serrver runs data access and applications |
|
|
Term
|
Definition
| Client taks on some applications processing |
|
|
Term
|
Definition
| Scalablility. Server has limited number of connections |
|
|
Term
|
Definition
| Presentation, application Data management |
|
|
Term
|
Definition
| Provide a snapshot of the intension of a table at a given time |
|
|
Term
|
Definition
| Allow DBMS to monitor DB like constrainst do with more flexability. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
