• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Creating a large table , 8 million rows, 30 key values

B

bdbigdata

Junior Member
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top