[AccessD] [SPAM] Re: The iPad is soooo cool (uhhh ok.)

Charlotte Foust charlotte.foust at gmail.com
Tue Oct 30 11:56:57 CDT 2012


Are you using dimension tables at all, John?  I'd think a hybrid snowflake
schema might help with that kind of grouping.

Charlotte

On Tue, Oct 30, 2012 at 7:04 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> If I didn't have time for iHumor I would go iCrazy.
>
> I am currently working on a system to build a data dictionary table and
> populate it for a given database.  Then I need to select which columns
> (fields) to count the data items in - a groupby / count query on all
> selected fields.
>
> The databases I use tend to have a ton of columns (277 fields in the one I
> am working on now), each column tends to have a 1/0, T/F or a limited range
> of codes 1-9 and a-z.  Unfortunately other columns have names, zips,
> address fields etc so I can't do a groupby on those fields or I will get
> tens of millions of counts - not the intention.
>
> So I build a data dictionary table which reads out the standard stuff -
>
>         [SchemaName]
>       ,[TableName]
>       ,[ColumnId]
>       ,[ColumnName]
>       ,[DataType]
>       ,[CharacterMaximumLength]
>       ,[ColumnDescription]
>       ,[ColumnDefault]
>       ,[IsNullable]
>
> plus a couple of extra fields of my own [PerformCount] and (denormalized)
> [CountInfo].
>
> I then populate that table, unselect the fields with things like names /
> addresses, then run a groupby/count on the remaining fields, updating the
> [CountInfo] with the resulting data.  Push it out to a spreadsheet and send
> to the customer.
>
> Keeps me busy.
>
>
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> On 10/30/2012 9:34 AM, jack drawbridge wrote:
>
>> iLike it John, but when do you get time... you always seem up to your
>> iBalls in real work.
>> jack
>>
>> On Tue, Oct 30, 2012 at 8:45 AM, jwcolby <jwcolby at colbyconsulting.com>**
>> wrote:
>>
>>  From:
>>>
>>> http://www.techradar.com/us/****news/phone-and-communications/****<http://www.techradar.com/us/**news/phone-and-communications/**>
>>> mobile-phones/apple-samsung-****smartphone-profits-add-up-to-****
>>> 106-percent-1108455<http://**www.techradar.com/us/news/**
>>> phone-and-communications/**mobile-phones/apple-samsung-**
>>> smartphone-profits-add-up-to-**106-percent-1108455<http://www.techradar.com/us/news/phone-and-communications/mobile-phones/apple-samsung-smartphone-profits-add-up-to-106-percent-1108455>
>>> >
>>>
>>>  Apple's sales may only be hampered by the fact that its 7.9-inch iPad
>>>>
>>> mini could be in short supply, as it has already sold out of its initial
>>> launch stock.  Customers who pre-order the WiFi model of an iPad mini
>>> online Monday face a two-week shipping wait time.
>>>
>>> Uhhh yep, they are soooo cool that Apple can't build enough for all the
>>> iFolks standing in those long iLines.
>>>
>>> My biggest concern is all of the poor iFolks standing in iLines in the
>>> northeast as the hurricane sweeps overhead.  You know they won't evacuate
>>> and lose their iPlace in iLine.  There are already reports of entire
>>> iLines
>>> of iDiots being washed out to sea.
>>>
>>> The upside is that the US average IQ is inching upwards.
>>>
>>> ;)
>>>
>>> BTW, before I even pressed send I was served with an iCease and iDesist
>>> for using the iCopyrighted phrase iFolks, iPlace and iLine.  For some
>>> reason iDiot wasn't included in the iCease and iDesist. iStrange!
>>>
>>> ;)
>>>
>>> OK, iBack to iWork.
>>>
>>> --
>>> John W. Colby
>>> Colby Consulting
>>>
>>> Reality is what refuses to go away
>>> when you do not believe in it
>>>
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/****mailman/listinfo/accessd<http://databaseadvisors.com/**mailman/listinfo/accessd>
>>> <http:**//databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
>>> >
>>> Website: http://www.databaseadvisors.****com<http://www.**
>>> databaseadvisors.com <http://www.databaseadvisors.com>>
>>>
>>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>


More information about the AccessD mailing list