Page 170 - DMGT505_MANAGEMENT_INFORMATION_SYSTEM

Unit 8: Databases and Data Warehouses

8.6 Summary Notes

 A database is a collection of data, which is organized in a way that allows for easy data
retrieval and manipulation.

 The file processing system relied on the piecemeal approach of data across the organization
where every functional unit like marketing, finance, production, etc. used to maintain
their own set of application programs and data files.
 Unlike a file processing system, data redundancy and data inconsistency in the database
system approach are minimized.
 A database model or database schema is the structure or format of a database, described in
a formal language supported by the database management system.

 A relational database contains multiple tables, each similar to the one in the “flat” database
model.
 The object-oriented paradigm has been applied to database technology, creating a new
programming model known as object databases.
 SQL is a simple and powerful query language that is capable of answering simple to most
complex queries.

 Data modelling is the analysis of data objects that are used in a business or other context
and the identification of the relationships among these data objects.

 A web database is a database for the internet. You can get access to your data via the
internet from anywhere in the world or you can create a database driven website by using
such databases.
 A data warehouse is a relational database management system (RDBMS) designed
specifically to meet the needs of transaction processing systems.

8.7 Keywords

Data Model: A conceptual framework that defines the logical relationships among the data
elements needed to support a basic business or other process.
Data Modeling: A process where the relationships between data elements are identified and
defined to develop data models.
Data Warehouse: An integrated collection of data extracted from operational, historical, and
external databases, and screened, edited, and standardized for retrieval and analysis to provide
business intelligence for managerial decision making.
Data: Facts or observations about physical phenomena or business transactions. More specifically,
data are objective measurements of the attributes (characteristics) of entities such as people,
places, things, and events.

Database Administrator: A specialist responsible for maintaining standards for the development
maintenance, and security of an organization's databases.
Database Management System (DBMS): A set of computer programs that controls the creation,
maintenance, and utilization of the databases of an organization.
Database: A collection of logically related records or files. A database consolidates many records
previously stored in separate files so that a common pool of data records serves many applications.

LOVELY PROFESSIONAL UNIVERSITY 165