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.
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
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.
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.
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.
Smart Images

Figure CN112203262B_ABST
Abstract
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.
