Interested to Buy Any Domain ? << Click Here >> for more details...
what is data independence exactly? give an example
- 6 Answers
- 42132 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / guneetinder singh
Data independence means when we bring out changes in lower
levels then upper level does not feel any affect.
i.e. changing internal level does not affect conceptual level.
| Is This Answer Correct ? | 77 Yes | 10 No |
Answer / mohammad ikram
Physical data independence
- the capacity to change the internal schema without
having to change the conceptual (or external) schema
- internal schema may change to improve the performance
(e.g., creating additional access structure)
| Is This Answer Correct ? | 17 Yes | 4 No |
Answer / noor alam
The separation of data descriptions from the application
programs (or user-interfaces) that uses the data is called
data independence.
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / monika
Data independance:
It includes the isolation of data from application program.
There are 2 types of data independance:
1.Logical data independance:
The ability to change the conceptual schema without
altering the external schema or application programs.
2.Physical data independance:
It is ability to change the internal schema without
changing the conceptual or external schema.
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / mohammad aquib
When the logical structure of database changes , application program are only minimally affected and requires very little modification ,it is called data independent
| Is This Answer Correct ? | 0 Yes | 0 No |
How to drop a stored procedure in oracle?
How can you merge two tables in oracle?
3. Display all the client numbers in the ORDER table. Remove duplicates.
how to retrieve 1st and last row of table without using group functions??
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
how to get last monday of a month?
State all possible different index configurations a table can possibly have?
What is dual table oracle?
Explain 1st, 2nd, 3rd normalization form of data base
How to omit columns with default values in insert statement in oracle?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Oracle General 
