Matches in SemOpenAlex for { <https://semopenalex.org/work/W1153605103> ?p ?o ?g. }
Showing items 1 to 64 of
64
with 100 items per page.
- W1153605103 endingPage "104" @default.
- W1153605103 startingPage "99" @default.
- W1153605103 abstract "This chapter focuses on the keys used in a database. A key by definition is unique and cannot be null. The surrogate key is one of the most misunderstood concepts in relational database management systems (RDBMS), where its newer users fake surrogate keys with various proprietary autonumbering features in their database product. Autonumbering is an exposed physical locator and not a surrogate. Because a surrogate key acts like an index, it is created by the user, managed by the system, and never seen by a user, and thus it is never used in queries, DRI, or anything else that a user does. One of the two arguments usually made for machine-generated physical locators (“fake pointers”) is that a multicolumn key is so lengthy that performance is adversely affected. However, this argument only applies to certain implementations such as the FOREIGN KEY column(s) in the SQL Server family and the pointers used by Sybase SQL anywhere. The second argument for fake pointers is that a suitable natural key does not exist. However, a natural key has to exist according to the Law of Identity, although it might not be a suitable key due to its bad design." @default.
- W1153605103 created "2016-06-24" @default.
- W1153605103 creator A5066287408 @default.
- W1153605103 date "2010-01-01" @default.
- W1153605103 modified "2023-09-23" @default.
- W1153605103 title "Keys" @default.
- W1153605103 doi "https://doi.org/10.1016/b978-0-12-374722-8.00006-2" @default.
- W1153605103 hasPublicationYear "2010" @default.
- W1153605103 type Work @default.
- W1153605103 sameAs 1153605103 @default.
- W1153605103 citedByCount "0" @default.
- W1153605103 crossrefType "book-chapter" @default.
- W1153605103 hasAuthorship W1153605103A5066287408 @default.
- W1153605103 hasConcept C148730421 @default.
- W1153605103 hasConcept C163173736 @default.
- W1153605103 hasConcept C185592680 @default.
- W1153605103 hasConcept C199360897 @default.
- W1153605103 hasConcept C203763787 @default.
- W1153605103 hasConcept C24394798 @default.
- W1153605103 hasConcept C26517878 @default.
- W1153605103 hasConcept C26713055 @default.
- W1153605103 hasConcept C2984286706 @default.
- W1153605103 hasConcept C38652104 @default.
- W1153605103 hasConcept C41008148 @default.
- W1153605103 hasConcept C510870499 @default.
- W1153605103 hasConcept C55493867 @default.
- W1153605103 hasConcept C5655090 @default.
- W1153605103 hasConcept C77088390 @default.
- W1153605103 hasConcept C98184364 @default.
- W1153605103 hasConceptScore W1153605103C148730421 @default.
- W1153605103 hasConceptScore W1153605103C163173736 @default.
- W1153605103 hasConceptScore W1153605103C185592680 @default.
- W1153605103 hasConceptScore W1153605103C199360897 @default.
- W1153605103 hasConceptScore W1153605103C203763787 @default.
- W1153605103 hasConceptScore W1153605103C24394798 @default.
- W1153605103 hasConceptScore W1153605103C26517878 @default.
- W1153605103 hasConceptScore W1153605103C26713055 @default.
- W1153605103 hasConceptScore W1153605103C2984286706 @default.
- W1153605103 hasConceptScore W1153605103C38652104 @default.
- W1153605103 hasConceptScore W1153605103C41008148 @default.
- W1153605103 hasConceptScore W1153605103C510870499 @default.
- W1153605103 hasConceptScore W1153605103C55493867 @default.
- W1153605103 hasConceptScore W1153605103C5655090 @default.
- W1153605103 hasConceptScore W1153605103C77088390 @default.
- W1153605103 hasConceptScore W1153605103C98184364 @default.
- W1153605103 hasLocation W11536051031 @default.
- W1153605103 hasOpenAccess W1153605103 @default.
- W1153605103 hasPrimaryLocation W11536051031 @default.
- W1153605103 hasRelatedWork W1774882870 @default.
- W1153605103 hasRelatedWork W2023842778 @default.
- W1153605103 hasRelatedWork W2046797091 @default.
- W1153605103 hasRelatedWork W2078392118 @default.
- W1153605103 hasRelatedWork W2138869566 @default.
- W1153605103 hasRelatedWork W2368606217 @default.
- W1153605103 hasRelatedWork W2603135307 @default.
- W1153605103 hasRelatedWork W2774948251 @default.
- W1153605103 hasRelatedWork W2919129196 @default.
- W1153605103 hasRelatedWork W9978827 @default.
- W1153605103 isParatext "false" @default.
- W1153605103 isRetracted "false" @default.
- W1153605103 magId "1153605103" @default.
- W1153605103 workType "book-chapter" @default.