CN103729451B - A kind of information input method of database, apparatus and system - Google Patents
A kind of information input method of database, apparatus and system Download PDFInfo
- Publication number
- CN103729451B CN103729451B CN201310754528.3A CN201310754528A CN103729451B CN 103729451 B CN103729451 B CN 103729451B CN 201310754528 A CN201310754528 A CN 201310754528A CN 103729451 B CN103729451 B CN 103729451B
- Authority
- CN
- China
- Prior art keywords
- information
- operation system
- server
- logged
- metadata
- 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
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Abstract
The embodiments of the invention provide a kind of database information input method, apparatus and system, to solve when repository is independently disposed, if the operation system of synchronization request service is excessive, the problem of interface capability of repository deteriorates may be caused.Wherein, the information input method of database, including：The typing of operation system receive information is asked；The metadata that the operation system is stored according to itself, generation Data Enter interface；Described information input interface is presented in the operation system；The operation system receives information to be logged by described information input interface；The information to be logged received is sent to the server for carrying database by the operation system, for making the server by the information storage to be logged into the database of itself carrying.
Description
Technical field
The present invention relates to areas of information technology, more particularly to a kind of information input method of database, apparatus and system.
Background technology
In information technology（IT, Information Technology）In field, with the progress and development of IT technologies, enterprise
The IT environment of industry becomes increasingly complex.Substantial amounts, information technoloy equipment various in style are difficult effectively to be managed, and are managed with these IT
Various IT services based on equipment are then increasingly complex.Meanwhile, the IT environment of enterprise is being continually changing, and how to assess some equipment
Or the influence caused by the accident of service generation or change, and how to provide IT resources newest configuration information for other flows
All it is the significant challenge that enterprise faces.Configuration management database（CMDB, Configuration Management Database）
Precisely in order to solving these following problems and being born.
The various configuration informations of equipment in CMDB storage and management enterprise IT architectures, it is handed over all service supports and service
Pay flow to be all closely linked to, support the operating of these flows, play the value of configuration information, while ensureing dependent on related procedure
The accuracy of data.In actual project, CMDB is often thought of as building other information technical foundation framework storehouse（ITIL,
Information Technology Infrastructure Library）Flow basis and pay the utmost attention to, ITIL projects
Whether success or failure are with being successfully established CMDB and having very big relation.
70%~80% IT relevant issues and the change of environment have direct relation.Implement the difficult point and again of change management
Point is not instrument, but flow.Workflow management automated by one, repeatable is changed so that when change occurs
When, the flow for having a standardization goes to perform, and can predict this change and manage whole system the influence produced, and
These influences are estimated and controlled.And the realization key of change management process automation is exactly CMDB.
Current many enterprises have all been proposed the repository of main flow, repository functional structure as shown in figure 1, including first number
It is investigated that inquiry, instance data inquiry, model definition, configuration association, dynamic, structured query language（SQL, Structured Query
Language）Generation inquiry, configuration change management and connection database（DB, Database）.
When repository is independently disposed, service interface is provided simultaneously to multiple operation systems, as shown in Fig. 2 realizing multi-service
During data sharing between system, when synchronization asks the operation system of service excessive, due to the place of the server of repository
Reason is limited in one's ability, and this can cause the interface capability of repository to deteriorate.
In summary, at present when repository is independently disposed, if the operation system of synchronization request service is excessive, due to
The disposal ability of the server of repository is limited, and this can cause the interface capability of repository to deteriorate.
The content of the invention
The embodiments of the invention provide a kind of method of database information typing, apparatus and system, to solve when configuration
When storehouse is independently disposed, if the operation system of synchronization request service is excessive, the interface capability of repository may be caused to dislike
The problem of change.
First aspect there is provided a kind of information input method of database, including：
The typing of operation system receive information is asked；
The metadata that the operation system is stored according to itself, generation Data Enter interface；
Described information input interface is presented in the operation system；
The operation system receives information to be logged by described information input interface；
The information to be logged received is sent to the server for carrying database by the operation system, for making
State in the database that server carries the information storage to be logged to itself.
With reference in a first aspect, in the first possible implementation, operation system receive information typing request, including：
Business module receive information typing request in the operation system；
The metadata that the operation system is stored according to itself, generation Data Enter interface, including：
Client modules of the business module into the operation system send the request for obtaining metadata；The business
Module generates Data Enter interface after the metadata that the client modules are returned is received according to the metadata；It is described
The metadata that client modules are returned is the metadata of the operation system itself storage；
Described information input interface is presented in the operation system, including：
Described information input interface is presented in the business module；
The operation system receives information to be logged by described information input interface, including：
The business module receives information to be logged by the Data Enter interface of presentation, and by the letter to be logged received
Breath submits to the client modules；
The information to be logged received is sent to the server by the operation system, including：
The information to be logged that the business module is submitted is sent to the server by the client modules.
The first possible implementation with reference to first aspect, in second of possible implementation, in the client
The information that the business module is submitted is sent to before the server by end module, and methods described also includes：
The business module sends to log in the server and asked after the instruction for starting the client modules is received
Ask, the logging request includes the identity information of the operation system；
The business module is authenticated in the server according to the identity information of the operation system to the operation system
After success, trigger the operation system and log in the server.
The first possible implementation with reference to first aspect, in the third possible implementation, the client
Metadata is returned to the business module by module after the request for the acquisition metadata that the business module is sent is received
Before, in addition to：
The client modules determine that the operation system has the authority for receiving Data Enter.
The first possible implementation with reference to first aspect, in the 4th kind of possible implementation, the client
The information to be logged that the business module is submitted is sent to before the server by module, in addition to：
The client modules determine that the operation system has the authority for submitting information to be logged.
The first possible implementation with reference to first aspect, in the 5th kind of possible implementation, the client
The information to be logged that the business module is submitted is sent to the server by module, is specifically included：
The information to be logged that the business module is submitted is converted to SQL SQL tables by the client modules
The information stated, and it is sent to the server.
With reference in a first aspect, in the 6th kind of possible implementation, the metadata of operation system storage is the business system
System is when logging in the server, and the server is generated according to data model current in the database itself carried, and is returned
Back to the operation system；Or, when data model of the server in the database that itself is carried updates, root
The metadata is generated according to the data model after renewal, and returns to each operation system for having logged in the server.
Second aspect there is provided a kind of Data Enter device of database, including：
First receiving module, for receive information typing request；
Generation module, for the metadata stored according to operation system, generation Data Enter interface；
Module is presented, for described information input interface to be presented；
Second receiving module, for receiving information to be logged by described information input interface；
Transport module, for the information to be logged received to be sent to the server for carrying database, for making
The server is by the information storage to be logged into the database of itself carrying.
With reference to second aspect, in the first possible implementation, the generation module specifically for：
After the first receiving module receives Data Enter request, the client modules into operation system, which are sent, obtains member
The request of data；And after the metadata that the client modules are returned is received, Data Enter is generated according to the metadata
Interface；
Second receiving module specifically for：
Information to be logged is received by the Data Enter interface of presentation, and the information to be logged received submitted to described
Client modules；
The transport module specifically for：
The information to be logged that business module in the operation system is submitted is sent to the server.
The first possible implementation with reference to second aspect, in second of possible implementation, the transmission mould
Block is additionally operable to：
Before the information for submitting the business module is sent to the server, the client is started receiving
After the instruction of module, logging request is sent to the server, the logging request includes the identity letter of the operation system
Breath；
Described device also includes trigger module, and the trigger module is used for：
After the server is authenticated successfully according to the identity information of the operation system to the operation system, institute is triggered
State operation system and log in the server.
The first possible implementation with reference to second aspect, in the third possible implementation, described device is also
Module is identified including the first authority, the first authority identification module is used for：
After the request for the acquisition metadata that the business module in receiving the operation system is sent, metadata is returned
Before the business module, determine that the operation system has the authority of receive information typing.
The first possible implementation with reference to second aspect, in the 4th kind of possible implementation, described device is also
Module is identified including the second authority, the second authority identification module is used for：
Before the information to be logged for submitting the business module is sent to the server, the operation system is determined
There is the authority for submitting typing information.
The first possible implementation with reference to second aspect, in the 5th kind of possible implementation, the transmission mould
Block specifically for：
The information to be logged that the business module is submitted is converted to the information of SQL SQL statements, concurrently
Give the server.
The third aspect there is provided a kind of Message Entry System of database, including：
Operation system, for after Data Enter request is received, Data Enter to be generated according to the metadata itself stored
Interface, and described information input interface is presented, and by described information input interface reception information to be logged, and will receive
To information to be logged be sent to server for carrying database；
The server, is arrived certainly for receiving the information to be logged that the operation system is sent, and by described information storage
The database of body carrying.
With reference to the third aspect, in the first possible implementation, the operation system specifically for：
After Data Enter request is received, Data Enter interface is generated according to the metadata itself stored, and institute is presented
State Data Enter interface, and receive by described information input interface information to be logged, and by the letter to be logged received
Breath is converted to the information of SQL SQL statements, and is sent to the server.
The beneficial effect of the embodiment of the present invention includes：
Information input method, the apparatus and system of a kind of database provided in an embodiment of the present invention, by operation system
Middle storage metadata so that after Data Enter request is received, can be presented Data Enter according to the metadata itself stored
Interface, without per it is secondary use metadata when, all obtain, so as to reduce the number of times with server interaction, drop from server
The busy extent of low server, reduction occurs what is deteriorated due to the limited interface capability for causing repository of the disposal ability of server
Probability.
Brief description of the drawings
Fig. 1 is the structural representation of repository in the prior art；
Structural representation when Fig. 2 is multiple operation system shared database in the prior art；
Fig. 3 is one of flow chart of method of Data Enter of database provided in an embodiment of the present invention；
Fig. 4 is the two of the flow chart of the method for the Data Enter of database provided in an embodiment of the present invention；
Fig. 5 is the three of the flow chart of the method for the Data Enter of database provided in an embodiment of the present invention；
Fig. 6 is one of flow chart of method of operation system login service device provided in an embodiment of the present invention；
Fig. 7 is the four of the flow chart of the method for the Data Enter of database provided in an embodiment of the present invention；
The structural representation for the repository that Fig. 8 runs for the method for the Data Enter of database provided in an embodiment of the present invention
Figure；
Fig. 9 is the six of the flow chart of the information input method of database provided in an embodiment of the present invention；
Figure 10 is one of structure chart of Data Enter device of database provided in an embodiment of the present invention；
Figure 11 is the two of the structure chart of the Data Enter device of database provided in an embodiment of the present invention；
Figure 12 is the three of the structure chart of the Data Enter device of database provided in an embodiment of the present invention；
Figure 13 is the four of the structure chart of the Data Enter device of database provided in an embodiment of the present invention；
Figure 14 is the structure chart of the Message Entry System of database provided in an embodiment of the present invention.
Embodiment
Information input method, the apparatus and system of a kind of database provided in an embodiment of the present invention, by operation system
Middle storage metadata so that every time when needing to use metadata, it is not necessary to obtained from server, so as to reduce and server interaction
Number of times, reduce server busy extent, reduction cause the interface capability of repository because the disposal ability of server is limited
There is the probability deteriorated.
With reference to Figure of description, to a kind of information input method of database provided in an embodiment of the present invention, device
And the embodiment of system is illustrated.
The information input method of a kind of database provided in an embodiment of the present invention, as shown in figure 3, specifically including following step
Suddenly：
S301, operation system receive information typing request；
The metadata that S302, the operation system are stored according to itself, generation Data Enter interface；
Described information input interface is presented in S303, the operation system；
S304, the operation system receive information to be logged by described information input interface；
The information to be logged received is sent to the server for carrying database by S305, the operation system, is used for
Make the server by the information storage to be logged into the database of itself carrying.
Alternatively, S301 is specifically included：Business module receive information typing request in the operation system；
S302 is specifically included：Client modules of the business module into the operation system, which are sent, obtains metadata
Request；The business module generates information after the metadata that the client modules are returned is received according to the metadata
Input interface；The metadata that the client modules are returned is the metadata of the operation system itself storage；
S303 is specifically included：Described information input interface is presented in the business module；
S304 is specifically included：The business module receives information to be logged by the Data Enter interface of presentation, and will connect
The information to be logged received submits to the client modules；
S305 is specifically included：The information to be logged that the business module is submitted is sent to the clothes by the client modules
Business device.
That is, when operation system includes business module and client modules, data provided in an embodiment of the present invention
The information input method in storehouse, as shown in figure 4, including：
S401, business module receive information typing request；
S402, business module send the request for obtaining metadata to client modules；
S403, client modules receive the request for the acquisition metadata that business module is sent；
S404, client modules will return to the business module by its metadata of storage into operation system；
S405, business module are received after the metadata of client modules return, and Data Enter is presented according to the metadata
Interface；
S406, business module by the Data Enter interface of presentation after information to be logged is received, by what is received
Information to be logged submits to client modules；
The information to be logged that business module is submitted is sent to server by S407, client modules.
Client modules wherein in operation system can be with Java archive file（Jar, Java Archive）The side of bag
Formula is realized, is used in order to which operation system is integrated, realizes the server module in the server of carrying database and multiple clients
The interaction that end module is given advice.
Alternatively, client modules are after the request of acquisition metadata of business module transmission is received, by metadata
Before returning to the business module, in addition to：Client modules determine that the operation system has the authority for receiving Data Enter.
Alternatively, the information that the business module is submitted is sent to before the server by client modules, in addition to：
Client modules determine that the operation system has the authority for the information for submitting typing.
It therefore, it can make a distinction the access right of operation system by the client modules being integrated in operation system,
The information input method of database provided in an embodiment of the present invention, as shown in figure 5, including：
S401, business module receive information typing request；
S402, business module send the request for obtaining metadata to client modules；
S403, client modules receive the request for the acquisition metadata that business module is sent；
S403a, client modules determine that operation system has the authority for receiving Data Enter；
S404, client modules will return to the business module by its metadata of storage into operation system；
S405, business module are received after the metadata of client modules return, and Data Enter is presented according to the metadata
Interface；
S406, business module by the Data Enter interface of presentation after information to be logged is received, by treating for receiving
Typing information submits to client modules；
S406a, client modules determine that business system has the authority for submitting information to be logged；
The information to be logged that business module is submitted is sent to server by S407, client modules.
Further, client modules by the information to be logged that the business module is submitted be sent to the server it
Before, operation system needs to log in the server of carrying database, to avoid the information in database from arbitrarily being changed.Operation system
The process of login service device as shown in fig. 6, including：
Business module in S601, operation system is sent after the instruction for starting client modules is received to server
Logging request, logging request includes the identity information of the operation system；
S602, the business module are authenticated successfully in server according to the identity information of the operation system to the operation system
Afterwards, trigger the operation system and log in the server.
Alternatively, the information input method of a kind of database provided in an embodiment of the present invention, as shown in fig. 7, S305 is specific
Including：
The information to be logged that business module is submitted is converted to SQL SQL statements by S3051, client modules
Information；
Information after conversion is sent to server by S3052, client modules.
Because operation system can realize dynamic generation SQL（SQL, Structured Query
Language）The function of sentence, therefore, in operation system and server interaction, server only needs to the SQL languages according to generation
Sentence is operated to database, and without generating SQL statement, this further mitigates the busy extent of server, enters one
Step is reduced causes the interface capability of repository the probability deteriorated occur because the disposal ability of server is limited.
Certainly, in actual applications, can also in operation system only integrated dynamic generation SQL statement function, it is not necessary to
Metadata is stored in operation system, when operation system needs metadata, is obtained every time from server.In operation system
In the function of integrated dynamic generation SQL statement can be realized in the way of Jar bags, the integrated storage metadata in operation system
Function can realize in the way of Jar bags, the function of integrated storage metadata, dynamic generation SQL statement in operation system
The function that function and access right to operation system are controlled can be realized in the way of Jar bags, so as to facilitate other
The integrated reference of operation system.
Alternatively, the metadata of operation system storage is that the operation system is logging in the server for carrying database
When, the server is generated according to data model current in the database itself carried, and returns to the operation system.
Alternatively, the metadata of operation system storage is data model of the server in the database that itself is carried
When updating, metadata is generated according to the data model after renewal, and return to each business system for having logged in the server
System.
If being integrated with the function of dynamic generation SQL statement in operation system, then server only needs to perform SQL statement i.e.
Can, i.e., the information that server is received is stated with SQL statement.If not integrated dynamic generation SQL statement in operation system
Function, then the information that server also needs to receive is converted to the information stated with SQL statement, can just be stored to number
According in storehouse.
When the function of integrated storage metadata, the function of dynamic generation SQL statement in operation system and to operation system
Access right be controlled function when, the function of repository is realized in two entities, as shown in figure 8, a part in industry
Realized in business system, referred to as client modules, a part is realized in the server, referred to as server module.
Below with the function of integrated storage metadata, the function of dynamic generation SQL statement in operation system and to industry
Illustrate exemplified by the function that the access right of business system is limited during the Data Enter of database, operation system and service
The process of device interaction, as shown in figure 9, the process includes：
S901, client modules start after enabled instruction is received；
S902, client modules are sent to server by operation system and business system are included in logging request, logging request
The identity information of system；
S903, server are after the logging request of operation system transmission is received, according to identity information therein to business
System is authenticated；
S904, server are after authenticating successfully, it is allowed to which operation system is logged in；
S905, server send the metadata generated according to current data model to operation system；
The metadata that operation system is received is stored in operation system by S906, client modules；
S907, business module receive information typing request；
S908, business module send the request for obtaining metadata to client modules；
S909, client modules receive the request for the acquisition metadata that business module is sent；
S910, client modules determine that operation system has the authority for receiving Data Enter；
The metadata that S911, client modules are stored in operation system returns to the business module；
S912, business module are received after the metadata of client modules return, and Data Enter is presented according to the metadata
Interface；
S913, business module by the Data Enter interface of presentation after information to be logged is received, by treating for receiving
Typing information submits to client modules；
S914, client modules determine that business system has the authority for submitting typing information, and the information to be logged of submission is turned
It is changed to the information of SQL descriptions；
The information that S915, client modules are converted into SQL descriptions is sent to server.
Based on same inventive concept, the embodiment of the present invention additionally provides a kind of Data Enter apparatus and system of database,
By the principle that these device and system solve problem is similar to the information input method in aforementioned data storehouse, thus the device and
The implementation of system may refer to the implementation of preceding method, repeats part and repeats no more.
The Data Enter device of database provided in an embodiment of the present invention, as shown in Figure 10, including：
First receiving module 101, for receive information typing request；
Generation module 102, for the metadata stored according to operation system, generation Data Enter interface；
Module 103 is presented, for described information input interface to be presented；
Second receiving module 104, for receiving information to be logged by described information input interface；
Transport module 105, for the information to be logged received to be sent to the server for carrying database, is used for
Make the server by the information storage to be logged into the database of itself carrying.
Alternatively, generation module 102, specifically for after the first receiving module receives Data Enter request, to business
Client modules in system send the request for obtaining metadata；And receiving the metadata that the client modules are returned
Afterwards, Data Enter interface is generated according to the metadata；
Second receiving module 104, receives information to be logged, and will connect specifically for the Data Enter interface by presentation
The information to be logged received submits to client modules；
Transport module 105, is sent to specifically for the information to be logged for submitting the business module in the operation system
The server.
Alternatively, transport module 105, be additionally operable to the information for submitting the business module be sent to the server it
Before, after the instruction for starting the client modules is received, sent to the server in logging request, the logging request
Include the identity information of the operation system；
The Data Enter device of database provided in an embodiment of the present invention, as shown in figure 11, in addition to trigger module 106,
For：After the server is authenticated successfully according to the identity information of operation system to the operation system, the business system is triggered
System logs in the server.
Alternatively, the Data Enter device of database provided in an embodiment of the present invention, as shown in figure 12, in addition to the first power
Limit identification module 107, is used for：, will after the request for the acquisition metadata that the business module in receiving operation system is sent
Metadata is returned to before the business module, determines that the operation system has the authority of receive information typing.
Alternatively, the Data Enter device of database provided in an embodiment of the present invention, as shown in figure 13, in addition to the second power
Limit identification module 108, is used for：By in operation system business module submit information to be logged be sent to the server it
Before, determine that the operation system has the authority for submitting typing information.
Alternatively, transport module 105, structuralized query language is converted to specifically for the information for submitting the business module
The information of SQL statements is sayed, and is sent to the server.
The Message Entry System of database provided in an embodiment of the present invention, as shown in figure 14, including：
Operation system 141, for after Data Enter request is received, according to the metadata generation information record itself stored
Enter interface, and the Data Enter interface is presented, and information to be logged is received by the Data Enter interface of presentation, and will connect
The information to be logged received is sent to the server for carrying database；
Server 142, data are arrived for receiving the information to be logged that the operation system is sent, and by described information storage
Storehouse.
Alternatively, operation system 141, specifically for after Data Enter request is received, according to first number of itself storage
According to generation Data Enter interface, and the Data Enter interface is presented, and receives to be logged by the Data Enter interface of presentation
Information, and the information to be logged received is converted to the information of SQL SQL statements, and SQL stated
Information be sent to server.
Through the above description of the embodiments, those skilled in the art can be understood that the embodiment of the present invention
It can be realized by hardware, the mode of necessary general hardware platform can also be added to realize by software.Based on such reason
Solution, the technical scheme of the embodiment of the present invention can be embodied in the form of software product, and the software product can be stored in one
Individual non-volatile memory medium（Can be CD-ROM, USB flash disk, mobile hard disk etc.）In, including some instructions are to cause a meter
Calculate machine equipment（Can be personal computer, server, or network equipment etc.）Perform the side described in each embodiment of the invention
Method.
It will be appreciated by those skilled in the art that accompanying drawing is the schematic diagram of a preferred embodiment, module or stream in accompanying drawing
Journey is not necessarily implemented necessary to the present invention.
It will be appreciated by those skilled in the art that the module in device in embodiment can be divided according to embodiment description
It is distributed in the device of embodiment, respective change can also be carried out and be disposed other than in one or more devices of the present embodiment.On
The module for stating embodiment can be merged into a module, can also be further split into multiple submodule.
The embodiments of the present invention are for illustration only, and the quality of embodiment is not represented.
Obviously, those skilled in the art can carry out the essence of various changes and modification without departing from the present invention to the present invention
God and scope.So, if these modifications and variations of the present invention belong to the scope of the claims in the present invention and its equivalent technologies
Within, then the present invention is also intended to comprising including these changes and modification.
Claims (14)
1. a kind of information input method of database, it is characterised in that including：
The typing of operation system receive information is asked；
The metadata that the operation system is stored according to itself, generation Data Enter interface, the metadata is in the business
In the database that the server carry according to the server when system login is used to carry the server of database currently
Data model is generated and returned to the operation system, or the metadata is for carrying the server of database certainly
Data model in the database of body carrying is generated and returned to according to the data model after renewal when updating and has logged in institute
State each operation system of server；
Described information input interface is presented in the operation system；
The operation system receives information to be logged by described information input interface；
The information to be logged received is sent to the server by the operation system, for making the server be treated described
The storage of typing information is into the database of itself carrying.
2. the method as described in claim 1, it is characterised in that the typing of operation system receive information is asked, including：
Business module receive information typing request in the operation system；
The metadata that the operation system is stored according to itself, generation Data Enter interface, including：
Client modules of the business module into the operation system send the request for obtaining metadata；The business module
After the metadata that the client modules are returned is received, Data Enter interface is generated according to the metadata；The client
The metadata that end module is returned is the metadata of the operation system itself storage；
Described information input interface is presented in the operation system, including：
Described information input interface is presented in the business module；
The operation system receives information to be logged by described information input interface, including：
The business module receives information to be logged by the Data Enter interface of presentation, and the information to be logged received is carried
Give the client modules；
The information to be logged received is sent to the server by the operation system, including：
The information to be logged that the business module is submitted is sent to the server by the client modules.
3. method as claimed in claim 2, it is characterised in that the letter for submitting the business module in the client modules
Breath is sent to before the server, and methods described also includes：
The business module sends logging request after the instruction for starting the client modules is received to the server,
The logging request includes the identity information of the operation system；
The business module is authenticated successfully in the server according to the identity information of the operation system to the operation system
Afterwards, trigger the operation system and log in the server.
4. method as claimed in claim 2, it is characterised in that the client modules are receiving the business module transmission
Acquisition metadata request after, before metadata returned into the business module, in addition to：
The client modules determine that the operation system has the authority for receiving Data Enter.
5. method as claimed in claim 2, it is characterised in that the client modules record treating of submitting of the business module
Enter information to be sent to before the server, in addition to：
The client modules determine that the operation system has the authority for submitting information to be logged.
6. method as claimed in claim 2, it is characterised in that the client modules record treating of submitting of the business module
Enter information and be sent to the server, specifically include：
The information to be logged that the business module is submitted is converted to SQL SQL statements by the client modules
Information, and it is sent to the server.
7. a kind of Data Enter device of database, it is characterised in that including：
First receiving module, for receive information typing request；
Generation module, for the metadata stored according to operation system, generation Data Enter interface, the metadata is described
Operation system log in the database that the server during server for carrying database is carried according to the server when
Preceding data model is generated and returned to the operation system, or the metadata is the server for carrying database
Data model in the database of itself carrying is generated and returned to according to the data model after renewal when updating and stepped on
Record each operation system of the server；
Module is presented, for described information input interface to be presented；
Second receiving module, for receiving information to be logged by described information input interface；
Transport module, for the information to be logged received to be sent into the server, for making the server described
Information storage to be logged is into the database of itself carrying.
8. device as claimed in claim 7, it is characterised in that the generation module specifically for：
After the first receiving module receives Data Enter request, the client modules into operation system, which are sent, obtains metadata
Request；And after the metadata that the client modules are returned is received, Data Enter interface is generated according to the metadata；
Second receiving module specifically for：
Information to be logged is received by the Data Enter interface of presentation, and the information to be logged received is submitted into the client
End module；
The transport module specifically for：
The information to be logged that business module in the operation system is submitted is sent to the server.
9. device as claimed in claim 8, it is characterised in that the transport module is additionally operable to：
Before the information for submitting the business module is sent to the server, the client modules are started receiving
Instruction after, send logging request to the server, the logging request includes the identity information of the operation system；
Described device also includes trigger module, and the trigger module is used for：
After the server is authenticated successfully according to the identity information of the operation system to the operation system, the industry is triggered
Server described in system login of being engaged in.
10. device as claimed in claim 8, it is characterised in that described device also includes the first authority and identifies module, described the
One authority identification module is used for：
After the request for the acquisition metadata that the business module in receiving the operation system is sent, metadata is returned to
Before the business module, determine that the operation system has the authority of receive information typing.
11. device as claimed in claim 8, it is characterised in that described device also includes the second authority and identifies module, described the
Two authorities identification module is used for：
Before the information to be logged for submitting the business module is sent to the server, determine that the operation system is carried
Hand over the authority of typing information.
12. device as claimed in claim 8, it is characterised in that the transport module specifically for：
The information to be logged that the business module is submitted is converted to the information of SQL SQL statements, and is sent to
The server.
13. a kind of Message Entry System of database, it is characterised in that including：
Operation system, for after Data Enter request is received, Data Enter interface to be generated according to the metadata itself stored,
And it is presented described information input interface, and receive by described information input interface information to be logged, and will receive
Information to be logged is sent to the server for carrying database, and the metadata is to log in the service in the operation system
Current data model is generated and returned to the business in the database that the server is carried according to the server during device
System, or the metadata be when data model of the server in the database that itself is carried updates according to
Data model after renewal is generated and returned to each operation system for having logged in the server；
The server, holds for receiving the information to be logged that the operation system is sent, and by described information storage to itself
The database of load.
14. system as claimed in claim 13, it is characterised in that the operation system specifically for：
After Data Enter request is received, Data Enter interface is generated according to the metadata itself stored, and the letter is presented
Input interface is ceased, and by described information input interface reception information to be logged, and the information to be logged received is turned
The information of SQL SQL statements is changed to, and is sent to the server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310754528.3A CN103729451B (en) | 2013-12-31 | 2013-12-31 | A kind of information input method of database, apparatus and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310754528.3A CN103729451B (en) | 2013-12-31 | 2013-12-31 | A kind of information input method of database, apparatus and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103729451A CN103729451A (en) | 2014-04-16 |
| CN103729451B true CN103729451B (en) | 2017-08-25 |
Family
ID=50453525
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310754528.3A Active CN103729451B (en) | 2013-12-31 | 2013-12-31 | A kind of information input method of database, apparatus and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103729451B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105989042A (en) * | 2015-02-04 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Information input method and device thereof |
| CN109254854A (en) * | 2018-08-15 | 2019-01-22 | 中国平安人寿保险股份有限公司 | Asynchronous invoking method, computer installation and storage medium |
| CN112784235B (en) * | 2021-01-30 | 2023-08-08 | 上海浦东发展银行股份有限公司 | Method for automatically distributing link tracking system permission based on CMDB project related information |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102208985A (en) * | 2011-07-11 | 2011-10-05 | 东莞市盈达信息科技股份有限公司 | Method for data exchange and integration in heterogeneous environment and system for implementing method |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101639879B (en) * | 2008-07-28 | 2012-06-20 | 成都市华为赛门铁克科技有限公司 | Database security monitoring method, device and system |
| CN102054213A (en) * | 2009-11-05 | 2011-05-11 | 中国移动通信集团公司 | Information integration method, device and system |
| CN203324800U (en) * | 2013-07-04 | 2013-12-04 | 中能电力科技开发有限公司 | Wind turbine generator reported data display device |
-
2013
- 2013-12-31 CN CN201310754528.3A patent/CN103729451B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102208985A (en) * | 2011-07-11 | 2011-10-05 | 东莞市盈达信息科技股份有限公司 | Method for data exchange and integration in heterogeneous environment and system for implementing method |
Non-Patent Citations (1)
| Title |
|---|
| 现场采集作业PDA系统的设计与应用;夏水斌 等;《仪表技术》;20130615(第6期);第18-22页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103729451A (en) | 2014-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102029277B1 (en) | Device Identifier-Dependent Operation Processing for Packet-Based Data Communications | |
| JP6991365B6 (en) | Systems, methods, and equipment for maintaining and updating a common message user interface in group-based communication systems. | |
| CN111382174B (en) | Multi-party data joint query method, device, server and storage medium | |
| CN105900396B (en) | Mobile cloud service architectural framework | |
| US20240012641A1 (en) | Model construction method and apparatus, and medium and electronic device | |
| US20110302277A1 (en) | Methods and apparatus for web-based migration of data in a multi-tenant database system | |
| CN102567400B (en) | Method for realizing Web visit and Web server | |
| CN113268336B (en) | Service acquisition method, device, equipment and readable medium | |
| CN113505520A (en) | Method, device and system for supporting heterogeneous federated learning | |
| JP2022031626A (en) | Method, device, electronic device, storage medium, and computer program for information output | |
| JP7079903B2 (en) | Systems, methods, and devices for building and rendering message user interfaces in group-based communication systems. | |
| CN113839977A (en) | Message pushing method and device, computer equipment and storage medium | |
| US20140007038A1 (en) | Social project management system and marketplace | |
| US11334601B2 (en) | Unified data model | |
| CN103729451B (en) | A kind of information input method of database, apparatus and system | |
| CN113760948A (en) | Data query method and device | |
| CN115237853A (en) | Data query method and device, electronic equipment and storage medium | |
| Montecchi et al. | Model-based evaluation of scalability and security tradeoffs: A case study on a multi-service platform | |
| US8843587B2 (en) | Retrieving availability information from published calendars | |
| CN114816499A (en) | Electronic resource sharing method and device and storage medium | |
| US9654522B2 (en) | Methods and apparatus for an integrated incubation environment | |
| CN109389271B (en) | Application performance management method and system | |
| US8935410B2 (en) | Cobrowsing macros | |
| WO2021113025A1 (en) | Platform for multi-stream sampling and visualization | |
| CN110990280B (en) | Automatic test data generation system and method |
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: 20220217 Address after: 550025 Huawei cloud data center, jiaoxinggong Road, Qianzhong Avenue, Gui'an New District, Guiyang City, Guizhou Province Patentee after: Huawei Cloud Computing Technology Co.,Ltd. Address before: 518129 Bantian HUAWEI headquarters office building, Longgang District, Guangdong, Shenzhen Patentee before: HUAWEI TECHNOLOGIES Co.,Ltd. |
|
| TR01 | Transfer of patent right |