Business Domain

Create a New Business Domain

• Enter the business domain name (limited to 50 characters);

• Select the referenced data source;

• After creation, you can enter the business domain management interface.

Add Data Tables and Relationship Modeling

• Add multiple business-related data tables as "business domain nodes";

• Each node represents a table, and multiple nodes can be added;

• Click the "Relationship List" of each table node to add relationships:

  • Set the From field (field in the current table);

  • Set the To table and its field (target table and target field);

  • Select the relationship type: one-to-one, one-to-many, many-to-one, many-to-many;

  • Submit to complete the relationship binding between the two tables.

In this way, users can build a complete data relationship network within the business domain, facilitating subsequent intelligent queries and chart generation.

Relationship Overview

Displays all tables in the business domain and their structural relationships, facilitating global understanding and management.

Parameterized Templates

Supports creating SQL templates with parameterized variables to flexibly meet data query needs in different scenarios.

• Parameters (such as date, department, region, etc.) can be defined in the template and inserted into the SQL statement as placeholders;

• When called, users can input different parameter values, and the system will automatically generate the corresponding SQL query;

• Suitable for commonly used queries that require flexible condition adjustments, significantly improving reusability and query efficiency;

• Parameters can have default values and input restrictions to ensure the accuracy and security of query results.

Example:

SELECT * FROM Sales where t1.c1 = "{value1}"
SELECT * FROM Sales where t1.c1 in ({value1})
SELECT * FROM Sales where t1.c1 like "%{value1}%"

Import and Export of Parameterized Templates

To facilitate migration or batch deployment of query templates across different environments (such as development, testing, production), the system supports import and export of parameterized templates.

• Implementation or delivery personnel can export multiple templates at once and quickly import them into the target system, greatly reducing repetitive configuration work;

• Supports version management and batch updates of templates, which is beneficial for team collaboration and unified template maintenance.

Reference Templates

Provides a series of system preset query templates to help users quickly understand and reuse standardized modeling methods.

• Template examples cover common business scenarios such as sales analysis, inventory statistics, customer profiling, etc.;

• Users can refer to the logical structure and field settings of the templates to customize models that meet their own business needs;

• Supports copying, modifying, and saving based on reference templates to quickly build personalized data relationship models;

• Facilitates unified data modeling standards within teams, improving overall usage consistency.