Database

Cards (19)

  • Data
    Raw bits and pieces of information
  • Types of data
    • Quantitative - numeric
    • Qualitative - descriptive
  • Data
    Raw facts or figures<|>Has no context
  • Data + Context
    Information
  • Information
    • Mark's blood pressure readings
  • Information
    Data given context and more specific
  • Information + Rules
    Knowledge
  • Knowledge
    Developed when information has been aggregated and analyzed to make decisions, set policies, and spark innovation
  • Database
    An organized collection of structured information, or data, typically stored electronically in a computer system
  • Database
    • One set of software program provides access of data to all the users
  • Primary Key
    A field(s) that is unique to each record and will not change
  • Foreign Key
    A field that links two tables together
  • Database Design
    1. Understand the goal
    2. Identify the data needed
    3. Identify how the data is related
    4. Identify tables and fields
    5. Each table needs a primary key
    6. Normalization is performed to eliminate duplicated data
  • Data Types
    • int - whole numbers
    • long - bigger range of whole numbers
    • float - floating-point numbers
    • double - double precision floating-point numbers
    • string - sequence of characters
    • char - single character
    • bool - True or False
  • Database Management System (DBMS)
    An application that allows data to be entered, modified, deleted, read, and reported<|>Has a user friendly interface to design the database
  • Databases
    • Relational databases use Microsoft Access installed on one machine with one user access at a time
    • Enterprise Databases serve the entire organization
  • Data Warehouse
    Consists of extracts from one or more of the organization's databases<|>Allows the data to be copied and stored for analysis<|>Needs to be refreshed as the data changes<|>Data is time-stamped when extracted<|>Allows comparisons between different time periods<|>Data is standardized<|>All similar fields are structured the same<|>Date is MM/DD/YYYY
  • Data warehouse is a single source of data truth
  • Data Warehouse Components
    • Collect
    • Store
    • Consume
    • Analyze
    • Raw Data
    • Summary Data
    • Meta Data
    • Integrated
    • Time Variant
    • Non Volatile
    • Subject Oriented