CN107798030A - The method for splitting and device of tables of data - Google Patents
The method for splitting and device of tables of data Download PDFInfo
- Publication number
- CN107798030A CN107798030A CN201710087369.4A CN201710087369A CN107798030A CN 107798030 A CN107798030 A CN 107798030A CN 201710087369 A CN201710087369 A CN 201710087369A CN 107798030 A CN107798030 A CN 107798030A
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- task
- table name
- database
- 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
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
Abstract
The present invention relates to a kind of method for splitting of tables of data and device, this method includes：Task is obtained, data table name and field are carried in the task；The displaying configuration page, receive the data table name and field that user inputs in the configuration page；The script file of tables of data is split according to the data table name and field generation；According to tables of data corresponding to the tables of data name acquiring, the tables of data is split using the script file, obtains multiple sublists；Multiple sublists after loading fractionation, task is performed using multiple sublists.The time-consuming of tables of data loading can effectively be reduced using this method, improve operating efficiency.
Description
Technical field
The present invention relates to database technical field, more particularly to the method for splitting and device of a kind of tables of data.
Background technology
Database is usually to use tables of data data storage at present.With the accumulation of database usage time, in tables of data
Data also will constantly increase.When the data volume stored in tables of data is excessive, loading the time-consuming of the tables of data will increase, and add
Efficiency is carried to decline.The loading efficiency for how effectively improving tables of data is referred to as needing the technical problem solved at present.
The content of the invention
Based on this, it is necessary to for above-mentioned technical problem, there is provided it is a kind of effectively to reduce the time-consuming of tables of data loading, carry
The method for splitting and device of the tables of data of high workload efficiency.
A kind of method for splitting of tables of data, methods described include：
Task is obtained, data table name and field are carried in the task；
The displaying configuration page, receive the data table name and field that user inputs in the configuration page；
The script file of tables of data is split according to the data table name and field generation；
According to tables of data corresponding to the tables of data name acquiring, the tables of data is torn open using the script file
Point, obtain multiple sublists；
Multiple sublists after loading fractionation, task is performed using multiple sublists.
In one of the embodiments, the tables of data includes separator, described to utilize the script file to described
The step of tables of data is split includes：
Obtain the separator and the corresponding relation of field；
Data corresponding with the field are extracted in the tables of data according to the corresponding relation；
The data extracted are split using the script file.
In one of the embodiments, Database Identification and database user mark are also carried in the task；
Also include before the step of tables of data according to corresponding to the tables of data name acquiring：
Selection database corresponding with the Database Identification；
Inquiry whether there is required data with the corresponding tables of data of database user mark in the database chosen
Table name；
If it is not, data needed for then being extracted using the field in tables of data corresponding to database user mark；
Utilize the tables of data needed for required data creation task.
In one of the embodiments, described the step of being split using the script file to the tables of data it
Before, in addition to：
Obtain the character quantity of the data table name；
The character quantity of the data table name and the data table name is verified respectively；
If the data table name is not validated and/or the character quantity of the data table name is not validated,
Generation error prompt message.
In one of the embodiments, multiple sublists after the loading is split, appointed using multiple sublists to perform work
The step of business, includes：
Obtain the free time of database；
Multiple sublists after the free time loading of database is split, task is performed using multiple sublists.
A kind of detachment device of tables of data, described device include：
Acquisition module, for obtaining task, data table name and field are carried in the task；
Display module, the page is configured for showing；
Receiving module, the data table name and field inputted for receiving user in the configuration page；
Module is split, for splitting the script file of tables of data according to the data table name and field generation；Root
According to tables of data corresponding to the tables of data name acquiring, the tables of data is split using the script file, obtained more
Individual sublist；
Task execution module, for loading multiple sublists after splitting, task is performed using multiple sublists.
In one of the embodiments, the tables of data includes separator, and the acquisition module is additionally operable to described in acquisition
The corresponding relation of separator and field；It is described fractionation module be additionally operable to extract in the tables of data according to the corresponding relation and
Data corresponding to the field；The data extracted are split using the script file.
In one of the embodiments, Database Identification and database user mark are also carried in the task；
Described device also includes：
Tables of data creation module, for selecting database corresponding with the Database Identification；In the database chosen
Inquiry is with whether there is required data table name in the corresponding tables of data of database user mark；If it is not, then utilize the word
Section data needed for extraction in tables of data corresponding to database user mark；Using needed for required data creation task
Tables of data.
In one of the embodiments, the acquisition module is additionally operable to obtain the character quantity of the data table name；Institute
Stating device also includes：
Correction verification module, for being verified respectively to the character quantity of the data table name and the data table name；
If the data table name is not validated and/or the character quantity of the data table name is not validated, generation error
Prompt message.
In one of the embodiments, the acquisition module is additionally operable to obtain the free time of database；The task is held
Row module is additionally operable to multiple sublists after the free time loading of database is split, and is appointed using multiple sublists to perform work
Business.
The method for splitting and device of above-mentioned tables of data, when performing task, the tables of data that will be carried in task
The input such as name and field splits the script text of tables of data according to the data table name and field generation to configuring in the page
Part, tables of data is split using script file to obtain multiple sublists, then load multiple sublists after splitting to perform work
Make task.Because tables of data is split as multiple sublists to load, so as to when efficiently solving that stored number is excessive in tables of data,
The problem of time-consuming is loaded, and then operating efficiency can be effectively improved.
Brief description of the drawings
Fig. 1 is the flow chart of the method for splitting of tables of data in one embodiment；
Fig. 2 is the schematic diagram that the page is configured in one embodiment；
Fig. 3 is the structural representation of server in one embodiment；
Fig. 4 is the structural representation of the detachment device of tables of data in one embodiment.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only to explain the present invention, not
For limiting the present invention.
In one embodiment, as shown in Figure 1, there is provided a kind of method for splitting of tables of data, be applied in this way eventually
Illustrate, specifically include exemplified by end：
Step 102, task is obtained, data table name and field are carried in task.
Terminal obtains task.Task items, required data table name, field, field are carried in task
Type etc..Further, database is multiple that Database Identification and database user mark can also be carried in task
Deng.From there through the fast positioning such as Database Identification and database user mark to required tables of data.
Step 104, the displaying configuration page, data table name and field that user inputs in the page is configured are received.
Step 106, the script file of tables of data is split according to data table name and field generation.
Step 108, the tables of data according to corresponding to tables of data name acquiring, tables of data is split using script file,
Obtain multiple sublists.
If the data volume in tables of data is excessive, the time-consuming of the terminal loads tables of data can be caused to increase, so that
The efficiency that terminal performs task declines.In order to effectively improve the loading efficiency of tables of data, terminal can utilize the second application
Program is split to tables of data.
Different tables of data is split according to different tasks for the ease of user, terminal can show configuration
The page.Configuration the page on include multiple input frames, by multiple input frame users can in the page is configured respectively input needed for
Data table name, field and field type etc..Further, can also configured if there is multiple databases, user
Input database mark and database user mark etc. in the page.It is as shown in Figure 2 to configure the page.
The control for creating script file can also be included by configuring on the page.User can also click on after input is completed
The control of script file is created, the instruction for creating script file is generated by the control.Terminal is according to the finger for creating script file
Order, script file is generated using data table name, field and field type.Further, it is whole if there is multiple databases
End can generate corresponding script text using Database Identification, database user mark, data table name, field and field type
Part.
Terminal gets required tables of data according to data table name in database.If there is multiple data, then
Terminal can get required tables of data according to Database Identification, database user mark and data table name.Data
Table memory storage two-dimentional relation type data.Tables of data can use a variety of storage formats, for example, it may be excel forms, also with
It is pdf forms, can also be word forms etc..
Terminal can be split using the script file generated to tables of data, so as to reach multiple sublists.Terminal
Tables of data can be split according to line number using script file.Specifically, before script file is generated, user can root
The line number of each sublist is inputted in the page is configured according to the needs of task.This line number is referred to as splitting line number.Example
Such as, it can be 10,000 rows to split line number.Terminal is read line by line using script file to the tables of data got, according to fractionation
Line number is split to tables of data, obtains multiple sublists.
Terminal can also be split using shell script according to the time to tables of data.Specifically, in generation script file
Before, user can according to corresponding to the needs of task input each sublist in the page is configured the period.This time
Section is referred to as splitting the period.For example, it is one week to split the period.Second application program is using script file to getting
Tables of data read access time field, the data for belonging to section at the same time are divided into a sublist, tables of data is completed with this
Fractionation.Further, if the data volume in the sublist obtained after being split according to the time exceedes preset value, terminal can also be by
Sublist corresponding to the fractionation time is continued to split according to line number is split, thus obtains multiple sublists.
Terminal can also be split using shell script according to mechanism or area to tables of data.Specifically, in generation pin
Before this document, user can according to corresponding to the needs of task input each sublist in the page is configured mechanism or ground
Area.The mechanism is properly termed as detachment means, and this area is properly termed as splitting area.Terminal is using script file to the number that gets
According to table reading mechanism field or Region field, the data for belonging to same mechanism or area are divided into a sublist, with this
Complete the fractionation of tables of data.Further, if the data volume in the sublist obtained after being split according to mechanism or area exceedes in advance
If value, terminal can also continue to split according to line number is split to sublist corresponding to mechanism or area.Further, in order to
Convenient to perform task using mechanism sublist corresponding to some period or regional sublist, terminal can also be according to detachment means
Or regional sublist, fractionation time and fractionation line number are split to mechanism sublist or regional sublist, for example, entering to declaration form data
1 year clearing of row etc., mechanism sublist or regional sublist can be split according still further to fractionation time and fractionation line number, be obtained
Mechanism sublist or regional sublist to every month.
Step 110, multiple sublists after loading is split, task is performed using multiple sublists.
Multiple sublists after terminal loads fractionation, are read the data in multiple sublists, are performed using the data read
Task.For example, the first application program calculates Reserve Fund of declaration form etc. using the data in the multiple sublists read.
In the present embodiment, when performing task, by inputs such as the data table name carried in task and fields extremely
In the configuration page of terminal display, terminal splits the script file of tables of data according to data table name and field generation, utilizes pin
This document is split to obtain multiple sublists to tables of data, then loads multiple sublists after splitting to perform task.By
Multiple sublists are split as in tables of data to load, so as to which when efficiently solving that stored number is excessive in tables of data, loading is time-consuming
The problem of long, and then operating efficiency can be effectively improved.
In one embodiment, tables of data includes separator, the step of fractionation using script file to tables of data
Including：Separator and the corresponding relation of field are obtained using terminal；Extracted according to corresponding relation in tables of data corresponding with field
Data；The data extracted are split using script file.
In the present embodiment, tables of data memory storage two-dimentional relation type data.Tables of data can use a variety of storage formats, example
Such as, it can be excel forms, also to be pdf forms, can also be word forms etc..Tables of data for pdf forms or
The tables of data of word forms, if the data in tables of data are separated by arranging, but it is separated using separator
If, tables of data can be split with arranging the corresponding relation of (i.e. separator and field) by separator.Specifically, task
In carry separator and the corresponding relation of field in tables of data.For example, according to the order of separator, each separator corresponding one
Individual field.Terminal obtains the corresponding relation of separator and field, is extracted according to the corresponding relation in tables of data corresponding with field
Data, and split using script file to extracting data.Specifically, terminal can be according to carrying in above-described embodiment
To mode the data extracted are split by splitting line number, split time, detachment means or split area.Further
, terminal can also be split according to the time is split with splitting line number to the data extracted, or according to detachment means and
Split line number to split the data extracted, or according to detachment means, fractionation time and split line number to extracting
Data split.So as to obtain multiple sublists.It is thus corresponding using this because separator and field have corresponding relation
Relation and script file can be split automatically to the tables of data of multiple format.Consequently facilitating to a variety of of database memory storage
The tables of data of form is split according to the needs of task.
In one embodiment, Database Identification and database user mark are also carried in task；According to data
Also include before the step of tables of data corresponding to table name acquisition：Selection database corresponding with Database Identification；What is chosen
Inquiry is with whether there is required data table name in database in the corresponding tables of data of database user mark；It is if it is not, then sharp
With field in data needed for extraction in tables of data corresponding to database user mark；Using needed for required data creation task
Tables of data.
In the present embodiment, terminal, can be first in database before being split to the tables of data needed for task
Inquiry whether there is the tables of data, if in the presence of, can in a manner of being provided in directly according to above-described embodiment to tables of data progress
Split.If not depositing, terminal can create required tables of data in database.Specifically, terminal carries according in task
Database Identification come in database corresponding to selecting, it is multiple corresponding to searching database user mark in the database chosen
Tables of data, judge in multiple tables of data for retrieving with the presence or absence of the tables of data needed for task.If being not present, terminal profit
Extracted accordingly in multiple tables of data corresponding to database user mark with the field and field type carried in task
Data, the data extracted are referred to as data needed for task (can also referred to as needed for data).Terminal utilizes
Required data create the tables of data needed for task according to field and field type.So as to according to being carried in above-described embodiment
The mode of confession carries out tables of data fractionation.
In one embodiment, before the step of being split using script file to tables of data, in addition to：Obtain number
According to the character quantity of table name；The character quantity of data table name and data table name is verified respectively；If data table name
Claim not validated and/or data table name character quantity not validated, then generation error prompt message.
In the present embodiment, can be smoothed out in order to ensure the fractionation of tables of data, terminal before tables of data is split,
Data table name can also be verified.Specifically, terminal obtains the data table name carried in task, the data are calculated
The character quantity of table name.Terminal can first verification data table name verification data table name again character quantity, terminal also may be used
With the character quantity of first verification data table name, verification data table name, terminal can also be to data table names and data table name again
The character quantity of title is verified simultaneously.
By terminal can first verification data table name again exemplified by the character quantity of verification data table name, terminal is according to work
Database corresponding to the Database Identification selection that task carries, it is corresponding to retrieve database user mark in the database chosen
Multiple data table names.Terminal judges the data carried in the multiple data table names retrieved with the presence or absence of task
Table name, if so, then determining whether the data table name that task carries is unique, if not unique, represent tables of data
There is mistake in title, verification can not pass through.If unique, terminal determines whether the character quantity of data table name exceedes
Preset characters number, if so, then verification can not pass through.When the character quantity of data table name and/or data table name fails to pass through
During verification, it is impossible to carry out tables of data fractionation, terminal meeting generation error prompt message, so as to user's timely processing.
In one embodiment, multiple sublists after loading is split, the step of using multiple sublists to perform task
Including：Obtain the free time of database；Multiple sublists after the free time loading of database is split, utilize multiple sublists
To perform task.
In the present embodiment, task can be the monthly closing entry of declaration form calculates, Reserve Fund calculates or code insurance operates etc..With guarantor
The calculating logic of simple correlation all can be very complicated, and database will provide support to the task of multiple terminals.In order to effectively alleviate
The resource consumption of database, it can be held for the relatively low task of real-time processing requirement in the free time of database
OK.
The free time of database refers to time when database performance is optimal.Database is disposed on the server.Service
Monitoring script has been run on device, multiple databases are monitored using monitoring script, database is obtained according to monitoring information
Free time.The free time of database can be the period of whole non-working time can also be the part non-working time
Period.Terminal can interact with server, get the free time of database.Free time of the terminal in database
Multiple sublists after loading fractionation, utilize the multiple sublists loaded to perform task.
Further, terminal can calculate the amount of money of multiple projects when performing task using multiple model algorithms.
For example, task is declaration form code insurance, the project of required calculating includes Valid Insured Amount, risk protection amount and Reserve Fund etc..For
Same project, the model algorithm of different insurance kinds is probably different.Traditional mode is to be embedded in model algorithm to run certain
In program corresponding to individual project.Intersect because the calculating between disparity items may be present, for example, insured amount in calculation risk
When, it is also necessary to calculate Valid Insured Amount.Same model algorithm may be embedded in different item object program, is thus caused in different item
Overlapping development is carried out to same model algorithm in object program.
In order to effectively avoid the overlapping development of model algorithm, the redundancy of project procedure is reduced, model algorithm can individually enter
Row storage, when using some model algorithm, called by interface.Specifically, the second configuration is established on server
Table, the second allocation list include the fields such as insurance kind, algorithm mark and interface.Insurance kind of the server in declaration form data is second
Algorithm mark and interface, each insurance kind have corresponding model algorithm corresponding to being retrieved in allocation list, by being identified with algorithm
Corresponding interface can directly invoke model algorithm to calculate the corresponding amount of money.
Terminal to server sends the request for obtaining the second allocation list, obtains the second allocation list of server return.Sublist
Field include insurance kind.Calculative multiple projects are also carried in task.In the free time of database, terminal
Algorithm mark and interface corresponding in the second allocation list retrieving project according to insurance kind, pass through interface interchange and algorithm mark pair
The model algorithm answered, the amount of money of multiple projects in evaluation work task is distinguished according to model algorithm and multiple sublists of loading.
In this process, it is not necessary to model algorithm corresponding to each project configuration, retrieved by the second allocation list
Corresponding algorithm mark and interface, are calculated so as to directly invoke corresponding model algorithm.It effectively prevent project journey
The overlapping development of sequence, and effectively reduce program redundancy.
In one embodiment, as shown in Figure 3, there is provided a kind of terminal 300, including the processing connected by system bus
Device 301, non-volatile memory medium 302, internal memory 303, network interface 304, display screen 305 and input unit 306.Wherein, should
The detachment device 3022 of operating system 3021 and tables of data, tables of data are stored with the non-volatile memory medium 302 of server
Detachment device be used to realize and reduce the time-consuming of tables of data loading, improve operating efficiency.The processor 301 of terminal 300 is used to carry
For calculating and control ability, it is configured as performing a kind of method for splitting of tables of data.The internal memory 303 of terminal 300 is non-volatile
The operation of the detachment device of tables of data in storage medium provides environment, and computer-readable instruction can be stored in internal memory 303, should
When computer-readable instruction is executed by processor, a kind of method for splitting of tables of data of computing device may be such that.Server 300
Network interface 304 is used to communicate by network connection with the terminal or server of outside according to this, for example sends and obtain to server
Request of second allocation list etc..The display screen 305 of terminal 300 can be LCDs or electric ink display screen etc., defeated
It can be button, the trace ball set on the touch layer or the shell of terminal 300 covered on display screen 305 to enter device 306
Or Trackpad or external keyboard, Trackpad or mouse etc..It will be understood by those skilled in the art that shown in Fig. 3
The block diagram of structure, the only part-structure related to application scheme, do not form and application scheme is applied thereon
Terminal restriction, specific terminal can include than more or less parts shown in figure, or some parts of combination, or
Person has different part arrangements.
In one embodiment, as shown in Figure 4, there is provided a kind of detachment device of tables of data, including：Acquisition module 402,
Display module 404, receiving module 406, module 408 and task execution module 410 are split, wherein：
Acquisition module 402, for obtaining task, data table name and field are carried in task.
Display module 404, the page is configured for showing.
Receiving module 406, the data table name and field inputted for receiving user in the page is configured.
Module 408 is split, for splitting the script file of tables of data according to data table name and field generation；According to data
Tables of data corresponding to table name acquisition, is split to tables of data using script file, obtains multiple sublists.
Task execution module 410, for loading multiple sublists after splitting, task is performed using multiple sublists.
In one of the embodiments, tables of data includes separator, and acquisition module 402 is additionally operable to obtain separator and word
The corresponding relation of section；Module 408 is split to be additionally operable to extract data corresponding with field in tables of data according to corresponding relation；Utilize
Script file is split to the data extracted.
In one of the embodiments, Database Identification and database user mark are also carried in task；The dress
Putting also includes：Tables of data creation module 412, for selecting database corresponding with Database Identification；In the database chosen
Inquiry is with whether there is required data table name in the corresponding tables of data of database user mark；If it is not, then existed using field
Data needed for extraction in tables of data corresponding to database user mark；Utilize the data needed for required data creation task
Table.
In one of the embodiments, acquisition module 402 is additionally operable to obtain the character quantity of data table name；The device is also
Including：Correction verification module 414, for being verified respectively to the character quantity of data table name and data table name；If tables of data
Title is not validated and/or the character quantity of data table name is not validated, then generation error prompt message.
In one of the embodiments, acquisition module 402 is additionally operable to obtain the free time of database；Task execution module
410 are additionally operable to multiple sublists after the free time loading of database is split, and task is performed using multiple sublists.
One of ordinary skill in the art will appreciate that realize all or part of flow in above-described embodiment method, being can be with
Instruct the hardware of correlation to complete by computer program, program can be stored in a non-volatile computer storage can be read
In medium, the program is upon execution, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, storage medium can be magnetic
Dish, CD, read-only memory (Read-Only Memory, ROM) etc..
Each technical characteristic of above example can be combined arbitrarily, to make description succinct, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, lance is not present in the combination of these technical characteristics
Shield, all it is considered to be the scope of this specification record.
Above example only expresses the several embodiments of the present invention, and its description is more specific and detailed, but can not
Therefore it is construed as limiting the scope of the patent.It should be pointed out that for the person of ordinary skill of the art,
On the premise of not departing from present inventive concept, various modifications and improvements can be made, these belong to protection scope of the present invention.
Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (10)
1. a kind of method for splitting of tables of data, methods described include：
Task is obtained, data table name and field are carried in the task；
The displaying configuration page, receive the data table name and field that user inputs in the configuration page；
The script file of tables of data is split according to the data table name and field generation；
According to tables of data corresponding to the tables of data name acquiring, the tables of data is split using the script file,
Obtain multiple sublists；
Multiple sublists after loading fractionation, task is performed using multiple sublists.
2. according to the method for claim 1, it is characterised in that the tables of data includes separator, described in the utilization
The step of script file is split to the tables of data includes：
Obtain the separator and the corresponding relation of field；
Data corresponding with the field are extracted in the tables of data according to the corresponding relation；
The data extracted are split using the script file.
3. according to the method for claim 1, it is characterised in that Database Identification sum is also carried in the task
Identified according to storehouse user；Also include before the step of tables of data according to corresponding to the tables of data name acquiring：
Selection database corresponding with the Database Identification；
Inquiry is with whether there is required data table name in the database chosen in the corresponding tables of data of database user mark
Claim；
If it is not, data needed for then being extracted using the field in tables of data corresponding to database user mark；
Utilize the tables of data needed for required data creation task.
4. according to the method for claim 1, it is characterised in that the tables of data is entered using the script file described
Before the step of row is split, in addition to：
Obtain the character quantity of the data table name；
The character quantity of the data table name and the data table name is verified respectively；
If the data table name is not validated and/or the character quantity of the data table name is not validated, generate
Miscue information.
5. according to the method described in claim any one of 1-4, it is characterised in that described to be loaded using first application program
Multiple sublists after fractionation, include the step of using multiple sublists to perform task：
Obtain the free time of database；
Multiple sublists after the free time loading of database is split, task is performed using multiple sublists.
6. a kind of detachment device of tables of data, it is characterised in that described device includes：
Acquisition module, for obtaining task, data table name and field are carried in the task；
Display module, the page is configured for showing；
Receiving module, the data table name and field inputted for receiving user in the configuration page；
Module is split, for splitting the script file of tables of data according to the data table name and field generation；According to institute
Tables of data corresponding to tables of data name acquiring is stated, the tables of data is split using the script file, obtains more height
Table；
Task execution module, for loading multiple sublists after splitting, task is performed using multiple sublists.
7. device according to claim 6, it is characterised in that the tables of data includes separator, the acquisition module
It is additionally operable to obtain the separator and the corresponding relation of field；The fractionation module is additionally operable to according to the corresponding relation described
Data corresponding with the field are extracted in tables of data；The data extracted are split using the script file.
8. device according to claim 6, it is characterised in that Database Identification sum is also carried in the task
Identified according to storehouse user；Described device also includes：
Tables of data creation module, for selecting database corresponding with the Database Identification；Inquired about in the database chosen
With whether there is required data table name in the corresponding tables of data of database user mark；If it is not, then existed using the field
Data needed for extraction in tables of data corresponding to the database user mark；Utilize the number needed for required data creation task
According to table.
9. device according to claim 6, it is characterised in that the acquisition module is additionally operable to obtain the data table name
Character quantity；Described device also includes：
Correction verification module, for being verified respectively to the character quantity of the data table name and the data table name；If institute
State that data table name is not validated and/or the character quantity of the data table name is not validated, then generation error is prompted
Information.
10. according to the device described in claim any one of 6-9, it is characterised in that the acquisition module is additionally operable to obtain data
The free time in storehouse；The task execution module is additionally operable to multiple sublists after the free time loading of database is split, profit
Task is performed with multiple sublists.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710087369.4A CN107798030B (en) | 2017-02-17 | 2017-02-17 | Splitting method and device of data table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710087369.4A CN107798030B (en) | 2017-02-17 | 2017-02-17 | Splitting method and device of data table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107798030A true CN107798030A (en) | 2018-03-13 |
| CN107798030B CN107798030B (en) | 2020-07-03 |
Family
ID=61530152
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710087369.4A Active CN107798030B (en) | 2017-02-17 | 2017-02-17 | Splitting method and device of data table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107798030B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109102754A (en) * | 2018-06-20 | 2018-12-28 | 新华三大数据技术有限公司 | The generation method and device of data map |
| CN109614622A (en) * | 2018-12-11 | 2019-04-12 | 北京锐安科技有限公司 | Valid data extracting method, device, storage medium and terminal |
| WO2019200757A1 (en) * | 2018-04-19 | 2019-10-24 | 平安科技（深圳）有限公司 | Data importing method and apparatus, and computer device and storage medium |
| US20210019299A1 (en) * | 2019-07-17 | 2021-01-21 | Aveva Software, Llc | System and server comprising database schema for accessing and managing utilization and job data |
| CN112434078A (en) * | 2020-11-20 | 2021-03-02 | 广州奇享科技有限公司 | Boiler data processing method, device, equipment and storage medium |
| CN112767013A (en) * | 2021-01-05 | 2021-05-07 | 北京锐安科技有限公司 | Business report splitting method, device, server and storage medium |
| CN114119202A (en) * | 2021-11-29 | 2022-03-01 | 阿尔法时刻科技(深圳)有限公司 | Automatic configuration method and system of credit management platform |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6691132B2 (en) * | 2001-05-16 | 2004-02-10 | Reengineering Llc | Semantic encoding and compression of database tables |
| US7089255B1 (en) * | 2001-03-30 | 2006-08-08 | Unisys Corporation | Intelligent step presentation |
| CN101566986A (en) * | 2008-04-21 | 2009-10-28 | 阿里巴巴集团控股有限公司 | Method and device for processing data in online business processing |
| CN102682044A (en) * | 2011-04-14 | 2012-09-19 | 天脉聚源(北京)传媒科技有限公司 | Method for splitting tables for PHP MYSQL database |
| CN104298695A (en) * | 2013-07-19 | 2015-01-21 | 腾讯科技（深圳）有限公司 | Data caching method and device and server |
| CN104598212A (en) * | 2013-10-30 | 2015-05-06 | 上海联影医疗科技有限公司 | Image processing method and device based on algorithm library |
| CN105677846A (en) * | 2016-01-06 | 2016-06-15 | 中国传媒大学 | Recommendation system and construction method thereof |
| US20160314121A1 (en) * | 2012-04-02 | 2016-10-27 | Taiger Spain Sl | System and method for natural language querying |
| CN106156186A (en) * | 2015-04-21 | 2016-11-23 | 阿里巴巴集团控股有限公司 | A kind of data model managing device, server and data processing method |
| CN106168949A (en) * | 2016-05-03 | 2016-11-30 | 泰康保险集团股份有限公司 | The method and device that data base splits |
-
2017
- 2017-02-17 CN CN201710087369.4A patent/CN107798030B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7089255B1 (en) * | 2001-03-30 | 2006-08-08 | Unisys Corporation | Intelligent step presentation |
| US6691132B2 (en) * | 2001-05-16 | 2004-02-10 | Reengineering Llc | Semantic encoding and compression of database tables |
| CN101566986A (en) * | 2008-04-21 | 2009-10-28 | 阿里巴巴集团控股有限公司 | Method and device for processing data in online business processing |
| CN102682044A (en) * | 2011-04-14 | 2012-09-19 | 天脉聚源(北京)传媒科技有限公司 | Method for splitting tables for PHP MYSQL database |
| US20160314121A1 (en) * | 2012-04-02 | 2016-10-27 | Taiger Spain Sl | System and method for natural language querying |
| CN104298695A (en) * | 2013-07-19 | 2015-01-21 | 腾讯科技（深圳）有限公司 | Data caching method and device and server |
| CN104598212A (en) * | 2013-10-30 | 2015-05-06 | 上海联影医疗科技有限公司 | Image processing method and device based on algorithm library |
| CN106156186A (en) * | 2015-04-21 | 2016-11-23 | 阿里巴巴集团控股有限公司 | A kind of data model managing device, server and data processing method |
| CN105677846A (en) * | 2016-01-06 | 2016-06-15 | 中国传媒大学 | Recommendation system and construction method thereof |
| CN106168949A (en) * | 2016-05-03 | 2016-11-30 | 泰康保险集团股份有限公司 | The method and device that data base splits |
Non-Patent Citations (2)
| Title |
|---|
| SOWMIA DEVI M.K. ET AL: "Dynamic Interface Selection in Portable Multi-interface Terminals", 《2007IEEE INTERNATIONAL CONFERENCE ON PORTABLE INFORMATION DEVICES》 * |
| 刘欢欢 等: "基于PaaS的云应用软件部署环境的元模型", 《计算机科学》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2019200757A1 (en) * | 2018-04-19 | 2019-10-24 | 平安科技（深圳）有限公司 | Data importing method and apparatus, and computer device and storage medium |
| CN109102754A (en) * | 2018-06-20 | 2018-12-28 | 新华三大数据技术有限公司 | The generation method and device of data map |
| CN109614622A (en) * | 2018-12-11 | 2019-04-12 | 北京锐安科技有限公司 | Valid data extracting method, device, storage medium and terminal |
| US20210019299A1 (en) * | 2019-07-17 | 2021-01-21 | Aveva Software, Llc | System and server comprising database schema for accessing and managing utilization and job data |
| CN112434078A (en) * | 2020-11-20 | 2021-03-02 | 广州奇享科技有限公司 | Boiler data processing method, device, equipment and storage medium |
| CN112767013A (en) * | 2021-01-05 | 2021-05-07 | 北京锐安科技有限公司 | Business report splitting method, device, server and storage medium |
| CN114119202A (en) * | 2021-11-29 | 2022-03-01 | 阿尔法时刻科技(深圳)有限公司 | Automatic configuration method and system of credit management platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107798030B (en) | 2020-07-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107798030A (en) | The method for splitting and device of tables of data | |
| US11294968B2 (en) | Combining website characteristics in an automatically generated website | |
| CN108764674B (en) | Risk control method and device based on rule engine | |
| US20120192051A1 (en) | Formatting data by example | |
| US8312369B2 (en) | Information display apparatus, method, and recording medium for saving and displaying note information in association with contextual information | |
| CN104866426A (en) | Software test integrated control method and system | |
| CN109308254B (en) | Test method, test device and test equipment | |
| US9424168B2 (en) | System and method for automatic generation of software test | |
| CN106951254B (en) | Method and device for multiplexing similar service function modules in payment system | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| JP2010015458A (en) | Program correction support system, program correction support method, and program correction support program | |
| CN104199648B (en) | A kind of General Mobile information system adaptation method and device | |
| CN105653273A (en) | Personalized customizing method for client function under B/S architecture | |
| CN115469849B (en) | Service processing system, method, electronic equipment and storage medium | |
| CN111931475A (en) | Dynamic subscription book generation method, system, computer equipment and storage medium | |
| CN111427577A (en) | Code processing method and device and server | |
| CN115774672A (en) | Test case generation method, test case generation device, server and storage medium | |
| JP6861176B2 (en) | Project estimation support method and project estimation support device | |
| CN113886906A (en) | CAD drawing loading method, font file replacing method, device and storage medium | |
| CN105893546A (en) | One-time asynchronous checking and accurate positioning prompt mode adopted in BS software system | |
| US11036927B1 (en) | Relative positional parsing of documents using trees | |
| CN117608839A (en) | Task processing method, device, electronic equipment and storage medium | |
| US8370292B2 (en) | Identifying and defining information services for delivery in a service oriented architecture | |
| CN113205421A (en) | Accounting method and device for financial products | |
| CN117556796A (en) | Project document processing method, device, computer equipment and storage 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |