I'm an amateur programmer. I'd like to develop a software application (like Tradestation), to analyse real-time market data. Please teach me if the following approach is correct, ie the procedures, knowledge or software needed etc:Use a DB to read the real-time feed from data provider: what should be the right DB to use? I know it should be a time serious one. Can I use SQL, Mysql, or others? What database can receive real-time data feed? Do I need to configure the DB to do this?If the real-time data is in ASCII form, how can it be converted to those that can be read by the DB and my application? Should I have to write codes or just use some add-ins? What kind of add-in are needed?How should I code the program to retrieve the changing data from the DB so that the analysis software screen data can also change asynchronously? (like the RTD in excel)Which aspects of programming do I need to learn to develop the above?Are there web resources/ books I can refer to for more information?
Real-time stock market application
database development
Per se, a database stores data, but it doesn't read it. In practice, most database systems come with lots of tools, so maybe one of those tools allow you to read the feed; some database systems like Oracle have powerful built-in languages so you could place the reading program as a stored procedure in the database.But I don't think that this is the right approach to go. You should better use a language like Java, C# etc. to write a program that fetches and parses the realtime feed and uses (N)Hibernate to write it into the database; other parts of the program could do the calculation and yet other parts create the screen output. A typical beginners mistake would be to create a big god class that does all that stuff; good programmers avoid that, they separate different concerns into different classes. In your case, the model-view-controller pattern seems like a good start.