| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
FireFoxx80
   |
Posted - 2005.12.19 08:54:00 -
[1]
I haven't touched Java in years, but the suggestion I would offer is:
1) Client
Background app that scans the <eve> folder every <n> minutes. Looks for text files beginning with region names and parses them. Each file is then turned into an XML submission to a <web service>. Also, give the client the option to delete the expotr file once it is dealt with. Also, with the submission, provide some sort of <checksum> (to prevent tampering of data export files) and the option for the submitter to enter their <character> name.
2) Server.
As above, a <web service> to listen to incoming data and stick it into a database. You are right though, to get anything sensible out of it requires some hefty SQL joins and queries on both the existing eve data export, and the market data. Give people <credit> (redeemable for ISK) for each data submission, and charge people <credit> (ISK) for each view.
I am going to give it a look over xmas, as it ties nicely into a few other eve related projects I am doing.
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2005.12.23 22:48:00 -
[2]
 Originally by: FireFoxx80
I haven't touched Java in years, but the suggestion I would offer is:
1) Client
*snip*
2) Server.
*snip8
I am going to give it a look over xmas, as it ties nicely into a few other eve related projects I am doing.
Client is done, server is halfway there, just working on the SQL servers.
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2005.12.26 14:54:00 -
[3]
Method for reliable data I was looking at:
1) As the client submits data, build a checkum of the charactername and the IP that the data is submitted from. Each submission = 1 'view'.
2) As the client views data, check that IP/charactername checksum. Subtract from view counter.
That way, it's fairly easy to both identify users who submit wrong data, and identify users who claim to be others. However you are still stuck if you are a user with multiple characters.
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2005.12.29 12:32:00 -
[4]
Originally by: Doe Jane
 If the market data is exported to a server then others know what you know - there may be those that then see all markets before you. This can lead to several thing - like buy several hundred thousand units o r2 million units of something then traveling 20 jumps to find that the order was filled by the time you get there. I do not other to know the market info that I get from my atls and corp mates. As this will make the drive for the best deals even harder to get to. To be more to the point this empowers you competition just as it does you... Kinda a no brainer really...
Yup, but one would hope that the market is both large enough, and that the data is updated enough, that thst situation would infrequently arise.
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2005.12.31 14:00:00 -
[5]
Originally by: Obi'yer
I was thinking how would you separate old files from new files would you have the server auto overwrite the file on the data? I mean you could add the data on two files together for regional but you would only have to omit the first line from the text file.
It's fairly easy. Assuming you have a table that more or less emulates the text file:
SELECT MAX(submittime), * FROM MARKET_DATA WHERE (submittime >= DATESUB(NOW(), 6 hours) GROUP BY submittime
Apologies for the pseudo-sql there.
23? # Missile Tool # ex: P-TMC : USAC |
FireFoxx80
|
Posted - 2006.01.09 10:37:00 -
[6]
Your problem will be speed of queries.
23? # Missile Tool # ex: P-TMC : USAC |
| |
|