DataSphere Studio (DSS)

repository·master·Indexed 25 days ago

https://github.com/webankfintech/dataspherestudio

A comprehensive data application development management portal by WeBank. DSS provides a unified, pluggable framework for the entire data lifecycle, including ingestion, cleaning, analysis, visualization, and scheduling. It features AppConn for system integration, Workspace for collaborative management, and includes Scriptis, an interactive data analysis platform for SQL, PySpark, and HiveQL. The ecosystem also includes @dataspherestudio/cyeditor, a workflow editing view based on Cytoscape.js.

Tokens
28K
Snippets
31
Records
189
Agent score
81%

What's inside DataSphere Studio

  1. Overview of DataSphere Studio (DSS)

    master

    DataSphere Studio (DSS) is an integrated framework for managing data application development, developed by WeBank. It uses a pluggable architecture and the Linkis computing middleware to connect various data application systems.

    Key capabilities include:

    • Workflow-based development: A graphical drag-and-drop experience for the full data lifecycle (exchange, cleaning, analysis, quality testing, visualization, scheduling, and output).
    • Pluggable components: Users can easily replace existing integrated components or add new ones.
    • Enterprise-grade execution: Leverages Linkis for high concurrency, high availability, multi-tenant isolation, and resource control.
    • Workspace management: Uses 'Workspace' as the management unit to organize business applications and provide user role management.
  2. Overview of Scriptis features

    master

    Scriptis is an interactive data analysis platform designed for script development (SQL, Pyspark, HiveQL), task submission (Spark, Hive), UDF management, function management, resource management, and intelligent diagnosis.

    Key capabilities include:

    • Script Editor: Multi-language support with auto-completion, syntax highlighting, and SQL syntax error-correction.
    • Computation Engines: Integration with multiple engines (Spark, Hive, Python, etc.) via Linkis.
    • Runtime Functionality: Full job life cycle display and intelligent diagnosis.
    • Result Set Management: Support for multiple result sets, customized aliases, and one-click visualization.
    • Database Services: Database management and CSV/Excel import/export functionality.
    • Context Management: Management and sharing of UDFs, custom variables, and functions.
    • Console: Engine parameter customization, task/engine management, and resource isolation/display.
  3. Overview of @dataspherestudio/cyeditor

    master
    The @dataspherestudio/cyeditor package provides a workflow editing view for DSS (DataSphere Studio). It is built by extending Cytoscape.js, a JavaScript library for analyzing and visualizing complex network data. It supports custom node/edge styling, various layout algorithms (circular, force-directed, matrix, etc.), and rich interactions like dragging, zooming, and selecting.
  4. Introduction to Scriptis

    master
    Scriptis is an interactive data analysis platform designed for script development (SQL, Pyspark, HiveQL), task submission (Spark, Hive), UDF and function management, resource management, and intelligent diagnosis. It provides a unified interface for managing the complete job lifecycle and interacting with multiple computation engines via Linkis.
  5. Overview of Scriptis

    master

    Scriptis is a web-based data analysis tool designed for writing and executing scripts such as SQL, PySpark, and HiveQL. It leverages Linkis as the underlying execution engine to connect with multiple computing engines including Spark, Hive, and TiSpark.

    Key capabilities include:

    • Script Editing: Multi-language support with auto-completion, syntax highlighting, and SQL error correction.
    • Runtime Management: Full job lifecycle visibility and error code reporting.
    • Context Management: Management of UDFs (User Defined Functions), function sharing, and custom variables.
    • Result Set Handling: Support for multiple result sets, custom aliases, and one-click publishing to reporting systems.
    • Database & Data Management: Database management and fast import/export of CSV/Excel files to tables.
    • Administrative Console: Multi-tenant resource control, personalized engine parameter configuration, and task/session management.
  6. Understand the Workspace management unit

    master

    In DSS, the Workspace serves as the primary management unit. It is used to:

    • Organize and manage business applications across various data application systems.
    • Define common standards for collaborative development within workspaces.
    • Provide user role management capabilities.
  7. Understand the AppConn integration concept

    master

    AppConn is the core application connector concept in DSS that enables the integration of various upper-layer web systems. It defines a set of unified three-level integration protocols:

    1. First-level: SSO (Single Sign-On) specification.
    2. Second-level: Organizational structure specification.
    3. Third-level: Development process specification.

    By arranging multiple AppConns in series, DSS forms workflows that support both real-time and scheduled execution. Because AppConn is integrated with Linkis, external systems benefit from shared resource management, concurrent limiting, and sharable context across the system level.

  8. Project Structure of DataSphereStudio Web

    master

    The web project is organized into a monorepo structure where core logic and individual applications reside in the packages directory. The dist directory contains the built static assets after compilation.

    ├─dist              # 构建后静态资源
    ├─docs              # 文档
    ├─node_modules
    └─packages          # 各应用模块
        ├─apiServices
        ├─dataGovernance
        ├─dataService
        ├─dolphinScheduler
        ├─dss
        ├─scheduleCenter
        ├─scriptis
        ├─shared
        │  ├─common
        │  └─components
        ├─workflows
        └─workspace
  9. Scriptis Core Features

    master

    Scriptis provides the following capabilities for data engineering and analysis:

    • Script Editor: Supports multi-language development with auto-completion, syntax highlighting, and SQL syntax error-correction.
    • Computation Engines: Connects to multiple engines (Spark, Hive, Python, etc.) based on Linkis.
    • Runtime Functionality: Provides complete job life cycle display and intelligent diagnosis.
    • Result Set Management: Supports multiple result sets, customized result set aliases, and one-click visualization.
    • Database Services: Includes functionalities for database management and importing/exporting files (CSV, Excel) to/from tables.
    • Context Management: Management and sharing of UDFs, custom variables, and functions.
    • Console: Customized settings for engine parameters, task/engine management, and resource isolation/display.
  10. Identify suitable use cases for DSS

    master

    DataSphere Studio (DSS) is designed for the following scenarios:

    1. Organizations building or starting to develop big data platform capabilities but lacking data application tools.
    2. Organizations with existing big data infrastructure but only a limited number of data application tools.
    3. Organizations with complete data application tools that are currently siloed, causing high learning costs and a fragmented user experience.
    4. Organizations with complete data application tools where some integration exists, but unified standards and specifications have not yet been defined.
  11. Understand the DSS Template project structure

    master

    The project is organized into the following directory structure:

    • dist/: Static assets after build.
    • node_modules/: Project dependencies.
    • exts/: Extension plugins.
    • packages/: Core application modules, including:
      • dss: DSS core module.
      • shared: Shared utilities and components.
      • workspace: Workspace management module.