I have an 8GB .csv file with 6 columns and 202,176,000 rows.
How would I convert that to an OpenOffice database(.db) file?
.db is used for several differant formats, but I'm assuming you mean Access. you can use the Access data import wizard to load the csv into a table.
Instructions here: http://databasesuperstar.com/ms-access-tutorial-how-to-import-csv-file/
for OpenOffice, see here: https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=37013
There is a tutorial at http://databasesuperstar.com/ms-access-tutorial-how-to-import-csv-file/, which is very good quality and too much to reproduce here.
From https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=37013 (source: various users), which presents multiple good options:
Import the CSV data into Calc. Select and copy all of the data. In the Base file, go to the Tables view (that is, click the Tables icon in the left had section), right click in the region where the tables are listed and select Paste. In the dialog that pops up, choose Definition and Data, then fill out the subsequent screens as needed. This option copies spreadsheet data into some type of editable database (native HSQLDB, MySQL or whatever database you connect Base with).
Use the file as an editable data source. This option utilizes some database server's capability to load plain text into predefined tables.
Store all similar csv files in one directory and connect a Base document to this directory. This option treats a collection of plain text files as if they were tables of a read-only database. From this pseudo-database you may also copy selected data into a true database.
See "import csv to openoffice database" for other options.
I have posted this as community wiki as I cannot take credit for any of the above, but am putting it here in case those other sites go down some day. Please feel free to add other options and instructions.