CN106201542B - WOF rapid development platform - Google Patents

WOF rapid development platform Download PDF

Info

Publication number
CN106201542B
CN106201542B CN201610574202.6A CN201610574202A CN106201542B CN 106201542 B CN106201542 B CN 106201542B CN 201610574202 A CN201610574202 A CN 201610574202A CN 106201542 B CN106201542 B CN 106201542B
Authority
CN
China
Prior art keywords
data
message
xml
access
entity
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
Application number
CN201610574202.6A
Other languages
Chinese (zh)
Other versions
CN106201542A (en
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.)
Shandong Laiwei Software Technology Co ltd
Original Assignee
Individual
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 Individual filed Critical Individual
Priority to CN201610574202.6A priority Critical patent/CN106201542B/en
Publication of CN106201542A publication Critical patent/CN106201542A/en
Application granted granted Critical
Publication of CN106201542B publication Critical patent/CN106201542B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/20Software design
    • G06F8/22Procedural
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/80Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
    • G06F16/84Mapping; Conversion

Landscapes

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

Abstract

The invention provides a WOF rapid development platform, which comprises an authorization server, a data warehouse, an Xml mapping document and a service interface, wherein the authorization server, the data warehouse, the Xml mapping document and the service interface are connected with a data center; the message ciphertext is decrypted to form a message plaintext after the processes of verifying the message format, judging the service life, judging the number of data centers and the like are carried out; the message ciphertext and the message returned by the authorization server are preprocessed and then preliminarily analyzed to form a preliminary data entity, the preliminary data entity is verified to form an Xml mapping file or analyzed message data, the analyzed message data is then formed into an executable statement, and finally the executable statement is executed through a database or locally. The scheme can effectively simplify the traditional software development mode, thereby improving the working efficiency of developers.

Description

WOF rapid development platform
Technical Field
The invention relates to the technical field of software development, in particular to a WOF rapid development platform which simplifies a traditional software development mode and improves the working efficiency of developers.
Background
In a traditional software development mode, different languages have different development tools, a software engineer can compile software through the programming tools, a long time is needed for the software engineer to build a development environment, and the characteristics of the programming languages need to be known in the development process; if a software development engineer is familiar with a plurality of development languages simultaneously, the software development engineer needs to be familiar with the construction of a plurality of language environments simultaneously. Because the development flow of each development language is not completely consistent, and a large part of work belongs to repetitive work; moreover, the quality requirement on developers is high, and enterprises need to cultivate the developers at high cost.
In the existing software development process, most software engineers operate in CMD surrounding a database and are work with great repeatability; for a primary software engineer, it is very likely that the logic relationship and the data relationship are not well separated, so that a software system is chaotic and unclear in hierarchy, and great aftereffects can be buried in both subsequent development and maintenance and implementation and maintenance of implementers.
Disclosure of Invention
The invention provides a WOF rapid development platform which can complete the development of basic software only by a notebook without preparing a complicated environment building by a developer.
In order to achieve the purpose, the technical scheme provided by the invention is as follows: a WOF rapid development platform comprises an authorization server, a data warehouse, an Xml mapping document and a service interface, wherein the authorization server, the data warehouse, the Xml mapping document and the service interface are connected with a data return message and a data request message; wherein the content of the first and second substances,
the authorization server comprises the following steps: message ciphertext → verification of message format → judgment of service life → judgment of data center number → decryption → message plaintext;
the data processing center comprises the following processing steps: the message ciphertext and the message returned by the authorization server are preprocessed and then preliminarily analyzed to form a preliminary data entity, the preliminary data entity is verified to form an Xml mapping file or is analyzed to form message data according to a preset rule, the message data is analyzed to form an executable statement, and finally the executable statement is executed through a database or locally.
The WOF rapid development platform adopts SOA to provide a data service interface, all data interaction provides data support through the service interface, and the condition that direct operation on a database is not allowed to occur in an application layer is strictly defined, so that the clarity of a system level is ensured, and the confusion of a software system is prevented. Meanwhile, the SOA interface is adopted, cross-platform data access is more convenient to realize, and the system can return the execution result as long as the access connection of the SOAP mode is followed.
The database structure dynamically generates structure mapping in the platform through XML (extensible markup language), and an access user can only access the database structure correspondingly existing in the XML, otherwise, an error prompt of illegal access is given.
The format of the data message for accessing the connection is encapsulated by adopting JSON (JavaScript Object Notation), and various forms of extensions are supported.
After the service interface acquires the data message submitted by the access user, the database element needing to be accessed in the message is searched in the XML mapping file according to the preset rule, and if the database element is not inquired, the access is terminated.
By the structure, the database is accessed, and an access user only needs to organize the data message according to a preset rule without preparing database statements.
The platform generated by the structure is applied to demand research and database design, the repeated utilization rate of codes is high, the layers are more obvious, and the complex events can be simplified after the layers are divided.
Among them, a Service Oriented Architecture (SOA) is a component model that ties different functional units of an application (called services) through well-defined interfaces and contracts between these services. The interface is defined in a neutral manner and should be independent of the hardware platform, operating system and programming language in which the service is implemented. This allows services built into various such systems to interact in a uniform and versatile manner.
Object Relational Mapping (ORM) is a technique for solving the problem of mismatch between Object-oriented and Relational databases. In brief, ORM is the automatic persistence of objects in a java program into a relational database using metadata that describes the mapping between the objects and the database. Essentially, data is converted from one form to another. This also implies an additional execution overhead at the same time; however, if ORM is implemented as a middleware, there are many opportunities to optimize, and these do not exist in the persistence layer of handwriting. More importantly, metadata for controlling the translation needs to be provided and managed; again, however, these costs are less than the solution of maintaining handwriting; and even object databases that comply with the ODMG specification still require class-level metadata.
Extensible markup language (XML), a subset of standard generalized markup language, is a markup language for marking electronic documents to be structured; in electronic computers, a label refers to a symbol of information that can be understood by a computer, and by this label, various information such as articles and the like can be handled between computers. It can be used to mark data, define data types, and is a source language that allows a user to define his or her own markup language. It is well suited for world wide web transport, providing a unified approach to describing and exchanging structured data that is independent of the application or vendor. Is a cross-platform, content-dependent technology in the Internet environment and is also an effective tool today for processing distributed structural information. As early as 1998, the XML1.0 specification was published by W3C, which was used to simplify the transmission of Internet documents.
JSON (JavaScript Object Notification) is a lightweight data exchange format. It is based on a subset of ECMAScript. JSON employs a text format that is completely language independent, but also uses conventions similar to the C language family (including C, C + +, C #, Java, JavaScript, Perl, Python, etc.). These properties make JSON an ideal data exchange language. Easy to read and write by humans, and also easy to parse and generate by machines (typically used to increase network transmission rates).
Compared with the traditional software development mode, the scheme of the invention has the advantages that under the new development mode, developers do not need to be familiar with more complex environment configuration and flow. For WEB access-based applications, developers can completely use editors of notepad categories to compile codes, organize data messages according to rules agreed in advance when data access is needed, and submit the data messages to an application service interface by adopting common AJAX, FORM FORMs and other modes; for the client-based C/S or APP application, the same or similar structure as the WEB scheme can be adopted during design, development personnel only need to be responsible for the design of a software interface and functions in the client (C/S, APP), and for the operation of the database, the operation is completely processed by a data center without facing variable and complex SQL statements and complex relations with object entities.
Drawings
FIG. 1 is a schematic diagram of a platform system architecture according to the present invention.
FIG. 2 is a schematic diagram of an authorization service flow according to the present invention.
FIG. 3 is a schematic diagram of a data processing center according to the present invention.
Detailed Description
The invention will be further described with reference to the accompanying drawings, in which preferred embodiments of the invention are: referring to fig. 1 to fig. 3, the WOF platform described in this embodiment is mainly composed of a data center, and the data center is responsible for the screening, classification, and calculation of data of the entire architecture.
The service interface is responsible for receiving and replying the data message of the client, and also undertakes the function of load balancing, when the access data volume is larger than the maximum data volume which can be undertaken by the current service interface, a plurality of service interfaces can be deployed, but the plurality of service interfaces can correspond to one data center; if a single data center cannot bear the data volume submitted by a plurality of data interfaces, the data center and the service interfaces can be deployed in a binding manner, that is, one service interface corresponds to one or more data centers, so that combined deployment is formed, and each combined database access path is configured, so that the combined database access path can operate on one or more databases, for example, a production database and a configuration database can be subjected to shunting processing.
And after the service interface receives the data message, the friend-making data processing center performs data processing.
After the data center performs preliminary processing according to the service interface, firstly, the data message needs to be decrypted; to prevent data interception during network transmission, encryption processing is performed on data transmitted on the network before transmission by the client. When the data reaches the service interface, the submitted data exists in a ciphertext form, the service interface performs simple unpacking processing, removes the outer layer identification structure of the data, and submits the data ciphertext of the core to the data center.
The data center needs the support of an authorization server for decrypting the data message, the authorization server is an authorized server or a common application, and the authorization content includes configuration information such as a service life, the number of the data centers, an encryption key and the like. For the authorization server exceeding the service life, when the data center requires an authorization key, the authorization server gives unauthorized message information; for each time the authorization server receives a decryption request of a data center, the characteristic information of the accessed data center is recorded, the access quantity is accumulated, and when the access quantity reaches the authorization quantity of the authorization server, the decryption request returns a prompt that the data center reaches the authorization quantity [ error code: EM1003 ″; if all verification authorizations pass, the authorization server will prepare to analyze the data ciphertext submitted by the data center, firstly verify whether the submitted data ciphertext is correct in format, if not, the data ciphertext will not go downwards, and return prompt information that the data ciphertext of the data center is incorrect [ error code: EM1004 ]; if the format is correct, the authorization server decrypts the ciphertext data by using the authorization key, performs data verification after decryption, and transmits the decrypted message to the accessed data center after verification is correct.
After the data center acquires the decryption message from the authorization server, if the returned data contains error information, the data center transmits the returned data to the service interface, and the upward execution cannot be continued; if the returned data contains a decryption success mark, the decrypted message is subjected to preliminary analysis, the analysis rule is to check whether the data format of the decrypted message is organized according to a predetermined rule, and if the preliminary analysis finds that the decrypted message is incorrect, the data center returns prompt information (error code) that the message format is incorrect: EM1005, and delivering to a service interface for transmission; if the format of the analyzed and decrypted message is correct, the data center starts to transfer the message to a process for analysis, and the process analysis firstly carries out formatting treatment on the message data so as to prevent an incorrect character format from entering the process and further cause the abnormal analysis process; for the formatted message data, a data entity is required to be generated according to a set rule, the generated data entity is mainly divided into two types, one is an XML format and mainly deals with the processing of BASE64 pictures, and the other is a JSON format; the scheme makes full use of JSON expandability and can flexibly and dynamically generate various data entity structures, thereby saving a large amount of development time and program space. The data entity generated by the preliminary analysis is an important operation object of the process.
According to the structure of the data entity generated by the primary analysis and the structure mapping file structure of the XML database, the data entity is further verified; if the database element that is desired to be accessed in the data entity is not found in the mapping file, the downward execution will not be continued, and a prompt message that the access structure does not exist is returned [ error code: EM1006 ]; r if the data entity contains the functional service and database element which need to be accessed, the system will search whether the element structure which needs to be accessed in the data exists in the XML mapping file according to the element which needs to be accessed in the entity; in the process of operating the XML mapping file, if the XML mapping file is subjected to more traversal and cycle operations, the reaction speed of the platform can be influenced, so that the system can buffer fragments of the XML mapping file every time the XML mapping file is operated once, for example, when the system loads the structure of an XML mapping file data table for the first time, the system automatically records the accessed XML fragment structure and caches the XML fragment structure into the memory, and when the same fragment is accessed next time, traversal search in the XML is not needed, and the XML fragment can be directly called from the memory according to the ID of the accessed fragment; similarly, the method is also a similar caching mechanism in the searching process of the query index and the field attribute of the operation data table structure, so that the reaction speed of the system is improved.
The data center judges how to carry out the next operation according to the information obtained by the mapping file and the data entity; judging whether the database needs to be accessed according to the information, wherein the database middleware needs to start working at the moment; firstly, searching data elements needing to be accessed in a data entity according to a preset rule, such as a data table, a function, a storage process and a view; the data elements needing to be accessed need to be set in an XML mapping file before being accessed, and a unique index is given, and the data elements are searched in the XML file according to the label and the index in the process of analyzing the data entity; for more special fields such as pictures, long texts and the like, types need to be set in corresponding field elements; for the storage process and the function, the length and the type of a parameter need to be set in an element, and if the length and the type of the incoming data are not consistent, the system is regarded as illegal access; for more specific query conditions, the XML mapping file may contain corresponding setting items, such as data grouping, sorting, paging, and the like. In the process of parsing the data entity, if it is found that the field to be accessed in the data entity does not exist in the XML mapping file, the process cancels the parsing of the field in the entity, and continues to process the next field, and if all the fields do not exist in the XML mapping file, the data processing center returns a prompt message that the access structure does not exist [ error code: EM1006 ]; if the accessed field or element exists, the center will make the corresponding field name and field value in the data entity and the field or element in the XML mapping file correspond and assign values, and form SQL statement or server script execution code according to the method which is required to be operated in the entity, and finally submit the SQL statement or server script execution code to the database or OS for processing, if the SQL statement or server script execution code is submitted to the database operation, a return data message will be formed according to the return format set in the data entity; if abnormity occurs in the executing process, the system writes abnormal information into a log, packs error information into a failure message, returns the failure message to the service interface, and returns the failure message to the client through the service interface; if the execution process comprises the transaction processing, the data platform automatically starts a transaction processing mechanism, returns the final execution result of the transaction processing to the client and simultaneously supports a plurality of return formats; if all the executions are executed successfully, the data platform forms a return message according to the format agreed in the data entity, submits the return message to the service interface, and is uniformly packaged by the interface and returns the return message to the client.
In summary, the present invention is only a specific embodiment, and it should be noted that, for those skilled in the art, a plurality of modifications and decorations can be made without departing from the scope of the invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.

Claims (2)

1. A WOF rapid development platform is characterized in that: the system comprises an authorization server, a data warehouse, an Xml mapping document and a service interface which are connected with a data center, wherein the service interface is connected with a data return message and a data request message, and the data return message and the data request message are connected with a request client; wherein the content of the first and second substances,
the authorization server comprises the following steps: message ciphertext → verification of message format → judgment of service life → judgment of data center number → decryption → message plaintext;
the data processing center comprises the following processing steps: the method comprises the steps that after a message ciphertext and a message returned by an authorization server are preprocessed, a preliminary data entity is formed after preliminary analysis, the preliminary data entity is verified to form an Xml mapping file or analysis message data according to a preset rule, the analysis message data is formed into an executable statement, and the executable statement specifically comprises the steps that firstly, data elements needing to be accessed in the data entity are searched according to the preset rule; the data elements needing to be accessed need to be set in an XML mapping file before being accessed, and a unique index is given, and the data elements are searched in the XML file according to the label and the index in the process of analyzing the data entity; setting types in corresponding field elements for special fields; setting parameter length and type in elements for storage process and function, if the length and type of the incoming data are not consistent, the system will be regarded as illegal access; the special query condition can be embodied in the XML mapping file, in the process of analyzing the data entity, if the field which is wanted to be accessed in the data entity is found not to exist in the XML mapping file, the process cancels the analysis of the field in the entity and continues to process the next field, if all the fields do not exist in the XML mapping file, the data processing center returns the prompt information that the access structure does not exist, if the accessed field or element exists, the center corresponds and assigns the field name and the field value which correspond to the data entity and the field or element in the XML mapping file, forms an SQL statement or server script execution code according to the method which is wanted to be operated in the entity, and finally executes the SQL statement or server script execution code through a database or locally.
2. The WOF rapid development platform of claim 1, wherein: the service interface adopts SOA to provide data, the interaction of all data provides data support through the service interface, meanwhile, the SOA is adopted to facilitate the realization of cross-platform data access, and the system can return an execution result as long as the access connection of the SOAP mode is followed; after the service interface acquires the data message submitted by the access user, searching a database element needing to be accessed in the message in an XML mapping file according to a preset rule, and stopping the access if the database element is not inquired;
the database structure dynamically generates structure mapping in the platform through XML language, an access user can only access the database structure correspondingly existing in the XML, otherwise, an illegal access error prompt is given, the format of the access connected data message is packaged by adopting JSON, and various forms of expansion are supported.
CN201610574202.6A 2016-07-14 2016-07-14 WOF rapid development platform Active CN106201542B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610574202.6A CN106201542B (en) 2016-07-14 2016-07-14 WOF rapid development platform

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610574202.6A CN106201542B (en) 2016-07-14 2016-07-14 WOF rapid development platform

Publications (2)

Publication Number Publication Date
CN106201542A CN106201542A (en) 2016-12-07
CN106201542B true CN106201542B (en) 2020-06-26

Family

ID=57493540

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610574202.6A Active CN106201542B (en) 2016-07-14 2016-07-14 WOF rapid development platform

Country Status (1)

Country Link
CN (1) CN106201542B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107894973A (en) * 2017-10-30 2018-04-10 武汉华工赛百数据系统有限公司 A kind of method for interchanging data and system based on XML
CN108197176A (en) * 2017-12-21 2018-06-22 深圳四方精创资讯股份有限公司 Core bank data processing method and its system based on distributed type assemblies framework
CN112948852A (en) * 2021-02-26 2021-06-11 杭州安恒信息安全技术有限公司 Data access method, device and computer readable storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102096710A (en) * 2011-01-21 2011-06-15 周军 Extensive makeup language (XML) template-based message analysis method
CN105138339A (en) * 2015-09-10 2015-12-09 中国航空无线电电子研究所 Distributed communication midware developing method based on DDS standard
CN105718431A (en) * 2016-01-14 2016-06-29 浪潮软件集团有限公司 Method for formatting Webservice message

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102096710A (en) * 2011-01-21 2011-06-15 周军 Extensive makeup language (XML) template-based message analysis method
CN105138339A (en) * 2015-09-10 2015-12-09 中国航空无线电电子研究所 Distributed communication midware developing method based on DDS standard
CN105718431A (en) * 2016-01-14 2016-06-29 浪潮软件集团有限公司 Method for formatting Webservice message

Also Published As

Publication number Publication date
CN106201542A (en) 2016-12-07

Similar Documents

Publication Publication Date Title
JP5431513B2 (en) Interpreting command scripts using local and extended storage for command indexing
US7418665B2 (en) Portable cross platform database accessing method and system
US7805341B2 (en) Extraction, transformation and loading designer module of a computerized financial system
US9152796B2 (en) Dynamic analysis interpreter modification for application dataflow
EP1686498A2 (en) Integration of a non-relational query language with a relational data store
US7873678B2 (en) Lightweight directory access protocol (LDAP) schema definition using extensible markup language (XML)
CN112260877B (en) AI-based RPA robot management method, platform and storage medium
US20050278697A1 (en) Object type-declaration prefix syntax
CN107665216A (en) A kind of data bank access method and middleware
CN102663298B (en) Safety online detecting system facing to terminal computers
CN106201542B (en) WOF rapid development platform
CN112671734A (en) Message processing method facing multiple data sources and related equipment thereof
CN115061851A (en) Data verification method and device, storage medium and electronic equipment
EP2343658A1 (en) Federation as a process
CN100470483C (en) System, device, and method for cooperative processing
WO1998038585A1 (en) Application messaging system
US8136087B2 (en) In-line processing of standardized text values
WO2023151239A1 (en) Micro-service creation method and related device
CN111459793B (en) Full life cycle software automatic test method and device
KR20020066151A (en) Spatial information distributing system based on open gis and method thereof
CN112231409A (en) Initial loading method, device, equipment and storage medium for database synchronization
CN109062954A (en) A kind of efficient data exchange and data source shielding system
CN108959489A (en) A kind of efficient data exchange and data source partition method
US11030332B1 (en) Database controlled web service type architecture
CN112287012B (en) Method for realizing http interface calling by Spark SQL mode

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
TR01 Transfer of patent right

Effective date of registration: 20210924

Address after: 250000 room 2-302-52, building 7, North District, Shandong design and Creative Industrial Park, No. 868, Tangye West Road, Jinan area, China (Shandong) pilot Free Trade Zone, Jinan, Shandong Province

Patentee after: Shandong Laiwei Software Technology Co.,Ltd.

Address before: 250000 No. 122, Yingshi street, Huaiyin District, Jinan City, Shandong Province

Patentee before: Zhang Bo

TR01 Transfer of patent right