4/28/14 UPDATE: the original thread on LinkedIn for this topic continues to draw useful comments regarding serious implementations/requirements. Take another read on it as time permits.
I honed in on an interesting thread on the Omniture Enthusiasts group on LinkedIn. The topic author, Nicholas, asks: “Has anyone has implemented a SiteCatalyst Clickstream Database solution?” The thread has turned into an interesting conversation, and another active participant has posted an R package at GitHub to faciliate this type of data movement and analysis. Turns out that it is possible to have a daily dump of clickstream data sent similar to a Data Warehouse data file for further processing. Hmmm – what an intriguing possibility.