PATRIOTISM • LEADERSHIP • SERVICE • PROFESSIONALISM

PAMANTASAN NG LUNGSOD NG SAN PABLO

COLLEGE OF BUSINESS ADMINISTRATION
BACHELOR OF SCIENCE IN BUSINESS ADMINISTRATION- FINANCIAL MANAGEMENT

DATA AND DATABASE

MANAGEMENT

A group report presented by BSBA 3C Group 4

MEMBERS:

Abacan, Vince Chester

Abril, Aljerald Laureus

Alcañeses, Rose Ann

Angeles, Donymie

Araguas, Karen

SUBMITTED TO:

Mr. Abraham Bringas

COLLEGE OF BUSINESS ADMINISTRATION

INTRODUCTION OF BUSINESS ANALYTICS
 PATRIOTISM • LEADERSHIP • SERVICE • PROFESSIONALISM
PAMANTASAN NG LUNGSOD NG SAN PABLO
COLLEGE OF BUSINESS ADMINISTRATION
BACHELOR OF SCIENCE IN BUSINESS ADMINISTRATION- FINANCIAL MANAGEMENT

The following topics were reported by our group on October 29, 2023.

1. Data, Information and Knowledge Management

2. Database and Database Management
3. Functions of a Database
4. Components of a Database
5. Data Governance in Business

TOPIC 1: DATA, INFORMATION AND KNOWLEDGE MANAGEMENT

Data Information

In common usage and statistics, data is a collection of discrete or continuous values

that convey information, describing the quantity, quality, fact, statistics, other basic units
of meaning, or simply sequences of symbols that may be further interpreted formally.

Knowledge Management

Knowledge management is the collection of methods relating to creating, sharing,

using and managing the knowledge and information of an organization. It refers to a
multidisciplinary approach to achieve organizational objectives by making the best use
of knowledge.

TOPIC 2: DATABASE AND DATABASE MANAGEMENT

COLLEGE OF BUSINESS ADMINISTRATION

INTRODUCTION OF BUSINESS ANALYTICS
 PATRIOTISM • LEADERSHIP • SERVICE • PROFESSIONALISM
PAMANTASAN NG LUNGSOD NG SAN PABLO
COLLEGE OF BUSINESS ADMINISTRATION
BACHELOR OF SCIENCE IN BUSINESS ADMINISTRATION- FINANCIAL MANAGEMENT

What is Database?

A database is an organized collection of data, stored and accessed electronically.

Databases are used to store and manage large amounts of structured and unstructured
data, and they can be used to support a wide range of activities, including data storage,
data analysis, and data management.

TYPES OF DATABASES

1. Relational Database - It is the most efficient way to access structured

information. The data is organized into a set of tables that has columns
and rows.
2. Cloud Database - This database runs on a Cloud Computing platform,
and access is provided ‘as a service.’
3. Centralization Database - CDB is located, stored, and maintained in a
single centralized location, for example, a mainframe computer, desktop,
or server CPU.

DATABASE ADVANTAGES AND DISADVANTAGES

There are several advantages to using database architecture:

° A database allows data to be organized in a structured and consistent manner, making

it easy to access and manipulate.

° It ensures the integrity of the data by enforcing rules on data input and storage, and by
tracking changes to the data.

° It provides security features to protect the data from unauthorized access or changes.

° It allows applications to be developed and maintained independently of the data,

making it easier to make changes to the data or the applications without affecting each
other.

COLLEGE OF BUSINESS ADMINISTRATION

INTRODUCTION OF BUSINESS ANALYTICS
 PATRIOTISM • LEADERSHIP • SERVICE • PROFESSIONALISM
PAMANTASAN NG LUNGSOD NG SAN PABLO
COLLEGE OF BUSINESS ADMINISTRATION
BACHELOR OF SCIENCE IN BUSINESS ADMINISTRATION- FINANCIAL MANAGEMENT

° It allows multiple users to access and update the data simultaneously, making it easier
to share information and collaborate.

There are also some disadvantages to using database architecture:

° Setting up and maintaining a database can be complex, requiring specialized skills

and resources.

° The purchase and maintenance of database software and hardware can be

expensive.

°Large databases can be resource-intensive, and the performance of the system may
suffer as the amount of data grows.

° A database may need to be redesigned or reconfigured as the amount of data grows

or the number of users increases, which can be a time-consuming and complex
process.

What Is a Database Management System?

A database management system (DBMS) is software that is used to create, manage,

and maintain a database.

Oracle Database Architecture

An Oracle database is a collection of data treated as a unit. The purpose of a

database is to store and retrieve related information. A database server is the key to
solving the problems of information management.

TOPIC 3: FUNCTIONS OF A DATABASE MANAGEMENT SYSTEM

COLLEGE OF BUSINESS ADMINISTRATION

INTRODUCTION OF BUSINESS ANALYTICS
 PATRIOTISM • LEADERSHIP • SERVICE • PROFESSIONALISM
PAMANTASAN NG LUNGSOD NG SAN PABLO
COLLEGE OF BUSINESS ADMINISTRATION
BACHELOR OF SCIENCE IN BUSINESS ADMINISTRATION- FINANCIAL MANAGEMENT

 Data Independence - maintains the segregation between the program and the
data.
 Concurrency Control - process to ensure the data is updated correctly and
appropriately.
 Recovery Services - refers to mechanism of recover of data.
 Utility Services - maintenance operation on a database.
 Manipulation of Data - it tells us that we can CRUD our data within DBMS.
 Database Definition - metadata describes the content of your database.
 Data Processing - allows user to perform different types of operations.
 Data sharing - means that within database privileges are provided to different
types of users.

TOPIC 4: COMPONENTS OF A DATABASE MANAGEMENT SYSTEM

Users

The users of a Database System are:

 Database Administrator - DBA is the person responsible for all the data
resources in an organization.
 System Developer - are those groups of people who create application
programs that cater to the user requirement.
 End user - uses application program to accomplish their day-to-day tasks.

Database Application

is a computer program that allows users to manipulate the data in a DBMS through a
user-friendly interface.

COLLEGE OF BUSINESS ADMINISTRATION

INTRODUCTION OF BUSINESS ANALYTICS
 PATRIOTISM • LEADERSHIP • SERVICE • PROFESSIONALISM
PAMANTASAN NG LUNGSOD NG SAN PABLO
COLLEGE OF BUSINESS ADMINISTRATION
BACHELOR OF SCIENCE IN BUSINESS ADMINISTRATION- FINANCIAL MANAGEMENT

(4) Four Broad Categories

1. Personal
2. Departmental
3. Enterprise
4. Internet

DBMS

The DBMS decouples application programs from data.

Database

Database is the space in the disk or computer where the data are actually stored.

COMPONENTS OF A DATABASE MANAGEMENT SYSTEM

1. Interface - The Interface is responsible for interacting with the user and also
called the “middlemen”.
2. Parser - The Parser is responsible for checking the correctness of the syntax
that was provided by the end user through the interface.
3. Query Optimizer - The Query Optimizer allows the DBMS to save time and save
space when performing operations.
4. Execution Engine - Its main responsibility is to execute the output of the query
optimizer.
5. Storage - It is the physical location of your database, which can be the
secondary or the primary memory.

TOPIC 5: DATA GOVERNANCE IN BUSINESS

COLLEGE OF BUSINESS ADMINISTRATION

INTRODUCTION OF BUSINESS ANALYTICS
 PATRIOTISM • LEADERSHIP • SERVICE • PROFESSIONALISM
PAMANTASAN NG LUNGSOD NG SAN PABLO
COLLEGE OF BUSINESS ADMINISTRATION
BACHELOR OF SCIENCE IN BUSINESS ADMINISTRATION- FINANCIAL MANAGEMENT

What is data governance in business?

Data governance is the process of managing the availability, usability, integrity and
security of the data in enterprise systems, based on internal data standards and policies
that also control data usage.

Goal of Data Governance

Its goal is to ensure that data is used properly, to avoid introducing data errors into
systems and to block potential misuse of personal data about customers and other
sensitive information.

Benefits of Data Governance

Its benefits provides:

 Improved data quality

 Lower data management costs
 Increased access to needed data for data scientists, other analysts and business
users.

Who's the part of the program on data governance?

Chief Data Officer: A Chief Data Officer or head of data management oversees data
governance programs at an executive level.

Data Owner: Data owners are in charge of collecting and defining data requirements for
specific areas of responsibility within an organization.

Data Steward: The data steward makes sure the established data management
standards and requirements set by data owners are being followed.

Data Architect: Data architects create data models and define how data is stored,
accessed, and integrated by IT systems based on the directions of data owners and
data stewards.

COLLEGE OF BUSINESS ADMINISTRATION

INTRODUCTION OF BUSINESS ANALYTICS
 PATRIOTISM • LEADERSHIP • SERVICE • PROFESSIONALISM
PAMANTASAN NG LUNGSOD NG SAN PABLO
COLLEGE OF BUSINESS ADMINISTRATION
BACHELOR OF SCIENCE IN BUSINESS ADMINISTRATION- FINANCIAL MANAGEMENT

Data Quality Manager: the data quality manager handles all the issues related to data
quality, such as quality metrics, methods, standards, and approaches.

Data Documentation Manager: The data documentation manager documents

everything about the data governance framework including data requirements,
standards, roles, and responsibilities.

COLLEGE OF BUSINESS ADMINISTRATION

INTRODUCTION OF BUSINESS ANALYTICS