Stack Overflow
Stack Overflow

Questions tagged [hierarchical]

For issues relating to arranging data and/or resources in a hierarchy.

A hierarchy is an arrangement of items (objects, names, values, categories, resources, etc.) in which the items are represented as being "above," "below," or "at the same level as" one another. Abstractly, a hierarchy is simply an ordered set or an acyclic directed graph.

A hierarchy can link entities either directly or indirectly, and either vertically or horizontally. The only direct links in a hierarchy, insofar as they are hierarchical, are to one's immediate superior or to one of one's subordinates, although a system that is largely hierarchical can also incorporate alternative hierarchies. Indirect hierarchical links can extend "vertically" upwards or downwards via multiple links in the same direction, following a path. All parts of the hierarchy which are not linked vertically to one another nevertheless can be "horizontally" linked through a path by traveling up the hierarchy to find a common direct or indirect superior, and then down again.

568 questions
2
votes
1 answer

OBIEE 11g Hierarchical columns. How to accomplish what we would normally do with a union report

So we have a hierarchy relationship for phases of a process: Overall Phase |----Phase 1 |----Intermediate Phase | |----Phase 2 | |----Phase 3 |----Phase 4 Then we have many objects that go through these phases. These…
JCL
  • 189
  • 1
  • 2
  • 11
2
votes
2 answers

oracle hierarchical query nocycle and connect by root

Can somebody explain use of nocycle and connect by root clauses in hierarchical queries in oracle, also when we dont use 'start with' what is the order we get the rows, i mean when we don't use 'start with' we get lot many rows, can anybody explain…
ratsy
  • 575
  • 4
  • 7
  • 13
2
votes
2 answers

Hierarchical Memory allocator library for C++

My application is mostly organised in layers so I found that something like the APR memory pools would be the best way. While reading on SO about C++ placement new posts here & here, and a more generic C allocation question I was thinking about…
Steve Schnepp
  • 4,620
  • 5
  • 39
  • 54
2
votes
2 answers

Tree like Database For Orders SQL

![enter image description here][2]I am working on a database that will create a three-tier structure. The idea is going to look like this: 1st level: Order table Primary Key - OrderID 2nd Level: OrderlineItemHeader table Primary Key -…
Enrique Padilla
  • 21
  • 5
2
votes
2 answers

Parsing a hierarchical config file structure with Python

I'm using ConfigParser for a project with a configuration file that is getting to large. I plan to split it but maintain a central config file that points to the others. I haven't seen this in the documentation, but can ConfigParser handle a…
Jonathan Livni
  • 101,334
  • 104
  • 266
  • 359
2
votes
3 answers

Indented hierarchical table structure

I am trying to create a hierarchical display of nested tables, where each sub level is indented further from the parent. I'm open to using table or div. The closest I've come is below. It looks mostly correct in IE (except that the borders on the…
Sentinel
2
votes
2 answers

Is there a better way to hierarchically cluster in R?

I would like to do hierarchical clustering by row and then by column. I came up with this total hack of a solution: #! /path/to/my/Rscript --vanilla args <- commandArgs(TRUE) mtxf.in <- args[1] clusterMethod <- args[2] mtxf.out <- args[3] mtx <-…
Alex Reynolds
  • 95,983
  • 54
  • 240
  • 345
2
votes
1 answer

Duplicate Hierarchical Data to the same table - Oracle

How to duplicate hierarchical data to insert them at the same table, generating new Ids but keeping parent-child relationship
Nestor Mestanza
  • 21
  • 1
2
votes
0 answers

SQL - Sorting Hierarchical Data (Child -> Parent Relation)

I'm trying to elegantly show data which is very similar to file system structure. Table Legend: Learning Path - something like folder which can contain ExerciseSet or another child LearningPath ExerciseSet - something like file in file system…
artolini
  • 97
  • 1
  • 10
2
votes
2 answers

How to get the current substate and the parent state out of the Spring Statemachine?

I am running a hierachical Spring Statemachine and - after walking through the inital transitions into state UP with the default substate STOPPED - want to use statemachine.getState(). Trouble is, it gives me only the parent state UP, and I cannot…
onouv
  • 528
  • 1
  • 5
  • 12
2
votes
0 answers

PyMC3 Model Error When Using Einstein Sum

I have the following random intercept pymc3 (3.11.12) model, where X is (NxTxK) and y is (TxN). N is the number of groups, T the number of observations within each group and K is the number of predictors. with pm.Model() as model: gamma=…
Michael
  • 357
  • 1
  • 13
2
votes
3 answers

How to flatten a hierarchical data structure given parent child relationships in R

I have data that describes parent-child relationships: df <- tibble::tribble( ~Child, ~Parent, "Fruit", "Food", "Vegetable", "Food", "Apple", "Fruit", "Banana", "Fruit", "Pear", "Fruit", …
JasonAizkalns
  • 20,243
  • 8
  • 57
  • 116
2
votes
1 answer

modeling hierarchy/directory in a relational database

I would like to model a hierarchy/directory like what you see below, in a mysql table. You can see below the table schema I was thinking. However, the directory Im talking about would be comprised of 100.000 elements and the depth would be ~5-10…
nonouco
  • 1,170
  • 1
  • 13
  • 25
2
votes
1 answer

SQL get all children

So I have hierarchical data that is organized in departments, with each department having a parent department except for the top one. I now want to write a SELECT statement to select this hierarchical structure in a cumulative way. That means that…
WayneNani
  • 173
  • 1
  • 9
2
votes
1 answer

Hierarchical Forecasting using R

I am using fable package to forecast for hierarchical time series and depth of all nodes is not equal. Use case is, forecasting contacts at country -> state -> district level. Forecast values have to add up to country level when aggregated…
Balraj
  • 33
  • 2
1 2 3
…
37 38