Databases 1
Databases II
Data Warehouse
OLTP
BI
100
Definition of a database
What is a collection of related records. It can be very similar to spreadsheets but handle larger amounts of data
100
The software that manages the database. It is required for all databases to interface with the database file.
What is a DBMS (Database Management System) FYI: basic functionalities of a DBMS modeling language-to defne schema of each database Data structure-optimized to handle large amounts of data database query language-allow users to interrogate db transaction mechanism- to ensure data integrity
100
Definition of Data warehouse
What is a central repository for all data that an enterprise's business systems collect (to support decision making) FYI "information warehouse"
100
OLTP
What is Online Transactional Processing
100
Skills, technologies, applications and practices for better understanding of a business's commercial context
What is Business Intelligence
200
Definition of a Relational DBMS or RDBMS.
What is the software that links/relates the data in rows and columns from one table to the data in a different table.
200
The way that data is stored
What is in tables consisting of rows and columns
200
4 main characteristics of data warehouse
What is Subject Oriented- a concentrated subject to analyse Integrated- resolves data discrepancies from dif. sources Nonvolatile- does not change after in the warehouse Time Variant- focus on data with regards to change over time Acronym-SINT
200
4 Main Characteristics of OLTP (Online Transactional Processing)
What is: Operation Oriented-supports specific pre-defined operations Integrated-uses data from less rows & large tables Volatile-data is stored in short time frame Time Sensitive- up keep to date to reflect each transaction
200
Business intelligence technologies provides these type of views of a business
What is historical, current and predictive
300
Top DBMS makers
What is 1. Oracle 2. IBM 3. Microsoft 4. Sybase 5. Computer Associates
300
The 4th level generation database programming language used to interrogate and process data in a relational database.
What is SQL
300
A subset of a data warehouse for a single department or function and may hold tens of gigabytes of data rather than hundreds.
What is a data mart
300
Examples of typical OLTP applications
What are: air line reservation systems, large order-entry applications, banking application
300
Name 5/8 functions of BI technologies
What are reporting, OLAP, analytics, data mining, business performance management, benchmarking, text-mining, and predictive analytics?
400
DBMSs for large scaled enterprises
What are 1. SQL Server (Microsoft) 2. mySQL (open source) 3. Oracle
400
Definition of CRM and companies that make CRM
What is Customer Relationship Management- info system that is used to plan/schedule/control presales and postsales activities in an organization Who is Oracle (Siebel) and Sales Force Automation
400
Different types of applications for data warehouses.
What are data mining, web mining, and decision support systems (DSS)
400
The key goals of OLTP applications
What is 24/7 availability, speed, concurrency, and recoverability
400
Names of BI spreadsheets
What are Excel, Open Office
500
Definition and Companies that do ERP
What is Enterprise Resource Planning- info system that serves ALL departments within enterprise Who is Oracle (Peoplesoft) and SAP (BAAN)
500
Definition of MRP
What is Material Requirements Planning, an ifo system that determines what assemblies must be built and what materials is required by certain time (inventory and bill)
500
A string to find data warehouse experience.
What is ("data warehous*" OR datawarehous* OR etl OR "data mart*" OR datamart* OR "extract transform load") Note: to migrate data..... Data is extracted from operational databases Then validated cleansed TRANSFORMED aggregated Finally loaded into the data warehouse
500
Definition/role of OLTP
What is update the appropriate database records as soon as transaction is entered into the computer.
500
BI technologies used for OLAP and data mining
What are Microsoft Analysis Server, Hyperion, Cognos, Business Objects, SAP BI, Microstrategy, Oracle. FYI- Reporting & Query SW-Crystal Reports, Cogos, SSRS Business Perf. Management- EIS, DSS, business dashboards
M
e
n
u