Matches in SemOpenAlex for { <https://semopenalex.org/work/W47393961> ?p ?o ?g. }
Showing items 1 to 81 of
81
with 100 items per page.
- W47393961 endingPage "346" @default.
- W47393961 startingPage "337" @default.
- W47393961 abstract "There is a growing need to combine traditional relational data with new object feature into one integrated systems called as object-relational database management system (ORBMS) (Dorsey and Hudicka, 1999; Taniar, Rahayu and Srivastava, 2003). ORBMS is built based on SQL3 model, which consist object data types, row types, collection and abstract data types along with basic relational models (Carey, 1992; Stonebraker and Moore, 1996; Fuh et al., 1999; Taniar, Rahayu and Srivastava, 2003). The advantage of database applying SQL3 model is that the system is more flexible and massive scalability so that the immediate changes in the business process can be accommodated fast and easily (Fuh et al., 1999; Taniar, Rahayu and Srivastava, 2003). REF is one of essential data structures which have been introduced in Object-Relational Databases serves as a logical pointer to define the link between two tables (Taniar, Rahayu and Srivastava, 2003). This logical pointer has similar function to pointers in object oriented programming approach. There are three ways of writing REF join queries which are: REF Join, Path Expression Join, and DEREF/VALUE Join. REF Join is the most straightforward method to write Object-Relational queries where the REF data structure is used in the SQL statement to retrieve the REF value (not real data) stored in the ref attribute. Different with REF join, the final result of a Path expression join is the real data taken directly from the referred attribute. Finally, the DEREF/VALUE join method retrieves data from the actual object itself rather than from the table as the other two methods do (Loney and Koch, 2000; Oracle, 2002). Query optimization is the most important stage in query processing where the database optimizer has to choose a query-evaluation plan with minimized cost and maximized" @default.
- W47393961 created "2016-06-24" @default.
- W47393961 creator A5018549791 @default.
- W47393961 creator A5030937919 @default.
- W47393961 creator A5040902434 @default.
- W47393961 creator A5065353209 @default.
- W47393961 date "2004-01-01" @default.
- W47393961 modified "2023-09-24" @default.
- W47393961 title "The use of hints in object-relational query optimization" @default.
- W47393961 cites W1508902783 @default.
- W47393961 cites W1528522955 @default.
- W47393961 cites W1584117873 @default.
- W47393961 cites W2015372451 @default.
- W47393961 cites W2030315716 @default.
- W47393961 cites W203994246 @default.
- W47393961 cites W2080527146 @default.
- W47393961 cites W2136195851 @default.
- W47393961 cites W2138709157 @default.
- W47393961 cites W2158237121 @default.
- W47393961 cites W2751199251 @default.
- W47393961 cites W2753710282 @default.
- W47393961 cites W3121902542 @default.
- W47393961 hasPublicationYear "2004" @default.
- W47393961 type Work @default.
- W47393961 sameAs 47393961 @default.
- W47393961 citedByCount "2" @default.
- W47393961 countsByYear W473939612012 @default.
- W47393961 crossrefType "journal-article" @default.
- W47393961 hasAuthorship W47393961A5018549791 @default.
- W47393961 hasAuthorship W47393961A5030937919 @default.
- W47393961 hasAuthorship W47393961A5040902434 @default.
- W47393961 hasAuthorship W47393961A5065353209 @default.
- W47393961 hasConcept C150202949 @default.
- W47393961 hasConcept C154945302 @default.
- W47393961 hasConcept C199360897 @default.
- W47393961 hasConcept C2781238097 @default.
- W47393961 hasConcept C41008148 @default.
- W47393961 hasConcept C510870499 @default.
- W47393961 hasConcept C5655090 @default.
- W47393961 hasConcept C77088390 @default.
- W47393961 hasConcept C80444323 @default.
- W47393961 hasConceptScore W47393961C150202949 @default.
- W47393961 hasConceptScore W47393961C154945302 @default.
- W47393961 hasConceptScore W47393961C199360897 @default.
- W47393961 hasConceptScore W47393961C2781238097 @default.
- W47393961 hasConceptScore W47393961C41008148 @default.
- W47393961 hasConceptScore W47393961C510870499 @default.
- W47393961 hasConceptScore W47393961C5655090 @default.
- W47393961 hasConceptScore W47393961C77088390 @default.
- W47393961 hasConceptScore W47393961C80444323 @default.
- W47393961 hasIssue "6" @default.
- W47393961 hasLocation W473939611 @default.
- W47393961 hasOpenAccess W47393961 @default.
- W47393961 hasPrimaryLocation W473939611 @default.
- W47393961 hasRelatedWork W131374543 @default.
- W47393961 hasRelatedWork W1493336764 @default.
- W47393961 hasRelatedWork W1524459778 @default.
- W47393961 hasRelatedWork W1535469647 @default.
- W47393961 hasRelatedWork W1579564205 @default.
- W47393961 hasRelatedWork W165386108 @default.
- W47393961 hasRelatedWork W1971735015 @default.
- W47393961 hasRelatedWork W1991271936 @default.
- W47393961 hasRelatedWork W1994097179 @default.
- W47393961 hasRelatedWork W2049590379 @default.
- W47393961 hasRelatedWork W2095149003 @default.
- W47393961 hasRelatedWork W2120940689 @default.
- W47393961 hasRelatedWork W2143767299 @default.
- W47393961 hasRelatedWork W2176406418 @default.
- W47393961 hasRelatedWork W2359269153 @default.
- W47393961 hasRelatedWork W2363222923 @default.
- W47393961 hasRelatedWork W2372649518 @default.
- W47393961 hasRelatedWork W2381088964 @default.
- W47393961 hasRelatedWork W2556786504 @default.
- W47393961 hasRelatedWork W2783122700 @default.
- W47393961 hasVolume "19" @default.
- W47393961 isParatext "false" @default.
- W47393961 isRetracted "false" @default.
- W47393961 magId "47393961" @default.
- W47393961 workType "article" @default.