CN106484874A - A kind of method by unified for software platform bottom isomeric data encapsulation and system - Google Patents

A kind of method by unified for software platform bottom isomeric data encapsulation and system Download PDF

Info

Publication number
CN106484874A
CN106484874A CN201610892071.6A CN201610892071A CN106484874A CN 106484874 A CN106484874 A CN 106484874A CN 201610892071 A CN201610892071 A CN 201610892071A CN 106484874 A CN106484874 A CN 106484874A
Authority
CN
China
Prior art keywords
data
unified
software platform
platform bottom
semantic
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
Application number
CN201610892071.6A
Other languages
Chinese (zh)
Inventor
王承浩
黄荣辉
林成龙
梁煜
范强
李清河
郭碧莲
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujian Xinghai Communication Technology Co Ltd
Original Assignee
Fujian Xinghai Communication Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Fujian Xinghai Communication Technology Co Ltd filed Critical Fujian Xinghai Communication Technology Co Ltd
Priority to CN201610892071.6A priority Critical patent/CN106484874A/en
Publication of CN106484874A publication Critical patent/CN106484874A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention provides a kind of method by unified for software platform bottom isomeric data encapsulation, intermediary's storehouse receive user inquiry request data;According to semantic base, inquiry request data is converted;Wrapper is inquired about according to the inquiry request data of conversion, obtains Query Result;According to semantic base, query structure is converted into the inquiry data of prescribed form;The present invention also provides a kind of system by unified for software platform bottom isomeric data encapsulation;Greatly reduce the complexity of upper layer application exploitation so that upper layer application can only focus on the realization of service logic, and the data structure without care bottom.

Description

A kind of method by unified for software platform bottom isomeric data encapsulation and system
Technical field
The present invention relates to a kind of method by unified for software platform bottom isomeric data encapsulation and system.
Background technology
The isomerism of data is mainly reflected in this four aspects of system isomery, structural isomerism, syntactic metacharacter and Semantic Heterogeneous, Many technology are exploited for solving these different types of Heterogeneities.CORBA, DCOM, RMI and federated database, void Intend database technology and method can solve the problem that first three Heterogeneity, especially XML is extensive as public language standard After use, the general syntax format being had by him is with standard so that people can be entered using unified data model The exchange of row information, efficiently solves a difficult problem for data exchange in data integration.
Because the different type of service of large software platform, data type frequently involve using different data storage sides Case, by way of packaging bottom layer isomeric data operates as unified data access middleware, industry under distributed developing environment Business logical layer does not need to be concerned about data storage method and the access mode of bottom, only need to pay close attention to the realization of service logic, it then follows The interface standard interacting with middleware, it is possible to easily carry out data interaction with various heterogeneous databases, greatly improves soft Part development efficiency, and systematic function is got a promotion further.Because each heterogeneous system or heterogeneous data source were originally During constructing system, it is all based on the semanteme of itself to carry out each self-defined of concept, logic etc., so semantically and differ Cause.
Term explanation:
Heterogeneous database:Heterogeneous database is the set of related multiple Database Systems, it is possible to achieve data shared And transparent access, each Database Systems had inherently existed before adding heterogeneous database system, had oneself DBMS.Each ingredient of heterogeneous database has the autonomy of itself, while realizing data sharing, each data base set System is still possessed application characteristic, integrity control and the safety of oneself and is controlled.
System isomery:Isomery on finger operating system, hardware.
Structural isomerism:Refer to data structure difference, for example structurized SQLServer and semi-structured XML data.
Syntactic metacharacter:Refer to different language data expression-forms.
Semantic Heterogeneous:Including conceptual level Semantic Heterogeneous value preset level Semantic Heterogeneous.Conceptual level Semantic Heterogeneous refer to different information Source represents the identical concept using multiple terms, and different implications expressed in different information sources in same term;Value level semanteme is different Structure mainly due to there are various contacts between the concept in each information source, but due to the Distributed Autonomous between each information source Property, this implicit relation can not embody.
Federated database:Federated database is made up of half autonomous data storehouse system, shared data each other, each data source Between access interface is provided mutually.Federated database can be centralized data base or distributed data base or other Federated Database.
XML language:XML (Extensible Markup Language, extensible markup language) is W3C (World Wide Web Consortium) simplified subset of SGML issued in definition in 1998 is a kind of normalized permissible The text formatting of structured message is represented on Web.
Content of the invention
The technical problem to be solved in the present invention, is to provide a kind of side by unified for software platform bottom isomeric data encapsulation Method and system, the complexity greatly reducing upper layer application exploitation is so that upper layer application can only focus on the reality of service logic Existing, and the data structure without care bottom.
One of present invention is realized in:A kind of method by unified for software platform bottom isomeric data encapsulation, data Storehouse middleware includes intermediary device, wrapper and semantic base;Comprise the steps:
Step 1, intermediary's storehouse receive user inquiry request data;
Step 2, according to semantic base, inquiry request data is converted;
Step 3, wrapper are inquired about according to the inquiry request data of conversion, obtain Query Result;
Step 4, according to semantic base, query structure is converted into the inquiry data of prescribed form.
Further, also include step 5, intermediary device to be processed inquiring about data, synthesized and removed redundancy, it After return to user.
Further, described semantic base sets up process:Extract data pattern from bottom data source, each based on different data sources From data pattern, set up respective local semantic;All of local semanteme is merged into an overall semanteme, is formed semantic Storehouse.
Further, described data pattern includes:ER figure is extracted from structural data, and from semi-structured data In extract XML schema.
The two of the present invention are realized in:A kind of system by unified for software platform bottom isomeric data encapsulation, data Storehouse middleware includes intermediary device, wrapper and semantic base;Including such as lower module:
Receiver module, intermediary's storehouse receive user inquiry request data;
Inquiry request data is converted by conversion module according to semantic base;
Enquiry module, wrapper is inquired about according to the inquiry request data of conversion, obtains Query Result;
Obtain object module, according to semantic base, query structure is converted into the inquiry data of prescribed form.
Further, also include returning module, intermediary device is processed, synthesized and removed redundancy letter by inquiring about data Breath, returns to user afterwards.
Further, described semantic base sets up process:Extract data pattern from bottom data source, each based on different data sources From data pattern, set up respective local semantic;All of local semanteme is merged into an overall semanteme, is formed semantic Storehouse.
Further, described data pattern includes:ER figure is extracted from structural data, and from semi-structured data In extract XML schema.
The invention has the advantages that:A kind of method by unified for software platform bottom isomeric data encapsulation of the present invention and System, for upper-layer user, query execution process and the result that returned are just one with the effect of access data mapping Cause, thus greatly reducing the complexity of upper layer application exploitation so that upper layer application can only focus on the realization of service logic, And without the data structure being concerned about bottom how.
In addition, by setting up overall " semantic base ", eliminating isomery semantically, solving conventional Data Integration institute The problem of the Semantic Heterogeneous existing, in conjunction with other technological means and method, mode, jointly efficiently solves Heterogeneous data and asks Various types of data Heterogeneity in topic domain, has decoupled software architecture and has applied at the middle and upper levels or service for bottom data operation Rely on, provide beneficial help for building increasingly complex, more horn of plenty software application.
Brief description
The present invention is further illustrated in conjunction with the embodiments with reference to the accompanying drawings.
Fig. 1 is the inventive method execution flow chart.
Fig. 2 is specific embodiment of the invention flow chart.
Fig. 3 is the Establishing process figure of semantic base of the present invention.
Specific embodiment
As shown in figure 1, what one of present invention was realized in:A kind of by unified for software platform bottom isomeric data encapsulation Method, database middleware includes intermediary device, wrapper and semantic base;Comprise the steps:
Step 1, intermediary's storehouse receive user inquiry request data;
Step 2, according to semantic base, inquiry request data is converted;
Step 3, wrapper are inquired about according to the inquiry request data of conversion, obtain Query Result;
Step 4, according to semantic base, query structure is converted into the inquiry data of prescribed form.
Step 5, intermediary device are processed, synthesized and are removed redundancy by inquiring about data, return to user afterwards.
Described semantic base sets up process:Extract data pattern from bottom data source, based on the respective data of different data sources Pattern, sets up respective local semantic;All of local semanteme is merged into an overall semanteme, forms semantic base, described Data pattern includes:Extract ER figure from structural data, and extract XML schema from semi-structured data.
The system of unified for software platform bottom isomeric data encapsulation, database middleware are included intermediary device, bag by the present invention Dress device and semantic base;Including such as lower module:
Receiver module, intermediary's storehouse receive user inquiry request data;
Inquiry request data is converted by conversion module according to semantic base;
Enquiry module, wrapper is inquired about according to the inquiry request data of conversion, obtains Query Result;
Obtain object module, according to semantic base, query structure is converted into the inquiry data of prescribed form.
Return module, intermediary device is processed, synthesized and removed redundancy by inquiring about data, returns to use afterwards Family.
Described semantic base sets up process:Extract data pattern from bottom data source, based on the respective data of different data sources Pattern, sets up respective local semantic;All of local semanteme is merged into an overall semanteme, forms semantic base, described Data pattern includes:Extract ER figure from structural data, and extract XML schema from semi-structured data.
A kind of specific embodiment of the present invention:
As shown in Fig. 2 user accesses the request initiating inquiry to intermediary device (based on global schema);
Intermediary device, after receiving inquiry request (global schema), translates the query to according to overall " semantic base " Based on the subquery of each local data source module, i.e. inquiry 1 and inquiry 2, and it is sent respectively to wrapper 1 and wrapper 2 assembly;
Wrapper 1 and wrapper 2 carry out the inquiry request inquired about 1 with inquire about 2, now bottom respectively according to respective data source The data source of layer must be not necessarily data base or semi-structured XML data or non-relational database etc.;
Each data source each returns respective Query Result 1 and result 2;
Different Query Results 1 and result 2 are returned to intermediary device by wrapper 1 and wrapper 2 respectively, and according to the overall situation " semantic base " is converted into consistent specification;
Intermediary device returns to user after data processing, synthesis, removal redundancy, is responded.
In addition, as shown in figure 3, semantic base to set up process as follows:
Extract data pattern from bottom data source:ER figure is extracted from structural data (such as relationship type DB);From half XML schema is extracted in structural data (such as XML, HTML can be first converted into XML);
Based on the respective data pattern of different data sources, set up respective local semantic;
All of local semanteme is merged into an overall semanteme, forms semantic base.
Although the foregoing describing the specific embodiment of the present invention, those familiar with the art should manage Solution, we are merely exemplary described specific embodiment, rather than for the restriction to the scope of the present invention, are familiar with this Equivalent modification and change that the technical staff in field is made in the spirit according to the present invention, all should cover the present invention's In scope of the claimed protection.

Claims (8)

1. a kind of method by unified for software platform bottom isomeric data encapsulation it is characterised in that:During database middleware includes Jie's device, wrapper and semantic base;Comprise the steps:
Step 1, intermediary's storehouse receive user inquiry request data;
Step 2, according to semantic base, inquiry request data is converted;
Step 3, wrapper are inquired about according to the inquiry request data of conversion, obtain Query Result;
Step 4, according to semantic base, query structure is converted into the inquiry data of prescribed form.
2. a kind of method by unified for software platform bottom isomeric data encapsulation according to claim 1 it is characterised in that: Also include step 5, intermediary device and processed, synthesized and removed redundancy by inquiring about data, return to user afterwards.
3. as claimed in claim 1 a kind of method by unified for software platform bottom isomeric data encapsulation it is characterised in that:Institute State semantic base and set up process:Extract data pattern from bottom data source, based on the respective data pattern of different data sources, set up each From local semantic;All of local semanteme is merged into an overall semanteme, forms semantic base.
4. as claimed in claim 3 a kind of method by unified for software platform bottom isomeric data encapsulation it is characterised in that:Institute State data pattern to include:Extract ER figure from structural data, and extract XML schema from semi-structured data.
5. a kind of system by unified for software platform bottom isomeric data encapsulation it is characterised in that:During database middleware includes Jie's device, wrapper and semantic base;Including such as lower module:
Receiver module, intermediary's storehouse receive user inquiry request data;
Inquiry request data is converted by conversion module according to semantic base;
Enquiry module, wrapper is inquired about according to the inquiry request data of conversion, obtains Query Result;
Obtain object module, according to semantic base, query structure is converted into the inquiry data of prescribed form.
6. a kind of system by unified for software platform bottom isomeric data encapsulation according to claim 5 it is characterised in that: Also include returning module, intermediary device is processed, synthesized and removed redundancy by inquiring about data, returns to user afterwards.
7. as claimed in claim 5 a kind of system by unified for software platform bottom isomeric data encapsulation it is characterised in that:Institute State semantic base and set up process:Extract data pattern from bottom data source, based on the respective data pattern of different data sources, set up each From local semantic;All of local semanteme is merged into an overall semanteme, forms semantic base.
8. as claimed in claim 7 a kind of system by unified for software platform bottom isomeric data encapsulation it is characterised in that:Institute State data pattern to include:Extract ER figure from structural data, and extract XML schema from semi-structured data.
CN201610892071.6A 2016-10-13 2016-10-13 A kind of method by unified for software platform bottom isomeric data encapsulation and system Pending CN106484874A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610892071.6A CN106484874A (en) 2016-10-13 2016-10-13 A kind of method by unified for software platform bottom isomeric data encapsulation and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610892071.6A CN106484874A (en) 2016-10-13 2016-10-13 A kind of method by unified for software platform bottom isomeric data encapsulation and system

Publications (1)

Publication Number Publication Date
CN106484874A true CN106484874A (en) 2017-03-08

Family

ID=58269304

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610892071.6A Pending CN106484874A (en) 2016-10-13 2016-10-13 A kind of method by unified for software platform bottom isomeric data encapsulation and system

Country Status (1)

Country Link
CN (1) CN106484874A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110677427A (en) * 2019-10-08 2020-01-10 山东浪潮商用系统有限公司 Multi-message analysis method
CN111881443A (en) * 2020-06-16 2020-11-03 苏州浪潮智能科技有限公司 Multi-user authentication method and system based on AI training management platform
CN112364538A (en) * 2020-11-09 2021-02-12 中国电子科技集团公司第二十九研究所 Multi-professional heterogeneous model unified packaging method based on data model

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102004748A (en) * 2010-04-29 2011-04-06 上海海洋大学 Heterogeneous geographic data query system and method
CN103092591A (en) * 2011-11-01 2013-05-08 镇江华扬信息科技有限公司 XML (Extensive Makeup Language) and Web Service based data integration middleware method
CN104008135A (en) * 2014-05-07 2014-08-27 南京邮电大学 Multi-source heterogeneous database fusion system and data query method thereof
CN104679823A (en) * 2014-12-31 2015-06-03 智慧城市信息技术有限公司 Semantic annotation-based association method and system of heterogeneous data

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102004748A (en) * 2010-04-29 2011-04-06 上海海洋大学 Heterogeneous geographic data query system and method
CN103092591A (en) * 2011-11-01 2013-05-08 镇江华扬信息科技有限公司 XML (Extensive Makeup Language) and Web Service based data integration middleware method
CN104008135A (en) * 2014-05-07 2014-08-27 南京邮电大学 Multi-source heterogeneous database fusion system and data query method thereof
CN104679823A (en) * 2014-12-31 2015-06-03 智慧城市信息技术有限公司 Semantic annotation-based association method and system of heterogeneous data

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110677427A (en) * 2019-10-08 2020-01-10 山东浪潮商用系统有限公司 Multi-message analysis method
CN111881443A (en) * 2020-06-16 2020-11-03 苏州浪潮智能科技有限公司 Multi-user authentication method and system based on AI training management platform
CN112364538A (en) * 2020-11-09 2021-02-12 中国电子科技集团公司第二十九研究所 Multi-professional heterogeneous model unified packaging method based on data model

Similar Documents

Publication Publication Date Title
US7979455B2 (en) RDF store database design for faster triplet access
US7823123B2 (en) Semantic system for integrating software components
US7818352B2 (en) Converting SPARQL queries to SQL queries
CN109492040A (en) A kind of system suitable for data center's magnanimity short message data processing
CN101493825B (en) GIS middleware collocation and management method
JPH07141399A (en) Computer data network and control thereof
WO2003030025A1 (en) Database management system
US10901973B1 (en) Methods and apparatus for a semantic multi-database data lake
CN101546325A (en) Grid heterogeneous data integrating method based on SOA
CN106484874A (en) A kind of method by unified for software platform bottom isomeric data encapsulation and system
US20150205880A1 (en) Integrating linked data with relational data
KR100331099B1 (en) Middleware system for integrating multiple databases and method for integrating distributed heterogeneous databases using the same
Dwyer et al. Some experiences with a distributed database testbed system
Lee et al. A design and implementation of XML-Based mediation framework (XMF) for integration of internet information resources
Kamel et al. Federated database management system: Requirements, issues and solutions
Nicklas et al. A schema-based approach to enable data integration on the fly
Bell et al. EDDS—a system to harmonize access to heterogeneous databases on distributed micros and mainframes
Spieldenner et al. ECA2LD: From entity-component-attribute runtimes to linked data applications
Papazoglou Knowledge-driven distributed information systems
Wu et al. Integrating diverse CIM databases: the role of natural language interface
KR100491725B1 (en) A data integration system and method using XQuery for defining the integrated schema
Yuan et al. Research and Application of Data Integration in Aircraft Designing Based on SDO.
Chan et al. Exchanging STEP data through XML-based mediators
Morishima et al. A data modeling and query processing scheme for integration of structured document repositories and relational databases
Xiao et al. RDF-based metadata management in peer-to-peer systems

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20170308