CN114417408B - Data processing method, device, equipment and storage medium - Google Patents
Data processing method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN114417408B CN114417408B CN202210053524.1A CN202210053524A CN114417408B CN 114417408 B CN114417408 B CN 114417408B CN 202210053524 A CN202210053524 A CN 202210053524A CN 114417408 B CN114417408 B CN 114417408B
- Authority
- CN
- China
- Prior art keywords
- data
- target
- format
- stream
- storage
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000003672 processing method Methods 0.000 title abstract description 19
- 238000012545 processing Methods 0.000 claims abstract description 112
- 238000004364 calculation method Methods 0.000 claims abstract description 58
- 238000006243 chemical reaction Methods 0.000 claims abstract description 31
- 238000000034 method Methods 0.000 claims description 40
- 230000015654 memory Effects 0.000 claims description 28
- 230000008569 process Effects 0.000 claims description 17
- 238000004590 computer program Methods 0.000 claims description 12
- 230000005856 abnormality Effects 0.000 claims description 5
- 230000003044 adaptive effect Effects 0.000 claims description 4
- 238000010586 diagram Methods 0.000 description 20
- 238000005070 sampling Methods 0.000 description 9
- 238000004891 communication Methods 0.000 description 8
- 238000013500 data storage Methods 0.000 description 6
- 238000000586 desensitisation Methods 0.000 description 6
- 239000012634 fragment Substances 0.000 description 6
- 230000006870 function Effects 0.000 description 6
- 238000004422 calculation algorithm Methods 0.000 description 3
- 230000006835 compression Effects 0.000 description 3
- 238000007906 compression Methods 0.000 description 3
- 238000005538 encapsulation Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000010801 machine learning Methods 0.000 description 2
- 238000004806 packaging method and process Methods 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 239000000872 buffer Substances 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000013467 fragmentation Methods 0.000 description 1
- 238000006062 fragmentation reaction Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000001953 sensory effect Effects 0.000 description 1
- 238000000638 solvent extraction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6245—Protecting personal data, e.g. for financial or medical purposes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Databases & Information Systems (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Medical Informatics (AREA)
- Storage Device Security (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The disclosure provides a data processing method, apparatus, device and storage medium. The technical field of computers is related to, and especially the fields such as big data, cloud computing, information security are related to. The specific implementation scheme is as follows: acquiring target data from each data source, wherein the target data comprises at least one type of data; respectively carrying out format conversion on different types of data in each target data to obtain a first data stream of each target data, wherein the format of the first data stream is a preset target format; privacy calculation processing is carried out on each first data stream respectively to obtain a second data stream of each target data; and generating data to be stored of each target data based on each second data stream. According to the technical scheme disclosed by the invention, the processing efficiency of the diversified data source data can be improved.
Description
Technical Field
The present disclosure relates to the field of computer technology, and in particular to the fields of big data, cloud computing, information security, and the like.
Background
With the advent of the big data era, diversified processing of data sources becomes a difficult problem to be solved, and particularly, privacy calculation processing needs to be performed on data from diversified data sources, and the data sources are characterized by large data volume and many files. Therefore, the processing efficiency is low.
Disclosure of Invention
The disclosure provides a data processing method, apparatus, device, storage medium and computer program product.
According to a first aspect of the present disclosure, there is provided a data processing method, including:
acquiring target data from each data source, wherein the target data comprises at least one type of data;
respectively carrying out format conversion on different types of data in each target data to obtain a first data stream of each target data, wherein the format of the first data stream is a preset target format;
privacy calculation processing is carried out on each first data stream respectively to obtain a second data stream of each target data;
and generating data to be stored of each target data based on each second data stream.
According to a second aspect of the present disclosure, there is provided a data processing apparatus comprising:
the acquisition module is used for acquiring target data from each data source, and the target data comprises at least one type of data;
the first format conversion module is used for respectively carrying out format conversion on different types of data in each target data to obtain a first data stream of each target data, and the format of the first data stream is a preset target format;
the privacy calculation module is used for respectively carrying out privacy calculation processing on each first data stream to obtain a second data stream of each target data;
and the generating module is used for generating the data to be stored of each target data based on each second data stream.
According to a third aspect of the present disclosure, there is provided an electronic device comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of the first aspect.
According to a fourth aspect of the present disclosure, there is provided a non-transitory computer readable storage medium having stored thereon computer instructions for causing a computer to perform the method provided by the first aspect.
According to a fifth aspect of the present disclosure, there is provided a computer program product comprising a computer program which, when executed by a processor, implements the method provided by the first aspect described above.
According to the technical scheme disclosed by the invention, the processing efficiency of the diversified data source data can be at least improved.
It should be understood that the statements in this section do not necessarily identify key or critical features of the embodiments of the present disclosure, nor do they limit the scope of the present disclosure. Other features of the present disclosure will become apparent from the following description.
Drawings
The drawings are included to provide a better understanding of the present solution and are not to be construed as limiting the present disclosure. Wherein:
FIG. 1 is a flow diagram of a data processing method according to an embodiment of the disclosure;
FIG. 2 is a schematic diagram of formatting before and after privacy computing processing according to an embodiment of the present disclosure;
FIG. 3 is a schematic diagram of normal processing and exception processing flow according to an embodiment of the present disclosure;
FIG. 4 is an overall logic block diagram of a diverse data source streaming process according to an embodiment of the disclosure;
FIG. 5 is a schematic interface diagram of data source processing according to an embodiment of the present disclosure;
FIG. 6 is a schematic diagram of a data write-out module interface according to an embodiment of the present disclosure;
FIG. 7 is a schematic diagram of an ORC file format according to an embodiment of the present disclosure;
FIG. 8 is a first block diagram of a data processing apparatus according to an embodiment of the present disclosure;
FIG. 9 is a second block diagram of a data processing apparatus according to an embodiment of the present disclosure;
FIG. 10 is a schematic diagram of a data processing scenario according to an embodiment of the present disclosure;
fig. 11 is a block diagram of an electronic device for implementing a data processing method of an embodiment of the present disclosure.
Detailed Description
Exemplary embodiments of the present disclosure are described below with reference to the accompanying drawings, in which various details of embodiments of the present disclosure are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the disclosure. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
The terms "first," "second," and "third," etc. in the description and claims of the present disclosure and the above-described figures are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. Furthermore, the terms "comprises" and "comprising," as well as any variations thereof, are intended to cover a non-exclusive inclusion, such as a list of steps or elements. A method, system, article, or apparatus is not necessarily limited to those steps or elements explicitly listed, but may include other steps or elements not explicitly listed or inherent to such process, system, article, or apparatus.
The embodiment of the present disclosure provides a data processing method, which may be applied to an electronic device including, but not limited to, a fixed device and/or a mobile device, for example, the fixed device includes, but not limited to, a server, and the server may be a cloud server or a general server. For example, mobile devices include, but are not limited to: one or more of a cell phone or a tablet computer. As shown in fig. 1, the data processing method includes:
s101, acquiring target data from each data source, wherein the target data comprises at least one type of data;
s102, performing format conversion on different types of data in each target data respectively to obtain a first data stream of each target data, wherein the format of the first data stream is a preset target format;
s103, performing privacy calculation processing on each first data stream to obtain a second data stream of each target data;
and S104, generating data to be stored of each target data based on each second data stream.
Wherein the present disclosure does not limit the type of data source. Such as JDBC data sources, S3 data sources, oracle data sources, postgreSQL data sources, mySQL data sources, etc.
Here, the target data is data to be processed acquired from a data source, and the target data may be represented in the form of a data stream. It is understood that the target data obtained by different data sources may include the same data type, but the target data obtained by different data sources is different.
Wherein the present disclosure does not limit the type of data. Such as picture data, text data, voice data, etc.
Here, the different types of data correspond to different format converters. The format converter may be subdivided into an input format converter and an output format converter. The first data stream in S102 is converted by the input format converter.
For example, the input format converter is divided into at least: a Sample input Format (Sample input Format) converter, an Annotation input Format (Annotation input Format) converter, a Full Data input Format (Full Data input Format) converter, a Csv input Format (Csv input Format) converter, and a Jdbc input Format (Jdbc input Format) converter.
Illustratively, target data of a data type of sampling is converted by a sampling input format, target data of a data type of annotation is converted by an annotation input format, target data of a data type of integrity data is converted by an integrity data input format, and target data of a data type of Csv data is converted by a Csv input format. That is, for example, data of which data type is Csv is converted by the Csv input format converter regardless of the data source; for another example, data of which the data type is Txt is converted by a Txt format converter regardless of the data source.
Here, the preset target format is a virtual table format. The content represented by each column is the same for virtual tables of different target data. Of course, the content represented by each column in the virtual table can be set or adjusted according to actual needs and user requirements.
Illustratively, in a virtual table, the first column represents the file name; a second column representing data of the picture itself; and the third column, the binary information of the markup file.
Here, the privacy calculation processing includes, but is not limited to, at least one type of: sampling treatment and desensitization treatment.
The embodiments of the present disclosure do not limit the type of privacy computation processing. Through the privacy calculation processing, partial data can be replaced so as to protect the safety of the data.
Here, the second data stream is a data stream obtained by performing privacy computation processing on at least part of data in the first data stream. That is, at least a portion of the data in the second data stream is different from the first data stream. The second data stream is in the same format as the first data stream.
Here, the data to be stored is data conforming to the target storage format. The target storage format is a column storage format, such as an (Optimized Row column, ORC) file format.
According to the technical scheme of the embodiment of the disclosure, target data from each data source is acquired; respectively carrying out format conversion on different types of data in each target data to obtain a first data stream of each target data; privacy calculation processing is carried out on each first data stream respectively to obtain a second data stream of each target data; and generating data to be stored of each target data based on each second data stream, so that the target data of different data formats of different data sources are converted into a unified preset target format, and then a series of operations such as privacy calculation processing, storage and the like are performed, so that the processing efficiency of the data of the diversified data sources can be improved, including the efficiency of the privacy calculation processing.
In some embodiments, obtaining target data from data sources comprises: determining each analyzer respectively adaptive to each data source; and streaming target data from each data source through each parser.
Wherein the parser can identify the type of data source to which it is connected, and can thereby determine whether data from that data source can be parsed. In practical application, different data sources are connected with the parser adapted to the different data sources, so that the parser can parse data acquired from the data sources connected with the different data sources.
Here, the streaming acquisition may be understood as that, for each parser, one piece of target data is acquired at the same time, and after the currently acquired target data is processed, the next piece of target data of each data source is acquired.
Illustratively, the parser is determined according to the type of the data source, such as a Jdbc data source with a Jdbc parser, an S3 data source with an S3 parser, an Oracle data source with an Oracle parser, a PostgreSQL data source with a PostgreSQL parser, and a MySQL data source with a MySQL parser.
As yet another example, the parser is determined based on a data source type and a data type. For example, the parser corresponding to the csv format data of the S3 data source is a csv sub parser of S3. The parser corresponding to the SQL format data of the Oracle data source is an SQL sub parser of Oracle.
Although the analytic modes of different resolvers are different, the data are read in a streaming mode, and the use of cache can be reduced by adopting the streaming reading, so that the resource utilization rate and the reading efficiency are improved.
Therefore, target data from different data sources are obtained through different resolvers, and for each resolver, the target data is obtained from the data source connected with the resolver in a streaming processing mode, so that basic support is provided for the streaming processing of data of diversified data sources, and therefore the privacy calculation of supporting multiple files and big data is achieved.
In some embodiments, the preset target format is a virtual table format, and format conversion is performed on different types of data in each target data to obtain a first data stream of each target data, including: respectively determining input format converters matched with different types of data in the target data; and respectively carrying out format conversion on different types of data in the target data through each input format converter to obtain a first data stream of each target data, wherein the first data stream is represented by a virtual table format.
Here, the first data streams of the respective target data are represented by the same kind of virtual table, that is, the content represented by each column is the same for the first data streams of the respective target data. It is understood that the content represented by each column in the virtual table can be set or adjusted according to actual needs, such as user requirements.
Illustratively, in a virtual table, the first column represents the file name; a second column, representing data of the picture itself; and the third column, the binary information of the markup file.
Illustratively, the sampling type data is input to the format converter through sampling to obtain a first data stream, the annotation type data is input to the format converter through annotation to obtain the first data stream, the csv type data is input to the format converter through csv to obtain the first data stream, and the Jdbc type data is input to the format converter through Jdbc to obtain the first data stream.
Therefore, format conversion is carried out on different types of data in each target data through different input format converters to obtain the first data stream of each target data, wherein the first data stream is represented by the virtual table format, so that the first data stream of the virtual table format only needs to be faced when privacy calculation processing is carried out subsequently, privacy calculation processing of different forms is not needed to be carried out on the data streams of different formats, the data source coverage of the privacy calculation processing can be improved, the calculation process of the privacy processing can be simplified, and the processing efficiency of the privacy calculation processing is improved.
In some embodiments, performing privacy computation processing on each first data stream to obtain a second data stream of each target data, includes: privacy calculation processing is carried out on each first data stream respectively to obtain data which are subjected to privacy calculation processing and correspond to each first data stream; and obtaining a second data stream of each target data based on the data which is subjected to privacy calculation processing and corresponds to each first data stream, wherein the format of the second data stream is a preset target format.
Here, the second data stream has the same format as the first data stream, and is a preset target format, such as a virtual table format.
Here, the privacy calculation process includes, but is not limited to, a sampling process and a desensitization process.
Therefore, the data processed by the privacy calculation is well formatted data, diversification of the data is shielded for the privacy calculation, and difficulty of the privacy calculation is reduced.
In some embodiments, the data processing method may further include: respectively determining each output format converter matched with different types of data in each target data; and passing the second data streams corresponding to the target data through the output format converters to obtain the updated second data streams. Generating data to be stored of each target data based on each second data stream, including: and generating the data to be stored of each target data, which meets the target storage format, based on each updated second data stream.
Here, the output Format converter includes, but is not limited to, a Sample output Format (Sample output Format) converter, an Annotation output Format (Annotation output Format) converter, and a Full Data output Format (Full Data output Format) converter.
Here, the number of kinds of output format converters is equal to or less than the number of kinds of input format converters.
Here, the target storage format is a columnar storage format, for example, the target storage format is an ORC file format. In some embodiments, the data tables are grouped (line groups) on a line basis and then the line groups are stored in a columnar manner. When the data is inquired, all the data does not need to be scanned, and only the appointed column needs to be inquired.
Fig. 2 shows a schematic diagram of formatting before and after privacy calculation processing, and as shown in fig. 2, target data is obtained from a data source in a streaming manner, format conversion is performed on the target data, then privacy calculation processing is performed, format conversion is further performed on the data after the privacy calculation processing, and finally data to be stored, which meet the target storage format, of each target data is generated. Here, some identification processing (e.g., prefixing) is performed on the partial data after the privacy calculation processing, but the data after the privacy calculation processing is not changed, such as prefixing identification for the picture data.
Thus, format conversion is carried out on the second data streams respectively corresponding to the target data through the output format converters to obtain the updated second data streams; generating data to be stored of each target data, which meets the target storage format, based on each updated second data stream; therefore, different storage processing modes are not needed to be adopted for different data sources during storage, and only a unified storage mode is needed, so that diversified data can be stored in a unified format, and the storage processing efficiency is improved.
In some embodiments, the data processing method may further include: and storing the data to be stored of each target data according to a preset storage mode.
Here, the preset storage manner includes: and the data storage device comprises independent memories distributed for the data sources, and independent data slices are divided in each memory and used for storing data to be stored. In each data slice, the initial position information and each column of attributes of each data slice and the header information of each column are stored through index metadata; data information; and storing each line of Data in a column form (Row Data is also called Row Group, and one Stripe corresponds to a plurality of Row groups.
In this way, after the diversified data source data is subjected to unified privacy calculation processing, unified format storage can be performed, and the overall streaming processing of the diversified data source data can be realized.
In some embodiments, storing the data to be stored of each target data according to a preset storage manner includes: respectively writing the data to be stored of each target data into the data slice of the memory corresponding to each data source; and uploading the data to be stored in the data pieces reaching the preset threshold value to a storage server under the condition that the data size of the data pieces corresponding to each data source reaches the preset threshold value.
Here, the preset threshold may be set or adjusted according to actual conditions. For example, the size of the memory allocated by the system for each data source is set. The preset threshold is less than or equal to the memory allocated by the system for each data source.
For example, if the preset threshold is 10 megabits, each line of data is written into a data slice stored in the memory first, and when the number of data reaches 10 megabits, the data in the data slice is uploaded to the storage server.
Here, the storage server is used for merging the data uploaded by all the data pieces of each data source.
Therefore, by uploading data on the data sub-chips, each line of data written in is written in the memory corresponding to each data source, so that the cache can be reasonably used, the input/output interface can be reasonably applied, and resources can be fully utilized.
In some embodiments, the storing the data to be stored of each target data according to a preset storage mode further includes: and uploading the data to be stored in the data slice of the memory corresponding to each data source to a storage server under the condition that the reading of each target data corresponding to each data source is finished.
Taking the size of a data slice as 10 million as an example, if the data in the data slice 1 corresponding to the data source 1 does not reach 10 million, but all the target data corresponding to the data source 1 are completely read or the connection with the data source 1 is disconnected, uploading the data in the data slice 1 to the storage server.
Therefore, the integrity of the target data of each stored data source can be ensured.
In some embodiments, the storing the data to be stored of each target data according to a preset storage mode further includes: and respectively merging the data of all the data slices corresponding to each data source through the storage server to obtain target storage data of each data source.
For example, the data source 1 includes target data 1 to 2n, the storage server receives data 1 to n to be stored uploaded by a data slice 1 of a memory corresponding to the data source 1 and data n +1 to 2n to be stored uploaded by a data slice 2 of the memory corresponding to the data source 1, and merges the data to be stored uploaded by the data slice 1 and the data slice 2 corresponding to the data source 1 to obtain the target storage data of the data source 1.
Therefore, as the data are uploaded to the storage server in the fragments and finally the fragments are combined, the cache can be reasonably used, the input/output interface can be reasonably applied, and the utilization rate of resources is improved.
In some embodiments, the data processing method may further include: determining a target database of each data source; and storing the target storage data of each data source to a target database of each data source.
And the target database corresponding to each data source can be set according to the configuration information.
Here, the target database is a final storage location of the target data of the data source after the privacy computation process. The present disclosure does not limit the type of target database. Such as a bos database, a minio database, an oss database, a Distributed File System (HDFS) database, etc.
The target databases corresponding to the data sources may be the same or different. For example, data source 1 corresponds to target database 1, and data source 2 and data source 3 correspond to target database 2.
In this way, the target data of the data source can be stored to the designated database according to the configuration information.
In some embodiments, the data processing method may further include: generating a fault event and reporting the fault event layer by layer under the condition that an abnormality occurs in the data processing process; and determining the fault occurrence reason according to the fault event.
Here, layer by layer means that a fault event is reported to a node at the previous stage where a fault occurs at the node at the current stage where the fault occurs, and so on until the fault event is reported to a node at the first stage. According to the data processing flow, each node comprises a task distribution node, a target data acquisition node, an input format conversion node, a privacy calculation processing node, an output format conversion node, a data writing-out processing node and a data storage node.
Fig. 3 shows a schematic diagram of normal processing and exception processing flows, and a solid line in fig. 3 represents a normal flow, specifically, the task distributor distributes tasks to the data source parser, generates a data stream through the data source parser, and writes the data stream into the data storage through the privacy calculation processing. In fig. 3, a dotted line represents an abnormal flow, specifically, in which module an abnormality occurs, an error is thrown layer by layer, and error information is recorded, and finally the error information is thrown into a task distributor, and the task distributor updates a task to be a failure and updates a failure reason.
Therefore, the data exception handling process can be reported in time, the fault event can be acquired in time, and the efficiency of handling the fault event is improved conveniently.
In order to facilitate understanding of the above data processing method, a specific implementation is given below.
The overall logic block diagram of the diversified data source streaming processing is shown in fig. 4, and a task distributor is responsible for processing tasks configured by a user and processing different tasks in a multi-thread concurrent manner. The task distributor acquires tasks and distributes thread processing tasks, wherein each task is realized by acquiring different data source information of a user through a data source analyzer, reading and converting the data source information into an iterator, and packaging the iterator into a data structure (such as a virtualization table), and the data structure also comprises data meta-information, such as the line number of data, the column number of data, the type of data and the like. In the process of packaging into the iterator, different types of file formats can be converted according to different format converters, converted into a unified format through an input formatting tool (namely, the input format converter), and then distributed to different processing implementations to perform sampling, desensitization and other processing on data through privacy calculation processing. The processed data is packaged into a new data structure, an iterator is included in the data structure, format conversion is carried out through an output formatting tool (namely an output format converter), the data structure is converted into a format which needs to be stored, and the data structure is written into a file storage system in a split mode through a data writing-out processing module. When the task distributor processes data, task scheduling is carried out based on multiple data types included by different data sources, and each task corresponds to the processing of data of one data type of one data source. The same data source can be provided with a plurality of data types, each data type can only be configured with one task, and the plurality of data types can be configured with a plurality of tasks and can schedule the plurality of tasks. The data read in a streaming mode is constructed into an iterator, the design of a nested iterator is carried out on multiple files, and the streaming data processing of subsequent privacy calculation can be achieved through the iterator. For example, for three files a, b, and c, 3 file name lists are first configured into iterators (3 iterations), each iteration reads a corresponding file internally, a corresponding file stream is configured into a file stream iterator, the file stream iterator is iterated, and then the next file is processed by the outer iterator.
In the framework, the data are read in a streaming mode, format conversion, privacy calculation and storage are adopted, data are read line by line, desensitization and sampling processing is carried out on the data line by line, and one line is written in after one line is processed.
Fig. 5 shows a schematic diagram of an interface of data source processing, wherein rectangles represent core interfaces, parallelograms represent abstract classes, and ovals represent different implementation classes of the interface in fig. 5. In fig. 5, a Data Source parser (Data Source) is used as a core interface, and it has different implementation classes of Data sources, such as S3, mysql, oracle, and other different Data Source parsing implementations. The Data Source interface is managed through a Data Source parser Factory interface (Data Source Factory), and corresponding parsers are found out according to different Data sources configured by users. The Data Source interface realizes format conversion of input Data stream through an input formatting tool, and the input formatting tool has different implementation classes according to the type of a file, such as: example file format converters, json file format converters, csv file format converters, and the like. The Data Source interface is also connected with a Data stream wrapper (Data Frame), and can acquire an iterator of each row of Data through the Data stream processing structure and acquire the meta information of the Data, such as the number of rows, the number of columns, the Data type and the like. The data stream encapsulator is further divided into a data read stream encapsulator, a data write stream encapsulator and a data storage stream encapsulator. The data read stream is an encapsulation of the stream generated by the user data source data. The data write stream is an encapsulation of the data generated after the privacy computation. The data storage stream is an encapsulation of the data to be stored. The data reading stream is divided into different implementation classes such as an S3 reading stream, a Mysql reading stream and the like. Similarly, the data write-out stream is divided into different implementation classes such as an S3 write-out stream, a Mysql write-out stream, and the like. The data storage stream is divided into different implementation classes such as an S3 storage stream, a Mysql storage stream and the like.
Fig. 6 shows a schematic diagram of a data writing-out module interface, where in fig. 6, a rectangle represents a core interface, a parallelogram represents an abstract class, and an ellipse represents different implementation classes of the interface. The Data writing-out module (Data Sink) is used as a core interface, and the Data writing-out module can have an implementation class (minio \ bos \ oss, etc.) for file storage writing of an S3 protocol, and can also be an implementation class for writing in other protocol storage systems. The Data writing-out module is managed through a Data Sink Factory interface (Data library), and different Data writing-out implementation classes can be selected according to different user configurations. The data writing-out module is connected with the output formatting tool and converts the processed data into a uniform format for storage. For example, a general output formatting tool may be implemented, and most of the formatted data may be supported. And (3) implementation of an unstructured output format converter, such as a picture data set, a large text, and the like.
Fig. 7 shows a schematic diagram of the format of the ORC file, which is not a pure columnar storage format, but is stored in columns within each row group by first partitioning the entire table according to the row group. The ORC file is self-describing, its metadata is serialized using Protocol Buffers, and the data in the ORC file is compressed as much as possible to reduce the consumption of storage space, and is also supported by search SQL, presto, and other query engines. In the hive table in the ORC format, a record is firstly transversely split into multiple strips, and then in each strip, data is stored in a column unit, and the contents of all columns are stored in the same file. When reading an ORC file, two pieces of position information are required to accurately perform the data reading operation. Since there are multiple groups in each stripe, the ORC reader (reader) needs to know the metadata stream (metadata streams) of each group and the starting position of the group recorded in the data stream (data streams). Since an ORC File can contain multiple strips, and an HDFS block can also contain multiple strips, in order to quickly locate the position of a given strip, it is necessary to know the start position of each strip, and this information can be stored in the File script (File font) of the ORC, as shown by the dashed line in the middle of fig. 7. Storage in the ORC file format has the following advantages:
1) ORC files are columnar stores, have multiple file compression modes, and have very high compression ratios. For example, the formatted data is stored in the OCR document in the form of fragments, each fragment is a certain number of rows of data, and each row stores the corresponding column data. Since compression is supported, the storage footprint is reduced.
2) The ORC file can be fragmented, large batches of data can be processed usually in privacy calculation processing, complete data source data can be fragmented and stored by utilizing the characteristics of the fragments, and data can be searched by directly positioning corresponding fragments according to index and algorithm searching during query without traversing all data, so that the query efficiency is increased.
3) The ORC file provides various complex data formats, and can store different data formats according to the supported data sources and service scenes, so that unified processing of diversified data is better realized.
4) Unified storage, different data sources and data types, such as structured data types Csv, json and the like, unstructured data pictures and large texts or machine learning data sets VOC, COCO and the like, can be subjected to unified column storage by utilizing the characteristics of ORC files, so that the formats of the data sources can be shielded when the data sources are read and used, and subsequent processing can be performed according to the unified formats.
In the following, an overall closed-loop flow of private computation streaming processing and unified storage in an isolated domain scene is provided, specifically as follows:
1) The user selects a corresponding data source and data type, such as: s3, a data source, csv data type;
2) Acquiring data source data in a streaming mode through different data sources according to the configuration of a user, constructing an iterator, and nesting and iterating a plurality of files;
3) Formatting the data through different formatting tools according to different data types;
4) Privacy calculation processing, namely acquiring formatted virtual table data through an iterator and a formatting tool, and performing stream-type calculation on the data, such as desensitization calculation, specified field statistics and the like;
5) The processed data is written into a data output layer in a streaming mode;
6) The data output layer accesses streaming data, constructs an ORC file and uploads the ORC file to the storage server in a fragmentation mode;
7) And analyzing the data by the user in a uniform data reading mode to perform subsequent algorithm operation.
Therefore, the private calculation of multiple files and big data can be supported through the streaming processing, the temporary use of the memory is less, and the calculation efficiency is good; in the storage, the privacy calculation processing results of diversified data sources can be stored in a unified format.
An embodiment of the present disclosure discloses a data processing apparatus, which may include, as shown in fig. 8:
an obtaining module 810, configured to obtain target data from each data source, where the target data includes at least one type of data;
a first format conversion module 820, configured to perform format conversion on different types of data in each target data, respectively, to obtain a first data stream of each target data, where a format of the first data stream is a preset target format;
the privacy calculation module 830 is configured to perform privacy calculation processing on each first data stream, so as to obtain a second data stream of each target data;
the generating module 840 is configured to generate data to be stored of each target data based on each second data stream.
In some embodiments, the obtaining module 810 is configured to:
determining each analyzer respectively adaptive to each data source;
and acquiring target data from each data source in a streaming mode through each parser.
In some embodiments, the predetermined target format is a virtual table format, and the first format conversion module 820 is configured to:
respectively determining input format converters matched with different types of data in the target data;
and respectively carrying out format conversion on different types of data in the target data through each input format converter to obtain a first data stream of each target data, wherein the first data stream is represented by a virtual table format.
In some embodiments, the privacy calculation module 830 is configured to:
privacy calculation processing is carried out on each first data stream respectively to obtain data which are subjected to privacy calculation processing and correspond to each first data stream;
and obtaining a second data stream of each target data based on the data which is subjected to privacy calculation processing and corresponds to each first data stream, wherein the format of the second data stream is a preset target format.
In some embodiments, as shown in fig. 9, the data processing apparatus may further include:
a second format conversion module 850 for:
respectively determining each output format converter matched with different types of data in each target data;
respectively corresponding second data streams of the target data to obtain updated second data streams through the output format converters;
the generating module is further configured to generate data to be stored of each target data, which satisfies the target storage format, based on each updated second data stream.
In some embodiments, as shown in fig. 9, the data processing apparatus may further include:
and the storage module 860 is configured to store the data to be stored of each target data according to a preset storage manner.
In some embodiments, the storage module 860 includes:
the writing submodule is used for respectively writing the data to be stored of each target data into the data sheet of the memory corresponding to each data source;
and the uploading sub-module is used for uploading the data to be stored in the data pieces reaching the preset threshold value to the storage server under the condition that the data size of the data pieces corresponding to the data sources reaches the preset threshold value.
In some embodiments, the upload module is further configured to:
and uploading the data to be stored in the data slice of the memory corresponding to each data source to a storage server under the condition that the reading of each target data corresponding to each data source is finished.
In some embodiments, the storage module 860 further comprises:
and the merging submodule is used for merging the data of all the data slices corresponding to each data source through the storage server to obtain target storage data of each data source.
In some embodiments, the storage module 860 further comprises:
the determining submodule is used for determining a target database of each data source;
and the storage submodule is used for storing the target storage data of each data source to the target database of each data source.
In some embodiments, as shown in fig. 9, the data processing apparatus may further include:
an exception handling module 870 to:
generating a fault event and reporting the fault event layer by layer under the condition that an abnormality occurs in the data processing process;
and determining the fault occurrence reason according to the fault event.
It should be understood by those skilled in the art that the functions of the processing modules in the data processing apparatus according to the embodiments of the present disclosure may be understood by referring to the description of the foregoing data processing method, and the processing modules in the data processing apparatus according to the embodiments of the present disclosure may be implemented by analog circuits that implement the functions described in the embodiments of the present disclosure, or by running software that performs the functions described in the embodiments of the present disclosure on electronic devices.
The data processing device of the embodiment of the disclosure can process diversified data sources in a unified format, thereby improving the processing efficiency of the diversified data sources; in addition, in the storage process, the occupied memory is less, and the diversified data sources can be stored in a unified format, so that when the stored data is read or used, the format of the data sources can be shielded, and the data can be processed according to the unified format.
Fig. 10 is a schematic view of a data processing scenario, and as can be seen from fig. 10, an electronic device such as a cloud server receives target data from a diversified data source, and performs format conversion on different types of data in each target data to obtain a first data stream of each target data, where the format of the first data stream is a preset target format; privacy calculation processing such as sampling processing or desensitization processing is carried out on each first data stream respectively to obtain a second data stream of each target data; generating data to be stored of each target data based on each second data stream; respectively storing the data to be stored of each target data according to a preset storage mode, for example, writing the data into the data slice of the memory corresponding to each data source, uploading the data stored in the data slice reaching the preset threshold to a storage server under the condition that the size of the data in the data slice corresponding to each data source reaches the preset threshold, and merging the data of all the data slices corresponding to each data source through the storage server to obtain the target storage data in the ORC file format of each data source; and, the target storage data of each data source can be stored in the target database of each data source.
It should be understood that the scene diagram shown in fig. 10 is only illustrative and not restrictive, and those skilled in the art may make various obvious changes and/or substitutions based on the example of fig. 10, and the obtained technical solution still belongs to the disclosure scope of the embodiments of the present disclosure.
In the technical scheme of the disclosure, the acquisition, storage, application and the like of the personal information of the related user all accord with the regulations of related laws and regulations, and do not violate the good customs of the public order.
The present disclosure also provides an electronic device, a readable storage medium, and a computer program product according to embodiments of the present disclosure.
FIG. 11 shows a schematic block diagram of an example electronic device 1100 that may be used to implement embodiments of the present disclosure. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be examples only, and are not meant to limit implementations of the disclosure described and/or claimed herein.
As shown in fig. 11, the device 1100 includes a computing unit 1101, which can perform various appropriate actions and processes in accordance with a computer program stored in a Read-Only Memory (ROM) 1102 or a computer program loaded from a storage unit 1108 into a Random Access Memory (RAM) 1103. In the RAM 1103, various programs and data necessary for the operation of the device 1100 may also be stored. The calculation unit 1101, the ROM 1102, and the RAM 1103 are connected to each other by a bus 1104. An Input/Output (I/O) interface 1105 is also connected to bus 1104.
A number of components in device 1100 connect to I/O interface 1105, including: an input unit 1106 such as a keyboard, a mouse, and the like; an output unit 1107 such as various types of displays, speakers, and the like; a storage unit 1108 such as a magnetic disk, optical disk, or the like; and a communication unit 1109 such as a network card, a modem, a wireless communication transceiver, and the like. The communication unit 1109 allows the device 1100 to exchange information/data with other devices via a computer network such as the internet and/or various telecommunication networks.
The computing unit 1101 can be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of the computing Unit 1101 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various computing units running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable Processor, controller, microcontroller, and the like. The calculation unit 1101 performs the respective methods and processes described above, such as a data processing method. For example, in some embodiments, the data processing method may be implemented as a computer software program tangibly embodied on a machine-readable medium, such as storage unit 1108. In some embodiments, part or all of the computer program may be loaded and/or installed onto device 1100 via ROM 1102 and/or communication unit 1109. When a computer program is loaded into the RAM 1103 and executed by the computing unit 1101, one or more steps of the data processing method described above may be performed. Alternatively, in other embodiments, the computing unit 1101 may be configured to perform the data processing method by any other suitable means (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be realized in digital electronic circuitry, integrated circuitry, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application-Specific Standard Products (ASSPs), system-on-Chip (SOC), load Programmable Logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.
Program code for implementing the methods of the present disclosure may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the program codes, when executed by the processor or controller, cause the functions/operations specified in the flowchart and/or block diagram to be performed. The program code may execute entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard Disk, a random access Memory, a Read-Only Memory, an Erasable Programmable Read-Only Memory (EPROM), a flash Memory, an optical fiber, a Compact disc Read-Only Memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a Display device (e.g., a Cathode Ray Tube (CRT) or Liquid Crystal Display (LCD) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), and the internet.
The computer system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client and server relationship to each other. The server may be a cloud server, a server of a distributed system, or a server with a combined blockchain.
It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present disclosure may be executed in parallel or sequentially or in different orders, and are not limited herein as long as the desired results of the technical solutions disclosed in the present disclosure can be achieved.
The above detailed description should not be construed as limiting the scope of the disclosure. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present disclosure should be included in the scope of protection of the present disclosure.
Claims (23)
1. A method of data processing, comprising:
acquiring target data from each data source, wherein the target data comprises at least one type of data;
respectively carrying out format conversion on different types of data in the target data to obtain a first data stream of the target data, wherein the format of the first data stream is a preset target format;
privacy calculation processing is carried out on each first data stream respectively to obtain a second data stream of each target data;
generating data to be stored of each target data based on each second data stream;
determining output format converters matched with different types of data in the target data respectively;
passing the second data streams corresponding to the target data through the output format converters to obtain updated second data streams;
generating data to be stored of each target data based on each second data stream includes:
and generating the data to be stored of each target data, which meet the target storage format, based on each updated second data stream.
2. The method of claim 1, wherein the obtaining target data from each data source comprises:
determining each analyzer respectively adaptive to each data source;
and obtaining the target data from each data source in a streaming mode through each resolver.
3. The method according to claim 1, wherein the preset target format is a virtual table format, and the performing format conversion on different types of data in each target data to obtain a first data stream of each target data includes:
determining input format converters matched with different types of data in the target data respectively;
and respectively carrying out format conversion on different types of data in the target data through the input format converters to obtain a first data stream of the target data, wherein the first data stream is represented by a virtual table format.
4. The method according to claim 1, wherein the performing privacy computation processing on each of the first data streams to obtain a second data stream of each of the target data comprises:
performing privacy calculation processing on each first data stream respectively to obtain data which is subjected to privacy calculation processing and corresponds to each first data stream;
and obtaining the second data stream of each target data based on the data which is subjected to the privacy computation processing and corresponds to each first data stream, wherein the format of the second data stream is the preset target format.
5. The method of claim 1, further comprising:
and storing the data to be stored of each target data according to a preset storage mode.
6. The method according to claim 5, wherein the storing the data to be stored of each target data according to a preset storage mode respectively comprises:
respectively writing the data to be stored of each target data into the data slice of the memory corresponding to each data source;
and uploading the data to be stored in the data slices reaching the preset threshold value to a storage server under the condition that the data size of the data slices corresponding to each data source reaches the preset threshold value.
7. The method according to claim 6, wherein the data to be stored of each target data is stored according to a preset storage mode, and further comprising:
and uploading the data to be stored in the data slice of the memory corresponding to each data source to the storage server under the condition that the reading of the target data corresponding to each data source is finished.
8. The method according to claim 6 or 7, wherein the storing the data to be stored of each target data according to a preset storage mode further comprises:
and merging the data of all the data slices corresponding to the data sources through the storage server to obtain target storage data of the data sources.
9. The method of claim 8, further comprising:
determining a target database of each data source;
and storing the target storage data of each data source to the target database of each data source.
10. The method of claim 1, further comprising:
generating a fault event and reporting the fault event layer by layer under the condition that an abnormality occurs in the data processing process;
and determining the fault occurrence reason according to the fault event.
11. A data processing apparatus comprising:
the acquisition module is used for acquiring target data from each data source, wherein the target data comprises at least one type of data;
the first format conversion module is used for respectively carrying out format conversion on different types of data in the target data to obtain a first data stream of the target data, wherein the format of the first data stream is a preset target format;
the privacy calculation module is used for respectively carrying out privacy calculation processing on each first data stream to obtain a second data stream of each target data;
a generating module, configured to generate data to be stored of each target data based on each second data stream;
a second format conversion module to:
determining output format converters matched with different types of data in the target data respectively;
passing the second data streams corresponding to the target data through the output format converters to obtain updated second data streams;
the generating module is further configured to generate the to-be-stored data, which satisfies the target storage format, of each target data based on each updated second data stream.
12. The apparatus of claim 11, wherein the means for obtaining is configured to:
determining each analyzer respectively adaptive to each data source;
and streaming the target data from each data source through each parser.
13. The apparatus of claim 11, wherein the preset target format is a virtual table format, and the first format conversion module is configured to:
determining input format converters matched with different types of data in the target data respectively;
and performing format conversion on different types of data in the target data respectively through the input format converters to obtain a first data stream of the target data, wherein the first data stream is represented by a virtual table format.
14. The apparatus of claim 11, wherein the privacy computation module is to:
performing privacy calculation processing on each first data stream respectively to obtain data which is subjected to privacy calculation processing and corresponds to each first data stream;
and obtaining the second data stream of each target data based on the data which is subjected to the privacy computation processing and corresponds to each first data stream, wherein the format of the second data stream is the preset target format.
15. The apparatus of claim 11, further comprising:
and the storage module is used for storing the data to be stored of each target data according to a preset storage mode.
16. The apparatus of claim 15, the storage module comprising:
the writing submodule is used for respectively writing the data to be stored of each target data into the data sheet of the memory corresponding to each data source;
and the uploading sub-module is used for uploading the data to be stored in the data pieces reaching the preset threshold to a storage server under the condition that the size of the data in the data pieces corresponding to the data sources reaches the preset threshold.
17. The apparatus of claim 16, wherein the upload sub-module is further configured to:
and uploading the data to be stored in the data slice of the memory corresponding to each data source to the storage server under the condition that the reading of the target data corresponding to each data source is finished.
18. The apparatus of claim 16 or 17, wherein the storage module further comprises:
and the merging submodule is used for merging the data of all the data slices corresponding to the data sources through the storage server to obtain target storage data of the data sources.
19. The apparatus of claim 18, the storage module further comprising:
the determining submodule is used for determining a target database of each data source;
and the storage submodule is used for storing the target storage data of each data source to the target database of each data source.
20. The apparatus of claim 11, further comprising:
an exception handling module to:
generating a fault event and reporting the fault event layer by layer under the condition that an abnormality occurs in the data processing process;
and determining the fault occurrence reason according to the fault event.
21. An electronic device, comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-10.
22. A non-transitory computer readable storage medium having stored thereon computer instructions for causing the computer to perform the method of any one of claims 1-10.
23. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1-10.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210053524.1A CN114417408B (en) | 2022-01-18 | 2022-01-18 | Data processing method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210053524.1A CN114417408B (en) | 2022-01-18 | 2022-01-18 | Data processing method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114417408A CN114417408A (en) | 2022-04-29 |
| CN114417408B true CN114417408B (en) | 2022-11-11 |
Family
ID=81274090
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210053524.1A Active CN114417408B (en) | 2022-01-18 | 2022-01-18 | Data processing method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114417408B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20230214360A1 (en) * | 2022-01-05 | 2023-07-06 | Jpmorgan Chase Bank, N.A. | Method and system for facilitating distributed entity resolution |
| CN115438107A (en) * | 2022-08-10 | 2022-12-06 | 珠海金智维信息科技有限公司 | Data processing method, system, device and storage medium |
| CN115658838B (en) * | 2022-11-18 | 2023-04-07 | 山东省地图院 | Map set data generation method and device, electronic equipment and storage medium |
| CN116010337B (en) * | 2022-12-05 | 2023-07-21 | 广州海量数据库技术有限公司 | Method for accessing ORC data by openGauss |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109542889A (en) * | 2018-10-11 | 2019-03-29 | 平安科技（深圳）有限公司 | Stream data column storage method, device, equipment and storage medium |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8112333B2 (en) * | 2007-10-17 | 2012-02-07 | Hartford Fire Insurance Company | System and method for processing payroll related insurance premiums |
| US20130268527A1 (en) * | 2012-04-10 | 2013-10-10 | Baker Hughes Incorporated | Processing acquisition data into deliverable format |
| CN110351315A (en) * | 2018-04-03 | 2019-10-18 | 中兴通讯股份有限公司 | Method, system and storage medium, the electronic device of data processing |
| CN109413066A (en) * | 2018-10-26 | 2019-03-01 | 雪普达分析仪器(天津)有限公司 | Communication protocol converter of analytical instrument |
| CN112925838A (en) * | 2019-12-06 | 2021-06-08 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN111737329A (en) * | 2020-06-13 | 2020-10-02 | 北京京投亿雅捷交通科技有限公司 | Unified data acquisition platform for rail transit |
| CN112100265A (en) * | 2020-09-17 | 2020-12-18 | 博雅正链(北京)科技有限公司 | Multi-source data processing method and device for big data architecture and block chain |
| CN113778947A (en) * | 2021-09-26 | 2021-12-10 | 杭州安恒信息技术股份有限公司 | Data import method, device and equipment of kafka stream processing platform |
-
2022
- 2022-01-18 CN CN202210053524.1A patent/CN114417408B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109542889A (en) * | 2018-10-11 | 2019-03-29 | 平安科技（深圳）有限公司 | Stream data column storage method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114417408A (en) | 2022-04-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114417408B (en) | Data processing method, device, equipment and storage medium | |
| CN110807067B (en) | Data synchronization method, device and equipment for relational database and data warehouse | |
| US9460188B2 (en) | Data warehouse compatibility | |
| CN110362544B (en) | Log processing system, log processing method, terminal and storage medium | |
| CN112948486B (en) | Batch data synchronization method and system and electronic equipment | |
| CN103838867A (en) | Log processing method and device | |
| CN111241182A (en) | Data processing method and apparatus, storage medium, and electronic apparatus | |
| CN106354817B (en) | Log processing method and device | |
| CN109522341A (en) | Realize method, apparatus, the equipment of the stream data processing engine based on SQL | |
| CN110737594A (en) | Database standard conformance testing method and device for automatically generating test cases | |
| CN113282611A (en) | Method and device for synchronizing stream data, computer equipment and storage medium | |
| CN113010542A (en) | Service data processing method and device, computer equipment and storage medium | |
| CN109471893B (en) | Network data query method, equipment and computer readable storage medium | |
| CN112434087B (en) | Cross-system data comparison method, device, electronic equipment and storage medium | |
| CN113962597A (en) | Data analysis method and device, electronic equipment and storage medium | |
| CN115495440A (en) | Data migration method, device and equipment of heterogeneous database and storage medium | |
| CN112817930A (en) | Data migration method and device | |
| CN113722296A (en) | Agricultural information processing method and device, electronic equipment and storage medium | |
| US20200110815A1 (en) | Multi contextual clustering | |
| CN114816578A (en) | Method, device and equipment for generating program configuration file based on configuration table | |
| EP4216076B1 (en) | Method and apparatus of processing an observation information, electronic device and storage medium | |
| CN110688355A (en) | Method and device for changing container state | |
| CN108984221B (en) | Method and device for acquiring multi-platform user behavior logs | |
| CN113886482B (en) | Automatic data storage method, device and equipment for graph database | |
| KR20200103133A (en) | Method and apparatus for performing extract-transfrom-load procedures in a hadoop-based big data processing system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |