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
0 answers

Excel formula for hierarchical data analysis Excel 2010

I am trying to write an Excel formula that will take data and look at the starting type and then ending type and then depending on the final type will decide on what worksheet, column and row it will go into. I want to set a priority system so if it…
0
votes
2 answers

SQL Server Tree Query

I need some help is MS SQL Server Query. I’m not much of a DBA. I have an application with an Organization Table which is made up of a parent-child relationship: CREATE TABLE [dbo].[Organizations]( [OrgPK] [int] IDENTITY(1,1) NOT NULL, …
RWBear
  • 233
  • 5
  • 16
0
votes
0 answers

How can I change hierarchy database record to java object?

I have hierarchy database record like following (0 means it doesn't have any parent) parent_no no 0 1 1 11 1 12 11 111 0 2 2 21 21 211 I'm currently developing one api using…
JoonT
  • 1,106
  • 1
  • 13
  • 29
0
votes
0 answers

Convert flat data to hierarchical class C#

I am wondering to get hierarchical structure of those class class Tree { public string Name { get; set; } public string Parent { get; set; } } I collect data to list of object of Class Tree List tree = new List(); One of those…
Alexandre
  • 3
  • 3
0
votes
1 answer

SQL Loop Update

So here is the deal. I got what we call "ProjectIDs" which is a field in our database (Primary Key) we have 2 fields that need to be updated based on information that is within the project IDs. For example: I might have a project ID 00068: This…
GrafixMastaMD
  • 139
  • 5
  • 15
0
votes
2 answers

How to display list data in tree structure in Java?

I have an arrayList and I want to display in a hierarchal structure. I want the results to look like this. If it doesn't have any child nodes I want the item indented with a hyphen: User Design Lectures Week 1 -Apr 5 …
user2100620
  • 311
  • 2
  • 5
  • 17
0
votes
1 answer

Get Category Level

In MySql I have category table with fields: cat_id (int) cat_parent_id (int) cat_name (string) How to create query that return list off all categoryes with coresponded level number cat parent_id for root nodes is 0 sample SQL Fiddle with sample…
Jernej Pirc
  • 504
  • 1
  • 4
  • 13
0
votes
1 answer

what is best way to recursive update mysql using php

im not good at php and mysql but i know some,, my problem is that i want to update an 2 million row (in the future, but for now i only have around few data). 1 i have this table: ID BAnumber DateEntry Parent Side LastA LastB 1 10001 …
Darvin
  • 21
  • 7
0
votes
1 answer

How to get list of step siblings in postgres?

Following is my schema :- postgres=# \d check_user; Table "public.check_user" Column | Type | Modifiers --------+---------+--------------------------------------------------------- id |…
Mangu Singh Rajpurohit
  • 10,806
  • 4
  • 68
  • 97
0
votes
0 answers

Solr search and facet by hierarchical category, subcategory

I have categories like: auto, tools & travel auto, tools & travel > luggage tags auto, tools & travel > luggage tags > luggage spotters auto, tools & travel > luggage tags > something else auto, tools & travel > car organizers Products are…
Mainuddin
  • 416
  • 5
  • 15
0
votes
2 answers

ABP AppService for hierarchical data

I need an AppService to load a treeview with a recursive collection of entities like these: ===Products=== Id Description Price Products[] ====> Id Description Price Products[] ====> Id …
pinale
  • 2,060
  • 6
  • 38
  • 72
0
votes
1 answer

How to convert tidy hierarchical data frame to hierarchical list grid in R?

This is a more complex version of a previous question where I had abstracted the actual problem too much to apply the answers. R convert tidy hierarchical data frame to hierarchical list I've converted a hierarchical data frame with two grouping…
Peter
  • 11,500
  • 5
  • 21
  • 31
0
votes
2 answers

R convert tidy hierarchical data frame to hierarchical list

Converting this g1 g2 desc val A a 1 v1 A a 2 v2 A b 3 v3 To: desc val A a 1 v1 2 v2 b 3 v3 I've converted a hierarchical data frame with two grouping levels into a structured…
Peter
  • 11,500
  • 5
  • 21
  • 31
0
votes
1 answer

Sort a tree data structure

I have a table like this: CREATE TABLE tree ( id integer NOT NULL, name character varying(50) NOT NULL, parentid integer, displayorder integer NOT NULL, CONSTRAINT tree_id PRIMARY KEY (id) ) The displayorders are relative in the same…
moc
  • 76
  • 8
0
votes
1 answer

How to parse multi-level XML in Kenitco

I have a web service that's passing and XML file to my Kentico site. The file looks something like this:
John
Clint Warner
  • 1,265
  • 1
  • 9
  • 25
1 2 3
99
100