Domain 8: Database pt 2 Flashcards
Data is stored in more than one database, but those databases are logically connected (many-to-many)
Distributed data model
Mixing data in a database with different classification levels and/or need-to-know requirements
Database contamination
Number of rows (tuples) in a relational database
Cardinality
Number of columns (attributes) in a relational database
Degree
Set of allowable values that the attribute can take
Domain
All database transactions have what four characteristics?
Bonus what’s the name of this model?
- Atomicity
- Consistency
- Isolation
- Durability
Bonus
ACID mode
- Database transaction characteristic
- If any part of the transactions fails the entire transaction must be rolled back as if it never occurred
Atomicity
- Database transaction characteristic
- All transactions must begin operating in an environment that is consistent with all of the database’s rules
Consistency
- Database transaction characteristic
- Requires that transactions operate separately from each other
Isolation
- Database transaction characteristic
- Once transactions are committed to the database, they must be preserved
Durability
Preventative security mechanism that ensures certain info stored in the database is always correct (integrity and availability protected)
Concurrency
- Failure when concurrency is not implemented
- Occurs when two different process make updates to a database unaware of each other’s activity
Lost updates
- Failure when concurrency is not implemented
- Occurs when a process reads a record from a transaction that did not successfully commit
Dirty reads
- Database security mechanism
- Hiding individual database fields or cells or imposing more security restrictions on them
Cell suppression
- Database security mechanism
- Evaluates the big picture to make access control decisions
Context-dependent access control
- Database security mechanism
- Process of splitting a single database into multiple parts, each with a unique and distinct security level or type of content
Database partitioning
- Database security mechanism
- Two or more rows in the same relational database table appear to have identical primary key elements but contain different data for use at differing classification levels
Polyinstantiation
- Database security mechanism
- Admins insert false or misleading data into a DBMS in order to redirect or thwart info confidentiality attacks
Noise and perturbation
Database feature that allows applications to communicate with different types of databases without having to be directly programmed for interaction with each type
Open Database Connectivity (ODBC)
Class of databases that use models other than the relational model to store data
NoSQL databases
- NoSQL database type
- Stores info in pairs
- ________ is an index used to uniquely identify a record
- Data is stored in the ________ pair
Key/value stores
- NoSQL database type
- Store data in graph format using nodes to represent objects and edges to represent relationships
Graph database
- NoSQL database type
- Similar to key/value stores in that they store info using keys, but data stores is more complex
Document stores
