Abstract One of the basic functionalities of database management systems (DBMSs) is to be able to... more Abstract One of the basic functionalities of database management systems (DBMSs) is to be able to process declarative user queries. The first generation of object-oriented DBMSs did not provide declarative query capabilities. However, the last decade has seen significant research in defining query models (including calculi, algebra and user languages) and in techniques for processing and optimizing them. Many of the current commercial systems provide at least rudimentary query capabilities. In this chapter we discuss the techniques ...
Page 1. Join Index, Materialized View, and Hybrid-Hash Join: A Performance Analysis Josd A. Blake... more Page 1. Join Index, Materialized View, and Hybrid-Hash Join: A Performance Analysis Josd A. Blakelef Nancy L. Martin Computer Science Department Indiana University Bloomington, IN 47405-4101 Abstract This paper deals ...
... Consumers are components that use data. Examples include services such as a query processor; ... more ... Consumers are components that use data. Examples include services such as a query processor; high-level data access models such as ADO, business applications written in languages like Visual Basic, C++, or Java as well as development tools. ...
This paper describes the ADO.NET Entity Framework, a platform for programming against data that r... more This paper describes the ADO.NET Entity Framework, a platform for programming against data that raises the level of abstraction from the logical (relational) level to the conceptual (entity) level, and thereby significantly reduces the impedance mismatch for applications and data services such as reporting, analysis, and replication. The conceptual data model is made real by a runtime that implements an extended relational model (the Entity Data Model aka the EDM), that embraces entities and relationships as first class concepts; a query language for the EDM; a comprehensive mapping engine that translates from the conceptual to the logical (relational) level, and a set of model-driven tools that help create entity-object, object-xml, and entity-xml transformers.
Page 1. Experiences Building the Open OODB Query Optimizer JOS6A. Blakeley, Texas Instruments WNi... more Page 1. Experiences Building the Open OODB Query Optimizer JOS6A. Blakeley, Texas Instruments WNiam J. McKenna, University of Colorado at Boulder Goetz Graefe, Portland State University Abstract This paper reports ...
... SELECT m 1.*. c.Address FROM MakeTallle( Mail, cl:Nllail\srlllth.rnrllf ) m 1, M.akeT~hle( Ac... more ... SELECT m 1.*. c.Address FROM MakeTallle( Mail, cl:Nllail\srlllth.rnrllf ) m 1, M.akeT~hle( Access, d:'wccess~nterprise,nlLih, Customers) c WHERE m 1,1.)ate >= dmte( t[dayo, -2 ) AND m 1.From = c.Emaila&ir AND c.City = Senttle ... decision to use a particular stor:ige manager, file ...
Abstract One of the basic functionalities of database management systems (DBMSs) is to be able to... more Abstract One of the basic functionalities of database management systems (DBMSs) is to be able to process declarative user queries. The first generation of object-oriented DBMSs did not provide declarative query capabilities. However, the last decade has seen significant research in defining query models (including calculi, algebra and user languages) and in techniques for processing and optimizing them. Many of the current commercial systems provide at least rudimentary query capabilities. In this chapter we discuss the techniques ...
Page 1. Join Index, Materialized View, and Hybrid-Hash Join: A Performance Analysis Josd A. Blake... more Page 1. Join Index, Materialized View, and Hybrid-Hash Join: A Performance Analysis Josd A. Blakelef Nancy L. Martin Computer Science Department Indiana University Bloomington, IN 47405-4101 Abstract This paper deals ...
... Consumers are components that use data. Examples include services such as a query processor; ... more ... Consumers are components that use data. Examples include services such as a query processor; high-level data access models such as ADO, business applications written in languages like Visual Basic, C++, or Java as well as development tools. ...
This paper describes the ADO.NET Entity Framework, a platform for programming against data that r... more This paper describes the ADO.NET Entity Framework, a platform for programming against data that raises the level of abstraction from the logical (relational) level to the conceptual (entity) level, and thereby significantly reduces the impedance mismatch for applications and data services such as reporting, analysis, and replication. The conceptual data model is made real by a runtime that implements an extended relational model (the Entity Data Model aka the EDM), that embraces entities and relationships as first class concepts; a query language for the EDM; a comprehensive mapping engine that translates from the conceptual to the logical (relational) level, and a set of model-driven tools that help create entity-object, object-xml, and entity-xml transformers.
Page 1. Experiences Building the Open OODB Query Optimizer JOS6A. Blakeley, Texas Instruments WNi... more Page 1. Experiences Building the Open OODB Query Optimizer JOS6A. Blakeley, Texas Instruments WNiam J. McKenna, University of Colorado at Boulder Goetz Graefe, Portland State University Abstract This paper reports ...
... SELECT m 1.*. c.Address FROM MakeTallle( Mail, cl:Nllail\srlllth.rnrllf ) m 1, M.akeT~hle( Ac... more ... SELECT m 1.*. c.Address FROM MakeTallle( Mail, cl:Nllail\srlllth.rnrllf ) m 1, M.akeT~hle( Access, d:'wccess~nterprise,nlLih, Customers) c WHERE m 1,1.)ate >= dmte( t[dayo, -2 ) AND m 1.From = c.Emaila&ir AND c.City = Senttle ... decision to use a particular stor:ige manager, file ...
Uploads