2014
DOI: 10.1177/0165551514520943
|View full text |Cite
|
Sign up to set email alerts
|

SQL-based semantics for path expressions over hierarchical data in relational databases

Abstract: Hierarchical part-of relationships/aggregation structures and related queries are essential parts of information systems. However, relational database query languages do not explicitly support hierarchical relationships and queries. A hierarchical query may require a great number of join operations, which increases the effort in query formulation. Therefore, we propose path expressions in formulating hierarchical views over relational data because path expressions are a conventional and compact way to represen… Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
3
1
1

Citation Types

0
8
0

Year Published

2015
2015
2022
2022

Publication Types

Select...
5
1

Relationship

1
5

Authors

Journals

citations
Cited by 6 publications
(8 citation statements)
references
References 33 publications
(36 reference statements)
0
8
0
Order By: Relevance
“…The data obtained through the need assessment were analyzed with a percentage, and the data from the interviews were analyzed using the content analysis procedure. The important thing to obtaining information related to student needs for career counseling is reviews and suggestions from material experts and media experts following the development procedures carried out [26]. Measurements made on the experts use a Likert scale with a rating of 5 = highly feasible, score 4 = feasible, score 3 = moderately feasible, score 2 = less feasible, score 1 = unfeasible.…”
Section: Discussionmentioning
confidence: 99%
“…The data obtained through the need assessment were analyzed with a percentage, and the data from the interviews were analyzed using the content analysis procedure. The important thing to obtaining information related to student needs for career counseling is reviews and suggestions from material experts and media experts following the development procedures carried out [26]. Measurements made on the experts use a Likert scale with a rating of 5 = highly feasible, score 4 = feasible, score 3 = moderately feasible, score 2 = less feasible, score 1 = unfeasible.…”
Section: Discussionmentioning
confidence: 99%
“…This will lead to a great number of join operations, which increase the query response time. The path expressions are a conventional and compact way to represent hierarchical relationships by embedding them within SQL queries and compiling them to standard SQL [28]. The utilization of the path When comparing these sub-techniques, the second is evidently superior to the first in terms of reducing the storage space of the RDB and query response times.…”
Section: Model Mapping Techniquesmentioning
confidence: 99%
“…In the literature [12], the R tree optimization algorithm is used to achieve data mining. The coverage area and the blank part of the node are reduced by spatial clustering, and the efficiency of data mining is improved.…”
Section: Introductionmentioning
confidence: 99%