Deployment of workable DBMS solution for Hertfordshire Catering Limited (HCL) by comparing MS Access, MS Server and Oracle

DATABASE AND BUSINESS INTELLIGENCE
(Deployment of workable DBMS solution for Hertfordshire Catering Limited (HCL)
by comparing MS Access, MS Server and Oracle)
INTRODUCTION
Business intelligence systems can be understood to improve an enterprise decision, by
making tools for gaining storage of data, storing, accessing and analysing business data
evolved. Also, it is a combination of tools and systems involved in enterprise strategic
planning which aids in analysis for larger working efficacy on extended periods within
structural innovation scenarios. HCL in the last 8 years has been a customer driven
organization, delivering innovative solutions to the challenges of fast-growing market space.
The company aims to utilize the best quality catering services towards a wide range of
market-oriented services to further cater for the exponential rise in fast developing markets.
Based on the number of years in operation, the company is known to utilize fresh and high-
quality ingredients to sell fresh and local seasonal foods to schools and colleges as well as
offering a wide range of quality catering services to academics. The telesales operations and
online sales system have a varied range of customer complaints, where customer
experiences further enable to innovate faster actively.
Overview of the company and its aim
HCL as one of the most productively expanding company aims to further keep track of
employee details including details regarding customers, in terms of standard promotional
aspects and to further enhance stronger quality growth. Online sales system, further aims to
deliver stringent innovation, and faster pace among extensive business goals for competent
scope within longer oriented systems which further raises goodwill (Tricoche, 2020). HCL
aims to adopt new database management systems to scale up the telesales operations by
capturing customers orders as well as complaints. Software investment plays a strong role in
strengthened working vision in achieving a huge rise on extended paradigms informatively.
For this aspect, it can be analysed that HCL values extractable intelligence from DBMS
which enhances abilities to further innovate more competitively, for regaining scope towards
extensive scale domains. Within a recent period, businesses among companies are evolving
to develop a critical rise for high quality catering services within innovative business goals
competitively (Sharma, 2017). An in-depth comparison of MS access, SQL servers and Oracle
further will enable the company to develop a stronger working base diversely within
software parameters for achieving a stronger range of operations. HCL business aims to
develop potential scale expansion where extractable intelligence from DBMS enhances
working competencies to be further advanced for new scale informative growth. By adopting
new software, the company further will be able to evolve on extensive commercial growth in
terms of innovation business avenues extensively for a leveraged rise within business
extended goals competently (Syamsiana, Setiawan and Saputra, 2020).
Intelligence database
The intelligence database plays a crucial role in employing artificial intelligence,
interacting with users to ensure huge returned items in most relevant aspects within
working innovation parameters. HCL by using intelligence will be able to further intricate
flexible options and conduct major queries practically on wider horizons for competent
innovation variedly. The business of HCL aims to derive the best flexible approach in terms
of technology functional growth for determining the best vision-oriented paradigms and
developing fundamental expansion within technology (Van Aken and et.al, 2017).
The dilemma of deploying the best software solution gave rise to significant in-depth
comparative analysis on MS Access, SQL Server and Oracle which are some of the most
significant database systems used by companies operating in similar business spaces to

ideally form competent innovation. HCL aims to derive the best technology, best vision
formative scope for hindering expertise rapidly on new paradigms for technical profits rise.
There has to be also scaled uprise on varied technical business quest evolved, for
systematic database management aspects for expertise enhancement.
As the company has been witnessing a huge volume increase in consumer complaints,
where usage of the best database management system plays a crucial role for innovative
faster reach. HCL needs to expand the best database system to develop expertise in
handling customer experiences and innovate faster for large-scale profits, which pools up
innovation working reach competitively on the extensive scope. As the company has been
witnessing huge issues in keeping records of all systems, there is a deliberate need to adopt
the best systematic working, user-friendly, scalable, efficient and cost-effective DBMS.
Usage and investment in the best database system, will enable the business to diversify
scope and further generate higher functional working evolved for digital advancement (Raza
and et.al, 2018).
Features of MS access :
Features of Oracle:
MS access is small database
system, which allows to
further create small medium-
sized database minimum
security features extensively
on working grounds for
securing optimum rise on
features significantly. Oracle
on the other hand as
compared with MS access,
can be integrated with
advanced NT security
parameters which gets data
authentically worked on for
larger scale functional growth
efficacy.
Oracle adoption on other
hand determines massive
multi users, to deliver higher
scale quality reach among
operations for company to
optimize new functional
working parameters
innovatively. As HCL aims to
develop value from most
advanced demonstrated
extractable intelligence, for
higher quality business goals
and achievement to develop
potential growth expertise
rapidly.
Features of SQL: SQL server
is lot easier to work with as
compared with MS access
and needs to be dedicated
further advanced on by using
DBA administer which
further enables business goals
to be fragmented up
informatively on structured.
HCL has significant benefits
for adopting SQL, as
compared with MS access
which shapes quest rise
dynamically on piratical
business targets for extended
scope.
However, on
comparison with Oracle,it
holds advanced reach and
technology oriented scope to
be functionally evolved on
new working grounds rapidly.
It aims to further deliver new
predictable and well
documented aspects within
business model scenarios
productively on structured
horizons.
Pros: MS's access is
particularly scaleable, where
multiple users are there and
Pros: It reduces performance
outages, where resolving
problem efficiency is there
Pros: The SQL server is easy
to install, enhanced
performance is there and

significant rise evolving
among multiple users which
further forms advanced scale
adopted for extensive growth
(Zhang and et.al, 2018).
Cons: It lacks efficiency to
be adopted with changing
parameters of time among
company business goals,
which exponentially plays
crucial role for strengthened
vision significantly on larger
performance goals. Access
does not provide good
prototyping tool in
development and deployment
of tools for faster platforms
traducement, which lowers
productive innovation
strategically for new
paradigms potentially. It also
lacks scalable business
objectives for new services to
be delivered and providing
commitment on rolling
features for extended
platform growth.
within business grounds,
where stability is there for
effective rise on extended
competitive grounds rapidly
for new performance goals
innovatively.
Cons: Oracle database is
ported to varied platforms
reach for competition to be
segmented into deliverables
with changing pace among
business performance goals
exponentially.
several SQL editions are
there which gives excellent
data restoration aspect
worked on for management
(Nidzwetzki and Güting,
2017). It can be analysed that
there is lower cost of
ownership, for business to
further evolve by
implementing SQL software
and derives competent
innovation as compared to
MS access within company
working scenario.
Cons: SQL lacks innovation
further pace significantly on
wider horizons as compared
with oracle for competitive
business growth rapidly.
Scalability : MS access lacks
scalability within business
operations, as with changing
varied new goals company
need to develop proper
advanced technologies
rapidly on untapped grounds.
Scalability : Oracle is scaled
up for strengthening
improved advancement
Scalability : It can be also
analysed that there has been
significant growth organized
with implementation of
Oracle which shapes
competitive business to be
evolved. It is easy to be
adopted significantly on
extended functional growth
targets, which shapes scope
for leveraged rise grounds
diversely.
Migration: Easy for
company to adopt, but lacks
efficiency to be adopted in
longer time run.
Migration: Costly for
company to adopt and
develop new scale business
strategies significantly. It
gracefully brings change in
system configuration and
demand, where additional
Migration: There has been
scope evolved, to yield on
innovation for expertise
business growth within data
business management goals
for larger profitability