Matches in SemOpenAlex for { <https://semopenalex.org/work/W3021194031> ?p ?o ?g. }
Showing items 1 to 76 of
76
with 100 items per page.
- W3021194031 endingPage "34" @default.
- W3021194031 startingPage "17" @default.
- W3021194031 abstract "The chapter discusses adjacent list models used in databases. The chapter describes a method for showing hierarchies in SQL that consists of a column for the boss and another column for the employee in a relationship. It is a direct implementation in a table of the adjacency list model of a graph. Oracle is the first commercial database to use SQL, and the sample database that comes with their product, nicknamed the “Scott/Tiger” database in the trade because of its default user and password codes, uses an adjacency list model in a combination Personnel/Organizational chart table. The organizational structure and the personnel data are mixed together in the same row. This model is popular as it is the most natural way to convert from an IMS database or from a procedural language to SQL. The simple adjacency list model is not a normalized schema. A normalized schema has no data redundancy and is safe from data anomalies. The chapter proposes three characteristics required in a data model. First, that the typical adjacency list model table includes information about the node, as well as who the boss in each row is. The second characteristic is that each fact appears in one place in the schema, but the subtree of each node can be in more than one row. The third characteristic is that each fact appears one time in the schema. Violations of these conditions result in anomalies. The chapter lists down the fundamental problems of adjacency list models and provide solutions to these problems." @default.
- W3021194031 created "2020-05-13" @default.
- W3021194031 creator A5066287408 @default.
- W3021194031 date "2004-01-01" @default.
- W3021194031 modified "2023-09-25" @default.
- W3021194031 title "Adjacency List Model" @default.
- W3021194031 doi "https://doi.org/10.1016/b978-155860920-4/50003-9" @default.
- W3021194031 hasPublicationYear "2004" @default.
- W3021194031 type Work @default.
- W3021194031 sameAs 3021194031 @default.
- W3021194031 citedByCount "0" @default.
- W3021194031 crossrefType "book-chapter" @default.
- W3021194031 hasAuthorship W3021194031A5066287408 @default.
- W3021194031 hasConcept C110484373 @default.
- W3021194031 hasConcept C11413529 @default.
- W3021194031 hasConcept C124101348 @default.
- W3021194031 hasConcept C127413603 @default.
- W3021194031 hasConcept C135598885 @default.
- W3021194031 hasConcept C148840519 @default.
- W3021194031 hasConcept C150012506 @default.
- W3021194031 hasConcept C190703929 @default.
- W3021194031 hasConcept C199360897 @default.
- W3021194031 hasConcept C23123220 @default.
- W3021194031 hasConcept C2777020290 @default.
- W3021194031 hasConcept C30775581 @default.
- W3021194031 hasConcept C41008148 @default.
- W3021194031 hasConcept C510870499 @default.
- W3021194031 hasConcept C52146309 @default.
- W3021194031 hasConcept C55166926 @default.
- W3021194031 hasConcept C55596503 @default.
- W3021194031 hasConcept C56310702 @default.
- W3021194031 hasConcept C5655090 @default.
- W3021194031 hasConcept C77088390 @default.
- W3021194031 hasConcept C78519656 @default.
- W3021194031 hasConcept C80444323 @default.
- W3021194031 hasConceptScore W3021194031C110484373 @default.
- W3021194031 hasConceptScore W3021194031C11413529 @default.
- W3021194031 hasConceptScore W3021194031C124101348 @default.
- W3021194031 hasConceptScore W3021194031C127413603 @default.
- W3021194031 hasConceptScore W3021194031C135598885 @default.
- W3021194031 hasConceptScore W3021194031C148840519 @default.
- W3021194031 hasConceptScore W3021194031C150012506 @default.
- W3021194031 hasConceptScore W3021194031C190703929 @default.
- W3021194031 hasConceptScore W3021194031C199360897 @default.
- W3021194031 hasConceptScore W3021194031C23123220 @default.
- W3021194031 hasConceptScore W3021194031C2777020290 @default.
- W3021194031 hasConceptScore W3021194031C30775581 @default.
- W3021194031 hasConceptScore W3021194031C41008148 @default.
- W3021194031 hasConceptScore W3021194031C510870499 @default.
- W3021194031 hasConceptScore W3021194031C52146309 @default.
- W3021194031 hasConceptScore W3021194031C55166926 @default.
- W3021194031 hasConceptScore W3021194031C55596503 @default.
- W3021194031 hasConceptScore W3021194031C56310702 @default.
- W3021194031 hasConceptScore W3021194031C5655090 @default.
- W3021194031 hasConceptScore W3021194031C77088390 @default.
- W3021194031 hasConceptScore W3021194031C78519656 @default.
- W3021194031 hasConceptScore W3021194031C80444323 @default.
- W3021194031 hasLocation W30211940311 @default.
- W3021194031 hasOpenAccess W3021194031 @default.
- W3021194031 hasPrimaryLocation W30211940311 @default.
- W3021194031 hasRelatedWork W1491668897 @default.
- W3021194031 hasRelatedWork W2019086993 @default.
- W3021194031 hasRelatedWork W2087376388 @default.
- W3021194031 hasRelatedWork W250356548 @default.
- W3021194031 hasRelatedWork W2587157981 @default.
- W3021194031 hasRelatedWork W2903518539 @default.
- W3021194031 hasRelatedWork W3021194031 @default.
- W3021194031 hasRelatedWork W604023535 @default.
- W3021194031 hasRelatedWork W1825479138 @default.
- W3021194031 hasRelatedWork W1963537333 @default.
- W3021194031 isParatext "false" @default.
- W3021194031 isRetracted "false" @default.
- W3021194031 magId "3021194031" @default.
- W3021194031 workType "book-chapter" @default.