Explain about the Physical Data Model?
A physical data model (a.k.a. database design) is a
representation of a data design which takes into account the
facilities and constraints of a given database management
system. In the lifecycle of a project it is typically
derived from a logical data model, though it may be
reverse-engineered from a given database implementation. A
complete physical data model will include all the database
artifacts required to create relationships between tables or
achieve performance goals, such as indexes, constraint
definitions, linking tables, partitioned tables or clusters.
The physical data model can usually be used to calculate
storage estimates and may include specific storage
allocation details for a given database system.
The Physical Data Model (PDM) describes how the information
represented in the Logical Data Model is actually
implemented, how the information-exchange requirements are
implemented, and how the data entities and their
relationships are maintained.
There should be a mapping from a given Logical Data Model to
the Physical Data Model if both models are used. The form of
the Physical Data Model can vary greatly. For some purposes,
an additional entity-relationship style diagram will
suffice. The Data Definition Language (DDL) may also be
used. References to message format standards (which identify
message types and options to be used) may suffice for
message-oriented implementations. Descriptions of file
formats may be used when file passing is the mode used to
exchange information. Interoperating systems may use a
variety of techniques to exchange data, and thus have
several distinct partitions in their Physical Data Model
with each partition using a different form.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is spliterator in java se 8?
What are the types of cookies in java?
What happens when you omit a brace or misspell one of the words, like public or
What is java ioc?
how can we create the ui using netbeans,having the code?
Which is faster c++ or java?
What is aop in java?
program A and B are analysed and found to have worst case running time greater than 150NlogN and N*N respectively. which program has the better guarantee after the running time for the large values of N(N>10000)? which program has the better guarantee for the running time of small program N (N<100)? which program will run faster on average for N=1000?
0 Answers St. Pauls University,
Iam working as a Project Lead in a s/w comp.The follwing question was asked in HCL interview. What about the schedule slippage? If the developer has taken more time than the specified time. How do you adjust the time? From where do you allocate that extra time for the developer?
What is java persistence api used for?
What is the difference between Enumeration and Iteration interfaces? What is the way of to retreive the objects from these interfaces ?
How do I install eclipse?