I need a database program to manage my ultra-massive files. I currently use Lotus Approach - super easy to use - but the dbase files are limited to 2gb, so I need to upgrade my file size capability to unlimited.
My two biggest files are (csv) 100 million plus usa consumers with fields shown below, and 20 million usa businesses with dozens of fields. Currently I have to open them one state at a time - but I want to be able to see and manipulate all states at one time.
I would prefer not to go with sql, as I don't need all the bells and whistles - but I do need "unlimited" file size... I just need to be able to sort, search/find either one field or multiple for keywords, export, suppress.
That's about it...
1. process fast
[url removed, login to view] all the records (infinite) at one time
3. basic search functions - including suppress
4. simple to use
Here is the header for the consumer file:
EID,STATE,ZIP,AGE,DOB,GENDER,MARRIED,CHILDREN,VETERAN,INCOME,MALES,FEMALES,HOME OWNER,LANGUAGE,ETHNICITY,GOLF,OUTDOOR,TRAVEL ARTS,POLITICAL,HEALTH,IP ADDRESS,OPTDATE,SOURCE,EMAIL,FIRST NAME,LAST NAME,ADDRESS,CITY,HITECH,BANKCARD,STOCKBONDS,PREMIUM BANKCARD,OIL CARD,FINANCE CARD,RETAIL CARD,ID,,,