![]() |
Database help
I need some help in setting up a database of past results. What info should i entered and how do i get it to search once theres enough info.
At the moment, the only database program I have is the one in MSWorks. Somehow, i don't think it will do the job. Any assitance is most welcome. |
Best Database to use : Oracle XE
Easiest Database to use : Microsoft Access. Good Luck. |
Benny, enter as much information as you can possibly obtain. What you dont deem as being important now might not be the case in 12 months time, and depending how you do it, it shouldnt be any harder.
IMO you will need either Oracle or MySQL, either will do, and both very similar anyway. But, you will need to familiarise youself with SQL, and PHP if you want to make the job of manipulating/displaying the data much easier. But if you dont know anything about programming you face an uphill battle, good luck. |
I read somewhere on the internet that it might be possible to do the same thing with excel, but i'm not sure.
|
Quote:
Please dont use Excel. Where do you plan to get the raw data from? Are you going to do it on a day by day basis, or write a program to go back and scrape it off the web? |
If you use Excel keep in mind that you can only have 65,000 rows per sheet and believe me 65000 horses is not much data.
You would enter about 15000 per month which would only give you about 4 months worth of data per sheet. Good Luck. |
Quote:
Cheers |
I now have ms access. How do i set it. What headings or info do i need to enter.
horse name track beaten margin weighyt limit weight jockey barrier track condition starting price |
My most baseic datbase has the following:
HORSENAME LASTSTARTS RATING LOCATION CONDITION FINISHED PRICEWIN PRICEPLACE WIN PLACE LASTSTART JOCKEY BARRIER WEIGHT SPECIALS OUTSIDECOUNT POSITIONRELATIVE FIELDSIZE BRATING DISTANCE STRAIGHT NUMBERHORSE PRIZEMONEY TOTALRACES TOTALWINS TOTALSECS TOTALTHIRDS WETRACES WETWINS WETSECS WETTHIRDS TRACKRACES TRACKWINS TRACKSECS TRACKTHIRDS DISTRACES DISTWINS DISTSECS DISTTHIRDS FIRSTRACES FIRSTWINS FIRSTSECS FIRSTTHIRDS LAST1FIELD LAST1LOCATION LAST1CONDITION LAST1DATE LAST1DIST LAST1CLASS LAST1JOCKEY LAST1BARRIER LAST1WEIGHT LAST1WINNER LAST1BL LAST1TIME LAST1TIMESECS LAST2FIELD LAST2LOCATION LAST2CONDITION LAST2DATE LAST2DIST LAST2CLASS LAST2JOCKEY LAST2BARRIER LAST2WEIGHT LAST2WINNER LAST2BL LAST2TIME LAST2TIMESECS LAST3FIELD LAST3LOCATION LAST3CONDITION LAST3DATE LAST3DIST LAST3CLASS LAST3JOCKEY LAST3BARRIER LAST3WEIGHT LAST3WINNER LAST3BL LAST3TIME LAST3TIMESECS LAST1POSITION LAST2POSITION LAST3POSITION LAST1PRICE LAST2PRICE LAST3PRICE WEIGHTRATING LASTSTARTRATING RATINGRATING MYRATING NUMBERRATING DTRACED DAYRACED RADIOTIP1 RADIOTIP2 RADIOTIP3 RADIOTIP4 OTHERTIP4 OTHERTIP3 OTHERTIP2 OTHERTIP1 OTHERTIPSTER LATEMAIL MARKETPERCENTAGE TOTALMARKET FIRSTUPPERS WINRANK APIRANK PLACERANK WINTIME TODAYSLOCATION LAST3TIMEADJUSTED LAST2TIMEADJUSTED LAST1TIMEADJUSTED AVGTIMEADJUSTED BESTTIMEADJUSTED BESTRANK AVGRANK LASTRANK Good Luck. |
umm...hey Wesmip1...
...I suspect Benny, the Mad Gambler, may have just pooped himself at the sight of your "most basic database."
|
You could cut that list pretty much in half as you are doubling up on information that is already in the database.
For instance records like, WETRACES, WETWINS, WETSECS, WETTHIRDS, TRACKRACES, TRACKWINS, TRACKSECS, TRACKTHIRDS dont need to be entered in each time you write to the databse as have already been entered in the databse previously and you can query the databse to get those results should you so desire. What i mean by that is there is no need for a specific field say WETWINS because if you want to find out how many times a horse has one in the wet you would query the database. Anyway, if you are serious, wesmip has given a pretty comprehensive list of the sorts of things you might want to keep records on, other than that start reading :) |
How do i set up each field?
|
Quote:
Look Benny, buy a "how to" guide to databases. To be able to help you, you have to know at least the basics. Even the help in MSAccess is a start. Believe me, I am not trying to be nasty or condescending. Good luck. |
Thanks to all I now have my datadase setup. Now do I record every hore in a race or just the place getters. I'm only going to record metro meetings only as that's when I do most of my betting.
|
many thanks goblin you in spired me i had newzealand race 5 no i think you know which one..that was the pointer next race was the one i put money on it was the winner......
|
Nice to see you have a win mate.
|
Quote:
|
All times are GMT +10. The time now is 01:36 PM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.