CN104504029B - Data convert information processing method and device - Google Patents

Data convert information processing method and device Download PDF

Info

Publication number
CN104504029B
CN104504029B CN201410770715.5A CN201410770715A CN104504029B CN 104504029 B CN104504029 B CN 104504029B CN 201410770715 A CN201410770715 A CN 201410770715A CN 104504029 B CN104504029 B CN 104504029B
Authority
CN
China
Prior art keywords
data
conversion
transformed
miss
successful
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
Application number
CN201410770715.5A
Other languages
Chinese (zh)
Other versions
CN104504029A (en
Inventor
赵立贺
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Gridsum Technology Co Ltd
Original Assignee
Beijing Gridsum Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Gridsum Technology Co Ltd filed Critical Beijing Gridsum Technology Co Ltd
Priority to CN201410770715.5A priority Critical patent/CN104504029B/en
Publication of CN104504029A publication Critical patent/CN104504029A/en
Application granted granted Critical
Publication of CN104504029B publication Critical patent/CN104504029B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/254Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

Abstract

The invention discloses a kind of data conversion information processing method and device, data conversion information processing method includes:Obtain data to be transformed;It treats conversion data and performs conversion processing, obtain conversion results;Conversion successful data and the data relay miss data to be transformed in data to be transformed are obtained according to conversion results, wherein, conversion successful data refers to data of the successful conversion for target data in data to be transformed, and conversion miss data refers to be converted into the data of target data not successfully in data to be transformed;And the conversion successful data in data to be transformed is stored to first object storage location, and the conversion miss data in data to be transformed is stored to the second target storage position.By the present invention, it is successfully low with the information efficiency of failure to solve the problems, such as that searching data converts, has further achieved the effect that improving searching data converts the efficiency of information successfully and to fail.

Description

Data convert information processing method and device
Technical field
The present invention relates to data processing fields, and information processing method and device are converted in particular to a kind of data.
Background technology
Microsoft SQL Server integrate service (Microsoft SQL Server Integration Services, abbreviation For SSIS), it is the platform for generating high-performance data integrated solution, for example, the extraction of data warehouse, conversion and loading etc.. SSIS carries journal function, and included journal function includes recording exceptional, warning, event action, cancellation, the important letter such as unsuccessfully Breath, but data can not be recorded and convert the successfully detailed data information with data conversion failure, data, which convert, to be referred to from source data The processing procedure that target data includes is converted into, which includes type conversion, Data Integration and refinement etc..
The method of the abnormal root of present analysis data conversion is converted by the SQL statement correction data of SSIS log recordings Source database and data conversion after target database, obtained converting successfully and data by the method that manual analysis is compared The data of failure are converted, so as to analyze the root for causing conversion abnormal.As can be seen that current solution party from foregoing description Automatic record data is not supported to convert the successfully detailed data information with data conversion failure in case.This means that user can only Obtain converting the successfully data with data conversion failure by manual analysis SQL statement, there are efficiency for this manual analysis method Low and easily make a fault, this is unfavorable for the abnormal root of user's searching data conversion.
The problem of successfully low with the information efficiency of data conversion failure is converted for searching data in the relevant technologies, at present still Effective solution is not proposed.
Invention content
It is a primary object of the present invention to provide a kind of data conversion information processing method and device, to solve the relevant technologies Middle searching data converts the problem of successfully low with the information efficiency of data conversion failure.
To achieve these goals, according to an aspect of the invention, there is provided a kind of data convert information processing method.
Data conversion information processing method according to the present invention includes:Obtain data to be transformed;Treat conversion data execution Conversion processing obtains conversion results;Conversion successful data and the data to be transformed in data to be transformed are obtained according to conversion results Middle conversion miss data, wherein, conversion successful data refers to data of the successful conversion for target data in data to be transformed, conversion Miss data refers to be converted into the data of target data not successfully in data to be transformed;And by being converted in data to be transformed Work(data are stored to first object storage location, and the conversion miss data in data to be transformed is stored to the second target and is stored Position.
Further, data to be transformed are obtained to include:Source data is obtained from presetting database;Source data is stored to Three target storage positions;And obtain data to be transformed from third target storage position.
Further, conversion data execution conversion processing is treated to include:Determine default conversion type;According to default conversion class Data to be transformed are converted into target data by type, wherein, the type of target data is default conversion type;Establish target data with The correspondence of data to be transformed;And the correspondence of output target data and data to be transformed.
Further, the conversion successful data in data to be transformed is stored to first object storage location, and will waits to turn Conversion miss data in change data, which is stored to the second target storage position, to be included:Obtain preset data file format;And it presses The conversion successful data in data to be transformed will be stored according to preset data file format to first object storage location, and according to Preset data file format stores the conversion miss data in data to be transformed to the second target storage position.
Further, the conversion successful data in data to be transformed are obtained according to conversion results and data relay to be transformed After changing miss data, this method further includes:Turned according to conversion successful data and conversion miss data parsing conversion miss data Change the type of failure;And the type of output conversion miss data conversion failure.
To achieve these goals, according to another aspect of the present invention, a kind of data conversion information processing unit is provided.
Data conversion information processing unit according to the present invention includes:First acquisition unit, for obtaining data to be transformed; Conversion unit performs conversion processing for treating conversion data, obtains conversion results;Second acquisition unit, for according to conversion As a result the conversion successful data in data to be transformed and data relay miss data to be transformed are obtained, wherein, it converts and successfully counts According to data of the successful conversion for target data in data to be transformed are referred to, conversion miss data refers to failed in data to be transformed It is converted into the data of target data;And storage unit, for storing the conversion successful data in data to be transformed to first Target storage position, and the conversion miss data in data to be transformed is stored to the second target storage position.
Further, first acquisition unit includes:First acquisition module, for obtaining source data from presetting database; First memory module, for storing source data to third target storage position;And second acquisition module, for from third mesh It marks storage location and obtains data to be transformed.
Further, conversion unit includes:Determining module, for determining default conversion type;Conversion module, for basis Data to be transformed are converted into target data by default conversion type, wherein, the type of target data is default conversion type;It establishes Module, for establishing the correspondence of target data and data to be transformed;And output module, for exporting target data with treating The correspondence of conversion data.
Further, storage unit includes:Third acquisition module, for obtaining preset data file format;And second Memory module, for will store the conversion successful data in data to be transformed to first object according to preset data file format Storage location, and the conversion miss data in data to be transformed is stored to the second target according to preset data file format and is stored Position.
Further, which further includes:Resolution unit, for according to conversion successful data and conversion miss data parsing Convert the type of miss data conversion failure;And output unit, for exporting the type of conversion miss data conversion failure.
By the present invention, using the conversion successful data and data relay to be transformed stored respectively automatically in data to be transformed Change miss data, solve the problems, such as that searching data converts successfully low with the information efficiency of data conversion failure in the relevant technologies, And then achieve the effect that improving searching data converts the successfully information efficiency with data conversion failure.
Description of the drawings
The attached drawing for forming the part of the application is used to provide further understanding of the present invention, schematic reality of the invention Example and its explanation are applied for explaining the present invention, is not constituted improper limitations of the present invention.In the accompanying drawings:
Fig. 1 is the flow chart of data conversion information processing method according to embodiments of the present invention;And
Fig. 2 is the schematic diagram of data conversion information processing unit according to embodiments of the present invention.
Specific embodiment
It should be noted that in the absence of conflict, the feature in embodiment and embodiment in the application can phase Mutually combination.The present invention will be described in detail below with reference to the accompanying drawings and in conjunction with the embodiments.
In order to which those skilled in the art is made to more fully understand application scheme, below in conjunction in the embodiment of the present application The technical solution in the embodiment of the present application is clearly and completely described in attached drawing, it is clear that described embodiment is only The embodiment of the application part, instead of all the embodiments.Based on the embodiment in the application, ordinary skill people Member's all other embodiments obtained without making creative work should all belong to the model of the application protection It encloses.
It should be noted that term " first " in the description and claims of this application and above-mentioned attached drawing, " Two " etc. be the object for distinguishing similar, and specific sequence or precedence are described without being used for.It should be appreciated that it uses in this way Data can be interchanged in the appropriate case, so as to embodiments herein described herein.In addition, term " comprising " and " tool Have " and their any deformation, it is intended that cover it is non-exclusive include, for example, containing series of steps or unit Process, method, system, product or equipment are not necessarily limited to those steps or unit clearly listed, but may include without clear It is listing to Chu or for the intrinsic other steps of these processes, method, product or equipment or unit.
According to embodiments of the present invention, a kind of data conversion information processing method is provided.Fig. 1 is according to embodiments of the present invention Data conversion information processing method flow chart.
As shown in Figure 1, data conversion information processing method includes steps S102 to step S108:
Step S102:Obtain data to be transformed.
Data conversion refers to initial data being converted into target data according to preset rules, for example, data type conversion, number According to integration, data mining etc., the embodiment of the present invention is illustrated for being based on SSIS platforms and carrying out data conversion.Number to be transformed Can be the data that are obtained from database or from other electronic watches according to the data for referring to need to perform conversion processing The data obtained in lattice, for example, the data obtained from Excel tables.Preferably, data to be transformed are obtained to include:From default Source data is obtained in database;Source data is stored to third target storage position;And it is obtained from third target storage position Data to be transformed.
Presetting database is data source data library, specifically, can be filtered out by SQL statement from presetting database Need the data converted, i.e. source data.In order to detect in data conversion process with the presence or absence of loss of data, can will obtain The source data that arrives carries out a dump, for example, be stored in third target storage position, so as to, can be with after data conversion is completed It is that data conversion process whether there is loss of data data after conversion and the source data to be compared to judge, for example, number It is 100 according to source data amount before conversion, it is 85 that successfully data volume is converted after data conversion, and conversion miss data amount is 10, then can obtain It is 5 to lose data volume to conversion.Cause the above results inaccurate in order to avoid occurring loss of data in dump procedure, the present invention is real It applies example and obtains data to be transformed from third target storage position.
Step S104:It treats conversion data and performs conversion processing, obtain conversion results.
SSIS platforms can easily realize that data convert, and the embodiment of the present invention is with using the progress data conversion of SSIS platforms For illustrate.Specifically, conversion data execution conversion processing is treated to include:Determine default conversion type;Turned according to default Change type and data to be transformed are converted into target data, wherein, the type of target data is default conversion type;Establish number of targets According to the correspondence with data to be transformed;And the correspondence of output target data and data to be transformed.
Data conversion includes multiple types, for example, type conversion, Data Integration etc., it can be arbitrary to preset conversion type A kind of data convert type.When carrying out data conversion using SSIS platforms, user can pre-set data conversion type, When data convert task start, SSIS platforms can perform corresponding data conversion operation automatically according to default conversion type, obtain Target data further analyzes data conversion results for the ease of user, establishes target data pass corresponding with data to be transformed System.Specifically, it is the data of successful conversion in data to be transformed are corresponding with the target data that it is converted and export or into one Step is stored in target database.
Step S106:Conversion successful data and the data relay to be transformed in data to be transformed are obtained according to conversion results Miss data, wherein, conversion successful data refers to data of the successful conversion for target data in data to be transformed, and conversion unsuccessfully counts According to the data for referring to be converted into target data not successfully in data to be transformed.
After treating conversion data execution conversion processing, the conversion successful data in data to be transformed and data to be transformed are obtained Middle conversion miss data, for example, can be data relay successful data to be transformed and number to be transformed in data conversion process According to middle conversion miss data plus different marks, distinguish the conversion successful data in data to be transformed according to mark and wait to turn Change data relay miss data, it can also be in the conversion process by the conversion successful data in data to be transformed from number to be transformed The memory headroom of other positions is stored according to middle taking-up, so as to be distinguished according to the position of content space in data to be transformed Conversion successful data and data relay miss data to be transformed.
Step S108:Conversion successful data in data to be transformed is stored to first object storage location, and will wait to turn The conversion miss data changed in data is stored to the second target storage position.
First object storage location and the second target storage position can be the different storage locations of any two.This hair Bright embodiment is by obtaining the conversion in the conversion successful data and data to be transformed in data conversion process in data to be transformed Miss data, and the conversion miss data in the conversion successful data and data to be transformed in data to be transformed is stored respectively in Different storage locations are realized in automatic record data conversion process and are converted to work(data and conversion miss data, so as to side Just quickly obtain and check conversion successful data and conversion miss data, solve searching data convert successfully with data conversion The problem of information efficiency of failure is low.In addition, it can quickly and accurately be analyzed according to conversion successful data and conversion miss data The defects of going out current data conversion, improves working efficiency, reduces error rate.
Preferably, the conversion successful data in data to be transformed is stored to first object storage location, and will be to be transformed Conversion miss data in data, which is stored to the second target storage position, to be included:Obtain preset data file format;And according to Preset data file format will store the conversion successful data in data to be transformed to first object storage location, and according to pre- If document format data stores the conversion miss data in data to be transformed to the second target storage position.
Preset data file format refers to the file format of data storage, for example, it may be TXT file formats, Ke Yishi Excel forms or alternative document form.It, will be in data to be transformed after the file format stored in setting data Conversion successful data and data to be transformed in conversion miss data according to pre-set stored in file format, for example, depositing It stores up as Excel tables.The embodiment of the present invention can flexibly select the file format that data store, and subsequently treat and turn convenient for user Change the use of the conversion successful data in data and the conversion miss data in data to be transformed.
Preferably, the conversion successful data in data to be transformed are obtained according to conversion results and data relay to be transformed After miss data, method further includes:It is lost according to conversion successful data and conversion miss data parsing conversion miss data conversion The type lost;And the type of output conversion miss data conversion failure.
Data conversion may be unsuccessfully caused by due to character length, character types, character sequence etc..Specifically, Multiple rules can be pre-set to be detected the type of data conversion failure.For example, character length, character type are detected successively Type, character sequence.It is illustrated by taking character length as an example, detection first is totally converted successfully the character length of data, obtains most Big character length and minimum character length, then conversion miss data is traversed, the character of each conversion miss data is judged respectively Whether between maximum character length and minimum character length, specifically, a threshold value can be set, if turned by calculating Character length is not at the data volume between maximum character length and minimum character length and character length in change miss data The ratio of data volume between maximum character length and minimum character length, the number is determined if the ratio is more than preset value It is inconsistent for character length according to the type of conversion failure, otherwise continue the type detection of other conversion failures, for example, detection detection Character types if detecting that be totally converted successfully data is the character string that letter is formed, and detect conversion and unsuccessfully count According to being not by the alphabetical character string formed, determine that the type that data conversion fails is inconsistent for character types at this time.Respectively After the type for detecting preset multiple conversion failures, testing result is exported, for example, it is that character length mismatch causes to count to detect During according to conversion failure, it can be mismatched with output character length, user can be further according to the testing result rapidly locating The root of failure is converted, improves the efficiency of searching data conversion failure cause.
It can be seen from the above description that the present invention realizes following technique effect:
The embodiment of the present invention treats conversion data and performs conversion processing, obtain conversion results by obtaining data to be transformed, Conversion successful data in data to be transformed and data relay miss data to be transformed are obtained according to conversion results and will be treated Conversion successful data in conversion data is stored to first object storage location, and by the conversion miss data in data to be transformed It stores to the second target storage position.The embodiment of the present invention will be in the conversion successful data and data to be transformed in data to be transformed Conversion miss data be stored respectively in different storage locations, realize be converted in automatic record data conversion process work(data and Miss data is converted, so as to obtain and check conversion successful data and conversion miss data easily and fast, solves and looks into Data is looked for convert the problem of successfully low with the information efficiency of data conversion failure.In addition, the embodiment of the present invention can further root Data conversion failure is automatically analyzed according to the conversion miss data in the conversion successful data and data to be transformed in data to be transformed The reason of, improve the efficiency that searching data converts failure cause.
It should be noted that step shown in the flowchart of the accompanying drawings can be in such as a group of computer-executable instructions It is performed in computer system, although also, show logical order in flow charts, it in some cases, can be with not The sequence being same as herein performs shown or described step.
Another aspect according to embodiments of the present invention provides a kind of data conversion information processing unit, data conversion Information processing unit can be used for performing the data conversion information processing method of the embodiment of the present invention, the method for the embodiment of the present invention Data that can also be through the embodiment of the present invention convert information processing unit to perform.
Fig. 2 is the schematic diagram of data conversion information processing unit according to embodiments of the present invention, as shown in Fig. 2, the data Conversion information processing unit includes:First acquisition unit 10, conversion unit 20, second acquisition unit 30 and storage unit 40.
First acquisition unit 10, for obtaining data to be transformed.
Data conversion refers to initial data being converted into target data according to preset rules, for example, data type conversion, number According to integration, data mining etc..Data to be transformed refer to the data for needing to perform conversion processing, can be obtained from database Data or the data obtained from other electrical forms, for example, the data obtained from Excel tables.
Preferably, first acquisition unit 10 includes:First acquisition module, for obtaining source data from presetting database; First memory module, for storing source data to third target storage position;And second acquisition module, for from third mesh It marks storage location and obtains data to be transformed.
Conversion unit 20 performs conversion processing for treating conversion data, obtains conversion results.
Optionally, conversion unit 20 includes:Determining module, for determining default conversion type;Conversion module, for basis Data to be transformed are converted into target data by default conversion type, wherein, the type of target data is default conversion type;It establishes Module, for establishing the correspondence of target data and data to be transformed;And output module, for exporting target data with treating The correspondence of conversion data.
Second acquisition unit 30, for obtaining conversion successful data in data to be transformed and to be transformed according to conversion results Data relay miss data, wherein, conversion successful data refers to data of the successful conversion for target data in data to be transformed, Conversion miss data refers to be converted into the data of target data not successfully in data to be transformed.
After treating conversion data execution conversion processing, the conversion successful data in data to be transformed and data to be transformed are obtained Middle conversion miss data, for example, can be data relay successful data to be transformed and number to be transformed in data conversion process According to middle conversion miss data plus different marks, distinguish the conversion successful data in data to be transformed according to mark and wait to turn Change data relay miss data, it can also be in the conversion process by the conversion successful data in data to be transformed from number to be transformed The memory headroom of other positions is stored according to middle taking-up, so as to be distinguished according to the position of content space in data to be transformed Conversion successful data and data relay miss data to be transformed.
Storage unit 40, for storing the conversion successful data in data to be transformed to first object storage location, and Conversion miss data in data to be transformed is stored to the second target storage position.
First object storage location and the second target storage position are the different storage locations of any two.Locating respectively After storing conversion successful data and the data relay miss data to be transformed in data to be transformed, user can combine and treat The number recorded in conversion successful data and data relay miss data to be transformed and data conversion daily record in conversion data According to the information that conversion is abnormal and fails, for example, SSIS platforms carry out the log information recorded during data conversion, number is quickly analyzed The reason of according to conversion failure.
Preferably, storage unit 40 includes:Third acquisition module, for obtaining preset data file format;And second Memory module, for will store the conversion successful data in data to be transformed to first object according to preset data file format Storage location, and the conversion miss data in data to be transformed is stored to the second target according to preset data file format and is stored Position.
Preferably, which further includes:Resolution unit, for being turned according to conversion successful data and conversion miss data parsing Change the type of miss data conversion failure;And output unit, for exporting the type of conversion miss data conversion failure.
Data conversion may be unsuccessfully caused by due to character length, character types, character sequence etc..Specifically, Multiple rules can be pre-set to be detected the type of data conversion failure.For example, character length, character type are detected successively Type, character sequence.
The embodiment of the present invention obtains data to be transformed by first acquisition unit 10, and converting unit 20 is treated conversion data and held Row conversion processing, obtains conversion results, and second acquisition unit 30 obtains the conversion success in data to be transformed according to conversion results Data and data relay miss data to be transformed and storage unit 40 store the conversion successful data in data to be transformed It is stored to first object storage location, and by the conversion miss data in data to be transformed to the second target storage position.Pass through Conversion miss data in conversion successful data and data to be transformed in data to be transformed is stored respectively in different storage positions It puts, realizes in automatic record data conversion process and be converted to work(data and conversion miss data, so as to obtain easily and fast It takes and checks conversion successful data and convert miss data, solve searching data and convert the successfully information with data conversion failure The problem of efficiency is low.
Obviously, those skilled in the art should be understood that each module of the above-mentioned present invention or each step can be with general Computing device realize that they can concentrate on single computing device or be distributed in multiple computing devices and be formed Network on, optionally, they can be realized with the program code that computing device can perform, it is thus possible to which they are stored In the storage device by computing device come perform either they are fabricated to respectively each integrated circuit modules or by they In multiple modules or step be fabricated to single integrated circuit module to realize.In this way, the present invention is not limited to any specific Hardware and software combines.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, for the skill of this field For art personnel, the invention may be variously modified and varied.All within the spirits and principles of the present invention, that is made any repaiies Change, equivalent replacement, improvement etc., should all be included in the protection scope of the present invention.

Claims (8)

1. a kind of data convert information processing method, which is characterized in that including:
Obtain data to be transformed;
Conversion processing is performed to the data to be transformed, obtains conversion results;
Conversion successful data and the data relay to be transformed in the data to be transformed are obtained according to the conversion results Miss data, wherein, the conversion successful data refers to data of the successful conversion for target data, institute in the data to be transformed State the data that conversion miss data refers to be converted into target data not successfully in the data to be transformed;And
Conversion successful data in the data to be transformed is stored to first object storage location, and by the data to be transformed In conversion miss data store to the second target storage position;
Wherein, it is obtained according to the conversion results in the conversion successful data and the data to be transformed in the data to be transformed Conversion miss data includes:It is being converted in the data to be transformed in the data execution conversion processing process to be transformed Work(data and data relay miss data to be transformed add different marks, and the data to be transformed are distinguished according to the mark In conversion successful data and data relay miss data to be transformed;
Wherein, the conversion successful data in the data to be transformed are obtained according to the conversion results and the data to be transformed After middle conversion miss data, the method further includes:According to the conversion successful data and the conversion miss data parsing The type of the conversion miss data conversion failure;And the type of the output conversion miss data conversion failure.
2. data according to claim 1 convert information processing method, which is characterized in that obtain the data packet to be transformed It includes:
Source data is obtained from presetting database;
The source data is stored to third target storage position;And
The data to be transformed are obtained from the third target storage position.
3. data according to claim 1 convert information processing method, which is characterized in that the data to be transformed are performed Conversion processing includes:
Determine default conversion type;
The data to be transformed are converted by target data according to the default conversion type, wherein, the class of the target data Type is the default conversion type;
Establish the correspondence of the target data and the data to be transformed;And
Export the correspondence of the target data and the data to be transformed.
4. data according to claim 1 convert information processing method, which is characterized in that will be in the data to be transformed Conversion successful data is stored to first object storage location, and the conversion miss data in the data to be transformed is stored to the Two target storage positions include:
Obtain preset data file format;And
The conversion successful data in the data to be transformed will be stored according to the preset data file format to described first Target storage position, and according to the preset data file format by the conversion miss data in the data to be transformed store to Second target storage position.
5. a kind of data convert information processing unit, which is characterized in that including:
First acquisition unit, for obtaining data to be transformed;
Conversion unit for performing conversion processing to the data to be transformed, obtains conversion results;
Second acquisition unit, for obtaining conversion successful data in the data to be transformed and described according to the conversion results Data relay miss data to be transformed, wherein, the conversion successful data refers to that successful conversion is in the data to be transformed The data of target data, the conversion miss data refer to be converted into the number of target data not successfully in the data to be transformed According to;And
Storage unit, for storing the conversion successful data in the data to be transformed to first object storage location, and will Conversion miss data in the data to be transformed is stored to the second target storage position;
Wherein, the second acquisition unit is additionally operable in the data to be transformed perform conversion processing process be described to wait to turn The conversion successful data and data relay miss data to be transformed changed in data add different marks, according to the tag slot Divide the conversion successful data in the data to be transformed and data relay miss data to be transformed;
Wherein, described device further includes:Resolution unit, for according to the conversion successful data and the conversion miss data solution Analyse the type of the conversion miss data conversion failure;And output unit, it is lost for exporting the conversion miss data conversion The type lost.
6. data according to claim 5 convert information processing unit, which is characterized in that the first acquisition unit packet It includes:
First acquisition module, for obtaining source data from presetting database;
First memory module, for storing the source data to third target storage position;And
Second acquisition module, for obtaining the data to be transformed from the third target storage position.
7. data according to claim 5 convert information processing unit, which is characterized in that the conversion unit includes:
Determining module, for determining default conversion type;
Conversion module, for the data to be transformed to be converted into target data according to the default conversion type, wherein, it is described The type of target data is the default conversion type;
Module is established, for establishing the correspondence of the target data and the data to be transformed;And
Output module, for exporting the correspondence of the target data and the data to be transformed.
8. data according to claim 5 convert information processing unit, which is characterized in that the storage unit includes:
Third acquisition module, for obtaining preset data file format;And
Second memory module, for will successfully count the conversion in the data to be transformed according to the preset data file format According to storing to the first object storage location, and according to the preset data file format will be in the data to be transformed turn Change miss data to store to second target storage position.
CN201410770715.5A 2014-12-11 2014-12-11 Data convert information processing method and device Active CN104504029B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410770715.5A CN104504029B (en) 2014-12-11 2014-12-11 Data convert information processing method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410770715.5A CN104504029B (en) 2014-12-11 2014-12-11 Data convert information processing method and device

Publications (2)

Publication Number Publication Date
CN104504029A CN104504029A (en) 2015-04-08
CN104504029B true CN104504029B (en) 2018-06-26

Family

ID=52945427

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410770715.5A Active CN104504029B (en) 2014-12-11 2014-12-11 Data convert information processing method and device

Country Status (1)

Country Link
CN (1) CN104504029B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105975524A (en) * 2016-04-28 2016-09-28 成都理工大学 Data integration method and system used for geology monitoring
CN108241679B (en) * 2016-12-26 2020-07-03 北京国双科技有限公司 Data processing method and device

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102298601A (en) * 2011-05-23 2011-12-28 北京捷成世纪科技股份有限公司 Conversion method of monitoring data of storage device oriented to radio and TV industry and converter
CN103605715A (en) * 2013-11-14 2014-02-26 北京国双科技有限公司 Method and device used for data integration processing of multiple data sources
CN104063482A (en) * 2014-07-03 2014-09-24 浙江大学 Business data integration method oriented to real estate registration

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9087105B2 (en) * 2012-10-04 2015-07-21 Adobe Systems Incorporated Rule-based extraction, transformation, and loading of data between disparate data sources

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102298601A (en) * 2011-05-23 2011-12-28 北京捷成世纪科技股份有限公司 Conversion method of monitoring data of storage device oriented to radio and TV industry and converter
CN103605715A (en) * 2013-11-14 2014-02-26 北京国双科技有限公司 Method and device used for data integration processing of multiple data sources
CN104063482A (en) * 2014-07-03 2014-09-24 浙江大学 Business data integration method oriented to real estate registration

Also Published As

Publication number Publication date
CN104504029A (en) 2015-04-08

Similar Documents

Publication Publication Date Title
CN109388566B (en) Code coverage rate analysis method, device, equipment and storage medium
CN110245035A (en) A kind of link trace method and device
US10261967B2 (en) Data extraction
CN104899016B (en) Allocating stack Relation acquisition method and device
CN112631913B (en) Method, device, equipment and storage medium for monitoring operation faults of application program
CN110764980A (en) Log processing method and device
CN109635564A (en) A kind of method, apparatus, medium and equipment detecting Brute Force behavior
CN110489317B (en) Cloud system task operation fault diagnosis method and system based on workflow
CN109582504A (en) A kind of data reconstruction method and device for apple equipment
CN104504029B (en) Data convert information processing method and device
US10083070B2 (en) Log file reduction according to problem-space network topology
CN110493085A (en) Statistical method, system, electronic equipment and the medium of IPv6 active users
CN109857714A (en) Journal obtaining method, device, electronic equipment and computer readable storage medium
CN110019762B (en) Problem positioning method, storage medium and server
CN112256532A (en) Test interface generation method and device, computer equipment and readable storage medium
CN109559121A (en) Transaction path calls exception analysis method, device, equipment and readable storage medium storing program for executing
CN111970151A (en) Flow fault positioning method and system for virtual and container network
CN115687406B (en) Sampling method, device, equipment and storage medium for call chain data
CN105847079A (en) Data processing method and device
CN114610385B (en) Running environment adaptation system and method
CN110968779A (en) Processing method and device for crawling webpage information
CN103699482A (en) Method and device for testing reasonableness of controls
CN113037521B (en) Method for identifying state of communication equipment, communication system and storage medium
CN109560964B (en) Equipment compliance checking method and device
CN111831515A (en) Application system running state monitoring system and monitoring method thereof

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
PE01 Entry into force of the registration of the contract for pledge of patent right
PE01 Entry into force of the registration of the contract for pledge of patent right

Denomination of invention: Data transformation information processing method and device

Effective date of registration: 20190531

Granted publication date: 20180626

Pledgee: Shenzhen Black Horse World Investment Consulting Co., Ltd.

Pledgor: Beijing Guoshuang Technology Co.,Ltd.

Registration number: 2019990000503

CP02 Change in the address of a patent holder
CP02 Change in the address of a patent holder

Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing

Patentee after: Beijing Guoshuang Technology Co.,Ltd.

Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A

Patentee before: Beijing Guoshuang Technology Co.,Ltd.