I have a database of stock data in Microsoft SQL (500MB) for use in an analysis program.
I need to:
- determine the structure of the database
- adjust the data using a simple recursive algorithm, that I can supply. The algorithm will refer to the existing data in the database, as well as additional data that I can supply in a table. The resulting databse structure will be identical to the current structure.
I want a process by which I can do this now, as well as in the future (as the data will change over time).