Skip to Content
avatar image
Former Member

Schemas

Hi Experts

Can any explain the difference between the physical and logical schema with example?

Thanks

Pooja

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 25, 2013 at 06:43 AM

    Hi Pooja,

    Am I correct in assuming you are referring to database design in general? If so take a look at the following definition;

    http://en.wikipedia.org/wiki/Database_design

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25, 2013 at 11:02 AM

    Hi Pooja,

    for each user in HANA, a default schema is created. A schema is a collection of objects like Tables, views, sequences etc. It is sort of a container to hold the objects.

    A user can have multiple schemas, but practically I haven't seen that yet. Mostly one schema per user (Default schema) is created.

    Regarding logical and physical, it is similar to having the logical database design and physical database design. The logical model is closer to business terms, it uses business domains and mappings. It is realized in physical form in form of tables and constraints etc.

    Regards,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded