Matches in SemOpenAlex for { <https://semopenalex.org/work/W4254343831> ?p ?o ?g. }
Showing items 1 to 86 of
86
with 100 items per page.
- W4254343831 endingPage "116" @default.
- W4254343831 startingPage "93" @default.
- W4254343831 abstract "An adaptive probe-based optimization technique is developed and demonstrated in the context of an Internet-based distributed database environment. More and more common are database systems, which are distributed across servers communicating via the Internet where a query at a given site might require data from remote sites. Optimizing the response time of such queries is a challenging task due to the unpredictability of server performance and network traffic at the time of data shipment; this may result in the selection of an expensive query plan using a static query optimizer. We constructed an experimental setup consisting of two servers running the same DBMS connected via the Internet. Concentrating on join queries, we demonstrate how a static query optimizer might choose an expensive plan by mistake. This is due to the lack of a priori knowledge of the run-time environment, inaccurate statistical assumptions in size estimation, and neglecting the cost of remote method invocation. These shortcomings are addressed collectively by proposing a probing mechanism. Furthermore, we extend our mechanism with an adaptive technique that detects sub-optimality of a plan during query execution and attempts to switch to the cheapest plan while avoiding redundant work and imposing little overhead. An implementation of our run-time optimization technique for join queries was constructed in the Java language and incorporated into an experimental setup. The results demonstrate the superiority of our probe-based optimization over a static optimization." @default.
- W4254343831 created "2022-05-12" @default.
- W4254343831 creator A5003500167 @default.
- W4254343831 creator A5005002693 @default.
- W4254343831 creator A5090330984 @default.
- W4254343831 date "2002-01-01" @default.
- W4254343831 modified "2023-09-27" @default.
- W4254343831 title "An Adaptive Probe-Based Technique to Optimize Join Queries in Distributed Internet Databases" @default.
- W4254343831 doi "https://doi.org/10.4018/978-1-931777-13-1.ch006" @default.
- W4254343831 hasPublicationYear "2002" @default.
- W4254343831 type Work @default.
- W4254343831 citedByCount "0" @default.
- W4254343831 crossrefType "book-chapter" @default.
- W4254343831 hasAuthorship W4254343831A5003500167 @default.
- W4254343831 hasAuthorship W4254343831A5005002693 @default.
- W4254343831 hasAuthorship W4254343831A5090330984 @default.
- W4254343831 hasConcept C105795698 @default.
- W4254343831 hasConcept C110875604 @default.
- W4254343831 hasConcept C111919701 @default.
- W4254343831 hasConcept C118689300 @default.
- W4254343831 hasConcept C120314980 @default.
- W4254343831 hasConcept C148840519 @default.
- W4254343831 hasConcept C149672232 @default.
- W4254343831 hasConcept C151730666 @default.
- W4254343831 hasConcept C157692150 @default.
- W4254343831 hasConcept C164120249 @default.
- W4254343831 hasConcept C165064840 @default.
- W4254343831 hasConcept C192939062 @default.
- W4254343831 hasConcept C205295232 @default.
- W4254343831 hasConcept C23123220 @default.
- W4254343831 hasConcept C2779343474 @default.
- W4254343831 hasConcept C2779729312 @default.
- W4254343831 hasConcept C2779960059 @default.
- W4254343831 hasConcept C31258907 @default.
- W4254343831 hasConcept C33923547 @default.
- W4254343831 hasConcept C41008148 @default.
- W4254343831 hasConcept C54239708 @default.
- W4254343831 hasConcept C70061542 @default.
- W4254343831 hasConcept C77088390 @default.
- W4254343831 hasConcept C86803240 @default.
- W4254343831 hasConcept C93996380 @default.
- W4254343831 hasConcept C97854310 @default.
- W4254343831 hasConceptScore W4254343831C105795698 @default.
- W4254343831 hasConceptScore W4254343831C110875604 @default.
- W4254343831 hasConceptScore W4254343831C111919701 @default.
- W4254343831 hasConceptScore W4254343831C118689300 @default.
- W4254343831 hasConceptScore W4254343831C120314980 @default.
- W4254343831 hasConceptScore W4254343831C148840519 @default.
- W4254343831 hasConceptScore W4254343831C149672232 @default.
- W4254343831 hasConceptScore W4254343831C151730666 @default.
- W4254343831 hasConceptScore W4254343831C157692150 @default.
- W4254343831 hasConceptScore W4254343831C164120249 @default.
- W4254343831 hasConceptScore W4254343831C165064840 @default.
- W4254343831 hasConceptScore W4254343831C192939062 @default.
- W4254343831 hasConceptScore W4254343831C205295232 @default.
- W4254343831 hasConceptScore W4254343831C23123220 @default.
- W4254343831 hasConceptScore W4254343831C2779343474 @default.
- W4254343831 hasConceptScore W4254343831C2779729312 @default.
- W4254343831 hasConceptScore W4254343831C2779960059 @default.
- W4254343831 hasConceptScore W4254343831C31258907 @default.
- W4254343831 hasConceptScore W4254343831C33923547 @default.
- W4254343831 hasConceptScore W4254343831C41008148 @default.
- W4254343831 hasConceptScore W4254343831C54239708 @default.
- W4254343831 hasConceptScore W4254343831C70061542 @default.
- W4254343831 hasConceptScore W4254343831C77088390 @default.
- W4254343831 hasConceptScore W4254343831C86803240 @default.
- W4254343831 hasConceptScore W4254343831C93996380 @default.
- W4254343831 hasConceptScore W4254343831C97854310 @default.
- W4254343831 hasLocation W42543438311 @default.
- W4254343831 hasOpenAccess W4254343831 @default.
- W4254343831 hasPrimaryLocation W42543438311 @default.
- W4254343831 hasRelatedWork W10289283 @default.
- W4254343831 hasRelatedWork W12120584 @default.
- W4254343831 hasRelatedWork W1901499 @default.
- W4254343831 hasRelatedWork W256357 @default.
- W4254343831 hasRelatedWork W3266680 @default.
- W4254343831 hasRelatedWork W5839577 @default.
- W4254343831 hasRelatedWork W7814883 @default.
- W4254343831 hasRelatedWork W7917240 @default.
- W4254343831 hasRelatedWork W901556 @default.
- W4254343831 hasRelatedWork W6461097 @default.
- W4254343831 isParatext "false" @default.
- W4254343831 isRetracted "false" @default.
- W4254343831 workType "book-chapter" @default.