Questions tagged [hierarchical-data]

Hierarchical data reflects a set of parent-child relationships. These can be found in a genealogy, a taxonomy, a list of requirements for parts assembly, and innumerably other instances. Methods for dealing with hierarchical data are often essential for data management and analysis.

Hierarchical data reflects a set of parent-child relationships. As Materials Resource Planning was developed by manufacturers in the 1950s, hierarchical data management emerged as a theoretical and practical discipline. A manufacturer uses the term Bill of Materials (BOM) for the set of items required to assemble a parent item; the term BOM was adopted by mathematicians and software developers, and it is used today in both realms.

Hierarchical data is ubiquitous and has called forth some of the most important and complex work of database management. It has also propelled object-oriented programming.

The key design element is recursion. Imagine starting at the trunk of a tree and visiting every leaf; this theoretical exercise would require an enormously large number of decision points occurring in a nested or recursive pattern. Requirements for this analysis are remarkably varied and have produced entire sub-disciplines of database design.

2030 questions
0
votes
1 answer

error in using the recursive CTE to get the folder path from a table in DB2?

I have a table with columns - OBJECT_ID, NAME, PARENT_CONTAINER_ID. This Table contains all the folder names and their ParentID. If the Parent ID is null then it's root folder. I need to pull a report of all the folders along with their full path.…
Venky.m
  • 101
  • 1
  • 8
0
votes
0 answers

can't feed the CIFAR100 to the caffe code that i have

I'm working on some project about image tagging and I'm new to caffe. I have a caffe code from one of the papers that i read about image tagging and the data set that is used for it, is CIFAR100. According to the code and layers structure, I have to…
0
votes
1 answer

get records whose child count is less than 2

I am working on tree based architecure. There is one table called user. I have providing schema of the table as follows: CREATE TABLE `user5` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `parent_id` int(11) NOT NULL, …
Yogesh k
  • 352
  • 1
  • 7
  • 22
0
votes
1 answer

Oracle Hierarchical query with multiple nodes

I have a View and a Table that has the following details: V_Mgmt DMId PMId TLId 1 1 1 1 1 2 1 2 3 2 3 4 2 3 5 2 4 6 T_ProjLevels TLId DevId …
SDR
  • 361
  • 1
  • 4
  • 20
0
votes
1 answer

Hierarchical query to find root and return singular path

I am working with a black box database which I did not create, nor can I edit. Also, this select query needs to run in jasper reports so I cannot write a stored procedure. I have an inventory system which uses a parent/child mapping table and…
0
votes
1 answer

Angular Telerik Kendo Grid Not displaying Data beyond first level

We're using Kendo Grid on Angular 5 project. In html, we have: For kendo-grid-column field="Property-A.Code" - Works But kendo-grid-column field="Property-B.Property-B-One.CodeName" - does NOT Work How can one access data that is 2 levels down in…
N. Kaufman
  • 81
  • 1
  • 2
  • 9
0
votes
0 answers

sqlite transform tree table (hierarchical) into a flat one

I'm quite stuck with this problem here and will highly appreciate any help. I need to transform a tree table / hierarchical like this: id name parent 1 aaa 2 bbb 1 3 ccc 1 4 ddd 2 5 …
Vlad
  • 181
  • 2
  • 10
0
votes
3 answers

R delete fathers row based on sons in hierarchycal data

I'm working with some data like these: id <- c(1,1,1,2,2,2,3,3,3,4,4) # fathers name <- c('a','b','k','b','e','g','e','f','k','f','u') # sons data <- data.frame(id,name) data > data id name 1 1 a 2 1 b 3 1…
s__
  • 9,270
  • 3
  • 27
  • 45
0
votes
1 answer

Flat BOM structure to hierarchical, detecting cycles in your tree / graph

I've got many<>many table which stores Bill Of Material hierarchy data like: id | childId a | b a | c c | d d | a I need to find closed loops, like in this case d points back to a, which breaks the system since some recursive functions would never…
Tom Raganowicz
  • 2,169
  • 5
  • 27
  • 41
0
votes
0 answers

Query Hierarchy

I have a Hierarchy problem. I have a four level Hierarchy and i need to take the user from the low level to see all the upper levels.I can take the hierarchy from the low level to the upper as you can see: select * from test1 **username** …
ctsinavos
  • 41
  • 4
0
votes
1 answer

Apache Axis2 application/json not return a well format json object

i have an API service deployed on wso2 enterprise integrator console that send a request on a db for a select. It returns the data of the hierarchical structure in xml format :
0
votes
0 answers

How to perform a scatterplot for cluster with drill in R?

With my data I did a cluster analysis for hierarchical data, now I would like to display the results interactively. I would like to perform with R a chart like the one below: Where A, B, C, and D represent my 4 clusters based on the two variables…
0
votes
1 answer

How to create logical constraints for a hierarchical tree in Neo4j

I have created a hierarchical tree to represent the organization chart of a company on Neo4j, which is like the picture below. Hierarchical Tree Each node can't have more than one incoming "Manage relation" and an employee can't manage someone who…
0
votes
1 answer

Testing for regional interaction effects using a hierarchical model in R

I want to test for voters' motives behind castig one's vote for a given party 'XY' and whether residence in a region makes a significant difference. The question is, do voters from region A (coded '1') significantly differ in their motives from…
0
votes
1 answer

Can we use analytic functions to retrieve parents and child in hierarchy?

I have the following data (a sample of real data, which is much bigger): id p_id 1 null 2 1 3 1 4 2 5 4 6 5 7 5 8 3 9 7 Would it be possible to use analytic function of SQL Server to get the following result (get the deepest hierarchy):…
Leo
  • 265
  • 1
  • 4
  • 18
1 2 3
99
100