Matches in SemOpenAlex for { <https://semopenalex.org/work/W2912484301> ?p ?o ?g. }
Showing items 1 to 87 of
87
with 100 items per page.
- W2912484301 abstract "Codd’s rule of entity integrity stipulates the existence of a primary key over every database table. That is, uniqueness and absence of null markers are enforced on the columns of the primary key. Key sets stipulate a generalized entity integrity rule that can be achieved on data sets where primary keys do not exist. Indeed, a key set means that different pairs of rows can be distinguished by unique non-null values on potentially different elements of the key set. While primary keys are a core feature of SQL databases, key sets have not been researched much at all. Our goal is to motivate the actual use of key sets in database systems. The use of key sets depends at least on the ability to identify those key sets that are meaningful in a given application domain, and to efficiently validate such key sets during the lifetime of the database. For this purpose, we analyze for the first time the performance of validating key sets in SQL experimentally, and also conduct experiments that provide insight on the time and size required to generate Armstrong relations for the implication of unary key sets by arbitrary key sets. Armstrong relations provide computational support for identifying key sets that are meaningful for a given application domain." @default.
- W2912484301 created "2019-02-21" @default.
- W2912484301 creator A5069839542 @default.
- W2912484301 creator A5079968544 @default.
- W2912484301 creator A5081905302 @default.
- W2912484301 date "2019-01-01" @default.
- W2912484301 modified "2023-09-23" @default.
- W2912484301 title "Simple SQL Validation of Generalized Entity Integrity" @default.
- W2912484301 cites W1526843800 @default.
- W2912484301 cites W2004699875 @default.
- W2912484301 cites W2043117781 @default.
- W2912484301 cites W2063645305 @default.
- W2912484301 cites W2087134747 @default.
- W2912484301 cites W2088916770 @default.
- W2912484301 cites W2171204442 @default.
- W2912484301 cites W2411740706 @default.
- W2912484301 cites W2811226145 @default.
- W2912484301 cites W2912656603 @default.
- W2912484301 cites W4244346042 @default.
- W2912484301 doi "https://doi.org/10.1007/978-3-030-12079-5_3" @default.
- W2912484301 hasPublicationYear "2019" @default.
- W2912484301 type Work @default.
- W2912484301 sameAs 2912484301 @default.
- W2912484301 citedByCount "0" @default.
- W2912484301 crossrefType "book-chapter" @default.
- W2912484301 hasAuthorship W2912484301A5069839542 @default.
- W2912484301 hasAuthorship W2912484301A5079968544 @default.
- W2912484301 hasAuthorship W2912484301A5081905302 @default.
- W2912484301 hasConcept C114614502 @default.
- W2912484301 hasConcept C124101348 @default.
- W2912484301 hasConcept C135598885 @default.
- W2912484301 hasConcept C177264268 @default.
- W2912484301 hasConcept C199360897 @default.
- W2912484301 hasConcept C203763787 @default.
- W2912484301 hasConcept C26517878 @default.
- W2912484301 hasConcept C33762810 @default.
- W2912484301 hasConcept C33923547 @default.
- W2912484301 hasConcept C38652104 @default.
- W2912484301 hasConcept C41008148 @default.
- W2912484301 hasConcept C45235069 @default.
- W2912484301 hasConcept C510870499 @default.
- W2912484301 hasConcept C77088390 @default.
- W2912484301 hasConcept C78023250 @default.
- W2912484301 hasConcept C80444323 @default.
- W2912484301 hasConceptScore W2912484301C114614502 @default.
- W2912484301 hasConceptScore W2912484301C124101348 @default.
- W2912484301 hasConceptScore W2912484301C135598885 @default.
- W2912484301 hasConceptScore W2912484301C177264268 @default.
- W2912484301 hasConceptScore W2912484301C199360897 @default.
- W2912484301 hasConceptScore W2912484301C203763787 @default.
- W2912484301 hasConceptScore W2912484301C26517878 @default.
- W2912484301 hasConceptScore W2912484301C33762810 @default.
- W2912484301 hasConceptScore W2912484301C33923547 @default.
- W2912484301 hasConceptScore W2912484301C38652104 @default.
- W2912484301 hasConceptScore W2912484301C41008148 @default.
- W2912484301 hasConceptScore W2912484301C45235069 @default.
- W2912484301 hasConceptScore W2912484301C510870499 @default.
- W2912484301 hasConceptScore W2912484301C77088390 @default.
- W2912484301 hasConceptScore W2912484301C78023250 @default.
- W2912484301 hasConceptScore W2912484301C80444323 @default.
- W2912484301 hasLocation W29124843011 @default.
- W2912484301 hasOpenAccess W2912484301 @default.
- W2912484301 hasPrimaryLocation W29124843011 @default.
- W2912484301 hasRelatedWork W118670021 @default.
- W2912484301 hasRelatedWork W1508684246 @default.
- W2912484301 hasRelatedWork W1596369110 @default.
- W2912484301 hasRelatedWork W1829462735 @default.
- W2912484301 hasRelatedWork W1994212309 @default.
- W2912484301 hasRelatedWork W2000765645 @default.
- W2912484301 hasRelatedWork W2049496693 @default.
- W2912484301 hasRelatedWork W206214475 @default.
- W2912484301 hasRelatedWork W2203920328 @default.
- W2912484301 hasRelatedWork W2346101662 @default.
- W2912484301 hasRelatedWork W2411740706 @default.
- W2912484301 hasRelatedWork W2734736394 @default.
- W2912484301 hasRelatedWork W2802709624 @default.
- W2912484301 hasRelatedWork W2898575261 @default.
- W2912484301 hasRelatedWork W2914417365 @default.
- W2912484301 hasRelatedWork W3080260318 @default.
- W2912484301 hasRelatedWork W3168935107 @default.
- W2912484301 hasRelatedWork W3193473889 @default.
- W2912484301 hasRelatedWork W75684040 @default.
- W2912484301 hasRelatedWork W8064756 @default.
- W2912484301 isParatext "false" @default.
- W2912484301 isRetracted "false" @default.
- W2912484301 magId "2912484301" @default.
- W2912484301 workType "book-chapter" @default.