David Wendelken (White Giant) | Monday, September 1, 2008 - 12:48 pm 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 type at each effectivity setting. - Weapons and labor usage by worker type. - Our corporations with hiring levels by worker type, effectivity and quality settings. |