2 2 votes In distributed databases, location transparency allows for database users, programmers and administratirs to treat the data as if it is at one location, A SQL query with location transparency needs to specify Inheritances Fragments Locations Local formats Databases ugcnetcse-july2016-paper3 databases distributed-database + – Sanjay Sharma 7.0k views answer comment Share Follow Print 0 reply Please log in or register to add a comment.
3 3 votes Answer 2 In SQL query with location transparency the end user must specify the database fragment name but does not need to specify where those fragments are located. Fragmentation transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned. Therefore, neither fragment names nor fragment locations are specified prior to data access. Local mapping transparency exists when the end user or programmer must specify both the fragment names and their locations. sh!va answered Jul 11, 2016 sh!va comment Share Follow 0 reply Please log in or register to add a comment.
