Most voted "hierarchical-data" questions
The hierarchical database is based on an Entity and Relationship Model; where each record is a group (collection) of attributes (fields), and each containing only one information; whereas, a link is the association (link) between two records.
Learn more…11 questions
Sort by count of
-
42
votes3
answers6498
viewsHow to model a tree data structure using a relational database?
How to appropriately and efficiently define naturally organized tree-based data in relational databases, considering the physical implications of this? That is, organize in a way that minimizes the…
-
2
votes1
answer81
viewsUpdating hierarchical data using hierarchyId
Hello. I have the following table in SQL Server 2008 The goal is to update the Value field on a child and accumulate in the parent. For example: If in the id record 12 I put the value 31 in the…
-
2
votes1
answer161
viewsAdd javascript plugins at angular 7
I’m trying to plot a hierarchy chart on the page using a plugin Angular from this tutorial. Even looking at the demo and trying to put them that way When I load the page, the page does not work...…
-
2
votes0
answers20
viewsPlot Dendrogram X-axis with TF-IDF
I’m trying to plot Dendrograma with data that was vectored by TF-idf, however the axis x always presents me with numbers. I would like to know how to move to the Graphics Labels option, the real…
python matplotlib machine-learning hierarchical-data clusterizationasked 3 years, 6 months ago CH97 21 -
1
votes0
answers426
viewsBest way to work with hierarchical data in Mysql for a system with constant register in the hierarchy
I have a table where I store user registration where each user was indicated by another user, so I keep a column ID and a column PARENT_ID. There are 2 ways to work with hierarchy in Mysql, are…
-
1
votes2
answers54
viewshierarchyid, remove children from one node and assign to another node
I have a user table, with the use of hierarchyid, I need to remove all Subordinate Users from User 1 and assign them to User 2. SELECT US.cd_usuario ,(SELECT cd_usuario FROM USUARIO USR WHERE…
-
1
votes0
answers44
viewsDoubt with hierarchical data
Talk, you guys, all right ? I have a problem already have a few days , in the system I need to control the display of some data, I have a function registration , sector and employee, linked between…
-
0
votes1
answer251
viewsTo repeat the value of a field in another field in select SQL Server
I have a table where there are the fields: Personal, Name and Personal (which indicates that she is someone else’s daughter from the table. and if she is the father, that field is null). I need to…
-
0
votes0
answers25
viewsHierarchical data. What would be the most appropriate ER Diagram to implement a Labels system like Gmail?
Something related to hierarchical data. I am implementing a Labels system for messaging a website that is similar to the gmail Labels system. This is the short ER. A message may have one or more…
-
0
votes0
answers80
viewsHow to return materials from a product or product levels with PL/SQL
I have a table that contains products and each product has other products that are used to manufacture. The products that are used to manufacture the parent product, can also be manufactured and…
-
-2
votes3
answers404
viewsCategory and Subcategory Sum with PHP and MYSQL
I already broke my head and I’m lost in finding the solution to my problem, I’m developing a financial report that has categories and subcategory (7 levels) Below is the structure of part of my…