ICT704 Non Relational Database Systems

ICT704 Non Relational Database Systems

Free Samples

ICT704 Non Relational Database Systems

.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}

ICT704 Non Relational Database Systems

0 Download5 Pages / 1,221 Words

Course Code: ICT704
University: University Of The Sunshine Coast

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Question:
For the report you are required to explain the structure of the database you created. This includes justifying the indexes you created. You need to describe how the relationships were handled in the database. In your report, discuss potential alternatives to how the relationships could have been modeled and implemented in MongoDB and the benefits/issues of each. Provide recommendations to Movie Maniacs for any additional functionality for the database

Answer:
Structure of the database:
Our database comprises a single collection movie. Movies contain a number of Movie documents which have various attributes like MovieId, MovieName etc. Each Movie document may or may not have ratings associated with it. We are using the embedded relationship approach in our database. So all the rating documents associated with a Movie are embedded inside it. There is a one to many relationships between movies and ratings. Each movie in the collection can have zero or more ratings associated with it. That means that there can be some movies which do not have any rating associated with it. Each rating is associated with only one movie at a time. Also, ratings and movies have a strong relationship between them. No rating can exist without a movie whereas movies can exist without ratings also.
Example Movie Document:-
db.movies.insert({
“MovieID”: “11”,
“MovieName”: “King Kong”,
“Director”: “Ernest B Schoedsack, Merian C Cooper”,
“Leading actors”: “Bruce Cabot, Ernest B Schoedsack, Fay Wray, Frank Reicher, James Flavin, John Armstrong, Noble Jhonson, Robert Armstrong”,
“ReleaseDate”: “1933”,
“Country”: “USA”,
“ratings”:[{
        “ReviewedBy”: “Mitch”,
        “Date”: “6/9/18”,
        “Rating”: 5,
        “Comments”: “Was ok, could have been better”
    },{
        “ReviewedBy”: “Matt”,
        “Date”: “6/7/18”,
        “Rating”: 9,
        “Comments”: “Brilliant”
    }]});
 
This is an example movie document having two ratings associated with it. These rating documents are stored like an array having rating document.
Indexes Created: 
We have created the following index:
db.movies.createIndex({“MovieID”:1,”MovieName”:-1});
This index is a combination of two columns MovieId and MovieName. “MovieId”:1 means that the index is created as ascending order for r the column MovieId and as the Descending order for MovieName. Id and name of an element is the most common and important attribute associated with it. So I have chosen these two columns for creating the index. When our database will become bulky and the number of documents in it will rise to a large extent, then this index will help in fetching the results from the database faster. The index helps in improving the performance of the database by making the search results faster.
Handling of relationships in database:-
We have used the embedded relationship approach in our database design. In the embedded approach various child documents are directly embedded inside the parent documents. There is an attribute named ratings that only exist for the documents having any rating. If no rating exists for any movie, then the rating attribute is not present for that Movie. We have a one to many relationships between movie and Rating. Each movie can have zero or many ratings associated with it but one rating can have only one movie associated with it. Also, a rating cannot even exist without a movie. If a movie is deleted, then all the ratings associated with it are automatically deleted.
Alternatives to how the relationships could have been modelled and implemented in MongoDB:-
There are only two ways in which the relationships can be handled in Mongo Db.

Embedded Approach: –

This is the most common and easiest approach. In this approach, one type of documents is embedded into other types of documents. We have used this approach in our database design. In such an approach, the child entities which are embedded cannot exist without the parent entities. If we delete the parent entity, then all the child entities associated with it are automatically deleted. Only the parent document in the embedded approach has the unique identifier (_id) provided by Mongo DB. All child documents do not have this unique identifier.
Benefits of using Embedded Approach:-

All the data can be retrieved by just one query. When we retrieve the parent document, all the child documents embedded inside this parent document are also automatically fetched inside it. So queries in embedded approach are faster and simpler.
If we remove the parent data which has various embedded documents in it. Then all those embedded documents are also automatically deleted.

Issues of using Embedded Approach:- 

Size is a constraint in the embedded approach, as all the embedded documents are also a part of the main parent document. So the size of the parent document goes on increasing as the number of child documents is increasing. MongoDB limits the size of a document to 16MB. 

Duplication of documents is there as the documents are embedded. So, if one document needs to be used by more than one parent, then its copying is required. 

Document References Approach: –

In this approach, rather than embedding documents inside one another, we can give each document an id and then the document ids are stored as references rather than storing the actual documents.
In this approach, the child documents also exist as a separate entity. So, deletion of the main entity which has references to the child entity do not means deleting the main entity. In such a case only the parent entity is deleted, but all the referenced entities are not deleted with it. All the referenced entities are also separate documents and they have their own unique identifier (_id).  
Benefits of using Document References Approach:-

Consistency is there among various referenced documents on updates as all the parent documents have references to the same chills document.
Size constraint is not there as the parent document is just storing the references and not the whole documents.
No duplication of data is there as the same document can be referenced as the child in more than one document 

Issues of using Document References Approach:-

Queries are slower in this approach as one query just retrieves the references and then the second query retrieves the referenced documents associated with these references. 

Recommendations to Movie Maniacs for any additional functionality for the database. :-

We can try to store various links to various banners/posters that are associated with a particular movie.
We can store a short story of the movie as the description in the movies database. So this will give an idea to the users of what this movie is all about.
We can store the Genre of the movie and its type like is it A romantic movie, action Movie etc. 

References: –
Alam, M. (2014) Oracle NoSQL database. New York: McGraw-Hill Education/Oracle Press.
Copeland, R. (2013) MongoDB applied design patterns. Sebastopol, CA: O’Reilly Media, Inc.
Dayley, B. (2015) Sams Teach Yourself NoSQL with MongoDB in 24 hours. Indianapolis, Ind.: Sams.
Eliot, G. (2016) The mill on the Floss. New York: Open Road Integrated Media.
Francia, S. (2012) MongoDB and PHP. Beijing: O’Reilly.
McCreary, D. and Kelly, A. (2014) Making sense of NoSQL. Shelter Island: Manning.
Mehrabani, A. (2014) MongoDB high availability. Birmingham: Packt Publishing.
Perkins, L., Redmond, E. and Wilson, J. (2018) Seven databases in seven weeks. Raleigh, N. C.: The Pragmatic Bookshelf.
Vaish, G. (2013) Getting started with NoSQL. Birmingham: Packt Publishing.

Free Membership to World’s Largest Sample Bank

To View this & another 50000+ free samples. Please put
your valid email id.

E-mail

Yes, alert me for offers and important updates

Submit 

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

UploadUnique Document

DocumentUnder Evaluation

Get Moneyinto Your Wallet

Total 5 pages

PAY 3 USD TO DOWNLOAD

*The content must not be available online or in our existing Database to qualify as
unique.

Cite This Work
To export a reference to this article please select a referencing stye below:

APA
MLA
Harvard
OSCOLA
Vancouver

My Assignment Help. (2021). Non Relational Database Systems. Retrieved from https://myassignmenthelp.com/free-samples/ict704-non-relational-database-systems/embedded-approach.html.

“Non Relational Database Systems.” My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/ict704-non-relational-database-systems/embedded-approach.html.

My Assignment Help (2021) Non Relational Database Systems [Online]. Available from: https://myassignmenthelp.com/free-samples/ict704-non-relational-database-systems/embedded-approach.html[Accessed 18 December 2021].

My Assignment Help. ‘Non Relational Database Systems’ (My Assignment Help, 2021) accessed 18 December 2021.

My Assignment Help. Non Relational Database Systems [Internet]. My Assignment Help. 2021 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/ict704-non-relational-database-systems/embedded-approach.html.

×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}

×

Thank you for your interest
The respective sample has been mail to your register email id

×

CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.

Account created successfully!
We have sent login details on your registered email.

User:

Password:

Have you been grappling with the burden of producing stellar admission essays? Fret not. Let the essay help professionals of MyAssignmenthelp.com in the UK can take away all your academic concerns. Often students get stuck with writing a quality college essay, and ask “Can someone write an essay for me?” We understand that the inability to deliver a stellar admission essay can ruin your chances of securing a cherished spot in your dream college. Interact us, and we will help you deliver a brilliant essay, just the way you want. Our professionals are well-versed with all the ins and outs of writing an excellent admission essay. Our experts of essay writing services of UK are well adept at conducting extensive research, structuring it accurately to referencing following all norms. The essays prepared by our experts have been admired by assessors of top universities all across the world.

Latest Management Samples

div#loaddata .card img {max-width: 100%;
}

MPM755 Building Success In Commerce
Download :
0 | Pages :
9

Course Code: MPM755
University: Deakin University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More

SNM660 Evidence Based Practice
Download :
0 | Pages :
8

Course Code: SNM660
University: The University Of Sheffield

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration 

BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20

Course Code: BSBHRM513
University: Tafe NSW

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More

MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5

Course Code: MKT2031
University: University Of Northampton

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration 

MN506 System Management
Download :
0 | Pages :
7

Course Code: MN506
University: Melbourne Institute Of Technology

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology 

Next

Our Essay Writing Service Features

Qualified Writers
Looming deadline? Get your paper done in 6 hours or less. Message via chat and we'll get onto it.
Anonymity
We care about the privacy of our clients and will never share your personal information with any third parties or persons.
Free Turnitin Report
A plagiarism report from Turnitin can be attached to your order to ensure your paper's originality.
Safe Payments
The further the deadline or the more pages you order, the lower the price! Affordability is in our DNA.
No Hidden Charges
We offer the lowest prices per page in the industry, with an average of $7 per page
24/7/365 Support
You can contact us any time of day and night with any questions; we'll always be happy to help you out.
$15.99 Plagiarism report
$15.99 Plagiarism report
$15.99 Plagiarism report
$15.99 Plagiarism report
$3.99 Outline
$21.99 Unlimited Revisions
Get all these features for $65.77 FREE
Do My Paper

Frequently Asked Questions About Our Essay Writing Service

Academic Paper Writing Service

Our essay writers will gladly help you with:

Essay
Business Plan
Presentation or Speech
Admission Essay
Case Study
Reflective Writing
Annotated Bibliography
Creative Writing
Report
Term Paper
Article Review
Critical Thinking / Review
Research Paper
Thesis / Dissertation
Book / Movie Review
Book Reviews
Literature Review
Research Proposal
Editing and proofreading
Other
Find Your Writer

Latest Feedback From Our Customers

Customer ID:  # 678224
Research Paper
Highly knowledgeable expert, reasonable price. Great at explaining hard concerts!
Writer: Raymond B.
08/10/2021
Customer ID: # 619634
Essay (any type)
Helped me with bear and bull markets right before my exam! Fast teacher. Would work with Grace again.
Writer: Lilian G.
08/10/2021
Customer ID: # 519731
Research Paper
If you are scanning reviews trying to find a great tutoring service, then scan no more. This service elite!
Writer: Grace P.
08/10/2021
Customer ID: #499222
Essay (any type)
This writer is great, finished very fast and the essay was perfect. Writer goes out of her way to meet your assignment needs!
Writer: Amanda B.
08/10/2021
Place an Order

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
×

Powered by essayworldwide.com

× WhatsApp Us