CN110019242A - Processing method, device and system for tables of data - Google Patents
Processing method, device and system for tables of data Download PDFInfo
- Publication number
- CN110019242A CN110019242A CN201711498909.4A CN201711498909A CN110019242A CN 110019242 A CN110019242 A CN 110019242A CN 201711498909 A CN201711498909 A CN 201711498909A CN 110019242 A CN110019242 A CN 110019242A
- Authority
- CN
- China
- Prior art keywords
- tables
- user
- configuration information
- specific data
- extended field
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Present disclose provides a kind of processing methods for tables of data, comprising: carries out a point list processing to the tables of data according to the corresponding multiple values of specific point of literary name section of the tables of data, generates multiple subdatasheets；User's request is received, user's request includes the corresponding particular value of the specific point of literary name section；It is requested according to the user, determines that subdatasheet belonging to the particular value is specific data table based on the first configuration information；At least one corresponding extended field of the specific data table is determined based on the second configuration information；And operational order is generated based on the specific data table and at least one described extended field, the operational order is used to carry out corresponding operating to the specific data table according to user request.
Description
Technical field
This disclosure relates to field of computer technology, more particularly, to it is a kind of for the processing method of tables of data, device and
System.
Background technique
With economic and science and technology fast development, all trades and professions generate more and more data and need to store or make
With.For example, with the development of the times, many original operation systems of enterprise are not able to satisfy the quick hair of enterprise largely
Exhibition, therefore each enterprise needs to extend various business, although too big variation does not occur for mainstream business, is different
Business has unique business datum, and how these personalized business datums carry out storing and urgently to be resolved using becoming
Technical problem.
In the scheme of the prior art, usually increase extended field in former table, or establish difference for different business
Expansion table be associated with former table.
During realizing present inventive concept, at least there are the following problems in the prior art for inventor's discovery: increasing and expands
The method of field is opened up as business is increasing, redundant field is more and more, and table structure can become to become increasingly complex, database
It can drastically reduce；The method of expansion table is established with the continuous extension of business, the complexity of code can be higher and higher.
Summary of the invention
In view of this, present disclose provides a kind for the treatment of method and apparatus for being efficiently used for tables of data.
An aspect of this disclosure provides a kind of processing method for tables of data, comprising: according to the tables of data
The corresponding multiple values of specific point of literary name section carry out a point list processing to the tables of data, generate multiple subdatasheets, receive user and ask
It asks, user's request includes the corresponding particular value of the specific point of literary name section, is requested according to the user, based on the first configuration
Information determines that subdatasheet belonging to the particular value is specific data table, determines the specific data based on the second configuration information
At least one corresponding extended field of table, and behaviour is generated based on the specific data table and at least one described extended field
It instructs, the operational order is used to carry out corresponding operating to the specific data table according to user request.
In accordance with an embodiment of the present disclosure, above-mentioned first configuration information include corresponding point of literary name section of each subdatasheet and
Divide the value of literary name section accordingly.
In accordance with an embodiment of the present disclosure, above-mentioned second configuration information includes at least one the corresponding extension of each subdatasheet
Field.
In accordance with an embodiment of the present disclosure, above-mentioned to be generated based on the specific data table and at least one described extended field
Operational order, comprising: predetermined registration operation instruction is stored in advance, the predetermined registration operation instruction includes table identifier and attribute-identifier,
And the table identifier is replaced according to the specific data table, the attribute mark is replaced according at least one described extended field
Know symbol, generates operational order.
It in accordance with an embodiment of the present disclosure, include at least one criteria field and at least one extension in above-mentioned subdatasheet
Field.
Another aspect of the disclosure provides a kind of processing unit for tables of data, comprising: divides table module, receives mould
Block, the first determining module, the second determining module, generation module.Wherein, divide table module according to specific point of literary name of the tables of data
The corresponding multiple values of section carry out a point list processing to the tables of data, generate multiple subdatasheets.Receiving module receives user's request,
User's request includes the corresponding particular value of the specific point of literary name section.First determining module is requested according to the user, base
Determine that subdatasheet belonging to the particular value is specific data table in the first configuration information.Second determining module is based on second and matches
Confidence breath determines at least one corresponding extended field of the specific data table.Generation module be based on the specific data table and
At least one described extended field generates operational order, and the operational order is used to be requested according to the user to the certain number
Corresponding operating is carried out according to table.
In accordance with an embodiment of the present disclosure, above-mentioned first configuration information include corresponding point of literary name section of each subdatasheet and
Divide the value of literary name section accordingly.
In accordance with an embodiment of the present disclosure, above-mentioned second configuration information includes at least one the corresponding extension of each subdatasheet
Field.
In accordance with an embodiment of the present disclosure, above-mentioned to be generated based on the specific data table and at least one described extended field
Operational order, comprising: predetermined registration operation instruction is stored in advance, the predetermined registration operation instruction includes table identifier and attribute-identifier,
And the table identifier is replaced according to the specific data table, the attribute mark is replaced according at least one described extended field
Know symbol, generates operational order.
It in accordance with an embodiment of the present disclosure, include at least one criteria field and at least one extension in above-mentioned subdatasheet
Field.
Another aspect of the disclosure provides a kind of processing system for tables of data, comprising: one or more processing
Device；Storage device, for storing one or more programs, wherein when one or more of programs are one or more of
When processor executes, so that one or more of processors execute method as described above.
Another aspect of the present disclosure provides a kind of non-volatile memory medium, is stored with computer executable instructions, institute
Instruction is stated when executed for realizing method as described above.
Another aspect of the present disclosure provides a kind of computer program, and the computer program, which includes that computer is executable, to be referred to
It enables, described instruction is when executed for realizing method as described above.
In accordance with an embodiment of the present disclosure, single table reduced performance and extension in the prior art can at least be partially solved
The problem of table code complexity, and therefore may be implemented to improve the technical effect of database performance.
Detailed description of the invention
By referring to the drawings to the description of the embodiment of the present disclosure, the above-mentioned and other purposes of the disclosure, feature and
Advantage will be apparent from, in the accompanying drawings:
Fig. 1 diagrammatically illustrate according to the embodiment of the present disclosure can be using the treating method and apparatus for tables of data
Exemplary system architecture；
Fig. 2 diagrammatically illustrates the applied field of the treating method and apparatus for tables of data according to the embodiment of the present disclosure
Scape；
Fig. 3 diagrammatically illustrates the flow chart of the processing method for tables of data according to the embodiment of the present disclosure；
Fig. 4 diagrammatically illustrates the block diagram of the processing unit for tables of data according to the embodiment of the present disclosure；And
Fig. 5 diagrammatically illustrates the calculating of the treating method and apparatus for being suitable for use in tables of data according to the embodiment of the present disclosure
The block diagram of machine system.
Specific embodiment
Hereinafter, will be described with reference to the accompanying drawings embodiment of the disclosure.However, it should be understood that these descriptions are only exemplary
, and it is not intended to limit the scope of the present disclosure.In addition, in the following description, descriptions of well-known structures and technologies are omitted, with
Avoid unnecessarily obscuring the concept of the disclosure.
Term as used herein is not intended to limit the disclosure just for the sake of description specific embodiment.It uses herein
The terms "include", "comprise" etc. show the presence of the feature, step, operation and/or component, but it is not excluded that in the presence of
Or add other one or more features, step, operation or component.
There are all terms (including technical and scientific term) as used herein those skilled in the art to be generally understood
Meaning, unless otherwise defined.It should be noted that term used herein should be interpreted that with consistent with the context of this specification
Meaning, without that should be explained with idealization or excessively mechanical mode.
It, in general should be according to this using statement as " at least one in A, B and C etc. " is similar to
Field technical staff is generally understood the meaning of the statement to make an explanation (for example, " system at least one in A, B and C "
Should include but is not limited to individually with A, individually with B, individually with C, with A and B, with A and C, have B and C, and/or
System etc. with A, B, C).Using statement as " at least one in A, B or C etc. " is similar to, generally come
Saying be generally understood the meaning of the statement according to those skilled in the art to make an explanation (for example, " having in A, B or C at least
One system " should include but is not limited to individually with A, individually with B, individually with C, with A and B, have A and C, have
B and C, and/or the system with A, B, C etc.).It should also be understood by those skilled in the art that substantially arbitrarily indicating two or more
The adversative conjunction and/or phrase of optional project shall be construed as either in specification, claims or attached drawing
A possibility that giving including one of these projects, either one or two projects of these projects.For example, phrase " A or B " should
A possibility that being understood to include " A " or " B " or " A and B ".
Embodiment of the disclosure provides a kind of processing method for tables of data and can apply the processing of this method
Device.This method comprises: the corresponding multiple values of specific point of literary name section according to tables of data carry out a point list processing to the tables of data, it is raw
At multiple subdatasheets, user's request is received, user request includes the corresponding particular value of specific point of literary name section, is asked according to user
It asks, determines that subdatasheet belonging to the particular value is specific data table based on the first configuration information, it is true based on the second configuration information
Fixed at least one corresponding extended field of the specific data table, and it is raw based on specific data table and at least one extended field
At operational order, which is used to carry out corresponding operating to specific data table according to user's request.
Fig. 1 diagrammatically illustrate according to the embodiment of the present disclosure can be using the treating method and apparatus for tables of data
Exemplary system architecture 100.It should be noted that only can showing using the system architecture of the embodiment of the present disclosure shown in Fig. 1
Example, to help skilled in the art to understand the technology contents of the disclosure, but is not meant to that the embodiment of the present disclosure cannot be used
In other equipment, system, environment or scene.
As shown in Figure 1, system architecture 100 may include terminal device 101,102,103, network according to this embodiment
104 and server 105.Network 104 between terminal device 101,102,103 and server 105 to provide communication link
Medium.Network 104 may include various connection types, such as wired, wireless communication link or fiber optic cables etc..
User can be used terminal device 101,102,103 and be interacted by network 104 with server 105, to receive or send out
Send message etc..Various telecommunication customer end applications, such as the application of shopping class, net can be installed on terminal device 101,102,103
(merely illustrative) such as the application of page browsing device, searching class application, instant messaging tools, mailbox client, social platform softwares.
Terminal device 101,102,103 can be the various electronic equipments with display screen and supported web page browsing, packet
Include but be not limited to smart phone, tablet computer, pocket computer on knee and desktop computer etc..
Server 105 can be to provide the server of various services, such as utilize terminal device 101,102,103 to user
The user inputted requests the back-stage management server (merely illustrative) handled.Back-stage management server can be to receiving
The data such as user's request analyze etc. processing, and by processing result (such as according to user's request or the webpage of generation,
Information or data etc.) feed back to terminal device.
It should be noted that the processing method provided by the embodiment of the present disclosure for tables of data generally can be by server
105 execute.Correspondingly, the processing unit provided by the embodiment of the present disclosure for tables of data generally can be set in server
In 105.It can also be by being different from server 105 and can be with for the processing method of tables of data provided by the embodiment of the present disclosure
The server or server cluster that terminal device 101,102,103 and/or server 105 communicate execute.Correspondingly, the disclosure is real
Applying the processing unit provided by example for tables of data also can be set in being different from server 105 and can be with terminal device
101,102,103 and/or server 105 communicate server or server cluster in.
For example, the tables of data of the embodiment of the present disclosure can store in one or more servers, terminal device 101,
In 102 or 103 any one (for example, terminal device 101, but not limited to this) receive user and input user's request, and should
User's request is sent to other terminal devices for being stored with the tables of data or capable of obtaining the tables of data, server or service
Device cluster, and the embodiment of the present disclosure is executed by receiving other terminal devices, server or the server cluster that the user requests
The provided processing method for tables of data, to be operated according to user request to corresponding data table.
It should be understood that the number of terminal device, network and server in Fig. 1 is only schematical.According to realization need
It wants, can have any number of terminal device, network and server.
Fig. 2 diagrammatically illustrates the applied field of the treating method and apparatus for tables of data according to the embodiment of the present disclosure
Scape.
As shown in Fig. 2, the application scenarios include user terminal 210 and database 220.
According to the embodiment of the present disclosure, user can input user's request by user terminal 210, for example, logarithm can be requested
Inquiry operation is carried out according to the data in library 220, is also possible to request to be updated the data in database 220 operation etc..
The method that the embodiment of the present disclosure provides can carry out corresponding operation to database 200 according to the request of user, so
Result is showed into user terminal 210 afterwards.For example, user requests the data in inquiry database 200 about account settlement business, the disclosure
Embodiment can request to generate corresponding operation instruction according to user, to extract corresponding data in database 200, then open up
Show to user.
It should be noted that being only the example that can apply the application scenarios of the embodiment of the present disclosure shown in Fig. 2, to help this
Field technical staff understands the technology contents of the disclosure, but be not meant to the embodiment of the present disclosure may not be usable for other equipment,
System, environment or scene.
Fig. 3 diagrammatically illustrates the flow chart of the processing method for tables of data according to the embodiment of the present disclosure.
As shown in figure 3, this method includes operation S301~S305.
In operation S301, the tables of data is carried out at point table according to specific point of literary name section corresponding multiple values of tables of data
Reason, generates multiple subdatasheets.
According to the embodiment of the present disclosure, tables of data may include multiple fields, such as may include criteria field (for example, every
The field that a business will be used), can also include extended field (for example, personalized field of each business).It can choose
Some field of tables of data carries out at point table tables of data according to the corresponding multiple values of the field as specific point of literary name section
Reason.
For example, the account payable table of certain enterprise may include criteria field: major key id, anti-heavy uuid, system coding, business are compiled
Code, clearing object, clearing object oriented, ou coding, the amount of money, currency type, direction (receivable or deal with), the business hours, when keeping accounts
Between, account settlement business, clearing grouping, applicant, department encodes, department name or invoice check and write off state etc..
For example, " account settlement business " that can choose the account payable table is used as specific point literary name section, for example, account settlement business pair
The multiple values answered may include Pop business, business school's business, college of law's business, then the account payable table can be divided into pop
Table, business school's sublist, college of law's sublist.Wherein, pop sublist may include the personalized extended field of pop business, such as: it orders
Odd numbers, type of service, level-one classification ID, level-one category name, mechanism ID etc..Business school's sublist may include business school's business
Personalized extended field, such as: enterprise/individual etc..
In the embodiments of the present disclosure, may include in each subdatasheet have at least one criteria field and at least one
Extended field.For example, may include all criteria fields and the corresponding business tool of the sublist of main table in each subdatasheet
The personalized extended field having.
According to the embodiment of the present disclosure, table rule subdata table progress information can be divided to match according to each subdatasheet
It sets.For example, each subdatasheet can correspond to first configuration information, which includes the subdatasheet pair
The value of point literary name section and corresponding point literary name section answered.For example, corresponding first configuration information of pop sublist includes point of the table
The value " pop business " of literary name section " account settlement business " and corresponding point of literary name section.Unique son can be determined according to configuration information
Tables of data.
In the embodiments of the present disclosure, the first configuration information can also include dividing table column, dividing table number (for example, subdatasheet
Record row it is excessive, then the subdatasheet can be divided into several tables of data and stored, such as sublist _ 1 pop, sublist _ 2 pop
Deng), document mark etc..It is appreciated that the embodiment of the present disclosure does not limit the particular content of the first configuration information, those skilled in the art
Member can according to the actual situation set it, only need to meet each first configuration information and corresponding subdatasheet is uniquely corresponding
?.
It, can also be according to the personalized extended field that each subdatasheet has to the subdata according to the embodiment of the present disclosure
Table is extended information configuration.For example, each subdatasheet can correspond to second configuration information, second configuration information
Including at least one corresponding extended field of each subdatasheet.For example, corresponding second configuration information of pop sublist may include
The personalized extended field of the five of the sublist: order number, type of service, level-one classification ID, level-one category name, mechanism ID.Again
For example, corresponding second configuration information of business school's sublist may include the property extended field one by one of the sublist: enterprise/
People.
According to the embodiment of the present disclosure, the first configuration information be can store in the attribute of Java bean, and second matches confidence
Breath can store in the TreeMap of Java bean.Pass through the second configuration information of extension and TreeMap collection when data save
Close the preservation that data can be realized.It activates business if increase is new, only needs to configure the first configuration information and the second configuration
The access newly activated business can be completed in information.
In operation S302, user's request is received, user request includes the corresponding particular value of specific point of literary name section.
According to the embodiment of the present disclosure, user's request may include carrying out inquiry operation to tables of data or updating to operate.
For example, user can select by operation interface, such as inquiry operation, inquiry can be selected in operation interface
This enterprise to the relevant data of pop account settlement business (the corresponding particular value of specific point of literary name section).
In the embodiments of the present disclosure, predetermined registration operation instruction can be stored in advance, predetermined registration operation instruction includes table identifier
(for example,@T1) and attribute-identifier (for example,@C).
For example, the predetermined registration operation instruction about inquiry operation for example may is that select id, uuid ... ...,
SettlementBizId ... ..., deptName, comparestatus ,@C from payable@T1where
Settlementbizid=# { settlementbizid }.
After receiving user's request, user request can be intercepted by Mybatis plug-in unit, and pass through the plug-in unit road
By replacing identifier in predetermined registration operation instruction, generating operational order to the first configuration information and the second configuration information.
It in operation S303, is requested according to user, determines subdatasheet belonging to particular value for spy based on the first configuration information
Determine tables of data.
According to the embodiment of the present disclosure, the first configuration information includes corresponding point of literary name section of each subdatasheet and corresponding
Divide the value of literary name section.
For example, first can be routed to by Mybatis plug-in unit with confidence after user requests inquiry pop account settlement business
Breath, from the first configuration information extract with " pop account settlement business " (specific point of literary name section=account settlement business, corresponding particular value=
Pop business) corresponding subdatasheet " pop sublist ".It is appreciated that the embodiment of the present disclosure is by storing matching for each subdatasheet
Confidence breath can be requested based on user, lock unique corresponding subdatasheet according to the configuration information.
In the embodiments of the present disclosure, after determining corresponding specific data table, it is default that specific data table replacement can be used
Table identifier@T1 in operational order.
In operation S304, at least one corresponding extended field of specific data table is determined based on the second configuration information.
According to the embodiment of the present disclosure, the second configuration information includes at least one corresponding extended field of each subdatasheet.
For example, corresponding second configuration information of pop sublist may include five personalized extended fields of the sublist: order number, business
Type, level-one classification ID, level-one category name, mechanism ID.In another example corresponding second configuration information of business school's sublist can wrap
Include the property extended field one by one of the sublist: enterprise/individual.
After determining specific data table is pop sublist, the second configuration information can be routed to by Mybatis plug-in unit,
The corresponding personalized extended field of the subdatasheet is extracted from the second configuration information (for example, order number, type of service, level-one
Classification ID, level-one category name, mechanism ID).It is appreciated that personalization of the embodiment of the present disclosure by each subdatasheet of storage
Extended field, confirmable tables of data obtain the individual cultivation that the tables of data has.
In the embodiments of the present disclosure, after determining at least one extended field, at least one extended field can be used and replace
Change the attribute-identifier@C in predetermined registration operation instruction.
In operation S305, operational order is generated based on specific data table and at least one extended field, operational order is used
It requests according to user to specific data table progress corresponding operating.
According to the embodiment of the present disclosure, according to the table identifier in determining specific data table replacement predetermined registration operation instruction, root
According to the attribute-identifier in determining at least one extended field replacement predetermined registration operation instruction.
For example, the specific data table determined is pop sublist, at least one extended field determined is order number, service class
Type, level-one classification ID, level-one category name, mechanism ID, then can be generated operational order: select id, uuid ... ...,
SettlementBizId ... ..., deptName, comparestatus, orderId, bussType, oneCategoryId,
OneCategoryName, orgId from payable_pop where settlementbizid=#
{ settlementbizid } (merely illustrative).
For example, the specific data table determined is business school's sublist, at least one extended field determined is enterprise/individual,
Operational order then can be generated: select id, uuid ... ..., settlementBizId ... ..., deptName,
Comparestatus, supplierType from payable_college where settlementbizid=#
{ settlementbizid } (merely illustrative).
In the embodiments of the present disclosure, can carry out corresponding operating in the database according to the operational order of generation, obtain with
User requests relevant data, so that data are showed user.
What the embodiment of the present disclosure provided divides table method and subdatasheet to store criteria field and corresponding personalized expansion
Field is opened up, different business Dynamic data exchange can be stored, it is non-cross, the influence between each business datum is solved, coupling is reduced
Property, reducing a business operation database is the performance issue occurred.
The embodiment of the present disclosure defines different business subdatasheets by the first configuration information and the second configuration information, and
Corresponding personalization extended field, can determine subdatasheet and its individuation data having by configuration information.
The embodiment of the present disclosure has less instruction code, and table mark and attribute-bit have been used in code, can basis
User's request routes plug-in unit by Mybatis and is replaced to the mark in instruction, so that the method that the disclosure provides can
To provide a set of easy extension, efficient solution for the business that constantly extends.
The method that the embodiment of the present disclosure provides can execute in multiple stage computers, and every computer is not accessible of the same trade or business
The table of business can disperse pressure, provide availability.And it can be used in the database schema of master-slave database, realize height
, the high service handled up can be used.
Fig. 4 diagrammatically illustrates the block diagram of the processing unit 400 for tables of data according to the embodiment of the present disclosure.
As shown in figure 4, the processing unit 400 for tables of data includes that table module 410, receiving module 420, first is divided to determine
Module 430, the second determining module 440 and generation module 450.
Table module 410 is divided to carry out a point list processing to tables of data according to the corresponding multiple values of specific point of literary name section of tables of data,
Generate multiple subdatasheets.According to the embodiment of the present disclosure, the behaviour described above with reference to Fig. 3 can be executed by dividing table module 410 for example
Make S301, details are not described herein.
Receiving module 420 receives user's request, and user's request includes the corresponding particular value of specific point of literary name section.According to this public affairs
Embodiment is opened, receiving module 420 can for example execute the operation S302 above with reference to Fig. 3 description, and details are not described herein.
First determining module 430 is requested according to user, determines subdatasheet belonging to particular value based on the first configuration information
For specific data table.According to the embodiment of the present disclosure, the first determining module 430 can for example execute the behaviour above with reference to Fig. 3 description
Make S303, details are not described herein.
Second determining module 440 determines at least one corresponding extended field of specific data table based on the second configuration information.
According to the embodiment of the present disclosure, the second determining module 440 can for example execute the operation S304 above with reference to Fig. 3 description, herein not
It repeats again.
Generation module 450 is based on specific data table and at least one extended field generates operational order, and operational order is used
It requests according to user to specific data table progress corresponding operating.According to the embodiment of the present disclosure, generation module 450 can for example be held
The operation S305 that row is described above with reference to Fig. 3, details are not described herein.
It is understood that dividing table module 410, receiving module 420, the first determining module 430, the second determining module 440
And generation module 450 may be incorporated in a module realize or any one module therein can be split into it is more
A module.Alternatively, at least partly function of one or more modules in these modules can be with other modules at least partly
Function combines, and realizes in a module.According to an embodiment of the invention, dividing table module 410, receiving module 420, first
At least one of determining module 430, the second determining module 440 and generation module 450 can be at least implemented partly as
On hardware circuit, such as field programmable gate array (FPGA), programmable logic array (PLA), system on chip, substrate is
System, the system in encapsulation, specific integrated circuit (ASIC), or can be to carry out any other conjunction that is integrated or encapsulating to circuit
The hardware such as reason mode or firmware realize, or is realized with software, the appropriately combined of three kinds of implementations of hardware and firmware.Or
Person divides in table module 410, receiving module 420, the first determining module 430, the second determining module 440 and generation module 450
At least one can at least be implemented partly as computer program module, when the program is run by computer, can execute
The function of corresponding module.
Fig. 5 is diagrammatically illustrated according to the treating method and apparatus being adapted for carrying out for tables of data of the embodiment of the present disclosure
The block diagram of computer system.Computer system shown in Fig. 5 is only an example, should not be to the function of the embodiment of the present disclosure
Any restrictions are brought with use scope.
As shown in figure 5, include processor 501 according to the computer system 500 of the embodiment of the present disclosure, it can be according to storage
It is loaded into random access storage device (RAM) 503 in the program in read-only memory (ROM) 502 or from storage section 508
Program and execute various movements appropriate and processing.Processor 501 for example may include general purpose microprocessor (such as CPU), refer to
Enable set processor and/or related chip group and/or special microprocessor (for example, specific integrated circuit (ASIC)), etc..Processing
Device 501 can also include the onboard storage device for caching purposes.Processor 501 may include describing for executing with reference to Fig. 3
The method flow according to the embodiment of the present disclosure different movements single treatment units either multiple processing units.
In RAM 503, it is stored with system 500 and operates required various programs and data.Processor 501, ROM 502 with
And RAM 503 is connected with each other by bus 504.Processor 501 is held by executing the program in ROM 502 and/or RAM 503
The various operations according to the embodiment of the present disclosure that row is described above with reference to Fig. 3.It is being removed it is noted that described program also can store
In one or more memories other than ROM 502 and RAM 503.Processor 501 can also be stored in described one by executing
Program in a or multiple memories executes the various operations according to the embodiment of the present disclosure described above with reference to Fig. 3.
In accordance with an embodiment of the present disclosure, system 500 can also include input/output (I/O) interface 505, input/output
(I/O) interface 505 is also connected to bus 504.System 500 can also include be connected to I/O interface 505 with one in lower component
Item is multinomial: the importation 506 including keyboard, mouse etc.；Including such as cathode-ray tube (CRT), liquid crystal display (LCD)
Deng and loudspeaker etc. output par, c 507；Storage section 508 including hard disk etc.；And including such as LAN card, modulatedemodulate
Adjust the communications portion 509 of the network interface card of device etc..Communications portion 509 executes communication process via the network of such as internet.
Driver 510 is also connected to I/O interface 505 as needed.Detachable media 511, such as disk, CD, magneto-optic disk, semiconductor
Memory etc. is mounted on as needed on driver 510, in order to be pacified as needed from the computer program read thereon
It is packed into storage section 508.
In accordance with an embodiment of the present disclosure, it may be implemented as computer software journey above with reference to the method for flow chart description
Sequence.For example, embodiment of the disclosure includes a kind of computer program product comprising carry meter on a computer-readable medium
Calculation machine program, the computer program include the program code for method shown in execution flow chart.In such embodiments,
The computer program can be downloaded and installed from network by communications portion 509, and/or be pacified from detachable media 511
Dress.When the computer program is executed by processor 501, the above-mentioned function of limiting in the system of the embodiment of the present disclosure is executed.Root
According to embodiment of the disclosure, system as described above, unit, module, unit etc. can by computer program module come
It realizes.
It should be noted that computer-readable medium shown in the disclosure can be computer-readable signal media or meter
Calculation machine readable storage medium storing program for executing either the two any combination.Computer readable storage medium for example can be --- but not
Be limited to --- electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor system, device or device, or any above combination.Meter
The more specific example of calculation machine readable storage medium storing program for executing can include but is not limited to: have the electrical connection, just of one or more conducting wires
Taking formula computer disk, hard disk, random access storage device (RAM), read-only memory (ROM), erasable type may be programmed read-only storage
Device (EPROM or flash memory), optical fiber, portable compact disc read-only memory (CD-ROM), light storage device, magnetic memory device,
Or above-mentioned any appropriate combination.In the disclosure, computer readable storage medium can be it is any include or storage journey
The tangible medium of sequence, the program can be commanded execution system, device or device use or in connection.And at this
In open, computer-readable signal media may include in a base band or as the data-signal that carrier wave a part is propagated,
Wherein carry computer-readable program code.The data-signal of this propagation can take various forms, including but unlimited
In electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be that computer can
Any computer-readable medium other than storage medium is read, which can send, propagates or transmit and be used for
By the use of instruction execution system, device or device or program in connection.Include on computer-readable medium
Program code can transmit with any suitable medium, including but not limited to: wireless, electric wire, optical cable, RF etc. are above-mentioned
Any appropriate combination.In accordance with an embodiment of the present disclosure, computer-readable medium may include above-described ROM 502
And/or one or more memories other than RAM 503 and/or ROM 502 and RAM 503.
Flow chart and block diagram in attached drawing are illustrated according to the system of the various embodiments of the disclosure, method and computer journey
The architecture, function and operation in the cards of sequence product.In this regard, each box in flowchart or block diagram can generation
A part of one module, program segment or code of table, a part of above-mentioned module, program segment or code include one or more
Executable instruction for implementing the specified logical function.It should also be noted that in some implementations as replacements, institute in box
The function of mark can also occur in a different order than that indicated in the drawings.For example, two boxes succeedingly indicated are practical
On can be basically executed in parallel, they can also be executed in the opposite order sometimes, and this depends on the function involved.Also it wants
It is noted that the combination of each box in block diagram or flow chart and the box in block diagram or flow chart, can use and execute rule
The dedicated hardware based systems of fixed functions or operations is realized, or can use the group of specialized hardware and computer instruction
It closes to realize.
As on the other hand, the disclosure additionally provides a kind of computer-readable medium, which can be
Included in equipment described in above-described embodiment；It is also possible to individualism, and without in the supplying equipment.Above-mentioned calculating
Machine readable medium carries one or more program, when said one or multiple programs are executed by the equipment, makes
It obtains the equipment to execute: the tables of data being carried out at point table according to specific point of literary name section corresponding multiple values of the tables of data
Reason generates multiple subdatasheets, receives user's request, and user's request includes that the specific point of literary name section is corresponding specific
Value is requested according to the user, determines that subdatasheet belonging to the particular value is specific data table based on the first configuration information,
At least one corresponding extended field of the specific data table is determined based on the second configuration information, and is based on the specific data
Table and at least one described extended field generate operational order, and the operational order is used to be requested according to the user to described
Specific data table carries out corresponding operating.
In accordance with an embodiment of the present disclosure, above-mentioned first configuration information include corresponding point of literary name section of each subdatasheet and
Divide the value of literary name section accordingly.
In accordance with an embodiment of the present disclosure, above-mentioned second configuration information includes at least one the corresponding extension of each subdatasheet
Field.
In accordance with an embodiment of the present disclosure, above-mentioned to be generated based on the specific data table and at least one described extended field
Operational order, comprising: predetermined registration operation instruction is stored in advance, the predetermined registration operation instruction includes table identifier and attribute-identifier,
And the table identifier is replaced according to the specific data table, the attribute mark is replaced according at least one described extended field
Know symbol, generates operational order.
It in accordance with an embodiment of the present disclosure, include at least one criteria field and at least one extension in above-mentioned subdatasheet
Field.
Embodiment of the disclosure is described above.But the purpose that these embodiments are merely to illustrate that, and
It is not intended to limit the scope of the present disclosure.Although respectively describing each embodiment above, but it is not intended that each reality
Use cannot be advantageously combined by applying the measure in example.The scope of the present disclosure is defined by the appended claims and the equivalents thereof.It does not take off
From the scope of the present disclosure, those skilled in the art can make a variety of alternatives and modifications, these alternatives and modifications should all fall in this
Within scope of disclosure.
Claims (12)
1. a kind of processing method for tables of data, comprising:
A point list processing is carried out to the tables of data according to the corresponding multiple values of specific point of literary name section of the tables of data, is generated multiple
Subdatasheet；
User's request is received, user's request includes the corresponding particular value of the specific point of literary name section；
It is requested according to the user, determines that subdatasheet belonging to the particular value is specific data based on the first configuration information
Table；
At least one corresponding extended field of the specific data table is determined based on the second configuration information；
Operational order is generated based on the specific data table and at least one described extended field, the operational order is used for root
Corresponding operating is carried out to the specific data table according to user request.
2. according to the method described in claim 1, wherein, first configuration information includes corresponding point of table of each subdatasheet
Field and the value for dividing literary name section accordingly.
3. according to the method described in claim 1, wherein, second configuration information includes that each subdatasheet is corresponding at least
One extended field.
4. according to the method described in claim 1, wherein, being based on the specific data table and at least one described extended field
Generate operational order, comprising:
Predetermined registration operation instruction is stored in advance, the predetermined registration operation instruction includes table identifier and attribute-identifier；
The table identifier is replaced according to the specific data table, the attribute mark is replaced according at least one described extended field
Know symbol, generates operational order.
5. including at least one criteria field and at least according to the method described in claim 1, wherein, in the subdatasheet
One extended field.
6. a kind of processing unit for tables of data, comprising:
Divide table module, the tables of data is carried out at point table according to specific point of literary name section corresponding multiple values of the tables of data
Reason, generates multiple subdatasheets；
Receiving module receives user's request, and user's request includes the corresponding particular value of the specific point of literary name section；
First determining module requests according to the user, determines subdata belonging to the particular value based on the first configuration information
Table is specific data table；
Second determining module determines at least one corresponding extended field of the specific data table based on the second configuration information；
Generation module generates operational order, the operation based on the specific data table and at least one described extended field
Instruction is for carrying out corresponding operating to the specific data table according to user request.
7. device according to claim 6, wherein first configuration information includes corresponding point of table of each subdatasheet
Field and the value for dividing literary name section accordingly.
8. device according to claim 6, wherein second configuration information includes that each subdatasheet is corresponding at least
One extended field.
9. device according to claim 6, wherein be based on the specific data table and at least one described extended field
Generate operational order, comprising:
Predetermined registration operation instruction is stored in advance, the predetermined registration operation instruction includes table identifier and attribute-identifier；
The table identifier is replaced according to the specific data table, the attribute mark is replaced according at least one described extended field
Know symbol, generates operational order.
10. device according to claim 6, wherein including at least one criteria field and extremely in the subdatasheet
A few extended field.
11. a kind of processing system for tables of data, comprising:
One or more processors；
Storage device, for storing one or more programs,
Wherein, when one or more of programs are executed by one or more of processors, so that one or more of
Processor executes method according to any one of claims 1 to 5.
12. a kind of computer-readable medium, is stored thereon with executable instruction, which hold processor when being executed by processor
Row method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711498909.4A CN110019242A (en) | 2017-12-29 | 2017-12-29 | Processing method, device and system for tables of data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711498909.4A CN110019242A (en) | 2017-12-29 | 2017-12-29 | Processing method, device and system for tables of data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110019242A true CN110019242A (en) | 2019-07-16 |
Family
ID=67187252
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711498909.4A Pending CN110019242A (en) | 2017-12-29 | 2017-12-29 | Processing method, device and system for tables of data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110019242A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457323A (en) * | 2019-08-08 | 2019-11-15 | 北京明略软件***有限公司 | The processing method and processing device of tables of data |
| CN112668287A (en) * | 2019-09-30 | 2021-04-16 | 北京国双科技有限公司 | Data table determination method, system and device |
| CN112767013A (en) * | 2021-01-05 | 2021-05-07 | 北京锐安科技有限公司 | Business report splitting method, device, server and storage medium |
| CN114756556A (en) * | 2022-06-15 | 2022-07-15 | 建信金融科技有限责任公司 | Method, device, electronic equipment and computer readable medium for processing account data |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2009146084A (en) * | 2007-12-13 | 2009-07-02 | Mitsubishi Electric Corp | Table management device |
| CN102968306A (en) * | 2012-11-29 | 2013-03-13 | 广东全通教育股份有限公司 | Method and system for automatically generating code based on data model drive |
| CN103020196A (en) * | 2012-12-03 | 2013-04-03 | 北京奇虎科技有限公司 | System for processing database operation request |
| CN103020193A (en) * | 2012-12-03 | 2013-04-03 | 北京奇虎科技有限公司 | Method and equipment for processing database operation request |
| CN105808437A (en) * | 2016-03-09 | 2016-07-27 | 广州彩瞳网络技术有限公司 | Automation testing method and system based on test case data table |
| CN106095878A (en) * | 2016-06-07 | 2016-11-09 | 中国建设银行股份有限公司 | The database manipulation device and method of table is divided based on point storehouse |
| CN106227799A (en) * | 2016-07-21 | 2016-12-14 | 江和慧 | A kind of sql statement processing method based on distributed data base |
| CN107038182A (en) * | 2016-09-27 | 2017-08-11 | 阿里巴巴集团控股有限公司 | Divide the completeness inspection method and device of table data |
-
2017
- 2017-12-29 CN CN201711498909.4A patent/CN110019242A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2009146084A (en) * | 2007-12-13 | 2009-07-02 | Mitsubishi Electric Corp | Table management device |
| CN102968306A (en) * | 2012-11-29 | 2013-03-13 | 广东全通教育股份有限公司 | Method and system for automatically generating code based on data model drive |
| CN103020196A (en) * | 2012-12-03 | 2013-04-03 | 北京奇虎科技有限公司 | System for processing database operation request |
| CN103020193A (en) * | 2012-12-03 | 2013-04-03 | 北京奇虎科技有限公司 | Method and equipment for processing database operation request |
| CN105808437A (en) * | 2016-03-09 | 2016-07-27 | 广州彩瞳网络技术有限公司 | Automation testing method and system based on test case data table |
| CN106095878A (en) * | 2016-06-07 | 2016-11-09 | 中国建设银行股份有限公司 | The database manipulation device and method of table is divided based on point storehouse |
| CN106227799A (en) * | 2016-07-21 | 2016-12-14 | 江和慧 | A kind of sql statement processing method based on distributed data base |
| CN107038182A (en) * | 2016-09-27 | 2017-08-11 | 阿里巴巴集团控股有限公司 | Divide the completeness inspection method and device of table data |
Non-Patent Citations (7)
| Title |
|---|
| JSJ01113NG: "mybatis***实现数据库水平切分", 《HTTPS://BLOG.CSDN.NET/WAGCY/ARTICLE/DETAILS/13002063》 * |
| LINKINSTAR: "MyBatis实现Mysql数据库分库分表操作和总结", 《HTTPS://WWW.CNBLOGS.COM/LINKSTAR/P/7404698.HTML》 * |
| LINKINSTAR: "MyBatis实现Mysql数据库分库分表操作和总结", 《博客园》 * |
| SELICOCO: "基于mybatis***分表实现", 《HTTPS://WWW.CNBLOGS.COM/SELINAMEE/P7110072.HTML》 * |
| WEIXIN_34248118: "MYSQL存储过程，为分表添加字段", 《HTTPS://BLOG.CSDN.NET/WEIXIN_34248118/ARTICLE/DETAILS/92070049》 * |
| 每天进步多一点: "动态sql语句基本语法", 《博客园》 * |
| 西山农夫: "SQL Server分表查询", 《博客园》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457323A (en) * | 2019-08-08 | 2019-11-15 | 北京明略软件***有限公司 | The processing method and processing device of tables of data |
| CN112668287A (en) * | 2019-09-30 | 2021-04-16 | 北京国双科技有限公司 | Data table determination method, system and device |
| CN112767013A (en) * | 2021-01-05 | 2021-05-07 | 北京锐安科技有限公司 | Business report splitting method, device, server and storage medium |
| CN114756556A (en) * | 2022-06-15 | 2022-07-15 | 建信金融科技有限责任公司 | Method, device, electronic equipment and computer readable medium for processing account data |
| CN114756556B (en) * | 2022-06-15 | 2022-09-27 | 建信金融科技有限责任公司 | Method, device, electronic equipment and computer readable medium for processing account data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108846753B (en) | Method and apparatus for processing data | |
| US10713090B2 (en) | Context aware prioritization in a distributed environment using tiered queue allocation | |
| CN110019242A (en) | Processing method, device and system for tables of data | |
| CN110019080B (en) | Data access method and device | |
| CN109034988A (en) | A kind of accounting entry generation method and device | |
| CN111427971B (en) | Business modeling method, device, system and medium for computer system | |
| WO2018219285A1 (en) | Data object display method and device | |
| CN109447635A (en) | Information storage means and device for block chain | |
| CN110706093A (en) | Accounting processing method and device | |
| CN109710859A (en) | Data query method and apparatus | |
| CN107862044A (en) | The method and apparatus of displayed page | |
| CN110427304A (en) | O&M method, apparatus, electronic equipment and medium for banking system | |
| CN109766127A (en) | Method for updating application version information | |
| CN109992406A (en) | The method and client that picture requesting method, response picture are requested | |
| CN110400201A (en) | Information displaying method, device, electronic equipment and medium | |
| CN110070394A (en) | Data processing method, system, medium and calculating equipment | |
| CN111258988B (en) | Asset management method, device, electronic equipment and medium | |
| US20170199912A1 (en) | Behavior topic grids | |
| CN108959642A (en) | Method and apparatus for information to be written | |
| CN110223179A (en) | The data processing method of fund, device, system, medium | |
| CN108399046A (en) | File operation requests treating method and apparatus | |
| CN113157271A (en) | Service processing method and device | |
| CN110928594A (en) | Service development method and platform | |
| CN110109912A (en) | A kind of identifier generation method and device | |
| CN109685472A (en) | A kind of electronic signature method, device, electronic equipment and medium |
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 |