DBMS

avatar
Created by
Lovely Faith

Cards (11)

  • DATABASE
    storage of data; organized collection of data from a computer sysrem
  • DATA
    a facts or information
  • STRUCTURED DATA
    typically tabular with rows and column that clearly define the data attributes
  • UNSTRUCTURED DATA
    are not stored in a structured database format
  • METADATA
    describe the other data it helps to sort and identify the attributes of the information it describes
  • DIFFERENT BETWEEN DATA AND INFORMATION
    information is the result of analyzing and interpreting pieces of data
  • DATABASE MANAGEMENT SYSTEM (DBMS)
    serves as an central/interface between and end-user and a database, allowing users to create, read, update, and delete data in the database
  • 4 ELEMENTS OF THE DATABASE APPROACH
    1. DATA MODELS - represents information in a systematic way using relational, hierarchical and network models
    2. DATABASES APPLICATION - application program used
    3. USE OF INTERNET TECHNOLOGY - network and telecommunications
    4. RELATIONAL DATABASE - type of database that organizes data into tables with rows and columns, where each row represents a record and each column represents a specific attribute.
  • 2 TYPES OF DATA MODELS
    1. ENTERPRISE DATA MODEL - provides a comprehensive view of an organization's data assets
    2. PROJECT DATA MODEL - is a specific representations of data tailored for a particular project's needs.
  • COMPONENTS OF DATABASE ENVIRONMENT
    1. CASE TOOL - automated tool used to design
    2. REPOSITY - centralized storehouse of metadata, just like central data relationship
    3. APPLICATION PROGRAMS - software using data, for maintain data for the users
    4. USER INTERFACE - text and graphical displays to users
    5. DATA/DATA ADMINISTRATOR - personnel responsible for maintaining the database
    6. SYSTEM DEVELOPERS - personnel responsible for designing database and software
    7. END USER - people wo use the applications and databases
  • RANGE OF DATABASE APPLICATIONS
    1. PERSONAL - 1 user; megabytes
    2. WORKGROUP - 5-25 users; server; megabytes-gigabytes
    3. DEPARTMENT/DIVISIONAL - 20-100; server; gigabytes
    4. ENTERPRISE - >100; client-server; gigabytes-terabytes
    5. WEB-ENABLED - >1000; web and applications servers; megabytes-gigabytes
    6. ENTERPRISE RESOURCE PLANNING - integrates all enterprise functions like manufacturing, finance, sales, etc.
    7. DATA WAREHOUSE - integrates decision support system derive from various operational databases