EOData: Goons clamping down on Gallente Ice

This morning I read the Market Discussion: Gallente Ice Part 2 on the evenews 24 site, and that made me wonder could I see the results in my database.
So I wrote a quick query to show the historic price evolution on Oxygen Isotopes, the item most targeted by the goons and put into a quick report, the following graph came up:

Since I only have data for ice products since October 10 2011, it only shows the evolution in the past month.

EvE Online: Isogen keeps flatlinening

For 2 months now the value of Isogen has remained steady, there have been changes but none great enough to have an effect on the graph.

This graph was generated with Visual Studio 2008, report designer, using the EOData base as source, the graph shows the evolution of the median price for the year 2011 (The data is provided via the eve-markets website)

EOData: Converting it to a datawarehouse

My boss had a nice assignment today, I got to practice datawarehousing.
In order to do this I got to create a datawarehouse base on my EOData database, however since EOData is already pretty conform to the structure of a datawarehouse:
*A datawarehouse receives bulks of information (Check)
*A datawarehouse has few updates (Check)
*A datawarehouse is around 90% read of data and 10% write (Sort of)

OK, so I can use it as datawarehouse, but that not the bad part, in order to to this I'll have to start renaming my tables to convene with naming standards, so first I got to rename a half-a-dozen tables. Then change any stored procedures,views,functions and packets that work on those.

Not looking forward to that.

EOData: Backstabbing

Since my boss has been more at the office I've been getting more assignments and less time to implement my EOData database.

Yesterday I reached the goal I had set out in EvE for this year, hurray.
Unfortunatly since I no longer can count on absolute certaintity that I'll be able to get all of my ore sold well, I have to get a buffer.

All and well, I set in a new goal in the database and suddenly all the data involving my daily activity is spitting out strange numbers, especially the estimated isk made since the last logged day.