An amateur stock trader wants to store information about his day trading: stock prices, buys/sells, profits, losses,
Question:
An amateur stock trader wants to store information about his day trading: stock prices, buys/sells, profits, losses, etc. with the aim of creating an end-of-the-year report to help him analyze his activities. Unsurprisingly, the volume of data reached a point that caused our stock trader to think about using a database. He plans to run the DBMS locally, on his desktop (of course, he does not plan to share his financial information with anyone else). However, he needs help picking a database management system (DBMS) that meets the needs. He wants a DBMS with ONLY the features that he will use. Which of the following DBMS features would be recommended to the stock trader? For each feature, explain why he should (or should not) pay for it.
1. A reporting tool (tools used for data visualization & report generation from stored data)
2. Crash recovery
3. A query language
4. Concurrency control