Proceedings of 1994 IEEE 10th International Conference on Data Engineering最新文献

筛选
英文 中文
Analysis of common subexpression exploitation models in multiple-query processing 多查询处理中常用子表达式开发模型分析
Proceedings of 1994 IEEE 10th International Conference on Data Engineering Pub Date : 1994-02-14 DOI: 10.1109/ICDE.1994.283068
Jamal R. Alsabbagh, Vijay V. Raghavan
{"title":"Analysis of common subexpression exploitation models in multiple-query processing","authors":"Jamal R. Alsabbagh, Vijay V. Raghavan","doi":"10.1109/ICDE.1994.283068","DOIUrl":"https://doi.org/10.1109/ICDE.1994.283068","url":null,"abstract":"In multiple-query processing, a subexpression that appears in more than one query is called a common subexpression (CSE). A CSE needs to he evaluated once only to produce a temporary result that can then be used to evaluate all the queries containing the CSE. Therefore, the cost of evaluating the CSE is amortized over the queries requiring its evaluation. Two queries, posed simultaneously to the optimizer, may however contain subexpression that are not equivalent but are, nevertheless related by implication (the extension of one is a proper subset of the other) or intersection (the intersection of the two extensions is a proper subset of both extensions). In order to exploit the opportunity for cost amortization offered by the two latter relationships. the optimizer must rewrite the two queries in such a way that a CSE is induced. This paper compares, empirically and analytically, the performance of the various query execution models that are implied by different approaches to query rewriting.<<ETX>>","PeriodicalId":142465,"journal":{"name":"Proceedings of 1994 IEEE 10th International Conference on Data Engineering","volume":"1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1994-02-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"122616015","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 24
Exploiting uniqueness in query optimization 在查询优化中利用唯一性
Proceedings of 1994 IEEE 10th International Conference on Data Engineering Pub Date : 1994-02-14 DOI: 10.1109/ICDE.1994.283003
Satyanarayana R. Valluri, Arvind Hulgeri, K. Karlapalem
{"title":"Exploiting uniqueness in query optimization","authors":"Satyanarayana R. Valluri, Arvind Hulgeri, K. Karlapalem","doi":"10.1109/ICDE.1994.283003","DOIUrl":"https://doi.org/10.1109/ICDE.1994.283003","url":null,"abstract":"Consider an SQL query that specifies duplicate elimination via a DISTINCT clause. Because duplicate elimination often requires an expensive sort of the query result, it is often worthwhile to identify unnecessary DISTINCT clauses and avoid the sort altogether. We prove a necessary and sufficient condition for deciding if a query requires duplicate elimination. The condition exploits knowledge about keys, table constraints, and query predicates. Because the condition cannot always be tested efficiently, we offer a practical algorithm that tests a simpler, sufficient condition. We consider applications of this condition for various types of queries, and show that we can exploit this condition in both relational and nonregulation database systems.<<ETX>>","PeriodicalId":142465,"journal":{"name":"Proceedings of 1994 IEEE 10th International Conference on Data Engineering","volume":"134 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1994-02-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"126869867","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 49
Declustering techniques for parallelizing temporal access structures 并行时态访问结构的聚类技术
Proceedings of 1994 IEEE 10th International Conference on Data Engineering Pub Date : 1994-02-14 DOI: 10.1109/ICDE.1994.283036
V. Kouramajian, R. Elmasri, Anurag Chaudhry
{"title":"Declustering techniques for parallelizing temporal access structures","authors":"V. Kouramajian, R. Elmasri, Anurag Chaudhry","doi":"10.1109/ICDE.1994.283036","DOIUrl":"https://doi.org/10.1109/ICDE.1994.283036","url":null,"abstract":"This paper addresses the issues of declustering temporal index and access structures for a single processor multiple independent disk architecture. The temporal index is the Monotonic B/sup +/-Tree which uses the time index temporal access structure. We devise a new algorithm, called multi-level round robin, for assigning tree nodes to multiple disks. The multi-level round robin declustering technique takes advantage of the append-only nature of temporal databases to achieve uniform load distribution, decrease response time, and increase the fanout of the tree by eliminating the need to store disk numbers within the tree nodes. We propose two declustering techniques for the time index access structures; one considers only time proximity while declustering, whereas the other considers both time proximity and data size. We investigate their performance over different types of temporal queries and show that various temporal queries have conflicting allocation criteria for the time index buckets. In addition, we devise two disk partition techniques for the time index buckets. The mutually exclusive technique partitions the disks into disjoint groups, whereas the shared disk technique allows the different types of buckets to share all disks.<<ETX>>","PeriodicalId":142465,"journal":{"name":"Proceedings of 1994 IEEE 10th International Conference on Data Engineering","volume":"6 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1994-02-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"129551352","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 12
On the interaction between ISA and cardinality constraints 关于ISA和基数约束之间的相互作用
Proceedings of 1994 IEEE 10th International Conference on Data Engineering Pub Date : 1994-02-14 DOI: 10.1109/ICDE.1994.283032
Diego Calvanese, M. Lenzerini
{"title":"On the interaction between ISA and cardinality constraints","authors":"Diego Calvanese, M. Lenzerini","doi":"10.1109/ICDE.1994.283032","DOIUrl":"https://doi.org/10.1109/ICDE.1994.283032","url":null,"abstract":"ISA and cardinality constraints are among the most interesting types of constraints in data models. ISA constraints are used to establish several forms of containment among classes, and are receiving great attention in moving to object-oriented data models, where classes are organized in hierarchies based on a generalization/specialization principle. Cardinality constraints impose restrictions on the number of links of a certain type involving every instance of a given class, and can be used for representing several forms of dependencies between classes, including functional and existence dependencies. While the formal properties of each type of constraints are now well understood, little is known of their interaction. We present an effective method for reasoning about a set of ISA and cardinality constraints in the context of a simple data model based on the notions of classes and relationships. In particular, the method allows one both to verify the satisfiability of a schema and to check whether a schema implies a given constraint of any of the two kinds. We prove that the method is sound and complete, thus showing that the reasoning problem for ISA and cardinality constraints is decidable.<<ETX>>","PeriodicalId":142465,"journal":{"name":"Proceedings of 1994 IEEE 10th International Conference on Data Engineering","volume":"17 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1994-02-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"128301917","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 78
X.500 Directory Schema management X.500目录模式管理
Proceedings of 1994 IEEE 10th International Conference on Data Engineering Pub Date : 1994-02-14 DOI: 10.1109/ICDE.1994.283056
D. Silver, J. W. Hong, M. Bauer
{"title":"X.500 Directory Schema management","authors":"D. Silver, J. W. Hong, M. Bauer","doi":"10.1109/ICDE.1994.283056","DOIUrl":"https://doi.org/10.1109/ICDE.1994.283056","url":null,"abstract":"The X.500 Directory Service provides a powerful mechanism for storing and retrieving information about objects in a distributed computing environment. This requires the functional components of the Directory Service to have knowledge of the structure and representation, or schema, of the information held within the directory. The management of the Directory Schema is a subject requiring further research and development. We identify the three major technical elements required for properly managing the Directory Schema. We then focus on one of these elements; propagation of the schema between functional components of the Directory Service. Three subproblems from within schema propagation are presented, along with several alternative solutions.<<ETX>>","PeriodicalId":142465,"journal":{"name":"Proceedings of 1994 IEEE 10th International Conference on Data Engineering","volume":"20 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1994-02-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"132187363","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 1
Mariposa: a new architecture for distributed data Mariposa:分布式数据的新架构
Proceedings of 1994 IEEE 10th International Conference on Data Engineering Pub Date : 1994-02-14 DOI: 10.1109/ICDE.1994.283004
M. Stonebraker, Paul M. Aoki, Robert Devine, W. Litwin, Michael A. Olson
{"title":"Mariposa: a new architecture for distributed data","authors":"M. Stonebraker, Paul M. Aoki, Robert Devine, W. Litwin, Michael A. Olson","doi":"10.1109/ICDE.1994.283004","DOIUrl":"https://doi.org/10.1109/ICDE.1994.283004","url":null,"abstract":"We describe the design of Mariposa, an experimental distributed data management system that provides high performance in an environment of high data mobility and heterogeneous host capabilities. The Mariposa design unifies the approaches taken by distributed file systems and distributed databases. In addition, Mariposa provides a general, flexible platform for the development of new algorithms for distributed query optimization, storage management, and scalable data storage structures. This flexibility is primarily due to a unique rule-based design that permits autonomous, local-knowledge decisions to be made regarding data placement, query execution location, and storage management.<<ETX>>","PeriodicalId":142465,"journal":{"name":"Proceedings of 1994 IEEE 10th International Conference on Data Engineering","volume":"126 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1994-02-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"116403754","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 112
Sort-merge-join: an idea whose time has(h) passed? 排序-合并-连接:一个过时的想法?
Proceedings of 1994 IEEE 10th International Conference on Data Engineering Pub Date : 1994-02-14 DOI: 10.1109/ICDE.1994.283062
G. Graefe
{"title":"Sort-merge-join: an idea whose time has(h) passed?","authors":"G. Graefe","doi":"10.1109/ICDE.1994.283062","DOIUrl":"https://doi.org/10.1109/ICDE.1994.283062","url":null,"abstract":"Matching two sets of data items is a fundamental operation required in relational, extensible, and object-oriented database systems alike. However, the pros and cons of sort- and hash-based query evaluation techniques in modern query processing systems are still not fully understood. After our earlier research clarified strengths and weaknesses of sort- and hash-based query processing techniques and suggested remedies for the shortcomings of hash-based algorithms, the present paper outlines a number of further differences between sort-merge-join and hybrid hash join that traditionally have been ignored in such comparisons and render sort-merge-join mostly obsolete. We consolidate old and raise new issues pertinent to the comparison of sort- and hash-based query evaluation techniques and stir some thought and discussion among both academic and industrial database system builders.<<ETX>>","PeriodicalId":142465,"journal":{"name":"Proceedings of 1994 IEEE 10th International Conference on Data Engineering","volume":"33 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1994-02-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"115620291","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 64
Performance analysis of RAIDS disk arrays with a vacationing server model for rebuild mode operation 基于休假服务器模型的raid磁盘阵列性能分析
Proceedings of 1994 IEEE 10th International Conference on Data Engineering Pub Date : 1994-02-14 DOI: 10.1109/ICDE.1994.282999
Alexander Thomasian, J. Menon
{"title":"Performance analysis of RAIDS disk arrays with a vacationing server model for rebuild mode operation","authors":"Alexander Thomasian, J. Menon","doi":"10.1109/ICDE.1994.282999","DOIUrl":"https://doi.org/10.1109/ICDE.1994.282999","url":null,"abstract":"We analyze the performance of RAIDS disk arrays in normal, degraded, and rebuild modes. The analysis, which is shown to be highly accurate through validation against simulation results, achieves its accuracy by (1) modeling detailed disk characteristics; (2) developing a simple approximation to compute the mean response time for fork-join requests arising in degraded mode operation; and (3) using a vacationing server model with multiple vacation types for rebuild mode analysis. According to this model vacations (rebuild reads) are started when the server (disk) becomes idle and are repeated until the arrival of an external disk request. Type one (two) vacations correspond to the reading of the first track which requires a seek (successive tracks requiring no seeks). The analytic solution is used to quantify the effect of different rebuild options, such as read redirection and the split-seek option.<<ETX>>","PeriodicalId":142465,"journal":{"name":"Proceedings of 1994 IEEE 10th International Conference on Data Engineering","volume":"70 2 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1994-02-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"124154573","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 53
Efficient organization of large multidimensional arrays 高效组织大型多维数组
Proceedings of 1994 IEEE 10th International Conference on Data Engineering Pub Date : 1994-02-14 DOI: 10.1109/ICDE.1994.283048
Sunita Sarawagi, M. Stonebraker
{"title":"Efficient organization of large multidimensional arrays","authors":"Sunita Sarawagi, M. Stonebraker","doi":"10.1109/ICDE.1994.283048","DOIUrl":"https://doi.org/10.1109/ICDE.1994.283048","url":null,"abstract":"Large multidimensional arrays are widely used in scientific and engineering database applications. The authors present methods of organizing arrays to make their access on secondary and tertiary memory devices fast and efficient. They have developed four techniques for doing this: (1) storing the array in multidimensional \"chunks\" to minimize the number of blocks fetched, (2) reordering the chunked array to minimize seek distance between accessed blocks, (3) maintaining redundant copies of the array, each organized for a different chunk size and ordering and (4) partitioning the array onto platters of a tertiary memory device so as to minimize the number of platter switches. The measurements on real data obtained from global change scientists show that accesses on arrays organized using these techniques are often an order of magnitude faster than on the unoptimized data.<<ETX>>","PeriodicalId":142465,"journal":{"name":"Proceedings of 1994 IEEE 10th International Conference on Data Engineering","volume":"36 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1994-02-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"132647697","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 306
Resolving attribute incompatibility in database integration: an evidential reasoning approach 数据库集成中属性不兼容的解决:一种证据推理方法
Proceedings of 1994 IEEE 10th International Conference on Data Engineering Pub Date : 1994-02-14 DOI: 10.1109/ICDE.1994.283022
Ee-Peng Lim, J. Srivastava, S. Shekhar
{"title":"Resolving attribute incompatibility in database integration: an evidential reasoning approach","authors":"Ee-Peng Lim, J. Srivastava, S. Shekhar","doi":"10.1109/ICDE.1994.283022","DOIUrl":"https://doi.org/10.1109/ICDE.1994.283022","url":null,"abstract":"Resolving domain incompatibility among independently developed databases often involves uncertain information. DeMichiel (1989) showed that uncertain information can be generated by the mapping of conflicting attributes to a common domain, based on some domain knowledge. The authors show that uncertain information can also arise when the database integration process requires information not directly represented in the component databases, but can be obtained through some summary of data. They therefore propose an extended relational model based on Dempster-Shafer theory of evidence (1976) to incorporate such uncertain knowledge about the source databases. They also develop a full set of extended relational operations over the extended relations. In particular, an extended union operation has been formalized to combine two extended relations using Dempster's rule of combination. The closure and boundedness properties of the proposed extended operations are formulated.<<ETX>>","PeriodicalId":142465,"journal":{"name":"Proceedings of 1994 IEEE 10th International Conference on Data Engineering","volume":"156 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1994-02-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"133430757","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 65
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
相关产品
×
本文献相关产品
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信