Cluster, Non cluster and Full Text Indexing Techniques for Efficient Database
Journal Title: International Journal of Engineering Sciences & Research Technology - Year 30, Vol 2, Issue 4
Abstract
Data warehouse is the central management system having pool of datasets. The traditional data warehouse was designed in such a manner that it can efficiently manage transactional data which is highly dominated by numerical information where as in some data warehouse textual and non t The dataset which contains text data is accessed over the network on the daily basis and performance issue arises. The objective of this paper is to propose an indexing technique based on time complexity and index s complexity for data warehouse used in applications. The performance evaluation of three data warehouse queries is focused in this paper by comparing techniques used mostly with FULL TEXT indexing technique and to observe the results of variable size dataset with respect to time and space complexity
Authors and Affiliations
Nikhil Karande
Keywords
Related Articles
- EP ID EP95616
- DOI -
- Views 81
- Downloads 0
PERFORMANCE ANALYSIS OF VCR SYSTEM WITH VARYING THE DIAMETERS OF HELICAL CONDENSER COIL BY USING R-134A REFRIGERANT
Vapor compression machine is a refrigerator in which the heat removed from the cold by evaporation of the refrigerant is given a thermal potential so that it can gravitate to a natural sink by compressing the vapor prod...
Curriculum Design for Technical Institutions -An Expert System Approach
This paper presents the development of expert system to assist technical institutes, universities curriculum developers, experts to analysis the gap between competencies developed in student through existing curriculum...
Malicious Code Analysis using Metalanguage
Computer viruses are big threat to computer world; researchers doing work in this area have made various efforts in the direction of classification and detection methods of these viruses. Graph mining, system call...
BLOCK BASED IMAGE FORGERY DETECTION TECHNIQUES
Since the day o f an advent of the internet and the World Wide Web digital images started playing an important role in exchanging ideas and sharing the information. Today it’s hard to imagine the world of web without...
Vulnerable Security Aspects of Windows
With the advancement in technology we are having everything available on a single click. Instead of wasting a lot of time while standing in a queue for a task to be done now we just have to open our device and co...