DatabaseManagement

Database management is an administrative process for organizing and maintaining the data to meet the needs of the lifecycle in business.
It involves determine requirement, identify the risks factors and decide the final approach to requirement.
p r o c e s s   f l o w
Database management comprises the following flows of the process:

Process Flow

start
1

Data Source

A successful business operational view gathered information from various source available from data warehouse like ERP, CRM, operational system, SQL and Flat Files, Spreadsheets.
Oprational system
ERP
CRM
SQL
Flat Files,Spreadsheets
2

Data Flow

The gathered data from various sources should check for correction and transform the data into the accurate model through sorting and coding. Finally, load the data into the warehouse.

A data mart is one of the subsets of a data warehouse that provides end-user report.

DataWarehouse

DataValidation
DataCleaning
DataTransforming
DataAggregating
DataLoading
ETL
(Extract,Transform, Load)
3

BI Result

Business intelligence delivers the information from the data warehouse for taking appropriate decision in the normal business lifecycle. It involves three process namely static reports which show already exist data, Dynamic reports shows interactive information and data mining refers to statistical analyses for a pattern of interest.

Conclusion on database management:
Database management involves managing a data through a systematic way of a process that comprises of creating, maintaining, updating, and managing data through the software system.

Database Management

Database management is an administrative process for organizing and maintaining the data to meet the needs of the lifecycle in business. It involves determine requirement, identify the risks factors and decide the final approach to requirement.

Process Flow

Database management comprises the following flows of the process:
1

Data Source

A successful business operational view gathered information from various source available from data warehouse like ERP, CRM, operational system, SQL and Flat Files, Spreadsheets.

Oprational system

ERP

CRM

SQL

Flat Files,Spreadsheets

2

Data Flow

The gathered data from various sources should check for correction and transform the data
into the accurate model through sorting and coding. Finally, load the data into the warehouse.

A data mart is one of the subsets of a data warehouse that provides end-user report.

Data Warehouse

Data Validation
Data Cleaning
Data Transforming
Data Aggregating
Data Loading
ETL
(Extract,Transform, Load)
3
BI Result

Business intelligence delivers the information from the data warehouse for taking appropriate
decision in the normal business lifecycle. It involves three process namely static reports which
show already exist data, Dynamic reports shows interactive information and data mining refers
to statistical analyses for a pattern of interest.

Database Management
Bi Results
Olap Analysis
Data Mining
Data Visualization
Reports
Dashboards
Alerts
Conclusion on database management:
Database management involves managing a data through a systematic way of a process that comprises of creating, maintaining, updating, and managing data through the software system.
Close
Inquire
Let’s make something awesome together!
Drop us a line, or give us a heads up if you’re interested in visiting us.
  • Accepted file types: docx, xlsx, ppt, pdf, jpg, gif, png.
  • 11 + 4 =
  • This field is for validation purposes and should be left unchanged.
100% secure and private