Home
Designing databasesThe first step in creating a relational database is to construct a data model, which is a precise, complete definition of the data you want to store. After you prepare your data model, you must implement it as a database and tables. To implement your data model, you first select a data type for each column and then you create a database and tables and populate the tables with data. You can also implement fragmentation strategies and control access to your data.
Designing and Implementing a DatabaseThe HCL OneDB™ Database Design and Implementation Guide provides information to help you design, implement, and manage your HCL® OneDB® databases. It includes data models that illustrate different approaches to database design and shows you how to use structured query language (SQL) to implement and manage your databases.
Object-relational databases
Type and table inheritance
Type inheritance

Type inheritance

Type inheritance applies to named row types only. You can use inheritance to group named row types into a type hierarchy in which each subtype inherits the representation (data fields) and the behavior (UDRs, aggregates, and operators) of the supertype under which it is defined. A type hierarchy provides the following advantages:

It encourages modular implementation of your data model.
It ensures consistent reuse of schema components.
It ensures that no data fields are accidentally left out.
It allows a type to inherit UDRs that are defined on another data type.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.