Introduction
Data : Computer data is information processed or stored by a computer.
This information may be in the form of text documents, images, audio
clips, software programs, or other types of data. Computer data may be
processed by the computer's CPU and is stored in files and folders on
the computer's hard disk.
Computer data is a bunch of ones and zeros, known as binary data.
Because all computer data is in binary format, it can be created,
processed, saved, and stored digitally. This allows data to be transferred
from one computer to another using a network connection or various
media devices.
Database : A database is a collection of information that is organized so
that it can be easily accessed, managed and updated. Computer
databases typically contain aggregations of data records or files,
containing information about sales transactions or interactions with
specific customers.
In a relational database, digital information about a specific customer is
organized into rows, columns and tables which are indexed to make it
easier to find relevant information through SQL or NoSQL queries.
Data ware House : A Data Warehousing (DW) is process for collecting and
managing data from varied sources to provide meaningful business
insights. A Data warehouse is typically used to connect and analyze
business data from heterogeneous sources. The data warehouse is the core
of the BI system which is built for data analysis and reporting.
It is a blend of technologies and components which aids the strategic use
of data. It is electronic storage of a large amount of information by a
business which is designed for query and analysis instead of transaction
processing. It is a process of transforming data into information and
making it available to users in a timely manner to make a difference.
How Datawarehouse works?
A Data Warehouse works as a central repository where information
arrives from one or more data sources. Data flows into a data
warehouse from the transactional system and other relational
databases.
Data may be:
Structured: Structured data is data whose elements are addressable for effective analysis. It
has been organized into a formatted repository that is typically a database. It concerns all
data which can be stored in database SQL in a table with rows and columns. They have
relational keys and can easily be mapped into pre-designed fields. Today, those data are most
processed in the development and simplest way to manage information. Example: Relational
data.
Semi-structured: Semi-structured data is information that does not reside in a relational
database but that has some organizational properties that make it easier to analyze. With
some processes, you can store them in the relation database (it could be very hard for some
kind of semi-structured data), but Semi-structured exist to ease space. Example: XML data.
Unstructured data: Unstructured data is a data which is not organized in a predefined
manner or does not have a predefined data model, thus it is not a good fit for a mainstream
relational database. So for Unstructured data, there are alternative platforms for storing and
managing, it is increasingly prevalent in IT systems and is used by organizations in a variety of
business intelligence and analytics applications. Example: Word, PDF, Text, Media logs.
The data is processed, transformed, and ingested so that users can access
the processed data in the Data Warehouse through Business Intelligence
tools, SQL clients, and spreadsheets. A data warehouse merges
information coming from different sources into one comprehensive
database.
By merging all of this information in one place, an organization can
analyze its customers more holistically. This helps to ensure that it has
considered all the information available. Data warehousing makes data
mining possible. Data mining is looking for patterns in the data that may
lead to higher sales and profits.
Data Mining
Data mining is a process of extracting and discovering patterns in large
data sets involving methods at the intersection of machine learning,
statistics, and database systems.
KDD (Knowledge Discovery from
Data)
1. Data Cleaning − Basically in this step, the noise and inconsistent data are removed.
2. Data Integration − Generally, in this step, multiple data sources are combined.
3. Data Selection − Basically, in this step, data relevant to the analysis task are retrieved from the database.
4. Data Transformation −In this step, data is transformed into forms appropriate for mining. Also, by performing
summary or aggregation operations.
5. Data Mining − Generally, In this, intelligent methods are applied in order to extract data patterns.
6. Pattern Evaluation − Basically in this step, data patterns are evaluated.
7. Knowledge Presentation − Generally, in this step, knowledge is represented
Research In Computing
Research: Search for Knowledge
Research is an objective and systemic search for relevant information
on a particular subject or topic.
It aims at finding answer to question by implementing scientific
procedure.
Computing: It is the process of using computer technology to complete
given goal oriented task.