CN107545044A - A kind of tables of data method for building up, electronic equipment and storage medium - Google Patents
A kind of tables of data method for building up, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN107545044A CN107545044A CN201710700500.XA CN201710700500A CN107545044A CN 107545044 A CN107545044 A CN 107545044A CN 201710700500 A CN201710700500 A CN 201710700500A CN 107545044 A CN107545044 A CN 107545044A
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- database
- attribute information
- built
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Embodiments of the invention disclose a kind of tables of data method for building up, electronic equipment and storage medium, are related to database technical field, can effectively improve the speed and accuracy rate that corresponding data table is established between disparate databases, and methods described includes：The attribute information of first tables of data is obtained according to index information of first tables of data in a kind of database；The attribute information is adjusted according to the mapping ruler between two class databases and a kind of database；Table statement is built using the attribute information generation after adjustment, the second tables of data corresponding with first tables of data is generated in the two classes database to build table statement according to.The present invention is suitable for big data processing.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of tables of data method for building up, electronic equipment and storage to be situated between
Matter.
Background technology
In recent years, big data development reaches its maturity, it has been found that the value of data, by being arranged, carried to data
Take, process, cleaning, analyzing and carry out aid decision making.And before this, there are many industries to have accumulated abundant data resource.This
A little data are mostly based on more traditional relational data library storage, such as oracle etc..But with being continuously increased of data,
The data processing speed of the traditional relational database of accumulative and new technology continuous renewal, oracle etc. can not increasingly meet
Processing requirement of the user for mass data.Therefore complex database processing mode is usually used, number is stored in oracle
According to, the process data in hive, spark, quick data processing technique is added by stable storage, carrys out update method.
However, because disparate databases are not fully compatible, data during hand-off process, can be related between disparate databases
To the operation such as the foundation of substantial amounts of tables of data, conversion, synchronous.In the prior art, these are operated completely by manually realizing, not only efficiency
It is low and easily malfunction.
The content of the invention
In view of this, the embodiment of the present invention provides a kind of tables of data method for building up, electronic equipment and storage medium, Neng Gouyou
The speed and accuracy rate of corresponding data table are established between effect raising disparate databases.
In a first aspect, the embodiment of the present invention provides a kind of tables of data method for building up, including：According to the first tables of data in one kind
Index information in database obtains the attribute information of first tables of data；According to two class databases and a kind of database
Between mapping ruler the attribute information is adjusted；Table statement is built using the attribute information generation after adjustment, with
The second tables of data corresponding with first tables of data is generated in the two classes database according to the table statement of building.
With reference in a first aspect, in the first embodiment of first aspect, the index information includes the described first number
According to library name and table name of the table in a kind of database；The attribute information includes following at least one：Field, field class
Type, row annotation.
It is described according to two in second of embodiment of first aspect with reference to the first embodiment of first aspect
Mapping ruler between class database and a kind of database the attribute information is adjusted including：If the field
Type includes preset kind, and the preset kind is replaced with into corresponding target type；If the row annotation includes pre-
Point is marked with, the default punctuate is replaced with into corresponding target punctuate.
With reference to first aspect, first aspect the first to any embodiment in second, the of first aspect
In three kinds of embodiments, table statement is built in the attribute information generation using after adjustment to be included：Described in after adjustment
Attribute information carries out dynamic sentence splicing；The storage format that will be used in the two classes database second tables of data
Carry out storage format splicing；Built according to the generation of the splicing result of the splicing result of the dynamic sentence and the storage format
Table statement.
With reference to the third embodiment of first aspect, in the 4th kind of embodiment of first aspect, in the basis
Built described in the generation of the splicing result of the splicing result of the dynamic sentence and the storage format after table statement, methods described is also
Including：The preset field of table statement deposit preset data table will be built described in generation, the field type of the preset field is
CLOB (character large object block, Character Large Object block).
With reference to the 4th kind of embodiment of first aspect, in the 5th kind of embodiment of first aspect, the present count
Include at least one entry according to table, each entry include library name of first tables of data in a kind of database and
The library name of table name and second tables of data in the two classes database.
With reference to the third embodiment of first aspect, in the 6th kind of embodiment of first aspect, in the basis
Built described in the generation of the splicing result of the splicing result of the dynamic sentence and the storage format after table statement, methods described is also
Including：By the translation and compiling environment built table statement and import the two classes database；According to the compiling result under the translation and compiling environment,
Second tables of data is generated in the two classes database.
With reference to first aspect, first aspect the first to any embodiment in second, the of first aspect
In seven kinds of embodiments, a kind of database includes relevant database, and the two classes database includes big data database.
Second aspect, the embodiment of the present invention provide a kind of electronic equipment, and the electronic equipment includes：Housing, processor, deposit
Reservoir, circuit board and power circuit, wherein, circuit board is placed in the interior volume that housing surrounds, and processor and memory are set
On circuit boards；Power circuit, for each circuit or the device power supply for above-mentioned electronic equipment；Memory is used to store and can hold
Line program code；The executable program code that processor is stored by reading in memory is run and executable program code pair
The program answered, for performing foregoing any described tables of data method for building up.
The third aspect, the embodiment of the present invention provide a kind of computer-readable recording medium, the computer-readable storage medium
Matter is stored with one or more program, and one or more of programs can be by one or more computing device, with reality
Existing foregoing any described tables of data method for building up.
Tables of data method for building up, electronic equipment and storage medium provided in an embodiment of the present invention, can be according to the first data
Index information of the table in a kind of database obtains the attribute information of the first tables of data, corresponding by being carried out to these attribute informations
Adjustment comply with the requirement of two class databases, then automatically formed using the attribute information after adjustment in two class numbers
Table statement is built according to the second tables of data of storehouse generation.So, when needs import the data in a kind of database in two class databases
During processing, the form in two class databases can be carried out adapting to and adjusting automatically, make it can be by corresponding data from one kind
Imported in database, meet the form and processing requirement of two class databases again, so as to greatly accelerate the establishment speed of tables of data,
Also the error rate of tables of data foundation is effectively reduced.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can be with
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is the flow chart of embodiments of the invention tables of data method for building up；
Fig. 2 is the compiling interface schematic diagram under hive environment in the tables of data method for building up that embodiments of the invention provide；
Fig. 3 is a kind of detail flowchart for the tables of data method for building up that embodiments of the invention provide；
Fig. 4 is the structural representation at the storage interface that table statement is built in embodiments of the invention；
Fig. 5 is the structural representation of electronic equipment one embodiment of the present invention.
Embodiment
The embodiment of the present invention is described in detail below in conjunction with the accompanying drawings.
It will be appreciated that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.Base
Embodiment in the present invention, those of ordinary skill in the art obtained under the premise of creative work is not made it is all its
Its embodiment, belongs to the scope of protection of the invention.
Fig. 1 is the flow chart for the tables of data method for building up that embodiments of the invention provide, as shown in figure 1, the present embodiment carries
The tables of data method for building up of confession can include：
S11, the attribute that first tables of data is obtained according to index information of first tables of data in a kind of database are believed
Breath；
S12, the attribute information is adjusted according to the mapping ruler between two class databases and a kind of database
It is whole；
S13, table statement is built using the attribute information generation after adjustment, to build table statement in two class according to
The second tables of data corresponding with first tables of data is generated in database.
The tables of data method for building up that embodiments of the invention provide, can be according to the first tables of data in a kind of database
Index information obtains the attribute information of the first tables of data, by being adjusted correspondingly these attribute informations to comply with two
The requirement of class database, then automatically formed using the attribute information after adjustment for generating the second tables of data in two class databases
Build table statement.So, can be to two class numbers when needing being handled in the data two class databases of importing in a kind of database
According to the newly-built form in storehouse adapt to and adjust automatically, it is imported corresponding data from a kind of database, again
Meet the form and processing requirement of two class databases, so as to greatly accelerate the establishment speed of tables of data, also effectively reduce number
The error rate established according to table.
In embodiments of the invention, being related to the tables of data in two class databases, how this corresponds to conversion.Same data
Corresponding tables of data is discrepant in different types of database, and number can be ensured by only properly handling these differences
According to accurately being imported from a kind of tables of data in another kind of tables of data, and carry out follow-up data processing.
It should be noted that a kind of database and two class databases in the present embodiment can be different types of any two
Kind database, because the data processing in hybrid database often refers to traditional relevant database such as oracle database,
With new big data database such as hive, therefore, optionally, in one embodiment of the invention, a kind of database can be with
Including relevant database, two class databases can include big data database.
Specifically, before step S11, index information of first tables of data in a kind of database can be first obtained.Its
In, the index information of the first tables of data can be a kind of information with positioning function, i.e., can be by the index information
First tables of data corresponding to being found in system.For example, in one embodiment of the invention, the index information can be the first data
The library name lib1 of database where the table name sheet1 of table and first tables of data sheet1, in another reality of the present invention
Apply in example, the index information can also be a store path, such as D：\route1\route2\lib2\sheet2.Certainly,
In other embodiments of the invention, index information can also be other information that can point at or identify a tables of data, this
The embodiment of invention is not limited this.
Optionally, acquisition of information approach can be directly read under the translation and compiling environment of a kind of database or
By calling the parameter acquiring in a kind of database under the translation and compiling environment of two class databases, it can also be and led to using third party's instrument
Parameter transmission is crossed to obtain, embodiments of the invention contrast does not limit.
After getting index information, you can the first data corresponding to being found using the index information in a kind of database
Table, obtain the attribute information of the first tables of data.Specifically, in step s 11, the index information can be utilized to obtain the first number
According to the attribute information of table.Wherein, attribute information can include one or more of：It is each field in first tables of data, every
The field type of individual field, and row annotation of the first tables of data etc..For example, index information " 1 year class Three " (storehouse can be passed through
Name), " term 2015-2016 academic years first " (table name) obtain class's Students' Score List attribute information, specifically include word
Section：Student number, name, mathematics, Chinese language, English, physics, chemistry, average mark；Field type：The type of student number is integer, and name is
Character type, remaining is Real-valued.
Because these attribute informations got are derived from a kind of database, not necessarily meet the requirement of two class databases,
Therefore need that these attribute informations are filtered and adjusted, retain compatible portion of the two class databases to attribute information, and repair
Change the incompatible part of attribute information.Specific reservation or modification operation can be according between two class databases and a kind of database
Mapping ruler carry out.
Optionally, in step s 12, according to the mapping ruler between two class databases and a kind of database to the attribute
Information, which is adjusted, may include：
If field type includes preset kind, preset kind is replaced with into corresponding target type；
If row annotation includes default punctuate, default punctuate is replaced with into corresponding target punctuate.
Specifically, attribute information may include field, field type and row annotation.Wherein, field relates generally to some certainly
The title of definition, can be compatible typically in types of databases.And field type and row annotation are in different types of database
Usually there is different requirements, it is often necessary to adjust.
For example, in one embodiment of the invention, a kind of database is oracle database, two class databases are
Hive databases.Need to correspond to a data Table A 1 in oracle database in hive databases and form new tables of data
A2.From prior art, the field type in oracle exists different, it is necessary to adjust from the field type in hive.For example,
Need the field type ' STRING ' the field type VARCHAR2 in oracle being substituted in hive, by the word in oracle
Segment type number is substituted for the field type ' DOUBLE ' in hive.In another example may in row annotation in oracle database
Branch can be used, and is corresponded in hive, is needed when can be reported an error if branch is appeared in row annotation, therefore build in hive table
Other legal symbols are deleted or replaced with to original branch.
In a word, different databases has different form and grammar request, specifically needs to do which character is replaced and adjusted
It is whole to determine and set as needed.
Further, after to attribute information adjustment such as field type, row annotations, the category after these adjustment can be utilized
Property information generation apply in new type of database (i.e. two class databases) build table statement.Optionally, the life of table statement is built
It may particularly include into method：
Dynamic sentence splicing is carried out using the attribute information after adjustment；
The storage format that will be used in the two classes database second tables of data carries out storage format splicing；
Table statement is built according to the generation of the splicing result of the splicing result of the dynamic sentence and the storage format.
Specifically, it is exactly the side by dynamic sentence splicing to carry out dynamic sentence splicing using the attribute information after adjustment
Method reconnects the attribute information after above-mentioned adjustment, for example, generation hive tables can be specified to build table in dynamic sentence
Library name, before table name plus ' CREATE TABLE IF NOT EXISTS ' avoid building the table of repetition, can be by dynamic sentence certainly
It is dynamic to be spliced above sentence, it is spliced into one and completely builds table statement.Further, if data in two class databases
Table can use a variety of storage formats, then the storage format that can also will be used the second tables of data carries out storage format spelling
Connect, table statement is then built according to dynamic sentence splicing result and the generation of storage format splicing result.Optionally, the present invention's
In one embodiment, in two class databases, tables of data can be with partitioned storage, then and it is corresponding, carrying out storage format splicing
When can also increase subregion splicing, so as to according to dynamic sentence splicing result, storage format and subregion splicing result generation build table
Sentence.
Optionally, generation builds table statement and can be used directly to import two class database environments, so as in two class databases
It is middle to generate the second tables of data corresponding with the first tables of data, generation can also be built table statement deposit file, for subsequently making
With.
In the case where table statement deposit file will be built, this can be built to the file that table statement is saved as diversified forms, as long as
The correct text for building table statement can be retained, for example, txt file, office files, database file etc..But in order to more
That gets well is compatible with database environment, further improves the quality and efficiency for building table, in one embodiment of the invention, can incite somebody to action
The preset field that table statement is stored in a single tables of data is built, table statement is built in disparate databases so as to easily realize
Between transmission.
Specifically, in step S13 according to the splicing result of the dynamic sentence and the splicing result of the storage format
Built described in generation after table statement, tables of data method for building up provided by the invention may also include：
By the preset field for building table statement deposit preset data table of generation, the field type of the preset field is character
Large object CLOB.Optionally, the preset data table can be the tables of data in a kind of database, or two class databases
In tables of data, can also be another tables of data independently of a kind of database and two class databases, embodiments of the invention
This is not limited.
Further, when needs do the establishment and conversion of substantial amounts of tables of data between a kind of database and two class databases
When, can by the table statement of building of tables of data of establishment and conversion in need be divided into different entries and be stored in same preset data
In table.The preset data table includes an entry or multiple entries, and each entry includes the first tables of data in a kind of data
The library name of library name, table name and the second tables of data in two class databases in storehouse.In the present embodiment, in order that tables of data has
Good correspondence, table name of the tables of data in a kind of database is still continued to use in two class databases.Certainly, in the present invention
Other embodiments in, different table names can also be used, embodiments of the invention are not limited this.
For example, in one embodiment of the invention, it is necessary to by oracle database, the data under database C
Rebuild under tables of data sh02 under table sh01 and database D, the database E in hive databases, then what is generated builds table statement
Phrase1 and phrase2 can store according to the form of table 1.
Table 1
Similar, next building table each time only needs to insert library name, the table name of oracle tables, and needs what is generated
The library name of hive tables, determine the mapping ruler between two kinds of database, you can automatically generate and build table statement.This carry out
Multi-field, when building table handling of big scale, effectively increase efficiency and have been greatly reduced error rate.
Optionally, using building in the case that table statement directly generates tables of data, in step S13 according to the dynamic sentence
Splicing result and the storage format splicing result generation described in build after table statement, data provided in an embodiment of the present invention
Table method for building up may also include：
The translation and compiling environment of table statement two class databases of importing will be built；
According to the compiling result under translation and compiling environment, the second tables of data is generated in two class databases.
In one embodiment of the invention, table statement will be built to import under the translation and compiling environment of hive databases, it is specific to compile
Translate environment can be as shown in Fig. 2 so as to directly build table in two class databases.
Tables of data method for building up provided by the invention is described in detail below by specific embodiment.
As shown in figure 3, the tables of data method for building up that the present embodiment provides comprises the following steps：
S301, obtain index information of first tables of data in oracle database：Library name is CTXSYS, and table name is
TABLE_SCORE；
For example, following variable declarations and assignment can be carried out：
S302, the first data are obtained according to index informations of the first tables of data TABLE_SCORE in oracle database
Table TABLE_SCORE attribute information, attribute information include table in be related to various fields, each field field type and
Row annotation；
When it is implemented, variable declarations can be carried out first, then input variable name, next performs for circulations, at this
The field of table, field type can be read in individual circulation inside the system table all_tab_columns, from all_col_comments
The row annotation of table is read in the inside, such as using oracle dynamic sentences, user of the specified table for needing to build in oracle, table name,
Then annotated from the field of all_tab_columns meter readings, field type, from the row of all_col_comments meter readings；
S303, above-mentioned attribute information is filtered and adjusted, traveled through all field types and row annotate, will not meet
The form of hive databases and the character of grammar request and punctuate etc. are replaced or deleted, and other contents retain；Optionally, may be used
To be realized with CASE WHEN sentences, when matching field type and row annotation meet corresponding condition, corresponding sentence is performed.
When it is implemented, step S302 and S303 can be realized in the following way：
S304, dynamic sentence splicing is carried out using the attribute information after adjustment, for example, can be spliced as follows：
S305, the storage format that will be used tables of data under hive carries out storage format splicing, for example, can carry out such as
Lower splicing：
S306, table statement is built according to the generation of above-mentioned splicing result and generation is built what table statement insertion pre-established
In oracle tables table_save；Building the storage interface of table statement can be stored in as shown in figure 4, building table statement with CLOB fields
In table_save.
Specifically, the table statement of building of generation can be inserted by the oracle tables table_ pre-established by following code
In save：
S307, table TABLE_SCORE table statement of building is imported into hive environment by reading the data in table_save,
So as to tables of data TABLE_SCORE corresponding to the foundation in hive.
Optionally, tables of data TABLE_SCORE store path can be default path in hive, can also build predicative
Specified in the importing process of sentence.
Accordingly, as shown in figure 5, the present invention to embodiment a kind of electronic equipment is also provided, as shown in figure 5, above-mentioned electricity
Sub- equipment can include：Housing 41, processor 42, memory 43, circuit board 44 and power circuit 45, wherein, circuit board 44 is pacified
The interior volume surrounded in housing 41 is put, processor 42 and memory 43 are arranged on circuit board 44；Power circuit 45, for for
Each circuit or the device power supply of above-mentioned electronic equipment；Memory 43 is used to store executable program code；Processor 42 passes through
The executable program code that stores is read in memory 43 to run program corresponding with executable program code, before execution
State the tables of data method for building up described in any embodiment.
Processor 42 to the specific implementation procedures of above-mentioned steps and processor 42 by run executable program code come
The step of further performing, the description of previous embodiment is may refer to, will not be repeated here.
The electronic equipment exists in a variety of forms, includes but is not limited to：
(1) mobile communication equipment：The characteristics of this kind equipment is that possess mobile communication function, and to provide speech, data
Communicate as main target.This Terminal Type includes：Smart mobile phone (such as iPhone), multimedia handset, feature mobile phone, and it is low
Hold mobile phone etc..
(2) super mobile personal computer equipment：This kind equipment belongs to the category of personal computer, there is calculating and processing work(
Can, typically also possess mobile Internet access characteristic.This Terminal Type includes：PDA, MID and UMPC equipment etc., such as iPad.
(3) portable entertainment device：This kind equipment can show and play content of multimedia.The kind equipment includes：Audio,
Video player (such as iPod), handheld device, e-book, and intelligent toy and portable car-mounted navigation equipment.
(4) server：The equipment for providing the service of calculating, the composition of server are total including processor, hard disk, internal memory, system
Line etc., server is similar with general computer architecture, but due to needing to provide highly reliable service, therefore in processing energy
Power, stability, reliability, security, scalability, manageability etc. require higher.
(5) other electronic equipments with data interaction function.
Accordingly, embodiments of the invention also provide a kind of computer-readable recording medium, the computer-readable storage
Media storage has one or more program, one or more of programs can by one or more computing device, with
Any tables of data method for building up that previous embodiment provides is realized, therefore can also realize corresponding technique effect.Above
It is described in detail, here is omitted.
It should be noted that herein, such as first and second or the like relational terms are used merely to a reality
Body or operation make a distinction with another entity or operation, and not necessarily require or imply and deposited between these entities or operation
In any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant are intended to
Nonexcludability includes, so that process, method, article or equipment including a series of elements not only will including those
Element, but also the other element including being not expressly set out, or it is this process, method, article or equipment also to include
Intrinsic key element.In the absence of more restrictions, the key element limited by sentence " including one ... ", it is not excluded that
Other identical element in the process including the key element, method, article or equipment also be present.
Each embodiment in this specification is described by the way of related, identical similar portion between each embodiment
Divide mutually referring to what each embodiment stressed is the difference with other embodiment.
For device embodiment, because it is substantially similar to embodiment of the method, so the comparison of description is simple
Single, the relevent part can refer to the partial explaination of embodiments of method.
For convenience of description, it is to be divided into various units/modules with function to describe respectively to describe apparatus above.Certainly, exist
The function of each unit/module can be realized in same or multiple softwares and/or hardware when implementing of the invention.
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
The hardware of correlation is instructed to complete by computer program, described program can be stored in a computer read/write memory medium
In, the program is upon execution, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, described storage medium can be magnetic
Dish, CD, read-only memory (Read-Only Memory, ROM) or random access memory (RandomAccess
Memory, RAM) etc..
The foregoing is only a specific embodiment of the invention, but protection scope of the present invention is not limited thereto, any
Those familiar with the art the invention discloses technical scope in, the change or replacement that can readily occur in, all should
It is included within the scope of the present invention.Therefore, protection scope of the present invention should be defined by scope of the claims.
Claims (10)
- A kind of 1. tables of data method for building up, it is characterised in that including：The attribute information of first tables of data is obtained according to index information of first tables of data in a kind of database；The attribute information is adjusted according to the mapping ruler between two class databases and a kind of database；Table statement is built using the attribute information generation after adjustment, to build table statement in the two classes database according to Generation the second tables of data corresponding with first tables of data.
- 2. according to the method for claim 1, it is characterised in that the index information includes first tables of data described Library name and table name in a kind of database；The attribute information includes following at least one：Field, field type, row annotation.
- 3. according to the method for claim 2, it is characterised in that it is described according to two class databases and a kind of database it Between mapping ruler the attribute information is adjusted including：If the field type includes preset kind, the preset kind is replaced with into corresponding target type；If the row annotation includes default punctuate, the default punctuate is replaced with into corresponding target punctuate.
- 4. according to the method in any one of claims 1 to 3, it is characterised in that the attribute using after adjustment Table statement is built in information generation to be included：Dynamic sentence splicing is carried out using the attribute information after adjustment；The storage format that will be used in the two classes database second tables of data carries out storage format splicing；Table statement is built according to the generation of the splicing result of the splicing result of the dynamic sentence and the storage format.
- 5. according to the method for claim 4, it is characterised in that in the splicing result according to the dynamic sentence and institute State and built described in the splicing result generation of storage format after table statement, methods described also includes：The preset field of table statement deposit preset data table will be built described in generation, the field type of the preset field is character Large object CLOB.
- 6. according to the method for claim 5, it is characterised in that the preset data table includes at least one entry, each The entry exists including library name and table name and second tables of data of first tables of data in a kind of database Library name in the two classes database.
- 7. according to the method for claim 4, it is characterised in that in the splicing result according to the dynamic sentence and institute State and built described in the splicing result generation of storage format after table statement, methods described also includes：By the translation and compiling environment built table statement and import the two classes database；According to the compiling result under the translation and compiling environment, second tables of data is generated in the two classes database.
- 8. according to the method in any one of claims 1 to 3, it is characterised in that a kind of database includes relationship type Database, the two classes database include big data database.
- 9. a kind of electronic equipment, it is characterised in that the electronic equipment includes：Housing, processor, memory, circuit board and electricity Source circuit, wherein, circuit board is placed in the interior volume that housing surrounds, and processor and memory are set on circuit boards；Power supply Circuit, for each circuit or the device power supply for above-mentioned electronic equipment；Memory is used to store executable program code；Processing The executable program code that device is stored by reading in memory runs program corresponding with executable program code, for holding Tables of data method for building up described in the foregoing any claim 1-8 of row.
- A kind of 10. computer-readable recording medium, it is characterised in that the computer-readable recording medium storage have one or Multiple programs, one or more of programs can be by one or more computing devices, to realize in claim 1 to 8 Tables of data method for building up described in any one.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710700500.XA CN107545044A (en) | 2017-08-15 | 2017-08-15 | A kind of tables of data method for building up, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710700500.XA CN107545044A (en) | 2017-08-15 | 2017-08-15 | A kind of tables of data method for building up, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107545044A true CN107545044A (en) | 2018-01-05 |
Family
ID=60970830
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710700500.XA Pending CN107545044A (en) | 2017-08-15 | 2017-08-15 | A kind of tables of data method for building up, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107545044A (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108710660A (en) * | 2018-05-11 | 2018-10-26 | 上海核工程研究设计院有限公司 | A kind of items property parameters modeling of database and storage method |
| CN109241184A (en) * | 2018-08-20 | 2019-01-18 | 中国平安人寿保险股份有限公司 | Method of data synchronization, device, computer equipment and storage medium |
| CN109492057A (en) * | 2018-10-26 | 2019-03-19 | 深圳点猫科技有限公司 | A kind of educational system is used for Hive offline computing method and electronic equipment |
| CN109559808A (en) * | 2018-11-07 | 2019-04-02 | 平安医疗健康管理股份有限公司 | A kind of data processing method, device, equipment and storage medium |
| CN110427498A (en) * | 2019-07-24 | 2019-11-08 | 新华智云科技有限公司 | Storage method, device, storage equipment and the storage medium of media information |
| CN110647564A (en) * | 2019-08-14 | 2020-01-03 | 中国平安财产保险股份有限公司 | Hive table establishing method, electronic device and computer readable storage medium |
| CN110928895A (en) * | 2018-09-19 | 2020-03-27 | 阿里巴巴集团控股有限公司 | Data query method, data table establishing method, device and equipment |
| CN111241053A (en) * | 2018-11-29 | 2020-06-05 | 中国移动通信集团四川有限公司 | Data table creating method, device, equipment and storage medium |
| CN111680092A (en) * | 2020-06-05 | 2020-09-18 | 深圳市卡数科技有限公司 | Method, system, server and storage medium for importing data into hive table |
| CN112817990A (en) * | 2021-01-28 | 2021-05-18 | 北京百度网讯科技有限公司 | Data processing method and device, electronic equipment and readable storage medium |
| CN113127453A (en) * | 2021-06-10 | 2021-07-16 | 平安普惠企业管理有限公司 | Method, device, equipment and storage medium for cross-database migration of Oracle data |
| CN113505128A (en) * | 2021-06-30 | 2021-10-15 | 平安科技（深圳）有限公司 | Method, device and equipment for creating data table and storage medium |
| CN117331963A (en) * | 2023-11-28 | 2024-01-02 | 恒生电子股份有限公司 | Data access processing method and device, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060190476A1 (en) * | 2005-02-18 | 2006-08-24 | Mettovaara Risto K | Database storage system and associated method |
| CN102063491A (en) * | 2010-12-30 | 2011-05-18 | 浪潮集团山东通用软件有限公司 | Data structure capable of realizing data back-up and restoration of different types of databases and realization method |
| CN103530327A (en) * | 2013-09-25 | 2014-01-22 | 清华大学深圳研究生院 | Method for migrating data from non-relational database to relational database |
| CN104281704A (en) * | 2014-10-22 | 2015-01-14 | 新华瑞德（北京）网络科技有限公司 | Database data copying method and device |
| CN105069033A (en) * | 2015-07-22 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Method and device for creating database table model |
-
2017
- 2017-08-15 CN CN201710700500.XA patent/CN107545044A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060190476A1 (en) * | 2005-02-18 | 2006-08-24 | Mettovaara Risto K | Database storage system and associated method |
| CN102063491A (en) * | 2010-12-30 | 2011-05-18 | 浪潮集团山东通用软件有限公司 | Data structure capable of realizing data back-up and restoration of different types of databases and realization method |
| CN103530327A (en) * | 2013-09-25 | 2014-01-22 | 清华大学深圳研究生院 | Method for migrating data from non-relational database to relational database |
| CN104281704A (en) * | 2014-10-22 | 2015-01-14 | 新华瑞德（北京）网络科技有限公司 | Database data copying method and device |
| CN105069033A (en) * | 2015-07-22 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Method and device for creating database table model |
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108710660A (en) * | 2018-05-11 | 2018-10-26 | 上海核工程研究设计院有限公司 | A kind of items property parameters modeling of database and storage method |
| CN109241184A (en) * | 2018-08-20 | 2019-01-18 | 中国平安人寿保险股份有限公司 | Method of data synchronization, device, computer equipment and storage medium |
| CN109241184B (en) * | 2018-08-20 | 2024-03-15 | 中国平安人寿保险股份有限公司 | Data synchronization method, device, computer equipment and storage medium |
| CN110928895A (en) * | 2018-09-19 | 2020-03-27 | 阿里巴巴集团控股有限公司 | Data query method, data table establishing method, device and equipment |
| CN110928895B (en) * | 2018-09-19 | 2023-07-04 | 阿里巴巴集团控股有限公司 | Data query and data table establishment method, device and equipment |
| CN109492057A (en) * | 2018-10-26 | 2019-03-19 | 深圳点猫科技有限公司 | A kind of educational system is used for Hive offline computing method and electronic equipment |
| CN109559808A (en) * | 2018-11-07 | 2019-04-02 | 平安医疗健康管理股份有限公司 | A kind of data processing method, device, equipment and storage medium |
| CN111241053A (en) * | 2018-11-29 | 2020-06-05 | 中国移动通信集团四川有限公司 | Data table creating method, device, equipment and storage medium |
| CN111241053B (en) * | 2018-11-29 | 2022-08-23 | 中国移动通信集团四川有限公司 | Data table creating method, device, equipment and storage medium |
| CN110427498A (en) * | 2019-07-24 | 2019-11-08 | 新华智云科技有限公司 | Storage method, device, storage equipment and the storage medium of media information |
| CN110647564A (en) * | 2019-08-14 | 2020-01-03 | 中国平安财产保险股份有限公司 | Hive table establishing method, electronic device and computer readable storage medium |
| CN110647564B (en) * | 2019-08-14 | 2023-11-24 | 中国平安财产保险股份有限公司 | Hive table building method, electronic device and computer readable storage medium |
| CN111680092A (en) * | 2020-06-05 | 2020-09-18 | 深圳市卡数科技有限公司 | Method, system, server and storage medium for importing data into hive table |
| CN112817990A (en) * | 2021-01-28 | 2021-05-18 | 北京百度网讯科技有限公司 | Data processing method and device, electronic equipment and readable storage medium |
| CN112817990B (en) * | 2021-01-28 | 2024-03-08 | 北京百度网讯科技有限公司 | Data processing method, device, electronic equipment and readable storage medium |
| CN113127453A (en) * | 2021-06-10 | 2021-07-16 | 平安普惠企业管理有限公司 | Method, device, equipment and storage medium for cross-database migration of Oracle data |
| CN113505128A (en) * | 2021-06-30 | 2021-10-15 | 平安科技（深圳）有限公司 | Method, device and equipment for creating data table and storage medium |
| CN113505128B (en) * | 2021-06-30 | 2024-05-31 | 平安科技（深圳）有限公司 | Method, device, equipment and storage medium for creating data table |
| CN117331963A (en) * | 2023-11-28 | 2024-01-02 | 恒生电子股份有限公司 | Data access processing method and device, electronic equipment and storage medium |
| CN117331963B (en) * | 2023-11-28 | 2024-03-08 | 恒生电子股份有限公司 | Data access processing method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107545044A (en) | A kind of tables of data method for building up, electronic equipment and storage medium | |
| US9934220B2 (en) | Content revision using question and answer generation | |
| US11030259B2 (en) | Document searching visualized within a document | |
| CN110276023B (en) | POI transition event discovery method, device, computing equipment and medium | |
| CN105335412A (en) | Method and device for data conversion and data migration | |
| CN107807915B (en) | Error correction model establishing method, device, equipment and medium based on error correction platform | |
| CN102609406B (en) | Learning device, judgment means, learning method and determination methods | |
| US11789940B2 (en) | Natural language interface to databases | |
| WO2023236252A1 (en) | Answer generation method and apparatus, electronic device, and storage medium | |
| CN110347999A (en) | A kind of method and apparatus of list data verification | |
| CN109828748A (en) | Code naming method, system, computer installation and computer readable storage medium | |
| CN111143556A (en) | Software function point automatic counting method, device, medium and electronic equipment | |
| WO2023236253A1 (en) | Document retrieval method and apparatus, and electronic device | |
| CN118093621A (en) | Structured query language generation method and device, electronic equipment and storage medium | |
| US9495352B1 (en) | Natural language determiner to identify functions of a device equal to a user manual | |
| US8244732B2 (en) | Named entity marking apparatus, named entity marking method, and computer readable medium thereof | |
| CN111602129B (en) | Smart search for notes and ink | |
| CN113377963B (en) | Knowledge-graph-based well site test data processing method and device | |
| CN113110843B (en) | Contract generation model training method, contract generation method and electronic equipment | |
| CN108694172B (en) | Information output method and device | |
| CN115169370A (en) | Corpus data enhancement method and device, computer equipment and medium | |
| CN111552576B (en) | Insertion and ingestion framework for question-answering system | |
| CN102214175A (en) | System and method for generating example sentence according to word relevancy | |
| CN109522211A (en) | Interface parameters transmission method, device, electronic equipment and storage medium | |
| CN117076515B (en) | Metadata tracing method and device in medical management system, server 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180105 |
|
| RJ01 | Rejection of invention patent application after publication |