CN111506642A - Data conversion method based on basic data type - Google Patents
Data conversion method based on basic data type Download PDFInfo
- Publication number
- CN111506642A CN111506642A CN202010536875.9A CN202010536875A CN111506642A CN 111506642 A CN111506642 A CN 111506642A CN 202010536875 A CN202010536875 A CN 202010536875A CN 111506642 A CN111506642 A CN 111506642A
- Authority
- CN
- China
- Prior art keywords
- data
- conversion
- convert
- data type
- plug
- 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.)
- Pending
Links
- 238000006243 chemical reaction Methods 0.000 title claims abstract description 25
- 238000000034 method Methods 0.000 title claims abstract description 17
- 238000005516 engineering process Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000008054 signal transmission Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data conversion method based on basic data types, which comprises the following steps: A. selecting the converted data type and the target data type by a user; B. the user fills in data link information; C. the system receives the link information; D. selecting a corresponding data type plug-in for data conversion; E. the method can convert the data into the target data type without damage, can convert the database by inputting simple database link information, can convert non-relational data into relational data, can convert the data structure invisibly by an algorithm written by a python language, can convert the data without modifying the configuration according to the data structure, and can support the mutual conversion among various data types such as common texts, data tables, relational databases, non-relational databases and the like and the distributed deployment.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a data conversion method based on basic data types.
Background
Data conversion is one of the most common technologies in the field of information technology, and most of signal transmission needs signal conversion to meet the requirements.
The existing data conversion operation program is complex in operation and strong in professional, and non-professional personnel cannot perform simple operation. The non-relational data conversion of the relational data needs to carry out related configuration modification according to a data structure, the operation is complex, the supported data types are few, and the hardware limitation is more.
Disclosure of Invention
The present invention is directed to a method for converting data based on basic data types, so as to solve the problems mentioned in the background art.
In order to achieve the purpose, the invention provides the following technical scheme:
a data conversion method based on basic data types comprises the following steps:
A. selecting the converted data type and the target data type by a user;
B. the user fills in data link information;
C. the system receives the link information;
D. selecting a corresponding data type plug-in for data conversion;
E. and converting the data into the target data type without loss.
As a further technical scheme of the invention: further comprising step F: and after the conversion is finished, the user downloads data.
As a further technical scheme of the invention: further comprising step F: and after the conversion is finished, the user directly transfers the data into the target database.
As a further technical scheme of the invention: the plug-in unit comprises four access inlets.
As a further technical scheme of the invention: the four access entries are respectively: the method comprises the steps of plug-in database creation, data structure acquisition, data writing and data reading.
The system is a data conversion system which is formed by extensible plug-ins of mysql, sqlserver, pgsql, oracle, PostgreSQL L, mongodb, excel, json and csv and can be freely added with different data types.
As a further technical scheme of the invention: the system may optionally be deployed distributively in a distributed environment.
Compared with the prior art, the invention has the beneficial effects that: the invention can convert the database only by inputting simple database link information, convert non-relational data into relational data, convert the data structure by an algorithm written by python language, convert the data structure without modifying configuration according to the data structure, support the mutual conversion among various data types such as common texts, data tables, relational databases, non-relational databases and the like, and support the distributed deployment.
Drawings
FIG. 1 is a flow chart of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, embodiment 1: a data conversion method based on basic data types comprises the following steps:
A. selecting the converted data type and the target data type by a user;
B. the user fills in data link information;
C. the system receives link information, wherein the system is a data conversion system which is formed by extensible plug-ins of mysql, sqlserver, pgsql, oracle, PostgreSQL L, mongodb, excel, json and csv and can be freely added with different data types;
D. selecting a corresponding data type plug-in for data conversion; the plug-in includes four access entries: creating a database, acquiring a data structure, writing data and reading data;
E. and converting the data into the target data type without loss.
F. After the conversion is finished, the user can select data to download or directly transfer to the target database.
The system can be selectively deployed in a distributed environment in a distributed mode, is deployed in a lightweight mode, is high in plug-in component forming freedom degree, simple to operate, high in distributed deployment efficiency and strong in stability.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof. The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned.
Furthermore, it should be understood that although the present description refers to embodiments, not every embodiment may contain only a single embodiment, and such description is for clarity only, and those skilled in the art should integrate the description, and the embodiments may be combined as appropriate to form other embodiments understood by those skilled in the art.
Claims (7)
1. A method for data conversion based on basic data types, comprising the steps of:
A. selecting the converted data type and the target data type by a user;
B. the user fills in data link information;
C. the system receives the link information;
D. selecting a corresponding data type plug-in for data conversion;
E. and converting the data into the target data type without loss.
2. The method of claim 1, further comprising the step of: and after the conversion is finished, the user downloads data.
3. The method of claim 1, further comprising the step of: and after the conversion is finished, the user directly transfers the data into the target database.
4. The method of claim 1, wherein the plug-in includes four access entries.
5. The method of claim 4, wherein the four access entries are respectively: the method comprises the steps of plug-in database creation, data structure acquisition, data writing and data reading.
6. The method as claimed in claim 1, wherein the system is a data conversion system capable of freely adding different data types, and the system is composed of mysql, sqlserver, pgsql, oracle, PostgreSQ L, mongodb, excel, json, and csv extensible plug-ins.
7. The method of claim 6, wherein the system is selectively deployed in a distributed environment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010536875.9A CN111506642A (en) | 2020-06-12 | 2020-06-12 | Data conversion method based on basic data type |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010536875.9A CN111506642A (en) | 2020-06-12 | 2020-06-12 | Data conversion method based on basic data type |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111506642A true CN111506642A (en) | 2020-08-07 |
Family
ID=71868772
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010536875.9A Pending CN111506642A (en) | 2020-06-12 | 2020-06-12 | Data conversion method based on basic data type |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111506642A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120313953A1 (en) * | 2011-06-07 | 2012-12-13 | The Mathworks, Inc. | Graphical data conversion/translation |
| US8417715B1 (en) * | 2007-12-19 | 2013-04-09 | Tilmann Bruckhaus | Platform independent plug-in methods and systems for data mining and analytics |
| WO2014088396A2 (en) * | 2012-12-05 | 2014-06-12 | Mimos Berhad | Automatic transformation of non-relational database into relational database |
| CN106383764A (en) * | 2016-08-31 | 2017-02-08 | 北京百分点信息科技有限公司 | Data acquisition method and device |
| CN106528898A (en) * | 2017-01-04 | 2017-03-22 | 泰康保险集团股份有限公司 | Method and device for converting data of non-relational database into relational database |
| CN106649788A (en) * | 2016-12-28 | 2017-05-10 | 深圳启润德管理咨询有限公司 | Database data transmission method and device |
| WO2019011603A1 (en) * | 2017-07-11 | 2019-01-17 | Endress+Hauser Process Solutions Ag | Method and data conversion unit for monitoring an automation system |
-
2020
- 2020-06-12 CN CN202010536875.9A patent/CN111506642A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8417715B1 (en) * | 2007-12-19 | 2013-04-09 | Tilmann Bruckhaus | Platform independent plug-in methods and systems for data mining and analytics |
| US20120313953A1 (en) * | 2011-06-07 | 2012-12-13 | The Mathworks, Inc. | Graphical data conversion/translation |
| WO2014088396A2 (en) * | 2012-12-05 | 2014-06-12 | Mimos Berhad | Automatic transformation of non-relational database into relational database |
| CN106383764A (en) * | 2016-08-31 | 2017-02-08 | 北京百分点信息科技有限公司 | Data acquisition method and device |
| CN106649788A (en) * | 2016-12-28 | 2017-05-10 | 深圳启润德管理咨询有限公司 | Database data transmission method and device |
| CN106528898A (en) * | 2017-01-04 | 2017-03-22 | 泰康保险集团股份有限公司 | Method and device for converting data of non-relational database into relational database |
| WO2019011603A1 (en) * | 2017-07-11 | 2019-01-17 | Endress+Hauser Process Solutions Ag | Method and data conversion unit for monitoring an automation system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| RU2370808C2 (en) | System and method for data display with enclosed tables without circuit diagram | |
| CN101620636B (en) | Method and apparatus for displaying tabular data | |
| CN104035754A (en) | XML (Extensible Markup Language)-based custom code generation method and generator | |
| CN105389367B (en) | The multilevel distributed storage method of grid graph multi-time Scales based on Mongo databases | |
| CN100550020C (en) | A kind of method and apparatus that is used to solve the Chinese software issue of supporting multilanguage | |
| CN105404665A (en) | JSON format data query management system | |
| CN104123392A (en) | Tool and method for transferring relational database to HBase | |
| CN110709829B (en) | Data processing system and method | |
| CN104021123A (en) | Method and system for data transfer | |
| CN111435347A (en) | Efficient expansion method and system for relational table in database | |
| CN102254012A (en) | Graph data storing method and subgraph enquiring method based on external memory | |
| CN108829884A (en) | data mapping method and device | |
| CN102999600A (en) | Method and system for automatically generating embedded database | |
| CN103002061A (en) | Method and device for mutual conversion of long domain names and short domain names | |
| CN104951565B (en) | XM (extensible messaging client) L (extensible markup language) configuration maintenance method and system based on memory database | |
| CN103699555A (en) | Multisource data real-time database data generation method applicable to scheduling and transformer substation integrated system | |
| CN110519408A (en) | A kind of IP attribution inquiry method, device, electronic equipment and storage medium | |
| US20140279970A1 (en) | Compactly storing geodetic points | |
| CN114862449A (en) | Method and device for calculating unique natural person identifier, electronic equipment and storage medium | |
| CN111506642A (en) | Data conversion method based on basic data type | |
| CN101917282B (en) | Method, device and system for processing alarm shielding rules | |
| CN109271448A (en) | It is the data synchronous system and method for platform based on database | |
| CN116431637A (en) | Internet of things platform object model conversion method and device and computer equipment | |
| CN103092869A (en) | Mapping transformation method of Enable extensive makeup language (XML) Database | |
| CN104346334A (en) | Remote visual interface database 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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200807 |