Designing databases

The 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.

Additional resources

• Database concepts Describes fundamental database concepts.
• Dimensional databases Design, implement, and manage dimensional databases.
• User-Defined Routines and Data Types Developer's Guide Define new data types, create new casts, extend operator classes for secondary-access methods, write opaque data types, and create and register routines.

External resource

• HCL® Data Studio ( Knowledge Center) HCL Data Studio is an Integrated Data Management environment. Data architects, developers, and database administrators can use HCL Data Studio to collaborate throughout the data-driven application development lifecycle. HCL Data Studio and the underlying workbench technology are introduced, and how to use its integrated development environment to achieve your database development goals is explained.

Main resource