CN109684332A - A kind of wide table generating method of data, apparatus and system - Google Patents
A kind of wide table generating method of data, apparatus and system Download PDFInfo
- Publication number
- CN109684332A CN109684332A CN201811564613.2A CN201811564613A CN109684332A CN 109684332 A CN109684332 A CN 109684332A CN 201811564613 A CN201811564613 A CN 201811564613A CN 109684332 A CN109684332 A CN 109684332A
- Authority
- CN
- China
- Prior art keywords
- data
- configuration
- wide
- wide table
- incidence relation
- 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
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000012545 processing Methods 0.000 claims abstract description 42
- 238000006243 chemical reaction Methods 0.000 claims description 19
- 238000013523 data management Methods 0.000 claims description 4
- 238000013519 translation Methods 0.000 claims description 3
- 238000011161 development Methods 0.000 abstract description 7
- 230000008569 process Effects 0.000 description 14
- 238000012986 modification Methods 0.000 description 6
- 230000004048 modification Effects 0.000 description 6
- 230000008901 benefit Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 238000003780 insertion Methods 0.000 description 4
- 230000037431 insertion Effects 0.000 description 4
- 239000000284 extract Substances 0.000 description 3
- 230000009466 transformation Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 230000007704 transition Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000009471 action Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present embodiments relate to technical field of data processing, a kind of wide table generating method of data, apparatus and system are disclosed, this method comprises: configuration information needed for receiving the wide table of generation data of user's input；At least two configuration steps corresponding with the wide table of data are established according to configuration information；Determine the incidence relation between at least two configuration steps；According to the incidence relation between at least two configuration steps, each configuration step is sequentially executed, generates the wide table of data.Which does not depend on the development ability of staff, greatly improves the generating rate of the wide table of data, and then promotes wide table and generate progress, increases user experience.
Description
Technical field
The present embodiments relate to technical field of data processing, and in particular to a kind of wide table generating method of data, device and
System.
Background technique
The system of any data analysis all be unable to do without the processing of wide table.Wide table is created, is all by business personnel at present
Or software developer writes database store process to realize, executes periodically scheduling using JOB to the storing process write
It generates.And this requires application developer is familiar with data base procedure and specific business, suitable process otherwise can not be write.
If the table based on base table generation is as datum target table using the current tables of data executed in step as base table；
So the wide table of data is then the datum target table ultimately generated.It is ripe that the generation of each datum target table requires developer
It knows, the ability of program code and the familiarity of operation flow is write including database, the familiarity of operation flow can be with the short time
It is interior to be familiar with, but the ability for writing program code cannot but be promoted the short time.Therefore, the less staff of experience is then not easy
Write out the program code that the wide table of data generates.
So, the higher ability of development ability for how avoiding the generation each time of the wide table of data from requiring developer is complete
At otherwise the generating rate of the wide table of data can not ensure, become urgent problem to be solved.
Summary of the invention
For this purpose, the embodiment of the present invention provides a kind of wide table generating method of data, to solve in the prior art since data are wide
Generating each time for table is all more demanding to the development ability of developer, caused by the wide table of data generating rate it is lower,
And then reduce the problem of wide table generates progress.
To achieve the goals above, embodiments of the present invention provide the following technical solutions:
In the first aspect of embodiments of the present invention, a kind of wide table generating method of data is provided, comprising: receive and use
Configuration information needed for the wide table of generation data of family input；
At least two configuration steps corresponding with the wide table of data are established according to configuration information；
Determine the incidence relation between at least two configuration steps；
According to the incidence relation between at least two configuration steps, calling is default to be executed instruction, and is sequentially executed each and is matched
Step is set, until generating the wide table of data.
In one embodiment of the invention, configuration attribute includes one or more in following:
User name, table name, time label corresponding with tables of data, display name, table space or table classification.
In another embodiment of the invention, configuration information includes: source table information, configuration attribute and data processing rule
Then；
Configuration step includes: that source table is transferred from pre-established database according to source table information；
Source table is handled according to configuration attribute and data processing rule, generates the wide table of data.
In another embodiment of the present invention, data processing rule includes: data conversion expression formula, switch condition and conversion
Type.
In yet another embodiment of the present invention, when source table quantity includes at least two, configuration information further include: configuration
Incidence relation between at least two source tables, at least two source tables include a main table, and the source table in addition to main table is contingency table；
Source table is handled according to configuration attribute and data processing rule, the wide table of data is generated, specifically includes:
According to data processing rule and configuration attribute, main table and contingency table are handled, generate the wide table of data.
In configuration information further include: filter condition；According to number in yet another embodiment of the present invention, according to transformation rule with
And configuration attribute, before handling main table and contingency table, method further include: main table is filtered with contingency table.
In yet another embodiment of the present invention, source table is handled according to configuration attribute and data processing rule, it is raw
After the wide table of data, method further include:
Statistics generates the time of the wide table of data；
When the time for generating the wide table of data being more than the first preset threshold, the data of main table or contingency table in Statistic Source table
Amount；
When the data volume of main table is more than the second preset threshold, main Table Properties reference time is counted according to the filter condition of main table
Number；
When main Table Properties reference number is more than third predetermined threshold value, recommended user establishes rope to main table according to main Table Properties
Draw；
And/or
When the data volume of contingency table is more than the second preset threshold, according to the mistake of the incidence relation of contingency table and contingency table
Filter condition statistical correlation Table Properties quote number；
When being associated with Table Properties reference number more than third predetermined threshold value, recommended user is according to association Table Properties to contingency table
Establish index.
In yet another embodiment of the present invention, configuration information further includes one or more in following:
Increase newer field, delete existing field, insertion data, modification data or delete data.
In the second aspect of embodiments of the present invention, a kind of wide table creating device of data is provided, comprising: receive single
Member, for configuration information needed for receiving the wide table of generation data that user inputs；
Configuration unit, for establishing at least two configuration steps corresponding with the wide table of data according to configuration information；
Determine the incidence relation between at least two configuration steps；
Processing unit, for according to the incidence relation between at least two configuration steps, sequentially executing each configuration step
Suddenly, the wide table of data is generated.
In the third aspect of embodiments of the present invention, wide table data management system is provided, for receiving user's input
The wide table of generation data required configuration information, configuration information include: source table information, configuration attribute and data processing rule
Then；
Wide list processing routine intelligently generates engine, for establishing corresponding with the wide table of data at least two according to configuration information
Configuration step；
Determine the incidence relation between at least two configuration steps；
Task dispatcher, for sequentially executing each configuration according to the incidence relation between at least two configuration steps
Step generates the wide table of data.
In the fourth aspect of embodiments of the present invention, a kind of computer storage medium is provided, which is characterized in that meter
Comprising one or more program instructions in calculation machine storage medium, one or more program instructions are used to be generated by a kind of wide table of data
System executes a kind of step that the wide table generating method of data is corresponding as described above.
Embodiment according to the present invention has the advantages that configuration information is good by staff's configured in advance, system meeting
Configuration step corresponding with configuration information is automatically generated, and determines the incidence relation between at least two configuration steps.Finally
According to the incidence relation between multiple tasks, calling is default to be executed instruction, each configuration step is sequentially executed, until generating number
According to wide table.That is, which does not depend on the development ability of the staff of the current operation work, write initially by staff
After good process frame, subsequent operation personnel need to only configure the relevant parameter for generating the wide table of data in process frame, specific to execute
Movement will be called automatically what is write in advance to execute instruction generation by system.The generating rate for greatly improving the wide table of data, into
And promote wide table and generate progress, increase user experience.
Detailed description of the invention
It, below will be to embodiment party in order to illustrate more clearly of embodiments of the present invention or technical solution in the prior art
Formula or attached drawing needed to be used in the description of the prior art are briefly described.It should be evident that the accompanying drawings in the following description is only
It is merely exemplary, it for those of ordinary skill in the art, without creative efforts, can also basis
The attached drawing of offer, which is extended, obtains other implementation attached drawings.
Fig. 1 is the wide table generating method flow diagram of a kind of data that one embodiment of the invention provides；
Fig. 2 is the wide table creating device structural schematic diagram of a kind of data that another embodiment of the present invention provides；
Fig. 3 is that the wide table of a kind of data that another embodiment of the present invention provides generates system structure diagram.
Specific embodiment
Embodiments of the present invention are illustrated by particular specific embodiment below, those skilled in the art can be by this explanation
Content disclosed by book is understood other advantages and efficacy of the present invention easily, it is clear that described embodiment is the present invention one
Section Example, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art are not doing
Every other embodiment obtained under the premise of creative work out, shall fall within the protection scope of the present invention.
The present invention provides a kind of wide table generating methods of data, and specifically as shown in FIG. 1, FIG. 1 is the offers of the embodiment of the present invention 1
A kind of wide table generating method flow diagram of data.This method comprises:
Step 110, configuration information needed for receiving the wide table of generation data of user's input.
Specifically, its configuration information may include source table information, configuration attribute and data processing rule etc..
Optionally, configuration attribute is the configurable attribute of tables of data.Including one or more in following: user name, table
Name, time label corresponding with tables of data, display name, table space, table classification etc..Wherein, the wide table classification of data may include number
According to wide table, derive from reference list, interim transition table three classes.
It derives from reference list and interim transition table is to generate the tables of data generated in the wide table process of data or used.
Optionally, data processing rule may include: data conversion expression formula, switch condition and translation type.
Step 120, at least two configuration steps corresponding with the wide table of data are established according to configuration information.
After user configuration after configuration information, system can automatically generate configuration step.
Specifically, may include: to transfer source table from pre-established database according to source table information；According to configuration attribute
Source table is handled with data processing rule, generates the wide table of data.
Step 130, the incidence relation between at least two configuration steps is determined.
Specifically, determining the incidence relation between at least two configuration steps, practical is exactly to determine at least two configuration steps
Dependence between rapid.Who is first carried out, execution after whom, or parallel execution, or is executed after being ranked up according to priority
Etc..The step of introducing in the step 120 of the present embodiment, this implementation are mainly configured and are determined between the two configuration steps
Execute sequencing.Then it is operated according to step 140.
Step 140, according to the incidence relation between at least two configuration steps, calling is default to be executed instruction, and is sequentially executed
Each configuration step, until generating the wide table of data.
Specifically, can then be taken out from the tables of data according to data processing rule if the quantity of source table is one
After taking partial data or total data, according to switch condition, type when data conversion is determined.This parameter is practical be exactly with
The attribute of the wide table of data is corresponding.For example, field name conversion, field type conversion or data value conversion.And data value turns
It changes needs and formula realization is expressed according to data conversion, i.e., bring the numerical value in source data table into threshold value corresponding data conversion and express formula
In, corresponding numerical value is obtained, the numerical value that also should as store in the wide table of data.
If source table is at least two, in configuration information further include: the incidence relation between at least two source tables of configuration,
At least two source tables include a main table, and the source table in addition to main table is contingency table.
So, source table is handled according to configuration attribute and data processing rule, generates the wide table of data, specifically includes:
According to data processing rule and configuration attribute, main table and contingency table are handled, generate the wide table of data.
Here processing is carried out to main table and contingency table to need to include following process:
Multiple source tables generate the wide table of data, must uniformly arrive by multiple source tables by the processing such as extraction or conversion
In the same tables of data.Format conversion can be also possible to the customized standard of user on the basis of main table.
Such as most of data are extracted from main table, and contingency table extracts small part data respectively.It is right on the basis of main table
Data in contingency table carry out unified format conversion.Specifically, field name can be carried out to the small part data in contingency table
Conversion, field type conversion or the conversion of data value.It can specifically be determined according to switch condition using which kind of operation, if it is
The conversion of data value then also needs to carry out according to data conversion expression formula.In addition, if it is the extraction section data from main table,
It so necessarily further include the filter condition to main table in configuration information.It that is to say and main table was carried out according to main table filter condition
Filter, extracts corresponding data.And the data for being extracted in contingency table, then it is according to the incidence relation between contingency table and main table
And the filter condition determination of contingency table.For example, needing to know the wage of some company all staff on board.So, main table
Incidence relation between contingency table is exactly the work number of all employees.It that is to say, the incidence relation between main table and contingency table can
To be determined by business relations.
It is further alternative, it not only may include configuration information as above before the wide table of data generates.Staff
It can also add or delete according to the actual situation configuration information.
For example, addition newer field: configuring new field correlation attribute such as field name, display Name, data type, data
Precision, default value etc..
It deletes existing field: deleting existing field from table, further delete data insertion relevant to the field, data
The information such as modification, data query, index.
Insertion data information, the field to be inserted into selection table can also be configured, selection will extract one, source table of data
Or it is multiple, establish the incidence relation in the source table currently selected and system between existing source table, field transformation rule or filtering
The configuration informations such as condition carry out the insertion of data.
Modify data information: the field to be modified in selection table adds the condition of modification, establishes modified source table and its
Incidence relation, field transformation rule between his source table etc., carry out the modification of data.
Delete data information: configuration deletion condition.
System then can carry out corresponding operation according to the configuration of user.
After executing aforesaid operations and generating the wide table of data, system can also count the time for generating the wide table of data；
When the time for generating the wide table of data being more than the first preset threshold, the data of main table or contingency table in Statistic Source table
Amount；
When the data volume of main table is more than the second preset threshold, main Table Properties reference time is counted according to the filter condition of main table
Number；
When main Table Properties reference number is more than third predetermined threshold value, recommended user establishes rope to main table according to main Table Properties
Draw；
And/or
When the data volume of contingency table is more than the second preset threshold, according to the mistake of the incidence relation of contingency table and contingency table
Filter condition statistical correlation Table Properties quote number；
When being associated with Table Properties reference number more than third predetermined threshold value, recommended user is according to association Table Properties to contingency table
Establish index.
Further, system in the process of running, once discovery task execution is abnormal, can be incited somebody to action with misregistration log
The error number of error is write in corresponding log sheet with error message.And misregistration program code, the program generation that will be reported an error
Code sentence, which is recorded, to be stored in tables of data.And error feedback is handled to staff there convenient for staff in time.
The wide table generating method of a kind of data provided in an embodiment of the present invention, embodiment according to the present invention have as follows
Advantage: configuration information is good by staff's configured in advance, and system can automatically generate configuration step corresponding with configuration information, and
Determine the incidence relation between at least two configuration steps.Finally according to the incidence relation between multiple tasks, default hold is called
Row instruction, sequentially executes each configuration step, until generating the wide table of data.That is, which does not depend on the current operation work
Staff development ability, after initially writing process frame by staff, subsequent operation personnel only need to be in process
Configuration generates the relevant parameter of the wide table of data in frame, and specific execution movement will be called automatically the execution write in advance by system
Instruction generates.The generating rate of the wide table of data is greatly improved, and then promotes wide table and generates progress, increases user experience.
Corresponding with above-described embodiment, the embodiment of the invention also provides a kind of wide table creating devices of data, specifically such as
Shown in Fig. 2, which includes: receiving unit 201, configuration unit 202 and processing unit 203.
Receiving unit 201, for configuration information needed for receiving the wide table of generation data that user inputs；
Configuration unit 202, for establishing at least two configuration steps corresponding with the wide table of data according to configuration information；
Determine the incidence relation between at least two configuration steps；
Processing unit 203 is executed instruction for calling to preset according to the incidence relation between at least two configuration steps,
Each configuration step is sequentially executed, until generating the wide table of data.
Optionally, configuration information includes: source table information, configuration attribute and data processing rule.Configuration step includes: root
According to source table information, source table is transferred from pre-established database；
Source table is handled according to configuration attribute and data processing rule, generates the wide table of data.
Optionally, configuration attribute includes one or more in following:
User name, table name, time label corresponding with tables of data, display name, table space or table classification.
Optionally, data processing rule includes: data conversion expression formula, switch condition and translation type.
Optionally, when table quantity in source includes at least two, configuration information further include: the pass between at least two source tables of configuration
Connection relationship, at least two source tables include a main table, and the source table in addition to main table is contingency table, and configuration unit 202 is specifically used for,
According to data processing rule and configuration attribute, main table and contingency table are handled, generate the wide table of data.
Optionally, in configuration information further include: filter condition；According to data processing rule and configuration attribute, to main table
Before being handled with contingency table, device further include: filter element 204, for being filtered to main table with contingency table.
Optionally, device further include: statistic unit 205, for counting the time for generating the wide table of data；
When the time for generating the wide table of data being more than the first preset threshold, the data of main table or contingency table in Statistic Source table
Amount.
When the data volume of main table is more than the second preset threshold, main Table Properties reference time is counted according to the filter condition of main table
Number；
Processing unit 203 is also used to, and when main Table Properties reference number is more than third predetermined threshold value, recommended user is according to master
Table Properties are established main table and are indexed；
And/or
When the data volume of contingency table is more than the second preset threshold, according to the incidence relation statistical correlation Table Properties of contingency table
Quote number；
Processing unit 203 is also used to, when be associated with Table Properties reference number be more than third predetermined threshold value when, recommended user according to
It is associated with Table Properties and index is established to contingency table.
Function performed by each component is above-mentioned in the wide table creating device of a kind of data provided in an embodiment of the present invention
It is discussed in detail in embodiment, therefore does not do excessively repeat here.
The wide table creating device of a kind of data provided in an embodiment of the present invention, embodiment according to the present invention have as follows
Advantage: configuration information is good by staff's configured in advance, and system can automatically generate configuration step corresponding with configuration information, and
Determine the incidence relation between at least two configuration steps.Finally according to the incidence relation between multiple tasks, default hold is called
Row instruction, sequentially executes each configuration step, until generating the wide table of data.That is, which does not depend on the current operation work
Staff development ability, after initially writing process frame by staff, subsequent operation personnel only need to be in process
Configuration generates the relevant parameter of the wide table of data in frame, and specific execution movement will be called automatically the execution write in advance by system
Instruction generates.The generating rate of the wide table of data is greatly improved, and then promotes wide table and generates progress, increases user experience.
Corresponding with above-mentioned two embodiment, the embodiment of the invention also provides a kind of wide tables of data to generate system, should
System includes: wide table data management system 301, wide list processing routine intelligently generation engine 302 and task dispatcher 303.
Wide table data management system 301, the required configuration information of the wide table of generation data for receiving user's input, configuration
Information includes: source table information, configuration attribute and data processing rule；
Wide list processing routine intelligently generates engine 302, for corresponding with the wide table of data at least according to configuration information foundation
Two configuration steps；
Determine the incidence relation between at least two configuration steps；
Task dispatcher 303, for calling default execute to refer to according to the incidence relation between at least two configuration steps
It enables, sequentially executes each configuration step, until generating the wide table of data.
The wide table of a kind of data provided in an embodiment of the present invention generates system, and embodiment according to the present invention has as follows
Advantage: configuration information is good by staff's configured in advance, and system can automatically generate configuration step corresponding with configuration information, and
Determine the incidence relation between at least two configuration steps.Finally according to the incidence relation between multiple tasks, default hold is called
Row instruction, sequentially executes each configuration step, until generating the wide table of data.That is, which does not depend on the current operation work
Staff development ability, after initially writing process frame by staff, subsequent operation personnel only need to be in process
Configuration generates the relevant parameter of the wide table of data in frame, and specific execution movement will be called automatically the execution write in advance by system
Instruction generates.The generating rate of the wide table of data is greatly improved, and then promotes wide table and generates progress, increases user experience.
Corresponding with above-mentioned two embodiment, the embodiment of the invention also provides a kind of computer storage medium, the meters
Include one or more program instructions in calculation machine storage medium.Wherein, one or more program instructions are used for wide by a kind of data
Table generates system and executes a kind of data auditing method as described above.
Although above having used general explanation and specific embodiment, the present invention is described in detail, at this
On the basis of invention, it can be made some modifications or improvements, this will be apparent to those skilled in the art.Therefore,
These modifications or improvements without departing from theon the basis of the spirit of the present invention are fallen within the scope of the claimed invention.
Claims (10)
1. a kind of wide table generating method of data, which is characterized in that the described method includes:
Configuration information needed for receiving the wide table of generation data of user's input；
At least two configuration steps corresponding with the wide table of the data are established according to the configuration information；
Determine the incidence relation between at least two configuration step；
According to the incidence relation between at least two configuration step, calling is default to be executed instruction, and is sequentially executed each and is matched
Step is set, until generating the wide table of data.
2. the method according to claim 1, wherein the configuration information include: source table information, configuration attribute with
And data processing rule；
The configuration step includes: that source table is transferred from pre-established database according to the source table information；
The source table is handled according to the configuration attribute and the data processing rule, generates the wide table of data.
3. the method according to claim 1, wherein the configuration attribute includes one or more in following:
User name, table name, time label corresponding with the tables of data, display name, table space or table classification.
4. the method according to claim 1, wherein the data processing rule include: data conversion expression formula,
Switch condition and translation type.
5. according to the method described in claim 2, it is characterized in that, when the quantity of the source table include at least two when, it is described
Configuration information further include: the incidence relation between configuration at least two source table, at least two source table include a master
Table, the source table in addition to the main table are contingency table；It is described according to the configuration attribute and the data processing rule to described
Source table is handled, and is generated the wide table of data, is specifically included:
According to the data processing rule and configuration attribute, the main table and contingency table are handled, generate the wide table of data.
6. according to the method described in claim 5, it is characterized in that, in the configuration information further include: main table filter condition；Institute
It states according to the data processing rule and configuration attribute, before handling the main table and contingency table, the method is also
It include: to be filtered to the main table.
7. according to the method described in claim 5, it is characterized in that, described advise according to the configuration attribute and the data processing
Then the source table is handled, after generating the wide table of data, the method also includes:
Statistics generates the time of the wide table of data；
When the time for generating the wide table of data being more than the first preset threshold, main table or contingency table in the source table are counted
Data volume；
When the data volume of the main table is more than the second preset threshold, the main table category is counted according to the filter condition of the main table
Property reference number；
When the main Table Properties reference number is more than third predetermined threshold value, recommended user is according to the main Table Properties to the master
Table establishes index；
And/or
When the data volume of the contingency table is more than the second preset threshold, according to the incidence relation of the contingency table and the pass
The filter condition for joining table counts the association Table Properties and quotes number；
When association Table Properties reference number is more than third predetermined threshold value, recommend the user according to the association Table Properties
The contingency table is established and is indexed.
8. a kind of wide table creating device of data, which is characterized in that described device includes:
Receiving unit, for configuration information needed for receiving the wide table of generation data that user inputs；
Configuration unit, for establishing at least two configuration steps corresponding with the wide table of the data according to the configuration information；
Determine the incidence relation between at least two configuration step；
Processing unit executes instruction, sequentially for calling to preset according to the incidence relation between at least two configuration step
Each configuration step is executed, until generating the wide table of data.
9. a kind of wide table of data generates system, which is characterized in that the system comprises:
Wide table data management system, the required configuration information of the wide table of generation data for receiving user's input are described to match confidence
Breath includes: source table information, configuration attribute and data processing rule；
Wide list processing routine intelligently generates engine, for corresponding with the wide table of the data at least according to configuration information foundation
Two configuration steps；
Determine the incidence relation between at least two configuration step；
Task dispatcher is executed instruction for calling to preset according to the incidence relation between at least two configuration step, is pressed
Sequence executes each configuration step, until generating the wide table of data.
10. a kind of computer storage medium, which is characterized in that refer in the computer storage medium comprising one or more programs
It enables, one or more of program instructions are used to generate system by a kind of wide table of data and execute such as any one of claim 1-7 institute
The method stated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811564613.2A CN109684332A (en) | 2018-12-20 | 2018-12-20 | A kind of wide table generating method of data, apparatus and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811564613.2A CN109684332A (en) | 2018-12-20 | 2018-12-20 | A kind of wide table generating method of data, apparatus and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109684332A true CN109684332A (en) | 2019-04-26 |
Family
ID=66188033
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811564613.2A Pending CN109684332A (en) | 2018-12-20 | 2018-12-20 | A kind of wide table generating method of data, apparatus and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109684332A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110399600A (en) * | 2019-07-24 | 2019-11-01 | 北京明略软件系统有限公司 | Generate the method and device of wide table |
| CN110928879A (en) * | 2019-11-20 | 2020-03-27 | 贵州电网有限责任公司电力科学研究院 | Wide table generation method and device |
| CN112100182A (en) * | 2020-09-27 | 2020-12-18 | 中国建设银行股份有限公司 | Data warehousing processing method and device and server |
| CN112732242A (en) * | 2021-01-12 | 2021-04-30 | 中国邮政储蓄银行股份有限公司 | Wide table processing script generation method and device |
| CN113535817A (en) * | 2021-07-13 | 2021-10-22 | 浙江网商银行股份有限公司 | Method and device for generating characteristic broad table and training business processing model |
| CN115062028A (en) * | 2022-07-27 | 2022-09-16 | 中建电子商务有限责任公司 | Method for multi-table join query in OLTP field |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105279269A (en) * | 2015-10-27 | 2016-01-27 | 中通服公众信息产业股份有限公司 | SQL generating method and system for supporting table free association |
| CN105930446A (en) * | 2016-04-20 | 2016-09-07 | 重庆重邮汇测通信技术有限公司 | Telecommunication customer tag generation method based on Hadoop distributed technology |
| CN108228628A (en) * | 2016-12-15 | 2018-06-29 | 亿度慧达教育科技（北京）有限公司 | Wide table generating method and its device in a kind of structured query language database |
| CN108287886A (en) * | 2018-01-16 | 2018-07-17 | 阿里巴巴集团控股有限公司 | The method and device of synchrodata modification information |
-
2018
- 2018-12-20 CN CN201811564613.2A patent/CN109684332A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105279269A (en) * | 2015-10-27 | 2016-01-27 | 中通服公众信息产业股份有限公司 | SQL generating method and system for supporting table free association |
| CN105930446A (en) * | 2016-04-20 | 2016-09-07 | 重庆重邮汇测通信技术有限公司 | Telecommunication customer tag generation method based on Hadoop distributed technology |
| CN108228628A (en) * | 2016-12-15 | 2018-06-29 | 亿度慧达教育科技（北京）有限公司 | Wide table generating method and its device in a kind of structured query language database |
| CN108287886A (en) * | 2018-01-16 | 2018-07-17 | 阿里巴巴集团控股有限公司 | The method and device of synchrodata modification information |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110399600A (en) * | 2019-07-24 | 2019-11-01 | 北京明略软件系统有限公司 | Generate the method and device of wide table |
| CN110928879A (en) * | 2019-11-20 | 2020-03-27 | 贵州电网有限责任公司电力科学研究院 | Wide table generation method and device |
| CN112100182A (en) * | 2020-09-27 | 2020-12-18 | 中国建设银行股份有限公司 | Data warehousing processing method and device and server |
| CN112100182B (en) * | 2020-09-27 | 2024-08-09 | 中国建设银行股份有限公司 | Data warehouse-in processing method, device and server |
| CN112732242A (en) * | 2021-01-12 | 2021-04-30 | 中国邮政储蓄银行股份有限公司 | Wide table processing script generation method and device |
| CN112732242B (en) * | 2021-01-12 | 2024-08-16 | 中国邮政储蓄银行股份有限公司 | Method and device for generating wide-table processing script |
| CN113535817A (en) * | 2021-07-13 | 2021-10-22 | 浙江网商银行股份有限公司 | Method and device for generating characteristic broad table and training business processing model |
| CN113535817B (en) * | 2021-07-13 | 2024-05-14 | 浙江网商银行股份有限公司 | Feature broad table generation and service processing model training method and device |
| CN115062028A (en) * | 2022-07-27 | 2022-09-16 | 中建电子商务有限责任公司 | Method for multi-table join query in OLTP field |
| CN115062028B (en) * | 2022-07-27 | 2023-01-06 | 中建电子商务有限责任公司 | Method for multi-table join query in OLTP field |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109684332A (en) | A kind of wide table generating method of data, apparatus and system | |
| EP2778929B1 (en) | Test script generation system | |
| CN110019486A (en) | Collecting method, device, equipment and storage medium | |
| US9171072B2 (en) | System and method for real-time dynamic measurement of best-estimate quality levels while reviewing classified or enriched data | |
| CN106371973B (en) | A kind of data processing method, equipment and system | |
| US8463811B2 (en) | Automated correlation discovery for semi-structured processes | |
| CN109344153A (en) | The processing method and terminal device of business datum | |
| CN109688046A (en) | Issue management method, apparatus, equipment and storage medium | |
| CN106649239A (en) | Method and device for generating report in cloud monitoring system based on visualization | |
| WO2020258492A1 (en) | Information processing method and apparatus, storage medium and terminal device | |
| CN108304522A (en) | Comparison method, device and the terminal device of difference between a kind of database | |
| CN106919612A (en) | A kind of processing method and processing device of SQL script of reaching the standard grade | |
| US9311345B2 (en) | Template based database analyzer | |
| CN106484699B (en) | Method and device for generating database query field | |
| CN109299074B (en) | Data verification method and system based on templated database view | |
| CN109753596B (en) | Information source management and configuration method and system for large-scale network data acquisition | |
| CN112396397A (en) | Operation and maintenance affair collection and management system | |
| CN113886606B (en) | Data annotation method, device, medium and equipment based on knowledge graph | |
| CN111241144B (en) | Data processing method and system | |
| CN108829651A (en) | A kind of method, apparatus of document treatment, terminal device and storage medium | |
| CN112685017A (en) | Workflow engine facing mobile internet | |
| CN112015912A (en) | Intelligent index visualization method and device based on knowledge graph | |
| CN107943912B (en) | A kind of response type Resource TOC data visualization management method, terminal and device | |
| CN113360517A (en) | Data processing method and device, electronic equipment and storage medium | |
| Barcellos et al. | A software measurement task ontology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190426 |