Database System Security
Aggregation - SQL provides a # of functions that combine records from one
or more tables to produce potentially useful information
Has security vulnerabilities - aggregation attacks are used to collect
numerous low level security items or low level items and combine them to
create higher security level or value
Inference - similar attacks are aggregation - involve combining several pieces
of nonsenstive information to gain access to information that should be
classified at a higher level - like someone in accounting can see new hire
salary and figure out salaries for others
Data Warehouse- large databases to store large amounts of information from
a variety of db's
Data Dictionary - storing critical information about data, usage, type,
sources, relationships and formats
Data mining - allows analysts to comb through data warehouses and look for
potential correlated info
Data Analytics - the science of raw data examination with the focus of
extracting useful information out of the bulk
Big Data - refers to a collection of data that have become so large that
traditional means of analysis or processing are ineffective
Large Scale Parallel Data systems - computation system designed to perform
numerous calculations at the same time and go far beyond multiprocessing
capabilities
Asymmetric Multiprocessing AMP - operate independently of each other has
its own OS or instruction set
Symmetric Multiprocessing - SMP - each share a common OS and memory
Aggregation - SQL provides a # of functions that combine records from one
or more tables to produce potentially useful information
Has security vulnerabilities - aggregation attacks are used to collect
numerous low level security items or low level items and combine them to
create higher security level or value
Inference - similar attacks are aggregation - involve combining several pieces
of nonsenstive information to gain access to information that should be
classified at a higher level - like someone in accounting can see new hire
salary and figure out salaries for others
Data Warehouse- large databases to store large amounts of information from
a variety of db's
Data Dictionary - storing critical information about data, usage, type,
sources, relationships and formats
Data mining - allows analysts to comb through data warehouses and look for
potential correlated info
Data Analytics - the science of raw data examination with the focus of
extracting useful information out of the bulk
Big Data - refers to a collection of data that have become so large that
traditional means of analysis or processing are ineffective
Large Scale Parallel Data systems - computation system designed to perform
numerous calculations at the same time and go far beyond multiprocessing
capabilities
Asymmetric Multiprocessing AMP - operate independently of each other has
its own OS or instruction set
Symmetric Multiprocessing - SMP - each share a common OS and memory
