CN101739452A - Data exchange interface and realizing method thereof - Google Patents
Data exchange interface and realizing method thereof Download PDFInfo
- Publication number
- CN101739452A CN101739452A CN200910242778A CN200910242778A CN101739452A CN 101739452 A CN101739452 A CN 101739452A CN 200910242778 A CN200910242778 A CN 200910242778A CN 200910242778 A CN200910242778 A CN 200910242778A CN 101739452 A CN101739452 A CN 101739452A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- file
- standard form
- parameter
- 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
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000012545 processing Methods 0.000 claims abstract description 18
- 238000005538 encapsulation Methods 0.000 claims description 16
- 230000009471 action Effects 0.000 claims description 8
- 230000003993 interaction Effects 0.000 claims description 5
- 230000010354 integration Effects 0.000 abstract description 8
- 230000006870 function Effects 0.000 description 10
- 238000004519 manufacturing process Methods 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000006243 chemical reaction Methods 0.000 description 4
- 238000000151 deposition Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 239000012467 final product Substances 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000003860 storage Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 210000000746 body region Anatomy 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000007596 consolidation process Methods 0.000 description 1
- 239000000470 constituent Substances 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013497 data interchange Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000012856 packing Methods 0.000 description 1
- 238000010248 power generation Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data exchange interface and a realizing method thereof. The data exchange interface comprises a universal access module, a real-time system access module, a data processing module and a data format configuration module, wherein the universal access module is used for receiving an input parameter which is used for identifying an operation on a database and/or an object file and a return value which is used for describing the result of a current operation; the real-time system access module is used for receiving real-time data and forwarding by an application programming interface (API) mode; the data processing module is used for exchanging the data in a database list and a data file based on a data standard format configured by the data format configuration module; and the data format configuration module is used for configuring the data standard format of each data list in the database. The data exchange interface and realizing method thereof meet the access requirements to various relational databases, files, real-time data and other data sources in the data exchange or application integration, and support the access of real-time data and various data sources.
Description
Technical field
The present invention relates to the network application field, particularly relate to a kind of data exchange interface and its implementation.
Background technology
Continuous development along with infotech, a lot of enterprises or unit have built the infosystem of oneself, these infosystems are towards different business fields, and some larger units are because distributed more widely on the region, the infosystem that is distributed in constituent parts, all departments has formed the isolated data source of enterprise, for effectively utilizing these data sources, generally need realize sharing of information by application integration or Data Interchange Technology with integrated.No matter in application integration or in exchanges data, all relate to the problem of access data sources, most typical data source is a relational database.
At present, in a large amount of application integration platforms or data exchange interface, realized interface to the data source visit, for example: number of patent application is 200710041274.5, denomination of invention is the patented claim of " a kind of data exchange interface and method that is used for Database Systems ", the data exchange interface that this patent relates to comprises data exchange module and Data access module, data exchange module realizes that the packing data that database is needed is the XML data, and is transferred to database; Data access module realizes various databases are conducted interviews; Simultaneously, number of patent application is 200710043432.0, denomination of invention is the application documents of " based on the multi-source heterogeneous data integrated system of data flow technique ", the data source management server is provided in this patent, the interface that provides with outside heterogeneous data source is provided, and receives the data of outside heterogeneous system output.
Through to the existing technical Analysis of supporting the data source interface, mainly have following problem: prior art generally only supporting database and do not provide support as data source to file, real time data; The data exchange interface of prior art is a data base-oriented also, can't unify, call for operation system flexibly; And the data exchange interface of prior art has only been considered integrated between the system mostly, a little less than the function of compatible artificial treatment data, if when also not setting up corresponding information system on integrated a certain link, will cause integrated work to realize.
Summary of the invention
Technical matters to be solved by this invention provides a kind of data exchange interface and its implementation, in order to solve in the prior art problem that the data exchange interface of data base-oriented only can't be unified, call for operation system flexibly.
Another object of the present invention is that above-mentioned design is applied to provide a kind of data exchange interface and implement device thereof in the concrete applied environment, thereby guarantees the realization and the application of this method.
For solving the problems of the technologies described above, the embodiment of the invention provides a kind of data exchange interface and its implementation, comprising:
Unified access module is used to receive input parameter and rreturn value, and described input parameter is used to identify the operation to database and/or file destination, and described rreturn value is used to describe the result of current operation;
The real-time system access module adopts application programming interface API mode, is used for receiving real-time data and transmits;
Data processing module is used for the data standard form according to described data layout configuration module configuration, and data in the database table and data file are changed mutually;
The data layout configuration module is used for the data standard form of each tables of data of configuration database;
The data standard lattice frame is used to provide the data standard structure, and described data standard structure is used for the data interaction between the described unified access module of standard, real-time system access module, data processing module and the data layout configuration module.
Preferably, also comprise:
The file download module is used for according to described input parameter, downloads corresponding file destination from Web server.
Preferably, described data processing module specifically comprises:
The data encapsulation submodule is used for the data standard form according to described data layout configuration module configuration, is the data file that meets described data standard form with the data encapsulation in the database table;
The data parsing submodule is used for the data standard form according to the configuration of described data layout configuration module, and the data file that will meet described data standard form is converted to the data in the database table.
Preferably, described data standard form comprises: expandable mark language XML form, Excel form and/or E language format.
Preferably, described input parameter comprises parameter head and parameter body, and described parameter head is used to identify the essential information of describing current operation, and described parameter body is used to identify current action type.
The embodiment of the invention also provides a kind of data exchange interface and implement device thereof, comprising:
Unified access module receives input parameter and rreturn value, and described input parameter is used to identify the operation to database and/or file destination, and described rreturn value is used to describe the result of current operation; The real-time system access module adopts application programming interface API mode, and receiving real-time data is also transmitted;
The data standard form of each tables of data in the data layout configuration module configuration database;
Data processing module is changed data in the database table and data file mutually according to the data standard form of described data layout configuration module configuration.
Preferably, also comprise:
The file download module is downloaded corresponding file destination according to described input parameter from Web server.
Preferably, described data processing module is changed data in the database table and data file mutually according to the data standard form of described data layout configuration module configuration, specifically comprises:
The data encapsulation submodule is the data file that meets described data standard form according to the data standard form of described data layout configuration module configuration with the data encapsulation in the database table;
The data parsing submodule is according to the data standard form of described data layout configuration module configuration, and the data file that will meet described data standard form is converted to the data in the database table.
Preferably, described data standard form comprises: expandable mark language XML form, Excel form and/or E language format.
Preferably, described input parameter comprises parameter head and parameter body, and described parameter head is used to identify the essential information of describing current operation, and described parameter body is used to identify current action type.
Compared with prior art, the present invention has the following advantages:
Adopt data exchange interface of the present invention, no matter data source is the visit that database, file or real time data can realize data, solved the requirement of in exchanges data or the application integration several data sources such as kinds of relationships database, file, real time data being visited, not only support the access of real time data, also support the access in several data source.Simultaneously, the present invention can adopt XML, WebServices technology, thereby has realized having unified, the data exchange interface of interface flexibly, the calling of convenient business application system.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art, to do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the structured flowchart of a kind of data exchange interface embodiment 1 of the present invention;
Fig. 2 is the structural representation of a kind of data exchange interface input parameter of the present invention;
Fig. 3 is the structural representation of a kind of data exchange interface input parameter of the present invention;
Fig. 4 is a kind of data exchange interface of the present invention detailed structural representation in actual applications;
Fig. 5 is the structured flowchart of a kind of data exchange interface embodiment 2 of the present invention;
Fig. 6 is the structural representation of a kind of data exchange interface input parameter of the present invention;
Fig. 7 is the structural representation of the data file that generates in the XML form language in a kind of data exchange interface of the present invention;
Fig. 8 is the synoptic diagram of data volume structure in the XML form language in a kind of data exchange interface of the present invention;
Fig. 9 is the data file structure synoptic diagram of Excel form in a kind of data exchange interface of the present invention;
Figure 10 is the process flow diagram of the implementation method embodiment 1 of a kind of data exchange interface of the present invention;
Figure 11 is the process flow diagram of the implementation method embodiment 2 of a kind of data exchange interface of the present invention.
Embodiment
For above-mentioned purpose of the present invention, feature and advantage can be become apparent more, the present invention is further detailed explanation below in conjunction with the drawings and specific embodiments.
The present invention can be used in numerous general or special purpose calculation element environment or the configuration.For example: personal computer, server computer, handheld device or portable set, plate equipment, multiprocessor device, comprise distributed computing environment of above any device or equipment or the like.
The present invention can describe in the general context of the computer executable instructions of being carried out by computing machine, for example program module.Usually, program module comprises the routine carrying out particular task or realize particular abstract, program, object, assembly, data structure or the like.Also can in distributed computing environment, put into practice the present invention, in these distributed computing environment, by by communication network connected teleprocessing equipment execute the task.In distributed computing environment, program module can be arranged in the local and remote computer-readable storage medium that comprises memory device.
With reference to figure 1, show the structured flowchart of a kind of data exchange interface embodiment 1 of the present invention, can comprise with lower module:
Described unified access module 101 can trigger different modules according to the difference of described input parameter to carry out follow-up different task; Described input parameter can comprise parameter head and parameter body, and described parameter head is used to identify the essential information of describing current operation, and described parameter body is used to identify current action type.
Described parameter head can be described essential informations such as the title, user of current service; The parameter body is the core of input parameter, can express the input data, obtains data, send multinomial function such as data, and the parameter body generally comprises Data Identification, the parameter when promptly carrying out this function, for example date of the sign of a certain database table, data etc.; Rreturn value can also be described two parts by execution result and be constituted by success or fail flag in practice, and success or fail flag have only 0 or 1 two value, is convenient to program and judges and discern; Execution result description part then describes this in detail and calls result, generally adopts natural language, is convenient to User Recognition;
When input parameter was represented operation to database, the name of input parameter was called requestStr, and the parameter type of input parameter and rreturn value is String, and input parameter and rreturn value can adopt the XML format description; When database is data source, can carry out different functions according to different input parameters; For example: the input parameter sign need be when database be imported data or is obtained data, thereby then described unified access module 101 will be called data processing module and finish read-write operation to database, and these operations can be expanded with changes in demand, and do not influence existing operation;
When input parameter is represented transmit operation to file destination, input parameter can be two, one of them parameter name is requestStr, this parameter type is String, another is fileObject, this parameter type is the DataHandler array, is a file object, and the fileObject parameter can be sky; And parameter requestStr and rreturn value adopt the XML format description; When parameter f ileObject is sky, need in parameter requestStr, import the file consolidation URLs URL path of file destination into, the subsequent file download module will be downloaded corresponding file destination from this URL so, can also carry out other operation after download is finished, for example send to another station server; The structure of input parameter can be as shown in Figure 2.Wherein, this input parameter also comprises parameter head and parameter body two parts, and described parameter head is also represented the essential information of current service, and described parameter body is the core of input parameter, has comprised transmission file destination address and file identification;
When input parameter was represented to obtain file destination, then input parameter adopted the XML format description, and rreturn value is the object of DataHandler.The structure of input parameter as shown in Figure 3.
Real-time system access module 102 adopts application programming interface API mode, is used for receiving real-time data and transmits;
The real-time system access module, can adopt application programming interface API mode, API is some predefined functions, purpose provide application program and developer based on certain software or hardware to visit the ability of one group of routine, and need not to visit source code, or understand the details of internal work mechanism.API also refers in particular to the explanation document of API except the meaning that application " application programming interfaces " are arranged, be also referred to as help document;
Real-time system access module 102 can receiving real-time data and is transmitted, and real time data is the data that operation system produces in real time in practice, general production data, the data of production control system etc.;
Wherein, described data standard form comprises XML, Excel or three kinds of forms of E language, not only satisfied the conversion demand that database table is converted to data file, and satisfied no professional system, the demand of having only the hand-coding data can be supported the access to common system in the electric system production run simultaneously.Wherein, the XML extensibility is strong, is applicable to intersystem interface, and Excel is readable strong, is fit to user's hand-coding data; The E language construction is simple, and it is little to take memory capacity, uses when being fit to the system of electric system production run and other system integration or exchanges data;
Based on described data standard form, can be autonomous set in advance transformational relation between database table and the data standard form, wherein, generally speaking, it is then more convenient that the Excel form can be set; Can carry out the conversion of database table and data file by described data processing module according to data standard form and transformational relation;
Data layout configuration module 104 is used for the data standard form of each tables of data of configuration database;
Data standard lattice frame 105 is used to provide the data standard structure, and described data standard structure is used for the data interaction between the described unified access module of standard, real-time system access module, data processing module and the data layout configuration module.
Wherein, described data standard lattice frame, can define data standard form based on XML, Excel and E language, be equivalent to provide a kind of data structure, data between other each modules all need to meet this data structure, the data interaction of carrying out between so just can other each modules of standard.With reference to figure 4, be a detailed structural representation of present embodiment in actual applications.
In actual applications, no matter in application integration or in exchanges data, all relate to the various data sources of visit, data source has also comprised except relational database, other data such as file and real time data; Wherein there is the data base management system (DBMS) of a plurality of manufacturers exploitation in relational database; File is generally contents such as electronic document, video, and these files are little of several bytes, arrive hundreds of million greatly not wait; Characteristics such as real time data is generally the business datum in the production system, has the occurrence frequency height, and data volume is little for example are the status information that the unit circulation produces a certain equipment with the second.
Adopt the method for present embodiment, as can be seen, no matter data source is the visit that database, file or real time data can realize data, solved the requirement of in exchanges data or the application integration several data sources such as kinds of relationships database, file, real time data being visited, not only support the access of real time data, also support the access in several data source.Simultaneously, present embodiment can adopt XML, Web Services technology, thereby has realized having unified, the data exchange interface of interface flexibly, the calling of convenient business application system.The described method of present embodiment efficiently solves in the database data to the conversion of file, simultaneously based on three kinds of forms, satisfied the demand that operation system is reported and submitted by interface interchange, manual compiling Excel formatted data file, also solved with the electric system production run in the good integrated problem of nothing of production system.
With reference to figure 5, show the structured flowchart of a kind of data exchange interface embodiment 2 of the present invention, can comprise with lower module:
In the present embodiment, described operation to database can be divided into obtains data and writes the data action type, then the structural representation of described input parameter can be with reference to shown in Figure 6, can be as seen from Figure 6, the parameter body is the core of input parameter, the input data can be provided, obtain data, send multinomial function such as data, the input parameter in each function generally comprises Data Identification, the parameter when promptly carrying out this function; Wherein, data volume is the data based on the encapsulation of XML, Excel, E language, specifically adds based on the data layout frame of XML, Excel, E language and sees " data layout framework ".Can carry out different functions according to different input parameters, for example: when input parameter represents to carry out " input data function ", then described unified access module 101 will be called the data parsing submodule and finish write operation to database; Data only just exist when data manipulation is obtained in the input parameter execution, have stored the result after the data that get access to from database encapsulate by XML, Excel, E language.
Wherein,, adopt XML Schema to define, adopt XML that data are encapsulated based on XML data standard form.Defined file to the data form is referred to as data template, and the data that encapsulated according to data template are referred to as data file.List structure and data with relational database are likened, and XML Schema is equivalent to the DDL of database, and data template is the list structure that adopts the DDL language to create, and the data after the employing XML encapsulation are equivalent to the content in the tables of data.
The XML form is made of two parts, and a part is a data template, and another part is exactly the data file that generates according to data template.Data template is the description to the data file, and document format data must meet data template.Data file is the XML file according to the requirement generation of data template, it is described to be data itself, its file extent is called " XML ", form by Data Identification district and data field, the essential information of the data units of providing has been provided in the Data Identification district, and its form is fixed, and the data field is the set of data volume, depositing a plurality of data volumes, data volume is represented with the form of element.The data file structure that generates as shown in Figure 7.
Comprised two parts content in the data file, one is the Data Identification district, and the essential information of the identification data unit of providing is provided, for example unit code, organization etc., and form is fixed.Another is the data field, is used to depositing a plurality of data volumes, has comprised the sign and concrete data of data, according to the difference of exchanging contents, has defined different contents.
Data volume is made up of tag slot, the data entity collection of data volume.The data volume structure as shown in Figure 8.Data volume comprises two parts content, and a part is the data volume sign, is used for the essential information of identification data, for example, and other information of data phase etc.; Another part is the data entity collection, is used to deposit concrete data, is made up of one or more data entities, a data entity is made of one or more tuples, each data entity is all stored each element representation data line, data item of each attribute representation with the form of bivariate table.
Wherein, based on the data standard form of Excel, promptly be the Excel form, when being data carrier storage data with the Excel file, its data template and data file pattern basically identical.Each sheet of Excel deposits an item number according to content (being generally a tables of data or a record), and a data file can be deposited multinomial data content, is divided into data head and data area two parts on each sheet.Data head the store data unit of providing, phase is provided does not wait information, has taken the first eight row of sheet, is the sign to the data content; The data area is used for the store data content, represents with the form of bivariate table, by data standard format configuration instrument definition.The data file structure synoptic diagram of Excel form can be with reference to shown in Figure 9.
In the data head part of Excel form, cell A1 is set to " * ", and whether the form of sign Excel belongs to the data standard form; Cell A2 is used for the setting unit title; Cell A3 is used for the setting unit code; Cell A4 is used to be provided with the reporter; Cell A5 is used to be provided with the swap data title; Cell A6 is used to be provided with the swap data sign; Cell A7 is used to be provided with the phase other (monthly magazine, annual report, daily paper, quarterly report, weekly, perpetual) of swap data; Wherein, for perpetual other situation, A8, C8, E8 are empty; Cell A8 represents the time of form; Cell C8 is used to be provided with month, season, the week of form; Cell E8 is used to be provided with form day (having only daily paper to use).In the data area wherein the 9th row begins to be body region, is used for depositing concrete data.
Data standard form based on the E language promptly is the E language format, is carrier with the text, the data format specifications that is described with the E language.The Data Identification zone is as follows:
＜physical name deptCode=' 123 ' year=' 2006 ' month=' 11 ' day=' 18 ' isYear=' 0 ' 〉
@ name attribute 1 name attribute 2 titles ... attribute n title
The data area is as follows:
# index name attribute 1 value attribute 2 values ... attribute n value
# index name attribute 1 value attribute 2 values ... attribute n value
……
＜/physical name〉wherein:
The initial symbol of exchanging contents: the usefulness angle brackets "＜〉" expression, represent the initial of this data item.Link to each other with equal sign "=" between flag attribute name and the property value.As year=' 2005 ' month=' 05 ', the expression report data phase other, between a plurality of flag attribute with a space-separated.
Entity end symbol: represent with adding monocline thick stick "＜/〉" in the angle brackets, show that this row is the end of class or solid data piece.
Attribute boot symbol: during with single-address symbol " @ " expression, show that describing mode is for each object accounts for delegation, each attribute accounts for row.
Data pilot symbol:, show this behavior data with pound sign " # " expression.The expression way of data depends on the attribute boot symbol.
When input parameter need to represent data in the reading database, the data standard form of the described data layout configuration module configuration of 501 foundations of then described data encapsulation submodule is the data file that meets described data standard form with the data encapsulation in the database table;
When input parameter represents that needs write data in database, then described data parsing submodule needs the data standard form according to described data layout configuration module configuration, and the data file that will meet described data standard form is converted to the data in the database table.
Real-time system access module 102 adopts application programming interface API mode, is used for receiving real-time data and transmits;
Data layout configuration module 104 is used for the data standard form of each tables of data of configuration database.
Described file download module 503 can according to the file identification in the parameter body of described input parameter, be downloaded corresponding file destination from described URL address according to the URL address in the input parameter.
In the present embodiment, based on the XML that sets in advance, Excel, three kinds of data standard forms of E language, realized the mutual conversion of database table and data file in the database, having adapted to does not have the needs that professional system carries out exchanges data yet, also can support the access of electric power generation system simultaneously.Present embodiment realized the reading and writing of polytype data source based on XML, Web Services technology, realized having unified, the data exchange interface of interface flexibly, the calling of convenient operation system.
With reference to Figure 10, show the structured flowchart of the implementation method embodiment 1 of a kind of data exchange interface of the present invention, can may further comprise the steps:
Step 1001: unified access module receives input parameter and rreturn value, and described input parameter is used to identify the operation to database and/or file destination, and described rreturn value is used to describe the result of current operation; The real-time system access module adopts application programming interface API mode, and receiving real-time data is also transmitted;
Step 1002: the data standard form of each tables of data in the data layout configuration module configuration database;
Step 1003: data processing module is changed data in the database table and data file mutually according to the data standard form of described data layout configuration module configuration.
Simultaneously,, show the structured flowchart of the implementation method embodiment 1 of a kind of data exchange interface of the present invention, can may further comprise the steps with reference to Figure 11:
Step 1101: unified access module receives input parameter and rreturn value, and described input parameter is used to identify the operation to database and/or file destination, and described rreturn value is used to describe the result of current operation; The real-time system access module adopts application programming interface API mode, and receiving real-time data is also transmitted;
Step 1102: the data standard form of each tables of data in the data layout configuration module configuration database;
Step 1103: the data encapsulation submodule is the data file that meets described data standard form according to the data standard form of described data layout configuration module configuration with the data encapsulation in the database table;
Step 1104: the data parsing submodule is according to the data standard form of described data layout configuration module configuration, and the data file that will meet described data standard form is converted to the data in the database table.
Step 1105: the file download module is downloaded corresponding file destination according to described input parameter from Web server.
Need to prove, for aforesaid each method embodiment, for simple description, so it all is expressed as a series of combination of actions, but those skilled in the art should know, the present invention is not subjected to the restriction of described sequence of movement, because according to the present invention, some step can adopt other orders or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in the instructions all belongs to preferred embodiment, and related action and module might not be that the present invention is necessary.
Need to prove that each embodiment in this instructions all adopts the mode of going forward one by one to describe, what each embodiment stressed all is and the difference of other embodiment that identical similar part is mutually referring to getting final product between each embodiment.For device class embodiment, because it is similar substantially to method embodiment, so description is fairly simple, relevant part gets final product referring to the part explanation of method embodiment.
Need to prove, in this article, relational terms such as first and second grades only is used for an entity or operation are made a distinction with another entity or operation, and not necessarily requires or hint and have the relation of any this reality or in proper order between these entities or the operation.And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thereby make and comprise that process, method, article or the equipment of a series of key elements not only comprise those key elements, but also comprise other key elements of clearly not listing, or also be included as this process, method, article or equipment intrinsic key element.Do not having under the situation of more restrictions, the key element that limits by statement " comprising ... ", and be not precluded within process, method, article or the equipment that comprises described key element and also have other identical element.
More than a kind of data exchange interface provided by the present invention and its implementation and data exchange interface and implement device thereof are described in detail, used specific case herein principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that all can change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (10)
1. a data exchange interface is characterized in that, comprising:
Unified access module is used to receive input parameter and rreturn value, and described input parameter is used to identify the operation to database and/or file destination, and described rreturn value is used to describe the result of current operation;
The real-time system access module adopts application programming interface API mode, is used for receiving real-time data and transmits;
Data processing module is used for the data standard form according to described data layout configuration module configuration, and data in the database table and data file are changed mutually;
The data layout configuration module is used for the data standard form of each tables of data of configuration database;
The data standard lattice frame is used to provide the data standard structure, and described data standard structure is used for the data interaction between the described unified access module of standard, real-time system access module, data processing module and the data layout configuration module.
2. data exchange interface as claimed in claim 1 is characterized in that, also comprises:
The file download module is used for according to described input parameter, downloads corresponding file destination from Web server.
3. data exchange interface as claimed in claim 1 is characterized in that, described data processing module specifically comprises:
The data encapsulation submodule is used for the data standard form according to described data layout configuration module configuration, is the data file that meets described data standard form with the data encapsulation in the database table;
The data parsing submodule is used for the data standard form according to the configuration of described data layout configuration module, and the data file that will meet described data standard form is converted to the data in the database table.
4. data exchange interface as claimed in claim 1 is characterized in that, described data standard form comprises: expandable mark language XML form, Excel form and/or E language format.
5. as each described data exchange interface of claim 1-4, it is characterized in that described input parameter comprises parameter head and parameter body, described parameter head is used to identify the essential information of describing current operation, and described parameter body is used to identify current action type.
6. the implementation method of a data exchange interface, it is characterized in that, there is the data standard lattice frame, described data standard lattice frame is used to provide the data standard structure, described data standard structure is used for the data interaction between the described unified access module of standard, real-time system access module, data processing module and the data layout configuration module, and described method comprises:
Unified access module receives input parameter and rreturn value, and described input parameter is used to identify the operation to database and/or file destination, and described rreturn value is used to describe the result of current operation; The real-time system access module adopts application programming interface API mode, and receiving real-time data is also transmitted;
The data standard form of each tables of data in the data layout configuration module configuration database;
Data processing module is changed data in the database table and data file mutually according to the data standard form of described data layout configuration module configuration.
7. method as claimed in claim 6 is characterized in that, also comprises:
The file download module is downloaded corresponding file destination according to described input parameter from Web server.
8. method as claimed in claim 6 is characterized in that, described data processing module is changed data in the database table and data file mutually according to the data standard form of described data layout configuration module configuration, specifically comprises:
The data encapsulation submodule is the data file that meets described data standard form according to the data standard form of described data layout configuration module configuration with the data encapsulation in the database table;
The data parsing submodule is according to the data standard form of described data layout configuration module configuration, and the data file that will meet described data standard form is converted to the data in the database table.
9. method as claimed in claim 6 is characterized in that, described data standard form comprises: expandable mark language XML form, Excel form and/or E language format.
10. as each described method of claim 6-9, it is characterized in that described input parameter comprises parameter head and parameter body, described parameter head is used to identify the essential information of describing current operation, and described parameter body is used to identify current action type.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910242778A CN101739452A (en) | 2009-12-17 | 2009-12-17 | Data exchange interface and realizing method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910242778A CN101739452A (en) | 2009-12-17 | 2009-12-17 | Data exchange interface and realizing method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101739452A true CN101739452A (en) | 2010-06-16 |
Family
ID=42462935
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910242778A Pending CN101739452A (en) | 2009-12-17 | 2009-12-17 | Data exchange interface and realizing method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101739452A (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102043836A (en) * | 2010-12-01 | 2011-05-04 | 北京迅捷英翔网络科技有限公司 | Data adapting device and method |
| CN102043837A (en) * | 2010-12-01 | 2011-05-04 | 北京迅捷英翔网络科技有限公司 | Data integration system and method |
| CN102129443A (en) * | 2010-12-30 | 2011-07-20 | 中国民航信息网络股份有限公司 | Real-time data transmission channel and method based on USAS (Univac Standard Airline Systems) host |
| CN102340459A (en) * | 2010-07-29 | 2012-02-01 | 快威科技集团有限公司 | Information exchange and integration platform and method used for information systems |
| CN102521318A (en) * | 2011-12-02 | 2012-06-27 | 华侨大学 | General data exchange device based on extensible markup language (XML) |
| CN102819537A (en) * | 2011-09-29 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method and system for data exchange in heterogeneous system |
| CN103177119A (en) * | 2013-04-09 | 2013-06-26 | 上海华力微电子有限公司 | Data type automatic conversion system and method based on database |
| CN103455591A (en) * | 2013-08-30 | 2013-12-18 | 国家电网公司 | Standard data exchange interface method of parallel cooperative system |
| CN104092784A (en) * | 2014-06-24 | 2014-10-08 | 用友优普信息技术有限公司 | Device and method for data exchange |
| CN104317879A (en) * | 2014-10-21 | 2015-01-28 | 国网山西省电力公司太原供电公司 | Method for displaying telemetering data in real time on basis of real-time database |
| CN108446517A (en) * | 2018-04-04 | 2018-08-24 | 国家电网公司 | Method and system for cross-software platform interaction of three-dimensional design data of power transmission and transformation |
| CN108924185A (en) * | 2018-06-01 | 2018-11-30 | 中铁程科技有限责任公司 | Interface creation method and device |
| CN109460912A (en) * | 2018-10-31 | 2019-03-12 | 泰康保险集团股份有限公司 | Data processing method, device, storage medium and electronic equipment |
| CN110781230A (en) * | 2019-09-12 | 2020-02-11 | 腾讯大地通途（北京）科技有限公司 | Data access method, device and equipment |
| CN111427845A (en) * | 2020-02-28 | 2020-07-17 | 中国电子科技集团公司第十五研究所 | Interactive modeling analysis operator data exchange method |
| CN112308431A (en) * | 2020-11-03 | 2021-02-02 | 平安普惠企业管理有限公司 | Big data index management method, device, equipment and storage medium |
| CN114422377A (en) * | 2021-12-30 | 2022-04-29 | 北京润科通用技术有限公司 | Method and device for generating data forwarding model |
-
2009
- 2009-12-17 CN CN200910242778A patent/CN101739452A/en active Pending
Cited By (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102340459A (en) * | 2010-07-29 | 2012-02-01 | 快威科技集团有限公司 | Information exchange and integration platform and method used for information systems |
| CN102043836A (en) * | 2010-12-01 | 2011-05-04 | 北京迅捷英翔网络科技有限公司 | Data adapting device and method |
| CN102043837A (en) * | 2010-12-01 | 2011-05-04 | 北京迅捷英翔网络科技有限公司 | Data integration system and method |
| CN102129443A (en) * | 2010-12-30 | 2011-07-20 | 中国民航信息网络股份有限公司 | Real-time data transmission channel and method based on USAS (Univac Standard Airline Systems) host |
| CN102819537A (en) * | 2011-09-29 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method and system for data exchange in heterogeneous system |
| CN102819537B (en) * | 2011-09-29 | 2016-08-31 | 金蝶软件（中国）有限公司 | Heterogeneous system carries out the method and system of data exchange |
| CN102521318A (en) * | 2011-12-02 | 2012-06-27 | 华侨大学 | General data exchange device based on extensible markup language (XML) |
| CN103177119A (en) * | 2013-04-09 | 2013-06-26 | 上海华力微电子有限公司 | Data type automatic conversion system and method based on database |
| CN103455591A (en) * | 2013-08-30 | 2013-12-18 | 国家电网公司 | Standard data exchange interface method of parallel cooperative system |
| CN103455591B (en) * | 2013-08-30 | 2017-05-10 | 国家电网公司 | Standard data exchange interface method of parallel cooperative system |
| CN104092784A (en) * | 2014-06-24 | 2014-10-08 | 用友优普信息技术有限公司 | Device and method for data exchange |
| CN104092784B (en) * | 2014-06-24 | 2018-05-25 | 用友优普信息技术有限公司 | DEU data exchange unit and method for interchanging data |
| CN104317879B (en) * | 2014-10-21 | 2018-01-12 | 国网山西省电力公司太原供电公司 | A kind of telemetry real-time exhibition method based on real-time data base |
| CN104317879A (en) * | 2014-10-21 | 2015-01-28 | 国网山西省电力公司太原供电公司 | Method for displaying telemetering data in real time on basis of real-time database |
| CN108446517A (en) * | 2018-04-04 | 2018-08-24 | 国家电网公司 | Method and system for cross-software platform interaction of three-dimensional design data of power transmission and transformation |
| CN108924185A (en) * | 2018-06-01 | 2018-11-30 | 中铁程科技有限责任公司 | Interface creation method and device |
| CN109460912A (en) * | 2018-10-31 | 2019-03-12 | 泰康保险集团股份有限公司 | Data processing method, device, storage medium and electronic equipment |
| CN110781230A (en) * | 2019-09-12 | 2020-02-11 | 腾讯大地通途（北京）科技有限公司 | Data access method, device and equipment |
| CN110781230B (en) * | 2019-09-12 | 2024-04-12 | 腾讯大地通途（北京）科技有限公司 | Data access method, device and equipment |
| CN111427845A (en) * | 2020-02-28 | 2020-07-17 | 中国电子科技集团公司第十五研究所 | Interactive modeling analysis operator data exchange method |
| CN112308431A (en) * | 2020-11-03 | 2021-02-02 | 平安普惠企业管理有限公司 | Big data index management method, device, equipment and storage medium |
| CN112308431B (en) * | 2020-11-03 | 2023-11-21 | 北京国联视讯信息技术股份有限公司 | Big data index management method, device, equipment and storage medium |
| CN114422377A (en) * | 2021-12-30 | 2022-04-29 | 北京润科通用技术有限公司 | Method and device for generating data forwarding model |
| CN114422377B (en) * | 2021-12-30 | 2023-09-22 | 北京润科通用技术有限公司 | Method and device for generating data forwarding model |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101739452A (en) | Data exchange interface and realizing method thereof | |
| CN108874971B (en) | Tool and method applied to mass tagged entity data storage | |
| US7873591B2 (en) | User-interface architecture for manipulating business models | |
| CN102917009B (en) | A kind of stock certificate data collection based on cloud computing technology and storage means and system | |
| CN102999537A (en) | System and method for data migration | |
| CN102646039A (en) | Software interface generating system and method based on extensible markup language (XML) Schema | |
| CN104361139A (en) | Data importing device and method | |
| CN102214243A (en) | Version management system for x extensible business reporting language (XBRL) classification standard | |
| KR20100015368A (en) | A method of data storage and management | |
| CN101609473A (en) | A kind of method of Structured Query Language (SQL) of reconstruct report query and device | |
| CN102789491A (en) | Configurable data subscribing and publishing system and method thereof | |
| CN102982439A (en) | Method for generating electronic document and electronic document generating system | |
| CN100498787C (en) | Report generating method, equipment and system | |
| CN102722769A (en) | Experimental data processing system and method | |
| CN102880683A (en) | Automatic network generation system for feasibility study report and generation method thereof | |
| CN102866986A (en) | Document format conversion system | |
| CN101702216A (en) | Method for supporting configuration of various stock services | |
| CN102420862B (en) | A kind of Internet of things middleware message form conversion method | |
| CN101645062B (en) | Report form generation method and system | |
| CN109597603B (en) | Demand document automatic generation method based on document component | |
| Wolf | Solving location‐allocation problems with professional optimization software | |
| CN105550176A (en) | Basic mapping method for relational database and XML | |
| CN108846002A (en) | Label real time updating method and system | |
| Sharma et al. | Database Management Systems—An Efficient, Effective, and Augmented Approach for Organizations | |
| CN103377175A (en) | Structured document converting based on partition |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20100616 |