CN108509595A - Method for sorting, device, storage medium and the equipment of isomeric data - Google Patents
Method for sorting, device, storage medium and the equipment of isomeric data Download PDFInfo
- Publication number
- CN108509595A CN108509595A CN201810281910.XA CN201810281910A CN108509595A CN 108509595 A CN108509595 A CN 108509595A CN 201810281910 A CN201810281910 A CN 201810281910A CN 108509595 A CN108509595 A CN 108509595A
- Authority
- CN
- China
- Prior art keywords
- data
- regularization
- database
- mark
- isomerization
- 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
The invention discloses a kind of method for sorting of isomeric data, device, storage medium and equipment, the method includes：Obtain the metadata of the isomerization data in multiple databases and the mark of the metadata；Regularization is carried out to the isomerization data according to the mark, forms Regularization database.The present invention can facilitate user to pass through a platform to retrieve and inquire corresponding isomerization data, improve the efficiency of retrieval and inquiry by the way that the data of multiple heterogeneous databases are carried out Regularization.
Description
Technical field
The present invention relates to data processing field more particularly to a kind of method for sorting of isomeric data, device, storage medium and
Equipment.
Background technology
Current database is relatively more, and diversity, stronger isomery spy is presented in data type, structure in database etc.
Property.Such as relational data, analytic type (OLAP) data, affairs type (OLTP) relation data, semi-structured data, unstructured number
According to for a variety of data, user has inconvenience in retrieval.
As shown in Figure 1, the data type that user when searching the same data, finds inside different databases may
It is different, in addition, when user searches a data, it may be necessary to integrate the resource inside different databases, can just access
Complete result.
Invention content
For the defects in the prior art, the present invention provide a kind of method for sorting of isomeric data, device, storage medium and
Equipment can facilitate user to pass through a platform to retrieve and inquire by the way that the data of multiple heterogeneous databases are carried out Regularization
Corresponding isomerization data, improve the efficiency of retrieval and inquiry.
In a first aspect, the present invention provides a kind of method for sorting of isomeric data, the method includes：
Obtain the metadata of the isomerization data in multiple databases and the mark of the metadata；
Regularization is carried out to the isomerization data according to the mark, forms Regularization database.
Further, the mark includes at least one data attribute of the isomerization data.
Further, described that the isomerization data are arranged according to the mark, formed Regularization database it
Afterwards, further include：The inquiry request for receiving user is inquired the data in Regularization database for the inquiry request, and is fed back
Query result.
Further, the query result is in data or the Regularization database in the Regularization database
The corresponding metadata of data.
Further, if the query result includes multiple data, optimal data therein is chosen as query result.
Further, described that Regularization is carried out to the isomerization data according to the mark, form Regularization database
Later, further include：The update status for monitoring the metadata, according to the update status to the number in the Regularization database
According to being updated accordingly.
It is described that Regularization is carried out to the isomerization data according to the mark, it is formed after Regularization database, is also wrapped
It includes：According to the retrieval of user and label input by user, the data name in the Regularization database is modified, and base
Regularization is re-started to the data in Regularization database in the change.
Second aspect, the present invention also provides a kind of collating unit of isomeric data, described device includes data acquisition mould
Block and Regularization module；
The data acquisition module, the metadata for obtaining the isomerization data in multiple databases and the metadata
Mark；
The Regularization module forms Regularization for carrying out Regularization to the isomerization data according to the mark
Database.
The third aspect, the present invention also provides a kind of computer readable storage mediums, are stored thereon with computer program and (refer to
Enable), the method described in first aspect is realized when which is executed by processor.
Fourth aspect the present invention also provides a kind of computer equipment, including memory, processor and is stored in memory
Computer program that is upper and can running on a processor, the processor realize the side described in first aspect when executing described program
Method.
As shown from the above technical solution, the present invention provides a kind of method for sorting of isomeric data, device, storage medium and sets
It is standby, by the way that the data of multiple heterogeneous databases are carried out Regularization, user can be facilitated to pass through a platform to retrieve and inquire phase
The isomerization data answered improve the efficiency of retrieval and inquiry.
Description of the drawings
Fig. 1 shows the principle schematic of the conventional method of inquiry isomeric data.
Fig. 2 shows the flow diagrams of the method for sorting of isomeric data provided in an embodiment of the present invention.
Fig. 3 shows the principle schematic that isomeric data is inquired based on method for sorting provided by the invention.
Fig. 4 shows the structural schematic diagram of the collating unit of isomeric data provided in an embodiment of the present invention.
Specific implementation mode
The embodiment of technical solution of the present invention is described in detail below in conjunction with attached drawing.Following embodiment is only used for
Clearly illustrate technical scheme of the present invention, therefore be intended only as example, and the protection of the present invention cannot be limited with this
Range.
Embodiment one
Fig. 2 shows the flow diagrams of the method for sorting of the isomeric data of the offer of the embodiment of the present invention one.Such as Fig. 2 institutes
Show, the method includes：
Step S1 obtains the metadata of the isomerization data in multiple isomerization databases and the mark of the metadata.
Preferably, isomerization data include but not limited to Types Below：Relational data, analytic type (OLAP) data, thing
Business type (OLTP) relation data, semi-structured data (including diagram data and XML data), unstructured data (including image, regard
Frequently, audio, long text).
Preferably, the mark includes the time of the data names of the isomerization data, data file source, data
At least one data attribute such as stamp, data type.
Step S2 carries out Regularization to the isomerization data according to the mark, forms Regularization database.
Preferably, Regularization is carried out to the isomerization data according to the mark, including：According to mark to isomerization number
According to being cleared up, converted, merged or remolded.
In one example, may also include after step S2：The inquiry request for receiving user, is looked into for the inquiry request
Ask the data in Regularization database, and feedback query result.
Wherein, the query result be can be data in the Regularization database, can also be the Regularization
The corresponding metadata of data in database.
If query result includes multiple data, optimal data therein is chosen as query result.
In one example, may also include after step S2：The update status for monitoring the metadata, according to the update
Situation updates the data in the Regularization database accordingly.
Specifically, the data in Regularization database can be carried out according to the increase of metadata, deletion, modification situation
It accordingly increases, be deleted or modified, to realize the real-time update to Regularization database.
In one example, may also include after step S2：The retrieval of user and label input by user are received, according to
The retrieval and label are modified the data name in Regularization database, and based on the data name after change again into
Professional etiquette integralization, the step of Regularization is the same as step S2 again.
Based on the obtained Regularization database of method for sorting described in the embodiment of the present invention one, user inquires the original of data
Reason is as shown in Figure 3.
Based on the above content, the technique effect that the embodiment of the present invention one may be implemented is：By the number of multiple heterogeneous databases
According to Regularization is carried out, corresponding isomerization data are retrieved and inquired to facilitate user to pass through a platform, retrieval is improved and looks into
The efficiency of inquiry.
Embodiment two
Accordingly to the embodiment of the present invention one, second embodiment of the present invention provides a kind of optimization of distributed data management dresses
It sets, as shown in figure 4, described device includes the data acquisition module 201 interconnected and Regularization module 202；
The data acquisition module 201, the metadata for obtaining the isomerization data in multiple databases and the member
The mark of data；
The Regularization module 202 is formed regular for carrying out Regularization to the isomerization data according to the mark
Change database.
In one example, described device further includes the enquiry module being connect with Regularization module 202, for receiving user
Inquiry request, inquire the data in Regularization database, and feedback query result for the inquiry request.
In one example, described device further includes the update module being connect with Regularization module 202, described for monitoring
The update status of metadata updates the data in the Regularization database according to the update status accordingly.
In one example, described device further includes the Regularization module again being connect with Regularization module 202, for connecing
Receive the retrieval of user and label input by user, according to the retrieval and label, to the data name in Regularization database into
Row change, and Regularization is re-started based on the data name after change.
The above-mentioned particular content about optimization device may refer to embodiment one, and details are not described herein.
Embodiment three
Accordingly to the embodiment of the present invention one, the embodiment of the present invention three provides a kind of computer readable storage medium, thereon
It is stored with computer program (instruction), the optimization described in the embodiment of the present invention one is realized when which is executed by processor
Method.
Above-mentioned storage medium includes：USB flash disk, read-only memory (ROM, Read-Only Memory), is deposited mobile hard disk at random
The various media that can store program code such as access to memory (RAM, Random Access Memory), magnetic disc or CD.
The above-mentioned particular content about computer readable storage medium may refer to embodiment one, and details are not described herein.
Example IV
Accordingly to the embodiment of the present invention one, the embodiment of the present invention four provides a kind of computer equipment, including memory, place
The computer program managed device and storage on a memory and can run on a processor, the processor execute real when described program
Optimization method described in the existing embodiment of the present invention one.
The above-mentioned particular content about computer equipment may refer to embodiment one, and details are not described herein.
Without conflicting with each other, those skilled in the art can be by different embodiments described in this specification
Or the feature of example and different embodiments or examples is combined.
It should be noted that the present invention Figure of description in block diagram and or flow chart in each box and frame
The combination of figure and/or the box in flow chart can use function or the dedicated hardware based system of action as defined in executing
It realizes, or can be realized with the combination that specialized hardware is instructed with acquisition machine.
Finally it should be noted that：The above embodiments are only used to illustrate the technical solution of the present invention., rather than its limitations；To the greatest extent
Present invention has been described in detail with reference to the aforementioned embodiments for pipe, it will be understood by those of ordinary skill in the art that：Its according to
So can with technical scheme described in the above embodiments is modified, either to which part or all technical features into
Row equivalent replacement；And these modifications or replacements, various embodiments of the present invention technology that it does not separate the essence of the corresponding technical solution
The range of scheme should all cover in the claim of the present invention and the range of specification.
Claims (10)
1. a kind of method for sorting of isomeric data, which is characterized in that the method includes：
Obtain the metadata of the isomerization data in multiple databases and the mark of the metadata；
Regularization is carried out to the isomerization data according to the mark, forms Regularization database.
2. according to the method described in claim 1, it is characterized in that, the mark includes at least one of the isomerization data
Data attribute.
3. according to the method described in claim 1, it is characterized in that, described carry out the isomerization data according to the mark
It arranges, is formed after Regularization database, further include：The inquiry request for receiving user is inquired regular for the inquiry request
Change the data in database, and feedback query result.
4. according to the method described in claim 3, it is characterized in that, the query result is the number in the Regularization database
According to or the Regularization database in the corresponding metadata of data.
5. if according to the method described in claim 4, it is characterized in that, the query result includes multiple data, selection is wherein
Optimal data as query result.
6. according to the method described in claim 1, it is characterized in that, described carry out the isomerization data according to the mark
Regularization forms after Regularization database, further includes：The update status for monitoring the metadata, according to the update status
Data in the Regularization database are updated accordingly.
7. according to the method described in claim 1, it is characterized in that, described carry out the isomerization data according to the mark
Regularization forms after Regularization database, further includes：According to the retrieval of user and label input by user, to described regular
Change database in data name be modified, and based on it is described change the data in Regularization database are re-started it is regular
Change.
8. a kind of collating unit of isomeric data, which is characterized in that described device includes data acquisition module and Regularization module；
The data acquisition module, the mark of metadata and the metadata for obtaining the isomerization data in multiple databases
Know；
The Regularization module forms Regularization data for carrying out Regularization to the isomerization data according to the mark
Library.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is held by processor
Method according to any one of claims 1 to 7 is realized when row.
10. a kind of computer equipment, including memory, processor and storage are on a memory and the meter that can run on a processor
Calculation machine program, which is characterized in that the processor realizes side according to any one of claims 1 to 7 when executing described program
Method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810281910.XA CN108509595A (en) | 2018-04-02 | 2018-04-02 | Method for sorting, device, storage medium and the equipment of isomeric data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810281910.XA CN108509595A (en) | 2018-04-02 | 2018-04-02 | Method for sorting, device, storage medium and the equipment of isomeric data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108509595A true CN108509595A (en) | 2018-09-07 |
Family
ID=63379743
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810281910.XA Pending CN108509595A (en) | 2018-04-02 | 2018-04-02 | Method for sorting, device, storage medium and the equipment of isomeric data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108509595A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160321271A1 (en) * | 2010-07-29 | 2016-11-03 | Sap Se | Archive-system-independent archive-type objects |
| CN106708815A (en) * | 2015-07-15 | 2017-05-24 | 中兴通讯股份有限公司 | Data processing method, device and system |
| CN106874335A (en) * | 2016-08-19 | 2017-06-20 | 阿里巴巴集团控股有限公司 | Behavioral data processing method, device and server |
| CN107357940A (en) * | 2017-08-28 | 2017-11-17 | 中煤航测遥感集团有限公司 | A kind of method and apparatus of real estate Data Integration |
| CN107357933A (en) * | 2017-08-04 | 2017-11-17 | 刘应波 | A kind of label for multi-source heterogeneous science and technology information resource describes method and apparatus |
| CN107368588A (en) * | 2017-07-24 | 2017-11-21 | 人教数字出版有限公司 | A kind of heterogeneous resource Homogeneous method and device |
-
2018
- 2018-04-02 CN CN201810281910.XA patent/CN108509595A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160321271A1 (en) * | 2010-07-29 | 2016-11-03 | Sap Se | Archive-system-independent archive-type objects |
| CN106708815A (en) * | 2015-07-15 | 2017-05-24 | 中兴通讯股份有限公司 | Data processing method, device and system |
| CN106874335A (en) * | 2016-08-19 | 2017-06-20 | 阿里巴巴集团控股有限公司 | Behavioral data processing method, device and server |
| CN107368588A (en) * | 2017-07-24 | 2017-11-21 | 人教数字出版有限公司 | A kind of heterogeneous resource Homogeneous method and device |
| CN107357933A (en) * | 2017-08-04 | 2017-11-17 | 刘应波 | A kind of label for multi-source heterogeneous science and technology information resource describes method and apparatus |
| CN107357940A (en) * | 2017-08-28 | 2017-11-17 | 中煤航测遥感集团有限公司 | A kind of method and apparatus of real estate Data Integration |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200226151A1 (en) | System and method for supporting queries having sub-select constructs in a multidimensional database environment | |
| US10102253B2 (en) | Minimizing index maintenance costs for database storage regions using hybrid zone maps and indices | |
| CN103020204B (en) | A kind of method and its system carrying out multi-dimensional interval query to distributed sequence list | |
| US9009099B1 (en) | Method and system for reconstruction of object model data in a relational database | |
| US8880463B2 (en) | Standardized framework for reporting archived legacy system data | |
| CN105956123A (en) | Local updating software-based data processing method and apparatus | |
| WO2014145088A1 (en) | Apparatus, systems, and methods for batch and realtime data processing | |
| US20050223032A1 (en) | Loading data from a vertical database table into a horizontal database table | |
| CN106066895A (en) | A kind of intelligent inquiry system | |
| CN110570928A (en) | HBase and ozone based medical image file access method | |
| US8145580B2 (en) | Data management apparatus and method for managing data elements using a plurality of metadata elements | |
| US20140304266A1 (en) | Data base indexing | |
| CN109657803A (en) | The building of machine learning model | |
| US20050021924A1 (en) | Memory management tile optimization | |
| Krneta et al. | An approach to data mart design from a data vault | |
| US11657069B1 (en) | Dynamic compilation of machine learning models based on hardware configurations | |
| US11636124B1 (en) | Integrating query optimization with machine learning model prediction | |
| EP3282372B1 (en) | Method and apparatus for storing data | |
| US8200673B2 (en) | System and method for on-demand indexing | |
| Tiwari et al. | Contextual snowflake modelling for pattern warehouse logical design | |
| CN107291938A (en) | Order Query System and method | |
| CN109299106B (en) | Data query method and device | |
| US11093509B2 (en) | Data processing system for curating search result facets | |
| CN108509595A (en) | Method for sorting, device, storage medium and the equipment of isomeric data | |
| US7433882B2 (en) | Data management system and computer program |
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: 20180907 |