CN108334534A - Operation system field configuration method, apparatus, server and readable storage medium storing program for executing - Google Patents
Operation system field configuration method, apparatus, server and readable storage medium storing program for executing Download PDFInfo
- Publication number
- CN108334534A CN108334534A CN201711050867.8A CN201711050867A CN108334534A CN 108334534 A CN108334534 A CN 108334534A CN 201711050867 A CN201711050867 A CN 201711050867A CN 108334534 A CN108334534 A CN 108334534A
- Authority
- CN
- China
- Prior art keywords
- field
- configuration
- operation system
- database
- record
- 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
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/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- 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/23—Updating
- G06F16/2358—Change logging, detection, and notification
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of operation system field configuration method, apparatus, server and readable storage medium storing program for executing, which includes：It is corresponding to constitute virtual configuration table according to the entities field data in operation system database；According to the configuring request of the database entity field data of reception, modify to table record in the virtual configuration table；Modified virtual configuration table is updated in the server buffer of bearer service system, to be updated to correspondent entity field data in operation system database.The present invention is not necessarily to restart operation system progress functional verification, version updating and production environment, you can realizes and changes field to the field of database, is developed again without developer, reduces development cost, greatlying simplify new field and edit field flow.
Description
Technical field
The present invention relates to software systems technical field more particularly to a kind of operation system field configuration method, apparatus, services
Device and readable storage medium storing program for executing.
Background technology
Operation system meets the various demands inquiry of business personnel, and operation system is installed in server, server and industry
The database of business system storage service data connects, when business personnel needs the business new field or edit field to inquiry
(as modification field display format, field import database), it usually needs toward database new field or edit field, then
The mathematical logic between server and database is changed to read new field or edit field, furthermore in the webpage of operation system
Upper dispensing unit lattice finally need to test operation system progress function to show the value and sequence of new field or edit field
Card and restarts production environment at more new version, and new field or edit field can just come into force in server, to cause operation system
Middle new field and the technical problem that edit field procedure Procedure is cumbersome, development cost is high.
Invention content
The main purpose of the present invention is to provide a kind of operation system field configuration method, apparatus, server and readable deposit
Storage media, it is intended to solve new field and the technical problem that edit field procedure Procedure is cumbersome, development cost is high in operation system.
To achieve the above object, the embodiment of the present invention provides a kind of operation system field configuration method, the operation system
Field configuration method includes：
It is corresponding to constitute virtual configuration table according to the entities field data in operation system database；
According to the configuring request of the database entity field data of reception, table record in the virtual configuration table is repaiied
Change；
Modified virtual configuration table is updated in the server buffer of bearer service system, with to operation system number
It is updated according to correspondent entity field data in library.
Preferably, the operation system field configuration method includes：
The newest virtual configuration table of timing acquisition, and based on newest virtual configuration table to the entity of operation system database
Field data is updated.
Preferably, the entities field data include entity table and/or view,
Entities field data in the database according to operation system, corresponding to the step of constituting virtual configuration table includes：
The field record of entities field data in operation system database is obtained, wherein field record includes field value, word
Section attribute and field status；
It constitutes virtual configuration table and increases in the virtual configuration table and recorded with the one-to-one table of the field record, and
Increase explanatory description for every table record association.
Preferably, the configuring request of the database entity field data according to reception, in the virtual configuration table
Table record the step of modifying includes：
Receive the configuring request of simultaneously analytical database entities field data；
If configuring request is display configuring request, the display configuration parameter in display configuring request and the first configuration are obtained
Object, display configuration parameter includes display location and display properties；
The corresponding first table record of the first configuration object is determined in virtual configuration table, and parameter is configured according to the display
It modifies to the first table record.
Preferably, include after described the step of receiving the simultaneously configuring request of analytical database entities field data：
If configuring request is record configuring request, the target modification information and first object in record configuring request are obtained
Configuration sequence number marks the configuration sequence number of table record and the field sequence for marking the field record wherein in virtual configuration table
Number correspond；
Tag field note to be modified in virtual configuration table is determined based on the first object configuration sequence number in configuring request
The field sequence number of record is marked the field sequence number of first object configuration sequence correspondence markings field record in virtual configuration
Note table record is adjusted to target modification information.
Preferably, include after described the step of receiving the simultaneously configuring request of analytical database entities field data：
If configuring request is filtering configuring request, the Field Sanitization condition of the filtering configuring request is obtained；
The table record deletion that will not be inconsistent with the Field Sanitization condition in virtual configuration table.
Preferably, include after described the step of receiving the simultaneously configuring request of analytical database entities field data：
If configuring request is privileges configuration request, the target Permission Levels and the second target for obtaining privileges configuration request are matched
Set sequence number；
It will be recorded with the table of the second target configuration sequence number in virtual configuration table, assign target Permission Levels.
The present invention also provides a kind of operation system field configuration device, the operation system field configuration device includes：
Structure table module, for according to the entities field data in operation system database, corresponding composition virtual configuration table；
Modified module is used for the configuring request of the database entity field data according to reception, to the virtual configuration table
Middle table record is modified；
Update module, for being updated to modified virtual configuration table in the server buffer of bearer service system, with
Correspondent entity field data in operation system database is updated.
The present invention also provides a kind of server, the server includes processor, memory and is stored in the memory
Operation system field configuration program that is upper and can running on the processor；
It is realized when the operation system field configuration program is executed by the processor as above-mentioned operation system field is matched
The step of setting method.
The present invention also provides a kind of computer readable storage medium, business is stored on the computer readable storage medium
System field configurator；
Such as above-mentioned operation system field configuration side is realized when the operation system field configuration program is executed by processor
The step of method.
The present invention is by according to the entities field data in operation system database, corresponding to and constituting virtual configuration table, then
According to the configuring request of the database entity field data of reception, modify to table record in the virtual configuration table；And it will
Modified virtual configuration table, is updated in the server buffer of bearer service system, with to corresponding in operation system database
Entities field data are updated；To which operation system user (such as business personnel) is needing the business new field to inquiry
Or when edit field, without directly to the database new field or edit field of operation system, being held without further modification
Carry the mathematical logic between the server and database of operation system or the dispensing unit lattice on the webpage of operation system, industry
System user of being engaged in need to only change demand (such as new field demand, edit field demand) according to the field of inquiry business, right
The virtual configuration table of operation system fields match is modified, and then modified allocation list is updated in server buffer,
Update is synchronized to which database is based on modified allocation list in caching, without carrying out functional verification, version to operation system
This update and production environment are restarted, you can are realized and are changed field to the field of database, develop, drop again without developer
Low development cost greatlies simplify new field and edit field flow.
Description of the drawings
The hardware architecture diagram of Fig. 1 optional servers of each embodiment one to realize the present invention；
Fig. 2 is the flow diagram of one embodiment of operation system field configuration method of the present invention；
Fig. 3 is the refinement flow diagram of mono- embodiments of step S20 in Fig. 2.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific implementation mode
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
In subsequent description, using for indicating that the suffix of such as " module ", " component " or " unit " of element is only
The explanation for being conducive to the present invention, itself does not have a specific meaning.Therefore, " module ", " component " or " unit " can mix
Ground uses.
User terminal is substantially terminal device, and terminal can be implemented in a variety of manners.For example, user described in the present invention
End may include such as mobile phone, tablet computer, laptop, palm PC, personal digital assistant (Personal Digital
Assistant, PDA) etc. the fixed terminals such as mobile terminals, and number TV, desktop computer.
As shown in Figure 1, server of the present invention may include：Processor 1001, such as CPU, network interface 1004, Yong Hujie
Mouth 1003, memory 1005, communication bus 1002.Wherein, communication bus 1002 is logical for realizing the connection between these components
Letter.User interface 1003 may include display screen (Display), input unit such as keyboard (Keyboard), and optional user connects
Mouth 1003 can also include standard wireline interface and wireless interface.Network interface 1004 may include optionally the wired of standard
Interface, wireless interface (such as WI-FI interfaces).Memory 1005 can be high-speed RAM memory, can also be stable memory
(non-volatile memory), such as magnetic disk storage.Memory 1005 optionally can also be independently of aforementioned processor
1001 storage device.
Optionally, server can also include camera, RF (Radio Frequency, radio frequency) circuit, sensor, sound
Frequency circuit, WiFi module etc..Wherein, sensor such as optical sensor, motion sensor and other sensors.
It will be understood by those skilled in the art that server architecture shown in Fig. 1 does not constitute the restriction to server, it can
To include either combining certain components or different components arrangement than illustrating more or fewer components.
As shown in Figure 1, as may include that operating system, network are logical in a kind of memory 1005 of computer storage media
Believe that module, Subscriber Interface Module SIM and rate of advance generate program.
In server shown in Fig. 1, network interface 1004 is mainly used for connecting parent server and database, with higher level
Server and database are into row data communication；User interface 1003 be mainly used for connect client (user terminal), with client into
Row data communication；And processor 1001 can be used for calling the operation system field configuration program stored in memory 1005, and
Execute following operation：
It is corresponding to constitute virtual configuration table according to the entities field data in operation system database；
According to the configuring request of the database entity field data of reception, table record in the virtual configuration table is repaiied
Change；
Modified virtual configuration table is updated in the server buffer of bearer service system, with to operation system number
It is updated according to correspondent entity field data in library.
In addition, processor 1001 can be used for calling the operation system field configuration program stored in memory 1005, and
Execute above-mentioned each embodiment step of operation system field configuration method.
The present invention also provides a kind of operation system field configuration method, which is mainly used in
In the operation system of server, in one embodiment of operation system field configuration method, with reference to Fig. 2, operation system field configuration
Method includes：
Step S10, it is corresponding to constitute virtual configuration table according to the entities field data in operation system database；
Entities field data in operation system database include entity table, view etc., and entities field includes mainly entity
Field in table and view, the entities field data based on operation system database extract the field kind of operation system database
Then class establishes the field type corresponding table record for virtual configuration table, i.e., entity table in the database of operation system/regard
The field of figure is corresponded with the field in virtual configuration table.
Specifically, entities field data include entity table and/or view, and step S10 includes：
Step S11 obtains the field record of entities field data in operation system database, and wherein field record includes word
Segment value, field attribute and field status；
The field value of the field of database entity table/view, field attribute, field status respectively with table in virtual configuration table
Every field value, field attribute, field status is recorded to correspond to, the table record rule in virtual configuration table can predefined, and
And the table record of corresponding explanatory description can be increased.For example, field type can be row record in the table record of virtual configuration table,
Field value, field attribute, field status and explanatory description can be row record, be made of row record and row record to constitute
Virtual configuration table.
Step S12 constitutes virtual configuration table and increases in the virtual configuration table and remembers with the one-to-one table of field record
Record, and increase explanatory description for every table record association.
In the field record of the entities field based on database entity table/view, field note is built for virtual configuration table
Can be that every table record increases by an explanatory description of row, which can record each table after recording corresponding table record
Middle field carries out character property explanation, such as the field type of table record is ID, field attribute is varchar (32), field
State is 12345, can be major key ID to the explanatory description of table record, to fast conducive to operation system developer and user
Speed accurately reads virtual configuration table.
Step S20, according to the configuring request of the database entity field data of reception, to table in virtual configuration table record into
Row modification；
Configuring request can be that business personnel propose in inquiry business system, can also be operation system developer to this
Itd is proposed when operation system is safeguarded, configuring request may include to entities field in database in the operation system page whether
Whether display display location of the entities field in the operation system page in database, by Excel imports number into database
Data are imported according to, Excel and the corresponding storage location arranged in database, whether entities field appears in search engine in database
In filter condition, the role inquiry permission editor of database entity field (which role can see/operate these fields) etc..
After configuring request is identified and analyzed, the table record for needing to change in virtual configuration table and modified target are determined
Value, to be desired value to the table record modification for needing to change in virtual configuration table.
Modified virtual configuration table is updated in the server buffer of bearer service system, with to industry by step S30
Correspondent entity field data is updated in business system database.
All data of modified database virtual configuration table (such as p_column tables) are all buffered engine management, if
Table record in virtual configuration table has any variation, and the virtual configuration table after variation can be dynamically updated to the caching of operation system
In, caching could be updated by needing to restart rather than other servers.To store newest virtual configuration table in caching,
It realizes that virtual configuration table supports higher visit capacity, also improves access and the modification efficiency of virtual configuration table.
In the present embodiment, by according to the entities field data in operation system database, corresponding composition virtual configuration
Table repaiies table record in the virtual configuration table then according to the configuring request of the database entity field data of reception
Change；And modified virtual configuration table is updated in the server buffer of bearer service system, with to operation system database
Middle correspondent entity field data is updated；To which operation system user (such as business personnel) is new to the business of inquiry in needs
When increasing field or edit field, it is not necessarily to directly to the database new field or edit field of operation system, without further
Change the mathematical logic between the server and database of bearer service system or the dispensing unit on the webpage of operation system
Lattice, operation system user only need to change demand (such as new field demand, edit field demand according to the field of inquiry business
Deng), it modifies to the virtual configuration table of operation system fields match, modified allocation list, which is then updated to server, delays
In depositing, update is synchronized to which database is based on modified allocation list in caching, is tested without carrying out function to operation system
Card, version updating and production environment are restarted, you can are realized and are changed field to the field of database, are opened again without developer
It sends out, reduce development cost, greatlying simplify new field and edit field flow.
Optionally, operation system field configuration method includes：
The newest virtual configuration table of timing acquisition, and based on newest virtual configuration table to the entity of operation system database
Field data is updated.
By to virtual configuration table carry out easy configuration, then can on the operation system page new field, change field
Between sequence；As long as to virtual configuration table carry out easy configuration, can allow operation system acquiescence support a table import feature,
The sensitive information of field level shields.In the case where that need not restart server, (longest only 10 minutes, can also be configured for timing
At 5 minutes, 1 minute) dynamic change lane database configuration, such as：The more new state of virtual configuration table is checked, periodically will
In the configuration information update to caching of change, so as in time according to modified virtual configuration table to operation system database
Entities field data be updated, realize that business personnel changes demand to the field of operation system in time.
Further, in another embodiment of operation system field configuration method of the present invention, with reference to Fig. 3, step S20 packets
It includes：
Step S21 receives the configuring request of simultaneously analytical database entities field data；
Configuring request can be that business personnel propose in inquiry business system, can also be operation system developer to this
Itd is proposed when operation system is safeguarded, configuring request may include to entities field in database in the operation system page whether
Whether display (showing configuring request) display location of the entities field in the operation system page in database, passes through Excel
It is corresponding with being arranged in database that (a kind of way of realization of virtual configuration table) imports data, Excel importings data into database
Whether entities field appears in storage location (recording configuring request), database (is filtered in search engine filter condition
Configuring request), the role inquiry permission editor of database entity field (i.e. privileges configuration request, as which role can see/
Operate these fields) etc..
Step S22, if configuring request be display configuring request, obtain display configuring request in display configuration parameter and
First configuration object, display configuration parameter includes display location and display properties；The first configuration pair is determined in virtual configuration table
It modifies as corresponding first table record, and according to display configuration the first table of parameter pair record.
After analyzing configuring request, when identification configuring request is display configuring request, obtains display configuration and ask
Ask display configuration parameter (display properties be first configuration object whether on the page of operation system display, display location
Be first configuration object in the display location of the operation system page) and first configuration object (display configure parameter configuration pair
As), the first table record of the first configuration object matching is determined in virtual configuration table, and the first table of parameter pair is configured according to display
Record is modified, and such as display configuration parameter is not show, then deletes the first table record in virtual configuration table；Display configuration ginseng
Number is display, then the first table in virtual configuration table is kept to record.
In addition, when configuring request is setting or changes database entity field in the display location of the operation system page, root
According to the display location that need to be arranged, the target word segment value in corresponding change virtual configuration table about entities field display location, target
Field value has correspondence with display location.Entity in database is realized based on configuring request and virtual configuration table to realize
The adjustment of field display location, without additionally being developed.
Specifically, when configuring request is not require database entity field X to include on the page of operation system that is, the
One table is recorded as entities field X, and display configuration parameter is not show, then entities field X is not configured to the table of virtual configuration table
In record, if entities field X is existing in virtual configuration table, entities field X is deleted.
When configuring request is to need database entity field X to include i.e. the first table record on the page of operation system
For entities field X, display configuration parameter is display, then entities field X is configured in the table record of virtual configuration table.Certainly
P_column.rule tables record can be set in virtual configuration table, when needing certain database entity field in operation system
The page is shown, as long as configuration p_column.rule＆1=1；When needing to hide certain database entity field, do not need
Page code is changed, is not required to rewrite Java code, need not also rewrite SQL, as long as being by configuration p_column.rule＆1=0
It can.
Optionally, with reference to Fig. 3, step S21 receive and the step of the configuring request of analytical database entities field data it
After include：
Step S23, if configuring request be record configuring request, obtain record configuring request in target modification information and
First object configuration sequence number, the field for marking the configuration sequence number of table record to be recorded with tag field wherein in virtual configuration table
Sequence number corresponds；Label to be modified in virtual configuration table is determined based on the first object configuration sequence number in configuring request
The field sequence number of field record, by the field sequence of first object configuration sequence correspondence markings field record in virtual configuration
Number institute label table record is adjusted to target modification information.
When detecting that configuring request is record configuring request, show that the configuring request is to be repaiied to virtual configuration table
Change, and then realizes and modify to corresponding field data in database, the first object configuration sequence being then based in configuring request
Row number determines the field sequence number of tag field record to be modified in virtual configuration table, and first object in virtual configuration is configured
The marked content of field sequence number of sequence number correspondence markings field record is adjusted to target modification information, to realize based on note
Record configuring request is modified and is configured to the table record of virtual configuration table.
Specifically, when configuration needs be record configuring request, need the entity that database is imported data to by Excel
In table, needs to modify to the correspondence table record in virtual configuration table, relevant field in virtual configuration table is such as configured to p_
Column.rule＆2=2 does not need the exploitation of the page, java, SQL.Also, in the Excel tables of database to be imported
The field sequence number of data configuration flag field record in virtual configuration table, the field sequence number and entities field in database
Row number corresponds to, thus can be when reading every a line of Excel, it is known that the field data respectively arranged in Excel has in the database
Which row (corresponding with entities field row number) of body.
Such as the field sequence number in virtual configuration table for tag field record includes 01,02 and 03, in database
Entities field sequence number includes and the corresponding A01 of field sequence number 01, A02 corresponding with field sequence number 02 and field sequence
Number 03 corresponding A03, only needs to include aiming field sequence number (such as 02) and target modification information in configuring request to record
Abc, so as to be abc by the table record modification of field sequence number 02 in virtual configuration table, to realize operation system data
The entities field of entities field sequence number A02 labels in library is revised as abc.
Optionally, with reference to Fig. 3, step S21 receive and the step of the configuring request of analytical database entities field data it
After include：
Step S24 obtains the Field Sanitization condition of the filtering configuring request if configuring request is filtering configuring request；
The table record deletion that will not be inconsistent with Field Sanitization condition in virtual configuration table.
If configuring request is filtering configuring request, i.e. configuring request need to determine in database whether entities field appears in and search
Index holds up filter condition, that is to say, that includes the field mistake that selection filtering is carried out to database entities field in filtering configuring request
Filter condition, the Field Sanitization conditional log is according to needing the entities field filtered to be configured in library, thus will be in virtual configuration table
The table record deletion not being inconsistent with Field Sanitization condition, and then realize the entities field that will not be inconsistent with Field Sanitization condition in database
It deletes.
Specifically, the field in virtual configuration table (such as table record) is configured to p_column.rule＆8=8 (character types
Type), then just will appear the Field Options, operator's (such as operation system in Field Sanitization condition on the page of operation system
Business personnel, user etc.) can be based on this Field Sanitization condition come search result, as searched for character in virtual configuration table
The table of type is recorded to realize the entities field of character types in search database, to which Field Sanitization condition is that filtering is virtually matched
Set the table record of all non-character types in table.If by field configuration at p_column.column_type=2 (time classes
Type), then can show the time according to unified date Hour Minute Second automatically on the page of operation system.If present field occurs
In the Field Sanitization condition of the page, then can 2 text boxes of operation system automatic production of HTML page (initial time and at the end of
Between) for operator's input, to filter query result.The table of virtual configuration table is recorded based on filtering configuring request to realize
It is filtered, and then realizes the filtering to database entities field.
Optionally, with reference to Fig. 3, step S21 receive and the step of the configuring request of analytical database entities field data it
After include：
Step S25 obtains the target Permission Levels and the of privileges configuration request if configuring request is privileges configuration request
Two target configuration sequences number；It will be recorded with the table of the second target configuration sequence number in virtual configuration table, assign target Permission Levels.
If configuring request is privileges configuration request, i.e., configuring request need to be that the special entity field in database assigns permission
Grade, can be by recording the increase Permission Levels table in virtual configuration table, and the second target being then based in configuring request is matched
The table record that sequence number determines target Permission Levels to be assigned in virtual configuration table is set, the second target in virtual configuration is configured into sequence
The marked table record content of row number assigns target Permission Levels, to realize based on privileges configuration request to the table of virtual configuration table
Record carries out permission imparting, and then realizes and assign target permission etc. to the entities field of the second target configuration sequence number in database
Grade.
Specifically, when configuring request is privileges configuration request, the role-security grade of database entity data is determined, then
The table record of a character list defined in virtual configuration table is the table record setting permission that each in virtual configuration table arranges
Grade, the i.e. Permission Levels based on each list records limit which role can check the list on the operation system page
The data of record support the sensitive information of row rank to shield, code are customized without writing big section again to which system can be given tacit consent to.
Specifically, for employee's table, the sensitivity entities field such as salary, we can configure sensitive entities field only to specific
Role see, for example be arranged：P_column.role_list=HR, DPT_MGR, as sensitive entities field assign permission etc.
Grade is that only HR and line manager or more are readable.So, the only posies HR and line manager can see salary on the operation system page
Sensitive entities field, other roles just can only see some public informations (entities field other than sensitive entities field), such as
Name, gender etc.Operation system acquiescence supports permission control, does not need the exploitation of the page, java, SQL, simple with one kind,
Easily operated mode realizes the Permission Levels setting of the database entity field based on privileges configuration request.
In addition, the embodiment of the present invention also proposes a kind of operation system field configuration device, the operation system field configuration
Device includes：
Structure table module, for according to the entities field data in operation system database, corresponding composition virtual configuration table；
Modified module is used for the configuring request of the database entity field data according to reception, to the virtual configuration table
Middle table record is modified；
Update module, for being updated to modified virtual configuration table in the server buffer of bearer service system, with
Correspondent entity field data in operation system database is updated.
In addition, the embodiment of the present invention also proposes that a kind of server, server include：Memory, processor and it is stored in institute
The operation system field configuration program stated on memory and can run on the processor, the operation system field configuration journey
Sequence realizes the step of above-mentioned operation system field configuration method when being executed by the processor.
In addition, the embodiment of the present invention also proposes a kind of readable storage medium storing program for executing, business is stored on the readable storage medium storing program for executing
System field configurator, the operation system field configuration program realize above-mentioned operation system field when being executed by processor
The step of configuration method.
In the expansion of the specific implementation mode of operation system field configuration device of the present invention, server and readable storage medium storing program for executing
Appearance is essentially identical with above-mentioned each embodiment of operation system field configuration method, does not do tired state herein.
It should be noted that herein, the terms "include", "comprise" or its any other variant are intended to non-row
His property includes, so that process, method, article or device including a series of elements include not only those elements, and
And further include other elements that are not explicitly listed, or further include for this process, method, article or device institute it is intrinsic
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including this
There is also other identical elements in the process of element, method, article or device.
The embodiments of the present invention are for illustration only, can not represent the quality of embodiment.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can add the mode of required general hardware platform to realize by software, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on this understanding, technical scheme of the present invention substantially in other words does the prior art
Going out the part of contribution can be expressed in the form of software products, which is stored in a storage medium
In (such as ROM/RAM, magnetic disc, CD), including some instructions are used so that a station terminal (can be mobile phone, computer, service
Device, air conditioner or network equipment etc.) execute method described in each embodiment of the present invention.
The embodiment of the present invention is described with above attached drawing, but the invention is not limited in above-mentioned specific
Embodiment, the above mentioned embodiment is only schematical, rather than restrictive, those skilled in the art
Under the inspiration of the present invention, without breaking away from the scope protected by the purposes and claims of the present invention, it can also make very much
Form, all of these belong to the protection of the present invention.
Claims (10)
1. a kind of operation system field configuration method, which is characterized in that the operation system field configuration method includes：
It is corresponding to constitute virtual configuration table according to the entities field data in operation system database；
According to the configuring request of the database entity field data of reception, modify to table record in the virtual configuration table；
Modified virtual configuration table is updated in the server buffer of bearer service system, with to operation system database
Middle correspondent entity field data is updated.
2. operation system field configuration method as described in claim 1, which is characterized in that the operation system field configuration side
Method includes：
The newest virtual configuration table of timing acquisition, and based on newest virtual configuration table to the entities field of operation system database
Data are updated.
3. operation system field configuration method as described in claim 1, which is characterized in that the entities field data include real
Body surface and/or view,
Entities field data in the database according to operation system, corresponding to the step of constituting virtual configuration table includes：
The field record of entities field data in operation system database is obtained, wherein field record includes field value, field category
Property and field status；
It constitutes virtual configuration table and increases in the virtual configuration table and recorded with the one-to-one table of the field record, and be every
The record association of bar table increases explanatory description.
4. operation system field configuration method as claimed in claim 3, which is characterized in that the database according to reception is real
The configuring request of body field data, recording the step of modifying to table in the virtual configuration table includes：
Receive the configuring request of simultaneously analytical database entities field data；
If configuring request is display configuring request, the display configuration parameter in display configuring request and the first configuration pair are obtained
As display configuration parameter includes display location and display properties；
Determine the first configuration object corresponding first table record in virtual configuration table, and according to display configuration parameter pair the
One table record is modified.
5. operation system field configuration method as claimed in claim 4, which is characterized in that described to receive simultaneously analytical database reality
Include after the step of configuring request of body field data：
If configuring request is record configuring request, the target modification information in record configuring request and first object configuration are obtained
Sequence number marks the configuration sequence number of table record and the field sequence number one for marking the field record wherein in virtual configuration table
One corresponds to；
Tag field record to be modified in virtual configuration table is determined based on the first object configuration sequence number in configuring request
Field sequence number, by the marked table of field sequence number of first object configuration sequence correspondence markings field record in virtual configuration
Record is adjusted to target modification information.
6. operation system field configuration method as claimed in claim 5, which is characterized in that described to receive simultaneously analytical database reality
Include after the step of configuring request of body field data：
If configuring request is filtering configuring request, the Field Sanitization condition of the filtering configuring request is obtained；
The table record deletion that will not be inconsistent with the Field Sanitization condition in virtual configuration table.
7. operation system field configuration method as claimed in claim 5, which is characterized in that described to receive simultaneously analytical database reality
Include after the step of configuring request of body field data：
If configuring request is privileges configuration request, the target Permission Levels and the second target configuration sequence of privileges configuration request are obtained
Row number；
It will be recorded with the table of the second target configuration sequence number in virtual configuration table, assign target Permission Levels.
8. a kind of operation system field configuration device, which is characterized in that the operation system field configuration device includes：
Structure table module, for according to the entities field data in operation system database, corresponding composition virtual configuration table；
Modified module is used for the configuring request of the database entity field data according to reception, to table in the virtual configuration table
Record is modified；
Update module, for being updated in the server buffer of bearer service system, modified virtual configuration table with to industry
Correspondent entity field data is updated in business system database.
9. a kind of server, which is characterized in that the server includes processor, memory and is stored on the memory simultaneously
The operation system field configuration program that can be run on the processor；
It is realized as described in any one of claim 1 to 7 when the operation system field configuration program is executed by the processor
Operation system field configuration method the step of.
10. a kind of computer readable storage medium, which is characterized in that be stored with business system on the computer readable storage medium
System field configuration program；
The industry as described in any one of claim 1 to 7 is realized when the operation system field configuration program is executed by processor
The step of system field configuration method of being engaged in.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711050867.8A CN108334534A (en) | 2017-10-27 | 2017-10-27 | Operation system field configuration method, apparatus, server and readable storage medium storing program for executing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711050867.8A CN108334534A (en) | 2017-10-27 | 2017-10-27 | Operation system field configuration method, apparatus, server and readable storage medium storing program for executing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108334534A true CN108334534A (en) | 2018-07-27 |
Family
ID=62921864
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711050867.8A Pending CN108334534A (en) | 2017-10-27 | 2017-10-27 | Operation system field configuration method, apparatus, server and readable storage medium storing program for executing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108334534A (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109656912A (en) * | 2018-12-13 | 2019-04-19 | 成都四方伟业软件股份有限公司 | Data model management-control method, device and server |
| CN109710613A (en) * | 2018-12-26 | 2019-05-03 | 深圳乐信软件技术有限公司 | Management method, device, server and the storage medium of field |
| CN109783748A (en) * | 2018-12-10 | 2019-05-21 | 平安科技（深圳）有限公司 | Display methods, device, equipment and the readable storage medium storing program for executing of display field |
| CN109918443A (en) * | 2019-01-28 | 2019-06-21 | 平安科技（深圳）有限公司 | The synchronous method and device of related information |
| CN110109981A (en) * | 2019-04-04 | 2019-08-09 | 平安科技（深圳）有限公司 | Information displaying method, device, computer equipment and the storage medium of work queue |
| CN110134687A (en) * | 2019-05-13 | 2019-08-16 | 福建南威软件有限公司 | A kind of method and system changing control inventory element by the dynamic increasing of literary name section |
| CN110825944A (en) * | 2019-10-29 | 2020-02-21 | 深圳前海环融联易信息科技服务有限公司 | Webpage table data acquisition method and device, computer equipment and storage medium |
| CN110955655A (en) * | 2018-09-26 | 2020-04-03 | 千寻位置网络有限公司 | Dynamic CMDB database model storage method and system |
| CN111159207A (en) * | 2019-12-16 | 2020-05-15 | 中国建设银行股份有限公司 | Information processing method and device |
| CN111694908A (en) * | 2019-03-15 | 2020-09-22 | 丰图科技(深圳)有限公司 | Data storage method, device and storage medium |
| CN112416983A (en) * | 2019-08-21 | 2021-02-26 | 中移(苏州)软件技术有限公司 | Data processing method and device and computer readable storage medium |
| CN112540995A (en) * | 2020-11-11 | 2021-03-23 | 特劢丝软件科技(上海)有限公司 | Data updating method, electronic device and storage medium |
| CN112612801A (en) * | 2020-12-17 | 2021-04-06 | 平安普惠企业管理有限公司 | Supersonics database-based data statistical method and device and storage medium |
| CN112732678A (en) * | 2021-01-18 | 2021-04-30 | 中国民航信息网络股份有限公司 | Data comparison method, system, electronic equipment and computer storage medium |
| CN114490644A (en) * | 2022-01-10 | 2022-05-13 | 阿里云计算有限公司 | Data storage method, device and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101504672A (en) * | 2009-03-23 | 2009-08-12 | 金蝶软件（中国）有限公司 | Method and system for dynamically configuring physical data table |
| US20100042643A1 (en) * | 2008-04-28 | 2010-02-18 | Oracle International Corp | Virtual masked database |
| CN107273369A (en) * | 2016-04-06 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of table data modification method and device |
-
2017
- 2017-10-27 CN CN201711050867.8A patent/CN108334534A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100042643A1 (en) * | 2008-04-28 | 2010-02-18 | Oracle International Corp | Virtual masked database |
| CN101504672A (en) * | 2009-03-23 | 2009-08-12 | 金蝶软件（中国）有限公司 | Method and system for dynamically configuring physical data table |
| CN107273369A (en) * | 2016-04-06 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of table data modification method and device |
Non-Patent Citations (1)
| Title |
|---|
| 王有为等: "基于统计方法的Hive数据仓库查询优化实现", 《计算机研究与发展》 * |
Cited By (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110955655A (en) * | 2018-09-26 | 2020-04-03 | 千寻位置网络有限公司 | Dynamic CMDB database model storage method and system |
| CN110955655B (en) * | 2018-09-26 | 2022-10-14 | 千寻位置网络有限公司 | Dynamic CMDB database model storage method and system |
| CN109783748A (en) * | 2018-12-10 | 2019-05-21 | 平安科技（深圳）有限公司 | Display methods, device, equipment and the readable storage medium storing program for executing of display field |
| CN109783748B (en) * | 2018-12-10 | 2024-05-03 | 平安科技（深圳）有限公司 | Display method, device and equipment for display field and readable storage medium |
| CN109656912B (en) * | 2018-12-13 | 2020-08-07 | 成都四方伟业软件股份有限公司 | Data model control method and device and server |
| CN109656912A (en) * | 2018-12-13 | 2019-04-19 | 成都四方伟业软件股份有限公司 | Data model management-control method, device and server |
| CN109710613A (en) * | 2018-12-26 | 2019-05-03 | 深圳乐信软件技术有限公司 | Management method, device, server and the storage medium of field |
| CN109918443A (en) * | 2019-01-28 | 2019-06-21 | 平安科技（深圳）有限公司 | The synchronous method and device of related information |
| CN109918443B (en) * | 2019-01-28 | 2023-07-21 | 平安科技（深圳）有限公司 | Method and device for synchronizing associated information |
| CN111694908A (en) * | 2019-03-15 | 2020-09-22 | 丰图科技(深圳)有限公司 | Data storage method, device and storage medium |
| CN110109981A (en) * | 2019-04-04 | 2019-08-09 | 平安科技（深圳）有限公司 | Information displaying method, device, computer equipment and the storage medium of work queue |
| CN110109981B (en) * | 2019-04-04 | 2023-07-25 | 平安科技（深圳）有限公司 | Information display method and device for work queue, computer equipment and storage medium |
| CN110134687A (en) * | 2019-05-13 | 2019-08-16 | 福建南威软件有限公司 | A kind of method and system changing control inventory element by the dynamic increasing of literary name section |
| CN112416983A (en) * | 2019-08-21 | 2021-02-26 | 中移(苏州)软件技术有限公司 | Data processing method and device and computer readable storage medium |
| CN112416983B (en) * | 2019-08-21 | 2022-12-06 | 中移(苏州)软件技术有限公司 | Data processing method and device and computer readable storage medium |
| CN110825944A (en) * | 2019-10-29 | 2020-02-21 | 深圳前海环融联易信息科技服务有限公司 | Webpage table data acquisition method and device, computer equipment and storage medium |
| CN111159207B (en) * | 2019-12-16 | 2023-06-16 | 建信金融科技有限责任公司 | Information processing method and device |
| CN111159207A (en) * | 2019-12-16 | 2020-05-15 | 中国建设银行股份有限公司 | Information processing method and device |
| CN112540995B (en) * | 2020-11-11 | 2022-12-02 | 上海赛美特软件科技有限公司 | Data updating method, electronic device and storage medium |
| CN112540995A (en) * | 2020-11-11 | 2021-03-23 | 特劢丝软件科技(上海)有限公司 | Data updating method, electronic device and storage medium |
| CN112612801A (en) * | 2020-12-17 | 2021-04-06 | 平安普惠企业管理有限公司 | Supersonics database-based data statistical method and device and storage medium |
| CN112732678A (en) * | 2021-01-18 | 2021-04-30 | 中国民航信息网络股份有限公司 | Data comparison method, system, electronic equipment and computer storage medium |
| CN112732678B (en) * | 2021-01-18 | 2024-01-26 | 中国民航信息网络股份有限公司 | Data comparison method, system, electronic equipment and computer storage medium |
| CN114490644A (en) * | 2022-01-10 | 2022-05-13 | 阿里云计算有限公司 | Data storage method, device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108334534A (en) | Operation system field configuration method, apparatus, server and readable storage medium storing program for executing | |
| US10332184B2 (en) | Personalized application recommendations | |
| EP3499363B1 (en) | Data collection method and apparatus | |
| CN102253936B (en) | Method for recording access of user to merchandise information, search method and server | |
| CN108399072B (en) | Application page updating method and device | |
| US20150154303A1 (en) | System and method for providing content recommendation service | |
| CN103077344A (en) | Terminal and method for providing risk of application using the same | |
| CN105335511A (en) | Webpage access method and device | |
| CN111651468A (en) | Data updating method and device based on SQL analysis, electronic equipment and storage medium | |
| CN102426523A (en) | Multi-dimensional objects | |
| CN101174274A (en) | Information processing apparatus, information processing method and information processing program | |
| CN108427700B (en) | Electronic device, user grouping method and computer readable storage medium | |
| CN112784112A (en) | Message checking method and device | |
| CN115544183A (en) | Data visualization method and device, computer equipment and storage medium | |
| WO2021189766A1 (en) | Data visualization method and related device | |
| CN103442085A (en) | Method, terminal, server and system used for maintaining user information | |
| CN111383072A (en) | User credit scoring method, storage medium and server | |
| EP3188417B1 (en) | Information display method, terminal and server | |
| CN102866985A (en) | Data formatting device and method for on-line analytical processing system | |
| CN115878655A (en) | Data operation method and device, computer equipment and storage medium | |
| CN105808628A (en) | Webpage transcoding method, apparatus and system | |
| CN114020296A (en) | Configuration information updating method, device, equipment and readable storage medium | |
| CN112419058A (en) | Data management method and device, storage medium and electronic equipment | |
| CN108280139B (en) | POI data processing method, device, equipment and computer readable storage medium | |
| CN102436446A (en) | Method and device for updating abstract structure |
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: 20180727 |