Database Operations

Scenario

RTDService provides a UI for users to create databases and use SQL statements to add, delete, modify, and query databases.

This function also allows tenant system administrators to create data tables and index tables in MOTService through DDL.

Tenant system administrators and tenant service administrators can view table data through DQL and add, delete, and modify data through DML.

Procedure

1. Log in to the RTD web UI and select a tenant. For details, see Accessing the RTDService Web UI.
2. Choose Business Management > Database Operator > Database Operator.
   • In the pane on the right of the displayed page, select a specified cluster group and active/standby group from the Group DB and HA DB drop-down lists, respectively.
   • Select DDL from the Operation drop-down list and enter a SQL command for database modeling. Click the run button in the upper right corner of the pane to submit the table creation statement.
   • The RTD application administrator and RTD service administrator can query data tables through DQL.
   • The RTD application administrator and RTD service administrator can add, delete, and modify data tables through DML.
     

     The timestamp field corresponding to the dimension time must be NOT NULL in the creation statement of the event source table. Otherwise, expired data cannot be deleted.