Database and Conceptual Modeling: NoSQL and DreamHome Analysis

This report delves into the world of NoSQL databases, offering a comprehensive overview of their theoretical underpinnings, motivations, and technological aspects. It begins by defining NoSQL as an alternative to traditional relational databases, highlighting its ability to accommodate diverse data models like key-value, columnar, and graph formats. The report then contrasts NoSQL with relational databases across key areas, including data models, data structure, scaling capabilities, and development models. Furthermore, the report explores a practical application of NoSQL, suggesting its use within the DreamHome Database to enhance compatibility and data handling. It emphasizes NoSQL's flexibility in accommodating various web application file formats and its advantages in managing large datasets compared to relational systems. The report concludes by emphasizing the ease of handling real-life applications using NoSQL databases. The assignment is available on Desklib, a platform providing AI-based study tools.

Running head: DATABASE AND CONCEPTUAL MODELLING
Database and Conceptual Modelling
Name of Student-
Name of University-
Author’s Note-

1DATABASE AND CONCEPTUAL MODELLING
Part 1:
Theory, Motivation, and Technology behind NoSQL
NoSQL commonly known as Not Only SQL Database, is an approach that helps to
accommodate wide range of data models that includes key-value, columnar, graphs, as well as
document format.
Not Only SQL is basically an alternative to the traditional Relational Database in which
the information is placed in the tables, and the data schema is designed carefully before building
the database (Liao et al. 2016). Specifically, when the work is done on large sets of data that are
distributed, then databases of NoSQL are used.
NoSQL means implementing the database for designing the software solution or a
product (Bugiotti et al. 2014). Not Only SQL is used when there are multiple storage systems
that are can be used based on the requirement. NoSQL was previously a hashtag that was chosen
to meet up and discuss the new databases. No SQL came from Polyglot Persistence.
Comparison between NoSQL and Relational Database Model
Not only SQL differs from traditional relational database mainly in four different sectors.
The four areas where they can be differentiated is discussed below.
 Data Models: In NoSQL, the schema is not to be defined to build the application. The
database of NoSQL helps to make the application even without defining the schema that
is not possible in relational database (Fiannaca and Huang 2015). The schema is to be
defined first in RDMS before adding or deleting data in the database. For updating the

2DATABASE AND CONCEPTUAL MODELLING
data in NoSQL or changing the requirements of the database, predefined schema is not
required.
 Data Structure: In relational databases, the data is to be structured and the relation
between them is to be shown clearly (Noel et al. 2015). On the other hand, NoSQL
databases usually handles data that are unstructured.
 Scaling: The NoSQL database is much cheaper to scale than the relational database. This
is because in NoSQL space can be added by scaling commodity and cheap servers, but
RDMS requires a particular server for hosting the database. For scaling purpose,
expensive and bigger servers are needed.
 Development Model: The database of NoSQL is open sourced and the relational
databases are closed source along with licensing fees. The NoSQL database does not
requires any huge investments.
Part 2:
Application of NoSQL on DreamHome
Since, the NoSQL database does not require any particular web application file format
(Gadepally et al. 2015). The database of NoSQL is compatible with different web applications.
So, NoSQL can be used in DreamHome Database to make the structure more compatible. Any
type of file format can be used, processed or can be integrated in web application using the
NoSQL. In the DreamHome Database, NoSQL could be used because the storage as well as the
retrieval of the system is different from the relations that are used in relational database.

3DATABASE AND CONCEPTUAL MODELLING
If the database of DreamHome could be done on NoSQL, then large amount of data sets
could be used as there is no boundary for data. Handling a real life application of NoSQL is
much easier than relational databases.
References
Bugiotti, F., Cabibbo, L., Atzeni, P. and Torlone, R., 2014, October. Database design for NoSQL
systems. In International Conference on Conceptual Modeling (pp. 223-231). Springer, Cham.
Fiannaca, A.J. and Huang, J., 2015. Benchmarking of Relational and NoSQL Databases to
Determine Constraints for Querying Robot Execution Logs. Computer Science & Engineering,
University of Washington, USA, pp.1-8.
Gadepally, V., Bolewski, J., Hook, D., Hutchison, D., Miller, B. and Kepner, J., 2015, May.
Graphulo: Linear algebra graph kernels for NoSQL databases. In Parallel and Distributed
Processing Symposium Workshop (IPDPSW), 2015 IEEE International (pp. 822-830). IEEE.
Liao, Y.T., Zhou, J., Lu, C.H., Chen, S.C., Hsu, C.H., Chen, W., Jiang, M.F. and Chung, Y.C.,
2016. Data adapter for querying and transformation between SQL and NoSQL database. Future
Generation Computer Systems, 65, pp.111-121.
Noel, S., Harley, E., Tam, K.H. and Gyor, G., 2015. Big-Data Architecture for Cyber Attack
Graphs Representing Security Relationships in NoSQL Graph Databases.