Using a .sql database to analyze market data? Huh?
For my CSCI class, I'm writing a program to analyze market data from an online video game I play. I'm having no problem actually writing it (the traveling salesman issue excluded) but I have run into a problem - all locations (star systems, stations) are represented as 10 digit numbers, which means that at the end of the program, it gives me the best trade route it could come up with, between system id 30000136 and 30000159...which is kinda hard to read. So, after poking around in the development forums, I found that what I'm after is the latest "data dump," I presume a list of the locations in the game. After talking with my roommate and poking around on the net, I learned it was a database file, an SQL...unfortunately, I have no idea how to manipulate it or even access it. Not sure if this is the right place to post this problem, but what I'd eventually like to do is when my program returns those stations, I'd like it to access the database and find the appropriate name for the id presented. Any help or suggestions are greatly appreciated!
What kind of dbms does the game use?
usually you can access to the database using ado connection
usually you can access to the database using ado connection
Topic archived. No new replies allowed.