Home
Data warehousingIn addition to designing and implementing HCL OneDB™ dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries.
Dimensional databasesThe HCL OneDB™ Data Warehouse Guide provides information to help you design, implement, and manage dimensional databases, and describes the tools that you can use to create data warehouses and optimize your data warehouse queries.
Implement a dimensional databaseYou will learn the SQL statements that you need to implement the dimensional data model
Implement the sales_demo dimensional database
Create the dimensional databaseYou must create the dimensional database before you can create any of the tables or other objects that the database must contain.

Create the dimensional database

You must create the dimensional database before you can create any of the tables or other objects that the database must contain.

When you use the HCL® OneDB® database server to create a database, the server sets up records that show the existence of the database and its mode of logging. The database server manages disk space directly, so these records are not visible to operating-system commands.

The following statement shows the syntax that you use to create a database that is called sales_demo:

CREATE DATABASE sales_demo

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.