CN107644107A - A kind of generation method and relevant apparatus of internal auditing daily record - Google Patents
A kind of generation method and relevant apparatus of internal auditing daily record Download PDFInfo
- Publication number
- CN107644107A CN107644107A CN201710980294.2A CN201710980294A CN107644107A CN 107644107 A CN107644107 A CN 107644107A CN 201710980294 A CN201710980294 A CN 201710980294A CN 107644107 A CN107644107 A CN 107644107A
- Authority
- CN
- China
- Prior art keywords
- data
- orm
- engines
- record
- obtains
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Abstract
This application discloses a kind of generation method and relevant apparatus of internal auditing daily record, this method includes：When operation system is modified by ORM engines to database, data mode of each ORM engines to database manipulation is recorded；The difference between all data modes is analyzed, obtains analyze data；The analyze data is recorded, obtains corresponding audit log.The data mode operated every time by ORM engines record, comparative analysis data mode, it is possible to know the particular content of user's operation, and the change of data, record on data variation, obtains the related audit log of service logic accordingly.
Description
Technical field
The application is related to field of computer technology, more particularly to a kind of generation method of internal auditing daily record, generating means,
Computer-readable recording medium and server.
Background technology
With the development of information technology, business is done information process- by increasing enterprise's selection.Therefore can build more
Come more servers and terminal, also can increasing business diary query function in terms of business.Convenient tracking user makes
With the operation behavior of the vestige of system, in systems user, the overall management of administrative staff can be facilitated, observe the behavior of user
Custom.In general log query function can track the footprint that user uses system, such as log in IP, into module, check, protect
Deposit, submit, audit, the operation such as deletion.
Existing log system is from the behavior of system level concern user, the track of recording user operation.It realizes former
Capture operation entrance during reason, when user, which clicks on, needs the operation of log, catch the relevant information of active user and operation
And record.
But prior art is with system business logic isolation, the operation for some key messages, in general daily record is looked into
Ask function and do not have method record.For example, user checks what specific data, whether data are operated, which kind of behaviour carried out
Make, and whether add new data or delete the operation such as data, record of having no idea.
Therefore, how to preserve detailed record for operation of the user to data is those skilled in the art's heat of interest
Point problem.
The content of the invention
The purpose of the application is to provide a kind of generation method of internal auditing daily record, generating means, computer-readable storage
Medium and server, the data mode operated every time by ORM engines record, comparative analysis data mode, it is possible to know use
The particular content of family operation, and the change of data, record on data variation, obtain the related audit of service logic accordingly
Daily record.
In order to solve the above technical problems, the application provides a kind of generation method of internal auditing daily record, including：
When operation system is modified by ORM engines to database, each ORM engines are recorded to database manipulation
Data mode；
The difference between all data modes is analyzed, obtains analyze data；
The analyze data is recorded, obtains corresponding audit log.
Optionally, it is described when operation system is modified by ORM engines to database, record each ORM engines pair
The data mode of database manipulation, including：
Configuration information is obtained, the configuration information is parsed and obtains needing to carry out the field data for recording audit log；
When the operation system is modified by the ORM engines to the database, each ORM engines pair are recorded
Data mode corresponding to the field data of database manipulation.
Optionally, the difference between all data modes of analysis, obtains analyze data, including：
The change between all data modes is contrasted, obtains comparing result；
Data variation type is selected according to the comparing result；Wherein, the data variation type includes：Increase, delete,
Change and unchanged；
Using all data modes and data change type as analyze data.
Optionally, the change between all data modes of contrast, obtains comparing result, in addition to：
The ORM engines stamp dirty mark to the data to change；
Update the SQL scripts of the data of the database accordingly according to the dirty mark generation.
Optionally, it is described to record the analyze data, corresponding audit log is obtained, including：
The analyze data is recorded, obtains original audit log；
Corresponding data model is made according to the original audit log, by view with reference to described in inciting somebody to action the data model
Original audit log is shown processing, obtains the audit log.The application also provides a kind of generation of internal auditing daily record
Device, including：
Record data block of state, when operation system is modified by ORM engines to database, record each ORM
Data mode of the engine to database manipulation；
Difference module is analyzed, the difference between all data modes is analyzed, obtains analyze data；
Audit log generation module, the analyze data is recorded, obtain corresponding audit log.
Optionally, the record operation data module, including：
Configuration information unit is obtained, the configuration information is parsed and obtains needing to carry out the field data for recording audit log；
Data mode recording unit, when the operation system is modified by the ORM engines to the database,
Each ORM engines are recorded to data mode corresponding to the field data of database manipulation.
Optionally, the analysis difference module, including：
Contrast operation's unit, the change between all data modes is contrasted, obtains comparing result；
Data mode unit is selected, data variation type is selected according to the comparing result；Wherein, the data variation class
Type includes：Increase, delete, changing and be unchanged；
Analyze data unit, using all data modes and data change type as analyze data.
The application also provides a kind of computer-readable recording medium, is stored thereon with computer program, the computer journey
When sequence is performed, the method for realizing following steps：
When operation system is modified by ORM engines to database, each ORM engines are recorded to database manipulation
Data mode；
The difference between all data modes is analyzed, obtains analyze data；
The analyze data is recorded, obtains corresponding audit log.
The application also provides a kind of server, including memory and processor, and computer journey is stored in the memory
Sequence, when the processor calls the computer program in the memory, the method for realizing following steps：
When operation system is modified by ORM engines to database, each ORM engines are recorded to database manipulation
Data mode；
The difference between all data modes is analyzed, obtains analyze data；
The analyze data is recorded, obtains corresponding audit log.A kind of internal auditing daily record provided herein
Generation method, including：When operation system is modified by ORM engines to database, each ORM engines are recorded to database
The data mode of operation；The difference between all data modes is analyzed, obtains analyze data；The analyze data is recorded,
Obtain corresponding audit log.The data mode operated every time by ORM engines record, comparative analysis data mode, it is possible to
Know the particular content of operation, and the change of data, it is possible to which record is related to service logic on data accordingly
Audit log.
Brief description of the drawings
, below will be to embodiment or existing in order to illustrate more clearly of the embodiment of the present application or technical scheme of the prior art
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
The embodiment of application, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis
The accompanying drawing of offer obtains other accompanying drawings.
A kind of flow chart of the generation method for internal auditing daily record that Fig. 1 is provided by the embodiment of the present application；
A kind of a kind of audit log displaying of the generation method for internal auditing daily record that Fig. 2 is provided by the embodiment of the present application
Figure；
Fig. 3 is the timing diagram of the log recording of prior art；
The timing diagram that Fig. 4 is provided by the embodiment of the present application；
A kind of stream of the acquisition configuration information of the generation method for internal auditing daily record that Fig. 5 is provided by the embodiment of the present application
Cheng Tu；
A kind of flow of the analysis difference of the generation method for internal auditing daily record that Fig. 6 is provided by the embodiment of the present application
Figure；
A kind of structural representation of the generating means for internal auditing daily record that Fig. 7 is provided by the embodiment of the present application；
A kind of structural representation for server that Fig. 8 is provided by the embodiment of the present application.
Embodiment
The core of the application is to provide a kind of generation method of internal auditing daily record, generating means, computer-readable storage
Medium and server, the data mode operated every time by ORM engines record, comparative analysis data mode, it is possible to know behaviour
The particular content of work, and the change of data, it is possible to record the audit day related to service logic on data accordingly
Will.
To make the purpose, technical scheme and advantage of the embodiment of the present application clearer, below in conjunction with the embodiment of the present application
In accompanying drawing, the technical scheme in the embodiment of the present application is clearly and completely described, it is clear that described embodiment is
Some embodiments of the present application, rather than whole embodiments.Based on the embodiment in the application, those of ordinary skill in the art
The every other embodiment obtained under the premise of creative work is not made, belong to the scope of the application protection.
It refer to Fig. 1, a kind of flow of the generation method for internal auditing daily record that Fig. 1 is provided by the embodiment of the present application
Figure.
The present embodiment provides a kind of generation method of internal auditing daily record, can include：
S101, when operation system is modified by ORM engines to database, each ORM engines are recorded to database
The data mode of operation；
This step is intended to record the data mode of each database manipulation by ORM engines, due in general log system
User is simply recorded to the Operation Log between operation system, it records content and is only about behaviour of the user for operation system
Make, and can not know what kind of operation user carries out for the data in operation system.Therefore, user is recorded by ORM engines
The data mode of operation each time.
Wherein, ORM engines are formed according to ORM technical principles.And ORM refers to Object Relation Mapping, abbreviation ORM, it is
It is a kind of in order to solve existing for object-oriented and relational database the mutually technology of unmatched phenomenon, for realizing that object-oriented is compiled
Conversion in Cheng Yuyan between the data of different type system.For the object map that object model represents to based on SQL's
In relational model database structure.ORM engines are just called based on the framework that ORM principles are built.ORM engines structure at work
It build between operation system and database, the configuration and operation in can difference focused data storehouse when exploitation can be only
It is concerned about service logic, facilitates operation system.
Due to the characteristic of ORM engines, operation of the operation system for database is required for by ORM engines therefore passed through
ORM engine cans get concrete operations data mode of the operation system for each operation of data.When operation system is led to
When crossing ORM engines data are read into database, will all write down a data snapshot, to record data from database come out when
Data mode.Then, ORM engines give data to operation system, and are supplied to user to enter edlin, data after the completion of editor
Return in ORM engines, ORM engines are also recorded data.
Wherein, operation system is by modification of the ORM engines to database, as operation of the operation system for database,
The modification that should be all considered as when any operation for database of appearance in the application.
Wherein, the data mode of the record can be the value of data or the type of data, be exactly to remember herein
The reset condition of data is recorded, selection records that what data can be set as needed, no longer repeat herein on earth.
It is envisioned that in actual use, user can need to record audit by configuration service Object Selection
The field of daily record, the configuration are integrated in the functional attributes with field, and selection can allow the data field for recording audit log.Example
Such as, the field of the specific unsuitable record such as big text will be unable to be chosen and can not record.Simultaneously it should also be appreciated that the essence of data volume
Simple problem, user will set the field of key monitoring.
S102, the difference between all data modes is analyzed, obtains analyze data；
On the basis of step S101, this step is intended to analyze data state, obtains analyze data.Operation system is for same
The front and rear data mode of the operation of one data, can obtain which type of operation is operation system done for high data, for example,
It is volume increase, deletion, the modification to data field, or is not operated.
Wherein, the judgement for operation is exactly resulting analyze data.In actual mechanical process, the contrast of ORM engines
After front and rear data, dirty mark can be stamped to the data to change, according to various dirty marks, ORM engines are just accordingly
Generate respective operations data can script.So that ORM engines operate to database.
Meanwhile it can be obtained by which kind of operation that operation system carried out for data, Yi Ji using these analyze datas
The change that data are occurred before and after the operation.
S103, record analysis data, obtain corresponding audit log.
On the basis of step S102, this step, which is intended to record above-mentioned analyze data, obtains corresponding audit log.Will
Analyze data is obtained after classifying beneficial to the audit log read.
Wherein it is possible to the audit log expected after visual processing by terminal display on the readable boundary of user
Can be illustrated in the page, or in mobile phone terminal, specifically no longer repeat herein in face.
Certainly, inevitably also need to do data the processing of other angles and whole during audit log is obtained
Reason, it should regard and specifically want to obtain the audit log of what exhibition method, the user of audit log, and viewing angle select not
Same processing and arrangement data mode, are specifically no longer repeated herein.
Fig. 2 is refer to, Fig. 2 is examined by a kind of one kind of the generation method for internal auditing daily record that the embodiment of the present application provides
Count daily record displaying figure.
The exhibition method of audit log, can be such as Fig. 2 mode.This is a kind of data display towards keeper
Figure.It can be seen that operator (user HRDeveloper) is in date of operation (2016/9/318:13:27) this time
Point, it is this operation object (office worker's shelves of test01 to the modified logo (i.e. office worker encodes) in operation module (for administration of employee)
Case) be modified, modification attribute be related to FBillHead (attribute coding) physically notice day (my god), adjustment age and service seniority day etc.
Two fields, and the forward and backward value of renewal that have recorded the two fields.If this audit log record is in conjunction with the upper of existing scheme
Preservation Operation Log in machine Operation Log, then the complete context that user uses system can be completely shown, reach internal examine
Count effect.
Optionally, the model of data can also be made in systems, so as to which data are shown in a manner readable.By number
According to record with data display carry out function separation, daily record data is visualized by view combination data model.
Fig. 3 and Fig. 4 are refer to, Fig. 3 is the timing diagram of the log recording of prior art, and Fig. 4 is carried by the embodiment of the present application
The timing diagram of confession.
Fig. 3 is refer to, in the prior art, the scheme of log recording is isolated with service logic, only have recorded user's progress
What operation, but do not know that user is how to be operated.For example, the journal displaying user operated the computer is to basic data mould
The material that CH44 (COM code) is encoded under block has carried out preserving operation, behind also record a string of holding times, machine name,
The information such as IP address.When system manager checks that this operates the computer daily record, it is that the user protects to get most deep information
Material has been deposited, whether has been modified before being preserved as material, has made which kind of modification, it is all unknown.
Fig. 4 is refer to, and the difference of the technology of prior art and application scheme is, participates in the object that record is investigated and occurs
Change, the participation object of existing scheme are user, log pattern and operation system, operation system in the technical scheme of the application
It is the initiator as action, is interacted by ORM engines to database.Therefore, the technical program is to supplement existing day
In will record scheme can not record traffic logical process the defects of, i.e., for user to data to preserve operation note detailed
Internal auditing daily record.Technical scheme is done in prior art one supplement, with both prior arts phase
It is auxiliary to coordinate.
As the supplement of existing log system, technical scheme have recorded the concrete operations behavior of user, work as user
When being operated to operation system, can inquires tool when user is operated in the audit log of the technical program generation
Body acts.For example, internal auditing daily record can display the details of out user before material CH44 is preserved, which letter of material have modified
Breath, change forward and backward value and be recorded.In addition, in the case of specific needs, system manager can be according to internal auditing daily record point
Whether normal analyse user behavior.
To sum up, the data mode operated every time by ORM engines record, comparative analysis data mode, it is possible to know use
The particular content of family operation, and the change of data, record on data variation, obtain the related audit of service logic accordingly
Daily record.Greatly facilitate manager and analyze the concrete operations content of user and the data of operation.
Fig. 5 is refer to, Fig. 5 is matched somebody with somebody by a kind of acquisition of the generation method for internal auditing daily record that the embodiment of the present application provides
The flow chart of confidence breath.
With reference to a upper embodiment, the present embodiment is that an explanation is done in the configuration that how to carry out being directed in a upper embodiment, its
His part is substantially identical with a upper embodiment, and same section may be referred to an embodiment, no longer repeat herein.
The present embodiment can include：
S201, obtains configuration information, and parsing configuration information obtains needing to carry out the field data for recording audit log；
This step is intended to, and system is obtained configuration information, and parsing needs by the configuration information of acquisition records audit day
The field data of will, system is set to be recorded for field data to the data of ORM engines.
S202, when operation system is modified by ORM engines to database, each ORM engines are recorded to database
Data mode corresponding to the field data of operation.
On the basis of step S201, this step is intended to obtain corresponding data mode according to the field data of acquisition, and
Record the data mode.
Fig. 6 is refer to, a kind of analysis of the generation method for internal auditing daily record that Fig. 6 is provided by the embodiment of the present application is poor
Different flow chart.
With reference to a upper embodiment, the present embodiment is that the difference that how to carry out analyzing being directed in a upper embodiment does a solution
Release, other parts are substantially identical with a upper embodiment, and same section may be referred to an embodiment, no longer repeat herein.
The present embodiment can include：
S301, the change between all data modes is contrasted, obtains comparing result；
This step is intended to, and is contrasted the data mode, is obtained comparing result.The data mode can be the content of data, number
According to length, the type of data.By the front and rear change of correction data state, it is known that user has been any behaviour to data
Make, further, suitable change type is specifically selected by comparing result, therefore this step is by being contrasted
As a result.
S302, data variation type is selected according to comparing result；Wherein, data variation type includes：Increase, delete, repair
Change and unchanged；
On the basis of step S301, this step is intended to, and data variation type is selected according to comparing result.
In the embodiment of the present application, processing business object is a complicated object, to the editing process of business object
It is an increase, deletes, the process of modification.Wherein, increase and delete the table body entry primarily directed to business object, modification can
To be any attribute.For the front and rear value of its modification of the field essential record of modification, then recorded point for the entry for increasing, deleting
The Major key of record.
S303, using all data modes and data change type as analyze data.
On the basis of step S302, this step be intended to using the data mode of record and obtained data variation type as
Analyze data.
The embodiment of the present application provides a kind of generation method of internal auditing daily record, and operation every time is recorded by ORM engines
Data mode, comparative analysis data mode, it is possible to know the particular content of user's operation, and the change of data, record
Accordingly on data variation, the related audit log of service logic is obtained.
A kind of generating means of the internal auditing daily record provided below the embodiment of the present application are introduced, described below
A kind of generating means of internal auditing daily record can mutually corresponding ginseng with a kind of above-described generation method of internal auditing daily record
According to.
Fig. 7 is refer to, Fig. 7 is shown by a kind of structure of the generating means for internal auditing daily record that the embodiment of the present application provides
It is intended to.
The present embodiment can include：
Record data block of state 100, when operation system is modified by ORM engines to database, record is each
Data mode of the ORM engines to database manipulation；
Difference module 200 is analyzed, the difference between all data modes is analyzed, obtains analyze data；
Audit log generation module 300, record analysis data, obtain corresponding audit log.
Record data block of state 100 can include：
Configuration information unit is obtained, parsing configuration information obtains needing to carry out the field data for recording audit log；
Data mode recording unit, when operation system is modified by ORM engines to database, record each ORM
Engine is to data mode corresponding to the field data of database manipulation；
Difference module 200 is analyzed, including：
Contrast operation's unit, the change between all data modes is contrasted, obtains comparing result；
Data mode unit is selected, data variation type is selected according to comparing result；Wherein, data variation type includes：
Increase, delete, changing and be unchanged；
Analyze data unit, using all data modes and data change type as analyze data.
Refer to Fig. 8, the structural representation for the server that Fig. 8 is provided by the embodiment of the present application, the server can because with
Put or performance is different and produce bigger difference, one or more processors (central can be included
Processing units, CPU) 422 (for example, one or more processors) and memory 442, one or more
Store the storage medium 440 (such as one or more mass memory units) of application program 442 or data 444.Wherein, deposit
Reservoir 442 and storage medium 440 can be of short duration storage or persistently storage.Being stored in the program of storage medium 440 can include
One or more modules (diagram does not mark), each module can include operating the series of instructions in server.More
Further, central processing unit 422 be could be arranged to communicate with storage medium 440, and storage medium is performed on server 400
Series of instructions operation in 440.The server can be the terminals such as computer equipment.At least one is stored in storage medium 330
Individual computer program, the computer program can be executed by processor, to realize that what is provided in the embodiment of the present application is applied to service
The generation method of the internal auditing daily record of device.
Server 400 can also include one or more power supplys 426, one or more wired or wireless networks
Interface 450, one or more input/output interfaces 458, and/or, one or more operating systems 441, such as
Windows ServerTM, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM etc..
Step in a kind of above-mentioned Fig. 1 to the generation method of internal auditing daily record described by Fig. 6 is by a kind of server base
Realized in the structure shown in the Fig. 8.
It is apparent to those skilled in the art that for convenience and simplicity of description, the system of foregoing description,
The specific work process of device and module, the corresponding process in preceding method embodiment is may be referred to, will not be repeated here.
In several embodiments provided herein, it should be understood that disclosed system, apparatus and method can be with
Realize by another way.For example, device embodiment described above is only schematical, for example, the division of module,
Only a kind of division of logic function, can there is an other dividing mode when actually realizing, such as multiple module or components can be with
With reference to or be desirably integrated into another system, or some features can be ignored, or not perform.It is another, it is shown or discussed
Mutual coupling or direct-coupling or communication connection can be by some interfaces, the INDIRECT COUPLING of device or unit or
Communication connection, can be electrical, mechanical or other forms.
The module illustrated as separating component can be or may not be physically separate, be shown as module
Part can be or may not be physical module, you can with positioned at a place, or can also be distributed to multiple networks
On unit.Some or all of unit therein can be selected to realize the purpose of this embodiment scheme according to the actual needs.
In addition, each functional module in each embodiment of the application can be integrated in a processing module, can also
That modules are individually physically present, can also two or more modules be integrated in a module.Above-mentioned integrated mould
Block can both be realized in the form of hardware, can also be realized in the form of software function module.
If integrated unit is realized in the form of software function module and is used as independent production marketing or in use, can
To be stored in a computer read/write memory medium.Based on such understanding, the technical scheme of the application substantially or
Saying all or part of the part to be contributed to prior art or the technical scheme can be embodied in the form of software product
Out, the computer software product is stored in a storage medium, including some instructions are causing a computer equipment
(can be personal computer, funcall device, or network equipment etc.) performs the whole of each embodiment method of the application
Or part steps.And foregoing storage medium includes：USB flash disk, mobile hard disk, read-only storage (Read-Only Memory,
ROM), random access memory (Random Access Memory, RAM), magnetic disc or CD etc. are various can be with storage program
The medium of code.
The embodiment of the present application also provides a kind of calculation machine readable storage medium storing program for executing, is stored thereon with computer program, computer journey
When sequence is performed, following steps are realized：
When operation system is modified by ORM engines to database, each ORM engines are recorded to database manipulation
Data mode；
The difference between all data modes is analyzed, obtains analyze data；
Record analysis data, obtain corresponding audit log.
The embodiment of the present application also carries a kind of server, including memory and processor, and computer journey is stored in memory
Sequence, when processor calls the computer program in memory, realize following steps：
When operation system is modified by ORM engines to database, each ORM engines are recorded to database manipulation
Data mode；
The difference between all data modes is analyzed, obtains analyze data；
Record analysis data, obtain corresponding audit log.
Each embodiment is described by the way of progressive in specification, and what each embodiment stressed is and other realities
Apply the difference of example, between each embodiment identical similar portion mutually referring to.For device disclosed in embodiment
Speech, because it is corresponded to the method disclosed in Example, so description is fairly simple, related part is referring to method part illustration
.
Professional further appreciates that, with reference to the unit of each example of the embodiments described herein description
And algorithm steps, can be realized with electronic hardware, computer software or the combination of the two, in order to clearly demonstrate hardware and
The interchangeability of software, the composition and step of each example are generally described according to function in the above description.These
Function is performed with hardware or software mode actually, application-specific and design constraint depending on technical scheme.Specialty
Technical staff can realize described function using distinct methods to each specific application, but this realization should not
Think to exceed scope of the present application.
Directly it can be held with reference to the step of method or algorithm that the embodiments described herein describes with hardware, processor
Capable software module, or the two combination are implemented.Software module can be placed in random access memory (RAM), internal memory, read-only deposit
Reservoir (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or technology
In any other form of storage medium well known in field.
Above to a kind of generation method of internal auditing daily record provided herein, generating means, computer-readable deposit
Storage media and server are described in detail.Specific case used herein is carried out to the principle and embodiment of the application
Illustrate, the explanation of above example is only intended to help and understands the present processes and its core concept.It should be pointed out that for
For those skilled in the art, on the premise of the application principle is not departed from, if can also be carried out to the application
Dry to improve and modify, these are improved and modification is also fallen into the application scope of the claims.
Claims (10)
- A kind of 1. generation method of internal auditing daily record, it is characterised in that including：When operation system is modified by ORM engines to database, data of each ORM engines to database manipulation are recorded State；The difference between all data modes is analyzed, obtains analyze data；The analyze data is recorded, obtains corresponding audit log.
- 2. generation method according to claim 1, it is characterised in that described to work as operation system by ORM engines to data When storehouse is modified, data mode of each ORM engines to database manipulation is recorded, including：Configuration information is obtained, the configuration information is parsed and obtains needing to carry out the field data for recording audit log；When the operation system is modified by the ORM engines to the database, each ORM engines are recorded to data Data mode corresponding to the field data of storehouse operation.
- 3. generation method according to claim 2, it is characterised in that the difference between all data modes of analysis It is different, analyze data is obtained, including：The change between all data modes is contrasted, obtains comparing result；Data variation type is selected according to the comparing result；Wherein, the data variation type includes：Increase, delete, modification It is and unchanged；Using all data modes and data change type as analyze data.
- 4. generation method according to claim 3, it is characterised in that the change between all data modes of contrast Change, obtain comparing result, in addition to：The ORM engines stamp dirty mark to the data to change；Update the SQL scripts of the data of the database accordingly according to the dirty mark generation.
- 5. generation method according to claim 4, it is characterised in that it is described to record the analyze data, obtain corresponding Audit log, including：The analyze data is recorded, obtains original audit log；Corresponding data model is made according to the original audit log, will be described original with reference to the data model by view Audit log is shown processing, obtains the audit log.
- A kind of 6. generating means of internal auditing daily record, it is characterised in that including：Record data block of state, when operation system is modified by ORM engines to database, record each ORM engines To the data mode of database manipulation；Difference module is analyzed, the difference between all data modes is analyzed, obtains analyze data；Audit log generation module, the analyze data is recorded, obtain corresponding audit log.
- 7. generating means according to claim 6, it is characterised in that the record operation data module, including：Configuration information unit is obtained, the configuration information is parsed and obtains needing to carry out the field data for recording audit log；Data mode recording unit, when the operation system is modified by the ORM engines to the database, record Each ORM engines are to data mode corresponding to the field data of database manipulation.
- 8. generating means according to claim 7, it is characterised in that the analysis difference module, including：Contrast operation's unit, the change between all data modes is contrasted, obtains comparing result；Data mode unit is selected, data variation type is selected according to the comparing result；Wherein, the data variation type bag Include：Increase, delete, changing and be unchanged；Analyze data unit, using all data modes and data change type as analyze data.
- 9. a kind of computer-readable recording medium, is stored thereon with computer program, it is characterised in that the computer program quilt Method as claimed any one in claims 1 to 3 is realized during execution.
- 10. a kind of server, including memory and processor, computer program is stored in the memory, it is characterised in that The processor realizes method as claimed any one in claims 1 to 3 when calling the computer program in the memory.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710980294.2A CN107644107A (en) | 2017-10-19 | 2017-10-19 | A kind of generation method and relevant apparatus of internal auditing daily record |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710980294.2A CN107644107A (en) | 2017-10-19 | 2017-10-19 | A kind of generation method and relevant apparatus of internal auditing daily record |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107644107A true CN107644107A (en) | 2018-01-30 |
Family
ID=61124473
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710980294.2A Pending CN107644107A (en) | 2017-10-19 | 2017-10-19 | A kind of generation method and relevant apparatus of internal auditing daily record |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107644107A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109656704A (en) * | 2018-12-21 | 2019-04-19 | 北京天融信网络安全技术有限公司 | A kind of information processing method and information processing unit |
| CN111125066A (en) * | 2019-12-26 | 2020-05-08 | 杭州迪普科技股份有限公司 | Method and device for detecting functions of database audit equipment |
| CN114661693A (en) * | 2022-02-21 | 2022-06-24 | 哪吒港航智慧科技(上海)有限公司 | Data auditing realization method, storage medium, electronic equipment and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102096623A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Operation log generation method, server and business operational support system |
| CN102810057A (en) * | 2011-05-30 | 2012-12-05 | 中国银联股份有限公司 | Log recording method |
| CN103778244A (en) * | 2014-02-11 | 2014-05-07 | 五八同城信息技术有限公司 | Automatic report analytical method based on user behavior logs |
| CN105787064A (en) * | 2016-03-01 | 2016-07-20 | 广州铭诚计算机科技有限公司 | Mining platform establishment method based on big data |
| US20160307128A1 (en) * | 2013-02-13 | 2016-10-20 | Tutsho, Llc | Food data access and delivery system |
-
2017
- 2017-10-19 CN CN201710980294.2A patent/CN107644107A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102096623A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Operation log generation method, server and business operational support system |
| CN102810057A (en) * | 2011-05-30 | 2012-12-05 | 中国银联股份有限公司 | Log recording method |
| US20160307128A1 (en) * | 2013-02-13 | 2016-10-20 | Tutsho, Llc | Food data access and delivery system |
| CN103778244A (en) * | 2014-02-11 | 2014-05-07 | 五八同城信息技术有限公司 | Automatic report analytical method based on user behavior logs |
| CN105787064A (en) * | 2016-03-01 | 2016-07-20 | 广州铭诚计算机科技有限公司 | Mining platform establishment method based on big data |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109656704A (en) * | 2018-12-21 | 2019-04-19 | 北京天融信网络安全技术有限公司 | A kind of information processing method and information processing unit |
| CN111125066A (en) * | 2019-12-26 | 2020-05-08 | 杭州迪普科技股份有限公司 | Method and device for detecting functions of database audit equipment |
| CN111125066B (en) * | 2019-12-26 | 2023-09-26 | 杭州迪普科技股份有限公司 | Method and device for detecting functions of database auditing equipment |
| CN114661693A (en) * | 2022-02-21 | 2022-06-24 | 哪吒港航智慧科技(上海)有限公司 | Data auditing realization method, storage medium, electronic equipment and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9916596B1 (en) | Systems and methods for providing a direct marketing campaign planning environment | |
| US9430354B2 (en) | Aggregation of metrics for tracking electronic computing resources based on user class hierarchy | |
| US9734468B2 (en) | System and method for resolving customer communications | |
| US20200210423A1 (en) | Multi-party data joint query method, device, server and storage medium | |
| US20130166498A1 (en) | Model Based OLAP Cube Framework | |
| CN107644107A (en) | A kind of generation method and relevant apparatus of internal auditing daily record | |
| US20150012328A1 (en) | Recursive processing of object allocation rules | |
| CN109325044A (en) | A kind of the audit log processing method and relevant apparatus of database | |
| CN106251114B (en) | Method and device for realizing approval in application | |
| CN107870988A (en) | A kind of information verification method, terminal device and storage medium | |
| US20130238549A1 (en) | Using Dimension Substitutions in OLAP Cubes | |
| Ali et al. | A framework to implement data cleaning in enterprise data warehouse for robust data quality | |
| CN104424231A (en) | Multi-dimensional data processing method and device | |
| CN110019754A (en) | A kind of method for building up of knowledge base, device and equipment | |
| CN106649242A (en) | Method and system for generating report | |
| CN107145547A (en) | A kind of acquisition methods of abnormal data, equipment and computer-readable recording medium | |
| CN106528391A (en) | Recording method of operating log by management platform on SSR | |
| CN108269107A (en) | User information processing method and processing device | |
| CN110825641B (en) | Micro-service application test system based on simulation data generator | |
| DE112012000305B4 (en) | Collaborative recovery from data sources | |
| CN106802928B (en) | Power grid historical data management method and system | |
| US20200081890A1 (en) | Increasing database performance through query aggregation | |
| CN110633301A (en) | Method and system for extracting data based on engine setting | |
| CN114218291A (en) | Portrait generation method, apparatus, device and storage medium based on target object | |
| CN111046382B (en) | Database auditing method, equipment, storage medium and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180130 |