A multi-person ETL collaboration method based on Web Bluetooth

Through the ETL multi-person collaboration method based on Web Bluetooth, Bluetooth connectivity is used to realize real-time data mutual transmission between multiple user computers, solving the problem of high communication and time costs in existing ETL collaboration, improving data accuracy and Comprehensiveness promotes the quality of decision-making analysis.

CN112203262BActive Publication Date: 2024-12-03XIAMEN NANXUN CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202010996627.2
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2020-09-21
Publication Date
2024-12-03
Estimated Expiration
2040-09-21

AI Technical Summary

Technical Problem

The existing ETL operating systems have high communication and time costs in the collaboration process, which affects the accuracy of the data and lacks the true multi-person collaboration capabilities.

Method used

Using the ETL multi-person collaboration method based on Web Bluetooth, by building the Web Bluetooth API, Bluetooth connection is used to realize real-time ETL node data mutual transmission between multiple user computers, supporting collaborative development of different departments and business personnel.

Benefits of technology

Real-time ETL node data mutual transmission between multiple user-side computers is realized, which improves the accuracy and comprehensiveness of data and promotes the quality of decision-making analysis.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN112203262B_ABST
    Figure CN112203262B_ABST
Patent Text Reader

Abstract

The invention discloses an ETL multi-person collaboration method based on Web Bluetooth, which is implemented based on an ETL operation system. The method comprises the following steps: constructing a Web Bluetooth API for the ETL operation system; turning on Bluetooth for a user-side computer that needs to perform ETL collaboration; the user enters the ETL processing interface of the ETL operation system and initiates a collaboration request; after receiving the collaboration request, the Web Bluetooth API scans the surrounding Bluetooth signals and selects the user-side computer that needs to collaborate for connection; and performing ETL collaboration processing on the ETL processing page on the user-side computer that is successfully connected via Bluetooth.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to an ETL multi-person collaboration method based on Web Bluetooth. Background Art

[0002] With the development of enterprise informatization, more and more enterprises have established their own data warehouses to support decision analysis and decision making in business management. ETL (abbreviation of Extract-Transform-Load, i.e. the process of data extraction, transformation and loading) is used to load the data of the business system into the data warehouse after extraction, cleaning and transformation. It is an important part of building a data warehouse, and the ability of ETL processing is crucial.

[0003] Since the enterprise's data warehouse contains data from all aspects of the enterprise (such as product data, marketing data, customer data, operation and maintenance data, etc.), the ETL processing process will involve different departments, different business lines and different personnel for different data. Therefore, the collaboration of ETL processing has become an important part of building a comprehensive and accurate data factory.

[0004] At present, most ETL operation systems use web systems. The common practice for ETL collaboration is that the output of one ETL is used as the input of the next ETL, and all ETL node data is stored in the database. The author of the ETL can share and publish the ETL for others to use. In essence, this is not real collaboration, but also brings communication and time costs, which in turn affects the accuracy of the data. Summary of the invention

[0005] In order to solve the above problems, the present invention provides an ETL multi-person collaboration method based on Web Bluetooth.

[0006] The present invention adopts the following technical solutions:

[0007] A Web Bluetooth-based ETL multi-person collaboration method is implemented based on an ETL operation system. The method includes the following steps:

[0008] S1. Build a Web Bluetooth API for the ETL operation system;

[0009] S2. Turn on Bluetooth for the user computer that needs to perform ETL collaboration;

[0010] S3. The user enters the ETL processing interface of the ETL operation system and initiates a collaboration request;

[0011] S4. After receiving the collaboration request, the Web Bluetooth API scans the surrounding Bluetooth signals and selects a user terminal computer that needs collaboration for connection;

[0012] S5. The user computer successfully connected via Bluetooth performs ETL collaborative processing on the ETL processing page.

[0013] Preferably, the ETL collaborative processing is specifically:

[0014] ETL node data transmission: select the ETL node to be transmitted, submit the data transmission request, and the ETL operation system will send the selected ETL node data to the connected user computer through the Web Bluetooth API;

[0015] ETL node data reception, submitting data reception request, the ETL operation system receives the ETL node data sent by the Web Bluetooth API and copies it to the current ETL processing interface.

[0016] Preferably, the submitting of the data sending request is achieved by performing a shortcut key operation on the user-side computer.

[0017] Preferably, the submitting of the data receiving request is achieved by performing a shortcut key operation on the user-side computer.

[0018] Preferably, the Web Bluetooth API is integrated into an ETL operating system.

[0019] Preferably, the ETL operation system is a Web application system.

[0020] Preferably, the initiating collaboration request specifically includes: the user clicks a multi-person collaboration button through the ETL processing interface to start the collaboration mode, and sends a Bluetooth connection request to the Web Bluetooth API.

[0021] Preferably, the user-side computers are configured for different departments and different business personnel.

[0022] After adopting the above technical solution, the present invention has the following advantages compared with the background technology:

[0023] This technology can realize real-time ETL node data transmission between multiple user-side computers, so that people from different departments or familiar with different businesses can collaborate on the development of ETL processes face to face, thereby making better use of existing business data and producing more comprehensive and accurate data for decision-making analysis. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1It is a schematic diagram of the process of the present invention. DETAILED DESCRIPTION

[0025] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention.

[0026] Example

[0027] refer to Figure 1 As shown, the present invention discloses an ETL multi-person collaboration method based on Web Bluetooth, which is implemented based on an ETL operation system. The ETL operation system adopts a Web application system. The method includes the following steps:

[0028] S1. Build Web Bluetooth API for ETL operation system. Web Bluetooth API is integrated into ETL operation system.

[0029] S2. Turn on Bluetooth for the client computers that need to perform ETL collaboration. The client computers are configured for different departments and business personnel.

[0030] S3. The user enters the ETL processing interface of the ETL operation system and initiates a collaboration request. The user clicks the multi-person collaboration button on the ETL processing interface to start the collaboration mode and sends a Bluetooth connection request to the Web Bluetooth API.

[0031] S4. After receiving the collaboration request, the Web Bluetooth API scans the surrounding Bluetooth signals and selects the user-side computer that needs collaboration for connection.

[0032] S5. The user computer successfully connected via Bluetooth performs ETL collaborative processing on the ETL processing page. ETL collaborative processing is specifically as follows:

[0033] ETL node data transmission, select the ETL node to be sent, submit the data transmission request, and the ETL operation system sends the selected ETL node data to the connected user computer through the Web Bluetooth API. Submitting the data transmission request is achieved by using shortcut keys on the user computer (such as pressing Ctrl+Alt+T).

[0034] ETL node data reception, submitting data reception request, the ETL operation system receives the ETL node data sent by the Web Bluetooth API and copies it to the current ETL processing interface. Submitting the data reception request is achieved by using shortcut keys on the user's computer (such as pressing Ctrl+Alt+R).

[0035] The above is only a preferred specific embodiment of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed by the present invention should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention should be based on the protection scope of the claims.

Claims

1. An ETL multi-person collaboration method based on Web Bluetooth, characterized in that: Based on the ETL operation system, the method includes the following steps: S1. Build a Web Bluetooth API for the ETL operation system; S2. Turn on Bluetooth for the user computer that needs to perform ETL collaboration; S3. The user enters the ETL processing interface of the ETL operation system and initiates a collaboration request; S4. After receiving the collaboration request, the Web Bluetooth API scans the surrounding Bluetooth signals and selects a user terminal computer that needs collaboration for connection; S5. The user computer successfully connected via Bluetooth performs ETL collaborative processing on the ETL processing page; The ETL collaborative processing is specifically as follows: ETL node data transmission: select the ETL node to be transmitted, submit the data transmission request, and the ETL operation system will send the selected ETL node data to the connected user computer through the WebBluetooth API; ETL node data reception, submitting data reception request, the ETL operation system receives the ETL node data sent by the Web Bluetooth API and copies it to the current ETL processing interface.

2. The ETL multi-person collaboration method based on Web Bluetooth as claimed in claim 1, characterized in that: The submitting of the data sending request is realized by performing a shortcut key operation on the user-side computer.

3. The ETL multi-person collaboration method based on Web Bluetooth as claimed in claim 1, characterized in that: The submitting of the data receiving request is achieved by performing a shortcut key operation on the user-side computer.

4. The ETL multi-person collaboration method based on Web Bluetooth as claimed in claim 1, characterized in that: The Web Bluetooth API is integrated into the ETL operation system.

5. The ETL multi-person collaboration method based on Web Bluetooth as claimed in claim 1, characterized in that: The ETL operation system is a Web application system.

6. The ETL multi-person collaboration method based on Web Bluetooth as claimed in claim 1, characterized in that: The initiation of the collaboration request specifically includes: the user clicks the multi-person collaboration button through the ETL processing interface to start the collaboration mode, and sends a Bluetooth connection request to the WebBluetooth API.

7. The ETL multi-person collaboration method based on Web Bluetooth as claimed in claim 1, characterized in that: The user-side computers are configured for different departments and different business personnel.