Database Security Architecture

Running head: User Account Security

Colorado Technical University

Allen Suber

 CSS330-1502B-01: User Account Security

Professor Anita Arceneaux

Assignment IP1 – Database Security Architecture    

Assignment Due Date: 06/01/2015

Table of Contents

Database Security Architecture        

User Account Security        

Database Vulnerabilities        

Auditing Techniques        

Auditing Policies        

References        

Database Security Architecture

        There is a very unpretentious and distinct difference between a Database and a Database Management System – whereas a database is simply an organized system designed to store and retrieve potentially large volumes of data. A database stores an array of digital data to be accessed by any number of users - and often abbreviated DB - the categorized content may consist of text-documents, bibliographic, and statistical. They are classified according to their organizational approach, such as a Relational Database – which is a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways. It stores data in tables with relationships to other tables. A Distributed Database is one that can be dispersed or replicated among different points in a network. An Object Oriented Programming Database has the data defined in object classes and sub-classes. MySQL is a popular DBMS used online and is an example of object oriented DBMS, (Schultz, 2006).

        A Database may consist of diverse levels of abstraction in its architecture is typically three levels, external, internal, and conceptual make up the database architecture. The external level defines how the users view the data. A single database can consist of several views. The internal level defines how the data is physically stored. The conceptual level is the communication medium between internal and external levels. It provides a unique view of the database irrespective of how it is stored or viewed. There are a number of types of databases such as an Analytical database, Data warehouses and Distributed databases. Relational databases are made up of tables and they contain rows and columns, much like spreadsheets in Excel. The columns relate to an attribute while each row represents a single record. As an example, a database that stores employee data of a company, the columns could contain employee name, employee id and salary, while a single row represents a single employee, (Ragel, 2011).