Page 130 - ASBIRES-2017_Preceedings

th
Proceedings of the 9 Symposium on Applied Science, Business & Industrial Research – 2017
ISSN 2279-1558, ISBN 978-955-7442-09-9

Increasing the Speed of Searching Process in Mysql Database for Dynamic
Data

Asiri DVLN, Arudchelvam T
Department of Computing and Information Systems, Wayamba University of Sri Lanka
Lukynuwan@gmail.com

ABSTRACT

TravelBox is a commercial software developed by a software company, for the
purpose of managing inventory related to travel and tour industry. It enables the large tour
operators to handle their products, bookings, suppliers and contracts in a dynamic
behaviour. This study examined the area of business intelligence capabilities of TravelBox
technology by enhancing the management and analysis of statistical data which gives
information on the bulk data transactions done through TravelBox servers.

KEYWORDS: Business intelligence, Data cubes, Dynamic storage, Efficiency, NOSQL
solutions, Search speed

1 INTRODUCTION system, there will be a minimum of 11GB of
data stored per week in the peak season and
In TravelBox technology, there are the database which is used by TravelBox to
many categories of statistical data used. store the statistical data, will exceed its
According to the user manuals and technical capacity within 3 weeks’ even if the
documentations, statistical data, transaction enterprise edition used. These figures are
data and result data are a few of them. These taken from the Support Engineers who
data can be used to analyze the performance monitor and analyze the databases.
of each operation, identify the bottlenecks,
identify the variations among search criteria Therefore, it is obvious that the current
and help decision making in business capacity of data storage which cannot store
intelligence environment. more than 3 weeks of data is not capable of
producing an effective statistical analysis or
When it comes to the business conclusion. To make a considerable analysis
requirement, the IT industry shows a future and business intelligence information, it is
of information analysis and business needed at least 1 to 3 years data.
intelligence to identify patterns and seasonal
variations in businesses. These are value This is a bottle neck for the analysis and
added services a business customer expects decision making process of the client. And it
from a software solution. The search and would be a competitive feature, if the data
transaction data are the most critical and can be filtered and sorted as it increases
valuable categories of statistical data. Search dynamically. The objective is to find a
actions give most of the end user feasible solution to store dynamically
experience. And the transactions data are increasing bulk of data and to enhance the
related to the data exchange with the Oracle performance of searching process in the
database which directly affects on the data.
performance of the software. TravelBox 2 LITERATURE REVIEW
endpoints are accessed by multiple numbers
of users at a time. Relational databases were introduced in
the 1970s and they were used as the
Therefore, transaction management is
important since the data should be available traditional databases that follow ACID
Consistency,
(Atomicity,
Isolation,
on time with the right relevance. In the Live Durability) nature and allow different
production environment of the current
applications to store data using standard data

120