Close category search window
 

SQL query modification algorithms

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

2 Author(s)
Chou, D. ; California Univ., Berkeley, CA, USA ; Segev, A.

Algebra rules and a query modification algorithm that enable modifications of SQL queries considered hitherto as nonmodifiable are introduced. Cases where aggregates are involved are emphasized. Also introduced is a technique to translate a view with DISTINCT keyword into an equivalent grouped view without DISTINCT; as a result some queries that were not modifiable on the DISTINCT view become modifiable. A set of commutative and merging rules at the relational algebra level that are used to derive the query modification algorithm systematically is developed

Published in:
Information Technology, 1990. 'Next Decade in Information Technology', Proceedings of the 5th Jerusalem Conference on (Cat. No.90TH0326-9)

Date of Conference: 22-25 Oct 1990

Need Help?


IEEE Advancing Technology for Humanity About IEEE Xplore | Contact | Help | Terms of Use | Nondiscrimination Policy | Site Map | Privacy & Opting Out of Cookies

A not-for-profit organization, IEEE is the world's largest professional association for the advancement of technology.
© Copyright 2013 IEEE - All rights reserved. Use of this web site signifies your agreement to the terms and conditions.