CN109582826A - A kind of mobile data services storage exchange method based on general purpose table storage and xml - Google Patents
A kind of mobile data services storage exchange method based on general purpose table storage and xml Download PDFInfo
- Publication number
- CN109582826A CN109582826A CN201811426762.2A CN201811426762A CN109582826A CN 109582826 A CN109582826 A CN 109582826A CN 201811426762 A CN201811426762 A CN 201811426762A CN 109582826 A CN109582826 A CN 109582826A
- Authority
- CN
- China
- Prior art keywords
- data
- xml
- business
- storage
- general purpose
- 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
Abstract
The present invention relates to data storage technical fields, especially a kind of mobile data services based on general purpose table storage and xml store exchange method, the present invention establishes business common store table by abstract, store the definition of business datum, business datum storage and the processing of particular service logic, the upload of business datum is arranged, tables of data xml conversion and compression encryption encapsulation, general upload downloading program and the business filing several steps of processing routine convert the mobile data of general purpose table data and xml, improve the expandability of development efficiency and system, the safety for the data that xml data table transmition and zip encapsulation encryption ensure simultaneously, smoothly realize the offline storage exchange of mobile law enforcement business datum.
Description
Technical field
The present invention relates to data storage technical field more particularly to a kind of mobile datas based on general purpose table storage and xml
Business stores exchange method.
Background technique
China Today socio-economic development tends to slowly, and the update iteration cycle of the science and technology such as mobile interchange, Internet of Things
Shorter and shorter, the resident that wherein application of mobile interchange has even more entered into all trades and professions or even streets and lanes is also full of emerging
It joined mobile interchange application group interestingly, but see that the current each department in China are asked in social field personnel enforcing law there are many
Topic, as law enforcement evidence obtaining is difficult, enforcing law is opaque, executive cost is high, law enfrocement official's quality is irregular and law enforcement is supervised not
Problem in place causes the satisfaction of law-enforcing work of the masses to each law enforcement agency extremely low, or even causes the consequence of very severe, institute
Especially the working efficiency of department, municipal administration is put forward higher requirements with government department, according to the mobility of department, municipal administration, a line portion
Door needs to exchange information to command centre, municipal administration and data center in real time, obtains comprehensive law enforcement information, faces a large amount of data, be
System needs to store these mobile datas, and General System is all to establish general purpose table data, needs online management of networking, data
Safety it is low, and the data file of XML format can be by computer outline management, and Information Security is high, so, the present invention is set
A kind of mobile data services storage exchange method based on general purpose table storage and xml is counted.
Summary of the invention
The purpose of the present invention is to solve the data that general purpose table exists in the prior art, and online management and data to be needed to pacify
The low disadvantage of full property, and a kind of mobile data services based on general purpose table storage and xml proposed store exchange method.
To achieve the goals above, present invention employs following technical solutions:
A kind of mobile data services storage exchange method based on general purpose table storage and xml is designed, is included the following steps,
Step 1: it is abstract to establish business common store table, code is write, takes general data collection and data element mode to construct general
Store table, wherein the general storage table of business includes the common store table for recording specific business information；
Step 2: the definition of business datum is stored, business datum will be stored by corresponding allocation of computer and carry out class definition,
Wherein data type includes binary data, character data, Unicode data, date and time data, numerical data, currency
Data and special data, in addition, the definition data of also included user；
Step 3: neck can be used in special different business logic processing in business datum storage and the processing of particular service logic
The attribute of object and behavior are made description, in addition added by the field logical architecture mode of domain model as the M layer in MVC
One data access layer provides data to particular service logic, and business datum stores in treatment process, by all texts of database
Part is placed into SSD storage pool, and DBA, the thorough liberation from performance optimization comes out the program, by hardware investment reduce manpower and
Management cost, the program are suitable for OLTP and OLAP business；
Step 4: the upload setting of business datum, the upload setting of configuration service data on computers, in the equipment of computer
PORT COM is selected in manager option, then selects the attribute of PORT COM, selects advanced setting, modifies open position in data
Number, bits per second are changed to 1200, and data are to be changed to 8, no parity checking, no flow control, and stop position is changed to 1, finally selects the end COM
Slogan position COM2.
Step 5: jdbc-odbc connection is established in tables of data xml conversion and compression encryption encapsulation, in defined variable, write-in
Xml document path writes code in eclipse, the data of general-purpose service data table is directly substituted into, by the number of xml format
According to file is established, ZIP encryption solution briquetting is then formed by way of decompression；
Step 6: program is downloaded in general upload, is uploaded by the data that the upload program of collocation type is realized；
Step 7: business files processing routine, and business filing procedure is called to realize the seamless connection with former computer end operation system.
Preferably, in step 2, binary data includes Binary, Varbinary and Image, character data
Type includes Char, Varchar and Text, and Unicode data type includes Nchar, Nvarchar and Ntext, day
Phase and time data type include Datetime and Smalldatetime two types, numeric data type include positive number and
Negative, decimal and integer.
Preferably, in step 2, user is when creating user-defined data type, it is necessary to provide three numbers: data class
The controllability of the title of type, the system data type being based on and data type.
Preferably, in step 3, MVC pattern includes model, view and controller, and model is for encapsulation and application program
The relevant data attribute of service logic and processing method or behavior to data, view carry out figure for interface personnel
Shape interface, controller are mainly responsible for forwarding request, handle request.
Preferably, in step 3, the purpose of MVC pattern is to realize a kind of dynamic programming, is made subsequent to program
Modifications and extensions simplify, and make it possible the recycling of program a part, and in addition to this, this mode passes through to complexity
The simplification of degree keeps program structure more intuitive, also gives while software systems are by separating itself basic part each
The due function of essential part.
Preferably, in steps of 5, it when data being carried out xml conversion, needs to parse xml document, uses JDBC connection data
Library, the insert sentence that sql is executed in java import data in data file, and so far xml mode completely converts
For relation schema.
A kind of mobile data services based on general purpose table storage and xml proposed by the present invention store exchange method, beneficial to effect
Fruit is: the present invention uses general purpose table storage mode, fast implements function by collocation type exploitation, improves development efficiency and be
The expandability of system, while the safety of xml data table transmition and the data of zip encapsulation encryption guarantee, smoothly realize movement and hold
The offline storage of method business datum exchanges.
Detailed description of the invention
Fig. 1 is that a kind of mobile data services based on general purpose table storage and xml proposed by the present invention store exchange method
Flow chart；
Fig. 2 it is proposed by the present invention it is a kind of based on general purpose table storage and xml mobile data services storage the general of exchange method deposit
Store up the code pattern of table.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.
Referring to Fig.1, a kind of mobile data services based on general purpose table storage and xml store exchange method, including following step
Suddenly,
Step 1: it is abstract to establish business common store table, code is write, takes general data collection and data element mode to construct general
Store table, wherein the general storage table of business includes the common store table for recording specific business information；
Step 2: the definition of business datum is stored, business datum will be stored by corresponding allocation of computer and carry out class definition,
Wherein data type includes binary data, character data, Unicode data, date and time data, numerical data, currency
Data and special data, in addition, the definition data of also included user；
Step 3: neck can be used in special different business logic processing in business datum storage and the processing of particular service logic
The attribute of object and behavior are made description, in addition added by the field logical architecture mode of domain model as the M layer in MVC
One data access layer provides data to particular service logic, and business datum stores in treatment process, by all texts of database
Part is placed into SSD storage pool, and DBA, the thorough liberation from performance optimization comes out the program, by hardware investment reduce manpower and
Management cost, the program are suitable for OLTP and OLAP business；
Step 4: the upload setting of business datum, the upload setting of configuration service data on computers, in the equipment of computer
PORT COM is selected in manager option, then selects the attribute of PORT COM, selects advanced setting, modifies open position in data
Number, bits per second are changed to 1200, and data are to be changed to 8, no parity checking, no flow control, and stop position is changed to 1, finally selects the end COM
Slogan position COM2.
Step 5: jdbc-odbc connection is established in tables of data xml conversion and compression encryption encapsulation, in defined variable, write-in
Xml document path writes code in eclipse, the data of general-purpose service data table is directly substituted into, by the number of xml format
According to file is established, ZIP encryption solution briquetting is then formed by way of decompression；
Step 6: program is downloaded in general upload, is uploaded by the data that the upload program of collocation type is realized；
Step 7: business files processing routine, and business filing procedure is called to realize the seamless connection with former computer end operation system.
Wherein, in step 2, user is when creating user-defined data type, it is necessary to provide three numbers: data type
Title, the controllability of the system data type being based on and data type, in step 3, MVC pattern includes model, view
And controller, model be used to encapsulate data attribute relevant to the service logic of application program and to the processing methods of data or
Behavior, view carry out Design of Graphical Interface for interface personnel, and controller is mainly responsible for forwarding request, at request
Reason, in step 3, the purpose of MVC pattern is to realize a kind of dynamic programming, makes the subsequent modifications and extensions letter to program
Change, and make it possible the recycling of program a part, in addition to this, this mode is made by the simplification to complexity
Program structure is more intuitive, and also giving each essential part while software systems are by separating itself basic part should have
Function when data are carried out xml conversion, need to parse xml document in steps of 5, using JDBC connection database,
The insert sentence that sql is executed in java imports data in data file, and so far xml mode is completely converted into relationship
Mode.
The foregoing is only a preferred embodiment of the present invention, but scope of protection of the present invention is not limited thereto,
Anyone skilled in the art in the technical scope disclosed by the present invention, according to the technique and scheme of the present invention and its
Inventive concept is subject to equivalent substitution or change, should be covered by the protection scope of the present invention.
Claims (6)
1. a kind of mobile data services based on general purpose table storage and xml store exchange method, which is characterized in that including following step
Suddenly,
Step 1: it is abstract to establish business common store table, code is write, takes general data collection and data element mode to construct general
Store table, wherein the general storage table of business includes the common store table for recording specific business information；
Step 2: the definition of business datum is stored, business datum will be stored by corresponding allocation of computer and carry out class definition,
Wherein data type includes binary data, character data, Unicode data, date and time data, numerical data, currency
Data and special data, in addition, the definition data of also included user；
Step 3: neck can be used in special different business logic processing in business datum storage and the processing of particular service logic
The attribute of object and behavior are made description, in addition added by the field logical architecture mode of domain model as the M layer in MVC
One data access layer provides data to particular service logic, and business datum stores in treatment process, by all texts of database
Part is placed into SSD storage pool, and DBA, the thorough liberation from performance optimization comes out the program, by hardware investment reduce manpower and
Management cost, the program are suitable for OLTP and OLAP business；
Step 4: the upload setting of business datum, the upload setting of configuration service data on computers, in the equipment of computer
PORT COM is selected in manager option, then selects the attribute of PORT COM, selects advanced setting, modifies open position in data
Number, bits per second are changed to 1200, and data are to be changed to 8, no parity checking, no flow control, and stop position is changed to 1, finally selects the end COM
Slogan position COM2.
Step 5: tables of data xml conversion and compression encryption encapsulation establish jdbc-odbc connection, in defined variable, xml are written
File path writes code in eclipse, the data of general-purpose service data table is directly substituted into, the data of xml format are built
Then vertical file forms ZIP encryption solution briquetting by way of decompression；
Step 6: program is downloaded in general upload, is uploaded by the data that the upload program of collocation type is realized；
Step 7: business files processing routine, and business filing procedure is called to realize the seamless connection with former computer end operation system.
2. a kind of mobile data services based on general purpose table storage and xml according to claim 1 store exchange method,
It is characterized in that, in step 2, binary data includes Binary, Varbinary and Image, the type packet of character data
Include Char, Varchar and Text, Unicode data type includes Nchar, Nvarchar and Ntext, the date and when
Between data type include Datetime and Smalldatetime two types, numeric data type include positive number and negative,
Decimal and integer.
3. a kind of mobile data services based on general purpose table storage and xml according to claim 1 store exchange method,
It is characterized in that, in step 2, user is when creating user-defined data type, it is necessary to provide three numbers: the name of data type
The controllability of the system data type and data type that claim, are based on.
4. a kind of mobile data services based on general purpose table storage and xml according to claim 1 store exchange method,
It is characterized in that, in step 3, MVC pattern includes model, view and controller, and model is for encapsulating and the business of application program
The relevant data attribute of logic and processing method or behavior to data, view carry out graphical interfaces for interface personnel
Design, controller are mainly responsible for forwarding request, handle request.
5. a kind of mobile data services based on general purpose table storage and xml according to claim 1 store exchange method,
Be characterized in that, in step 3, the purpose of MVC pattern is to realize a kind of dynamic programming, make the subsequent modification to program and
Extension simplifies, and makes it possible the recycling of program a part, and in addition to this, this mode passes through the letter to complexity
Change, keep program structure more intuitive, also gives each basic portion while software systems are by separating itself basic part
Divide due function.
6. a kind of mobile data services based on general purpose table storage and xml according to claim 1 store exchange method,
It is characterized in that, in steps of 5, when data are carried out xml conversion, needs to parse xml document, using JDBC connection database,
The insert sentence that sql is executed in java imports data in data file, and so far xml mode is completely converted into relationship
Mode.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811426762.2A CN109582826A (en) | 2018-11-27 | 2018-11-27 | A kind of mobile data services storage exchange method based on general purpose table storage and xml |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811426762.2A CN109582826A (en) | 2018-11-27 | 2018-11-27 | A kind of mobile data services storage exchange method based on general purpose table storage and xml |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109582826A true CN109582826A (en) | 2019-04-05 |
Family
ID=65924441
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811426762.2A Pending CN109582826A (en) | 2018-11-27 | 2018-11-27 | A kind of mobile data services storage exchange method based on general purpose table storage and xml |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109582826A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021051625A1 (en) * | 2019-09-16 | 2021-03-25 | 平安科技（深圳）有限公司 | Data table construction method, apparatus and device, and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588372A (en) * | 2004-10-12 | 2005-03-02 | 北京北大方正电子有限公司 | General file storage method based on relation type data base |
| US20130132826A1 (en) * | 2011-11-18 | 2013-05-23 | Youngkun Kim | Method of converting data of database and creating xml document |
| CN105138613A (en) * | 2015-08-07 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Business object and xml message mutual conversion method and system |
| US9558164B1 (en) * | 2008-12-31 | 2017-01-31 | F5 Networks, Inc. | Methods and system for converting WSDL documents into XML schema |
-
2018
- 2018-11-27 CN CN201811426762.2A patent/CN109582826A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588372A (en) * | 2004-10-12 | 2005-03-02 | 北京北大方正电子有限公司 | General file storage method based on relation type data base |
| US9558164B1 (en) * | 2008-12-31 | 2017-01-31 | F5 Networks, Inc. | Methods and system for converting WSDL documents into XML schema |
| US20130132826A1 (en) * | 2011-11-18 | 2013-05-23 | Youngkun Kim | Method of converting data of database and creating xml document |
| CN105138613A (en) * | 2015-08-07 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Business object and xml message mutual conversion method and system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021051625A1 (en) * | 2019-09-16 | 2021-03-25 | 平安科技（深圳）有限公司 | Data table construction method, apparatus and device, and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8051102B2 (en) | Data base and knowledge operating system | |
| Karnitis et al. | Migration of relational database to document-oriented database: Structure denormalization and data transformation | |
| Su | SAM∗: a semantic association model for corporate and scientific-statistical databases | |
| CN102609255B (en) | A kind of generation method of Spring IOC configuration file | |
| CN104239073B (en) | Data maintenance system rapid prototyping development system and method | |
| CN108304463A (en) | A kind of data managing method and its database application component for database | |
| CN103617167B (en) | A kind of general metadata/Hibernate | |
| CN107103064A (en) | Data statistical approach and device | |
| CN104537012B (en) | Data processing method and device | |
| US11928083B2 (en) | Determining collaboration recommendations from file path information | |
| CN106599241A (en) | Big data visual management method for GIS software | |
| CN109582826A (en) | A kind of mobile data services storage exchange method based on general purpose table storage and xml | |
| Bai et al. | Introduction to databases | |
| CN108804460A (en) | A kind of query language based on SQL | |
| CN107273425A (en) | A kind of Database Development Method and device based on ORM frameworks | |
| Farooq | The data warehouse virtualization framework for operational business intelligence | |
| US20140067874A1 (en) | Performing predictive analysis | |
| Bai | Practical database programming with Java | |
| EP2544104A1 (en) | Database consistent sample data extraction | |
| CN114115837A (en) | MIS self-adaptive generator based on object information and use method | |
| Neil et al. | Design method for a Historical Data Warehouse, explicit valid time in multidimensional models | |
| CN103309983B (en) | Electrical anti-error system and method based on embedded database SQLite | |
| Harezlak et al. | Performance aspects of migrating a web application from a relational to a NoSQL Database | |
| CN107832387A (en) | A kind of SQL statement analytic method based on FMDB | |
| Aithal et al. | Disconnected Data Access Architecture using ADO. NET Framework |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190405 |