Difference between revisions of "Elite Document Structure"
From NoSQLZoo
| Line 30: | Line 30: | ||
<code>systems</code> is much bigger, so some stations and listings have been removed from this example document to make it shorter. | <code>systems</code> is much bigger, so some stations and listings have been removed from this example document to make it shorter. | ||
<pre> | <pre> | ||
| + | |||
> db.systems.findOne({"name":"1 Kappa Cygni"}) | > db.systems.findOne({"name":"1 Kappa Cygni"}) | ||
{ | { | ||
| − | "_id" : ObjectId(" | + | "_id" : ObjectId("55b0edf6369fd5074b349c48"), |
"stations" : [ | "stations" : [ | ||
{ | { | ||
| Line 41: | Line 42: | ||
"has_outfitting" : 0, | "has_outfitting" : 0, | ||
"government" : "Democracy", | "government" : "Democracy", | ||
| − | |||
"has_shipyard" : 0, | "has_shipyard" : 0, | ||
"type" : "Unknown Outpost", | "type" : "Unknown Outpost", | ||
| Line 66: | Line 66: | ||
"sell_price" : 326, | "sell_price" : 326, | ||
"demand" : 217674 | "demand" : 217674 | ||
| − | } | + | } |
], | ], | ||
"distance_to_star" : 2359, | "distance_to_star" : 2359, | ||
| Line 76: | Line 76: | ||
}, | }, | ||
{ | { | ||
| − | "max_landing_pad_size" : " | + | "max_landing_pad_size" : "M", |
"has_blackmarket" : 1, | "has_blackmarket" : 1, | ||
"has_commodities" : 0, | "has_commodities" : 0, | ||
"updated_at" : 1434929486, | "updated_at" : 1434929486, | ||
| − | "has_outfitting" : | + | "has_outfitting" : 0, |
| − | "government" : " | + | "government" : "Anarchy", |
| − | + | "has_shipyard" : 0, | |
| − | "has_shipyard" : | + | "type" : "Unknown Outpost", |
| − | "type" : "Unknown | ||
"has_rearm" : 1, | "has_rearm" : 1, | ||
| − | "allegiance" : " | + | "allegiance" : "Independent", |
"has_refuel" : 1, | "has_refuel" : 1, | ||
| − | "name" : " | + | "name" : "Hauck Enterprise", |
| − | "distance_to_star" : | + | "distance_to_star" : 4832, |
"economies" : [ | "economies" : [ | ||
"Industrial", | "Industrial", | ||
| Line 111: | Line 110: | ||
"population" : 24843190 | "population" : 24843190 | ||
} | } | ||
| − | |||
</pre> | </pre> | ||
Revision as of 13:38, 23 July 2015
Questions on this database can be found here MAPREDUCE elite
Elite Dangerous
Keys used in this database.
commodities:
_id, average_price, category, name
systems:
_id, allegiance, faction, government, name, population, primary_economy, security, state, stations, updated_at, x, y, z
systems.stations:
allegiance, distance_to_star, economies, export_commodities,has_blackmarket, has_commodities, has_rearm, has_repair,
has_shipyard, has_outfitting, faction, government, listings, max_landing_pad, name, state, type, updated_at
systems.stations.listings:
buy_price, collected_at, demand, commodity, sell_price, supply, update_count
Unlike the world collection, null and empty values are not stored in this database.
This means that some documents will have fields that others do not: Some systems will be uninhabited and have no stations. Some stations will have no listings.
To query null or non-existant fields we use <field>: null
The average commodities document looks something like this.
{
"_id" : ObjectId("55af74e7402aa43f1ce7e3a3"),
"name" : "Explosives",
"average_price" : 267,
"category" : "Chemicals"
}
systems is much bigger, so some stations and listings have been removed from this example document to make it shorter.
> db.systems.findOne({"name":"1 Kappa Cygni"})
{
"_id" : ObjectId("55b0edf6369fd5074b349c48"),
"stations" : [
{
"max_landing_pad_size" : "M",
"has_blackmarket" : 0,
"has_commodities" : 1,
"updated_at" : 1434929486,
"has_outfitting" : 0,
"government" : "Democracy",
"has_shipyard" : 0,
"type" : "Unknown Outpost",
"has_rearm" : 0,
"allegiance" : "Federation",
"has_refuel" : 1,
"name" : "Kinsey Ring",
"listings" : [
{
"commodity" : "Hydrogen Fuel",
"supply" : 129630,
"collected_at" : 1421669319,
"update_count" : "1",
"buy_price" : 93,
"sell_price" : 89,
"demand" : 0
},
{
"commodity" : "Mineral Oil",
"supply" : 0,
"collected_at" : 1421669320,
"update_count" : "1",
"buy_price" : 0,
"sell_price" : 326,
"demand" : 217674
}
],
"distance_to_star" : 2359,
"economies" : [
"Industrial",
"Refinery"
],
"has_repair" : 1
},
{
"max_landing_pad_size" : "M",
"has_blackmarket" : 1,
"has_commodities" : 0,
"updated_at" : 1434929486,
"has_outfitting" : 0,
"government" : "Anarchy",
"has_shipyard" : 0,
"type" : "Unknown Outpost",
"has_rearm" : 1,
"allegiance" : "Independent",
"has_refuel" : 1,
"name" : "Hauck Enterprise",
"distance_to_star" : 4832,
"economies" : [
"Industrial",
"Refinery"
],
"has_repair" : 1
}
],
"name" : "1 Kappa Cygni",
"faction" : "United 1 Kappa Cygni Future",
"government" : "Democracy",
"allegiance" : "Federation",
"updated_at" : 1430938622,
"state" : "None",
"needs_permit" : 0,
"y" : 37.78125,
"x" : -117.75,
"security" : "High",
"z" : 11.1875,
"primary_economy" : "Industrial",
"population" : 24843190
}