CN103414705B - A kind of mobile internet heterogeneous database exchange method based on SAAS pattern - Google Patents
A kind of mobile internet heterogeneous database exchange method based on SAAS pattern Download PDFInfo
- Publication number
- CN103414705B CN103414705B CN201310325953.0A CN201310325953A CN103414705B CN 103414705 B CN103414705 B CN 103414705B CN 201310325953 A CN201310325953 A CN 201310325953A CN 103414705 B CN103414705 B CN 103414705B
- Authority
- CN
- China
- Prior art keywords
- data
- tenant
- terminal
- data type
- interchange platform
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Abstract
The invention discloses a kind of mobile internet heterogeneous database exchange method based on SAAS pattern, relate to the communications field, comprise the following steps: information is sent to data interchange platform by mobile Internet by the mobile terminal A of transmit leg, data interchange platform uses a kind of standard data type for intermediary, first convert the data type A of transmit leg to standard data type, the data type B that the mobile terminal B again standard data type being converted to recipient can identify, finally sends to the mobile terminal B of recipient by mobile Internet by data type B.By the present invention, the user of use mobile device can conveniently by the swapping data of mobile internet at isomery mobile device.
Description
Technical field
The present invention relates to the communications field, particularly relate to a kind of mobile internet heterogeneous database exchange method based on SAAS pattern.
Background technology
Along with information network technique ground is fast-developing, network technology is constantly weeded out the old and bring forth the new, and ceaselessly changes the life style of people.The software that is meant to of SAAS (Software-as-a-Service) is namely served, and is the software application pattern providing software service based on the Internet.The core of SAAS can provide software service online; It can save the high cost that user's configuration server, purchase software product etc. will pay, and need not carry out software upgrading and follow-up input again as application package.
SAAS service provider builds all-network infrastructure required for informationization and software, hardware running platform for enterprise, and be responsible for a series of service such as the enforcement in all early stages, the maintenance in later stage, enterprise is without the need to buying software and hardware, building machine room etc., only in earlier stage need pay disposable project implementation expense and regular software rental service expense, namely enjoy information system by the Internet.Service provider, by effective technical measures, can ensure fail safe and the confidentiality of every business data.Enterprise adopt SAAS service mode in effect with enterprise self-built information system substantially as broad as long, but save the fund of technology and maintenance operation, thus considerably reduce threshold and the risk of IT application in enterprises.
Mobile Internet is the product that mobile communication and the Internet combine.The network terminal to be coupled together formation by the communication line such as telephone wire, optical fiber by conventional internet.Because need circuit, so terminal cannot move or mobile range is very little, be generally confined to indoor, thus network can regard fixing as.And the mobile terminals such as mobile phone are connected by wireless signal, without the restriction of circuit, mobile terminal can move everywhere, and they just constitute mobile Internet.Mobile Internet is convenience like this, makes it constantly accelerate to every profession and trade, the infiltration of each field in recent years, merge, not only improves the living standard of people, also drive conventional industries transition and upgrade, inject new vitality to all trades and professions.
Internet of Things is the nearly 2 years new ideas proposed, its definition is by radio-frequency (RF) identification (RadioFrequencyIdentification, RFID), the information sensing equipment such as infrared inductor, global positioning system, laser scanner, by the agreement of agreement, any article are connected with the Internet, carry out information exchange and communicate, to realize a kind of network of Weigh sensor to article, location, tracking, monitor and managment.This has the two-layer meaning: the first, and core and the basis of Internet of Things remain the Internet, is the network of extension on Internet basic and expansion; The second, its user side extends and extend between any article and article, carries out information exchange and communicates.As can be seen here, Internet of Things is the inevitable outcome of the Internet and mobile Internet development.
In the Internet, propagate and sharing information, must communicate between terminal, surely can cause exchanges data thus.In the conventional internet taking computer as terminal, between terminal, the problem of exchanges data is little, because there is various software can process many dissimilar data in computer.But when the network terminal changes various different mobile device into, the problem that inter-terminal data exchanges will be very outstanding.The data type that different equipment use is different and data format, even same equipment, manufacturer is different, and the data type of use is also different.The information that mobile terminal None-identified uses the other-end different from the data type of oneself to send.Communication between heterogeneous device does not freely seriously constrain the development of mobile Internet and Internet of Things.
Summary of the invention
The object of this invention is to provide a kind of mobile internet heterogeneous database exchange method based on SAAS pattern, utilize the mutual conversion that the method can realize between isomeric data type, thus the problem that solution isomeric data cannot exchange, make communicate smoothly between various types of terminal in mobile network.
For achieving the above object, take following technical scheme: a kind of mobile internet heterogeneous database exchange method based on SAAS pattern, comprise the following steps: information is sent to data interchange platform by mobile Internet by the mobile terminal A of transmit leg, data interchange platform uses a kind of standard data type for intermediary, first convert the data type A of transmit leg to standard data type, the data type B that the mobile terminal B again standard data type being converted to recipient can identify, finally data type B is sent to the mobile terminal B of recipient by mobile Internet.
Preferably: mount message administration module in the terminal, mobile terminal is sent the discernible data format of data interchange platform by information management module or receives the data format after being changed by data interchange platform.
Preferably: each tenant for data interchange platform creates a schema, the exclusive user ID of tenant and device id is stored in each schema, set up public sheet collection simultaneously, and in the map information table that public sheet concentrates storage tenant ID and tenant to be correlated with, associated with tenant by the terminal equipment of map information table by access data switching plane.
Preferably: data interchange platform receives data exchange request and after obtaining the device id of transmitting terminal and receiving terminal, uses Sherwood algorithm to search match information in the terminal.
Preferably: the subsequent step of step 4 is: if there is not matched termination equipment, then return corresponding error message; If existed, the terminal equipment concentrated by public sheet and tenant's relation mapping table obtain transmitting terminal and receiving device tenant ID further, and compare; If two terminal equipments do not belong to same tenant, do not allow swap data, and return error message; Otherwise by the mapping relations between tenant and schema, determine concrete schema.
Preferably: by the schema name of the receiving terminal apparatus ID that obtains and tenant, it can be used as parameter call storing process, obtain the data format that receiving terminal apparatus is supported.
Beneficial effect of the present invention is as follows: utilize the mutual conversion that the method can realize between isomeric data type, thus solves the problem that isomeric data cannot exchange, and makes communicate smoothly between various types of terminal in mobile network.The tenant of data interchange platform can obtain data exchange service easily, flexibly customized service time, without the need to building and service data switching plane, reduces use cost.The data interchange platform of SAAS pattern makes platform software and hardware can be multiplexing, improves resource utilization.Exchanges data based on standard data structure is simple and convenient, and autgmentability is strong, only need change the replacing that data exchange middleware module can realize normal data, convenient upgrading.
Accompanying drawing explanation
Fig. 1 is data exchange process schematic diagram;
Fig. 2 is data transaction schematic diagram.
Embodiment
Data interchange platform of the present invention is the platform software write by JAVA, is applicable to various server platform, and uses SAAS pattern, is once disposed by operator, and be responsible for maintenance, software user rents the data exchange service of platform with Lease way.
Described data interchange platform is prior art, comprises with lower module:
Information management module: for receiving, processing and send the information of described data interchange platform.
User management module: for managing the user profile in described data interchange platform, user's associative operations such as comprise user's registration, user profile is inquired about, and deletes user, amendment user profile.
Device management module: be responsible for the maintenance of information of mobile terminal device using described data interchange platform, comprise the storage of facility information, delete, search, the equipment associative operation such as amendment.
Design of exchange middleware administration module: for managing the design of exchange middleware in described data interchange platform, comprise increase, deletion, data query conversion middleware, the design of exchange middleware calling coupling carries out the conversion of specific data type.
Database: the data needed for storage platform operation.
There is provided service with SaaS pattern: use the user of described data interchange platform without the need to setting for this platform, the various hardware devices needed for maintenance platform runs, these work are completed by platform operation business.Platform operation business in the form of services to the use of user's open platform, after user only need register, just can the data exchanging function that provides of usage platform.
Based under many tenants system of SAAS, need the difference distinguishing user and tenant.
We are set as follows scene, enterprise A, in order to solve the exchanges data problem between employee's different terminals, establishes a data interchange platform, and employee is the user of the data interchange platform of enterprise A, data interchange platform is by enterprise A operation maintenance, and this is non-multi tenant scene.Enterprise B has also built an identical data interchange platform afterwards.Problem has just been come, and two data interchange platform functions are identical, can only substitute with a data interchange platform? many tenants system addresses this problem.In many tenants system, enterprise A before and enterprise B, without the need to building and safeguard the data interchange platform of oneself, are built by data interchange platform operator and are safeguarded.Enterprise A and enterprise B rent the data exchange service that platform operation business provides, and here, enterprise A and enterprise B are tenants, and the employee in Liang Ge enterprise is user.
The problem of tenant's isolation is there is under many tenants system, because multiple tenant uses a platform, suppose the terminal that there is same type in two multiple tenants, if do not carry out tenant's isolation, which should so information send to? the mode that the present invention is cut by prior art database isolates tenant data, and detailed process is as follows:
In a database, for each registration tenant creates a schema, a schema is exactly the set of database table, view.The user profile of each tenant and terminal device information etc. all leave in respective schema, for tenant and schema set up mapping relations.In order to by request identification terminal tenant, need the public sheet collection that tenant has nothing to do and deposit tenant's information and some mapping relations tables.Public sheet collection should at least comprise tenant's information table, terminal equipment ID and tenant ID mapping relations table.Wherein, all terminal equipment ID of all tenants and the ID of tenant thereof in store data switching plane in terminal equipment ID and tenant ID mapping relations table.
Below by a data exchange process, specific embodiment of the invention step is described.
A kind of mobile internet heterogeneous database exchange method based on SAAS pattern, comprise the following steps: information is sent to data interchange platform by mobile Internet by the mobile terminal A of transmit leg, data interchange platform uses a kind of standard data type for intermediary, first convert the data type A of transmit leg to standard data type, the data type B that the mobile terminal B again standard data type being converted to recipient can identify, finally sends to the mobile terminal B of recipient by mobile Internet by data type B.
Step by step and specific embodiment as follows:
S1. user is by end message administration module, and input receiving equipment information, send data message, information is sent to data interchange platform by the Internet by end message administration module.Such as certain user needs the address list in mobile phone to send to another user, and user arranges the identifying information of receiving equipment in end message administration module, can be unique EIC equipment identification code, also can be the possessory user name of equipment, tenant's name oil (gas) filling device name.Need the data format arranging address list, such as, be CSV simultaneously.After setting, user selects to send address list, and transmitting terminal and receiving device information and data message are sent to data interchange platform by end message administration module.
S2. the listening port of data interchange platform receives data exchange request, according to predefined request format, obtains the data message of receiving equipment information and needs exchange.As adopted JSON formal definition, can { senddev:1234567, revdev:7654321, datatype:csv}.Data interchange platform can parse information needed by JSON Reading and writing instrument easily from the data of JSON form.
S3. after obtaining transmitting terminal and receiving device information, search terminal equipment in a database by facility information, due to the terminal equipment One's name is legion of access platform, use common traversal search performance excessively poor, here prior art Sherwood algorithm is adopted to carry out fast finding, specific as follows:
Sherwood algorithm is the one of probabilistic algorithm, and its basic thought is: establish A to be a deterministic algorithm, the computing time required when its input example is x is designated as t
a(x).If the input size that Xn is algorithm A is the entirety of the example of n, then when the input size of problem is n, the average time needed for algorithm A is:
this obviously can not get rid of and there is x ∈ Xn and make
possibility.Therefore wish acquisition probabilistic algorithm B, each example to the input size of problem is n all had:
In practice, by the major key in terminal device information table stored in array, during retrieval, Sherwood algorithm is used to search matched termination equipment to major key array.
If there is not matched termination equipment, return corresponding error message.If existed, the terminal equipment concentrated by public sheet and tenant's relation mapping table obtain transmitting terminal and receiving device tenant ID further, and compare.If two equipment do not belong to same tenant, do not allow swap data, return error message.Otherwise by the mapping relations between tenant and schema, determine concrete schema.Mapping relations simply can be set to the title that tenant ID is schema.If tenant ID is tenent1, corresponding schema is called tenent1.
S4. by the schema name of the receiving terminal apparatus ID that obtains and tenant, it can be used as parameter call storing process, obtain the data format that receiving terminal apparatus is supported.Under many tenants system, list structure in each tenant schema is identical, and content is different, and the sql statement being searched the data format that terminal equipment is supported by terminal equipment ID is basically identical, but the schema belonging to table is different, need add that schema name is distinguished before the table name in sql statement.Storing process is used can dynamically to determine schema name before sql statement performs.
S5. data transaction is carried out.By the unified data format of data interchange platform as intermediary, by twice conversion, be receiving terminal data format by transmitting terminal Data Format Transform, as shown in Figure 2.Call related converting method by design of exchange middleware according to data type in practice and complete conversion.Detailed process is as follows: establish transmitting terminal to need to send the address list of CSV form, the address list form of excel supported by receiving terminal, and the unified XML that uses of data interchange platform is as standard data type.Maintain in design of exchange middleware DataExchange class and have two mapping sets, as Map, be respectively general data type to the conversion method mapping set toxml of standard data type and standard data type to the conversion method mapping set xmlto of general data type.First search by toxml the method that CSV turns XML, CSV address list is changed into XML address list, more in like manner XML is changed into excel address list.
After converting, according to the receiving terminal information found before, excel address list is sent to receiving terminal, received by the end message administration module of receiving terminal and pointed out user.
Wherein, the data represented with described standard data type can convert other all data types that described data interchange platform is supported to, otherwise, can also standard data type be converted to the data of the data types to express of data interchange platform support described in any one.
Claims (2)
1. the mobile internet heterogeneous database exchange method based on SAAS pattern, it is characterized in that: comprise the following steps: information is sent to data interchange platform by mobile Internet by the mobile terminal A of transmit leg, data interchange platform uses a kind of standard data type for intermediary, first convert the data type A of transmit leg to standard data type, the data type B that the mobile terminal B again standard data type being converted to recipient can identify, finally sends to the mobile terminal B of recipient by mobile Internet by data type B;
Described data interchange platform is that each tenant of data interchange platform creates a schema, the exclusive user ID of tenant and device id is stored in each schema, set up public sheet collection simultaneously, and in the map information table that public sheet concentrates storage tenant ID and tenant to be correlated with, associated with tenant by the terminal equipment of map information table by access data switching plane;
Data interchange platform receives data exchange request and after obtaining the device id of transmitting terminal and receiving terminal, uses Sherwood algorithm to search match information in the terminal; If there is not matched termination equipment, then return corresponding error message; If existed, the terminal equipment concentrated by public sheet and tenant's relation mapping table obtain transmitting terminal and receiving device tenant ID further, and compare; If two terminal equipments do not belong to same tenant, do not allow swap data, and return error message; Otherwise by the mapping relations between tenant and schema, determine concrete schema;
By the schema name of the receiving terminal apparatus ID that obtains and tenant, it can be used as parameter call storing process, obtain the data format that receiving terminal apparatus is supported.
2. a kind of mobile internet heterogeneous database exchange method based on SAAS pattern according to claim 1, it is characterized in that: mount message administration module in the terminal, mobile terminal is sent the discernible data type of data interchange platform by information management module or receives the data type after being changed by data interchange platform.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310325953.0A CN103414705B (en) | 2013-07-30 | 2013-07-30 | A kind of mobile internet heterogeneous database exchange method based on SAAS pattern |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310325953.0A CN103414705B (en) | 2013-07-30 | 2013-07-30 | A kind of mobile internet heterogeneous database exchange method based on SAAS pattern |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103414705A CN103414705A (en) | 2013-11-27 |
| CN103414705B true CN103414705B (en) | 2016-03-02 |
Family
ID=49607691
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310325953.0A Active CN103414705B (en) | 2013-07-30 | 2013-07-30 | A kind of mobile internet heterogeneous database exchange method based on SAAS pattern |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103414705B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106055582B (en) * | 2016-05-20 | 2019-09-24 | 中国农业银行股份有限公司 | A kind of method and device of the table name in replacement data library |
| CN107172173A (en) * | 2017-06-01 | 2017-09-15 | 智象互联（厦门）科技有限公司 | The mobile Internet platform data sharing method and device of a kind of SAAS patterns |
| CN108920702A (en) * | 2018-07-18 | 2018-11-30 | 四川师范大学 | Realize that heterogeneous database synchronizes the online method exchanged and share |
| CN110061872B (en) * | 2019-04-12 | 2021-07-16 | 武汉理工大学 | Data exchange platform management system based on Internet of things |
| CN111464349A (en) * | 2020-03-30 | 2020-07-28 | 南京中诚区块链研究院有限公司 | Mixed consensus network algorithm and system of block chain Raft + PBFT |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101977164A (en) * | 2010-11-04 | 2011-02-16 | 杭州世导通讯有限公司 | Data interactive method and system in SaaS mode |
| CN102413135A (en) * | 2011-11-17 | 2012-04-11 | 成都康赛电子科大信息技术有限责任公司 | Strong expansion network grid SaaS access control method |
| CN103164206A (en) * | 2011-12-16 | 2013-06-19 | 上海博腾信息科技有限公司 | Software customization system based on software as a service (SAAS) |
| CN103176988A (en) * | 2011-12-21 | 2013-06-26 | 上海博腾信息科技有限公司 | Data migration system based on software-as-a-service (SaaS) |
-
2013
- 2013-07-30 CN CN201310325953.0A patent/CN103414705B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101977164A (en) * | 2010-11-04 | 2011-02-16 | 杭州世导通讯有限公司 | Data interactive method and system in SaaS mode |
| CN102413135A (en) * | 2011-11-17 | 2012-04-11 | 成都康赛电子科大信息技术有限责任公司 | Strong expansion network grid SaaS access control method |
| CN103164206A (en) * | 2011-12-16 | 2013-06-19 | 上海博腾信息科技有限公司 | Software customization system based on software as a service (SAAS) |
| CN103176988A (en) * | 2011-12-21 | 2013-06-26 | 上海博腾信息科技有限公司 | Data migration system based on software-as-a-service (SaaS) |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103414705A (en) | 2013-11-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103414705B (en) | A kind of mobile internet heterogeneous database exchange method based on SAAS pattern | |
| CN104125208B (en) | Data transmission method and device | |
| CN103763443B (en) | The mobile customer service system of a kind of many communication modes polymerization and method | |
| CN103927633A (en) | Thing information traceability system and method with relevance perception | |
| US20160253388A1 (en) | Method and Apparatus for Sharing Environment Context | |
| CN202178786U (en) | Data sharing service system based on internet of things | |
| CN104484958A (en) | Express delivery pickup method and system for intelligent express delivery cabinet | |
| CN106326243A (en) | Data processing method and apparatus | |
| CN103617583A (en) | Method and equipment for processing data of service provider | |
| WO2015172497A1 (en) | Message pushing and acquisition methods and devices, and computer readable storage medium | |
| US20070129049A1 (en) | System and gateway system for managing phone numbers and user IDs | |
| CN113396560B (en) | Method and device for establishing optical cable connection | |
| CN103067618A (en) | Caller identification method and caller identification system | |
| CN102103606A (en) | Technology for realizing advanced search of commodities on mobile phone client | |
| CN103455780B (en) | Be adapted to article mark recognition methods, device and the system of many application | |
| CN103729455B (en) | Master data storage method based on primary copy storage pattern | |
| CN112905600A (en) | Data query method and device, storage medium and electronic equipment | |
| CN110059091A (en) | Method, apparatus, client, server and the system of index construct | |
| CN115277707A (en) | Service processing method, device, electronic equipment and storage medium | |
| CN106506687A (en) | A kind of information processing method and system | |
| CN105468752B (en) | A kind of data product building system | |
| CN104572649B (en) | The processing method of the data of distributed memory system, apparatus and system | |
| KR20210033605A (en) | Integrated supply chain management system between fashion designers and manufacturers | |
| CN111008220A (en) | Dynamic identification method and device of data source, storage medium and electronic device | |
| KR20160113397A (en) | System for Interworking RFID based DDS in Internet of Things and Method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |