Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: Aldrin Austria
  Where is Aldrin Austria?
 Winnipeg
 Canada
 Aldrin Austria
 Tags
Subject: RE: need a substantial database??
Thread ID: 143503 Message ID: 143569 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, August 29, 2007 11:13:03 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".
>
>
>
> Thank you very much for the work you've done for this dataset. I will truly have a use for this kind of thing. My rating to you. :)

Aldrin,

You must have navigated away from the page before your rating was transmitted. Go to Boudewijn's original message click the "rate this" link at the bottom of the message header and then wait for the browser to refresh.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

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