Storing small amounts of data may be feasible in a spreadsheet whereas very large datasets may require a Big Data ecosystem. However, intermediate datasets (5-15 Gb size) can be stored in a desktop-based database system.
There are many different, freely available database systems to choose from depending on your needs. The choice depends on how much data you have or plan to collect, the type of the data you are gathering and how you will need to query the data.
This introductory webinar will cover:
- a basic definition of a database and introduction to a variety of database types
- how data can be stored in relational databases and equally importantly how data can be retrieved from them by writing queries in SQL (Structured Query Language).
- how data can be stored in ‘NoSQL’ databases such as Document databases (MongoDB) and Graph databases (Neo4j). Each database has its own query language and set of commands to load and store the data. For comparison we will show how data can be stored and retrieved from different ‘NoSQL’ databases.
This introductory webinar is intended for researchers with no previous experience of programming or of using databases.