ICT704 Non-Relational Database Systems - Free Samples to Students

db.getCollection('Movie').find({Country: 'Japan'})

Query 3: 

db.getCollection('Movie').find({}, {MovieName: 1, Director: 1, '_id':0})

db.getCollection('Movie').find({}, {MovieName: '2001', Director: 'Japan', '_id':0})

db.getCollection('Movie').distinct("Director")

db.getCollection('Movie').count({}, {MovieID: 1, '_id':0})

db.Movie.find({OscarsWon: { $exists: false }})

db.getCollection('Movie').find({ReleaseDate: {$lte: '1968'}})

db.Movie.aggregate([{$lookup:{from:"Movie", localField: "MovieID", foreignField: "MovieID", as: "MovieRating"}}, {$replaceRoot: { newRoot: { $mergeObjects: [ { $arrayElemAt: [ "$MovieRating", 0 ] }, "$$ROOT" ] } } }, {$group: {_id: {Movie: "$MovieID", MovieName: "$MovieName"}, averageRating: {$avg: "$Rating"}}}]);

db.Movie.aggregate([{ $lookup:{from:"Rating", localField: "MovieID", foreignField: "MovieID", as: "MovieRating"}}, {$replaceRoot: { newRoot: { $mergeObjects: [ { $arrayElemAt: [ "$MovieRating ", 0 ] }, "$$ROOT" ] } } }, {$project : {"MovieName": 1, MovieRating: {"Rating": 1, "Comments": 1}}}]);

db.Movie.update(

   { MovieName: "ET" },

   {

MovieID: "6",

MovieName: "E.T.",

Director: "Steven Spielberg",

ReleaseDate: "1982",

OscarsWon: "4",

Country: "USA"

 },

   { upsert: true }

)

Query 12: db.getCollection

('Movie').update

({MovieID: "12"},

{$set:{ notes: "Terminator and Terminator 2 are rated together"}})

db.getCollection

('Movie').update

({MovieID: "18"},

{$set:{ notes: "The trilogy consists of the three movies "}})

Bibliography:

Abbes, H. and Gargouri, F., 2016, December. M2Onto: an approach and a tool to learn OWL ontology from MongoDB database. In International Conference on Intelligent Systems Design and Applications (pp. 612-621). Springer, Cham.

Abbes, H. and Gargouri, F., 2016. Big data integration: A MongoDB database and modular ontologies based approach. Procedia Computer Science, 96, pp.446-455.

Abbes, H., Boukettaya, S. and Gargouri, F., 2015, November. Learning ontology from big data through MongoDB database. In Computer Systems and Applications (AICCSA), 2015 IEEE/ACS 12th International Conference of (pp. 1-7). IEEE.

Aboutorabi, S.H., Rezapour, M., Moradi, M. and Ghadiri, N., 2015, August. Performance evaluation of SQL and MongoDB databases for big e-commerce data. In Computer Science and Software Engineering (CSSE), 2015 International Symposium on (pp. 1-7). IEEE.

Chauhan, D. and Bansal, K.L., 2017. Using the Advantages of NoSQL: A case study on MongoDB. International Journal on Recent and Innovation Trends in Computing and Communication, 5(2), pp.90-93.

Dupont, C., Wussah, A., Malo, S., Thiare, O., Niass, F., Pham, C., Dupont, S., Le Gall, F. and Cousin, P., 2018, May. Low-Cost IoT Solutions for Fish Farmers in Africa. In 2018 IST-Africa Week Conference (IST-Africa) (pp. Page-1). IEEE.

Ferney, M.M.J., Estefan, L.B.N. and Alexander, V.V.J., 2017, October. Assessing data quality in open data: A case study. In de Innovacion y Tendencias en Ingenieria (CONIITI), 2017 Congreso Internacional (pp. 1-5). IEEE.

Gousios, G., Vasilescu, B., Serebrenik, A. and Zaidman, A., 2014, May. Lean GHTorrent: GitHub data on demand. In Proceedings of the 11th working conference on mining software repositories (pp. 384-387). ACM.

Guimaraes, V., Hondo, F., Almeida, R., Vera, H., Holanda, M., Araujo, A., Walter, M.E. and Lifschitz, S., 2015, November. A study of genomic data provenance in NoSQL document-oriented database systems. In Bioinformatics and Biomedicine (BIBM), 2015 IEEE International Conference on (pp. 1525-1531). IEEE.

Gyorodi, C., Gyorodi, R., Pecherle, G. and Olah, A., 2015, June. A comparative study: MongoDB vs. MySQL. In Engineering of Modern Electric Systems (EMES), 2015 13th International Conference on (pp. 1-6). IEEE.

Inel, O., Khamkham, K., Cristea, T., Dumitrache, A., Rutjes, A., van der Ploeg, J., Romaszko, L., Aroyo, L. and Sips, R.J., 2014, October. Crowdtruth: Machine-human computation framework for harnessing disagreement in gathering annotated data. In International Semantic Web Conference (pp. 486-504). Springer, Cham.

Kanoje, S., Powar, V. and Mukhopadhyay, D., 2015, March. Using MongoDB for social networking website deciphering the pros and cons. In Innovations in Information, Embedded and Communication Systems (ICIIECS), 2015 International Conference on (pp. 1-3). IEEE.

Kumar, L., Rajawat, S. and Joshi, K., 2015. Comparative analysis of nosql (mongodb) with mysql database. International Journal of Modern Trends in Engineering and Research, 2(5), pp.120-127.

Le, M.K., Chang, H.T., Chang, Y.M., Hu, Y.H. and Chen, H.T., 2016, December. An efficient multilevel healthy cloud system using Spark for smart clothes. In Computer Symposium (ICS), 2016 International (pp. 182-186). IEEE.

Michel, F., Faron-Zucker, C. and Montagnat, J., 2016, September. A mapping-based method to query MongoDB documents with SPARQL. In International Conference on Database and Expert Systems Applications (pp. 52-67). Springer, Cham.

Michel, F., Zucker, C.F. and Montagnat, J., 2016. Mapping-based SPARQL access to a MongoDB database (Doctoral dissertation, CNRS).

Mohamed, H.H.H., 2015. A new auditing mechanism for open source NoSQL database a case study on open source MongoDB database (Doctoral dissertation, Universiti Utara Malaysia).

Shukla, K. and Khare, P., 2018. A SIMPLIFIED WAY OF DATABASE MIGRATION FROM RELATIONAL DATABASE MYSQL TO NOSQL DATABASE MONGODB.

Simanjuntak, H.T., Simanjuntak, L., Situmorang, G. and Saragih, A., 2015. Query Response Time Comparison NOSQLDB MONGODB with SQLDB Oracle. JUTI: Jurnal Ilmiah Teknologi Informasi, 13(1), pp.95-105.

Stanescu, L., Brezovan, M. and Burdescu, D.D., 2016, September. Automatic mapping of MySQL databases to NoSQL MongoDB. In Computer Science and Information Systems (FedCSIS), 2016 Federated Conference on (pp. 837-840). IEEE.

Wu, C.M., Huang, Y.F. and Lee, J., 2015. Comparisons between mongodb and ms-sql databases on the twc website. American Journal of Software Engineering and Applications, 4(2), pp.35-41.