Hello, I want to know if anyone has any suggestions on what tech I should use for a database system where I will have to be able to select records based on criteria then create a flat file from the selected records to be used with other programs.
I have a flat file database of millions of records and I want to update it to be a relational database using more recent technology. Currently, the records are selected with an old IBM mainframe language where records are selected by byte position, it's a very old system. I want to know what would be some suggestions on how to convert the flat file database to a more up to date model. The database undergoes constant updating of records based on other input files where matching is performed and certain fields are updated, I'll need to be able to still do this.
The usage of the database is to select records from it based on specific criteria in each field or some combination of criteria where the output file of the selection is a flat file that is used in other programs for processing, so I'll need to be able to retain this functionality as well.
I know a little about current databases from a website I have that I've done a little bit with and it uses SQL so if that is the best avenue then let me know, but if there are alternatives to it that could be better or comparable I'm interested in those as well. It isn't just a database technology solution I'm looking for it is also the most reliable or easy way to convert from flat file to whatever database technology recommended. Any options available would be helpful if there are multiple competing solutions and a pro/con type thing to each could help. Thanks.