Is there a canonical definition for database schema (schema)?

Asked

Viewed 114 times

2

Each bank seems to define scheme (schema) in a different way.

See for example the Mysql, the MS SQL Server, the Postgresql...

Is there a relevant canonical definition or does only the individual definitions matter?

database terminology schema
  • 1

    I think the closest thing to that is the definition of schema in ISO/IEC 9075. Unfortunately you have to pay to get a copy of that document (I couldn’t link anything here). That said, I have read nothing in the specification that definitively resolves the impasse over which is the most "correct" implementation of schema. Although, at least for a layman in Databases design like me, Postgresql and Sqlserver appear to follow the pattern more closely.

  • There is a standardized way of consulting the information of the schemes, called INFORMATION SCHEMA. See https://en.wikipedia.org/wiki/Information_schema

1 answer

2


I can’t say, I’m not an expert on the subject and I don’t circulate in academic circles that use this kind of information better, but I would start with Wikipedia. Not that she’s always reliable, but it’s always a good start to finding what you want. Once confirmed, it may be that the information there is briefly canonical.

You are right that each SGDB uses the way it interprets, so it is that thing, there may even be something canonical, but what’s the point if this form is not followed in practice? So in practice the definition of each has become more important. For those who want to be an expert in databases should know well the canonical as well, even if it fits interpretation, this may not be exactly possible. Having your own well-founded interpretation may even be more important than having something canonical.

Browser other questions tagged database terminology schema

You are not signed in. Login or sign up in order to post.