CN110245150A - Data processing, querying method, device, equipment and data processing system - Google Patents
Data processing, querying method, device, equipment and data processing system Download PDFInfo
- Publication number
- CN110245150A CN110245150A CN201910462020.3A CN201910462020A CN110245150A CN 110245150 A CN110245150 A CN 110245150A CN 201910462020 A CN201910462020 A CN 201910462020A CN 110245150 A CN110245150 A CN 110245150A
- Authority
- CN
- China
- Prior art keywords
- data
- business
- supply
- mark
- tables
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
This specification embodiment discloses a kind of data processing, querying method, device, equipment and data processing system, business by extracting business demand side's mark from least one first supply side tables of data and comprising business demand side mark supplies data, the major key of the first supply side tables of data includes service provider mark, data are supplied using the business, major key is identified as with the business demand side and creates the second supply side tables of data, stores the second supply side tables of data in the database.
Description
Technical field
This specification embodiment is related to computer field more particularly to a kind of data processing, querying method, device, equipment
And data processing system.
Background technique
In business contact, business demand side attracts service provider to need for business by issuing service demand information
Information is asked to provide corresponding business supply.In general, business demand information can attract different business supplier to provide business supply
Service, and business demand side can choose suitable service provider.
In a kind of application scenarios, the business demand information of business demand side's publication can be in a manner of business demand data
It stores in tables of data and database, so that service provider obtains business demand information by inquiry, and needs for the business
Information is asked to issue corresponding service provider case, service provider case can store tables of data in such a way that business supplies data
In database.So, business demand side can obtain each service provider by inquiry and believe for the business demand of its publication
The service provider case provided is provided, suitable service provider case and service provider are therefrom selected.
Summary of the invention
In view of this, this specification embodiment provide it is a kind of promoted the data processing of efficiency data query, querying method,
Device, equipment and data processing system.
This specification embodiment provides a kind of data processing method, comprising:
Business demand side's mark is extracted from least one first supply side tables of data and is marked comprising the business demand side
The business of knowledge supplies data, and the major key of the first supply side tables of data includes service provider mark；
Data are supplied using the business, major key is identified as with the business demand side and creates the second supply side tables of data；
The second supply side tables of data is stored in the database.
This specification embodiment also provides a kind of data query method, comprising:
Inquiry request is received, is identified in the inquiry request comprising business demand side；
It is identified using the business demand side, inquires second that major key is identified as with the business demand side in the database
Supply side tables of data, the second supply side tables of data are the extraction business demand sides from least one first supply side tables of data
Mark and the business identified comprising the business demand side supply data, supply data using the business, are needed with the business
The side of asking is identified as what major key created；
The business supply comprising business demand side mark is extracted from the second supply side tables of data inquired
Data；
It sends the business comprising business demand side mark and supplies data.
This specification embodiment also provides a kind of data processing method, comprising:
Purchaser's mark and the supply comprising purchaser mark are extracted from least one supplier's quote data table
Bidding data, the major key of supplier's quote data table include supplier's mark；
Using supplier's quote data, major key creation purchaser's quote data table is identified as with the purchaser；
Purchaser's quote data table is stored in the database.
This specification embodiment also provides a kind of data processing system, comprising:
Database stores the first supply side tables of data, and the major key of the first supply side tables of data includes service provider
Mark；
Data Synchronization Component, extracting business from the first supply side tables of data in database described at least one needs
The side's of asking mark and the business identified comprising the business demand side supply data, data are supplied using the business, with the industry
Business party in request is identified as major key and creates the second supply side tables of data, stores the second supply side data in the database
Table.
This specification embodiment also provides a kind of data processing equipment, comprising:
Extraction module extracts business demand side's mark from least one first supply side tables of data and includes the business
The business of party in request's mark supplies data, and the major key of the first supply side tables of data includes service provider mark；
Tables of data creation module supplies data using the business, is identified as major key creation the with the business demand side
Two supply side tables of data；
Memory module stores the second supply side tables of data in the database.
This specification embodiment also provides a kind of data query device, comprising:
Receiving module receives inquiry request, identifies in the inquiry request comprising business demand side；
Enquiry module is identified using the business demand side, inquires be identified as with the business demand side in the database
Second supply side tables of data of major key, the second supply side tables of data are extracted from least one first supply side tables of data
Business demand side's mark and the business identified comprising the business demand side supply data, supply data using the business, with
The business demand side is identified as what major key created；
Extraction module is extracted from the second supply side tables of data inquired comprising business demand side mark
Business supplies data；
Sending module sends the business comprising business demand side mark and supplies data.
This specification embodiment also provides a kind of data processing equipment, comprising:
Extraction module extracts purchaser's mark from least one supplier's quote data table and includes the buying trade mark
Supplier's quote data of knowledge, the major key of supplier's quote data table include supplier's mark；
Tables of data creation module is identified as major key creation buying using supplier's quote data with the purchaser
Bidding tables of data；
Memory module stores purchaser's quote data table in the database.
This specification embodiment also provides a kind of electronic equipment, comprising:
At least one processor；
At least one processor；
Wherein, it is stored with program in at least one processor, and is configured to be held by least one described processor
Row following steps:
Business demand side's mark is extracted from least one first supply side tables of data and is marked comprising the business demand side
The business of knowledge supplies data, and the major key of the first supply side tables of data includes service provider mark；
Data are supplied using the business, major key is identified as with the business demand side and creates the second supply side tables of data；
The second supply side tables of data is stored in the database.
This specification embodiment also provides a kind of electronic equipment, comprising:
At least one processor；
Memory, memory are stored with program, and are configured at least execute following steps by a processor:
At least one processor；
At least one processor；
Wherein, it is stored with program in at least one processor, and is configured to be held by least one described processor
Row following steps:
Inquiry request is received, is identified in the inquiry request comprising business demand side；
It is identified using the business demand side, inquires second that major key is identified as with the business demand side in the database
Supply side tables of data, the second supply side tables of data are the extraction business demand sides from least one first supply side tables of data
Mark and the business identified comprising the business demand side supply data, supply data using the business, are needed with the business
The side of asking is identified as what major key created；
The business supply comprising business demand side mark is extracted from the second supply side tables of data inquired
Data.
This specification embodiment also provides a kind of electronic equipment, comprising:
At least one processor；
At least one processor；
Wherein, it is stored with program in at least one processor, and is configured to be held by least one described processor
Row following steps:
Purchaser's mark and the supply comprising purchaser mark are extracted from least one supplier's quote data table
Bidding data, the major key of supplier's quote data table include supplier's mark；
Using supplier's quote data, major key creation purchaser's quote data table is identified as with the purchaser；
Purchaser's quote data table is stored in the database.
This specification embodiment use at least one above-mentioned technical solution can reach it is following the utility model has the advantages that
By extracting business demand side's mark from least one first supply side tables of data and including the business demand
The business supply data just identified, the major key of the first supply side tables of data includes service provider mark, utilizes the industry
Business supply data, are identified as major key with the business demand side and create the second supply side tables of data, in the database described in storage
Second supply side tables of data.Since the major key of the second supply side tables of data of creation includes business demand side's mark, such business
Party in request can use business demand side and identify quick search to the second supply side tables of data, and the business that obtains supplies data, and nothing
All databases and tables of data need to be traversed, and then improves search efficiency, user experience is good.
Detailed description of the invention
Attached drawing described herein is used to provide to further understand this specification embodiment, constitutes this specification and implements
A part of example, the illustrative embodiments and their description of this specification are not constituted for explaining this specification embodiment to this
The improper restriction of specification embodiment.In the accompanying drawings:
Fig. 1 is a kind of structural schematic diagram for data processing system that this specification embodiment provides；
Fig. 2 is a kind of structural schematic diagram for data processing system that this specification embodiment provides；
Fig. 3 is a kind of flow chart for data processing method that this specification embodiment provides；
Fig. 4 is a kind of flow chart for data query method that this specification embodiment provides；
Fig. 5 is a kind of flow chart for data processing method that this specification embodiment provides；
Fig. 6 is a kind of structural schematic diagram for data processing equipment that this specification embodiment provides；
Fig. 7 is a kind of structural schematic diagram for data query device that this specification embodiment provides；
Fig. 8 is a kind of structural schematic diagram for data processing equipment that this specification embodiment provides.
Specific embodiment
Inventor carries out analysis to the prior art and finds, each service provider proposes not for same business demand information
Same service provider case, these service provider cases are dispersed in different supply side tables of data or in database.Work as business
When party in request needs inquiry business to supply data, business demand side's mark is provided, system needs to be traversed for each database or tables of data,
It is omitted to avoid data occur, obtains the different business comprising business demand side mark and supply data.
It being found by carrying out analysis to supply side tables of data, the major key of supply side tables of data includes service provider mark,
Each information for including in business supply data is field value, and business demand side is identified as one of field value, business demand side
Mark is unable to unique definition supply side tables of data.As a result of which system is using the mark inquiry of business demand side, it may be all over
Tables of data or database are gone through, the complete business supply data for the business demand side could be obtained.
In the prior art, service provider is that itself inquiry is convenient, usually can be only separately provided with service provider mark
Know the supply side tables of data for major key.
This specification embodiment proposes a kind of data processing, querying method, device, equipment and data processing system, passes through
Business demand side's mark and the business comprising business demand side mark are extracted from least one first supply side tables of data
Data are supplied, the major key of the first supply side tables of data includes service provider mark, data are supplied using the business, with
The business demand side is identified as major key and creates the second supply side tables of data, stores the second supply side data in the database
Table.Since the major key of the second supply side tables of data of creation includes business demand side's mark, such business demand side be can use
Business demand side identifies quick search to the second supply side tables of data, obtains business and supplies data, without traversing all data
Library and tables of data, and then search efficiency is improved, user experience is good.
To keep the purposes, technical schemes and advantages of this specification clearer, it is embodied below in conjunction with this specification
This specification technical solution is clearly and completely described in example and corresponding attached drawing.Obviously, described embodiment is only this
Specification a part of the embodiment, instead of all the embodiments.The embodiment of base in this manual, ordinary skill people
Member's every other embodiment obtained without making creative work, shall fall in the protection scope of this application.
Fig. 1 is a kind of structural schematic diagram for data processing system that this specification embodiment provides.
This specification embodiment record the data processing system may include:
Database 101, stores the first supply side tables of data, and the major key of the first supply side tables of data includes business supply
Side's mark；
Data Synchronization Component 102 is extracted from the first supply side tables of data in database 101 described at least one
Business demand side's mark and the business identified comprising the business demand side supply data, supply data using the business, with
The business demand side is identified as major key and creates the second supply side tables of data, stores second supply side in the database
Tables of data.
The effect of data Synchronization Component 102 is, by using service provider as the first supply side data table transmition of dimension at
Using business demand side as the second supply side tables of data of dimension, the demand that major key is identified as with business demand side is substantially realized
It is synchronous between side data table and business supply side tables of data.To since the major key in the second supply side tables of data includes industry
Business party in request mark, business demand side are identified as the unique index of the second supply side tables of data, and business demand side can use oneself
The business demand side of side identifies quick search and supplies data to relevant all business, without traversing all databases and data
Table effectively improves search efficiency.
Fig. 2 is a kind of structural schematic diagram for data-storage system that this specification embodiment provides.Using supplier as industry
Be engaged in supplier, and purchaser is as the principle for being illustrated the system for business demand side.
Purchaser's platform 201 obtains purchaser and passes through inquiry sheet, invitation, the mode issuing service recruited list, bid single
Demand is that major key (or dimension) creation purchaser sources tables of data according to purchaser ID, and it is demand that purchaser, which sources tables of data,
A kind of instantiation of side data table realizes that a point library divides table to store.The database 1 ... of 201 side of purchaser's platform is shown in Fig. 2
Library n, is not limited thereto.
Vendor platforms 202 obtain supplier and pass through price list, bid list for the business demand of purchaser's publication or answer
It raises the business quotation of single-shot cloth, is created for answering Bidding tables of data according to supplier ID, supplier's quote data table is supply side
A kind of instantiation of tables of data realizes that a point library divides table to store.Database 1 ... the library of 201 side of purchaser's platform is shown in Fig. 2
N is not limited thereto.
Data Synchronization Component 203 obtains supplier's quote data table, therefrom extracts purchaser ID and includes purchaser ID's
Quote data is created using purchaser ID as purchaser's quote data table of major key, is realized using purchaser as the quotation number at visual angle
According to deposit purchaser's quote data table, the quote data storage at purchaser and supplier visual angle is completed in this way.
In this case, business demand information and quotation information carry out runing visual angle by data Synchronization Component 203
Synchronous, so that full dose data are synchronized to business demand data and quote data, operation can be by operation platform to business in this way
Demand data and quote data carry out operation management.
Fig. 3 is a kind of flow chart for date storage method that this specification embodiment provides.
S301: business demand side's mark is extracted from least one first supply side tables of data and includes the business demand
The business supply data just identified, the major key of the first supply side tables of data include service provider mark.
In this specification embodiment, the first supply side tables of data is the supply side data using service provider as dimension
Business supply data are described in table.
This specification embodiment record business can refer to service or commodity, for service and the respective scope of commodity,
Herein and it is not especially limited.Business demand side is the side for seeking business service, such as purchaser.Service provider is to provide
One side of business service, such as supplier.
First supply side tables of data is to be proposed according to service provider to the business demand information that business demand side issues
Service provider case generate, business supply data may include: service provider mark, business demand side mark, business
Demand information, business information provision, wherein business information provision may include the information such as quotation, service parameter, address, herein not
Make specific limit.
In the first supply side tables of data, business demand side's mark, business demand information, business information provision etc. are word
Section, the field value of these fields constitute business supply data.
In this specification embodiment, business demand side's mark and packet are extracted from least one first supply side tables of data
The business of the mark containing the business demand side supplies data, can be, the first supply side tables of data is obtained from database, therefrom
The business of inquiry business party in request mark and business demand side's mark supplies data.
It is also possible that extracting business demand side's mark from least one first supply side tables of data and including the industry
Before the business supply data for party in request's mark of being engaged in, can also include:
Business demand side's mark, the major key of the Demand-side tables of data are extracted from least one Demand-side tables of data
It is identified including business demand side；
It is identified using the business demand side extracted, packet is inquired from least one described first supply side tables of data
The business of the mark containing the business demand side supplies data.
In this case, business demand side identify unique identification Demand-side tables of data, in this way can quickly and efficiently from
All business demand side's marks are inquired in Demand-side tables of data, thus when reducing the data processing of this specification embodiment record
Between.
In this specification embodiment, business demand side's mark and packet are extracted from least one first supply side tables of data
The business of the mark containing the business demand side supplies data, may include:
Data are supplied to the business at least one described first supply side tables of data using business demand side mark
It is grouped, at least one business supply data comprising same business demand side's mark are grouped into the same group, so that same
Group business supply data can be located in the second supply side tables of data created.
S303: supplying data using the business, is identified as major key with the business demand side and creates the second supply side number
According to table.
The first supply side data table transmition at visual angle is identified as at business demand side with service provider originally as a result,
It is identified as the second supply side tables of data at visual angle.
In this specification embodiment, not simply by business demand side's identification field in the first supply side tables of data
It is replaced mutually with major key, but can include the business supply data storage of same business demand side mark to one by extraction
In tables of data, in this way, business demand side is when inquiring all relative business supply data, it is only necessary to traverse a data
Table, without traversing multiple tables of data, so as to improve search efficiency.
Therefore, it can use business demand side's mark to the business at least one described first supply side tables of data
Supply data are grouped, at least one business supply data comprising same business demand side's mark are grouped into the same group,
So that same group of business supply data are located in the second supply side tables of data created.
In this specification embodiment, data are supplied using the business, major key wound is identified as with the business demand side
The second supply side tables of data is built, may include:
Inquiry is identified as the Demand-side tables of data of major key with the business demand side；
Business supply data including business demand side mark are inserted into the Demand-side tables of data, are obtained described
Second supply side tables of data.
This embodiment is updated to the Demand-side tables of data of storage.
In another embodiment of this specification, it is also possible that the second supply side tables of data that creation is new, newly created in this way
It may include the business supply data of recent different time points in second supply side tables of data.
S305: the second supply side tables of data is stored in the database.
Since the major key of the second supply side tables of data of creation includes business demand side's mark, such business demand side is permissible
Quick search is identified to the second supply side tables of data using business demand side, is obtained business and is supplied data, it is all without traversing
Database and tables of data, and then search efficiency is improved, user experience is good.
In this specification embodiment, the second supply side tables of data is stored in the database, may include:
The second supply side tables of data is stored in Demand-side database.
Fig. 4 is a kind of flow chart for data query method that this specification embodiment provides.
This method may include:
S401: inquiry request is received, is identified in the inquiry request comprising business demand side.
S403: it is identified using the business demand side, inquires in the database and major key is identified as with the business demand side
The second supply side tables of data, the second supply side tables of data is to extract business from least one first supply side tables of data
Party in request's mark and the business identified comprising the business demand side supply data, data are supplied using the business, with described
Business demand side is identified as what major key created.
If the second supply side tables of data is stored in Demand-side database, Demand-side database can be quickly navigated to,
Improve search efficiency.Also, due in the second supply side tables of data, business demand side is identified as unique index, therefore can be
The corresponding business supply data of specific business demand side's mark are disposably inquired in one table.
S405: the business comprising business demand side mark is extracted from the second supply side tables of data inquired
Data are supplied, without traversing all databases and tables of data, and then improve search efficiency, user experience is good.
S407: it sends the business comprising business demand side mark and supplies data, allow users to the confession of access business
Answer data.
Fig. 5 is a kind of flow diagram for data processing method that this specification embodiment provides.
In purchaser side, following steps are executed.
S501: purchaser's issuing service sources list, and business sources a kind of form that singly can be business demand information, herein
It is not construed as limiting.
S503: it obtains current issuing service and sources single purchaser ID.
S505: a point library divides meter to calculate, and specifically dividing table component to source single calculate according to the business of publication using point library will deposit
The target database and tables of data of storage；
S507: the business of publication is sourced into single progress structured query language SQL assembling, storage sources data to purchaser
Table.
In supplier side, following steps are executed.
S502: supplier obtains business and sources list, and sources single issuing service price list according to business.
S504: acquisition business sources the supplier ID of single associated purchaser ID and issuing service price list.
S506: a point library divides meter to calculate, and divides table component that will be stored according to the calculating of the business price list of publication using point library
Target database and tables of data.
S508: purchaser ID, supplier ID and business price list are subjected to SQL assembling, formed using supplier ID as major key
Supplier's quote data table, and store arrive target database.
In data Synchronization Component side, following steps are executed.
S510: supplier's quotation form trigger data is synchronous.
S512: purchaser's mark is extracted from least one supplier's quote data table and comprising purchaser mark
Supplier's quote data, the major key of supplier's quote data table include supplier's mark.
S514: utilizing supplier's quote data, is identified as major key creation purchaser's quote data with the purchaser
Table.
S516: purchaser's quote data table is stored in the database.
In this case, the purchaser that purchaser can use oneself identifies inquiry purchaser's database, is purchased
Bidding tables of data therefrom obtains the quotation information of supplier.
Fig. 6 is a kind of structural schematic diagram for data processing equipment that this specification embodiment provides.The apparatus may include:
Extraction module 601 extracts business demand side's mark and comprising described from least one first supply side tables of data
The business of business demand side's mark supplies data, and the major key of the first supply side tables of data includes service provider mark；
Tables of data creation module 602 supplies data using the business, is identified as major key creation with the business demand side
Second supply side tables of data；
Memory module 603 stores the second supply side tables of data in the database.
Optionally, described to extract business demand side's mark from least one first supply side tables of data and include the industry
The business for party in request's mark of being engaged in supplies data, comprising:
Data are supplied to the business at least one described first supply side tables of data using business demand side mark
It is grouped, at least one business supply data comprising same business demand side's mark are grouped into the same group, so that same
Group business supply data are located in the second supply side tables of data created.
Optionally, data are supplied using the business, major key is identified as with the business demand side and creates the second supply side
Tables of data, comprising:
Inquiry is identified as the Demand-side tables of data of major key with the business demand side；
Business supply data including business demand side mark are inserted into the Demand-side tables of data, are obtained described
Second supply side tables of data.
The data processing equipment recorded using this specification embodiment, will be using service provider as the first supply side of dimension
Data table transmition is at using business demand side as the second supply side tables of data of dimension.Due to the second supply side tables of data of creation
Major key includes business demand side's mark, and such business demand side can use business demand side and identify quick search to the second supply
Side data table obtains business and supplies data, without traversing all databases and tables of data, and then improves search efficiency, user
It experiences.
Based on the same inventive concept, this specification embodiment additionally provides a kind of electronic equipment, comprising:
At least one processor；
At least one processor；
Wherein, it is stored with program in at least one processor, and is configured to be held by least one described processor
Row following steps:
Business demand side's mark is extracted from least one first supply side tables of data and is marked comprising the business demand side
The business of knowledge supplies data, and the major key of the first supply side tables of data includes service provider mark；
Data are supplied using the business, major key is identified as with the business demand side and creates the second supply side tables of data；
The second supply side tables of data is stored in the database.
Based on the same inventive concept, a kind of computer readable storage medium is additionally provided in this specification embodiment, including
The program being used in combination with electronic equipment, described program can be executed by processor to complete following steps:
Business demand side's mark is extracted from least one first supply side tables of data and is marked comprising the business demand side
The business of knowledge supplies data, and the major key of the first supply side tables of data includes service provider mark；
Data are supplied using the business, major key is identified as with the business demand side and creates the second supply side tables of data；
The second supply side tables of data is stored in the database.
Fig. 7 is a kind of structural schematic diagram for data query device that this specification embodiment provides.The apparatus may include:
Receiving module 701 receives inquiry request, identifies in the inquiry request comprising business demand side；
Enquiry module 702 is identified using the business demand side, is inquired in the database with business demand side mark
For the second supply side tables of data of major key, the second supply side tables of data is mentioned from least one first supply side tables of data
The business for taking business demand side to identify and identify comprising the business demand side supplies data, supplies data using the business,
It is identified as what major key created with the business demand side；
Extraction module 703 is extracted from the second supply side tables of data inquired and is marked comprising the business demand side
The business of knowledge supplies data；
Sending module 704 sends the business comprising business demand side mark and supplies data.
The data query device recorded using this specification embodiment, due to the major key of the second supply side tables of data of creation
It is identified including business demand side, such business demand side can use business demand side and identify quick search to the second supply side number
It according to table, obtains business and supplies data, without traversing all databases and tables of data, and then improve search efficiency, user experience
It is good.
Based on the same inventive concept, this specification embodiment additionally provides a kind of electronic equipment, comprising:
At least one processor；
At least one processor；
Wherein, it is stored with program in at least one processor, and is configured to be held by least one described processor
Row following steps:
Inquiry request is received, is identified in the inquiry request comprising business demand side；
It is identified using the business demand side, inquires second that major key is identified as with the business demand side in the database
Supply side tables of data, the second supply side tables of data are the extraction business demand sides from least one first supply side tables of data
Mark and the business identified comprising the business demand side supply data, supply data using the business, are needed with the business
The side of asking is identified as what major key created；
The business supply comprising business demand side mark is extracted from the second supply side tables of data inquired
Data；
It sends the business comprising business demand side mark and supplies data.
Based on the same inventive concept, a kind of computer readable storage medium is additionally provided in this specification embodiment, including
The program being used in combination with electronic equipment, described program can be executed by processor to complete following steps:
Inquiry request is received, is identified in the inquiry request comprising business demand side；
It is identified using the business demand side, inquires second that major key is identified as with the business demand side in the database
Supply side tables of data, the second supply side tables of data are the extraction business demand sides from least one first supply side tables of data
Mark and the business identified comprising the business demand side supply data, supply data using the business, are needed with the business
The side of asking is identified as what major key created；
The business supply comprising business demand side mark is extracted from the second supply side tables of data inquired
Data；
It sends the business comprising business demand side mark and supplies data.
Fig. 8 is a kind of structural schematic diagram for data processing equipment that this specification embodiment provides.The apparatus may include:
Extraction module 801 extracts purchaser's mark from least one supplier's quote data table and includes the buying
Supplier's quote data that trade mark is known, the major key of supplier's quote data table include supplier's mark；
Tables of data creation module 802 is identified as major key creation with the purchaser and adopts using supplier's quote data
Purchase Bidding tables of data；
Memory module 803 stores purchaser's quote data table in the database.
Based on the same inventive concept, this specification embodiment additionally provides a kind of electronic equipment, comprising:
At least one processor；
At least one processor；
Wherein, it is stored with program in at least one processor, and is configured to be held by least one described processor
Row following steps:
Purchaser's mark and the supply comprising purchaser mark are extracted from least one supplier's quote data table
Bidding data, the major key of supplier's quote data table include supplier's mark；
Using supplier's quote data, major key creation purchaser's quote data table is identified as with the purchaser；
Purchaser's quote data table is stored in the database.
Based on the same inventive concept, a kind of computer readable storage medium is additionally provided in this specification embodiment, including
The program being used in combination with electronic equipment, described program can be executed by processor to complete following steps:
Purchaser's mark and the supply comprising purchaser mark are extracted from least one supplier's quote data table
Bidding data, the major key of supplier's quote data table include supplier's mark；
Using supplier's quote data, major key creation purchaser's quote data table is identified as with the purchaser；
Purchaser's quote data table is stored in the database.
In the 1990s, the improvement of a technology can be distinguished clearly be on hardware improvement (for example,
Improvement to circuit structures such as diode, transistor, switches) or software on improvement (improvement for method flow).So
And with the development of technology, the improvement of current many method flows can be considered as directly improving for hardware circuit.
Designer nearly all obtains corresponding hardware circuit by the way that improved method flow to be programmed into hardware circuit.Cause
This, it cannot be said that the improvement of a method flow cannot be realized with hardware entities module.For example, programmable logic device
(Programmable Logic Device, PLD) (such as field programmable gate array (Field Programmable Gate
Array, FPGA)) it is exactly such a integrated circuit, logic function determines device programming by user.By designer
Voluntarily programming comes a digital display circuit " integrated " on a piece of PLD, designs and makes without asking chip maker
Dedicated IC chip.Moreover, nowadays, substitution manually makes IC chip, this programming is also used instead mostly " is patrolled
Volume compiler (logic compiler) " software realizes that software compiler used is similar when it writes with program development,
And the source code before compiling also write by handy specific programming language, this is referred to as hardware description language
(Hardware Description Language, HDL), and HDL is also not only a kind of, but there are many kind, such as ABEL
(Advanced Boolean Expression Language)、AHDL(Altera Hardware Description
Language)、Confluence、CUPL(Cornell University Programming Language)、HDCal、JHDL
(Java Hardware Description Language)、Lava、Lola、MyHDL、PALASM、RHDL(Ruby
Hardware Description Language) etc., VHDL (Very-High-Speed is most generally used at present
Integrated Circuit Hardware Description Language) and Verilog.Those skilled in the art also answer
This understands, it is only necessary to method flow slightly programming in logic and is programmed into integrated circuit with above-mentioned several hardware description languages,
The hardware circuit for realizing the logical method process can be readily available.
Controller can be implemented in any suitable manner, for example, controller can take such as microprocessor or processing
The computer for the computer readable program code (such as software or firmware) that device and storage can be executed by (micro-) processor can
Read medium, logic gate, switch, specific integrated circuit (Application Specific Integrated Circuit,
ASIC), the form of programmable logic controller (PLC) and insertion microcontroller, the example of controller includes but is not limited to following microcontroller
Device: ARC 625D, Atmel AT91SAM, Microchip PIC18F26K20 and Silicone Labs C8051F320 are deposited
Memory controller is also implemented as a part of the control logic of memory.It is also known in the art that in addition to
Pure computer readable program code mode is realized other than controller, can be made completely by the way that method and step is carried out programming in logic
Controller is obtained to come in fact in the form of logic gate, switch, specific integrated circuit, programmable logic controller (PLC) and insertion microcontroller etc.
Existing identical function.Therefore this controller is considered a kind of hardware component, and to including for realizing various in it
The device of function can also be considered as the structure in hardware component.Or even, it can will be regarded for realizing the device of various functions
For either the software module of implementation method can be the structure in hardware component again.
System, device, module or the unit that above-described embodiment illustrates can specifically realize by computer chip or entity,
Or it is realized by the product with certain function.It is a kind of typically to realize that equipment is computer.Specifically, computer for example may be used
Think personal computer, laptop computer, cellular phone, camera phone, smart phone, personal digital assistant, media play
It is any in device, navigation equipment, electronic mail equipment, game console, tablet computer, wearable device or these equipment
The combination of equipment.
For convenience of description, it is divided into various units when description apparatus above with function to describe respectively.Certainly, implementing this
The function of each unit can be realized in the same or multiple software and or hardware when application.
It should be understood by those skilled in the art that, the embodiment of the present invention can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the present invention
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the present invention, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The present invention be referring to according to the method for the embodiment of the present invention, the process of equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
In a typical configuration, calculating equipment includes one or more processors (CPU), input/output interface, net
Network interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/or
The forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM).Memory is computer-readable medium
Example.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM),
Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices
Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates
Machine readable medium does not include temporary computer readable media (transitory media), such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability
It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap
Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including described want
There is also other identical elements in the process, method of element, commodity or equipment.
The application can describe in the general context of computer-executable instructions executed by a computer, such as program
Module.Generally, program module includes routines performing specific tasks or implementing specific abstract data types, programs, objects, group
Part, data structure etc..The application can also be practiced in a distributed computing environment, in these distributed computing environments, by
Task is executed by the connected remote processing devices of communication network.In a distributed computing environment, program module can be with
In the local and remote computer storage media including storage equipment.
All the embodiments in this specification are described in a progressive manner, same and similar portion between each embodiment
Dividing may refer to each other, and each embodiment focuses on the differences from other embodiments.Especially for system reality
For applying example, since it is substantially similar to the method embodiment, so being described relatively simple, related place is referring to embodiment of the method
Part explanation.
The above description is only an example of the present application, is not intended to limit this application.For those skilled in the art
For, various changes and changes are possible in this application.All any modifications made within the spirit and principles of the present application are equal
Replacement, improvement etc., should be included within the scope of the claims of this application.
Claims (16)
1. a kind of data processing method, comprising:
Business demand side's mark is extracted from least one first supply side tables of data and comprising business demand side mark
Business supplies data, and the major key of the first supply side tables of data includes service provider mark；
Data are supplied using the business, major key is identified as with the business demand side and creates the second supply side tables of data；
The second supply side tables of data is stored in the database.
2. the method as described in claim 1 stores the second supply side tables of data in the database, comprising:
The second supply side tables of data is stored in Demand-side database.
3. the method as described in claim 1, extracted from least one first supply side tables of data business demand side's mark and
Business comprising business demand side mark supplies data, comprising:
The business supply data at least one described first supply side tables of data are carried out using business demand side mark
Grouping, at least one business supply data comprising same business demand side's mark are grouped into the same group, so that same group of industry
Business supply data are located in the second supply side tables of data created.
4. the method as described in claim 1 is identified extracting business demand side from least one first supply side tables of data
It is supplied before data with the business identified comprising the business demand side, further includes:
Business demand side's mark is extracted from least one Demand-side tables of data, the major key of the Demand-side tables of data includes
Business demand side's mark；
It is identified using the business demand side extracted, inquiry includes institute from least one described first supply side tables of data
State the business supply data of business demand side's mark.
5. the method as described in claim 1 supplies data using the business, major key wound is identified as with the business demand side
Build the second supply side tables of data, comprising:
Inquiry is identified as the Demand-side tables of data of major key with the business demand side；
Business supply data including business demand side mark are inserted into the Demand-side tables of data, obtain described second
Supply side tables of data.
6. a kind of data query method, comprising:
Inquiry request is received, is identified in the inquiry request comprising business demand side；
It is identified using the business demand side, inquires the second supply for being identified as major key with the business demand side in the database
Side data table, the second supply side tables of data are that business demand side's mark is extracted from least one first supply side tables of data
Data are supplied with the business identified comprising the business demand side, data are supplied using the business, with the business demand side
It is identified as what major key created；
The business comprising business demand side mark is extracted from the second supply side tables of data inquired supplies data；
It sends the business comprising business demand side mark and supplies data.
7. a kind of data processing method, comprising:
Purchaser's mark and the supply Business comprising purchaser mark are extracted from least one supplier's quote data table
Valence mumber evidence, the major key of supplier's quote data table include supplier's mark；
Using supplier's quote data, major key creation purchaser's quote data table is identified as with the purchaser；
Purchaser's quote data table is stored in the database.
8. a kind of data processing system, comprising:
Database, stores the first supply side tables of data, and the major key of the first supply side tables of data includes service provider mark；
Data Synchronization Component extracts business demand side from the first supply side tables of data in database described at least one
Mark and the business identified comprising the business demand side supply data, supply data using the business, are needed with the business
The side of asking is identified as major key and creates the second supply side tables of data, stores the second supply side tables of data in the database.
9. a kind of data processing equipment, comprising:
Extraction module extracts business demand side's mark from least one first supply side tables of data and includes the business demand
The business supply data just identified, the major key of the first supply side tables of data include service provider mark；
Tables of data creation module supplies data using the business, is identified as major key creation second with the business demand side and supplies
Answer side data table；
Memory module stores the second supply side tables of data in the database.
10. device as claimed in claim 9, described to extract business demand side's mark from least one first supply side tables of data
Know and the business comprising business demand side mark supply data, comprising:
The business supply data at least one described first supply side tables of data are carried out using business demand side mark
Grouping, at least one business supply data comprising same business demand side's mark are grouped into the same group, so that same group of industry
Business supply data are located in the second supply side tables of data created.
11. device as claimed in claim 9 supplies data using the business, is identified as major key with the business demand side
Create the second supply side tables of data, comprising:
Inquiry is identified as the Demand-side tables of data of major key with the business demand side；
Business supply data including business demand side mark are inserted into the Demand-side tables of data, obtain described second
Supply side tables of data.
12. a kind of data query device, comprising:
Receiving module receives inquiry request, identifies in the inquiry request comprising business demand side；
Enquiry module is identified using the business demand side, inquires be identified as major key with the business demand side in the database
The second supply side tables of data, the second supply side tables of data is to extract business from least one first supply side tables of data
Party in request's mark and the business identified comprising the business demand side supply data, data are supplied using the business, with described
Business demand side is identified as what major key created；
Extraction module extracts the business comprising business demand side mark from the second supply side tables of data inquired
Supply data；
Sending module sends the business comprising business demand side mark and supplies data.
13. a kind of data processing equipment, comprising:
Extraction module extracts purchaser's mark and comprising purchaser mark from least one supplier's quote data table
Supplier's quote data, the major key of supplier's quote data table include supplier's mark；
Tables of data creation module is identified as major key creation buying Business using supplier's quote data with the purchaser
Valence tables of data；
Memory module stores purchaser's quote data table in the database.
14. a kind of electronic equipment, comprising:
At least one processor；
At least one processor；
Wherein, be stored with program in at least one processor, and be configured to by least one described processor execute with
Lower step:
Business demand side's mark is extracted from least one first supply side tables of data and comprising business demand side mark
Business supplies data, and the major key of the first supply side tables of data includes service provider mark；
Data are supplied using the business, major key is identified as with the business demand side and creates the second supply side tables of data；
The second supply side tables of data is stored in the database.
15. a kind of electronic equipment, comprising:
At least one processor；
At least one processor；
Wherein, be stored with program in at least one processor, and be configured to by least one described processor execute with
Lower step:
Inquiry request is received, is identified in the inquiry request comprising business demand side；
It is identified using the business demand side, inquires the second supply for being identified as major key with the business demand side in the database
Side data table, the second supply side tables of data are that business demand side's mark is extracted from least one first supply side tables of data
Data are supplied with the business identified comprising the business demand side, data are supplied using the business, with the business demand side
It is identified as what major key created；
The business comprising business demand side mark is extracted from the second supply side tables of data inquired supplies data.
16. a kind of electronic equipment, comprising:
At least one processor；
At least one processor；
Wherein, be stored with program in at least one processor, and be configured to by least one described processor execute with
Lower step:
Purchaser's mark and the supply Business comprising purchaser mark are extracted from least one supplier's quote data table
Valence mumber evidence, the major key of supplier's quote data table include supplier's mark；
Using supplier's quote data, major key creation purchaser's quote data table is identified as with the purchaser；
Purchaser's quote data table is stored in the database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910462020.3A CN110245150B (en) | 2019-05-30 | 2019-05-30 | Data processing method, data processing device, data query method, data query device, data processing equipment and data processing system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910462020.3A CN110245150B (en) | 2019-05-30 | 2019-05-30 | Data processing method, data processing device, data query method, data query device, data processing equipment and data processing system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110245150A true CN110245150A (en) | 2019-09-17 |
| CN110245150B CN110245150B (en) | 2023-03-17 |
Family
ID=67885311
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910462020.3A Active CN110245150B (en) | 2019-05-30 | 2019-05-30 | Data processing method, data processing device, data query method, data query device, data processing equipment and data processing system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110245150B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111600926A (en) * | 2020-04-01 | 2020-08-28 | 北京创世云科技有限公司 | Data processing method and device and electronic equipment |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20010049646A1 (en) * | 1999-10-04 | 2001-12-06 | Wilkinson William T. | Method for matching financial supply to demand |
| CN1652128A (en) * | 2004-02-05 | 2005-08-10 | 富士康(昆山)电脑接插件有限公司 | Request for quote system and method |
| CN106203140A (en) * | 2016-07-15 | 2016-12-07 | 上海数据交易中心有限公司 | Data circulation method based on data structure, device and terminal |
| CN107239479A (en) * | 2017-03-28 | 2017-10-10 | 阿里巴巴集团控股有限公司 | A kind of method and device of data storage and inquiry based on block chain |
| CN107609820A (en) * | 2017-09-19 | 2018-01-19 | 深圳市优户科技有限公司 | Method, system, medium and the server that commerce and trade enterprise interacts with supplier wechat |
| CN108304455A (en) * | 2017-12-20 | 2018-07-20 | 阿里巴巴集团控股有限公司 | A kind of method, apparatus and equipment of processing business request |
| CN108399175A (en) * | 2017-02-07 | 2018-08-14 | 阿里巴巴集团控股有限公司 | A kind of storage of data, querying method and its device |
| US20180247258A1 (en) * | 2017-02-28 | 2018-08-30 | Dais Technology, Inc. | Operating system for on-demand economy |
| US20180260841A1 (en) * | 2017-03-10 | 2018-09-13 | Manminder Kandola | Best-result-for-demander development application, supplier/provider market and demand matching and relationship management system |
| CN108959330A (en) * | 2017-05-26 | 2018-12-07 | 阿里巴巴集团控股有限公司 | A kind of processing of database, data query method and apparatus |
| CN109614822A (en) * | 2018-12-12 | 2019-04-12 | 北京时代远行信息科技有限公司 | A kind of Information Resource Access method, apparatus and system based on block chain |
-
2019
- 2019-05-30 CN CN201910462020.3A patent/CN110245150B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20010049646A1 (en) * | 1999-10-04 | 2001-12-06 | Wilkinson William T. | Method for matching financial supply to demand |
| CN1652128A (en) * | 2004-02-05 | 2005-08-10 | 富士康(昆山)电脑接插件有限公司 | Request for quote system and method |
| CN106203140A (en) * | 2016-07-15 | 2016-12-07 | 上海数据交易中心有限公司 | Data circulation method based on data structure, device and terminal |
| CN108399175A (en) * | 2017-02-07 | 2018-08-14 | 阿里巴巴集团控股有限公司 | A kind of storage of data, querying method and its device |
| US20180247258A1 (en) * | 2017-02-28 | 2018-08-30 | Dais Technology, Inc. | Operating system for on-demand economy |
| US20180260841A1 (en) * | 2017-03-10 | 2018-09-13 | Manminder Kandola | Best-result-for-demander development application, supplier/provider market and demand matching and relationship management system |
| CN107239479A (en) * | 2017-03-28 | 2017-10-10 | 阿里巴巴集团控股有限公司 | A kind of method and device of data storage and inquiry based on block chain |
| CN108959330A (en) * | 2017-05-26 | 2018-12-07 | 阿里巴巴集团控股有限公司 | A kind of processing of database, data query method and apparatus |
| CN107609820A (en) * | 2017-09-19 | 2018-01-19 | 深圳市优户科技有限公司 | Method, system, medium and the server that commerce and trade enterprise interacts with supplier wechat |
| CN108304455A (en) * | 2017-12-20 | 2018-07-20 | 阿里巴巴集团控股有限公司 | A kind of method, apparatus and equipment of processing business request |
| CN109614822A (en) * | 2018-12-12 | 2019-04-12 | 北京时代远行信息科技有限公司 | A kind of Information Resource Access method, apparatus and system based on block chain |
Non-Patent Citations (1)
| Title |
|---|
| 张水霞: "神东公司采购寻源及供应商管理系统的设计与实现", 《科技创新与应用》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111600926A (en) * | 2020-04-01 | 2020-08-28 | 北京创世云科技有限公司 | Data processing method and device and electronic equipment |
| CN111600926B (en) * | 2020-04-01 | 2021-03-23 | 北京创世云科技有限公司 | Data processing method and device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110245150B (en) | 2023-03-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109345389A (en) | A kind of resource sharing method, device and equipment | |
| CN107644286A (en) | Workflow processing method and device | |
| CN110096528A (en) | The method, apparatus and system of formation sequence in a kind of distributed system | |
| CN108173706A (en) | Service marker method, apparatus and equipment under a kind of multiservice system | |
| CN107038618A (en) | A kind of order generation method, device, server and computer-readable storage medium | |
| CN110472438A (en) | Transaction data processing based on block chain, Transaction Inquiries method, device and equipment | |
| CN108959341A (en) | A kind of method, device and equipment that data are synchronous | |
| CN109598611A (en) | A kind of processing method of transaction, transaction gateway, trading server and transaction system | |
| CN110134668A (en) | Data migration method, device and equipment applied to block chain | |
| CN110532295A (en) | A kind of method and device of computer-implemented information processing, information inquiry | |
| CN110263050A (en) | Data processing method, device, equipment and storage medium | |
| CN108960790A (en) | A kind of processing method, device, server and the system of bill business | |
| CN109241026A (en) | The method, apparatus and system of data management | |
| CN110060085A (en) | It is a kind of to parse method, system and the equipment being distributed under advertising objective crowd line | |
| CN107093094A (en) | The dissemination method and device of a kind of evaluation information | |
| CN109902077A (en) | A kind of service request processing method, device and equipment | |
| CN109003090A (en) | risk control method and device | |
| CN109003071A (en) | Method of payment, device and equipment | |
| CN110297955A (en) | A kind of information query method, device, equipment and medium | |
| CN109886804A (en) | A kind of task processing method and device | |
| CN110245150A (en) | Data processing, querying method, device, equipment and data processing system | |
| CN109597678A (en) | Task processing method and device | |
| CN105589853B (en) | A kind of classification catalogue determines method and device, automatic classification method and device | |
| CN109656946A (en) | A kind of multilist relation query method, device and equipment | |
| CN108959330A (en) | A kind of processing of database, data query method and apparatus |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200925 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200925 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |