Jump to content
Sign in to follow this  

Creating snapshots of data (multiple fields)

Recommended Posts

I've started building a database to track investments (stocks, mutual funds, bonds, etc.). What I'm after is to periodically duplicate all the records, set a date field with today's date, and update the quantities and prices of the investments. The investments have a field that describes their type (e.g., bond, international, risk, etc.). The outcome is to be able to see snapshots of investments over time, and compare them, as well as to see the current state.

I'm sure this is a very common type of database design. However I'm note sure of how to build it (there are probably a number of good ways to build it). Thinking in ERD terms, I was thinking of an investment table, a data table, and then a join table in the middle. Thanks.


Share this post

Link to post
Share on other sites

That's brilliant. The global selected date is something I hadn't considered. Thank you!

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.