DATA WAREHOUSING, DATA MINING, OLAP AND OLTP TECHNOLOGIES ARE ESSENTIAL ELEMENTS TO SUPPORT DECISION-MAKING PROCESS IN INDUSTRIES
Journal Title: International Journal on Computer Science and Engineering - Year 2010, Vol 2, Issue 9
Abstract
This paper provides an overview of Data warehousing, Data Mining, OLAP, OLTP technologies, exploring the features, applications and the architecture of Data Warehousing. The data warehouse supports on-line analytical processing (OLAP), the functional and performance requirements of which are quite different from those of the on-line transaction processing (OLTP) applications traditionally supported by the operational databases. Data warehouses provide on-line analytical processing (OLAP) tools for the interactive analysis of ultidimensional data of varied granularities, which facilitates effective data mining. Data warehousing and on-line analytical processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. OLTP is customer-oriented and is used for transaction and query processing by clerks, clients and information echnology professionals. An OLAP system is market-oriented and is used for data analysis by knowledge workers, including managers, executives and analysts. Data warehousing and OLAP have emerged as leading technologies that facilitate data storage, organization and then, significant retrieval. Decision support places some rather different requirements on database technology compared to traditional on-line transaction processing applications.
Authors and Affiliations
G. SATYANARAYANA REDDY , RALLABANDI SRINIVASU , M. POORNA CHANDER RAO , SRIKANTH REDDY RIKKULA
Keywords
Related Articles
- EP ID EP145001
- DOI -
- Views 117
- Downloads 0
Design Of An Automatic Speaker Recognition System Using MFCC, Vector Quantization And LBG Algorithm
The results of a case study carried out while developing an automatic speaker recognition system are presented in this paper. The Vector Quantization (VQ) approach is used for mapping vectors from a large vector space to...
Solution for Vehicles Noise Cancellation With Modification of LMS Adaptive Algorithm
The problems of noise cancelling systems are based on the specific characteristics of their sources. Therefore, the knowledge of each noise source should be represented prior to the excecution of the designed noise cance...
Multi-agent Collaboration Engine for Supply Chain Management
To improve the performance of Supply chain decisions (SCM) , agents technology is slowly becoming the best alternative . In general , most of the components in SCM work in isolation and achieving coordination among SCM p...
A Channel Adaptive MAC Protocol with Traffic Aware Distributed Power Management in Wireless Sensor Networks
Wireless sensor networks are battery operated computing and sensing devices. The sensor nodes will be deployed in an ad hoc fashion with individual nodes remaining inactive for large periods of time but suddenly becoming...
The comparative cost analysis of EAP Re-authentication Protocol and EAP TLS Protocol
the Extensible Authentication Protocol (EAP) is a generic ramework supporting multiple types of authentication ethods. In systems where EAP is used for authentication, it is desirable to not repeat the entire EAP excha...