D
David Wendelken (White Giant)
All worlds
01 Sep 2008 12:48Link
This is based upon the assumption that the Simcountry database is a relational database that allows SQL queries against it.
Publish a set of read-only data views to the SimCountry data tables, and the data definitions of those views. These views would have built-in security in them that would limit the user to seeing the data that they are allowed to see.
Provide an interface that lets us write queries against those views. This lets us write our own reports to get the data we need.
As this might cause an additional load upon the system, users who overuse it might be charged extra. The cost in game dollars might also be added to the cost of government, and the amount of usage might be limited by one's business and trade index, which would represent one's ability to gather this economic data.
At the very least, provide a spreadsheet for the following topics:
- Corporation types and labor usage by worker
Publish a set of read-only data views to the SimCountry data tables, and the data definitions of those views. These views would have built-in security in them that would limit the user to seeing the data that they are allowed to see.
Provide an interface that lets us write queries against those views. This lets us write our own reports to get the data we need.
As this might cause an additional load upon the system, users who overuse it might be charged extra. The cost in game dollars might also be added to the cost of government, and the amount of usage might be limited by one's business and trade index, which would represent one's ability to gather this economic data.
At the very least, provide a spreadsheet for the following topics:
- Corporation types and labor usage by worker