Matches in SemOpenAlex for { <https://semopenalex.org/work/W2016042910> ?p ?o ?g. }
Showing items 1 to 67 of
67
with 100 items per page.
- W2016042910 endingPage "281" @default.
- W2016042910 startingPage "233" @default.
- W2016042910 abstract "Applications, such as warehouse maintenance, need to load large data volumes regularly. The efficiency of loading depends on the resources that are available at the source and at the target systems. Our work aims to understand the performance criteria that are involved in bulk loading data into a database and to devise tailored optimization strategies.Unlike commercial systems and previous research on the same topic, our approach follows the fundamental database principle of physical-logical independence. A loading program is represented as a sequence of algebraic expressions. This abstraction enables the use of appropriate algebraic rewritings to optimize a loading program and of a cost model that takes into consideration efficiency criteria such as the processing times at the source and target systems and the bandwidth between them. A slow-loading program may be preferable if it does not slow down other applications by consuming too much memory. Thus, we view the problem of optimizing a loading program as finding a compromise between several efficiency criteria.The ability to represent loading programs in an algebra and performance criteria in a cost model has two very desirable properties: reusability and efficiency. Database programmers do not have to write loading programs by hand. In addition, tuning loading programs becomes easier since programmers have a better control on the performance criteria specified in the cost model. The algebra captures data transformations that would have been otherwise hardcoded in loading programs. Consequently, richer optimizations can be explored. Finally, our optimization techniques are not specific to one particular system. They can be used for loading data and from to any structured store (e.g., relational, structured files).We implemented our ideas in a complete environment for migrating ODBC-compliant databases into the O 2 object-oriented database system. This prototype provides a declarative view language to specify loading, an interface to specify directives, such as desired database physical organization and constraints on several criteria, such as resource and bandwidth consumption, an algebraic optimizer, a code generator, and an execution environment to control failures and guarantee incremental loading. Our experiments show that a tailored optimization is necessary when loading large data volumes into a database." @default.
- W2016042910 created "2016-06-24" @default.
- W2016042910 creator A5081664259 @default.
- W2016042910 creator A5087099692 @default.
- W2016042910 date "2004-06-01" @default.
- W2016042910 modified "2023-09-25" @default.
- W2016042910 title "A declarative approach to optimize bulk loading into databases" @default.
- W2016042910 cites W1969092043 @default.
- W2016042910 cites W2030868491 @default.
- W2016042910 cites W2069703493 @default.
- W2016042910 cites W2087378207 @default.
- W2016042910 cites W2087898817 @default.
- W2016042910 cites W2110631345 @default.
- W2016042910 cites W2117242988 @default.
- W2016042910 cites W2137420916 @default.
- W2016042910 cites W2165415744 @default.
- W2016042910 cites W2951321531 @default.
- W2016042910 cites W4255814300 @default.
- W2016042910 doi "https://doi.org/10.1145/1005566.1005567" @default.
- W2016042910 hasPublicationYear "2004" @default.
- W2016042910 type Work @default.
- W2016042910 sameAs 2016042910 @default.
- W2016042910 citedByCount "12" @default.
- W2016042910 countsByYear W20160429102014 @default.
- W2016042910 countsByYear W20160429102017 @default.
- W2016042910 crossrefType "journal-article" @default.
- W2016042910 hasAuthorship W2016042910A5081664259 @default.
- W2016042910 hasAuthorship W2016042910A5087099692 @default.
- W2016042910 hasConcept C111472728 @default.
- W2016042910 hasConcept C120314980 @default.
- W2016042910 hasConcept C124304363 @default.
- W2016042910 hasConcept C137981799 @default.
- W2016042910 hasConcept C138885662 @default.
- W2016042910 hasConcept C199360897 @default.
- W2016042910 hasConcept C2777904410 @default.
- W2016042910 hasConcept C41008148 @default.
- W2016042910 hasConcept C77088390 @default.
- W2016042910 hasConceptScore W2016042910C111472728 @default.
- W2016042910 hasConceptScore W2016042910C120314980 @default.
- W2016042910 hasConceptScore W2016042910C124304363 @default.
- W2016042910 hasConceptScore W2016042910C137981799 @default.
- W2016042910 hasConceptScore W2016042910C138885662 @default.
- W2016042910 hasConceptScore W2016042910C199360897 @default.
- W2016042910 hasConceptScore W2016042910C2777904410 @default.
- W2016042910 hasConceptScore W2016042910C41008148 @default.
- W2016042910 hasConceptScore W2016042910C77088390 @default.
- W2016042910 hasIssue "2" @default.
- W2016042910 hasLocation W20160429101 @default.
- W2016042910 hasOpenAccess W2016042910 @default.
- W2016042910 hasPrimaryLocation W20160429101 @default.
- W2016042910 hasRelatedWork W1594229218 @default.
- W2016042910 hasRelatedWork W1596201972 @default.
- W2016042910 hasRelatedWork W2120994104 @default.
- W2016042910 hasRelatedWork W2215606090 @default.
- W2016042910 hasRelatedWork W2278796325 @default.
- W2016042910 hasRelatedWork W2372886617 @default.
- W2016042910 hasRelatedWork W2394142092 @default.
- W2016042910 hasRelatedWork W2888805005 @default.
- W2016042910 hasRelatedWork W3216885170 @default.
- W2016042910 hasRelatedWork W2131591406 @default.
- W2016042910 hasVolume "29" @default.
- W2016042910 isParatext "false" @default.
- W2016042910 isRetracted "false" @default.
- W2016042910 magId "2016042910" @default.
- W2016042910 workType "article" @default.