Implementing and Solving Database Problems in Company A

Executive summary
The report has discussed that how Company A is able to implement and use
database. Also, it has been described that company is facing certain problems. It has
been analysed that current MS database system does not provide a good quality
data. Sometimes, duplicate records are contained in it. For example – many time
customer name and address are incorrect. Also, the data stored is not categorised
that makes it complicated to search and access info. Moreover, report has explained
that there are several solutions that can be followed. They are using cloud computing
CRM, semantic technique, application, indexing, etc. From all these cloud computing
CRM is best suitable. It has been described that cloud computing CRM benefit in
storing large data set. Furthermore, Cloud computing will be a cost efficient
technique for the Aldi as it gives a space for huge sum of data at very lower cost.
Cloud computing helps in providing a security to various data which are stores and to
be reflected. With the help of cloud computing it gives a change of watermarking
which can help in the evaluation of data and by creating a copy which will be visible
for users.
Database management is the most essential tool which helps the companies in
managing and handling data in systematic manner and also supports in improving data
retrieving. As companies are putting had efforts to raise sales and generating more
revenues hence there is need to maintain data of new consumers and exiting
consumers in significant manner, Use of data base management system allows
companies to store data and secure it for longer duration. This is the application that is
helpful in retrieving data and modify it in near future easily. Oracle, SQL etc. tools are
used for the same. NoSQL data base is the most essential application or software that
aids in expanding data set when there is insufficient capacity. There is need to give
proper training to employees for database management so that workers can keep
secure records and can manage it well. Semantic web system is helpful in addressing
duplication data issue in the firm. Cloud computing helps in raising data quality. By
using this method companies can save their important data in bulk. Data maintenance
is easy in cloud computing technique but it also has some disadvantage. But networks
create issues in data management hence sometimes cloud computing create problems
for business units. Cloud computing is the advance tool but still very limited storage
options are available in it. Security is another biggest concern in it as it increases risk
of data theft in such application hence sometimes companies have to think twice
before implementing this system at workplace.
Introduction
Technology has allowed organisation to install and use systems in an effective way.
It has enabled in storing large data set and keeping customer records. Besides,
database management system is used in managing records and segregating it. The
database has benefited in connecting entire system and communicating it. With
this, cost is been saved and information is easily been accessed. In addition, many
new techniques are applied to improve retrieving of data. However, semantic web is
a technology used by business. Through it, data stores are created on web.
The report will describe about problem which is faced by Company A and how that is
been solved by other organisation. Moreover, it will be discussed about solution that
can be implemented to solve that problem along with tools.
Business Overview

A database is a systematic management of raw data and info. It is a data structure
that stores large amount of info related to product, customer, employees, financial,
etc. A database management system is a software that store, retrieve, manage, etc.
data in database. The other function of database is it manipulate and validate data.
Also, data is updated, insert, edit, etc. in database. There are various types of
database which is used to store info. The use of database is accordingly to type of
data.
There are many techniques such as XML, sematic, metatag, etc. which is used in
database. The semantic is used to improve efficiency of database and its
processing. Also, it helps in understanding data.
In retail industry there are various types of products which is offered to customers.
Also, an organisation is having a large customer base. So, they have to maintain
huge records that include many things such as name, address, e mail id, etc.
Alongside, they also have to keep records of suppliers, daily transactions, etc.

Moreover, it is important to protect and secure data so that it is not accessed by third
parties (Maloney and Bracke, 2017). Furthermore, company have to maintain strong
relation with customers so that they are retained. With advancement in technology,
more advanced database systems are been used.
Recently, with growth in sales and expansion in new market, huge storage database
systems are required. This is because the current MS access database is not able to
hold large data records. In addition to it, as Aldi offers variety of products and
operate at global level so they have to maintain data in effective manner. The
organisation is also engaged in various marketing activities. Another thing is daily
transactions are stored as well in database. It has been analysed that current MS
database system does not provide a good quality data. Sometimes, duplicate
records are contained in it. For example – many time customer name and address
are incorrect. Also, the data stored is not categorised that makes it complicated to
search and access info. So, these all concern and problem are been faced by Aldi in
database.
Along with it, there is high increase in volume of data. Due to this, it is difficult for
company to maintain and store data. It has also led to making it complicated to
categorise and store it. So, complexity has increased as well. In retail industry
several issues are faced by other firms. They are also facing similar problem where
good quality data is not stored in MS database. Sometimes, duplicate data is stored
and accessed. Thus, it has resulted in open data and improper segregation. So, in
order to address this issue other organisations have taken certain steps. It has
enabled them to maintain good quality data.
It has been evaluated that first of all organisations have updated their entire IT
infrastructure. They have installed new software and database. It has allowed them
to store large data set. With this, the performance of database has improved
(Schilling and et.al., 2017). The data is effectively stored and accessed. besides this,
a centralised database is installed in it. It has made it easy to automatically update,
delete, etc. data records. So, the duplicated data is identified and deleted.
Henceforth, the processing to access data has increased as well. With high
performance data, records are stored in segregated way. However, a backup of data
is also taken that ensure its safety. So, in case of data loss the data is easily
retrieved.
For example – tesco is using cloud computing CRM, salesforce. With help of it,
they are easily able to store and access records. It is useful in improving
organisation information. The data is documented and recorded in effective way.
Furthermore, it
is quantified and info is accessed quickly. Also, the communication with customers is
improved. The software is also operated in mobile or any other device.
There are many complexities that is involved in implementing new database system.
Here, query is fixed so its size is small than database. Moreover, semantic web is
used for XML only.
Database
What is database

Database is used to collect data and information for computer and provides quick
research for it. The structure of the database facilitates the combination of various
data-processing operations to store, retrieve, modify, and delete data. A
database management system (DBMS) responds to queries to extract
information from the database. (Augustyn, 2018)
Why use new database
For our company, there are many problems of the old MS Access Database.
Therefore, a new database seems to be an essential solution for the company.
According to the data quality and data duplicity, for the new database, we select to
use DBMS to create, use and maintain our database.
Database Management System Model
DBMS is designed for the management of the database and computer
software system, generally with storage, interception, security, backup and
other basic functions. (Lemahieu, 2018)
The large databases users want to be able to quickly manipulate the information
within them. In addition, large enterprises have a tendency to use many separate
files including related or even overlying data, and their data-processing activities
frequently command linking data in various files. Several different types of DBMS
have been developed to support these requirements. DBMS can be classified by
many different conducts, and there are some types of DBMS differing by logical data
model. (Lemahieu, 2018)
First, as shown in Figure 1, hierarchical model denotes data in a tree structure,
where each record has a source. To preserve the order, there is a sort field that
retains the sibling nodes in record process. These types of models were mostly
designed for early mainframe database management systems. (Sam, 2018)
Figure 1 (Lemahieu, 2018)
Second, relational DBMS (RDBMS) is a program that uses relational database
model and currently the most popular in industry. Most RDBMS use the Structured
Query Language (SQL) language to visit the database and accumulate the data in
form of table. (Sumathi and Esakkirajan, 2010)

Third, object-oriented DBMS (OODBMS) based upon the object-oriented data
model which characterize data in the form of classes and object. There is no
impedance mismatch in combination with object-oriented host language and only
successful in niche markets, due to their complexity. (Ward, 2008)
Forth, object-relational DBMS (ORDBMS) also same as extended relational DBMS
(ERDBMS), and this database model choose a relational model protracted with
object-oriented schemas by using SQL. (Ward, 2008)
Fifth, XML DBMS is a data management system that supports operations such as
storing and querying XML format documents. In the system, developers can query,
export, and serialize specified formats of XML documents in the database. (Ward,
2008)
Finally, NoSQL DBMS targeted at storing big and unstructured data can be classified
into key-value stores, column-oriented databases and graph databases. Focus on
scalability and the ability to cope with irregular or highly volatile data structures. The
significance of NoSQL databases is to provide specific functions that SQL database
management systems do not have. (Lemahieu, 2018)
The Benefits and Drawbacks of New Database
When it comes to the benefit for using database in business, it can be the
fundamental and necessary method to manage the information of organisations.
Many companies use different databases to store and review customer, supplier or
business data when they needed. There are many benefits to using the most widely
used relational database. For instance, improving data sharing and data security
(Anthleman, 1999), effective data integration from disparate information and
reducing management data time (Antelman, 1999; Fitzgibbons and Meert, 2010; Niu
et al., 2015). Niu et al. (2015) noted that using database could enhance the quality
and consistency of data, a quick decision making, store useful and valuable data. It
can also analyse data in a variety of ways for organisation require (Anthleman, 1999;
Olson and Staley, 2012). These advantages create convenient operational
processes that provide organisations with better performance.
However, relational databases also carry possible risks. The most significant
problem is that the design of the DBMS is complex, difficult and time-consuming
(Anthleman,
1999). Although using database to help business is popular in small and medium
enterprises (Anthleman, 1999), the cost of introducing the system is prevented some
of them from implementing it (Olson and Staley, 2012). Even if the funding are
sufficient for the organisation to use it, a system that transfers from file-based to
database is a big undertaking (Fitzgibbons and Meert, 2010). In terms of personnel,
IT staff must have the necessary skills and adapt to the system's operating mode in
the shortest time to achieve business demand (Antelman, 1999; Fitzgibbons and
Meert, 2010), such as the initial training. Otherwise, it might bring unexpected
consequences for the business operations if performance of database cannot meet
the company require (Olson and Staley, 2012). Simultaneously, Han et al. (2011)
and Anthleman (1999) indicate that this Structure Query Language (SQL) database,
which often uses in Oracle, MySQL, SQL Service and Microsoft SQL, can also have
limited capacity, read and wrote slowly and difficult to expand. As it mentioned
before, the

complex of logic could reach impasses when the amount of information gradually
increases. It can then cause difficulty in writing and reading for the person who is
taking over.
NoSQL Database
Consequently, it appeared some new type of database to address those demands.
The mainly different on new and traditional databases is what language used to, so
they named them as “NoSQL”; it is also referred to “Not Only SQL” (Han et al.,
2011). Comparing to SQL database, NoSQL structure could bring an amount of
benefits:
 Suitable for horizontal expansion systems
 High reading and writing concurrently
 High storage and query efficiency
 Lower operation cost
Due to its flexible structure, it is easy to expand when the initial set capacity is
insufficient. Then, the average write speed is over forty percent faster than relational
databases (Schulz et al., 2016; Han et al., 2011). Schulz et al. (2016) identified that
the database of using NoSQL concept can increase six times on inset speed. In
addition, its high storage space and query efficiency cannot be denied. Han et al.
(2011) demonstrate the speed of query efficiency could take up to ten fold on access
speed on the data above 50 GB. Therefore, it might decrease the cost of business
operation(Han et al., 2011).
Nowadays, more and more companies are using databases to manage data in their
organisations (Schulz et al., 2016; Olson and Staley, 2012; Anthleman, 1999). New
databases concept, such as NoSQL, are great for processing unstructured data, for
example, text, images, audio or video, etc (Schulz et al., 2016; Han et al., 2011).
Because the system can expand horizontally, it can handle various data types and
compatible with different forms of information. Furthermore, when the organisation
needs to implement the database at the beginning, the data requirements are
unclear. In this situation, the database with NoSQL structure may become the first
choice. Similarly, its high storage and rapid reading and writing would make the
organisation more flexible. The most important thing is that it costs less to deploy the
system than relational databases, so that it can reduce the costs in the organisation.
With a little effort, the company can instantly expand multiple data centres with a
NoSQL database.
Critical Evaluation
For our business, the change of DBMS might bring the cost and technology issues.
 Cost of Hardware and Software
Due to using DBMS, it requires about high speed processors and large
memory capacity, because today, there is a lot of data in every field that
needs to be stored safely and securely. These demands for large amounts
of space and