CN109582695A - Data general-purpose querying method and inquiry system under a kind of micro services framework - Google Patents
Data general-purpose querying method and inquiry system under a kind of micro services framework Download PDFInfo
- Publication number
- CN109582695A CN109582695A CN201811473322.2A CN201811473322A CN109582695A CN 109582695 A CN109582695 A CN 109582695A CN 201811473322 A CN201811473322 A CN 201811473322A CN 109582695 A CN109582695 A CN 109582695A
- Authority
- CN
- China
- Prior art keywords
- data
- model
- metadata
- database
- service
- 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
Abstract
This application discloses data general-purpose querying method and inquiry systems under a kind of micro services framework, and the querying method includes: S2: corresponding first data are pulled from first database；S4: synchronous first data for receiving the data synchronization service unit；S6: establishing Data Storage Models, and establishes data model view；S8: the metadata is managed；S10: query service is provided by metadata schema and first data, corresponding data model query statement is formed according to the description of the metadata schema, the interface of uniform data warehouse unit is called to be inquired.Compared with prior art, data general-purpose querying method and inquiry system are that solution inquiry times are frequent under micro services framework provided herein, and high concurrent, real-time property requires relatively not high data query scene, does not ensure coming into force for write-in data.But in such a way that database timing and database are monitored, ensure the quasi real time property of data.
Description
Technical field
A kind of data query method and inquiry system, in particular under a kind of micro services framework data general-purpose querying method and
Inquiry system.
Background technique
Under Internet application scene, a complicated operation system is usually made of multiple micro services, each micro services
It generally will use independent database and carry out data storage and query.
Under single service, the storage and inquiry of data are typically all to be carried out by database.But in complicated business
In system, the data that a business paper uses are derived from other multiple micro services to be provided.
For example, a reimbursement business paper, may lead above with other multiple business objects: charge type undertakes portion
Door, payee bank account etc..These are provided by independent micro services.And in exploitation or implementation process, document may be used also
Other attributes can be continuously replenished, such as engineering project reimbursement can carry corresponding engineering project, the insurance of travel class will increase phase
The mode of transportation and location declaration of pass.
Based on the above circumstances, the major key that above multiple objects can be quoted on the object of reimbursement document, as current document
Attribute.But when interface shows or specific transactions calculate, relevant data can be inquired according to major key.
Fig. 1 is please referred to, for data providing operation system, generally can provide phase according to the demand of operation system
The api interface of pass externally provides service.This kind of api interface is usually to realize certain a kind of business with specific transactions logic
Special interface.The simple data-query interfaces that business paper needs above can also be provided by similar api.
In business paper in use, treatment process for a data, such as interface display, it needs according to interface display
Attribute, successively call the query interface of related service, operation system needs to record the interface that all relevant micro services provide.
Meanwhile when document of activating business needs new service, need to rewrite original code to call related new micro services to provide
Interface inquired.Therefore change realization and extension that scheme is unfavorable for operation system.
Secondly, often will appear the scene for being associated with multiple service-seekings, such as examine in expense report in business realizing
When, the expense for inquiring expense report undertakes the corresponding user of higher level department head of department and examines.Need tradition multiple right
As being inquired (referring to figure 2.).
It is provided by service interface and then needs to provide the query interface of higher level and responsible person in department, use is provided on employee
The interface of family inquiry
When submitting an expense account unitary call, need to call distinct interface in three times.It should be understood that the format of department's interface calls respectively.Or
Person provides the higher level department head interface for corresponding to user by departmental service.The interface of departmental service be will lead in this way according to business
Scene frequently increases.
It is carried out in query scheme by api interface, there are the following problems:
1, how excessively high the complexity that will lead to realization is, and each inquiry will develop stand-alone service interface according to business difference.
2, the concatenated call of multiple services will lead to request time it is elongated, the plenty of time consume on request process.
3, in the case where calling link complicated, the problem of any service or the problem of access link, can all cause service can not
It uses, reliability of service is caused to decline.
In summary, it is desirable to provide a kind of service of general simple queries solves between multiple micro services, without complicated industry
The ability of the simple queries of business.
Summary of the invention
The application's aims to overcome that the above problem or at least is partially solved or alleviates the above problem.
According to the one aspect of the application, data general-purpose querying method under a kind of micro services framework is provided, including as follows
Step: S2: data synchronization service step pulls corresponding first data from first database；S4: uniform data warehouse step
Suddenly, synchronous first data for receiving the data synchronization service unit；S6: storage model management process is established data and is deposited
Model is stored up, and establishes data model view；S8: metadata schema management process manages the metadata, and the metadata is to retouch
State the data of first data；S10: query service step provides inquiry clothes by metadata schema and first data
Business, according to the description of the metadata schema, forms corresponding data model query statement, calls uniform data warehouse list
The interface of member is inquired.
Data general-purpose querying method under above-mentioned micro services framework, the step S2 includes: S22: by timer, being referred to
Determine interval time increment and pull corresponding data from raw data base, is written in uniform data warehouse；S24: become according to data
Change propelling data, the mechanism provided by data itself, service database receives execution journal when changing, and parses
And the structure according to defined in inquiry view forms the data of update, write-in is unified from the corresponding database table of new inquiry view
In data warehouse.
Data general-purpose querying method under above-mentioned micro services framework, the step S22 includes: S221: being obtained according to view
Take conditional information and table name information；S222: synchronization time last time is obtained；S223: when synchronization time last time is empty, according to
The conditional information and the table name information generate sql；S224: when synchronization time last time is not sky, increase timestamp
Condition, and sql is generated according to the conditional information and the table name information；S225: the corresponding data source of the view is inquired；
S226: call the data base querying of the data source, when there are multiple databases, successively inquire；S227: data bins are written in data
In library.
Data general-purpose querying method under above-mentioned micro services framework, the step S24 includes: S241: operation system is write
Enter data to service database；S242: monitored data library variation；S243: delta data ID is obtained；S244: inquiry mirror image view；
S245: according to the mirror image view generation query statement, increase ID condition；S246: according to the query statement in the business
Data are inquired in database；S247: data warehouse is written into the data inquired.
Data general-purpose querying method under above-mentioned micro services framework carrys out sources operation system by retouching in storage model management
The model for the data warehouse stated, it is corresponding with the storage model of metadata, establish the Object Relational Model of complete operation system.
According to further aspect of the application, data general-purpose inquiry system under a kind of micro services framework is additionally provided, comprising:
Data synchronization service unit pulls corresponding first data from first database；Uniform data warehouse unit, connects the number
According to synchronous service unit, for synchronous first data for receiving the data synchronization service unit；Storage model management is single
Member connects the data synchronization service unit, for establishing Data Storage Models, and establishes data model view；Metadata mould
Type administrative unit connects the storage model administrative unit, and for managing the metadata, the metadata is to describe described the
The data of one data；Query service unit connects the metadata schema administrative unit and uniform data warehouse unit, leads to
The metadata schema and first data in the same data warehouse unit for crossing the metadata schema administrative unit mention
For query service, the query service unit forms corresponding data model inquiry language according to the description of the metadata schema
Sentence, calls the interface of uniform data warehouse unit to be inquired.
According to further aspect of the application, a kind of computer equipment, including memory, processor and storage are additionally provided
In the memory and the computer program that can be run by the processor, wherein the processor executes the computer
Method described in any of the above embodiments is realized when program.
According to further aspect of the application, a kind of computer readable storage medium is additionally provided, it is preferably non-volatile
Readable storage medium storing program for executing, is stored with computer program, and the computer program is realized any of the above-described when executed by the processor
Method described in.
According to further aspect of the application, a kind of computer program product, including computer-readable code are additionally provided,
When the computer-readable code is executed by computer equipment, the computer equipment is caused to execute described in any of the above embodiments
Method.
Compared with prior art, data general-purpose querying method and inquiry system are under micro services framework provided herein
It is frequent to solve inquiry times, high concurrent, real-time property requires relatively not high data query scene, does not ensure write-in data
It comes into force.But in such a way that database timing and database are monitored, ensure the quasi real time property of data.It is not recommended that in data dimension
The scene for the inquiry itself for protecting interface uses.It is generally used for selection data package inquiry, interface display data translation, according to master
The simple queries of key, when importing data according to coding/Title Translation scene.
According to the accompanying drawings to the detailed description of the specific embodiment of the application, those skilled in the art will be more
Above-mentioned and other purposes, the advantages and features of the application are illustrated.
Detailed description of the invention
Some specific embodiments of the application are described in detail by way of example and not limitation with reference to the accompanying drawings hereinafter.
Identical appended drawing reference denotes same or similar part or part in attached drawing.It should be appreciated by those skilled in the art that these
What attached drawing was not necessarily drawn to scale.In attached drawing:
Fig. 1 is according to data query method schematic diagram in the prior art；
Fig. 2 is according to data query method schematic diagram in the prior art；
Fig. 3 is the system schematic of inquiry system in one embodiment of the application；
Fig. 4 is the schematic diagram of storage model management in one embodiment of the application；
Fig. 5 is the schematic diagram of storage model management in one embodiment of the application；
Fig. 6 is the schematic diagram of storage model management in one embodiment of the application；
Fig. 7 is the flow diagram that data are synchronous in one embodiment of the application；
Fig. 8 is the flow diagram that data are synchronous in one embodiment of the application；
Fig. 9 is the flow diagram that data are synchronous in one embodiment of the application；
Figure 10 is the schematic diagram of computer equipment in one embodiment of the application；
Figure 11 is the schematic diagram of computer readable storage medium in one embodiment of the application.
Specific embodiment
In one embodiment of the application, data general-purpose querying method includes the following steps: 2 under micro services framework: data are synchronous
Service steps pull corresponding first data from first database；S4: uniform data warehouse step, it is synchronous to receive the number
According to first data of synchronous service unit；S6: storage model management process establishes Data Storage Models, and establishes data
Model view；S8: metadata schema management process manages the metadata, and the metadata is description first data
Data；S10: query service step provides query service by metadata schema and first data, according to the metadata
The description of model forms corresponding data model query statement, and the interface of uniform data warehouse unit is called to be inquired.
In one embodiment of the application, the step S2 includes: S22: by timer, appointed interval incremental time is from original
Corresponding data are pulled in beginning database, are written in uniform data warehouse；S24: according to data variation propelling data, pass through data
The mechanism that itself is provided, service database receive execution journal when changing, and parse and define according in inquiry view
Structure form the data of update from the corresponding database table of new inquiry view, be written in uniform data warehouse.
In one embodiment of the application, the step S22 includes: S221: obtaining conditional information according to view and table name is believed
Breath；S222: synchronization time last time is obtained；S223: when synchronization time last time is empty, according to the conditional information and described
Table name information generates sql；S224: when synchronization time last time is not sky, increase timestamp condition, and according to the condition
Information and the table name information generate sql；S225: the corresponding data source of the view is inquired；S226: the data source is called
Data base querying is successively inquired when there is multiple databases；S227: data are written in data warehouse.
In one embodiment of the application, the step S24 includes: S241: operation system writes data to service database；
S242: monitored data library variation；S243: delta data ID is obtained；S244: inquiry mirror image view；S245: it is regarded according to the mirror image
Figure generates query statement, increases ID condition；S246: data are inquired in the service database according to the query statement；
S247: data warehouse is written into the data inquired.
In one embodiment of the application, carrys out sources operation system and pass through the mould of data warehouse described in storage model management
Type, it is corresponding with the storage model of metadata, establish the Object Relational Model of complete operation system.
Present invention also provides data general-purpose inquiry systems (referring to figure 3.) under a kind of micro services framework, comprising: data are same
Service unit is walked, corresponding first data are pulled from first database；It is synchronous to connect the data for uniform data warehouse unit
Service unit, for synchronous first data for receiving the data synchronization service unit；Storage model administrative unit, connection
The data synchronization service unit for establishing Data Storage Models, and establishes data model view；Metadata schema management is single
Member connects the storage model administrative unit, and for managing the metadata, the metadata is description first data
Data；Query service unit connects the metadata schema administrative unit and uniform data warehouse unit, passes through the member
First data in the metadata schema of data model administrative unit and the same data warehouse unit provide inquiry clothes
Business, the query service unit form corresponding data model query statement according to the description of the metadata schema, call institute
The interface for stating uniform data warehouse unit is inquired.
Referring to figure 3., the invention mainly comprises several parts, storage model management, metadata schema management, unified numbers
According to warehouse, data synchronization service, data query service.
One, storage model management: it is responsible for providing the foundation of Data Storage Models, external data is established by data providing
Model view.Support data provider according to the sensibility of data or whether only it is internal using attribute etc. to the data mould of offer
Type is selected, and the necessary data attribute that can externally provide only is provided.
Single table model description is supported in the management for supporting the model of inquiry Data View, also supports the associated complicated knot of multilist
Structure data model describes (referring to figure 4.).
When carrying out inquiry view definition, data are screened in support, and data providing is specified to provide data attribute model
It encloses.Secondly, it is possible that in the case of need data source side provide ID, timestamp, delete label etc. attributes.For follow-up data
Extract the increment extraction ability (referring to figure 5.) when service.
A variety of table models are supported to describe, by being associated with surface condition opening relationships
It supports that read-only database account can be provided by business side to the connection management of source database, for synchronous clothes
Synchrodata of being engaged in uses.The relation management of support model and database supports centralized database deployment and multi-tenant multiple database
Deployment mode (please referring to Fig. 6).
For the deployment model for supporting multi-tenant, part micro services can connect there are the multiple databases of identical table structure, lead to
Point library for crossing tenant or other parameters progress data stores.Therefore, the description of multiple databases is supported in the description of data source model
Mode.Relationship only is kept with data source on model view, is carrying out sources operation system replacement database or is carrying out database isolation
In the case of, it does not need to remodify view model.
Two, metadata schema management: metadata generally refers to the data of description data, includes object model, object
The storage model of attribute model (data type including attribute, the adduction relationship with other objects) and object.Source business
System is by the model of data warehouse described in storage model management, and corresponding with the storage model of metadata, foundation is complete
The Object Relational Model of operation system.
Metadata schema supports attribute tags description, can be inquired according to unified label for subsequent query service,
Such as when according to ID return title, it is only necessary to which the name attribute setting label of a business provider in a model is (name)
It is inquired by unified sentence.
Three, uniform data warehouse uses the distributed NoSql database realizing for supporting high concurrent.It supports to press field condition
The mode of inquiry obtains data.It can pass through
Four, data synchronization service: corresponding data are pulled from the database of operation system in several ways and are synchronized to
In uniform data warehouse.Support following mode:
Please refer to Fig. 7, timed task pulls: by timer, appointed interval incremental time is pulled from raw data base
Corresponding data are written in uniform data warehouse.
Fig. 8 is please referred to, according to data variation propelling data, the mechanism provided by data itself, such as mysql
Binlog mechanism, service database receive execution journal (or after scanning to variation) parsing and basis when changing
Structure defined in view is inquired, from the corresponding database table of new inquiry view, the data of update is formed, uniform data storehouse is written
In library.
Usually by 1 initialization data of scheme, pass through 2 real-time synchronization data of scheme.And by being periodically executed scheme 1, use
In reparation because various abnormal conditions lead to the data of non-active synchronization.
Five, data query service provides the query service based on metadata schema by metadata schema.According to first number
It is described according to model, forms corresponding data model query statement, the interface of data warehouse is called to be inquired.
Fig. 9 is please referred to, the extension of sentence can be carried out according to label, such as Query Name is the user of " Zhang San ", can be made
Querying condition parameter is described with the mode of name=" Zhang San ", or<lable:name>=" Zhang San ".Query service receives
After parameter, according to metadata schema, the structure of storage model is converted to, the service interface of data warehouse is called to be inquired.
But data source is inquired when multiple tables of data or relationship, is that multiple queries execute respectively by query decomposition, as far as possible
The high-performance inquired using the single table of NoSql database.Finally result is integrated, returns to called side.
Generally speaking, this programme advantage is:
To original operation system without intrusion, the code of modification business service is not needed.
Definition inquire view when, can limitation inquiry field and increase querying condition by way of, to sensitive data into
Row filtering, avoids the occurrence of data problem.
Inquire view and practical business View separation, operation system can the database for modifying oneself simultaneously, pass through modification
View is inquired, guarantee does not change to original inquiry view properties, avoids the use for influencing other services.
Inquiry operation is carried out using independent data warehouse, avoids the performance for influencing original service database,
By using NoSql database sharing data warehouse, mentioning for this high concurrent operation is translated in tear such as interface major key
High execution efficiency.When data warehouse performance decline, more traditional relevant database is easier dynamic compatibilization extension.
Multiple synchronization scheme can select to use according to the demand of concrete scene or the requirement of real-time of specific data.
The program using independent inquiry data reference, query service is separated with persistence service, is alleviated in incognito
The pressure of the service database of business, while expansible NoSql database is used, improve search efficiency.Meanwhile avoid because
Under micro services scene, the database problem arbitrarily serviced causes integrity service unusable.
The program is that solution inquiry times are frequent, and high concurrent, real-time property requires relatively not high data query scene,
Do not ensure coming into force for write-in data.But in such a way that database timing and database are monitored, ensure data quasi real time
Property.It is not recommended that the scene in the inquiry itself at data maintenance interface uses.It is generally used for selection data package inquiry, interface is aobvious
Show data translation, according to the simple queries of major key, import data when according to coding/Title Translation scene.
Present invention also provides a kind of computer equipment (please referring to Figure 10), including memory, processor and it is stored in institute
State the computer program that can be run in memory and by the processor, which is characterized in that the processor executes the calculating
Method described in any of the above embodiments is realized when machine program.
Present invention also provides a kind of computer readable storage medium (please referring to Figure 11), and preferably non-volatile readable is deposited
Storage media is stored with computer program, which is characterized in that the computer program is realized above-mentioned when executed by the processor
Method described in any one.
Present invention also provides a kind of computer program products, including computer-readable code, which is characterized in that when described
When computer-readable code is executed by computer equipment, the computer equipment is caused to execute method described in any of the above embodiments.
Although the step of method in the application is the execution numbered according to numerical order, but be not meant to each step
Sequence has to carry out according to the sequence of number.It can be the relationship executed side by side between some steps, it might even be possible to overturn suitable
Sequence executes, in the range of belonging to protection required by the application.
In the above-described embodiments, can come wholly or partly by software, hardware, firmware or any combination thereof real
It is existing.When implemented in software, it can entirely or partly realize in the form of a computer program product.The computer program
Product includes one or more computer instructions.When computer loads and executes the computer program instructions, whole or portion
Ground is divided to generate according to process or function described in the embodiment of the present application.The computer can be general purpose computer, dedicated computing
Machine, computer network obtain other programmable devices.The computer instruction can store in computer readable storage medium
In, or from a computer readable storage medium to the transmission of another computer readable storage medium, for example, the computer
Instruction can pass through wired (such as coaxial cable, optical fiber, number from a web-site, computer, server or data center
User's line (DSL)) or wireless (such as infrared, wireless, microwave etc.) mode to another web-site, computer, server or
Data center is transmitted.The computer readable storage medium can be any usable medium that computer can access or
It is comprising data storage devices such as one or more usable mediums integrated server, data centers.The usable medium can be with
It is magnetic medium, (for example, floppy disk, hard disk, tape), optical medium (for example, DVD) or semiconductor medium (such as solid state hard disk
Solid State Disk (SSD)) etc..
Professional should further appreciate that, described in conjunction with the examples disclosed in the embodiments of the present disclosure
Unit and algorithm steps, can be realized with electronic hardware, computer software, or a combination of the two, hard in order to clearly demonstrate
The interchangeability of part and software generally describes each exemplary composition and step according to function in the above description.
These functions are implemented in hardware or software actually, the specific application and design constraint depending on technical solution.
Professional technician can use different methods to achieve the described function each specific application, but this realization
It is not considered that exceeding scope of the present application.
Those of ordinary skill in the art will appreciate that implement the method for the above embodiments be can be with
By program come instruction processing unit completion, the program be can store in computer readable storage medium, and the storage is situated between
Matter is non-transitory (English: non-transitory) medium, such as random access memory, read-only memory, flash
Device, hard disk, solid state hard disk, tape (English: magnetic tape), floppy disk (English: floppy disk), CD (English:
Optical disc) and any combination thereof.
The preferable specific embodiment of the above, only the application, but the protection scope of the application is not limited thereto,
Within the technical scope of the present application, any changes or substitutions that can be easily thought of by anyone skilled in the art,
Should all it cover within the scope of protection of this application.Therefore, the protection scope of the application should be with scope of protection of the claims
Subject to.
Claims (9)
1. data general-purpose querying method under a kind of micro services framework, which comprises the steps of:
S2: data synchronization service step pulls corresponding first data from first database；
S4: uniform data warehouse step, synchronous first data for receiving the data synchronization service unit；
S6: storage model management process establishes Data Storage Models, and establishes data model view；
S8: metadata schema management process manages the metadata, and the metadata is to describe the data of first data；
S10: query service step provides query service by metadata schema and first data, according to the metadata
The description of model forms corresponding data model query statement, and the interface of uniform data warehouse unit is called to be inquired.
2. data general-purpose querying method under micro services framework according to claim 1, which is characterized in that the step S2 packet
It includes:
S22: by timer, appointed interval incremental time pulls corresponding data from raw data base, and uniform data is written
In warehouse；
S24: according to data variation propelling data, the mechanism provided by data itself, service database connects when changing
By execution journal, parses and the structure according to defined in inquiry view is formed more from the corresponding database table of new inquiry view
New data are written in uniform data warehouse.
3. data general-purpose querying method under micro services framework according to claim 2, which is characterized in that the step S22
Include:
S221: conditional information and table name information are obtained according to view；
S222: synchronization time last time is obtained；
S223: when synchronization time last time is empty, sql is generated according to the conditional information and the table name information；
S224: when synchronization time last time is not sky, increase timestamp condition, and according to the conditional information and the table
Name information generates sql；
S225: the corresponding data source of the view is inquired；
S226: call the data base querying of the data source, when there are multiple databases, successively inquire；
S227: data are written in data warehouse.
4. data general-purpose querying method under micro services framework according to claim 2, which is characterized in that the step S24
Include:
S241: operation system writes data to service database；
S242: monitored data library variation；
S243: delta data ID is obtained；
S244: inquiry mirror image view；
S245: according to the mirror image view generation query statement, increase ID condition；
S246: data are inquired in the service database according to the query statement；
S247: data warehouse is written into the data inquired.
5. data general-purpose querying method under micro services framework according to claim 4, which is characterized in that carry out sources operation system
By storage model manage described in data warehouse model, it is corresponding with the storage model of metadata, establish complete business
The Object Relational Model of system.
6. data general-purpose inquiry system under a kind of micro services framework characterized by comprising
Data synchronization service unit pulls corresponding first data from first database；
Uniform data warehouse unit connects the data synchronization service unit, receives the data synchronization service list for synchronous
First data of member；
Storage model administrative unit connects the data synchronization service unit, for establishing Data Storage Models, and establishes data
Model view；
Metadata schema administrative unit connects the storage model administrative unit, for managing the metadata, the metadata
For the data for describing first data；
Query service unit connects the metadata schema administrative unit and uniform data warehouse unit, passes through the member
First data in the metadata schema of data model administrative unit and the same data warehouse unit provide inquiry clothes
Business, the query service unit form corresponding data model query statement according to the description of the metadata schema, call institute
The interface for stating uniform data warehouse unit is inquired.
7. a kind of computer equipment, including memory, processor and storage can be transported in the memory and by the processor
Capable computer program, which is characterized in that the processor is realized when executing the computer program as appointed in claim 1-5
Method described in one.
8. a kind of computer readable storage medium, preferably non-volatile readable storage medium, are stored with computer program,
It is characterized in that, the computer program realizes method according to any one of claims 1 to 5 when executed by the processor.
9. a kind of computer program product, including computer-readable code, which is characterized in that when the computer-readable code by
When computer equipment executes, the computer equipment perform claim is caused to require method described in any one of 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811473322.2A CN109582695A (en) | 2018-12-04 | 2018-12-04 | Data general-purpose querying method and inquiry system under a kind of micro services framework |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811473322.2A CN109582695A (en) | 2018-12-04 | 2018-12-04 | Data general-purpose querying method and inquiry system under a kind of micro services framework |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109582695A true CN109582695A (en) | 2019-04-05 |
Family
ID=65927252
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811473322.2A Pending CN109582695A (en) | 2018-12-04 | 2018-12-04 | Data general-purpose querying method and inquiry system under a kind of micro services framework |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109582695A (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110209534A (en) * | 2019-06-14 | 2019-09-06 | 四川长虹电器股份有限公司 | The system and method for automated back-up mysql database |
| CN110245148A (en) * | 2019-06-25 | 2019-09-17 | 河南中原消费金融股份有限公司 | A kind of date storage method, device, system and medium |
| CN111078961A (en) * | 2019-12-24 | 2020-04-28 | 用友网络科技股份有限公司 | Multi-data source query driving system, method, device and storage medium |
| CN111209292A (en) * | 2019-12-31 | 2020-05-29 | 成都库珀区块链科技有限公司 | Bin data management method, device and system |
| CN111291056A (en) * | 2020-02-25 | 2020-06-16 | 帆软软件有限公司 | Method for associating data table bottom layers of BI tool |
| CN111460241A (en) * | 2020-04-26 | 2020-07-28 | 甬矽电子(宁波)股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN112000696A (en) * | 2020-08-06 | 2020-11-27 | 苏州浪潮智能科技有限公司 | Framework for mirror image list query of multi-framework cloud platform mirror image warehouse |
| CN112487086A (en) * | 2020-11-17 | 2021-03-12 | 中国人寿保险股份有限公司 | Data synchronization method and device, electronic equipment and storage medium |
| CN112612778A (en) * | 2020-12-25 | 2021-04-06 | 上海航空工业(集团) 有限公司 | Enterprise data architecture method |
| CN113535768A (en) * | 2020-04-15 | 2021-10-22 | 北京京东乾石科技有限公司 | Production monitoring method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101710280A (en) * | 2009-11-05 | 2010-05-19 | 金蝶软件（中国）有限公司 | Packaging method and devices of BI product members |
| CN102073767A (en) * | 2011-01-12 | 2011-05-25 | 南京南瑞继保电气有限公司 | Method for managing metadata of virtual data warehouse of electric power information system group |
| CN105989150A (en) * | 2015-03-02 | 2016-10-05 | 中国移动通信集团四川有限公司 | Data query method and device based on big data environment |
| CN106844485A (en) * | 2016-12-23 | 2017-06-13 | 航天星图科技（北京）有限公司 | A kind of system and method for enterprise's heterogeneous database intelligent integrated |
| CN107103448A (en) * | 2016-02-23 | 2017-08-29 | 上海御行信息技术有限公司 | Data integrated system based on workflow |
-
2018
- 2018-12-04 CN CN201811473322.2A patent/CN109582695A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101710280A (en) * | 2009-11-05 | 2010-05-19 | 金蝶软件（中国）有限公司 | Packaging method and devices of BI product members |
| CN102073767A (en) * | 2011-01-12 | 2011-05-25 | 南京南瑞继保电气有限公司 | Method for managing metadata of virtual data warehouse of electric power information system group |
| CN105989150A (en) * | 2015-03-02 | 2016-10-05 | 中国移动通信集团四川有限公司 | Data query method and device based on big data environment |
| CN107103448A (en) * | 2016-02-23 | 2017-08-29 | 上海御行信息技术有限公司 | Data integrated system based on workflow |
| CN106844485A (en) * | 2016-12-23 | 2017-06-13 | 航天星图科技（北京）有限公司 | A kind of system and method for enterprise's heterogeneous database intelligent integrated |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110209534A (en) * | 2019-06-14 | 2019-09-06 | 四川长虹电器股份有限公司 | The system and method for automated back-up mysql database |
| CN110209534B (en) * | 2019-06-14 | 2022-09-16 | 四川长虹电器股份有限公司 | System and method for automatically backing up mysql database |
| CN110245148A (en) * | 2019-06-25 | 2019-09-17 | 河南中原消费金融股份有限公司 | A kind of date storage method, device, system and medium |
| CN111078961A (en) * | 2019-12-24 | 2020-04-28 | 用友网络科技股份有限公司 | Multi-data source query driving system, method, device and storage medium |
| CN111078961B (en) * | 2019-12-24 | 2023-09-15 | 用友网络科技股份有限公司 | Multi-data source query driving system, method, device and storage medium |
| CN111209292A (en) * | 2019-12-31 | 2020-05-29 | 成都库珀区块链科技有限公司 | Bin data management method, device and system |
| CN111209292B (en) * | 2019-12-31 | 2023-08-11 | 成都库珀创新科技有限公司 | Bin data management method, device and system |
| CN111291056A (en) * | 2020-02-25 | 2020-06-16 | 帆软软件有限公司 | Method for associating data table bottom layers of BI tool |
| CN111291056B (en) * | 2020-02-25 | 2020-12-01 | 帆软软件有限公司 | Method for associating data table bottom layers of BI tool |
| CN113535768A (en) * | 2020-04-15 | 2021-10-22 | 北京京东乾石科技有限公司 | Production monitoring method and device |
| CN111460241A (en) * | 2020-04-26 | 2020-07-28 | 甬矽电子(宁波)股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN111460241B (en) * | 2020-04-26 | 2024-01-23 | 甬矽电子(宁波)股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN112000696B (en) * | 2020-08-06 | 2023-01-06 | 苏州浪潮智能科技有限公司 | Framework for mirror image list query of multi-framework cloud platform mirror image warehouse |
| CN112000696A (en) * | 2020-08-06 | 2020-11-27 | 苏州浪潮智能科技有限公司 | Framework for mirror image list query of multi-framework cloud platform mirror image warehouse |
| CN112487086A (en) * | 2020-11-17 | 2021-03-12 | 中国人寿保险股份有限公司 | Data synchronization method and device, electronic equipment and storage medium |
| CN112487086B (en) * | 2020-11-17 | 2024-04-16 | 中国人寿保险股份有限公司 | Data synchronization method and device, electronic equipment and storage medium |
| CN112612778A (en) * | 2020-12-25 | 2021-04-06 | 上海航空工业(集团) 有限公司 | Enterprise data architecture method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109582695A (en) | Data general-purpose querying method and inquiry system under a kind of micro services framework | |
| US10579634B2 (en) | Apparatus and method for operating a distributed database with foreign tables | |
| CN108038222B (en) | System of entity-attribute framework for information system modeling and data access | |
| US8805864B2 (en) | Multi-client generic persistence for extension fields | |
| US9280568B2 (en) | Zero downtime schema evolution | |
| CN104899295B (en) | A kind of heterogeneous data source data relation analysis method | |
| CA2977042A1 (en) | System and method for generating an effective test data set for testing big data applications | |
| US11645296B1 (en) | Techniques for decoupling access to infrastructure models | |
| CN103699638A (en) | Method for realizing cross-database type synchronous data based on configuration parameters | |
| CN109739867A (en) | A kind of industry metadata management method and system | |
| CN101546259A (en) | Object-relation mapping system supporting model extension in runtime, and method thereof | |
| George | Nosql–not only sql | |
| CA2997071A1 (en) | Metadata-driven data management platform | |
| US9836503B2 (en) | Integrating linked data with relational data | |
| CN102982171A (en) | Database synchronization method | |
| US9922085B2 (en) | Template based generation of cross views | |
| US9483476B2 (en) | System decommissioning through reverse archiving of data | |
| CN106165369B (en) | System and method for supporting data type conversion in heterogeneous computing environment | |
| Singh | NoSQL: A new horizon in big data | |
| Senapati et al. | A survey on data warehouse architecture | |
| US11616744B2 (en) | Context-dependent message extraction and transformation | |
| EP4231170A1 (en) | On-demand virtual storage access method analytics | |
| EP4235517A1 (en) | Wrapper, computer program product, system and computer implemented method for data transformation | |
| US20180260423A1 (en) | Versioned data updating system | |
| Gidado et al. | Maximizing Bigdata Retrieval: Block as a Value for NoSQL over SQL |
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: 20190405 |
|
| RJ01 | Rejection of invention patent application after publication |