Disclosure of Invention
It is a primary objective of the present application to provide a data management and design system to improve the problems of the related art.
In order to achieve the above object, the present application provides a data management and design system, comprising:
a central processing module; the central database is used for managing the call connection between the modules in charge of the whole exchange system and managing the relay resources and various shared resources by constructing the central database;
a file new building module; the file new building module is used for building new data;
a file opening module; the file opening module is used for opening an original data group;
a file export module; for exporting edited data to a new location;
a file saving module; for saving the file.
Exiting the module; the user logs out of the system.
In one embodiment of the application, the system further comprises a profile module, wherein the profile module comprises a system introduction unit and an announcement unit;
the system introduction unit is used for explaining the relevant information of the system;
the announcement unit is used for issuing the real-time information related to the system.
In an embodiment of the present application, the file new creation module includes a surface layer unit and a related unit;
the surface layer unit is used for storing address information of data; the related unit is used for storing the content of the data.
The surface layer unit and the related units are mutually related and in one-to-one correspondence.
In one embodiment of the present application, a file opening module includes a first opening unit and a second opening unit;
the first opening unit selects and utilizes the existing data source, the connection is carried out through the IP address, the port, the user name and the password, information under the data source can be read after the connection is successful, and the corresponding table structure and the relevant information are displayed through the data source information.
Illustratively, the first opening unit may open the file by means of Mysql or maridb or Redis;
specifically, Mysql and MariaDB are opened for use through a PDM file; redis opens a file by popping the box address, port and password link.
The second opening unit is opened and used through a PDM format file exported from the Power Designer, so that data intercommunication with the Power Designer can be maintained.
In an embodiment of the present application, the second opening unit specifically comprises the following steps:
s1, the user selects a Power Designer to export the PDM file by using the system to open;
s2, the system analyzes the PDM file;
s3, obtaining a Document object after the file is successfully analyzed;
s4, acquiring a root Element through the Document object;
s5, acquiring all data source attributes and incidence relations in the whole PDM file through the root Element, and packaging;
and S6, after the analysis is successful, drawing all the obtained data source information to a system main panel, wherein the user can see the data source information in the Power Designer and then use the data source information in the system.
In one embodiment of the present application, the file saving module includes a timer and an auto-save unit;
the timer is in signal connection with the automatic saving unit;
the automatically saved interval may be adjusted by adjusting the setting of the timer.
When the interval time of automatic saving is set to be saved once in a few seconds, the real-time automatic saving of the editing process can be realized, and the saving to the local is supported.
In an embodiment of the application, the file saving module includes a data link module, and is configured to make a call with a linked data source service after the editing is completed, perform automatic saving in real time (after the attribute structure is edited), and save after the editing is reduced and in manual operation.
And after editing, the edited data source can be saved as a file through 'file saving' operation in the menu so as to be freely exported.
In an embodiment of the present application, the file saving module further includes a sorting unit, a matching unit, and a retrieving unit;
the sorting unit is used for sorting the data;
specifically, the sorting may be performed by time or by file size.
The matching unit is used for sorting and matching related data, dragging a plurality of data tables, modifying the association relationship among the tables, sorting the associated files together and facilitating calling.
The retrieval unit is used for retrieving the file.
Illustratively, the search can be performed by including time, and the search can also be performed by keywords.
In an embodiment of the application, the data saving module further includes a database server, and the edited data source information is automatically saved to the database server, so that the edited data source information can be synchronously seen in real time no matter which tool is used by a user to open the data source.
In an embodiment of the present application, the file export module includes a mode selection unit, and the mode selection unit can select an export mode to be saved locally;
the user selects to export the pdm file, and can also select Power Designer to open or the system to open when the pdm file is used next time; if export is selected;
and the user selects to export the html file, the html file can be directly opened and viewed in the browser next time, and the system can be directly displayed by using the data source information in a webpage mode.
Compared with the prior art, the beneficial effects of this application are: through the designed data management and design system, when in use, the currently edited data source is backed up in multiple formats, and the edited data source is automatically stored, so that the user operation is reduced; the cross-platform use capacity is enhanced, and customized development meets the requirements of users;
the cost of using time can be reduced; the data source can be managed more conveniently and effectively.
Detailed Description
In order to make the technical solutions better understood by those skilled in the art, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only partial embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that the terms "first," "second," and the like in the description and claims of this application and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It should be understood that the data so used may be interchanged under appropriate circumstances such that embodiments of the application described herein may be used. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In this application, the terms "upper", "lower", "left", "right", "front", "rear", "top", "bottom", "inner", "outer", "middle", "vertical", "horizontal", "lateral", "longitudinal", and the like indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings. These terms are used primarily to better describe the present application and its embodiments, and are not used to limit the indicated devices, elements or components to a particular orientation or to be constructed and operated in a particular orientation.
Moreover, some of the above terms may be used to indicate other meanings besides the orientation or positional relationship, for example, the term "on" may also be used to indicate some kind of attachment or connection relationship in some cases. The specific meaning of these terms in this application will be understood by those of ordinary skill in the art as appropriate.
In addition, the term "plurality" shall mean two as well as more than two.
It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict. The present application will be described in detail below with reference to the embodiments with reference to the attached drawings.
Example 1
Referring to fig. 1-6, the present application provides a data management and design system, comprising:
a central processing module; the central database is used for managing the call connection between the modules in charge of the whole exchange system and managing the relay resources and various shared resources by constructing the central database;
a file new building module; the file new building module is used for building new data;
a file opening module; the file opening module is used for opening an original data group;
a file export module; for exporting edited data to a new location;
a file saving module; for saving the file.
Exiting the module; the user logs out of the system.
The system also comprises a profile module, wherein the profile module comprises a system introduction unit and an announcement unit;
the system introduction unit is used for explaining the relevant information of the system;
the announcement unit is used for issuing the real-time information related to the system.
Further, the file new building module comprises a surface layer unit and a related unit;
the surface layer unit is used for storing address information of data; the related unit is used for storing the content of the data.
The surface layer unit and the related units are mutually related and in one-to-one correspondence.
Further, the file opening module comprises a first opening unit and a second opening unit;
the first opening unit selects and utilizes the existing data source, the connection is carried out through the IP address, the port, the user name and the password, information under the data source can be read after the connection is successful, and the corresponding table structure and the relevant information are displayed through the data source information.
Illustratively, the first opening unit may open the file by means of Mysql or maridb or Redis;
specifically, Mysql and MariaDB are opened for use through a PDM file; redis opens a file by popping the box address, port and password link.
The second opening unit is opened and used through a PDM format file exported from the Power Designer, so that data intercommunication with the Power Designer can be maintained.
Specifically, the second opening unit includes the steps of:
s1, the user selects a Power Designer to export the PDM file by using the system to open;
s2, the system analyzes the PDM file;
s3, obtaining a Document object after the file is successfully analyzed;
s4, acquiring a root Element through the Document object;
s5, acquiring all data source attributes and incidence relations in the whole PDM file through the root Element, and packaging;
and S6, after the analysis is successful, drawing all the obtained data source information to a system main panel, wherein the user can see the data source information in the Power Designer and then use the data source information in the system.
Specifically, the file saving module comprises a timer and an automatic saving unit;
the timer is in signal connection with the automatic saving unit;
the automatically saved interval may be adjusted by adjusting the setting of the timer.
When the interval time of automatic saving is set to be saved once in a few seconds, the real-time automatic saving of the editing process can be realized, and the saving to the local is supported.
Furthermore, the file storage module also comprises a sorting unit, a matching unit and a retrieval unit;
the sorting unit is used for sorting the data;
specifically, the sorting may be performed by time or by file size.
The matching unit is used for sorting and matching related data, dragging a plurality of data tables, modifying the association relationship among the tables, sorting the associated files together and facilitating calling.
The retrieval unit is used for retrieving the file.
Illustratively, the search can be performed by including time, and the search can also be performed by keywords.
Furthermore, the data storage module also comprises a database server, the edited data source information is automatically stored in the database server, and the edited data source information can be synchronously seen in real time no matter which tools are used by a user to open the data source.
Specifically, the file export module comprises a mode selection unit, and the mode selection unit can select an export mode to store the export mode to the local;
the user selects to export the pdm file, and can also select Power Designer to open or the system to open when the pdm file is used next time; if export is selected;
and the user selects to export the html file, the html file can be directly opened and viewed in the browser next time, and the system can be directly displayed by using the data source information in a webpage mode.
Example 2
Referring to fig. 1, fig. 2, fig. 3, fig. 4, fig. 5 and fig. 7, the present application provides a data management and design system, including:
a central processing module; the central database is used for managing the call connection between the modules in charge of the whole exchange system and managing the relay resources and various shared resources by constructing the central database;
a file new building module; the file new building module is used for building new data;
a file opening module; the file opening module is used for opening an original data group;
a file export module; for exporting edited data to a new location;
a file saving module; for saving the file.
Exiting the module; the user logs out of the system.
The system also comprises a profile module, wherein the profile module comprises a system introduction unit and an announcement unit;
the system introduction unit is used for explaining the relevant information of the system;
the announcement unit is used for issuing the real-time information related to the system.
Further, the file new building module comprises a surface layer unit and a related unit;
the surface layer unit is used for storing address information of data; the related unit is used for storing the content of the data.
The surface layer unit and the related units are mutually related and in one-to-one correspondence.
Further, the file opening module comprises a first opening unit and a second opening unit;
the first opening unit selects and utilizes the existing data source, the connection is carried out through the IP address, the port, the user name and the password, information under the data source can be read after the connection is successful, and the corresponding table structure and the relevant information are displayed through the data source information.
Illustratively, the first opening unit may open the file by means of Mysql or maridb or Redis;
specifically, Mysql and MariaDB are opened for use through a PDM file; redis opens a file by popping the box address, port and password link.
The second opening unit is opened and used through a PDM format file exported from the Power Designer, so that data intercommunication with the Power Designer can be maintained.
Specifically, the second opening unit includes the steps of:
s1, the user selects a Power Designer to export the PDM file by using the system to open;
s2, the system analyzes the PDM file;
s3, obtaining a Document object after the file is successfully analyzed;
s4, acquiring a root Element through the Document object;
s5, acquiring all data source attributes and incidence relations in the whole PDM file through the root Element, and packaging;
and S6, after the analysis is successful, drawing all the obtained data source information to a system main panel, wherein the user can see the data source information in the Power Designer and then use the data source information in the system.
Specifically, the file saving module comprises a timer and an automatic saving unit;
specifically, the file storage module comprises a data link module, and is used for communicating with a linked data source service after editing is completed, automatically storing the data source service in real time (after an attribute structure is edited), and reducing manual operation for storing the data source service after editing.
And after editing, the edited data source can be saved as a file through 'file saving' operation in the menu so as to be freely exported.
Furthermore, the file storage module also comprises a sorting unit, a matching unit and a retrieval unit;
the sorting unit is used for sorting the data;
specifically, the sorting may be performed by time or by file size.
The matching unit is used for sorting and matching related data, dragging a plurality of data tables, modifying the association relationship among the tables, sorting the associated files together and facilitating calling.
The retrieval unit is used for retrieving the file.
Illustratively, the search can be performed by including time, and the search can also be performed by keywords.
Furthermore, the data storage module also comprises a database server, the edited data source information is automatically stored in the database server, and the edited data source information can be synchronously seen in real time no matter which tools are used by a user to open the data source.
Specifically, the file export module comprises a mode selection unit, and the mode selection unit can select an export mode to store the export mode to the local;
the user selects to export the pdm file, and can also select Power Designer to open or the system to open when the pdm file is used next time; if export is selected;
and the user selects to export the html file, the html file can be directly opened and viewed in the browser next time, and the system can be directly displayed by using the data source information in a webpage mode.
It should be noted that:
the database system is a system consisting of a database and management tool software thereof. The system mainly comprises an operating system, various programming languages, a utility program, a data management system and the like. The database is managed by the management system in a unified way, and a system administrator is responsible for creating, monitoring and maintaining the whole database, so that the data can be used by any person with authority. The database system is a milestone of computer application, which makes the computer application turn from science and technology computing to data processing, shields complex database bottom logic for users, provides simple and easy-to-use database language, completes the operation of the database by a database management system, and the database independently exists in a specific application program and shares data for a plurality of users. Therefore, the database system has independence and sharing performance, is simple and easy to use, and users can conveniently store daily data into the computer and quickly access the daily data when needed, so that the computer can be widely used in various industries and families.
The database management tool is specially designed for simplifying the management of a database and reducing the cost of a database management system, and is usually displayed by an intuitive graphical interface, so that a user can create, use and access data information safely and simply, and meanwhile, a professional can conveniently understand a model and make the model more intuitively in the database modeling process.
The above description is only a preferred embodiment of the present application and is not intended to limit the present application, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.