CN101655873A - Single sign-on system as well as method and device for inputting and outputting data thereof - Google Patents
Single sign-on system as well as method and device for inputting and outputting data thereof Download PDFInfo
- Publication number
- CN101655873A CN101655873A CN200910189794A CN200910189794A CN101655873A CN 101655873 A CN101655873 A CN 101655873A CN 200910189794 A CN200910189794 A CN 200910189794A CN 200910189794 A CN200910189794 A CN 200910189794A CN 101655873 A CN101655873 A CN 101655873A
- Authority
- CN
- China
- Prior art keywords
- data
- data file
- xml form
- data source
- file
- 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
Images
Abstract
The invention is suitable for the field of data treatment, and provides a single sign-on system as well as a method and a device for inputting and outputting the data thereof. The method comprises thefollowing steps: leading out data from a reference data source of the single sign-on system and storing the led data as data documents of XML format; and leading in the data documents of XML format into a target data source of the single sign-on system. The invention adopts the data documents of XML format to carry out data transmission between the reference data source and the target data source, thereby shielding the heterogeneity of DMBS between the reference data source and the target data source and the heterogeneity of network protocols, and being convenient for the single sign-on system to obtain the reference data source and the target data source for the mutual leading in and leading out of data.
Description
Technical field
The invention belongs to data processing field, relate in particular to a kind of single-node login system and data importing deriving method and device.
Background technology
A plurality of operation systems are being carried out in the integrated application scenarios, as in single-node login system, because data base management system (DBMS) (the Data Base Management System between each operation system, DMBS), procotol etc. there are differences, make when the data of integrated each operation system, need depend on the DMBS isomery of each operation system and importing and the derivation that the procotol isomery could be realized integrated data, cause the importing of integrated data and derive that the process difficulty is big, complexity is high.
Prior art provides a kind of importing and derivation that realizes the data integration of a plurality of operation systems by the mode of manually filling in and insert integrated content, but the importing of this integrated data and deriving method are because the importing and the derivation of integrated data are manually carried out in employing, be difficult to guarantee fully accuracy, and need pay huge human cost, be difficult to satisfy the data integration demand.
Prior art provides the importing of another kind of integrated data and deriving method to adopt existing user's integrated functionality exactly, though also can satisfy the needs of service application, but in integrating process, need the third party system to be based upon just to carry out on the certain condition integrated, connect by certain agreement etc. as needs, thereby make data integration have limitation, be difficult to satisfy the data integration demand.
Summary of the invention
The purpose of the embodiment of the invention is to provide a kind of data importing deriving method, is intended to solve the problem that existing data importing deriving method is difficult to satisfy the data integration needs.
The embodiment of the invention is achieved in that the data importing deriving method in a kind of single-node login system, and described method comprises the steps:
Derived data from the source of reference data of single-node login system, and derived data is stored as the data file of XML form;
The data file of described XML form is imported in the target data source of single-node login system.Another purpose of the embodiment of the invention is to provide a kind of data importing let-off gear(stand), and described device comprises:
The data lead-out unit is used for the source of reference data derived data from single-node login system, and derived data is stored as the data file of XML form;
The data importing unit is used for the target data source with the data file importing single-node login system of XML form.
Another purpose of the embodiment of the invention is to provide a kind of single-node login system, and described system comprises described data importing let-off gear(stand).
In embodiments of the present invention, during data in integrated each operation system of single-node login system, data file by adopting the XML form is carried out data transfer between the source of reference data of single-node login system and target data source, thereby shielded the isomery of DMBS between source of reference data and the target data source and the isomery of procotol, be convenient in the single-node login system source of reference data and target data source and carry out data importing and derivation mutually.
Description of drawings
Fig. 1 is the realization flow figure of the data importing deriving method in the single-node login system that provides of the embodiment of the invention;
Fig. 2 is the realization flow figure of the data deriving method in the single-node login system that provides of the embodiment of the invention;
Fig. 3 is the synoptic diagram of the human-computer interaction interface that is used for derived data that provides of the embodiment of the invention;
Fig. 4 is the realization flow figure of the data lead-in method in the single-node login system that provides of the embodiment of the invention;
Fig. 5 is the synoptic diagram that the human-computer interaction interface of data is provided the embodiment of the invention being used to of providing;
Fig. 6 is the structured flowchart that imports and exports device that the embodiment of the invention provides.
Embodiment
In order to make purpose of the present invention, technical scheme and advantage clearer,, the present invention is further elaborated below in conjunction with drawings and Examples.Should be appreciated that specific embodiment described herein only in order to explanation the present invention, and be not used in qualification the present invention.
In embodiments of the present invention, when carrying out the system integration, adopt the data file storage derived data of XML form and import data, thereby in carrying out system integration process, the data file that only needs parsing XML format, the importing and the derivation of data be can realize, the DMBS isomery between a plurality of application systems, the isomery problem of procotol avoided.
Fig. 1 shows the realization flow of the data importing deriving method in the single-node login system that the embodiment of the invention provides, and details are as follows:
In step S101, derived data from the source of reference data of single-node login system, and derived data is stored as the data file of XML form.Its detailed process does not repeat them here as shown in Figure 2.
In step S102, the data file of XML form is imported in the target data source of single-node login system.Its detailed process does not repeat them here as shown in Figure 4.
Fig. 2 shows the derived data from the source of reference data of single-node login system that the embodiment of the invention provides, and derived data is stored as the realization flow of the data file of XML form, and details are as follows:
In step S201, receive the data source configuration information of the data to be exported of user's input, and connect data source according to the data source configuration information.
Wherein the data source configuration information comprises but is not limited to store path of source of reference data, resource link address, resource connection type, derived data etc.Wherein source of reference data is meant the data source of the data that need derivation.The resource link address is meant the link address of the data source that needs derivation.The resource connection type is meant the type of the data source that needs derivation, includes but not limited to type of database, field type and data file class.In embodiments of the present invention, when the resource connection type was type of database, this data source configuration information also comprised port, resource items login username, resource items login password etc.; When the resource connection type was field type, this data source configuration information also comprised port, resource items login username, resource items login password, connects proprietary name etc.; When the resource connection type was data file class, this data source configuration information also comprised the absolute path of data file client.Wherein connect proprietary name and refer in particular to absolute path in the territory.
During specific implementation, can be by be used for the human-computer interaction interface of derived data to user's output, so that the user is by this human-computer interaction interface input data source configuration information.Seeing also Fig. 3, is the synoptic diagram to the human-computer interaction interface that is used for derived data of user output that the embodiment of the invention provides, and the user is by this human-computer interaction interface input data source configuration information.
In embodiments of the present invention, when the data source configuration information of the data to be exported that receives user input, adopt profile store data source configuration information, and the configuration file that will store the data source configuration information is sent to service server.Service server reads this configuration file, and connects the data source of data source configuration information sign.Service server is meant computer system or the software systems that business service is provided in the network in embodiments of the present invention, and client is meant the computer system or the software systems of the service of accepting business.
In step S202, draw logic according to default data and from the data source of data source configuration information sign, obtain data, and the data obtained of assembly unit.
In embodiments of the present invention, according to data source configuration information and data filter condition, foundation is connected with data source, to obtain data from data source.By circulation, collect data according to filtercondition, and the data " stream " of collecting are changed, send client to.
In step S203, the data stream that assembly unit is good writes the data file of XML form, and the data file of XML form is stored to the store path of data source configuration information sign.
In another embodiment of the present invention, after step S203, this method also comprises the steps:
In step S204, receive the data file modifications instruction of user's input, the data file of the XML form of deriving is carried out the retouching operation of this data file modifications instruction appointment.
Fig. 4 shows the realization flow in the target data source that the data file with the XML form that the embodiment of the invention provides imports single-node login system, and details are as follows:
In step S401, receive the data file and the target data source information of the XML form to be imported of user's input.
Wherein the target data source packet is drawn together but is not limited to target data source, resource link address, resource connection type etc.Wherein target data source is meant the data source of the data file that needs importing XML form.The resource link address is meant the link address of the data source of the data file that needs importing XML form.The resource connection type is meant the type of the data source of the data file that needs importing XML form, includes but not limited to type of database, field type and data file class.
In embodiments of the present invention, when the data file of the XML form of selecting as the user to be imported is excessive, communicate and reduce the performance of single-node login system for fear of too much between service server and the client, in another embodiment of the present invention, after the data file that receives the XML form to be imported that the user selects, the data file of the XML form that receives is uploaded to service server.During specific implementation, can be provided for importing the human-computer interaction interface of data, so that the user selects the data file of XML form to be imported by this human-computer interaction interface for the user.Seeing also Fig. 5, is the synoptic diagram of human-computer interaction interface that is used to import data to user output that the embodiment of the invention provides, and the user selects the data file of XML form to be imported by this human-computer interaction interface.Its detailed process is as follows:
The accessory module of use original system carries out annex to be uploaded, and the user selects by file in system, gets access to the local path of file in client, selects to upload, and the client business procedure is changed file " stream " according to absolute path, obtains data stream.Data stream uploaded in batches enter service server annex business procedure, service server deposits the data stream of uploading in database or deposits in the file that enters service server.
In step S402, read the data file of the XML form that is uploaded to service server and resolve.In embodiments of the present invention, can adopt the data file of this XML form of resolver resolves of existing XML formatted data file, not repeat them here.
In step S403, in the target data source of the data file importing target data source message identification of the XML form after will resolving according to default integrated logic.
Fig. 6 shows the structure of the data importing let-off gear(stand) that the embodiment of the invention provides, and for convenience of explanation, only shows the part relevant with the embodiment of the invention.This data importing let-off gear(stand) can be to be built in the unit that software unit, hardware cell or software and hardware in the single-node login system combine, and perhaps is integrated in the application system of single-node login system or single-node login system as suspension member independently.Wherein:
Data lead-out unit 1 is derived data from the source of reference data of single-node login system, and derived data is stored as the data file of XML form.This data lead-out unit 1 comprises the first resource resolver 11, first integrated manipulator 12 and the first data file controller 13.Wherein:
The first resource resolver 11 receives the data source configuration information of the data to be exported of user's input, and connects data source according to the data source configuration information.
Wherein the data source configuration information comprises but is not limited to store path of source of reference data, resource link address, resource connection type, derived data etc.Wherein source of reference data is meant the data source of the data that need derivation.The resource link address is meant the link address of the data source that needs derivation.The resource connection type is meant the type of the data source that needs derivation, includes but not limited to type of database, field type and data file class.In embodiments of the present invention, when the resource connection type was type of database, this data source configuration information also comprised port, resource items login username, resource items login password etc.; When the resource connection type was field type, this data source configuration information also comprised port, resource items login username, resource items login password, connects proprietary name etc.; When the resource connection type was data file class, this data source configuration information also comprised the absolute path of data file client.Wherein connect proprietary name and refer in particular to absolute path in the territory.
First integrated manipulator 12 is drawn logic according to default data and obtain data from the data source of data source configuration information sign, and the data obtained of assembly unit.
The first data file controller 13 writes the data file of XML form with the good data stream of first integrated manipulator, 12 assembly units, and the data file of XML form is stored to the store path of data source configuration information sign.
For the user is made amendment to the data that derive voluntarily, in another embodiment of the present invention, this data let-off gear(stand) also comprises data file modifications module 14.This data file modifications module 14 receives the data file modifications instruction of users' input, the data file of the XML form of deriving is carried out the retouching operation of this data file modifications instruction appointment.
The second resource resolver 21 receives the data file and the target data source information of the XML form to be imported of user's selection, and the data file that receives is uploaded to service server.
Wherein the target data source packet is drawn together but is not limited to target data source, resource link address, resource connection type etc.Wherein target data source is meant the data source of the data file that needs importing XML form.The resource link address is meant the link address of the data source of the data file that needs importing XML form.The resource connection type is meant the type of the data source of the data file that needs importing XML form, includes but not limited to type of database, field type and data file class.
The second data file controller 23 read the second resource resolver 21 be uploaded to service server the XML form data file and resolve.In embodiments of the present invention, can adopt the data file of this XML form of resolver resolves of existing XML formatted data file, not repeat them here.
The data file of the XML form after second integrated manipulator 22 is resolved the second data file controller 23 according to default integrated logic imports in the target data source of target data source message identification.
In embodiments of the present invention, during data in integrated each operation system of single-node login system, data file by adopting the XML form is carried out data transfer between the source of reference data of single-node login system and target data source, thereby shielded the isomery of DMBS between source of reference data and the target data source and the isomery of procotol, be convenient in the single-node login system source of reference data and target data source and carry out data importing and derivation mutually.
The above only is preferred embodiment of the present invention, not in order to restriction the present invention, all any modifications of being done within the spirit and principles in the present invention, is equal to and replaces and improvement etc., all should be included within protection scope of the present invention.
Claims (11)
1, the data importing deriving method in a kind of single-node login system is characterized in that, described method comprises the steps:
Derived data from the source of reference data of single-node login system, and derived data is stored as the data file of XML form;
The data file of described XML form is imported in the target data source of single-node login system.
2, the method for claim 1 is characterized in that, described from the source of reference data of single-node login system derived data, and the step that derived data is stored as the data file of XML form is specially:
Receive the data source configuration information of the data to be exported of user's input, and connect data source according to the data source configuration information;
Draw logic according to default data and from the data source of data source configuration information sign, obtain data, and the data obtained of assembly unit;
The data stream that assembly unit is good writes the data file of XML form, and the data file of XML form is stored to the store path of data source configuration information sign.
3, method as claimed in claim 2, it is characterized in that, described data source configuration information comprises the store path of data source, resource link address, resource connection type, derived data, perhaps also comprises in connection proprietary name, port, resource items login username, the resource items login password one or more.
4, as claim 2 or 3 described methods, it is characterized in that, write the data file of XML form in the described data stream that assembly unit is good, and the data file of XML form is stored to after the step of store path of data source configuration information sign, described method also comprises:
Receive the data file modifications instruction of user's input, the data file of the XML form of deriving is carried out the retouching operation of described data file modifications instruction appointment.
5, the method for claim 1 is characterized in that, the step that described data file with described XML form imports in the target data source of single-node login system is specially:
Receive the data file of the XML form to be imported of user's selection;
Read the data file of described XML form to be imported and resolve;
Import the data file of described XML form to be imported according to default integrated logic.
6, method as claimed in claim 5 is characterized in that, after the data file that receives the XML form to be imported that the user selects, the data file of described XML form is uploaded to service server.
7, a kind of data importing let-off gear(stand) is characterized in that, described device comprises:
The data lead-out unit is used for the source of reference data derived data from single-node login system, and derived data is stored as the data file of XML form;
The data importing unit is used for the target data source with the data file importing single-node login system of XML form.
8, device as claimed in claim 7 is characterized in that, described data lead-out unit comprises:
The first resource resolver is used to receive the data source configuration information of the data to be exported of user's input, and connects data source according to the data source configuration information;
First integrated manipulator is used for drawing logic according to default data and obtains data from the data source of data source configuration information sign, and the data obtained of assembly unit;
The first data file controller is used for the data file that the data stream that assembly unit is good writes the XML form, and the data file of XML form is stored to the store path of data source configuration information sign.
9, device as claimed in claim 8 is characterized in that, described data lead-out unit also comprises:
The data file modifications module is used to receive the data file modifications instruction of user's input, the data file of the XML form of deriving is carried out the retouching operation of described data file modifications instruction appointment.
10, device as claimed in claim 7 is characterized in that, described data importing unit comprises:
The second resource resolver is used to receive the data file of the XML form to be imported that the user selects;
The second data file controller is used to read the data file of the XML form that is uploaded to service server and resolves;
Second integrated manipulator is used for the data file according to default integrated logic importing XML form.
11, a kind of single-node login system is characterized in that, described system comprises the described data importing let-off gear(stand) of the arbitrary claim of claim 7 to 10.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910189794A CN101655873A (en) | 2009-08-28 | 2009-08-28 | Single sign-on system as well as method and device for inputting and outputting data thereof |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910189794A CN101655873A (en) | 2009-08-28 | 2009-08-28 | Single sign-on system as well as method and device for inputting and outputting data thereof |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101655873A true CN101655873A (en) | 2010-02-24 |
Family
ID=41710164
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN200910189794A Pending CN101655873A (en) | 2009-08-28 | 2009-08-28 | Single sign-on system as well as method and device for inputting and outputting data thereof |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101655873A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102426579A (en) * | 2011-08-25 | 2012-04-25 | 中兴通讯股份有限公司 | Web mode-based method for importing/exporting file |
CN103532986A (en) * | 2013-11-01 | 2014-01-22 | 深圳中兴网信科技有限公司 | Terminal as well as server and file transmission system and method |
CN106991100A (en) * | 2016-01-21 | 2017-07-28 | 北京京东尚科信息技术有限公司 | Data lead-in method and device |
CN109947789A (en) * | 2019-01-28 | 2019-06-28 | 平安科技(深圳)有限公司 | A kind of method, apparatus, computer equipment and the storage medium of the data processing of multiple database |
-
2009
- 2009-08-28 CN CN200910189794A patent/CN101655873A/en active Pending
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102426579A (en) * | 2011-08-25 | 2012-04-25 | 中兴通讯股份有限公司 | Web mode-based method for importing/exporting file |
WO2012155621A1 (en) * | 2011-08-25 | 2012-11-22 | 中兴通讯股份有限公司 | Method for importing and exporting file based on web |
CN103532986A (en) * | 2013-11-01 | 2014-01-22 | 深圳中兴网信科技有限公司 | Terminal as well as server and file transmission system and method |
CN106991100A (en) * | 2016-01-21 | 2017-07-28 | 北京京东尚科信息技术有限公司 | Data lead-in method and device |
CN106991100B (en) * | 2016-01-21 | 2021-10-01 | 北京京东尚科信息技术有限公司 | Data import method and device |
CN109947789A (en) * | 2019-01-28 | 2019-06-28 | 平安科技(深圳)有限公司 | A kind of method, apparatus, computer equipment and the storage medium of the data processing of multiple database |
CN109947789B (en) * | 2019-01-28 | 2023-12-19 | 平安科技(深圳)有限公司 | Method, device, computer equipment and storage medium for processing data of multiple databases |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11062796B2 (en) | Multimode mobile electronic medical record system and working method thereof | |
CN103559217B (en) | A kind of massive multicast data towards isomeric data storehouse warehouse-in implementation method | |
CN110457256A (en) | Date storage method, device, computer equipment and storage medium | |
CN102053813B (en) | Splicing wall control method and device | |
CN104699718A (en) | Method and device for rapidly introducing business data | |
CN107480252A (en) | A kind of data query method, client, service end and system | |
CN106997418A (en) | A kind of method and system of long-distance transmissions medical image | |
CN110502491A (en) | A kind of Log Collect System and its data transmission method, device | |
CN105930417B (en) | A kind of big data ETL interactive process platform based on cloud computing | |
CN102438278A (en) | Load allocation method and device for mobile communication network | |
CN103618733A (en) | Data filtering system and method applied to mobile internet | |
CN101609415A (en) | Universal service calling system and method based on middleware | |
US20200204688A1 (en) | Picture book sharing method and apparatus and system using the same | |
CN101655873A (en) | Single sign-on system as well as method and device for inputting and outputting data thereof | |
CN106547911A (en) | A kind of access method and system of mass small documents | |
CN113381866A (en) | Service calling method, device, equipment and storage medium based on gateway | |
CN104601554A (en) | Data exchange method and device | |
CN105656643B (en) | Method and equipment for performing compatible management based on network configuration protocol | |
CN102404356B (en) | Long-distance function call transmission adapter and data reading method thereof | |
CN212935927U (en) | Internet of things gateway with embedded database | |
CN108768727A (en) | Access method, electronic device and the readable storage medium storing program for executing of third party's service | |
CN113626438B (en) | Data table management method, device, computer equipment and storage medium | |
CN113961146A (en) | Contract management system based on cloud signing | |
CN109033447B (en) | Face recognition data visualization system | |
CN107357853A (en) | A kind of operating method, device and the computer system of REDIS consoles |
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: 20100224 |