hierarchical data- persistence via closure table - the b^2 brand
DESCRIPTION
mysql hierachy clousure tableTRANSCRIPT
-
The B^2 BrandThe B^2 Brand
POSTSPOSTS
Enter keywords...DataData GeneralGeneral MVCMVC Professional DevelopmentProfessional Development WhitepaperWhitepaper Windows AzureWindows Azure
ABOUT.MEABOUT.ME BITBL.IT (PODCAST)BITBL.IT (PODCAST) FEEDBURNERFEEDBURNER .TUMBLR.TUMBLR
Hierarchical Data: Persistence via Closure Table | The B^2 Brand http://b2berry.com/2011/11/19/hierarchical-data-persistence-via-closure-table/
1 de 3 25/07/2015 7:58
-
POPULAR LATEST COMMENTS TAGS
Hierarchical Data: Persistence
via Closure Table
NOVEMBER 19, 2011
Hierarchical Data: Rendering
with Razor
NOVEMBER 20, 2011
Converting the Closure Table
from a Weak Entity
AUGUST 4, 2012
The Vacation State Machine
OCTOBER 30, 2011
Data Warehousing IIS Logs
JUNE 1, 2011
Hierarchical Data: Persistence viaClosure Table
NOVEMBER 19, 2011 BY B2BERRY 11 COMMENTS
Recently, Ive been working with hierarchical data using closure tables. The problem thistechnique solves for me is persisting hierarchical relationships of specific entities without anyrestriction 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.
In a series of posts about storing hierarchical data Im going to walk through implementing asolution for working with hierarchical data at the persistence layer, the application layer, and thepresentation layer. Well see what is necessary to persist the hierarchy in SQL Server 2008, howwe wrap the closure tables in the application, and how we build hierarchy in the user interface withMVC 3
Software Engineer, data enthusiast,
math literate and all around
technology nerd
Categories
Data (8)
MVC (2)
Professional Development (2)
Whitepaper (1)
Windows Azure (1)
Hierarchical Data: Persistence via Closure Table | The B^2 Brand http://b2berry.com/2011/11/19/hierarchical-data-persistence-via-closure-table/
2 de 3 25/07/2015 7:58
-
The B^2 Brand. Create a free website or blog at WordPress.com. The Headlines Theme.
Hierarchical Data: Persistence via Closure Table | The B^2 Brand http://b2berry.com/2011/11/19/hierarchical-data-persistence-via-closure-table/
3 de 3 25/07/2015 7:58