what is data independence exactly? give an example
Answer Posted / sravya
There are two types of data independence
1. Logical data independence: The ability to change the
logical (conceptual) schema without changing the External
schema (User View) is called logical data independence. For
example, the addition or removal of new entities,
attributes, or relationships to the conceptual schema should
be possible without having to change existing external
schemas or having to rewrite existing application programs.
2 Physical data independence: The ability to change the
physical schema without changing the logical schema is
called physical data independence. For example, a change to
the internal schema, such as using different file
organization or storage structures, storage devices, or
indexing strategy, should be possible without having to
change the conceptual or external schemas.
Is This Answer Correct ? | 127 Yes | 11 No |
Post New Answer View All Answers
Can objects of the same schema reside in different tablespace?
How many types of tables supported by oracle?
How to drop an index in oracle?
How to define a record variable to store a table row?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What are ddl statements in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Give the constructs of a package, function or a procedure.
What are the different editions of oracle?
What is oracle database client?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What are a cluster and non-cluster index?
What are the numeric comparison operations?
How do I connect to oracle database?
What is recycle bin in Oracle?