Databases - OHR

**quadrilla** · **01-10-09**, **10:30 PM**

I’ve imported into QlikView.

The main feature is speed, as all the data is in memory, any query takes less time than a click.

Raceform interactive can take anywhere between 5 and 15 minutes for a simple query and a couple of hours to infinity for anything remotely complex. RI is very one dimensional whereas QlikView can slice and dice data without limits - it's a BI Tool.

Early days, but if anyone has any questions or would like further information, I’ll let you know as this project progresses.

**Spook** · **01-10-09**, **10:32 PM**

And in English

**quadrilla** · **01-10-09**, **10:44 PM**

As the database will have every race and every detail about every runner, you can ask any question and you will have the answer, right on your screen within a keyclick.

http://www.qlikview.com/product/QT%2...20US%20ltr.pdf

**Spook** · **01-10-09**, **10:54 PM**

Now that sounds useful

**The Duke** · **02-10-09**, **12:25 PM**

Very interesting stuff Quad.

Keep us informed with any updates you can as this is definitley something which would benefit us speed freaks.

**quadrilla** · **24-10-09**, **10:38 AM**

Originally Posted by The Duke

Very interesting stuff Quad.

Keep us informed with any updates you can as this is definitley something which would benefit us speed freaks.

After a few problems with the RI raw data. Mainly small things like.
RI state " every race has a unique race number ". Well that's ******.

So, it's up and running now. Ask and you get ANY answer back, in a fraction of a second.

As an example. Show me every finishing time for Leicester over 7F. Takes two clicks of the mouse. Then drill down to G/F conditions takes another click.

Just wait until Spooks gets his hands on this. I'm planning a trip to CHL 14/15 and if Spook can meet me - I give him a laptop with this data base

**Retroneous** · **25-11-09**, **12:57 PM**

Superb stuff.

I've been toying with getting an RI subscription for a month, just so I can leech all of their AW results and information. Is it easy to export everything in one shot?

With the info exported, I'd pull it into my own database in order to manipulate it further. Just a matter of whether or not RI will let me say, select all races at Wolverhampton since 1989 and export it to a file or not.

**The Duke** · **26-11-09**, **12:10 AM**

Quad,

Have just installed Qlikview and I can immediatley see this is a very powerful tool which can be used to the advantage of people who store alot of data like us speed raters.

One thing I was wondering however, what would be the best way to start creating a database for my needs in the program?

Do you have any template files you would care to share my ole chum?

**Spook** · **26-11-09**, **12:19 AM**

Originally Posted by quadrilla

Just wait until Spooks gets his hands on this. I'm planning a trip to CHL 14/15 and if Spook can meet me - I give him a laptop with this data base

Spooks an impoverished student again these days and has the festival under review, but a laptop with a database does sound like to sort of thing that can tempt him out to play. Incidentally Q, I've lost that start up CD for that printer you let me have and can't operate the bleedin thing now as I've needed to move house since. Are there any ways of getting round this, as i think it had a unique code didn't it which seems to mean that the printer will only talk to that specific CD

**quadrilla** · **28-12-09**, **03:25 PM**

Duke and Spook.

Sorry guys' , for not replying. I've just seen your posts - I was away in California and Las Vegas for a few weeks.

Spook. If your printer is still not working, then please let me know.

Duke.

Do you have any template files you would care to share my ole chum?

QlikView imports any database or csv file. It's just a matter of a very simple mask ( Template ) - letting QlikView know what the fields are called.

I'm using some old RI Files - RI does not have the Conditions ( ie Good, Standard, Good to Soft etc ) as an export field - unless you have this field you are well and truly snookered - perhaps this is an intential error !!!

How are you getting on with QlikView ? Need any help ?

I was going to post some screen dumps but I don't think OHR will accept them. Failing this, I'll post them on TRF under Systems.

**quadrilla** · **31-12-09**, **03:26 PM**

QVJD01.jpg

**quadrilla** · **31-12-09**, **04:46 PM**

QVJC01.jpg

**lansdowne** · **08-01-10**, **09:00 AM**

After reading your interesting posts on KlikView I googled it.

The only KlikView I could find cost $4000!! are we talking about

the same prog?

Davey H

**quadrilla** · **08-01-10**, **04:12 PM**

Hopefully this is a better picture to show the current development.

Qlikview is currently available in 2 forms.

Free as a single personal user. Any development cannot be transfered or shared with other machines - this will be fine for most users. If you wish to purchase the full version at a cost of about £ 800.00 - files can be tranfered or shared.

I've included the current screen-shot for Gamla Stan, who was enquiring about holding Standard Times. Hopefully you can see on the middle right part of this screen, 4 standard times - Fortuna is my Standard, others are Racing Post , SSR and Mordin.

**quadrilla** · **08-01-10**, **04:39 PM**

Another couple of screen-shots.

Linfield 5f.

**givemeabreak** · **08-01-10**, **06:39 PM**

Blimey i was congratulating myself at getting calculations to work in excel

looks the business mate top work.

**Natagora** · **08-01-10**, **10:03 PM**

Thanks Quad, all looks terribly impressive but how does someone like myself with only above average excel skills go about constructing something of this size and importing all the required data.

Hello by the way!

**quadrilla** · **08-01-10**, **11:02 PM**

Originally Posted by Natagora

Thanks Quad, all looks terribly impressive but how does someone like myself with only above average excel skills go about constructing something of this size and importing all the required data.

Hello by the way!

Average Excel skills are just what is required. You get the power of Business Inteligence ( BI ) , valued at £ 800.00, for nothing - as a Personal License.

Importing existing data ( which can be from any type ) into QlikView takes seconds - I would estimate that 5 years racing data would take 80 seconds.
I'm importing 18 months worth in 20 seconds - some from RI export files, declarations scraped from RacingLife, standard times' from seperate files and some missing RI data from made-up files. Simple.

Creating the example screen-shots, you could do in a couple of hours. All the graphs are existing by selection of requested data.

It's all so easy and simple - the joy is the speed ( instant ) and the analysis is infinate.

QlikView only tells you what has happened in the past. I've another nugget for analysing current races.

Hi also. Hope that this is of interest.

**michael** · **11-02-10**, **12:02 PM**

Hi all
First post on this forum nice to see people sharing like this, have not done speed figures for a while now,but if the database is as good as you say it is then i may go back to doing them,the only reason i stopped doing before was not enough time to keep up the work of putting it all in the computer,it seems this will cut it down a lot being able to import most.
can you let me know What is the web address for it please,It will prob take me a time to go through all the info on here as well lots to look at.

be lucky
Michael

**The Duke** · **11-02-10**, **03:20 PM**

Hi Michael,

Welcome to the forums - I hope your stay here is long and prosperous.

You can find out more about Qlikview here: QlikView | QlikView Home Page

**michael** · **11-02-10**, **09:56 PM**

The Duke
Thanks for the welcome, went to the web site and downloaded it, see how it goes later, and hopefully it will be a long and prosperous relationship with this forum

be lucky

ps what is the vCash for

**michael** · **12-02-10**, **01:17 PM**

The Duke
just reading your post again, do you mean that you can put two or three different formats in when downloading into Qlik and it puts them where they are supposed to go in each column

be lucky

**The Duke** · **12-02-10**, **01:55 PM**

Hi Michael,

vCASH is fantasy currency which is generated by posting on the forums and just general getting involved. These can be used for the odd vBookie competition we might run during some special events for example the Cheltenham Festival in March.

As for Qlikview, I don't personally use it myself just yet, so Quadrilla would be best for advice.

**michael** · **12-02-10**, **02:40 PM**

Sorry not looking, hopefully Quadrilla will read and let me know

be lucky

**quadrilla** · **12-02-10**, **03:00 PM**

Originally Posted by michael

Sorry not looking, hopefully Quadrilla will read and let me know

be lucky

I've sent you a PM.

I'd like to answer this off-line.

01-10-09, 10:30 PM	#1 (permalink)
quadrilla Moderate Handicapper Join Date: Aug 2008 Location: La Quinta, California	Databases I’ve imported into QlikView. The main feature is speed, as all the data is in memory, any query takes less time than a click. Raceform interactive can take anywhere between 5 and 15 minutes for a simple query and a couple of hours to infinity for anything remotely complex. RI is very one dimensional whereas QlikView can slice and dice data without limits - it's a BI Tool. Early days, but if anyone has any questions or would like further information, I’ll let you know as this project progresses.

08-01-10, 09:00 AM	#13 (permalink)
lansdowne Claimer Join Date: Jan 2010 Location: WATFORD	KlikView After reading your interesting posts on KlikView I googled it. The only KlikView I could find cost $4000!! are we talking about the same prog? Davey H

11-02-10, 09:56 PM	#21 (permalink)
michael Low Grade Handicapper Join Date: Feb 2010 Location: Kent	The Duke Thanks for the welcome, went to the web site and downloaded it, see how it goes later, and hopefully it will be a long and prosperous relationship with this forum be lucky ps what is the vCash for Last edited by michael; 12-02-10 at 01:22 PM..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

01-10-09, 10:32 PM	#2 (permalink)
Spook World Class Join Date: Sep 2005	And in English

01-10-09, 10:44 PM	#3 (permalink)
quadrilla Moderate Handicapper Join Date: Aug 2008 Location: La Quinta, California	As the database will have every race and every detail about every runner, you can ask any question and you will have the answer, right on your screen within a keyclick. http://www.qlikview.com/product/QT%2...20US%20ltr.pdf

01-10-09, 10:54 PM	#4 (permalink)
Spook World Class Join Date: Sep 2005	Now that sounds useful

02-10-09, 12:25 PM	#5 (permalink)
The Duke The Iron Horse Join Date: Mar 2005 Twitter: @OHRacing Location: West Midlands	Very interesting stuff Quad. Keep us informed with any updates you can as this is definitley something which would benefit us speed freaks.

25-11-09, 12:57 PM	#7 (permalink)
Retroneous Group 1 Level Join Date: Mar 2009 Location: Exeter, Devon	Superb stuff. I've been toying with getting an RI subscription for a month, just so I can leech all of their AW results and information. Is it easy to export everything in one shot? With the info exported, I'd pull it into my own database in order to manipulate it further. Just a matter of whether or not RI will let me say, select all races at Wolverhampton since 1989 and export it to a file or not.

26-11-09, 12:10 AM	#8 (permalink)
The Duke The Iron Horse Join Date: Mar 2005 Twitter: @OHRacing Location: West Midlands	Quad, Have just installed Qlikview and I can immediatley see this is a very powerful tool which can be used to the advantage of people who store alot of data like us speed raters. One thing I was wondering however, what would be the best way to start creating a database for my needs in the program? Do you have any template files you would care to share my ole chum?

28-12-09, 03:25 PM	#10 (permalink)
quadrilla Moderate Handicapper Join Date: Aug 2008 Location: La Quinta, California	Duke and Spook. Sorry guys' , for not replying. I've just seen your posts - I was away in California and Las Vegas for a few weeks. Spook. If your printer is still not working, then please let me know. Duke. Do you have any template files you would care to share my ole chum? QlikView imports any database or csv file. It's just a matter of a very simple mask ( Template ) - letting QlikView know what the fields are called. I'm using some old RI Files - RI does not have the Conditions ( ie Good, Standard, Good to Soft etc ) as an export field - unless you have this field you are well and truly snookered - perhaps this is an intential error !!! How are you getting on with QlikView ? Need any help ? I was going to post some screen dumps but I don't think OHR will accept them. Failing this, I'll post them on TRF under Systems.

31-12-09, 03:26 PM	#11 (permalink)
quadrilla Moderate Handicapper Join Date: Aug 2008 Location: La Quinta, California	QVJD01.jpg

31-12-09, 04:46 PM	#12 (permalink)
quadrilla Moderate Handicapper Join Date: Aug 2008 Location: La Quinta, California	QVJC01.jpg

08-01-10, 06:39 PM	#16 (permalink)
givemeabreak World Class Join Date: Jul 2007	Blimey i was congratulating myself at getting calculations to work in excel looks the business mate top work.

08-01-10, 10:03 PM	#17 (permalink)
Natagora Claimer Join Date: May 2008	Thanks Quad, all looks terribly impressive but how does someone like myself with only above average excel skills go about constructing something of this size and importing all the required data. Hello by the way!

11-02-10, 12:02 PM	#19 (permalink)
michael Low Grade Handicapper Join Date: Feb 2010 Location: Kent	Hi all First post on this forum nice to see people sharing like this, have not done speed figures for a while now,but if the database is as good as you say it is then i may go back to doing them,the only reason i stopped doing before was not enough time to keep up the work of putting it all in the computer,it seems this will cut it down a lot being able to import most. can you let me know What is the web address for it please,It will prob take me a time to go through all the info on here as well lots to look at. be lucky Michael

11-02-10, 03:20 PM	#20 (permalink)
The Duke The Iron Horse Join Date: Mar 2005 Twitter: @OHRacing Location: West Midlands	Hi Michael, Welcome to the forums - I hope your stay here is long and prosperous. You can find out more about Qlikview here: QlikView \| QlikView Home Page

12-02-10, 01:17 PM	#22 (permalink)
michael Low Grade Handicapper Join Date: Feb 2010 Location: Kent	The Duke just reading your post again, do you mean that you can put two or three different formats in when downloading into Qlik and it puts them where they are supposed to go in each column be lucky

12-02-10, 01:55 PM	#23 (permalink)
The Duke The Iron Horse Join Date: Mar 2005 Twitter: @OHRacing Location: West Midlands	Hi Michael, vCASH is fantasy currency which is generated by posting on the forums and just general getting involved. These can be used for the odd vBookie competition we might run during some special events for example the Cheltenham Festival in March. As for Qlikview, I don't personally use it myself just yet, so Quadrilla would be best for advice.

12-02-10, 02:40 PM	#24 (permalink)
michael Low Grade Handicapper Join Date: Feb 2010 Location: Kent	Sorry not looking, hopefully Quadrilla will read and let me know be lucky

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)