CoddRule8

CoddRule8 - Account: number, owner, balance, branch_id, ....

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
    CODD’S 8 th  RULE
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
    BREIF HISTORY  Dr. Codd , an IBM researcher, is the major  developer in 1970. In 1985 he published a paper defining 12   rules. Rules specify ideal relational database. To date, no commercial relational  database system available that fully  supports all 12 rules. 
Background image of page 2
    Codd's Rule # 8.  Physical Data Independence   Applications should work with a logical data  model and declarative query language Applications should not need to worry about  how data is physically structured and stored Leave the implementation details and  optimization to DBMS
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
                 Data Independence          Three-Level Architecture
Background image of page 4
                             Example   Three-Level Architecture
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
                     EXAMPLE
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Account: number, owner, balance, branch_id, . .. Branch: branch_id, location, . .. Query: who have accounts with 0 balance managed by a branch in Bombay? SQL (1970s present) SELECT owner FROM Account, Branch WHERE balance = 0 AND location = Bombay AND Account.branch_id = Branch.branch_id; Programmer specifies what answers a query should return, but not how the query is executed DBMS picks the best execution strategy based on availability of indexes, actual distribution of the data, etc. Provides physical data independence Solution Thank You. Ameya s Raichur. Amit a Pol. Kalpak r Gadre. Krishanakumar N. Ramesh babu. Ganesh k Raja. Suresh Ch....
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 8

CoddRule8 - Account: number, owner, balance, branch_id, ....

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online