Answer Posted / amish ojha
applying hashing algorithm to the PI system gets the ROW
HASH ,that will be searched in the HASH BUCKET to get the
desired AMP ,thereafter by adding uniqueness value to row
hash value the row ID is obtained and then it gets stored
in AMP ..
PI-->ROW HASH ---> HASH BUCKET(MAP)--> AMPno
ROWID = ROW HASH + UNIQUENESS ID
where actually the row is stored
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain storage manager?
diff b/w inter process and in process
What is difference between clustered, non-clustered and unique index?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
Explain entity type?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
If the master device is full, how do I make the master database bigger?
How default key is different from primary key?
How heap is implemented in database?
What is meant by distributed system?
What is the Lock Based Protocol used for?
Explain natural key?
What does new grouping sets enables you to do?
What will happen non-clustered index will be created on clustered index?
What do you mean by foreign key and primary key?