How to store directory / hierarchy / tree structure in the database?

by

There are many ways to store hierarchies in SQL databases. Which one to choose depends on which DBMS product you use, and how the data will be used. As you have used the MSSQL2005 tag, I think you should start considering the “Adjacency List” model; if you find that it doesn’t perform well for your application, then have a look at Vadim Tropashko’s comparison which highlights differences between models with a focus on multiple performance characteristics.

More Related Contents:

  1. Date range overlapping check constraint
  2. “Prevent saving changes that require the table to be re-created” negative effects
  3. How can you represent inheritance in a database?
  4. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  5. What is the best way to create and populate a numbers table?
  6. Sql Server string to date conversion
  7. SQL Server query to find all permissions/access for all users in a database
  8. SQL Server IN vs. EXISTS Performance
  9. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  10. PIVOT in sql 2005
  11. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  12. Atomic UPSERT in SQL Server 2005
  13. Do I really need to use “SET XACT_ABORT ON”?
  14. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  15. SQL Server ORDER BY date and nulls last
  16. How to determine total number of open/active connections in ms sql server 2005
  17. How to remove accents and all chars a..z in sql-server?
  18. Find non-ASCII characters in varchar columns using SQL Server
  19. How to query values from xml nodes?
  20. How to query for Xml values and attributes from table in SQL Server?
  21. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  22. What happens to the primary key Id when it goes over the limit?
  23. What is the point of “Initial Catalog” in a SQL Server connection string?
  24. How do you kill all current connections to a SQL Server 2005 database?
  25. Milliseconds wrong when converting from XML to SQL Server datetime
  26. nvarchar(max) vs NText
  27. Convert UTC Milliseconds to DATETIME in SQL server
  28. Table Valued Function Killing My Query Performance
  29. @@ERROR and/or TRY – CATCH
  30. How to choose the clustered index in SQL Server?

Leave a Comment