Databases and Data Warehouses Flashcards
what is a database
- defined as an organized electronic collection of data
- based on info needs of an organization
data in database is organized to be…
-easily accessed, managed, and updated
what do databases do
- consolidate multiple copies of operational data into one integrated, central location
- creates one official version of “operational memory”
benefits of databases
-establishes logical views of operational data which is independent of physical platform
-minimizes duplication
-unlimited capacity to store
-promote data accuracy
-improved security
-retrieve info quickly
-enables data integration across the organization
-
what does OLTP stand for
-Online Transaction Processing
what is OLTP
a category of data processing that is focused on transaction orientated tasks
what does OLTP involve
inserting, updating, or deleating small amounts of info in a database
-mainly deals with large numbers of transactions by a large number of users
what does OLAP stand for
-ONline Analytical Processing
what does OALP do
-involves querying many records in a database for analytical purposes
-extract data from different points of view
-data is not changed, only interpreted to get answers to business questions
`
what does DBMS stand for
database management systems
what does DBMS do
an application that enables the creation and administration of databases
what is a data warehouse
- a system used for reporting and data analysis
- core component of business intelligence
- data stored in the warehouse is uploaded from the operational system
