CN110889013B - Data association method, device, server and storage medium based on XML - Google Patents
Data association method, device, server and storage medium based on XML Download PDFInfo
- Publication number
- CN110889013B CN110889013B CN201911157379.6A CN201911157379A CN110889013B CN 110889013 B CN110889013 B CN 110889013B CN 201911157379 A CN201911157379 A CN 201911157379A CN 110889013 B CN110889013 B CN 110889013B
- Authority
- CN
- China
- Prior art keywords
- data
- xml
- xml document
- page
- database
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information 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/81—Indexing, e.g. XML tags; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Abstract
The invention discloses a data association method, a device, a server and a storage medium based on XML, wherein the method comprises the following steps: acquiring demand modeling based on page configuration, wherein the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data; acquiring first data input by a user at the operable control; and processing the first data into an XML document and storing the XML document in a relational database. The technical scheme of the invention realizes the effects of providing visual and concise data service for users and improving the modeling reuse rate.
Description
Technical Field
The embodiment of the invention relates to the field of database operation, in particular to a data association method, a data association device, a server and a storage medium based on XML.
Background
With the wide popularization of data application, data sources become more and more complex, and the problems of type selection and heterogeneous data of database products bring more and more troubles to data integration.
On the other hand, users facing results and data analysis operations of data applications are no longer IT professional users, and IT is an urgent need to provide intuitive and concise data services for various users, so that demands for data visualization, object-oriented data service development and the like are increasing, but such applications bring another problem: how to establish an efficient translation mechanism between structured and unstructured data relationships and intuitive data operations becomes another issue.
Finally, with the popularization of data applications, the problem that how a requirement expression of a fuzzy and non-TI professional nature, which is provided by a non-IT professional user, can be converted into a clear algorithm for data also becomes a problem to be solved urgently.
Disclosure of Invention
The invention provides a data association method, a data association device, a server and a storage medium based on XML (extensive Makeup language), which are used for realizing the effects of providing visual and concise data services for users and improving the modeling reuse rate.
In a first aspect, an embodiment of the present invention provides a data association method based on XML, including:
acquiring demand modeling based on page configuration, wherein the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data;
acquiring first data input by a user at the operable control;
and processing the first data into an XML document and storing the XML document in a relational database.
In a second aspect, an embodiment of the present invention further provides an XML-based data association apparatus, including:
the modeling module is used for obtaining demand modeling based on page configuration, the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data;
the data acquisition module is used for acquiring first data input by a user at the operable control;
and the processing module is used for processing the first data into an XML document and storing the XML document in the relational database.
In a third aspect, an embodiment of the present invention further provides a server, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor executes the computer program to implement the XML-based data association method.
In a fourth aspect, the embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, which when executed by a processor implements the XML-based data association method as described above.
According to the technical scheme, demand modeling based on page configuration is obtained, wherein the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data; acquiring first data input by a user at the operable control; the first data is processed into an XML document and stored in the relational database, so that the problem of how fuzzy and non-IT professional requirement expression provided by non-IT professional users can be converted into a clear algorithm for the data is solved, and the effects of providing visual and concise data service for the users and improving the modeling reuse rate are achieved.
Drawings
Fig. 1 is a flowchart of an XML-based data association method according to a first embodiment of the present invention.
Fig. 2 is a flowchart of an XML-based data association method in the second embodiment of the present invention.
Fig. 3 is a flowchart of XML-based data migration parsing in the third embodiment of the present invention.
Fig. 4 is a schematic structural diagram of an XML-based data association apparatus according to a third embodiment of the present invention.
Fig. 5 is a schematic structural diagram of a server in the third embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not to be construed as limiting the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Before discussing exemplary embodiments in greater detail, it should be noted that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart may describe the steps as a sequential process, many of the steps can be performed in parallel, concurrently or simultaneously. In addition, the order of the steps may be rearranged. A process may be terminated when its operations are completed, but may have additional steps not included in the figure. A process may correspond to a method, a function, a procedure, a subroutine, a subprogram, etc.
Furthermore, the terms "first," "second," and the like may be used herein to describe various orientations, actions, steps, elements, or the like, but the orientations, actions, steps, or elements are not limited by these terms. These terms are only used to distinguish one direction, action, step or element from another direction, action, step or element. For example, a first database may be referred to as a second database, and similarly, a second database may be referred to as a first database, without departing from the scope of the present application. The first database and the second database are both databases, but they are not the same database. The terms "first", "second", etc. are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of the present invention, "a plurality" means at least two, e.g., two, three, etc., unless explicitly specified otherwise.
Example one
Fig. 1 is a flowchart of an XML-based data association method according to an embodiment of the present invention, where the embodiment is applicable to a data relationship description case, and the method includes the following steps:
s110, acquiring demand modeling based on page configuration, wherein the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data;
in this embodiment, a user may select a page creation instruction by triggering an operation option configured by the system, and send the page creation instruction to the page configuration system. After receiving a page creation instruction, the page configuration system responds to the page creation instruction, obtains the identifier and the preview information of at least one page configuration template, and renders the identifier and the preview information of the at least one page configuration template to generate a template selection page.
The identification of the page configuration template is specifically the name of the page configuration template; the preview information of the page configuration template specifically includes any one or more of partition composition of the page configuration template, available component types, usage scenario description information, keyword information, and page example link information created using the template. In at least one page configuration template configured in the page configuration system, each page configuration template corresponds to an identifier, different page configuration templates have different identifiers, and preview information corresponding to the identifiers of the different page configuration templates is different.
The user can establish a model according to self requirements, such as a bank model, a city model, a ground model, a road network model, a school model, a railway station model, a hospital model and the like, and requirements of bank reports or school personnel statistics can be met through the design of the model. In the demand modeling process, a type of a page to be built can be selected, an operable control to be used when the page is built is selected, and the operation can be a page-based drag operation, which is not limited herein. In this page, retrieval operations can be performed on the operable control library of the current type page, and viewing and deletion operations are allowed for all components in the component library. The required control can be selected from the control library arranged on the left side of the page in a dragging mode and put into the page. The positions of the controls can be adjusted in real time according to requirements, a control chain is formed through connecting lines, the tree-shaped graph can also be used, limitation is not required, and the connecting lines can represent data relationships among the controls.
S120, acquiring first data input by a user in the operable control;
in this embodiment, after the entire skeleton of the page is constructed, specific parameter configuration needs to be performed for each component. Such as appearance style of the component, event binding, data source selection, jump links, and so forth. The configuration mode is that a mouse is used for clicking to select the current component, a parameter list capable of being configured by the current component is displayed in the parameter configuration area, the current configuration can be enabled by clicking the determining button after the configuration is completed, and all parameters of the current configuration can be emptied by clicking the resetting button. The user inputs data according to business requirements, for example, if the user needs the statistics of a bank report, a model based on the bank report style needs to be established, and then parameter data is input according to business contents. The model of the embodiment is not limited to one bank, and the current model can be used for report statistics of another bank, so that the use reuse rate of the model is improved.
S130, processing the first data into an XML document and storing the XML document in a relational database.
In this embodiment, XML (Extensible Markup Language), which is a subset of the standard universal Markup Language, is a Markup Language for marking electronic documents to make them have structure. XML can be used for marking data and defining data types, can allow a user to define own marking languages, and is a data carrying mode which is friendly to people and machines. It provides a unified approach to describe and exchange application or vendor independent structured data, is well suited for world wide web transport, is a cross-platform, content-dependent technology in the Internet environment, and is an effective tool today for handling distributed structural information.
The method comprises the steps that a user inputs parameter data after modeling is needed, the parameter data and a model are translated into data which can be recognized by a server through data translation, the server verifies and eliminates the data which do not meet the protocol requirements, then XML language is used for classifying and establishing tables for the parameter data, the relation between the data is used as the corresponding relation between the tables to be stored into an XML document, then the XML document is stored into a relational database, and the query can be called at any time.
If the effect of modeling the page is confirmed to be correct, a download button of the page can be clicked, all the dependent resource files of the page are packaged and packed, a final XML document is generated, and the final XML document is downloaded to a locally specified file directory.
According to the technical scheme, demand modeling based on page configuration is obtained, wherein the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data; acquiring first data input by a user at the operable control; the first data is processed into an XML document and stored in a relational database, so that the problem that how fuzzy and non-IT-professional-property requirement expressions provided by non-IT-professional users can be converted into a clear algorithm for the data is solved, and the effects of providing visual and concise data services for the users and improving the modeling reuse rate are achieved.
Example two
Fig. 2 is a flowchart of an XML-based data association method according to a second embodiment of the present invention, where this embodiment is further optimized based on the foregoing embodiment, and the method specifically includes:
s210, acquiring demand modeling based on page configuration, wherein the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data;
in this embodiment, in the demand modeling process, a type of a page to be built may be selected, and an operable control to be used when the page is built is selected, where the operable control may be a page-based drag operation, and this is not limited here. The positions of the controls can be adjusted in real time according to requirements, a control chain is formed through connecting lines, the tree-shaped graph can also be used, limitation is not required, and the connecting lines can represent data relationships among the controls.
S220, acquiring first data input by a user in the operable control;
in this embodiment, a user inputs data according to business requirements, for example, if the user needs statistics of a bank report, a model based on a bank report style needs to be established, and then parameter data is input according to business contents. The model of the embodiment is not limited to one bank, and the current model can be used for report statistics of another bank, so that the use reuse rate of the model is improved.
S230, filtering the first data;
in this embodiment, the filtering may also be data cleaning, that is, the last procedure for finding and correcting an identifiable error in a data file includes checking data consistency, processing invalid values and missing values, and the like. Because of the uncertainty in the data acquisition process, it is avoided that some data are wrong data and some data have conflicts with each other, and the wrong or conflicting data are obviously unwanted and are called as 'dirty data', and the 'dirty data' is 'washed away' according to a certain rule. After receiving the first data input by the user, the server can process the first data after passing the security authentication. The server receives the model data and the parameter data through the data read-write interface, extracts the parameter data and the data relation based on the model relation, and obtains the required data through data cleaning.
S240, storing the filtered first data in a data warehouse, wherein the data warehouse is used for storing intermediate data.
In this embodiment, the intermediate data is data in the process of multiprocessing data by the server, so that subsequent extraction processing and use are facilitated. The server may extract the model data and the parameter data from the data repository for processing.
And S250, processing the first data into an XML document according to a preset algorithm and storing the XML document in a relational database, wherein the preset algorithm comprises integrated logic determined by a plurality of independent subtasks.
In this embodiment, the preset algorithm is to mark parameter data through XML language, classify data definitions into individual tables, and define relationships between the tables through model data. The preset algorithm comprises a plurality of independent subtasks, each subtask comprises data information of a plurality of tables, and the corresponding relation between the subtasks and the relation between the tables form integrated logic. Illustratively, in terms of school demographics. The relationship records of all students in the school can be recorded and counted through the class table, the class number table, the class name table, the student table and the student number table, and follow-up query is facilitated.
Further, the integration logic is a relational description of data among the plurality of independent subtasks.
Further, the subtask includes data table information, where the data table information includes a table mode, a table name, a field list, and a list of corresponding data types.
In this embodiment, the preset algorithm is decomposed into a plurality of independent subtasks, the integrated logic of each subtask is determined, and the integrated logic is formatted into a query plan. The query plan may be expressed in a structured query language. It should be noted that: each table and attribute column in the query statement is prefixed by an identification of the database to which it belongs.
Further, after the processing the first data into an XML document and storing the XML document in the relational database, the method further includes: and performing database management on the XML document according to the database management operation of the user, wherein the database management comprises the maintenance operation on the XML document.
In this embodiment, incremental updating is performed on the deployed database continuously, and an updated sql or data XML description file required by the updating is generated manually, which brings a very large workload. In order to solve the problem, the method adds the data updating operation types (addition, deletion and updating) and applies the demand page operation corresponding to the updating operation through the description of various types of data in the XML description file. And automatically generating a single-time updating XML data file based on the data updating demand page operation through the added data updating operation type and the corresponding demand page operation. Each time the database is incrementally updated, maintenance operations such as adding, deleting, changing, importing or exporting are performed through page operations, a corresponding database incremental update XML description file is generated, and the incremental update of the database can be realized through the XML description file.
According to the technical scheme, demand modeling based on page configuration is obtained, wherein the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data; acquiring first data input by a user at the operable control; filtering the first data; storing the filtered first data in a data warehouse, wherein the data warehouse is used for storing intermediate data; and processing the first data into an XML document according to a preset algorithm and storing the XML document in a relational database, wherein the preset algorithm comprises integrated logic determined by a plurality of independent subtasks. The technical scheme of the embodiment of the invention solves the problem that the existing XML descriptive language has higher data relationship and service coupling degree, and achieves the effect of improving the universality of the XML descriptive data relationship.
EXAMPLE III
Fig. 3 is a flowchart illustrating XML-based data migration parsing according to a third embodiment of the present invention, where the third embodiment is applicable to a data migration situation, and the specific structure is as follows:
s310, receiving migration data transmitted by a terminal, wherein the migration data belong to a first database, and the first database is different from a second database corresponding to the XML document;
s320, analyzing the migration data into analysis data according to a preset analysis rule, wherein the preset analysis rule comprises an analysis rule corresponding to the first database;
s330, storing the analysis data in the relational database.
In this embodiment, the first database may be an oracle, an sql server, a sybase, an informax database, and the like, which is not limited herein. The second database of this embodiment is an XML-based database. Illustratively, a Table object is obtained from a source database end, the format of the Table object is converted, the Table object is converted into a Table of an XML database according to the mapping relation of fields between the source database and a target database, the converted information is transmitted to XML statements to construct the XML database, corresponding XML statements are constructed according to the DesDatabase object encapsulating the information of the target database, and the XML is executed to import data into the XML database.
The invention can also be applied to other databases, for example, an XML-based data dump file is imported into a destination database, and is automatically connected to the destination database by using the defined destination database connection information, then the XML-based data dump file exported from a source database is parsed, table structure information and data stored in a table are obtained, the table is further created in the destination database, and finally sql required for data import is constructed and executed to import data into the destination database.
According to the technical scheme of the embodiment of the invention, migration data transmitted by a receiving terminal belong to a first database, and the first database is different from a second database corresponding to an XML document; analyzing the migration data into analysis data according to a preset analysis rule, wherein the preset analysis rule comprises an analysis rule corresponding to the first database; and storing the analysis data in the relational database. The technical scheme of the embodiment of the invention solves the problem of multi-platform universality and achieves the effects of supporting data integration and data migration across data platforms.
Example four
Fig. 4 is a schematic structural diagram of an XML-based data association apparatus 400 according to a fourth embodiment of the present invention, where the embodiment is applicable to a data association situation, and the specific structure is as follows:
the modeling module 410 is configured to obtain demand modeling based on page configuration, where the demand modeling includes multiple operable controls, and connection lines among the multiple operable controls form a control chain, where the connection lines are corresponding relations between data;
the data acquisition module 420 is configured to acquire first data input by a user at the operable control;
and the processing module 430 is configured to process the first data into an XML document and store the XML document in the relational database.
Further, the processing module 430 includes processing the first data into an XML document according to a preset algorithm, and storing the XML document in the relational database, where the preset algorithm includes an integrated logic determined by a plurality of independent subtasks.
Further, the integration logic is a relational description of data among the plurality of independent subtasks.
Further, the subtask includes data table information, where the data table information includes a table mode, a table name, a field list, and a list of corresponding data types.
Further, the apparatus 400 further comprises a filtering module and an intermediate storage module,
the filtering module is used for filtering the first data;
the intermediate storage module is used for storing the filtered first data in a data warehouse, and the data warehouse is used for storing intermediate data.
Further, the apparatus 400 further comprises a migration data receiving module, a parsing module and a parsing data storage module,
the migration data receiving module is used for receiving migration data transmitted by a terminal, wherein the migration data belong to a first database, and the first database is different from a second database corresponding to the XML document;
the analysis module is used for analyzing the migration data into analysis data according to a preset analysis rule, wherein the preset analysis rule comprises an analysis rule corresponding to the first database;
and the analysis data storage module is used for storing the analysis data in the relational database.
Further, the apparatus 400 further comprises a database management module for performing database management on the XML document according to a database management operation of a user, where the database management includes a maintenance operation on the XML document.
The XML-based data association apparatus 400 provided in the embodiment of the present invention can execute the XML-based data association method provided in the foregoing embodiment, and has the corresponding functional modules and beneficial effects of the execution method.
EXAMPLE five
Fig. 5 is a schematic structural diagram of a server according to a fifth embodiment of the present invention. FIG. 5 illustrates a block diagram of an exemplary server 512 suitable for use in implementing embodiments of the present invention. The server 512 shown in fig. 5 is only an example and should not bring any limitations to the function and scope of the use of the embodiments of the present invention.
As shown in FIG. 5, server 512 is in the form of a general-purpose server. Components of server 512 may include, but are not limited to: one or more processors 516, a storage device 528, and a bus 518 that couples the various system components including the storage device 528 and the processors 516.
The server 512 typically includes a variety of computer system readable media. Such media can be any available media that is accessible by server 512 and includes both volatile and nonvolatile media, removable and non-removable media.
A program/utility 540 having a set (at least one) of program modules 542 may be stored, for example, in storage 528, such program modules 542 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may include an implementation of a network environment. The program modules 542 generally perform the functions and/or methods of the described embodiments of the invention.
The server 512 may also communicate with one or more external devices 514 (e.g., keyboard, pointing terminal, display 524, etc.), with one or more terminals that enable a user to interact with the server 512, and/or with any terminals (e.g., network card, modem, etc.) that enable the server 512 to communicate with one or more other computing terminals. Such communication may occur via input/output (I/O) interfaces 522. Further, server 512 may communicate with one or more networks (e.g., a Local Area Network (LAN), wide Area Network (WAN), and/or a public Network such as the Internet) via Network adapter 520. As shown in FIG. 5, the network adapter 520 communicates with the other modules of the server 512 via the bus 518. It should be appreciated that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the server 512, including but not limited to: microcode, end drives, redundant processors, external disk drive Arrays, RAID (Redundant Arrays of Independent Disks) systems, tape drives, and data backup storage systems, among others.
The processor 516 executes various functional applications and data processing by running programs stored in the storage device 528, for example, implementing an XML-based data association method provided by any embodiment of the present invention, which may include:
acquiring demand modeling based on page configuration, wherein the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data;
acquiring first data input by a user at the operable control;
and processing the first data into an XML document and storing the XML document in a relational database.
Example six
An embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements an XML-based data association method according to any embodiment of the present invention, where the method may include:
acquiring demand modeling based on page configuration, wherein the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data;
acquiring first data input by a user at the operable control;
and processing the first data into an XML document and storing the XML document in a relational database.
The computer-readable storage media of embodiments of the invention may take any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or terminal. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (9)
1. An XML-based data association method, comprising:
acquiring demand modeling based on page configuration, wherein the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data;
the obtaining of the demand modeling based on the page configuration comprises: after a page creating instruction is received, responding to the page creating instruction, acquiring the identifier and the preview information of at least one page configuration template, and rendering the identifier and the preview information of the at least one page configuration template to generate a template selection page; performing appearance style, event binding, data source selection and/or jump link parameter configuration on each component;
the identification of the page configuration template is specifically the name of the page configuration template; the preview information of the page configuration template specifically includes: any one or more of partition composition of a page configuration template, available component types, usage scenario description information, keyword information, and page example link information created using the template;
acquiring first data input by a user at the operable control;
processing the first data into an XML document and storing the XML document in a relational database;
said processing said first data into an XML document stored in a relational database comprises:
processing the first data into an XML document according to a preset algorithm and storing the XML document in a relational database, wherein the preset algorithm comprises integrated logic determined by a plurality of independent subtasks;
the processing the first data into an XML document according to a preset algorithm and storing the XML document in a relational database comprises the following steps: decomposing a preset algorithm into a plurality of independent subtasks, determining the integrated logic of each subtask, and formalizing the integrated logic into a query scheme, wherein the query scheme is expressed by a structured query language.
2. The XML-based data association method according to claim 1, wherein the integration logic is a relational description of the data among the plurality of independent subtasks.
3. The XML-based data association method according to claim 1, wherein the subtask includes data table information, the data table information including a table schema, a table name, a field list, and a list of corresponding data types.
4. The XML-based data association method according to claim 1, wherein the obtaining the first data input by the user in the operable control further comprises:
filtering the first data;
storing the filtered first data in a data warehouse, wherein the data warehouse is used for storing intermediate data.
5. The XML-based data association method according to claim 1, further comprising:
receiving migration data transmitted by a terminal, wherein the migration data belong to a first database, and the first database is different from a second database corresponding to the XML document;
analyzing the migration data into analysis data according to a preset analysis rule, wherein the preset analysis rule comprises an analysis rule corresponding to the first database;
and storing the analysis data in the relational database.
6. The XML-based data association method according to claim 1, wherein after the processing the first data into the XML document and storing the XML document in the relational database, the method further comprises:
and performing database management on the XML document according to the database management operation of the user, wherein the database management comprises the maintenance operation on the XML document.
7. An XML-based data association apparatus, comprising:
the modeling module is used for obtaining demand modeling based on page configuration, the demand modeling comprises a plurality of operable controls, connecting lines among the operable controls form a control chain, and the connecting lines are corresponding relations among data;
the modeling module is specifically configured to: after a page creating instruction is received, responding to the page creating instruction, acquiring the identifier and the preview information of at least one page configuration template, and rendering the identifier and the preview information of the at least one page configuration template to generate a template selection page; performing appearance style, event binding, data source selection and/or jump link parameter configuration on each component;
the identification of the page configuration template is specifically the name of the page configuration template; the preview information of the page configuration template specifically includes: any one or more of partition composition of a page configuration template, available component types, usage scenario description information, keyword information, and page example link information created using the template;
the data acquisition module is used for acquiring first data input by a user at the operable control;
the processing module is used for processing the first data into an XML document and storing the XML document in a relational database;
the processing module is used for processing the first data into an XML document according to a preset algorithm and storing the XML document in a relational database, and the preset algorithm comprises integrated logic determined by a plurality of independent subtasks;
the processing the first data into an XML document according to a preset algorithm and storing the XML document in a relational database comprises the following steps: decomposing a preset algorithm into a plurality of independent subtasks, determining the integrated logic of each subtask, and formalizing the integrated logic into a query scheme, wherein the query scheme is expressed by a structured query language.
8. A server comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the XML-based data association method of any one of claims 1 to 6 when executing the computer program.
9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out an XML-based data association method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911157379.6A CN110889013B (en) | 2019-11-22 | 2019-11-22 | Data association method, device, server and storage medium based on XML |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911157379.6A CN110889013B (en) | 2019-11-22 | 2019-11-22 | Data association method, device, server and storage medium based on XML |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110889013A CN110889013A (en) | 2020-03-17 |
| CN110889013B true CN110889013B (en) | 2023-04-07 |
Family
ID=69748451
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911157379.6A Active CN110889013B (en) | 2019-11-22 | 2019-11-22 | Data association method, device, server and storage medium based on XML |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110889013B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112000330B (en) * | 2020-07-15 | 2023-12-22 | 北京百度网讯科技有限公司 | Configuration method, device, equipment and computer storage medium of modeling parameters |
| CN112559612A (en) * | 2020-12-15 | 2021-03-26 | 北京动力机械研究所 | Dynamic data extraction and sharing method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101110021A (en) * | 2002-03-25 | 2008-01-23 | 数据质量解决公司 | Method for visually programming instruction set for process |
| CN101984438A (en) * | 2010-11-27 | 2011-03-09 | 杭州万格网络科技有限公司 | Method of online self-help website establishment, creation of application service and development of online software |
| CN110377429A (en) * | 2019-07-24 | 2019-10-25 | 深圳乐信软件技术有限公司 | A kind of control method, device, server and storage medium that real-time task calculates |
Family Cites Families (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9171202B2 (en) * | 2005-08-23 | 2015-10-27 | Ricoh Co., Ltd. | Data organization and access for mixed media document system |
| CN101393517A (en) * | 2007-09-20 | 2009-03-25 | 上海宝信软件股份有限公司 | Method and apparatus for implementing collocation based on XML and control |
| CN101571800A (en) * | 2008-04-29 | 2009-11-04 | 中兴通讯股份有限公司 | Method and device for processing activex relation in control interface |
| CN101593207A (en) * | 2009-07-06 | 2009-12-02 | 孟智平 | The method and system of a kind of structure and generation webpage |
| CN102103491B (en) * | 2009-12-18 | 2013-11-06 | Tcl集团股份有限公司 | System and method for generating interface |
| CN102981855A (en) * | 2012-11-23 | 2013-03-20 | 蓝盾信息安全技术股份有限公司 | Template-based interface autogeneration method and system |
| KR102306149B1 (en) * | 2013-09-12 | 2021-09-28 | 윅스.컴 리미티드 | System and method for automated conversion of interactive sites and applications to support mobile and other display environments |
| CN104267962A (en) * | 2014-10-09 | 2015-01-07 | 浪潮通用软件有限公司 | Interface UI (user interface) control configuration method based on description |
| CN108038213A (en) * | 2017-12-21 | 2018-05-15 | 中国农业银行股份有限公司 | A kind of method of data processing, client, server and system |
| CN109783555B (en) * | 2018-12-13 | 2021-07-30 | 东软集团股份有限公司 | Form template storage method and device, storage medium and electronic equipment |
-
2019
- 2019-11-22 CN CN201911157379.6A patent/CN110889013B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101110021A (en) * | 2002-03-25 | 2008-01-23 | 数据质量解决公司 | Method for visually programming instruction set for process |
| CN101984438A (en) * | 2010-11-27 | 2011-03-09 | 杭州万格网络科技有限公司 | Method of online self-help website establishment, creation of application service and development of online software |
| CN110377429A (en) * | 2019-07-24 | 2019-10-25 | 深圳乐信软件技术有限公司 | A kind of control method, device, server and storage medium that real-time task calculates |
Non-Patent Citations (4)
| Title |
|---|
| D. Picard 等.The importance of sibling clustering for efficient bulkload of XML document trees.《in IEEE Signal Processing Magazine》.2015,95-102. * |
| P. Kreuger 等.Zero Configuration Adaptive Paging.《2012 IEEE Vehicular Technology Conference》.2012,1-5. * |
| 张晓宁.模型驱动的用户界面生成方法的研究.《中国优秀硕士学位论文全文数据库信息科技辑》.2010,(第(2010) 04期),I138-329. * |
| 林子雨 等.基于关系数据库的关键词查询.《软件学报》.2010,第21卷(第21期),2454-2476. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110889013A (en) | 2020-03-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11003645B1 (en) | Column lineage for resource dependency system and graphical user interface | |
| CN105144080B (en) | System for metadata management | |
| Karnitis et al. | Migration of relational database to document-oriented database: Structure denormalization and data transformation | |
| KR101644418B1 (en) | Visualizing relationships between data elements and graphical representations of data element attributes | |
| CN110781236A (en) | Method for constructing government affair big data management system | |
| US11526656B2 (en) | Logical, recursive definition of data transformations | |
| US8776009B2 (en) | Method and system for task modeling of mobile phone applications | |
| US20080208918A1 (en) | Efficient data handling representations | |
| US7720831B2 (en) | Handling multi-dimensional data including writeback data | |
| CN111427561A (en) | Service code generation method and device, computer equipment and storage medium | |
| US20120246519A1 (en) | Debugging data mappings | |
| US11276484B1 (en) | Clinical activity network generation | |
| US20140019889A1 (en) | Regenerating a user interface area | |
| CN110889013B (en) | Data association method, device, server and storage medium based on XML | |
| WO2023051125A1 (en) | Structured data version management method, apparatus, and related device | |
| CN113962597A (en) | Data analysis method and device, electronic equipment and storage medium | |
| US20210124752A1 (en) | System for Data Collection, Aggregation, Storage, Verification and Analytics with User Interface | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN114895875B (en) | Zero-code visual information system metadata production application method and system | |
| CN116244387A (en) | Entity relationship construction method, device, electronic equipment and storage medium | |
| CN116360766A (en) | Low-code system and device based on DDD visual designer | |
| US11526895B2 (en) | Method and system for implementing a CRM quote and order capture context service | |
| CN113971993A (en) | Clinical test data conversion method and device, computer equipment and storage medium | |
| CN117076515B (en) | Metadata tracing method and device in medical management system, server and storage medium | |
| WO2010119628A1 (en) | System and method for environment information aggregation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |