Archive | Data RSS feed for this section
By p medved

Converting the Closure Table from a Weak Entity

I’ve found the closure table very useful in cases where there is a high degree of interaction with hierarchy data. Recently I chose a closure table for shopping cart categories where categories could exist in multiple places in the hierarchy and furthermore an administrator could drag and drop categories anywhere in the hierarchy to rearrange […]

Continue reading

Trimming that hard to reach whitespace

Not all whitespace is created equal, and when LTRIM and RTRIM in T-SQL fails to remove leading and trailing space its easy to stare and panic.  Having worked on a lot of ETL pipelines and legacy databases lately I’ve encountered some pretty nasty data sources and eyebrow-raising moments. In one particular case, I encountered fields […]

Continue reading

Hierarchical Data: Rendering with Razor

I’ve walked through persisting hierarchical data via closure tables and then through abstracting the closure table in the application layer.  Now, we’ll look at rendering our hierarchy in an ASP.NET MVC 3 sample application using Razor. For the styling of the hierarchy I use jquery treeview which I quite like for its simplicity.  The typical approach […]

Continue reading

Hierarchical Data: Applying Data Structures

In my previous post I walked through persisting hierarchical data using closure tables.  While closure tables are a great technique for persistence we need a more approachable way to deal with the hierarchy in the application layer.  Since we are dealing with a hierarchy it stands to reason that we could benefit from a tree-like […]

Continue reading

Hierarchical Data: Persistence via Closure Table

Recently, I’ve been working with hierarchical data using closure tables.  The problem this technique solves for me is persisting hierarchical relationships of specific entities without any restriction on the size of the hierarchy and while providing a simple way to query the hierarchy.  Closure tables, above other solutions like path enumeration, maintain referential integrity.

Continue reading

Cubing IIS Logs

Using the data warehouse built in the <a title=”Data Warehousing IIS Logs” target=”_blank” href=””>previous post and SQL Server Analysis Services (SSAS) we can cube our log data.  The most compelling reason to create a data cube for the log data was to gain access to MDX (MultiDimensional eXpression). MDX comes with a great deal more built in […]

Continue reading

Data Warehousing IIS Logs

Previously, I discussed using LogParser 2.2 to load IIS logs into SQL Server. Continuing on with my prototype for reporting on IIS Log data, I roughed out a data warehouse for the log data – the schema is below.

Continue reading

Handling IIS Logs with Microsoft’s Log Parser

So you have a mountain of IIS logs, and you or someone in your organization is asking questions the answers to which might be found in that endless stream of log data.  There are many ways to analyze IIS logs, and there is certainly no compelling reason to reinvent the wheel here – its a […]

Continue reading