Person Info Test Data Table for OpenInsight
Benchmarking with real data or copies of real data is useful but it becomes problematic if you want to compare the performance of one site with another site and can't use the same data set at both sites. Having a consistent data set that is sanitized and can be used at any site can be a useful for performance benchmarks and consistent testing.
Below is a download link for a LinearHash table and accompanying source data table of a 1 million row person information table. Records are sequentially keyed from 1 to 1,000,000.
PERSON_INFO_TEST Dictionary:
| Key | FMC | TYPE |
| ID | 0 | F |
| FNAME | 1 | F |
| LNAME | 2 | F |
| ADDRESS | 3 | F |
| CITY | 4 | F |
| ZIP | 5 | F |
| COUNTRY | 6 | F |
| GEOPOS | 7 | F |
| PHONEHOME | 8 | F |
| PHONECELL | 9 | F |
| EMAILWORK | 10 | F |
| BUSINESSNAME | 11 | F |
| DATEOFBIRTH | 12 | F |
| ASSETVALUE | 13 | F |
| 14 | F | |
| BIOSHORT | 15 | F |
Linear Hash LK/OV Files, Dictionary, and RAW sources download link:
CSDataSample_PersonInfo.7z - 146m
Sample data was generated using generatedata.com and then imported into an OpenInsight Linear Hash table.
Author
Jared Bratu
Long time network sysadmin with proclivity to coding. Why do something twice when it can be scripted once? With a wide range of familiar technology skills Jared tries to apply the best aspects of each technology to projects leaving them better than they were before.
Leave a comment