Re: the distinction between data and intelligence

"Kenneth Downs" <knode.wants.this_at_see.sigblock> wrote in message news:38u3p2-clp.ln1_at_pluto.downsfam.net...
> mountain man wrote:
>
>> "Kenneth Downs" <knode.wants.this_at_see.sigblock> wrote in message
>> news:7a30p2-ak7.ln1_at_pluto.downsfam.net...
>>> mountain man wrote:
>>
>>>> Here's a question for you, and anyone into developing
>>>> code within a project that involves change management
>>>> of this code suite over some years ....
>>>>
>>>> Do you build a simple stats history data table for each
>>>> of the code modules? ie: whenever code is invoked
>>>> by a user, this is logged to a table (procid, userid,
>>>> datetime).
>>>>
>>>
>>> Nope.
>>
>>
>> This information can sometimes be handy in order
>> to map and quantify the demographics of use of the
>> elements of the suite.
>>
>>
>>
>
> Not in my case. To map use we look at change logs on tables and columns.
> Since the code is tied directly to the definitions of columns and table,
> measuring one gives a measure of the other.
>

Yes, such logs are handy for many things. I have seen situations however where uncontrolled development had occurred and there were many different program objects being used for update and enquiry. In this instance, a log on the code useage helped rationalise the code, since the data logs did not contain an identity for the code used.

Have you ever put in place a rowcounter history table for the database, containing table name, table row count and datetimestamp as at some routine time each day? See link below for surther info.

-- 
Pete Brown
IT Managers & Engineers
Falls Creek
Australia
http://www.mountainman.com.au/software/Winluck/row_counter.html