Data Warehousing and Data Mining

Data Warehousing and Data Mining

Data Warehouse

Data warehousing is the process that facilitates the development and operation of a data warehouse. It usually consists of a large collection of information that is gathered from multiples systems and scattered sources, whose activities are focused of the decision making process (Thusoo et.al, 2010). Once assembled systems data sources are stored for a long time, allowing access to historical data and data stores, which provides the user with a single consolidated interface to the data this makes it easier for the user as they could to write queries for decision making.

Benefits of Data Warehousing

It possesses the capability of working together with other databases.

It is capable of running predefined complex queries.

It allows the integration of heterogeneous databases

It possesses the capability of analyzing a particular problem in terms of dimensions.

It facilitates the operations of the application decisions support system.

Current Trends in Warehouse

Making Room for OPEX and CAPEX

During the past 10 years, the total cost of storage has increased by approximately 7% per year, in contrast to the growth of storage capacity, which has grown from 30 to 40%. The increase was due primarily to operating costs (OPEX), while hardware costs (CAPEX) have remained relatively unchanged. Disk technologies have had a great career with an increase in recording density doubles every 18 or 24 months, making drive prices eroded 30% per year. The containment hardware prices also boosted by the introduction of storage area networks (SAN), which eliminated silos attachments and helped to make better use of hardware through consolidation, but adding another level of complexity to the management and operational costs. As more applications and share data more and larger storage frames, it becomes more difficult to schedule and run backups, maintenance and migration to Windows (Ponniah, 2011).

Consolidation of Convergence

In order to obtain greater savings, attention will focus on the convergence of servers, storage platforms, networks and applications. Also highlight the Application Programming Interfaces (API) that can make the servers more efficient. Orchestration software will help to converge the management and automate provisioning through local servers, remote and cloud-based and network infrastructures.

Big Data

One of the great concepts for the year 2012 will be the "Big Data". The explosion of unstructured data and mobile applications will generate a huge opportunity for value creation in business, because if these data can be managed and accessed efficiently will become a competitive advantage and support when making decisions. The enormous growth of data will make it impossible to replicate or perform a backup by traditional means.

Secure Use of Cell Phones

The fashion of Bring Your Own Device (BYOD, use your own device) in the company will charge more momentum in 2013; however IT departments will have a new challenge to manage the security of these devices. One of the solutions that we will begin to see is the emergence of secure platforms for the exchange of data, which minimize the threat in mobile device security and further increase the productivity ...