Matches in SemOpenAlex for { <https://semopenalex.org/work/W1561348834> ?p ?o ?g. }
Showing items 1 to 93 of
93
with 100 items per page.
- W1561348834 abstract "In commercial network database management systems, set-valued fields and aggregate functions are commonly supported. However, the relational database model, as defined by Codd, does not include sex-valued attributes or aggregate functions. Recently, Klug extended the relational model by incorporating aggregate functions and by defining relational algebra and calculus languages.In this thesis, relational calculus database query language (as defined by Klug) is extended to manipulate set-valued attributes and to utilize aggregate functions. The expressive power of the extended language is shown to be equivalent to the extended relational algebra (ERA) of Ozsoyoglu and Ozsoyoglu which includes three new operators, namely, pack, unpack and aggregation-by-template. The extended languages form a theoretical framework for statistical database query languages.Summary-Table-by-Example (STBE) is a graphical, user friendly language based in the extended relational calculus. STBE, suitable for statistical database applications, permits queries with a hierarchical subquery structure, and manipulates relations with set-valued attributes and summary tables.The hierarchical arrangement of STBE queries naturally implies a tuple-by-tuple subquery evaluation strategy (similar to the nested loops join implementation technique) which may not be the best query processing strategy. In this thesis we discuss the query processing techniques used in STBE. We first convert an STBE query into an extended relational algebra expression using techniques similar to those proposed for removing the nesting from SQL queries. Two transformations are introduced to remove the hierarchical arrangement of subqueries so that query optimization is possible. To solve the empty partition problem of aggregate function evaluation, directional join (one-sided outer-join) is utilized. We then give the algebraic properties of the ERA operators to obtain an improved ERA expression. Finally we list alternative access paths and their cost formulas for obtaining an access path with the smallest cost. In addition to revising the access paths from SQL and ABE (Aggregates-By-Example) for STBE, new access paths for the ERA operators pack, unpack, and the aggregate-by-template are presented." @default.
- W1561348834 created "2016-06-24" @default.
- W1561348834 creator A5034808531 @default.
- W1561348834 date "1986-06-01" @default.
- W1561348834 modified "2023-09-28" @default.
- W1561348834 title "Extensions to the relational data model model for statistical database applications" @default.
- W1561348834 hasPublicationYear "1986" @default.
- W1561348834 type Work @default.
- W1561348834 sameAs 1561348834 @default.
- W1561348834 citedByCount "0" @default.
- W1561348834 crossrefType "journal-article" @default.
- W1561348834 hasAuthorship W1561348834A5034808531 @default.
- W1561348834 hasConcept C118615104 @default.
- W1561348834 hasConcept C118930307 @default.
- W1561348834 hasConcept C148840519 @default.
- W1561348834 hasConcept C157692150 @default.
- W1561348834 hasConcept C159985019 @default.
- W1561348834 hasConcept C164120249 @default.
- W1561348834 hasConcept C16739119 @default.
- W1561348834 hasConcept C177264268 @default.
- W1561348834 hasConcept C192028432 @default.
- W1561348834 hasConcept C192562407 @default.
- W1561348834 hasConcept C194222762 @default.
- W1561348834 hasConcept C199360897 @default.
- W1561348834 hasConcept C23123220 @default.
- W1561348834 hasConcept C24394798 @default.
- W1561348834 hasConcept C33923547 @default.
- W1561348834 hasConcept C40207289 @default.
- W1561348834 hasConcept C41008148 @default.
- W1561348834 hasConcept C4679612 @default.
- W1561348834 hasConcept C510870499 @default.
- W1561348834 hasConcept C54239708 @default.
- W1561348834 hasConcept C5655090 @default.
- W1561348834 hasConcept C65647387 @default.
- W1561348834 hasConcept C77088390 @default.
- W1561348834 hasConcept C80444323 @default.
- W1561348834 hasConcept C95916125 @default.
- W1561348834 hasConcept C97854310 @default.
- W1561348834 hasConcept C99436015 @default.
- W1561348834 hasConceptScore W1561348834C118615104 @default.
- W1561348834 hasConceptScore W1561348834C118930307 @default.
- W1561348834 hasConceptScore W1561348834C148840519 @default.
- W1561348834 hasConceptScore W1561348834C157692150 @default.
- W1561348834 hasConceptScore W1561348834C159985019 @default.
- W1561348834 hasConceptScore W1561348834C164120249 @default.
- W1561348834 hasConceptScore W1561348834C16739119 @default.
- W1561348834 hasConceptScore W1561348834C177264268 @default.
- W1561348834 hasConceptScore W1561348834C192028432 @default.
- W1561348834 hasConceptScore W1561348834C192562407 @default.
- W1561348834 hasConceptScore W1561348834C194222762 @default.
- W1561348834 hasConceptScore W1561348834C199360897 @default.
- W1561348834 hasConceptScore W1561348834C23123220 @default.
- W1561348834 hasConceptScore W1561348834C24394798 @default.
- W1561348834 hasConceptScore W1561348834C33923547 @default.
- W1561348834 hasConceptScore W1561348834C40207289 @default.
- W1561348834 hasConceptScore W1561348834C41008148 @default.
- W1561348834 hasConceptScore W1561348834C4679612 @default.
- W1561348834 hasConceptScore W1561348834C510870499 @default.
- W1561348834 hasConceptScore W1561348834C54239708 @default.
- W1561348834 hasConceptScore W1561348834C5655090 @default.
- W1561348834 hasConceptScore W1561348834C65647387 @default.
- W1561348834 hasConceptScore W1561348834C77088390 @default.
- W1561348834 hasConceptScore W1561348834C80444323 @default.
- W1561348834 hasConceptScore W1561348834C95916125 @default.
- W1561348834 hasConceptScore W1561348834C97854310 @default.
- W1561348834 hasConceptScore W1561348834C99436015 @default.
- W1561348834 hasLocation W15613488341 @default.
- W1561348834 hasOpenAccess W1561348834 @default.
- W1561348834 hasPrimaryLocation W15613488341 @default.
- W1561348834 hasRelatedWork W1482832319 @default.
- W1561348834 hasRelatedWork W1493271454 @default.
- W1561348834 hasRelatedWork W1505238579 @default.
- W1561348834 hasRelatedWork W1583690292 @default.
- W1561348834 hasRelatedWork W176014370 @default.
- W1561348834 hasRelatedWork W2021872018 @default.
- W1561348834 hasRelatedWork W2024087068 @default.
- W1561348834 hasRelatedWork W2098946490 @default.
- W1561348834 hasRelatedWork W2110918077 @default.
- W1561348834 hasRelatedWork W2113447855 @default.
- W1561348834 hasRelatedWork W2121620992 @default.
- W1561348834 hasRelatedWork W2123169291 @default.
- W1561348834 hasRelatedWork W2125198136 @default.
- W1561348834 hasRelatedWork W2126942675 @default.
- W1561348834 hasRelatedWork W2135215612 @default.
- W1561348834 hasRelatedWork W2138615052 @default.
- W1561348834 hasRelatedWork W2149156919 @default.
- W1561348834 hasRelatedWork W2149532506 @default.
- W1561348834 hasRelatedWork W2769068082 @default.
- W1561348834 hasRelatedWork W3193781380 @default.
- W1561348834 isParatext "false" @default.
- W1561348834 isRetracted "false" @default.
- W1561348834 magId "1561348834" @default.
- W1561348834 workType "article" @default.