• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

Card Range To Study



Play button


Play button




Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

19 Cards in this Set

  • Front
  • Back
What are database systems designed for?
Database systems are designed to associated data with enterprise applications (ERP, CRM, etc.)
What are the 3 main functions of databases?
What is a relational database?
A relational database is a structured collection of stored records so that a computer program (ERP, CRM, etc.) or person using a query language can consult it to answer questions.
What are the objectives of the DBMS? (Five answers)
1) Data independence: the application programs are protected from changes in the hardware, operating system, data storage devices, and so on.

2) Data sharing: all the applications use one copy of the database.

3) Security: only authorized individuals, terminals, and programs can perform specific functions.

4) Data integrity: hardware and software defects will not make the database inconsistent.

5) Ease of use: the view of data provided to the programmers and other users is clear, straightforward, and easy to use
What is an object oriented DBMS?
Able to store and retrieve drawings, images, audio and video, (not possible with relational databases)

-Stores the data and procedures that uses data as objects

-Stores more complex type of information
What is data quality like in databases?
-Corporate and government databases have unexpectedly poor levels of data quality.

-National consumer credit reporting databases have error rates of 20-35%.

-32% of the records in the FBI’s
Computerized Criminal History file are inaccurate, incomplete, or ambiguous.

-Gartner Group estimates that consumer data in corporate databases degrades at the rate of 2% a month.
What is DM?
Data mining is the process of finding correlations or patterns among databases
What does DM allow users to do?
Data mining allows users to analyze data from many different dimensions, categorize it, and summarize the relationships into useful information that typically is not obvious to the user.
What is DM doing to individual expertise and intuition?
DM is replacing individual expertise and intuition by objective, data-based decision making, made possible by a virtually inexhaustible supply of inexpensive information.
What are DM's most influential variables?
The most influential variables in a data mining model are typically behavior-based.
What are the five major elements of DM?
Extract transform, and load transaction data onto the data warehouse system.

Store and manage the data in a data warehouse.

Provide data access to business analysts and information technology professionals.

Analyze the data by application software.

Present the data in a useful format, such as a graph or table.
What is the most important step in successful BI?
The most important step in successful BI isn't about technology, it's about understanding the business
What is virtualization?
software designed to provide a layer of abstraction between computer hardware systems and the software running on them
What are advantages of virtualization?
Employing virtualization technology to consolidate underutilized servers in the data center yields both an immediate, one-time cost saving and potentially significant ongoing savings.

Reducing the numbers and types of servers

Utilization of existing, computing resources

Longer life for the data center

A smaller server footprint is a simpler datacenter to manage
What is SOA?
SOA uses components, constructed so that they can be easily linked with other software components
What is SaaS? What are advantages and disadvantages?
Software applications that are stored on a providers hardware and rented by the user company

Pay as used

Operating expense

Smaller infrastructure cost

Faster implementation

Issue with SaaS has been availability (< 99%)
What is a project? (project management)
Time frame for completion - start and finish date

Unique one-time event

Involvement of people

Limited set of resources

Sequencing of activities

ie CRM implementation
Projects Challenges & Sequence of Events
Estimating the unknown
Scope creep

Series of event:
Key Success Factors for PM
Agreement on Project Goal(s)
Team, customer, sponsor

Project Plan
Path, tasks, dates and responsibilities

Up, down and sideways

Control Scope
Balancing act of scope, time & resources

Management Support