University Report: Fibre Fashion Database Modification and Analysis

This report addresses the database modification needs of Fibre Fashion, an Australian wholesale fashion company. The study begins with an introduction to Fibre Fashion's business and its current use of an end-user database and spreadsheet system for client and sales data. Research questions are identified to guide the investigation into improving the existing information system (IS). A literature review explores relational databases, SQL queries, and the benefits of database systems, alongside the emerging NoSQL database systems. The analysis section evaluates the strengths and weaknesses of different database systems. The report then recommends solutions to address the issues of data redundancy, data sharing, and data integrity, offering insights into how a new database system can assist the business. The report concludes with a discussion of the importance of data management in the fashion industry and the role of database systems in supporting business operations.

Running head: DATABASE MODIFICATION IN FIBRE FASHION
Database Modification in Fibre Fashion
Name of the Student
Name of the University

1DATABASE MODIFICATION IN FIBRE FASHION
Table of Contents
Introduction:....................................................................................................................................2
Research Questions:.........................................................................................................................2
Literature Review:...........................................................................................................................3
Analysis of Literature:.....................................................................................................................7
Conclusion:......................................................................................................................................9
Recommended Solution:................................................................................................................10
References:....................................................................................................................................12

2DATABASE MODIFICATION IN FIBRE FASHION
Introduction:
The following report deals with Fiber fashion which is an Australia based company. At
present, the firm makes use of end user-user database. Fiber come up with consistent presence in
the wholesale fashion industry for around 20 years. Similar to design, Fiber focus on humble
beginning by making use of classical lines (Chan, Ngai & Moon, 2017). The organization has a
fledgling business which has developed and flourish with colour. The organization has fabulous
labels which are considered as the masterpiece of wardrobe. Fiber aims to accessories which can
complement the inner look of the city warehouse. It comes up knowledgeable staff and
homemade treats like the icon (Pedersen, Gwozdz & Hvass, 2018). The report deals with the
design of a database system which can be used by fiber fashion in order to assist their business.
The new database system at Fiber Fashion can provide a list of benefits like reduces data
redundancy, data sharing, data integrity and complete privacy of data.
In the coming pages of report, an idea has been provided regarding current issue due to
use of end-user database. The organization has makes use of spreadsheet for keeping all the
details of the client and sale obtained on each brand. Fiber aims to represent a list of brand on
global platform. The report provides a background to solve the issues of the plan. A list of
research questions has been identified for the given topic. A proper analysis has been done
regarding current issues. A list of solution has been recommended that how this new database
system will help in assisting the business.
Research Questions:

3DATABASE MODIFICATION IN FIBRE FASHION
The primary objective of the research study is to find ways of improving the current IS
and database system. The research study will intensively focus on identifying various possible
solutions for database requirement as well as showing the features of each solution.
i. How current database is failing to meet the need of organizational processes?
ii. What are the existing database system that can support Fibre Fashion?
iii. What are the features and capacity of relational database?
iv. Is NoSQL database preferable in current scenario?
v. What are database management best practices in online retail shops?
vi. What are the technologies that can provide rich interface for chosen databases?
Literature Review:
According to Todeschini et al., (2017), relational database system is the most common
kind of database where all data is stored in the table. Database used in fashion industry are
known to be relational database. Relational database come up with clout needed for handling
multitudes for data and complex queries. The flat file takes up both space and memory and is
very much less efficient. Data are merely stored in lot of table or even in relation. The table is
divided into both the ways that is rows and columns (Lee, Seifert & Cherrier, 2017). SQL query
is the process which help in getting access to data. SQL stand for structure query language. SQL
query is very much helpful in creating, deleting and modification of table. Relational database
aims to provide huge number of benefits like manageability, flexibility and avoiding errors. The
point should be noted that relational databases are very easy to manipulate. Each of the data table
can be updated without any kind of disruption of others. Most of the RBDMS makes use of SQL
for getting access to data found in the tables (Sudha & Sheena, 2017). SQLite stand out to be a

4DATABASE MODIFICATION IN FIBRE FASHION
relational database management. SQL syntax stand out to be slight different based on the usage
of RDBMS for its usage. MySQL stand out one popular source of SQL database. It is merely
used for application development. One of the biggest plus point of MySQL is that inexpensive
nature and easy to use behavior.
As per (), the whole world of data is changing at a rapid rate which has ultimately created
a new dimension needed for overall growth and challenges for the organization in fashion
industry. It merely focus on complete recording, updating, and tracking of data in efficient and
regular way. Most of the organization in fashion industry can easily address challenges and
provide potential help in this sector (Yang, Song & Tong, 2017). Complete collection and
updating of data aim to have information which will help in achieving the desired goal in a
proper way. The activities are conducted for data which includes complete creation of account
reports. In addition, it helps in estimation of sales along with creating invoice for different
customers. The data is made available to both management and employees of the organization by
making use of computerized database system. The point should be noted that database system
stand out to be important link in creating and managing data (Van Aken et al., 2017). All the
latest database management system are completely based on programming languages known as
structured programming language. The language is found to be useful for list of functions like
access, update and deleting of data. Database system comprises of programs which are
completely included in Microsoft SQL server which helps the programs to get access to data by
making use of SQL queries.
As stated by Arulraj & Pavlo, (2017), one of the vital aspect in relational database
management is that system program which helps various kind of data table related to one
another. Database come up with information regarding the data of employee regarding product

5DATABASE MODIFICATION IN FIBRE FASHION
and sale in a table. The second table comprises of information regarding the employee sales data.
The database stand out to be very much perfect for managing relationship in much systematic
and simple way (Zhang et al., 2018). The system helps in managing manager so that they can
understand different aspects like statistics. Productive database system help most of the brand
managers not just to enter new details but also help in updating the present details. In addition, it
also helps in deleting the information which is not required anymore. The person who can enter
transaction details in relational management system comprises of different details like name of
person, product sold by user (Jochim, 2017). Relational database system aims to record and
update information which will help organization in fashion Industry to track and sell different
products.
As given by Pavlo et al., (2017) relational database management system also helps the
brand manager to keep a track, maintain and build data in the upcoming years. There is a list of
tables in relational database which help the brand manager to go through the whole system for a
particular details. Organization manager can find information which they require by making use
of particular criteria (Lu et al., 2019). It also help the customers to search for any feature which
they require like price, brand and colour. Complete storing information stand out to be
predictable and in sequence format. This also helps the user to find all the required information
which they need with ease. By making use of all the available information, organization in
fashion industry can invest in the database management system. This stand out to be very much
important for different brand of different sector and even groups. Most of the organization and
brands in fashion industry aims to run database system. The store house of this organization can
help the brand to easily store different kind of information (Chan, Ngai & Moon, 2017). All the
required information are made available at a just single. The point should be noted that database

6DATABASE MODIFICATION IN FIBRE FASHION
management system will help the brands within this industry to keep a track of business in fast
and effective way. Database management system in fashion industry will make use of different
kind of management system. The point should be noted that database system will help the system
application to easily interact with different user and application (Pedersen, Gwozdz & Hvass,
2018). DBMS is merely designed which helps the individual to definition, creation, update,
querying and other kind of administrative function in database. Apparel search is known to be
fashion industry database which collect sites and even display the information related to industry
subject.
Here, the authors Meier and Kaufmann (2019), has elaborated the NoSQL database.
According to their discussion, “NoSQL Databases” term can be considered as emerging general
expression for some specific type of databases that are having the aim of not using the
functionalities of a SQL database. The NoSQL database systems should be non-relational, open-
source, distributed and horizontally scalable. This is due to the fact that NoSQL archives the
state. Here, the author has clarified all of the terms associated with the definition of the NoSQL
database. As per the authors, No-relational defines that the database is not depending on the
model of relational database. Thus, this type of database will not have any type of relation tables.
It means that this database is working on a completely different principle. The term distributed
defines that the existing data are stored and managed through different type of machines and due
to this reason data replication can exist in the database. Open source defines that everyone has
the access of taking a look of the source code and they have also the access for changing the
code and compiling it for themselves. Lastly, the horizontally scalable term defines that as more
database servers will be added, more performance will be achieved in a nearly linear way. This
phenomenon is also known as the out scaling. The SQL databases do not have the capability of

7DATABASE MODIFICATION IN FIBRE FASHION
scaling horizontally in a natural way due to the reason of latter is not a core business of the
relational database systems.
In this case, the authors Kunda and Phiri (2017) has performed a comparative study
between the NoSQL database and the Relational Database. The authors have defined that both
the databases are competing type of database models. As per the author, one of the key
differences between the relational database and NoSQL database is that relational database
systems are structured while the NoSQL database system are distributed in nature. The relational
database strictly adheres the relations and this relation is divided into the set of columns and
rows for storing the data where it is known as the tables. Compared with the NoSQL database it
has a documented oriented storage which does not requires any type of table like structures. The
relational database does hold a well-designed pre-defined schema and comparing it to the
NoSQL database system it does have a dynamic schema for the unstructured data or the
document type. The authors have also identified that the relational database is scalable from the
vertical aspects where the NoSQL database are scalable from the horizontal aspects. Also, this
comparison has defined that SQL database systems uses structured query language for defining
any kind of data where the NoSQL database system collection of documents for the data
definition purpose. This is also known as the unstructured query language. This comparison
performed by the author has also defined that SQL database system does not have any type of
hierarchical data storage where the NoSQL database systems does have hierarchical data storage
system. These are the main differences discovered by the authors through this comparative study.
Analysis of Literature:

8DATABASE MODIFICATION IN FIBRE FASHION
There is nothing more critical than data in an information system. Extensive analysis will
be done to identify the best solutions out of the literature review to support the database need of
Fibre Fashion. Each database management system has its strengths and weaknesses. That is why
selecting the right database is very essential for Fibre Fashion to perform its daily logistics and
sales operations. Fibre Fashion had been using spreadsheet and backdated database system to
track its daily operations.
The literature review has provided detailed information on structured query language and
NoSQL. If Fibre Fashion uses SQL then impedance mismatch issues will rise. In a typical SQL
structure, it is essential to remember the layout of each structure so that join operations can be
done (Gessert et al., 2017). Each join operation sums additional lookup to that table which result
into more time to perform a query. In case of NoSQL these joins can be avoided to increase
performance. The NoSQL codes are more easily understandable. NoSQL will allow more speed,
performance and scalability. NoSQL supports horizontal scalability that can be very important if
organization decides to expand its data requirements in future. However, the main queries that
are rising before considering NoSQL as the main solution is its reliability. Fibre Fashion will
have a lot of financial transaction within its system that can become very vulnerable if NoSQL is
considered. NoSQL adoptions had before resulted into atomicity, duplication and data security.
However, MongoDB in particular has addressed those issues in latest versions. Though it must
be considered that Oracle and PostgreSQL are far more reliable in than MongoDB. NoSQL has
redundant data that can increase cost of server due to huge data storing. It can become a critical
issue for Fibre Fashion. Moreover, NoSQL databases are not ACID compliance.
SQL databases on the other hand are very secure, practical and easy to maintain. In order
to provide performance boost, SQL databases has feature like indexing. Indexing in PostgreSQL

9DATABASE MODIFICATION IN FIBRE FASHION
can provide huge performance boost to Fibre Fashion. The DBMS offers two types of indexes
such as expression index and partial index. PostgreSQL community is huge and various
organizations also provide commercial support. PostgreSQL also include some NoSQL features
and it supports horizontal scale to some extent. In a situation like this, Fibre Fashion must go
with the PostgreSQL. The organization is currently using a relational database. This will allow
Fibre Fashion to understand the database structure quickly rather than researching about a whole
new genre. All the financial transactions of Fibre Fashion will be guided by ACID properties.
It is essential for Fibre Fashion to maintain the operational cost while expanding through
new regions. Increasing the capacity and salability of database system will not only enhance
internal processing but also allow Fibre Fashion to save a lot of capital in long run.
Implementing a more robust database system like PostgreSQL will enhance data integration,
process automation, reporting, efficient business modelling and many other factors that can
directly or indirectly benefit Fibre Fashion. Database management systems are powerful but do
not come with rich user experience. Backend technologies like python, php, c# and many others
are used to develop the rich interface that allows users to interact with database system. These
backend languages play a huge part in process automation. That is why along with database
system upgrade, Fibre Fashion should also implement a system that provides unique user
experience. It is essential because not all people are capable or have expertise to write raw sql
queries to fetch required data.
Conclusion:
From the above pages of the report, the point can be concluded that this report is all about
implementation of database system in Fiber Fashion. Currently, the organization makes use

10DATABASE MODIFICATION IN FIBRE FASHION
spreadsheet for keeping a track of both client and sale obtained on each and every brand. The
excel spreadsheet is required to keep a track of different brands which is very much inefficient.
The report is all about application of business and IS knowledge, concept for developing
verifiable solution. A list of recommendation has been provided in order to address and provide
strategic goal for this organization. There is need for development and communication of proper
strategy as per the guidelines of agile methodology needed by the stakeholder of the
organization. The database system in this organization can help in improving data sharing.
DBMS can help in creating an environment where user can have much better access to data. In
addition, there can be much better managed data. It merely focus on investment of huge time,
effort and money in order to ensure proper productivity within the organization. Any business
like Fiber fashion need to valid information so that proper can be done. Suitable tool can be there
with respect to input, tracking, storing and analysis. One of drawback for this organization is that
spreadsheet require calculation which should be provided in the spreadsheet. It merely requires
complete learning of the correct syntax for the provided calculation. Spreadsheet come up with
drawbacks like complete lack of security of the client file. For this organization, spreadsheet are
not found to be secure and it has a high risk of data corruption or even mismanagement of
information.
Recommended Solution:
Enhancing Indexing Strategy: It is common to overlook indexing at the time of
development but it can prove to be best tool for tuning the database system. PostgreSQL and
other SQL databases defines indexes as data structures that offer quick selection and sorting on
the data. Indexing must be done accurately and following best practices to ensure faster data
retrieval.

11DATABASE MODIFICATION IN FIBRE FASHION
Keeping Certain Files Protected: Fibre Fashion, if possible, should implement the
database in a separate server to ensure enhanced security measures. In case system is
compromised, hackers cannot get access to the database server. The organization can simply lock
the database server to ensure complete connection stop.
Backup and Recovery: Data back and recovery is an essential part of business. It is very
common that data has become corrupted or some data is lost. Backing up data will ensure
organization has all the required data store in separate location to be fetched in case of
emergency. Backup should be done periodically.
Choosing the Compatible Technologies: It is essential that Fibre Fashion chooses the
right set of technologies. Taken as an example, Oracle is best suited with Java environment,
PostgreSQL with Python, MySQL with PHP and MSSQL with c#. Choosing the right
technologies and tools allow following best practices, eliminate performance overhead,
availability of patches and solutions.

12DATABASE MODIFICATION IN FIBRE FASHION
References:
Arulraj, J., & Pavlo, A. (2017, May). How to build a non-volatile memory database management
system. In Proceedings of the 2017 ACM International Conference on Management of
Data (pp. 1753-1758).
Chan, A. T., Ngai, E. W., & Moon, K. K. (2017). The effects of strategic and manufacturing
flexibilities and supply chain agility on firm performance in the fashion
industry. European Journal of Operational Research, 259(2), 486-499.
Gessert, F., Wingerath, W., Friedrich, S., & Ritter, N. (2017). NoSQL database systems: a survey
and decision guidance. Computer Science-Research and Development, 32(3-4), 353-365.
Jochim, M. (2017, August). Extending the EMU Speech Database Management System: Cloud
Hosting, Team Collaboration, Automatic Revision Control. In INTERSPEECH (pp. 813-
814).
Kunda, D., & Phiri, H. (2017). A comparative study of nosql and relational database. Zambia
ICT Journal, 1, 1-4.
Lee, M. S., Seifert, M., & Cherrier, H. (2017). Anti-consumption and governance in the global
fashion industry: Transparency is key. In Governing Corporate Social Responsibility in
the Apparel Industry after Rana Plaza (pp. 147-174). Palgrave Macmillan, New York.
Lu, W., Zhao, Z., Wang, X., Li, H., Zhang, Z., Shui, Z., ... & Du, X. (2019). A lightweight and
efficient temporal database management system in TDSQL. Proceedings of the VLDB
Endowment, 12(12), 2035-2046.

13DATABASE MODIFICATION IN FIBRE FASHION
Meier, A., & Kaufmann, M. (2019). Nosql databases. In SQL & NoSQL Databases (pp. 201-
218). Springer Vieweg, Wiesbaden.
Pavlo, A., Angulo, G., Arulraj, J., Lin, H., Lin, J., Ma, L., ... & Santurkar, S. (2017, January).
Self-Driving Database Management Systems. In CIDR (Vol. 4, p. 1).
Pedersen, E. R. G., Gwozdz, W., & Hvass, K. K. (2018). Exploring the relationship between
business model innovation, corporate sustainability, and organisational values within the
fashion industry. Journal of Business Ethics, 149(2), 267-284.
Sudha, M., & Sheena, K. (2017). Impact of influencers in consumer decision process: the fashion
industry. SCMS Journal of Indian Management, 14(3), 14-30.
Todeschini, B. V., Cortimiglia, M. N., Callegaro-de-Menezes, D., & Ghezzi, A. (2017).
Innovative and sustainable business models in the fashion industry: Entrepreneurial
drivers, opportunities, and challenges. Business Horizons, 60(6), 759-770.
Van Aken, D., Pavlo, A., Gordon, G. J., & Zhang, B. (2017, May). Automatic database
management system tuning through large-scale machine learning. In Proceedings of the
2017 ACM International Conference on Management of Data (pp. 1009-1024).
Yang, S., Song, Y., & Tong, S. (2017). Sustainable retailing in the fashion industry: A systematic
literature review. Sustainability, 9(7), 1266.
Zhang, B., Van Aken, D., Wang, J., Dai, T., Jiang, S., Lao, J., ... & Gordon, G. J. (2018). A
demonstration of the ottertune automatic database management system tuning
service. Proceedings of the VLDB Endowment, 11(12), 1910-1913.