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 68
- Downloads 0
Power Quality Improvement in PMBLDCM Drive using PFC SEPIC Converter for Air Conditioner
In this paper, an improved power quality converter employing Single Ended Primary Inductor (SEPIC) converter topology is used to feed a permanent magnet brushless DC motor (PMBLDCM) drive. Normally, the PMBLDCM drive h...
Simulation and Analysis of Fuzzy Logic based Unified Power Flow Controller connected to Transmission Line
The Unified Power Flow Controller (UPFC) is used to control the flow of power in the transmission systems by controlling the impedance, voltage magnitude and phase angle. The Unified Power Flow Controller (UPFC)...
A STUDY ON BRAIN–MACHINE INTERFACE (BMI)
A brain–machine interface (BMI), sometimes called a mind-machine interface (MMI), or sometimes called a direct neural interface (DNI), synthetic telepathy interface (STI) or a brain–machine interface (BMI), is a d...
EXCEEDING MATHEMATICS: AWARENESS IN MATHEMATICAL SYMBOLS AND ALGEBRAIC EXPRESSIONS OF FRESHMEN STUDENTS IN NAVAL STATE UNIVERSITY
This study assessed the awareness in mathematical symbols and algebraic expressions of freshmen students in Naval State University. Employing the descriptive-survey design, there were 150 respondents who answe...
Performance Comparison Wireless Sensor Network Security Protocols : LLSP and Tiny SEC
Security protocols play an important role in the deployment of sensor networks in various environments However, many existing security protocols developed for WSNs are vulnerable to attacks in hostile environments...