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?
|
Create
Modify Retrieve |
|
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
|
Challenging:
Constraints Estimating the unknown People Scope creep Series of event: Definition Agreement Planning Execution |
|
Key Success Factors for PM
|
Agreement on Project Goal(s)
Team, customer, sponsor Project Plan Path, tasks, dates and responsibilities Communications Up, down and sideways Control Scope Balancing act of scope, time & resources Management Support |