CN109977104A - Data managing method and device - Google Patents
Data managing method and device Download PDFInfo
- Publication number
- CN109977104A CN109977104A CN201910259922.7A CN201910259922A CN109977104A CN 109977104 A CN109977104 A CN 109977104A CN 201910259922 A CN201910259922 A CN 201910259922A CN 109977104 A CN109977104 A CN 109977104A
- Authority
- CN
- China
- Prior art keywords
- database
- flowing water
- operating instruction
- identifiable
- presetting
- 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.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of data managing method and device, is related to technical field of data administration.The data managing method includes: receiving front-end table, wherein front-end table includes the database operating instruction of input.Front-end table is parsed, obtains the identifiable flowing water table of presetting database, wherein flowing water table is used to indicate database operating instruction.Presetting database is written into flowing water table, wherein database operating instruction, which is used to indicate, operates presetting database performance objective.Database can also be managed and maintained by realizing amateur database personnel, easy to operate, improve the efficiency for managing and maintaining database.
Description
Technical field
The present invention relates to technical field of data administration, in particular to a kind of data managing method and device.
Background technique
Data management is the very important work of many enterprises, but the management of database, maintenance are one more complicated
Work, generally requiring systematic learning structured query language (Structured Query Language, SQL) could complete.
Presently, there are the software of some simplified data managements, for example, Navicat Premium 12, DataGrip,
Sequel Pro etc., but the SQL syntax knowledge for needing to have basic using these softwares.Also, mass simultaneous creation and maintenance
When multiple tables of data, it is also necessary to write complicated SQL statement and just be able to achieve.
Therefore, the prior art is unable to satisfy the demand that manages and maintains of amateur database personnel, and operation difficulty is high, efficiency
It is low.
Summary of the invention
It is an object of the present invention in view of the deficiency of the prior art, a kind of data managing method and device are provided,
To solve the demand that manages and maintains that the prior art is unable to satisfy amateur database personnel, operation difficulty is high, and low efficiency is asked
Topic.
To achieve the above object, technical solution used in the embodiment of the present invention is as follows:
In a first aspect, the embodiment of the invention provides a kind of data managing methods, comprising: receiving front-end table, wherein front end
Table includes the database operating instruction of input.Front-end table is parsed, obtains the identifiable flowing water table of presetting database, wherein flowing water
Table is used to indicate database operating instruction.Presetting database is written into flowing water table, wherein database operating instruction is used to indicate pair
The operation of presetting database performance objective.
Optionally, front-end table is parsed, obtains the identifiable flowing water table of presetting database, comprising: before parsing by resolution table
The database operating instruction in table is held, loads the identifiable flowing water table of presetting database, wherein resolution table includes: front-end table
The mapping relations of database operating instruction in database operating instruction and flowing water table.
Optionally, front-end table includes multiple operational attributes, and front-end table is written in the different operation attribute of database operating instruction
In corresponding operational attribute position；Resolution table includes: that the mapping of each operational attribute and operational attribute in flowing water table in front-end table is closed
System.The database operating instruction in front-end table is parsed by resolution table, loads the identifiable flowing water table of presetting database, comprising:
Multiple operational attributes of the database operating instruction in front-end table are parsed by resolution table, obtain preset data in corresponding flowing water table
The identifiable multiple operational attributes in library.According to the identifiable multiple operational attributes of presetting database, loading presetting database can know
Other flowing water table.
It optionally, further include that identification acquisition database operating instruction indicates after presetting database being written in flowing water table
Object run.Presetting database performance objective is operated.
Optionally, if object run include delete operation, to presetting database performance objective operation before, further include by
The title of file to be deleted is updated to renaming title according to default naming rule, and by current time information and renames title
It is stored in file to be deleted, wherein include the mark of file to be deleted in database operating instruction.If according to current time information etc.
After preset duration, the instruction of revocation delete operation is not received, then deletes file to be deleted.
Second aspect, the embodiment of the invention also provides a kind of data administrators, including receiving module, before receiving
Hold table, wherein front-end table includes the database operating instruction of input.Parsing module obtains preset data for parsing front-end table
The identifiable flowing water table in library, wherein flowing water table is used to indicate database operating instruction.Writing module, for flowing water table to be written
Presetting database, wherein database operating instruction, which is used to indicate, operates presetting database performance objective.
Optionally, parsing module loads pre- specifically for parsing the database operating instruction in front-end table by resolution table
If the identifiable flowing water table of database, wherein resolution table includes: database in the database operating instruction and flowing water table of front-end table
The mapping relations of operational order.
Optionally, front-end table includes multiple operational attributes, and front-end table is written in the different operation attribute of database operating instruction
In corresponding operational attribute position；Resolution table includes: that the mapping of each operational attribute and operational attribute in flowing water table in front-end table is closed
System.Parsing module is obtained specifically for parsing multiple operational attributes of the database operating instruction in front-end table by resolution table
The identifiable multiple operational attributes of presetting database in corresponding flowing water table.Belonged to according to the identifiable multiple operations of presetting database
Property, load the identifiable flowing water table of presetting database.
Optionally, described device further includes execution module, obtains the target behaviour of database operating instruction instruction for identification
Make.Presetting database performance objective is operated.
Optionally, if object run includes delete operation, described device further includes removing module, for according to default life
The title of file to be deleted is updated to renaming title by name rule, and current time information and renaming title are stored in wait delete
Except file, wherein include the mark of file to be deleted in database operating instruction.If wait default according to current time information
After length, the instruction of revocation delete operation is not received, then deletes file to be deleted.
The beneficial effects of the present invention are: passing through the front-end table for receiving the database operating instruction including having input, wherein preceding
Holding the database operating instruction in table is visible instructions, be could fill out without learning sql like language also.Front-end table is parsed, is obtained pre-
If the identifiable flowing water table of database, operated using flowing water table instruction presetting database performance objective.Realize amateur data
Library personnel can also manage and maintain database, easy to operate, improve the efficiency for managing and maintaining database.
Detailed description of the invention
In order to illustrate the technical solution of the embodiments of the present invention more clearly, below will be to needed in the embodiment attached
Figure is briefly described, it should be understood that the following drawings illustrates only certain embodiments of the present invention, therefore is not construed as pair
The restriction of range for those of ordinary skill in the art without creative efforts, can also be according to this
A little attached drawings obtain other relevant attached drawings.
Fig. 1 is data managing method application scenarios schematic diagram provided by the present application；
Fig. 2 is the data managing method flow diagram that one embodiment of the application provides；
Fig. 3 is the front-end table schematic diagram that one embodiment of the application provides；
Fig. 4 is the resolution table mapping relations schematic diagram that one embodiment of the application provides；
Fig. 5 is that the flowing water that one embodiment of the application provides indicates to be intended to；
Fig. 6 is the data managing method flow diagram that another embodiment of the application provides；
Fig. 7 is the data managing method flow diagram that another embodiment of the application provides；
Fig. 8 is the data managing method flow diagram that another embodiment of the application provides；
Fig. 9 is the resolution table mapping relations schematic diagram for the type parsing that one embodiment of the application provides；
Figure 10 is the resolution table mapping relations schematic diagram for the constraint parsing that one embodiment of the application provides；
Figure 11 is the data administrator structural schematic diagram that one embodiment of the application provides；
Figure 12 is the data administrator structural schematic diagram that another embodiment of the application provides；
Figure 13 is the data administrator structural schematic diagram that another embodiment of the application provides；
Figure 14 is electronic devices structure schematic diagram provided by the present application.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments.
Fig. 1 is data managing method application scenarios schematic diagram provided by the present application.As shown in Figure 1, the applied field of this method
Scape may include: front-end table, processing system, database, feedback system.Wherein, the form of front-end table can be Excel table,
Form window etc. in web page form, software, form is not limited.
Above-mentioned front-end table, processing system, database and feedback system may be at same terminal, can also be in different ends
End.The type of terminal may include that laptop, desktop computer, tablet computer, server, Cloud Server etc. can be to data
The equipment for carrying out parsing management.For example, front-end table can fill in the laptop of user, processing system and feedback
System may operate on server, and database may operate in cloud etc.；Alternatively, front-end table can be in the desktop computer of user
On filled in, processing system, database, feedback system operate on the desktop computer of the user, herein with no restrictions.
In a kind of possible implementation, front-end table can be front end system generation, wherein the front end system is one
Simple interface, user easy-operating interactive system, such as small routine, webpage, software interface etc.；It is straight that front-end table is also possible to user
The form document filled in, such as Excel file are connect, herein with no restrictions.After user fills in front-end table, front-end table is submitted into processing
System, for example, build table button by the key for clicking leading portion system, Excel file is sent to preset address etc., processing system
After receiving front-end table, triggering processing system is read into the list, and processing is analyzed it, referred database executes corresponding behaviour
Make.It should be noted that database can be MySQL, MariaDB, Percona Server, PostgreSQL, Microsoft
Access, Microsoft SQL Server, Google Fusion Tables, FileMaker, oracle database,
One of the frequently-used datas such as Sybase, dBASE, Clipper, FoxPro, foshub library or combinations thereof, but not limited to this.
Fig. 2 is the data managing method flow diagram that one embodiment of the application provides.The executing subject of this method can be with
It is the equipment that laptop, desktop computer, tablet computer, server, Cloud Server etc. can carry out parsing management to data.
As shown in Fig. 2, this method comprises:
S101, receiving front-end table.
Wherein, front-end table includes the database operating instruction of input.
The database operating instruction filled in the front-end table of the application can be divided into not at the same level according to the type difference of user
Not, for example, general purpose grade user for no data library knowledge, can be used the database operating instruction of general purpose grade, for having
The base level user of master database knowledge, can be used the database operating instruction of base level, for specialized database
The professional user of managerial knowledge, also can be used professional database operating instruction.
In some embodiments, for general purpose grade user, the database operating instruction in front-end table be it is straightaway can
It is instructed depending on changing, which can be indicated using non-program statement.For example, user can be directly by selecting in a menu
Corresponding class of operation or by preset text fill in class of operation and according to instruction information other in front-end table it is complete
At the input of database operating instruction, but not limited to this.
S102, parsing front-end table, obtain the identifiable flowing water table of presetting database.
Wherein, flowing water table is used to indicate database operating instruction.
In some embodiments, the database operating instruction in front-end table is resolvable to as the identifiable number of presetting database
According to library operational order, flowing water table is used to indicate the identifiable database operating instruction of presetting database.
S103, presetting database is written into flowing water table.
Wherein, database operating instruction, which is used to indicate, operates presetting database performance objective.
In a kind of possible embodiment, the identifiable number of presetting database of presetting database parsing identification flowing water table instruction
According to library operational order, and execute the corresponding object run of the database operating instruction.
In the present embodiment, by the front-end table for receiving the database operating instruction including having input, wherein in front-end table
Database operating instruction is visible instructions, be could fill out without learning sql like language also.Front-end table is parsed, presetting database is obtained
Identifiable flowing water table is operated using flowing water table instruction presetting database performance objective.Realize amateur database personnel
Database can be managed and maintained, it is easy to operate, improve the efficiency for managing and maintaining database.
Optionally, front-end table is parsed, obtains the identifiable flowing water table of presetting database, comprising: before parsing by resolution table
The database operating instruction in table is held, loads the identifiable flowing water table of presetting database, wherein resolution table includes: front-end table
The mapping relations of database operating instruction in database operating instruction and flowing water table.
Fig. 3 is the front-end table schematic diagram that one embodiment of the application provides.
In a kind of possible embodiment, as shown in figure 3, may include: class of operation, table name, new table name, word in front-end table
Section name, newer field name, field annotation, data content, number of words, size etc., but not limited to this.
For different database operating instructions, need to fill in different class of operations, and according to the type of class of operation
Other are filled in, for example, carrying out building table handling, needs to fill out " building table " in class of operation, and provide table name in table name, it is other
Item is not filled out；Field is added to specified table, then need to fill out " addition field " in class of operation, and fill in specified table in " table name " item
Table name, " field name " item fill in the field name specified in the table, can be at " field annotation " if the field needs to annotate
Item fills in the related content of field annotation.Meanwhile in " field contents " item, it need to illustrate the data mode of field storage, such as
Storage number just to filling " number ", stores text, just inserts " text ", wherein when filling " number ", it is also necessary to fill in
" being integer or decimal " and " Digital size " item also need to fill in " number of words " item when filling " text ".
Fig. 4 is the resolution table mapping relations schematic diagram that one embodiment of the application provides, and Fig. 5 provides for one embodiment of the application
Flowing water indicate be intended to.
In a kind of possible embodiment, as shown in Fig. 3, Fig. 4 and Fig. 5, flowing water table is by meaning one, according to resolution table
Mapping relations are established with the database operating instruction in front-end table.
By taking the mapping relations of class of operation as an example, when the database operating instruction instruction class of operation in front-end table is modification
When table name, referring to the mapping relations schematic diagram of Fig. 4, corresponding meaning is modification table name, at this time the class of operation in flowing water table
Meaning position, it is corresponding to load the corresponding identifiable database operating instruction of presetting database of modification table name.
It should be noted that resolution table is shown in a tabular form in Fig. 4, but the type of resolution table not as
Limit, for example, it is also possible to be corresponding algorithm, default rule etc..
Fig. 6 is the data managing method flow diagram that another embodiment of the application provides.
Optionally, front-end table includes multiple operational attributes, and front-end table is written in the different operation attribute of database operating instruction
In corresponding operational attribute position；Resolution table includes: that the mapping of each operational attribute and operational attribute in flowing water table in front-end table is closed
System.
Wherein, each operational attribute of front-end table corresponds to a kind of type of parsing, and passes through corresponding resolution table and flowing water
Corresponding operational attribute establishes mapping relations in table.
Correspondingly, as shown in fig. 6, being loaded default above by the database operating instruction in resolution table parsing front-end table
The identifiable flowing water table of database, comprising:
S1021, multiple operational attributes that the database operating instruction in front-end table is parsed by resolution table, obtain corresponding stream
The identifiable multiple operational attributes of presetting database in water meter.
In a kind of possible embodiment, since, there are multiple operational attributes, each operational attribute is corresponding not in front-end table
Same resolution rules.Therefore, processing system can read resolution table by read module, then will according to database operating instruction
Multiple operational attributes are split, such as are split as corresponding behaviour by Naming conventions module, type parsing module, constraint parsing module
Make attribute, then according to resolution table corresponding with the operational attribute, parsed, presetting database can in the corresponding flowing water table of acquisition
Multiple operational attributes of identification.
Fig. 7 is the resolution table mapping relations schematic diagram for the type parsing that one embodiment of the application provides, and Fig. 8 is the application one
The resolution table mapping relations schematic diagram for the constraint parsing that embodiment provides.
For example, building table handling, addition field operations, check that user specifies the operation of table name, field name, it is pre- in advance by user
The rule of definition is parsed to operations such as table name, field name renamings by resolution table corresponding with Naming conventions；Such as Fig. 7
It is shown, according to " data content " in front-end table and combine the items such as " number of words ", " size ", " being integer or decimal ", by with class
Type parses corresponding resolution table and is parsed, and obtains satisfactory field type and length；As shown in figure 8, to addition field,
It is parsed etc. by resolution table corresponding with constraint parsing, but not limited to this.
S1022, according to the identifiable multiple operational attributes of presetting database, load the identifiable flowing water of presetting database
Table.
In a kind of possible embodiment, presetting database is identifiable more in the correspondence flowing water table that processing system will acquire
A operational attribute is loaded by loading module, obtains flowing water table.The flowing water sheet form of acquisition is as shown in figure 5, loading is good
In flowing water table, including attribute-name system value coding corresponding with the attribute, such as class of operation coding, corresponding system value
Deng herein with no restrictions.
Class of operation coding in flowing water table for indicating different class of operations, for example, the corresponding behaviour system of batch_ID
System numerical value is that the corresponding class of operation of 1052, operation_type is encoded to 1000, then flowing water table can be as shown in the table:
| batch_ID | operation_type | …… |
| 1052 | 1000 | …… |
It should be noted that can also include other attributes numerical value corresponding with the attribute in the flowing water table, for example, right
In operation_type this, can also include other operation, such as to the operation of table, 0000 expression modification table can be used
Name, 0001 expression modification table permission, 0002 indicate that modification table note, 0003 indicate that deletion table, 0004 indicate creation table；To field
Operation, can be used 1000 expressions increase field, 1001 indicate modification field types, 1002 indicate modification field names,
1003 indicate that modification field note, 1004 indicate to delete field；Operation to database can be used 2000 expressions and build library, 2001
It indicates to delete library, 2003 expression backup libraries, 2004 expression reduction backup libraries etc., but not limited to this.
Fig. 9 is the data managing method flow diagram that another embodiment of the application provides.
Optionally, as shown in figure 9, flowing water table is written after presetting database, further includes:
S104, identification obtain the object run of database operating instruction instruction.
In a kind of possible implementation, presetting database can monitor whether flowing water table is inserted by a trigger
Presetting database, when trigger detect flowing water table be inserted into, then can call default storing process, it is pre- that flowing water table is sent to this
If storing process, wherein the default storing process is that a band joins storing process, for receiving the parameter of trigger transmission, ginseng
Number content is the data in flowing water table.It is signified in analytic parameter after default storing process receives the parameter of trigger transmission
The object run shown obtains object run classification and data.
S105, presetting database performance objective is operated.
In a kind of possible implementation, storing process is preset as described above, is obtaining object run classification and data
Later, corresponding operation is executed to database, completes object run.
Optionally, after completing object run, default storing process obtains the state of the object run, such as success or mistake
It loses.The state of object run and corresponding state annotation are returned to flowing water table by default storing process, and are written in flowing water table
In the corresponding field of mode of operation.
In some embodiments, the mode of operation user since flowing water table is written can not directly read or user is difficult to manage
Solution, therefore can also include that a feedback system turns for the mode of operation in resolution flow water meter according to different user class
It changes the condition prompting information that can be read for target user into, and shows user, for example, for general purpose grade user, if mesh
Mark operation runs succeeded, then shows " success ", if object run executes failure, show " failure ", and show the object run
The reason of failure.
Figure 10 is the data managing method flow diagram that another embodiment of the application provides.
Optionally, as shown in Figure 10, if object run includes delete operation, it is operated to presetting database performance objective
Before, further includes:
S201, the title of file to be deleted is updated to renaming title according to default naming rule, and by current time
Information and renaming title are stored in file to be deleted, wherein include the mark of file to be deleted in database operating instruction.
In some embodiments, delete operation may include deleting database, deletion table.Firstly, it is necessary to according to default life
Name rule is updated to renaming title to by the title of file to be deleted, for example, for deleting database, naming rule be can be
" toDelDb " suffix is added afterwards at " database name "；For deleting table, naming rule can be to be added afterwards at " table name "
" toDelTb " suffix, but not limited to this.After the completion of according to naming rule renaming is preset, by current time information and again
Title is named to be stored in file to be deleted.
It should be noted that presetting database is waited for according to the mark location in database operating instruction including file to be deleted
File is deleted, the mark of file to be deleted can be characteristic value, filename of file to be deleted etc., herein with no restrictions.
If S202, after waiting preset duration according to current time information, not receiving the instruction of revocation delete operation, then deleting
Except file to be deleted.
In some embodiments, preset duration can be user-defined period, such as 48 hours, 7 days, one month,
Herein with no restrictions.
Optionally, delete operation can also include deleting field, when executing the operation for deleting field, need to first create field and delete
Except data cache table and field erasing time table, for example, field deletion data buffer storage table can be as shown in the table:
Field erasing time table can be as shown in the table:
After the completion of creation, field of the write-in as field type to be deleted in data buffer storage table is deleted in field,
Naming rule is " delete field name n_ serial number ", and serial number can be for one from increasing sequence.Then it is write in field erasing time table
Enter sequence number value and corresponding erasing time, which can determine according to above-mentioned preset duration.Field deletes data buffer storage
Table and field erasing time table establish mapping relations by serial number.At this point, field delete data buffer storage table in field to be deleted
The same field of type is null field, and data in field to be deleted are inserted into field and delete corresponding empty word in data buffer storage table
Then Duan Zhong deletes field to be deleted.
Optionally, before the field erasing time table preset time reaches, user can be by preset instructions, according to word
Section deletes data buffer storage table and field erasing time table restores deleted field.The field erasing time table preset time reaches
Later, presetting database then clears up the data in corresponding field deletion data buffer storage table.
By upper delete operation, slow deletion may be implemented, prevent user misoperation, lead to loss of data, enhance data
Safety.
Optionally, slow deletion can also be by will realize on file backup to alternate device to be deleted.It can will be to be deleted
File backup to local and remote backs up end, for example, backing up to local hard drive, backup server, backup harddisk or backup cloud disk
Deng generation backup file.After the completion of backup, file to be deleted is deleted, if not receiving revocation after preset duration deletes behaviour
Corresponding backup file is then deleted in the instruction of work, and but not limited to this.
Figure 11 is the data administrator structural schematic diagram that one embodiment of the application provides.
As shown in figure 11, which specifically includes:
Receiving module 301 is used for receiving front-end table, wherein front-end table includes the database operating instruction of input.
Parsing module 302 obtains the identifiable flowing water table of presetting database for parsing front-end table, wherein flowing water table is used
In referred database operational order.
Writing module 303, for presetting database to be written in flowing water table, wherein database operating instruction is used to indicate pair
The operation of presetting database performance objective.
Optionally, parsing module 302, specifically for parsing the database operating instruction in front-end table, dress by resolution table
Carry the identifiable flowing water table of presetting database, wherein resolution table includes: number in the database operating instruction and flowing water table of front-end table
According to the mapping relations of library operational order.
Optionally, front-end table includes multiple operational attributes, and front-end table is written in the different operation attribute of database operating instruction
In corresponding operational attribute position；Resolution table includes: that the mapping of each operational attribute and operational attribute in flowing water table in front-end table is closed
System.Parsing module 301, specifically for parsing multiple operational attributes of the database operating instruction in front-end table by resolution table,
Obtain the identifiable multiple operational attributes of presetting database in corresponding flowing water table.According to the identifiable multiple operations of presetting database
Attribute loads the identifiable flowing water table of presetting database.
Figure 12 is the data administrator structural schematic diagram that another embodiment of the application provides.
Optionally, as shown in figure 12 further include execution module 304, obtain the mesh of database operating instruction instruction for identification
Mark operation.Presetting database performance objective is operated.
Figure 13 is the data administrator structural schematic diagram that another embodiment of the application provides.
Optionally, as shown in figure 13, if object run include delete operation, further include removing module 305, for according to
The title of file to be deleted is updated to renaming title by default naming rule, and current time information and renaming title are deposited
Enter file to be deleted, wherein include the mark of file to be deleted in database operating instruction.If being waited according to current time information
After preset duration, the instruction of revocation delete operation is not received, then deletes file to be deleted.
The method that above-mentioned apparatus is used to execute previous embodiment offer, it is similar that the realization principle and technical effect are similar, herein not
It repeats again.
The above module can be arranged to implement one or more integrated circuits of above method, such as: one
Or multiple specific integrated circuits (Application Specific Integrated Circuit, abbreviation ASIC), or, one
Or multi-microprocessor (digital singnal processor, abbreviation DSP), or, one or more field programmable gate
Array (Field Programmable Gate Array, abbreviation FPGA) etc..For another example, when some above module passes through processing elements
When the form of part scheduler program code is realized, which can be general processor, such as central processing unit (Central
Processing Unit, abbreviation CPU) or it is other can be with the processor of caller code.For another example, these modules can integrate
Together, it is realized in the form of system on chip (system-on-a-chip, abbreviation SOC).
This application provides a kind of electronic equipment, as shown in figure 14, comprising:
Processor 401, computer readable storage medium 402 and bus 403, computer readable storage medium 402 are stored with
The executable machine readable instructions of processor 401, when electronic equipment operation, processor 401 and computer readable storage medium
It is communicated between 402 by bus 403, processor 401 executes machine readable instructions, to execute the step of above-mentioned data managing method
Suddenly.
Memory 401 is for storing program, the program that processor 402 calls memory 401 to store, to execute the above method
Embodiment.Specific implementation is similar with technical effect, and which is not described herein again.
Optionally, the present invention also provides a kind of program product, such as computer readable storage medium, including program, the journeys
Sequence is when being executed by processor for executing above method embodiment.
In several embodiments provided by the present invention, it should be understood that disclosed device and method can pass through it
Its mode is realized.For example, the apparatus embodiments described above are merely exemplary, for example, the division of the unit, only
Only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can be tied
Another system is closed or is desirably integrated into, or some features can be ignored or not executed.Another point, it is shown or discussed
Mutual coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or logical of device or unit
Letter connection can be electrical property, mechanical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of hardware adds SFU software functional unit.
The above-mentioned integrated unit being realized in the form of SFU software functional unit can store and computer-readable deposit at one
In storage media.Above-mentioned SFU software functional unit is stored in a storage medium, including some instructions are used so that a computer
Equipment (can be personal computer, server or the network equipment etc.) or processor (English: processor) execute this hair
The part steps of bright each embodiment the method.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory
(English: Read-Only Memory, abbreviation: ROM), random access memory (English: Random Access Memory, letter
Claim: RAM), the various media that can store program code such as magnetic or disk.
Claims (10)
1. a kind of data managing method characterized by comprising
Receiving front-end table, wherein the front-end table includes the database operating instruction of input；
The front-end table is parsed, obtains the identifiable flowing water table of presetting database, wherein the flowing water table is used to indicate the number
According to library operational order；
The presetting database is written into the flowing water table, wherein the database operating instruction is used to indicate to described default
The operation of database performance objective.
2. the method as described in claim 1, which is characterized in that the parsing front-end table, obtaining presetting database can know
Other flowing water table, comprising:
The database operating instruction in the front-end table is parsed by resolution table, loads the identifiable flowing water of the presetting database
Table, wherein the resolution table includes: that the database operating instruction of front-end table and database operating instruction in the flowing water table reflect
Penetrate relationship.
3. method according to claim 2, which is characterized in that the front-end table includes multiple operational attributes, the database
Corresponding operational attribute position in the front-end table is written in the different operation attribute of operational order；The resolution table includes: front end
The mapping relations of each operational attribute and operational attribute in the flowing water table in table；
The database operating instruction parsed in the front-end table by resolution table, it is identifiable to load the presetting database
Flowing water table, comprising:
Multiple operational attributes of the database operating instruction in the front-end table are parsed by resolution table, obtain the corresponding flowing water
The identifiable multiple operational attributes of presetting database described in table；
According to the identifiable multiple operational attributes of the presetting database, the identifiable flowing water table of the presetting database is loaded.
4. the method according to claim 1, which is characterized in that the presetting database is written in the flowing water table
Later, further includes:
Identification obtains the object run of the database operating instruction instruction；
The object run is executed to the presetting database.
5. method as claimed in claim 4, which is characterized in that if the object run includes delete operation, to described pre-
If database executes before the object run, further includes:
The title of file to be deleted is updated to renaming title according to default naming rule, and by current time information and described
It renames title and is stored in the file to be deleted, wherein include the mark of the file to be deleted in the database operating instruction
Know；
If not receiving the instruction for cancelling the delete operation after waiting preset duration according to the current time information, then deleting
Except the file to be deleted.
6. a kind of data administrator characterized by comprising
Receiving module is used for receiving front-end table, wherein the front-end table includes the database operating instruction of input；
Parsing module obtains the identifiable flowing water table of presetting database, wherein the flowing water table for parsing the front-end table
It is used to indicate the database operating instruction；
Writing module, for the presetting database to be written in the flowing water table, wherein the database operating instruction is for referring to
Show and the presetting database performance objective is operated.
7. device as claimed in claim 6, which is characterized in that the parsing module, specifically for parsing institute by resolution table
The database operating instruction in front-end table is stated, loads the identifiable flowing water table of the presetting database, wherein the resolution table packet
It includes: the mapping relations of database operating instruction in the database operating instruction of front-end table and the flowing water table.
8. device as claimed in claim 7, which is characterized in that the front-end table includes multiple operational attributes, the database
Corresponding operational attribute position in the front-end table is written in the different operation attribute of operational order；The resolution table includes: front end
The mapping relations of each operational attribute and operational attribute in the flowing water table in table；
The parsing module, specifically for parsing multiple operations of the database operating instruction in the front-end table by resolution table
Attribute obtains the identifiable multiple operational attributes of presetting database described in the corresponding flowing water table；
According to the identifiable multiple operational attributes of the presetting database, the identifiable flowing water table of the presetting database is loaded.
9. such as the described in any item devices of claim 6-8, which is characterized in that further include:
Execution module obtains the object run of the database operating instruction instruction for identification；
The object run is executed to the presetting database.
10. device as claimed in claim 9, which is characterized in that if the object run includes delete operation, further include:
Removing module, for the title of file to be deleted to be updated to renaming title according to default naming rule, and will be current
Temporal information and the renaming title are stored in the file to be deleted, wherein comprising described in the database operating instruction
The mark of file to be deleted；
If not receiving the instruction for cancelling the delete operation after waiting preset duration according to the current time information, then deleting
Except the file to be deleted.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910259922.7A CN109977104B (en) | 2019-04-01 | 2019-04-01 | Data management method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910259922.7A CN109977104B (en) | 2019-04-01 | 2019-04-01 | Data management method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109977104A true CN109977104A (en) | 2019-07-05 |
| CN109977104B CN109977104B (en) | 2021-04-16 |
Family
ID=67082291
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910259922.7A Active CN109977104B (en) | 2019-04-01 | 2019-04-01 | Data management method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109977104B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143355A (en) * | 2019-12-10 | 2020-05-12 | 北京字节跳动网络技术有限公司 | Data processing method and device |
| CN115981831A (en) * | 2021-10-14 | 2023-04-18 | 中移物联网有限公司 | Memory management method and related equipment |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102520963A (en) * | 2011-12-26 | 2012-06-27 | 重庆新媒农信科技有限公司 | Method and system for realizing service logic processing based on strongly-typed relation mapping |
| CN103473367A (en) * | 2013-09-27 | 2013-12-25 | 北京奇虎科技有限公司 | Method for using local application program in browser and web browser |
| CN103853803A (en) * | 2013-06-26 | 2014-06-11 | 携程计算机技术（上海）有限公司 | Database configuration file encapsulation method and operation method as well as operation device thereof |
| US20150278318A1 (en) * | 2012-10-04 | 2015-10-01 | Adobe Systems Incorporated | Rule-based extraction, transformation, and loading of data between disparate data sources |
| CN105224544A (en) * | 2014-05-30 | 2016-01-06 | 北大方正集团有限公司 | A kind of data editing method of database and device |
| CN107301186A (en) * | 2016-04-15 | 2017-10-27 | 中国移动通信集团重庆有限公司 | A kind of recognition methods of invalid data and device |
| CN108304463A (en) * | 2017-12-26 | 2018-07-20 | 中国广核电力股份有限公司 | A kind of data managing method and its database application component for database |
-
2019
- 2019-04-01 CN CN201910259922.7A patent/CN109977104B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102520963A (en) * | 2011-12-26 | 2012-06-27 | 重庆新媒农信科技有限公司 | Method and system for realizing service logic processing based on strongly-typed relation mapping |
| US20150278318A1 (en) * | 2012-10-04 | 2015-10-01 | Adobe Systems Incorporated | Rule-based extraction, transformation, and loading of data between disparate data sources |
| CN103853803A (en) * | 2013-06-26 | 2014-06-11 | 携程计算机技术（上海）有限公司 | Database configuration file encapsulation method and operation method as well as operation device thereof |
| CN103473367A (en) * | 2013-09-27 | 2013-12-25 | 北京奇虎科技有限公司 | Method for using local application program in browser and web browser |
| CN105224544A (en) * | 2014-05-30 | 2016-01-06 | 北大方正集团有限公司 | A kind of data editing method of database and device |
| CN107301186A (en) * | 2016-04-15 | 2017-10-27 | 中国移动通信集团重庆有限公司 | A kind of recognition methods of invalid data and device |
| CN108304463A (en) * | 2017-12-26 | 2018-07-20 | 中国广核电力股份有限公司 | A kind of data managing method and its database application component for database |
Non-Patent Citations (1)
| Title |
|---|
| 魏梨君等: "基于SQL的自助数据分析模式设计", 《嘉应学院学报(自然科学)》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143355A (en) * | 2019-12-10 | 2020-05-12 | 北京字节跳动网络技术有限公司 | Data processing method and device |
| CN111143355B (en) * | 2019-12-10 | 2023-04-25 | 北京字节跳动网络技术有限公司 | Data processing method and device |
| CN115981831A (en) * | 2021-10-14 | 2023-04-18 | 中移物联网有限公司 | Memory management method and related equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109977104B (en) | 2021-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| AU2014233672B2 (en) | System for metadata management | |
| US9772911B2 (en) | Pooling work across multiple transactions for reducing contention in operational analytics systems | |
| US20170351989A1 (en) | Providing supply chain information extracted from an order management system | |
| CN104573068A (en) | Information processing method based on megadata | |
| US20140324917A1 (en) | Reclamation of empty pages in database tables | |
| CN113127478B (en) | Analysis method and device for data endogenous blood edge relationship and computer equipment | |
| CN113656407B (en) | Data topology generation method and device, electronic equipment and storage medium | |
| US11429629B1 (en) | Data driven indexing in a spreadsheet based data store | |
| CN109977104A (en) | Data managing method and device | |
| CN102542036B (en) | Use the table optimized | |
| US6748388B1 (en) | Method and mechanism for storing and managing self-descriptive heterogeneous data | |
| US20210365406A1 (en) | Method and apparatus for processing snapshot, device, medium and product | |
| CN112860412B (en) | Service data processing method and device, electronic equipment and storage medium | |
| US11514236B1 (en) | Indexing in a spreadsheet based data store using hybrid datatypes | |
| US11500839B1 (en) | Multi-table indexing in a spreadsheet based data store | |
| CN112632266B (en) | Data writing method and device, computer equipment and readable storage medium | |
| CN113868138A (en) | Method, system, equipment and storage medium for acquiring test data | |
| US9785894B2 (en) | Simulation of supply chain plans using web service | |
| CN112164433A (en) | Hospital background data processing method and system | |
| CN113760861A (en) | Data migration method and device | |
| US20190370242A1 (en) | Electronic database and method for forming same | |
| US11544451B2 (en) | System and method for maintaining links and revisions | |
| US11443108B2 (en) | System and method for document management using branching | |
| US20240303219A1 (en) | Method, electronic device, and computer program product for monitoring storage resource objects | |
| US20240028823A1 (en) | System and method for maintaining links and revisions |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |