Tree utilities in SQL Server 2000 and 2005, and OLAP implementations

Dan Radu

Rate me:

4.72/5 (25 votes)

19 Jul 2006CPOL11 min read

154.4K

3.3K

107

This article describes how to efficiently store and access tree structures in a SQL Server database, and how to use them in OLAP implementations.

sales.zip
- sales.txt
sqlscripts.zip
- script.OLAP_PREP.sql
- script.TREE_DB.sql
refreshsalescube.zip
- RefreshSalesCube
  - App.config
  - App.ico
  - AssemblyInfo.cs
  - bin
    - Release
      - Interop.DSO.dll
      - Interop.MSOLAPADMINLib2.dll
      - Interop.POMInterfaces.dll
      - Interop.VBA.dll
      - RefreshSalesCube.exe
      - RefreshSalesCube.exe.config
  - RefreshSalesCube.cs
  - RefreshSalesCube.csproj
  - RefreshSalesCube.csproj.user
  - RefreshSalesCube.sln
tree_util.zip
- tree_util
  - AssemblyInfo.cs
  - bin
    - tree_util.dll
  - Config.cs
  - Global.asax
  - Global.asax.cs
  - Global.asax.resx
  - index.asmx
  - index.asmx.cs
  - index.asmx.resx
  - tree.xsl
  - tree_util.csproj
  - tree_util.csproj.webinfo
  - tree_util.sln
  - Web.config

Microsoft Visual Studio Solution File, Format Version 8.00
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "tree_util", "http://localhost/tree_util/tree_util.csproj", "{E504DEB6-A681-4779-951D-BF6915C5FCAB}"
	ProjectSection(ProjectDependencies) = postProject
	EndProjectSection
EndProject
Global
	GlobalSection(SolutionConfiguration) = preSolution
		Debug = Debug
		Release = Release
	EndGlobalSection
	GlobalSection(ProjectConfiguration) = postSolution
		{E504DEB6-A681-4779-951D-BF6915C5FCAB}.Debug.ActiveCfg = Debug|.NET
		{E504DEB6-A681-4779-951D-BF6915C5FCAB}.Debug.Build.0 = Debug|.NET
		{E504DEB6-A681-4779-951D-BF6915C5FCAB}.Release.ActiveCfg = Release|.NET
		{E504DEB6-A681-4779-951D-BF6915C5FCAB}.Release.Build.0 = Release|.NET
	EndGlobalSection
	GlobalSection(ExtensibilityGlobals) = postSolution
	EndGlobalSection
	GlobalSection(ExtensibilityAddIns) = postSolution
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Dan Radu

Web Developer Telstra Internet

Australia

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Tree utilities in SQL Server 2000 and 2005, and OLAP implementations

License

Comments and Discussions