I have to create a table of 8 million transport workers with roughly 20 to 30 key values. Data will be ingested through an apps, The table can perform some simple data analysis. Can someone tell me which should be a lost code DBM architecture?
I left off being a database expert when the field mostly involved relational databases. My only guess here is that you can break the data down into smaller tables, and link the information through the keys. It isn't so much the number of rows (transport workers by SSN or similar identifier) that makes it complex, and it could be a fairly simple or manageable structure. I'm not sure what you mean by "lost code DBM architecture". You could do this sort of thing with Microsoft Access, but of course -- you're looking for an open source option. With Access, SQL Server and other options, I don't see why "open source" has to be a requirement.