我有一只关于学校的数据:学校的地点、名称和每个学校的若干指标值:
County_id, County_name, Municipality_id, Municipality_name, School_id, School_name, Year, Indicator_1, Indicator_2, Indicator_3 [...]
我正在利用MongoDB,围绕这一数据建立互动的Java图像。
一些典型的询问是:(pseudo)
- Get a list of all Schools and their respective locations
- Get all Indicator_1 values for all years for schools in a specific location
- Count the number of schools in a specific location
1. Based on the data given, how should I set up my MongoDB documents/collections to be able to answer queries such as the above? (Hints on what intermediate steps I should take to import and build the schema are also welcome.)