Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 Tags
Subject: need a substantial database??
Thread ID: 143503 Message ID: 143503 # Views: 2 # Ratings: 3
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, August 29, 2007 12:23:58 PM         
   


Hi all,

having a database like Northwind is nice... as long as you need to learn the concepts of developing in VFP and the concept of relational databases.
But it is rather useless if you want to take a look at speed....

I developed therefore a northwind alike database but with (ahem) slighty more records.
Here it goes:
Addresses (like the customer table in NW) 150,000 faked names and addresses.
These fakenames have fake accounts at a bank, total of 539,574 accounts of 4 different kinds. (See Accounttypes table)
There are also 5 regions where these faked ppl live.
(east west, south, north, middle) OK OK I know, my fantasy goes sky high.
15 employees, as in NW. I did not feel the need to work on that one. Who wants more, feel free to add so.

Then orders, 672,039 orders with 3,089,749 orderlines.

Of course these ppl need insurance. So I created a table for that 315,331 policies in that, of 4 types
And while these ppl have a bankaccount (even though faked) I have "some" transactions on those accounts.
28,633,109 to be exact.

This database can be used for your own purposes and will be available as-is. I will not take responsibility for resemblance of real people all data is fiction.

How to download it:
ftp to 212.29.188.133, port 21
username and PW: vfpuser

You can only "read" in that folder.
I zipped the stuff. still 410 MB, So it might need some time.
You can make one connection form any ip address only. There are 10 connections allowed simultanious.
So if you cannot get in, try at a later time again.

Enjoy,

Boudewijn LutgeĀ®ink
http://www.vfpdevelopers-online.com
Border Collies, the only breed "That'll do".

ENTIRE THREAD

need a substantial database?? Posted by Boudewijn Lutgerink @ 8/29/2007 12:23:58 PM
RE: need a substantial database?? Posted by Ken Murphy @ 8/29/2007 1:22:10 PM
RE: need a substantial database?? Posted by Cetin Basoz @ 8/29/2007 1:24:09 PM
RE: need a substantial database?? Posted by Cetin Basoz @ 8/29/2007 1:30:26 PM
RE: need a substantial database?? Posted by Ken Murphy @ 8/29/2007 3:54:51 PM
RE: need a substantial database?? Posted by Aldrin Austria @ 8/29/2007 3:47:13 PM
RE: need a substantial database?? Posted by Boudewijn Lutgerink @ 8/29/2007 10:43:28 PM
RE: need a substantial database?? Posted by Ken Murphy @ 8/29/2007 11:13:03 PM
RE: need a substantial database?? Posted by Aldrin Austria @ 8/30/2007 4:37:49 PM
RE: need a substantial database?? Posted by Bernard Bout @ 8/30/2007 5:55:27 AM
RE: need a substantial database?? Posted by Cetin Basoz @ 8/30/2007 2:27:00 PM
RE: need a substantial database?? Posted by Bernard Bout @ 8/31/2007 8:55:13 AM
RE: need a substantial database?? Posted by Boudewijn Lutgerink @ 8/31/2007 11:22:39 AM