Advanced Databases

Load the publications dataset (from dblp.json)

Download Books dataset
create a new directory dblp, and make your mongod server start with this db path
connect to your mongod server from compass
in compass, create a new DB "dblp", and "publications" as a collection
Launch compass and then import the downloaded json file.

queries


        01. get all the articles
        02. count all the articles
        03. list of all the possible publication types
        04. find all the different publishers
        05. find all the publications from Springer publisher
        06. same as 05 but sorted by by year ascending and book title

queries using js

import this file and import it using a node.js script

implement the following queries, in js


            j01 - get a company named Facebook
            j02 - get companies founded in 2005, retaining only the company name and the founded date
            j03 - same as j02 but only first 3 companies
            j04 - same as j03 but sorted by name alphabetically ascending (A -> Z)
            j05 - find companies which is funded by a fund named "greylock", select ipo publication year, valuation and funder names
            j06 - identify all the companies funded by "greylock", select also the amount and the year of each funding
            j07 - give average number of employees per company

Moving to Repository pattern using typescript

To be continued