Friday, January 30, 2004
Thursday, January 22, 2004
SIGMOD Record - web edition / December 2000 Exciting stuff!
At the bottom of the page, New TPC Benchmarks for Decision Support and Web Commerce.
I made a shot across the bow on using the TPCH benchmark as a suite for testing compliance with the new SQL enhancements. Seemed to fly, so it's been the bulk of my work the last few days. Currently parsing the answer sets so they can be imported into a cursor for comparison with results. This may sound trivial, but the results sets are non delimited data dumps with one record spanning 3-4 rows. I've found lots of opensource and academic uses of TPCH, but no one seems to make available the complied version of DB_GEN or a normalized set of answers. ARGH!
At the bottom of the page, New TPC Benchmarks for Decision Support and Web Commerce.
I made a shot across the bow on using the TPCH benchmark as a suite for testing compliance with the new SQL enhancements. Seemed to fly, so it's been the bulk of my work the last few days. Currently parsing the answer sets so they can be imported into a cursor for comparison with results. This may sound trivial, but the results sets are non delimited data dumps with one record spanning 3-4 rows. I've found lots of opensource and academic uses of TPCH, but no one seems to make available the complied version of DB_GEN or a normalized set of answers. ARGH!
Monday, January 19, 2004
Okay, busy blogging day...
Here is another along the lines of HotScripts.com and SourceForge. The Code Project - Free Source Code and Tutorials While I understand the need for a viable business model to emerge for Open Source to be the "One True Way", when I hit sites like this -- it boggles the mind to think of how much work is saved by utilizing OPC (other peoples code). You down with OPC?
Here is another along the lines of HotScripts.com and SourceForge. The Code Project - Free Source Code and Tutorials While I understand the need for a viable business model to emerge for Open Source to be the "One True Way", when I hit sites like this -- it boggles the mind to think of how much work is saved by utilizing OPC (other peoples code). You down with OPC?
The whispering wheel is an electrical motor turned inside out with a wheel mounted on it. This application is for a city bus in the Netherlands. The motor is the wheel, the only combustion engine is the generator that charges the batteries. Nice!
Thoughts From The Head Working on Xen (X#?), language developer extrodinaire...also the talking head for VBTV http://www.msdn.microsfot.com/vbtv
Microsoft Watch - News and Analysis on Microsoft Plans, People, Strategy and Products all things big fish oriented.
Funny:
Red vs Blue
An animated series made by dubbing over video game footage.
Funny and True!:
The Gematriculator! The Gematriculator is a service that uses the infallible methods of Gematria developed by Mr. Ivan Panin to determine how good or evil a web site or a text passage is.
My resume is about 58% evil. A track John Miller and I did for a .NET conference last year is 98% evil!
Buhahahaha!
Red vs Blue
An animated series made by dubbing over video game footage.
Funny and True!:
The Gematriculator! The Gematriculator is a service that uses the infallible methods of Gematria developed by Mr. Ivan Panin to determine how good or evil a web site or a text passage is.
My resume is about 58% evil. A track John Miller and I did for a .NET conference last year is 98% evil!
Buhahahaha!
Friday, January 16, 2004
TPC-H
After a few days of research, I finally found a set of benchmarks that can be used for validation of SQL results. I worked on the TCP-C benchmarks back in 96, they are more performance oriented. The TPC-H benchmark is Decision Support oriented -- so it focuses more on capabilities and validation than performance.
The source in in ANSI-C. I tried to create a solution in VS2k3, but it wouldn't build. Then I tried nmake, the command line util. The makefile that comes with the source lists a few flags that "need to be changed for Windows NT" -- but I found no documentation on how to do this. I found one message on DBForums.com from someone that ran into the same issues -- no response since Sep 2003.
So, Calvin to the rescue. He created a non .NET console project. This resulted in something that would build - but had a few errors.
Most of the errors were solved by adding TPCH;WIN32;SQLSERVER to the Preprocessor Definitions found under project Configuration Properties/C/C++/Preprocessor.
A few additional errors solved by defining variables that weren't resolving... sorry I don't have better notes -- but it was only 1 or 2. I'll make the revised source avail.
After a few days of research, I finally found a set of benchmarks that can be used for validation of SQL results. I worked on the TCP-C benchmarks back in 96, they are more performance oriented. The TPC-H benchmark is Decision Support oriented -- so it focuses more on capabilities and validation than performance.
The source in in ANSI-C. I tried to create a solution in VS2k3, but it wouldn't build. Then I tried nmake, the command line util. The makefile that comes with the source lists a few flags that "need to be changed for Windows NT" -- but I found no documentation on how to do this. I found one message on DBForums.com from someone that ran into the same issues -- no response since Sep 2003.
So, Calvin to the rescue. He created a non .NET console project. This resulted in something that would build - but had a few errors.
Most of the errors were solved by adding TPCH;WIN32;SQLSERVER to the Preprocessor Definitions found under project Configuration Properties/C/C++/Preprocessor.
A few additional errors solved by defining variables that weren't resolving... sorry I don't have better notes -- but it was only 1 or 2. I'll make the revised source avail.
Wednesday, January 07, 2004
Monday, January 05, 2004
First post, new blog. This time it will be different! ;)
Recent blogging finds:
Web Services for bloggers
Mostly MS PMs and Devs for ASP.NET
Recent blogging finds:
Web Services for bloggers
Mostly MS PMs and Devs for ASP.NET
Subscribe to:
Posts (Atom)
