开发者

What is meant by 'query modification' as an approach to implementing views?

开发者 https://www.devze.com 2023-02-04 19:56 出处:网络
Just doing some revision, and one of the questions is: \"Explain what is meant by \'query modification\' as an approach to

Just doing some revision, and one of the questions is:

"Explain what is meant by 'query modification' as an approach to implementing views."

Now, I'm not quite sure how to answer that... I know wh开发者_StackOverflow中文版at views are, how to create them and why they are used etc, but what exactly does that question want to know?


This is a theoretical concept from David Meier's works on relational theory.

When you are using a view in your queries, like this:

CREATE VIEW v_filtered
AS
SELECT  *
FROM    mytable
WHERE   mycolumn = 1

SELECT  *
FROM    v_filtered
JOIN    othertable
ON      otherid = myid

, to execute your query, a database engine should be able to rewrite the query over the virtual relations (like your view) to one using the base relations, since that what is actually stored:

SELECT  *
FROM    mytable
JOIN    othertable
ON      otherid = myid
WHERE   mycolumn = 1

This process is called query modification.

0

精彩评论

暂无评论...
验证码 换一张
取 消