CN110245150B - Data processing method, data processing device, data query method, data query device, data processing equipment and data processing system - Google Patents
Data processing method, data processing device, data query method, data query device, data processing equipment and data processing system Download PDFInfo
- Publication number
- CN110245150B CN110245150B CN201910462020.3A CN201910462020A CN110245150B CN 110245150 B CN110245150 B CN 110245150B CN 201910462020 A CN201910462020 A CN 201910462020A CN 110245150 B CN110245150 B CN 110245150B
- Authority
- CN
- China
- Prior art keywords
- service
- data table
- supply
- data
- identifier
- 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.)
- Active
Links
Images
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
The embodiment of the specification discloses a data processing method, a data query method, a data processing device and a data processing system.
Description
Technical Field
Embodiments of the present disclosure relate to the field of computers, and in particular, to a data processing method, a data query method, a data processing apparatus, a data query device, a data processing apparatus, and a data processing system.
Background
In business transaction, the business demander attracts the business supplier to provide corresponding business supply aiming at the business demand information by releasing the business demand information. In general, the service requirement information may attract different service providers to provide service provision services, and the service demander may select an appropriate service provider.
In an application scenario, service demand information issued by a service demand party can be stored in a data table and a database in a service demand data manner, so that a service provider obtains the service demand information through query and issues a corresponding service provision scheme aiming at the service demand information, and the service provision scheme can be stored in the data table and the database in a service provision data manner. Then, the service demander can obtain the service provision scheme provided by the service demand information issued by each service provider by querying, and select an appropriate service provision scheme and service provider from the service provision schemes.
Disclosure of Invention
In view of this, embodiments of the present specification provide a data processing method, a data query method, a data processing apparatus, a data query device, and a data processing system, which improve data query efficiency.
An embodiment of the present specification provides a data processing method, including:
extracting a service demander identifier and service supply data containing the service demander identifier from at least one first supply-side data table, wherein a primary key of the first supply-side data table comprises the service supplier identifier;
creating a second supply side data table by using the service supply data and taking the service demander identification as a primary key;
storing the second supply-side data table in a database.
An embodiment of the present specification further provides a data query method, including:
receiving a query request, wherein the query request comprises a service demander identifier;
inquiring a second supply side data table with the service demander identifier as a main key in a database by using the service demander identifier, wherein the second supply side data table is created by extracting the service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table and using the service supply data with the service demander identifier as the main key;
extracting service supply data containing the service demander identification from the inquired second supply side data table;
and sending the service supply data containing the service demander identification.
An embodiment of the present specification further provides a data processing method, including:
extracting a buyer identification and supplier quote data containing the buyer identification from at least one supplier quote data table, the primary key of the supplier quote data table including the supplier identification;
creating a buyer quotation data table by using the supplier quotation data and taking the buyer identification as a main key;
and storing the buyer quotation data table in a database.
An embodiment of the present specification further provides a data processing system, including:
a database storing a first provisioning side data table, a primary key of the first provisioning side data table including a service provider identification;
and the data synchronization component extracts the service demander identification and the service supply data containing the service demander identification from the first supply side data table in at least one database, creates a second supply side data table by taking the service demander identification as a main key by using the service supply data, and stores the second supply side data table in the database.
An embodiment of the present specification further provides a data processing apparatus, including:
the extraction module extracts a service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table, wherein a primary key of the first supply side data table comprises the service supplier identifier;
the data table creating module is used for creating a second supply side data table by using the service supply data and taking the service demander identifier as a main key;
a storage module to store the second supply-side data table in a database.
An embodiment of the present specification further provides a data query apparatus, including:
the receiving module is used for receiving a query request, wherein the query request comprises a service demand party identifier;
the query module is used for querying a second supply side data table which takes the service demander identifier as a main key in a database by using the service demander identifier, wherein the second supply side data table is created by extracting the service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table and taking the service demander identifier as a main key by using the service supply data;
the extracting module is used for extracting service supply data containing the service demander identification from the inquired second supply side data table;
and the sending module is used for sending the service supply data containing the service demander identifier.
An embodiment of the present specification further provides a data processing apparatus, including:
an extraction module that extracts a buyer identifier and supplier quote data containing the buyer identifier from at least one supplier quote data table, the primary key of the supplier quote data table including the supplier identifier;
the data sheet creating module is used for creating a buyer quotation data sheet by taking the buyer identification as a main key by utilizing the supplier quotation data;
and the storage module is used for storing the buyer quotation data table in a database.
An embodiment of the present specification further provides an electronic device, including:
at least one memory;
at least one processor;
wherein the at least one memory has a program stored therein and is configured to, with the at least one processor:
extracting a service demander identifier and service supply data containing the service demander identifier from at least one first supply-side data table, wherein a primary key of the first supply-side data table comprises the service supplier identifier;
creating a second supply side data table by using the service supply data and taking the service demander identification as a primary key;
storing the second supply-side data table in a database.
An embodiment of the present specification further provides an electronic device, including:
at least one processor;
a memory storing a program and configured to at least perform, by one of the processors:
at least one memory;
at least one processor;
wherein the at least one memory has stored therein a program and is configured to, with the at least one processor:
receiving a query request, wherein the query request comprises a service demander identifier;
inquiring a second supply side data table with the service demander identifier as a main key in a database by using the service demander identifier, wherein the second supply side data table is created by extracting the service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table and using the service supply data with the service demander identifier as the main key;
and extracting service supply data containing the service demander identification from the inquired second supply side data table.
An embodiment of the present specification further provides an electronic device, including:
at least one memory;
at least one processor;
wherein the at least one memory has stored therein a program and is configured to, with the at least one processor:
extracting a buyer identification and supplier quote data containing the buyer identification from at least one supplier quote data table, the primary key of the supplier quote data table including the supplier identification;
creating a buyer quotation data table by using the supplier quotation data and taking the buyer identification as a main key;
and storing the buyer quotation data table in a database.
The embodiment of the specification adopts at least one technical scheme which can achieve the following beneficial effects:
the method comprises the steps of extracting service demander identification and service supply data containing the service demander identification from at least one first supply side data table, creating a second supply side data table by using service supply data and taking the service demander identification as a main key, and storing the second supply side data table in a database. Because the created main key of the second supply side data table comprises the service demander identification, the service demander can quickly inquire the second supply side data table by using the service demander identification to obtain the service supply data without traversing all databases and data tables, thereby improving the inquiry efficiency and having good user experience.
Drawings
The accompanying drawings, which are included to provide a further understanding of the embodiments of the specification and are incorporated in and constitute a part of this specification, illustrate embodiments of the specification and together with the description serve to explain the embodiments of the specification and are not intended to limit the embodiments of the specification unduly. In the drawings:
FIG. 1 is a block diagram of a data processing system according to an embodiment of the present disclosure;
FIG. 2 is a block diagram of a data processing system according to an embodiment of the present disclosure;
fig. 3 is a flowchart of a data processing method provided in an embodiment of the present specification;
FIG. 4 is a flowchart of a data query method provided in an embodiment of the present specification;
fig. 5 is a flowchart of a data processing method provided in an embodiment of the present specification;
fig. 6 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present disclosure;
FIG. 7 is a schematic structural diagram of a data query device provided in an embodiment of the present disclosure;
fig. 8 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present disclosure.
Detailed Description
The inventor analyzes the prior art to find that each service provider proposes different service provision schemes for the same service demand information, and the service provision schemes are dispersed in different supply-side data tables or databases. When a service demander needs to inquire service supply data, a service demander identifier is provided, and the system needs to traverse databases or data tables to avoid data omission and acquire different service supply data containing the service demander identifier.
Through analyzing the data table of the supply side, the main key of the data table of the supply side comprises service provider identification, each piece of information contained in the service supply data is a field value, the service demander identification is one of the field values, and the service demander identification cannot uniquely define the data table of the supply side. For this reason, the system uses the service demander identification query, possibly traversing a data table or database, to obtain the complete service provisioning data for the service demander.
In the prior art, a service provider is convenient for self query, and usually only a provider-side data table with a service provider identifier as a primary key is set separately.
The embodiment of the specification provides a data processing method, a data query method, a data processing device, a data processing equipment and a data processing system, wherein a service demander identifier and service supply data containing the service demander identifier are extracted from at least one first supply side data table, a primary key of the first supply side data table comprises the service supplier identifier, a second supply side data table is created by using the service supply data and taking the service demander identifier as the primary key, and the second supply side data table is stored in a database. Because the created main key of the second supply side data table comprises the service demander identification, the service demander can quickly inquire the second supply side data table by using the service demander identification to obtain the service supply data without traversing all databases and data tables, thereby improving the inquiry efficiency and having good user experience.
In order to make the objects, technical solutions and advantages of the present disclosure more clear, the technical solutions of the present disclosure will be clearly and completely described below with reference to the specific embodiments of the present disclosure and the accompanying drawings. It is to be understood that the embodiments described are only a few embodiments of the present disclosure, and not all embodiments. All other embodiments obtained by a person skilled in the art based on the embodiments in the present specification without any inventive step are within the scope of the present application.
Fig. 1 is a schematic structural diagram of a data processing system according to an embodiment of the present disclosure.
The data processing system described in the embodiments of the present specification may include:
a database 101 storing a first provisioning side data table, a primary key of the first provisioning side data table including a service provider identifier;
the data synchronization component 102 extracts the service demander identifier and the service provisioning data containing the service demander identifier from the first provisioning-side data table in at least one of the databases 101, creates a second provisioning-side data table by using the service provisioning data and using the service demander identifier as a primary key, and stores the second provisioning-side data table in the database.
The data synchronization component 102 is operative to convert a first supplier-side data table, which is dimensional to a service supplier, into a second supplier-side data table, which is dimensional to a service demander, and essentially achieves synchronization between a demand-side data table, which is identified as a primary key by the service demander, and the service supplier-side data table. Therefore, as the primary key in the second supply side data table contains the service demander identifier, which is the only index of the second supply side data table, the service demander can quickly query all relevant service supply data by using the own service demander identifier without traversing all databases and data tables, thereby effectively improving the query efficiency.
Fig. 2 is a schematic structural diagram of a data storage system according to an embodiment of the present disclosure. The principle of the system is illustrated by taking a supplier as a service provider and a buyer as a service demander.
The buyer platform 201 obtains the business requirements issued by the buyer through the modes of inquiry sheet, bid sheet, recruitment sheet and bid sheet, creates a buyer source data table by taking the ID of the buyer as a main key (or called dimension), and the buyer source data table is an instantiation of the demand side data table to realize sub-library and sub-table storage. Database 1 \8230, and library n, not limited thereto, is shown on the side of buyer platform 201 in fig. 2.
The supplier platform 202 acquires the service quotations issued by suppliers through quotations, tender tickets or accrual tickets according to the service demands issued by buyers, and creates a supplier quotation data table according to supplier IDs, wherein the supplier quotation data table is an instantiation of a supply side data table, so as to realize sub-warehouse and sub-table storage. Database 1 \8230, library n, not limiting herein, is shown on the side of buyer platform 201 in FIG. 2.
And the data synchronization component 203 acquires the supplier quotation data table, extracts the buyer ID and the quotation data containing the buyer ID from the supplier quotation data table, creates a buyer quotation data table taking the buyer ID as a main key, and realizes the storage of the quotation data taking the buyer as a view angle into the buyer quotation data table, thereby completing the storage of the quotation data of the buyer and the supplier view angles.
In this case, the service demand information and the quotation information are synchronized from the operation perspective through the data synchronization component 203, so that the full amount of data is synchronized to the service demand data and quotation data, and the operation can perform operation management on the service demand data and quotation data through the operation platform.
Fig. 3 is a flowchart of a data storage method provided in an embodiment of the present specification.
S301: and extracting service demander identification and service supply data containing the service demander identification from at least one first supply side data table, wherein the primary key of the first supply side data table comprises the service supplier identification.
In the embodiments of the present specification, the first provisioning-side data table is a provisioning-side data table with a service provider as a dimension, in which service provisioning data is described.
The service described in the embodiments of the present specification may be a service or a product, and the category of each of the service and the product is not particularly limited. The business requiring party is a party seeking business services, such as a buyer. A service provider is a party, such as a provider, that provides a service.
The first provisioning-side data table is generated according to a service provisioning scheme proposed by the service provider for service requirement information issued by the service provider for the service demander, and the service provisioning data may include: the service provider identifier, the service demander identifier, the service requirement information, and the service provision information, where the service provision information may include information such as price quotation, service parameter, address, and the like, and is not limited herein.
In the first supply-side data table, the service demander identifier, the service demand information, the service supply information and the like are fields, and the field values of the fields form service supply data.
In this embodiment of the present specification, the service demander identifier and the service provision data including the service demander identifier are extracted from at least one first provision-side data table, where the first provision-side data table is obtained from a database, and the service provision data of the service demander identifier and the service demander identifier are queried from the first provision-side data table.
Before extracting the service demander identifier and the service provisioning data containing the service demander identifier from at least one first provisioning-side data table, the method may further include:
extracting the service demander identification from at least one demand side data table, wherein a primary key of the demand side data table comprises the service demander identification;
and inquiring service supply data containing the service demander identification from the at least one first supply side data table by using the extracted service demander identification.
In this case, the service demander identifier uniquely identifies the demand side data table, so that all service demander identifiers can be quickly and efficiently queried from the demand side data table, thereby reducing the data processing time described in the embodiments of the present specification.
In an embodiment of the present specification, extracting the service demander identifier and the service provisioning data including the service demander identifier from at least one first provisioning-side data table may include:
and grouping the service supply data in the at least one first supply-side data table by using the service demander identifier, wherein the at least one service supply data containing the same service demander identifier is grouped into the same group, so that the same group of service supply data can be positioned in the created second supply-side data table.
S303: and creating a second supply side data table by using the service supply data and taking the service demander identification as a primary key.
Thus, the first supply-side data table originally identified from the perspective of the service provider is converted into the second supply-side data table identified from the perspective of the service provider.
In this embodiment of the present specification, instead of simply replacing the service demander identifier field in the first provisioning-side data table with the primary key, the extracted service provisioning data including the same service demander identifier may be stored in one data table, so that when querying all service provisioning data related to the service demander, the service demander only needs to traverse one data table, and does not need to traverse multiple data tables, thereby improving the querying efficiency.
Thus, the service provisioning data in the at least one first provisioning-side data table may be grouped using the service demander identity, and the at least one service provisioning data comprising the same service demander identity is grouped into the same group, such that the same group of service provisioning data is located in the created second provisioning-side data table.
In this embodiment, creating, by using the service provisioning data and using the service demander identifier as a primary key, a second provisioning-side data table may include:
inquiring a demand side data table with the service demand party identifier as a main key;
and inserting the service supply data comprising the service demander identification into the demand side data table to obtain the second supply side data table.
This embodiment updates the demand side data table with storage.
In another embodiment of the present specification, it may also be that a new second provisioning-side data table is created, so that the newly created second provisioning-side data table may contain service provisioning data of different time points in the near future.
S305: storing the second supply-side data table in a database.
Because the created main key of the second supply side data table comprises the service demander identification, the service demander can quickly inquire the second supply side data table by using the service demander identification to obtain the service supply data without traversing all databases and data tables, thereby improving the inquiry efficiency and having good user experience.
In an embodiment of the present specification, storing the second supply-side data table in a database may include:
storing the second supply-side data table in a demand-side database.
Fig. 4 is a flowchart of a data query method provided in an embodiment of the present disclosure.
The method can comprise the following steps:
s401: and receiving a query request, wherein the query request comprises a service demander identifier.
S403: and querying a second supply side data table with the service demander identifier as a main key in a database by using the service demander identifier, wherein the second supply side data table is created by extracting the service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table and using the service supply data with the service demander identifier as the main key.
If the second supply side data table is stored in the demand side database, the demand side database can be quickly located, and the query efficiency is improved. Moreover, since the service demander identifier in the second provisioning-side data table is a unique index, the service provisioning data corresponding to the specific service demander identifier can be queried in one table at a time.
S405: and extracting the service supply data containing the service demander identification from the queried second supply side data table without traversing all databases and data tables, thereby improving the query efficiency and ensuring good user experience.
S407: and sending the service supply data containing the service demander identification so that the user can consult the service supply data.
Fig. 5 is a flowchart illustrating a data processing method according to an embodiment of the present disclosure.
On the buyer side, the following steps are performed.
S501: the buyer issues a service sourcing sheet, which may be a form of service requirement information, and is not limited herein.
S503: and acquiring the ID of the buyer of the current issuing service sourcing list.
S505: performing database and table division calculation, specifically calculating a target database and a data table to be stored according to the issued service source searching list by using a database and table division component;
s507: and carrying out Structured Query Language (SQL) assembly on the issued service source searching list, and storing the service source searching list into a buyer source searching data table.
On the supplier side, the following steps are performed.
S502: and the supplier obtains the service sourcing order and issues a service quotation according to the service sourcing order.
S504: and acquiring the buyer ID associated with the service sourcing list and the supplier ID for issuing the service quotation.
S506: and (4) performing database and table division calculation, namely calculating a target database and a data table to be stored according to the issued service quotation by using a database and table division component.
S508: and SQL assembly is carried out on the buyer ID, the supplier ID and the service quotation to form a supplier quotation data table with the supplier ID as a main key, and the supplier quotation data table is stored in a target database.
On the data synchronization component side, the following steps are performed.
S510: the supplier quote table triggers data synchronization.
S512: a buyer identification and supplier quote data containing the buyer identification are extracted from at least one supplier quote data table, the primary key of which includes the supplier identification.
S514: and utilizing the supplier quotation data to establish a buyer quotation data table by taking the buyer identification as a main key.
S516: and storing the buyer quotation data table in a database.
In this case, the buyer can query the buyer database with its own buyer id to obtain the buyer's quote data table from which to obtain the supplier's quote information.
Fig. 6 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present disclosure. The apparatus may include:
an extracting module 601, configured to extract a service demander identifier and service provisioning data including the service demander identifier from at least one first provisioning-side data table, where a primary key of the first provisioning-side data table includes the service provider identifier;
a data table creating module 602, configured to create a second supply-side data table by using the service provisioning data and using the service demander identifier as a primary key;
the storage module 603 stores the second supply-side data table in a database.
Optionally, the extracting, from the at least one first provisioning-side data table, the service demander identifier and the service provisioning data including the service demander identifier includes:
and grouping the service supply data in the at least one first supply side data table by using the service demander identifier, wherein the at least one service supply data containing the same service demander identifier is grouped into the same group, so that the same group of service supply data is positioned in the created second supply side data table.
Optionally, creating a second provisioning-side data table with the service demander identifier as a primary key by using the service provisioning data, including:
inquiring a demand side data table with the service demand party identifier as a main key;
and inserting the service supply data comprising the service demander identification into the demand side data table to obtain the second supply side data table.
With the data processing apparatus described in the embodiments of the present specification, a first supply-side data table with a service provider as a dimension is converted into a second supply-side data table with a service provider as a dimension. Because the created primary key of the second supply side data table comprises the service demander identifier, the service demander can quickly query the second supply side data table by using the service demander identifier to obtain service supply data without traversing all databases and data tables, thereby improving the query efficiency and having good user experience.
Based on the same inventive concept, an embodiment of the present specification further provides an electronic device, including:
at least one memory;
at least one processor;
wherein the at least one memory has stored therein a program and is configured to, with the at least one processor:
extracting a service demander identifier and service supply data containing the service demander identifier from at least one first supply-side data table, wherein a primary key of the first supply-side data table comprises the service supplier identifier;
creating a second supply side data table by using the service supply data and taking the service demander identification as a primary key;
storing the second supply-side data table in a database.
Based on the same inventive concept, there is also provided in an embodiment of this specification a computer-readable storage medium including a program for use in conjunction with an electronic device, the program being executable by a processor to perform the steps of:
extracting a service demander identifier and service supply data containing the service demander identifier from at least one first supply-side data table, wherein a primary key of the first supply-side data table comprises the service supplier identifier;
creating a second supply side data table by using the service supply data and taking the service demander identifier as a primary key;
storing the second supply-side data table in a database.
Fig. 7 is a schematic structural diagram of a data query device provided in an embodiment of the present specification. The apparatus may include:
a receiving module 701, configured to receive a query request, where the query request includes a service demander identifier;
a query module 702 configured to query, in a database, a second data table on a supply side using the service demander identifier as a primary key, where the second data table on the supply side is created by extracting, from at least one first data table on the supply side, the service demander identifier and service supply data including the service demander identifier, and using the service supply data using the service demander identifier as a primary key;
an extracting module 703, configured to extract service provisioning data including the service demander identifier from the queried second provisioning-side data table;
a sending module 704, sending the service provision data containing the service demander identifier.
By using the data query device described in the embodiment of the present specification, since the primary key of the created second supply-side data table includes the service demander identifier, the service demander can quickly query the second supply-side data table by using the service demander identifier to obtain the service supply data without traversing all databases and data tables, thereby improving the query efficiency and providing good user experience.
Based on the same inventive concept, an embodiment of the present specification further provides an electronic device, including:
at least one memory;
at least one processor;
wherein the at least one memory has stored therein a program and is configured to, with the at least one processor:
receiving a query request, wherein the query request comprises a service demander identifier;
inquiring a second supply side data table with the service demander identifier as a main key in a database by using the service demander identifier, wherein the second supply side data table is created by extracting the service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table and using the service supply data with the service demander identifier as the main key;
extracting service supply data containing the service demander identification from the inquired second supply side data table;
and sending the service supply data containing the service demander identification.
Based on the same inventive concept, there is also provided in an embodiment of this specification a computer-readable storage medium including a program for use in conjunction with an electronic device, the program being executable by a processor to perform the steps of:
receiving a query request, wherein the query request comprises a service demander identifier;
inquiring a second supply side data table with the service demander identifier as a main key in a database by using the service demander identifier, wherein the second supply side data table is created by extracting the service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table and using the service supply data with the service demander identifier as the main key;
extracting service supply data containing the service demander identification from the inquired second supply side data table;
and sending the service supply data containing the service demander identification.
Fig. 8 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present disclosure. The apparatus may include:
an extracting module 801 extracting a buyer identifier and supplier quotation data including the buyer identifier from at least one supplier quotation data table, the primary key of which includes the supplier identifier;
a data table creating module 802, for creating a buyer quotation data table by using the buyer identification as the main key, using the supplier quotation data;
the storage module 803 stores the buyer quotation data table in the database.
Based on the same inventive concept, an embodiment of the present specification further provides an electronic device, including:
at least one memory;
at least one processor;
wherein the at least one memory has stored therein a program and is configured to, with the at least one processor:
extracting a buyer identification and supplier quote data containing the buyer identification from at least one supplier quote data table, the primary key of the supplier quote data table including the supplier identification;
creating a buyer quotation data table by using the supplier quotation data and taking the buyer identification as a main key;
and storing the buyer quotation data table in a database.
Based on the same inventive concept, there is also provided in an embodiment of this specification a computer-readable storage medium including a program for use in conjunction with an electronic device, the program being executable by a processor to perform the steps of:
extracting a buyer identification and supplier quote data containing the buyer identification from at least one supplier quote data table, the primary key of the supplier quote data table including the supplier identification;
creating a buyer quotation data table by using the supplier quotation data and taking the buyer identification as a main key;
and storing the buyer quotation data table in a database.
In the 90 s of the 20 th century, improvements in a technology could clearly distinguish between improvements in hardware (e.g., improvements in circuit structures such as diodes, transistors, switches, etc.) and improvements in software (improvements in process flow). However, as technology advances, many of today's process flow improvements have been seen as direct improvements in hardware circuit architecture. Designers almost always obtain a corresponding hardware circuit structure by programming an improved method flow into the hardware circuit. Thus, it cannot be said that an improvement in the process flow cannot be realized by hardware physical blocks. For example, a Programmable Logic Device (PLD), such as a Field Programmable Gate Array (FPGA), is an integrated circuit whose Logic functions are determined by programming the Device by a user. A digital system is "integrated" on a PLD by the designer's own programming without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips. Furthermore, nowadays, instead of manually manufacturing an Integrated Circuit chip, such Programming is often implemented by "logic compiler" software, which is similar to a software compiler used in program development and writing, but the original code before compiling is also written by a specific Programming Language, which is called Hardware Description Language (HDL), and HDL is not only one but many, such as ABEL (Advanced Boolean Expression Language), AHDL (alternate Hardware Description Language), traffic, CUPL (core universal Programming Language), HDCal, jhddl (Java Hardware Description Language), lava, lola, HDL, PALASM, rhyd (Hardware Description Language), and vhigh-Language (Hardware Description Language), which is currently used in most popular applications. It will also be apparent to those skilled in the art that hardware circuitry for implementing the logical method flows can be readily obtained by a mere need to program the method flows with some of the hardware description languages described above and into an integrated circuit.
The controller may be implemented in any suitable manner, for example, the controller may take the form of, for example, a microprocessor or processor and a computer-readable medium storing computer-readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, an Application Specific Integrated Circuit (ASIC), a programmable logic controller, and an embedded microcontroller, examples of which include, but are not limited to, the following microcontrollers: ARC 625D, atmel AT91SAM, microchip PIC18F26K20, and Silicone Labs C8051F320, the memory controller may also be implemented as part of the control logic for the memory. Those skilled in the art will also appreciate that, in addition to implementing the controller in purely computer readable program code means, the same functionality can be implemented by logically programming method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers and the like. Such a controller may thus be regarded as a hardware component and the means for performing the various functions included therein may also be regarded as structures within the hardware component. Or even means for performing the functions may be conceived to be both a software module implementing the method and a structure within a hardware component.
The systems, devices, modules or units illustrated in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions. One typical implementation device is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smartphone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
For convenience of description, the above devices are described as being divided into various units by function, and are described separately. Of course, the functionality of the units may be implemented in one or more software and/or hardware when implementing the present application.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both permanent and non-permanent, removable and non-removable media, may implement the information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Disks (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising a," "8230," "8230," or "comprising" does not exclude the presence of other like elements in a process, method, article, or apparatus comprising the element.
The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art to which the present application pertains. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (14)
1. A method of data processing, comprising:
extracting a service demander identifier and service supply data containing the service demander identifier from at least one first supply-side data table, wherein a primary key of the first supply-side data table comprises the service supplier identifier;
creating a second supply side data table by using the service supply data and taking the service demander identifier as a primary key;
storing the second supply-side data table in a database;
the extracting of the service demander identifier and the service provisioning data including the service demander identifier from the at least one first provisioning-side data table specifically includes:
and grouping the service supply data in the at least one first supply side data table by using the service demander identifier, wherein the at least one service supply data containing the same service demander identifier is grouped into the same group, so that the same group of service supply data is positioned in the created second supply side data table.
2. The method of claim 1, storing the second supply-side data table in a database, comprising:
storing the second supply-side data table in a demand-side database.
3. The method of claim 1, further comprising, prior to extracting the service demander identification and the service provisioning data containing the service demander identification from the at least one first provisioning-side data table:
extracting the service demander identification from at least one demand side data table, wherein a primary key of the demand side data table comprises the service demander identification;
and inquiring service supply data containing the service demander identification from the at least one first supply side data table by using the extracted service demander identification.
4. The method of claim 1, utilizing the service provisioning data to create a second provisioning-side data table with the service requestor identification as a primary key, comprising:
inquiring a demand side data table with the service demand party identifier as a main key;
and inserting the service supply data comprising the service demander identification into the demand side data table to obtain the second supply side data table.
5. A method of data query, comprising:
receiving a query request, wherein the query request comprises a service demand party identifier;
inquiring a second supply side data table with the service demander identifier as a main key in a database by using the service demander identifier, wherein the second supply side data table is obtained by extracting the service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table and establishing by using the service supply data with the service demander identifier as the main key;
extracting service supply data containing the service demander identification from the inquired second supply side data table;
sending service supply data containing the service demander identifier;
the extracting of the service demander identifier and the service provisioning data including the service demander identifier from the at least one first provisioning-side data table specifically includes:
and grouping the service supply data in the at least one first supply side data table by using the service demander identifier, wherein the at least one service supply data containing the same service demander identifier is grouped into the same group, so that the same group of service supply data is positioned in the created second supply side data table.
6. A method of data processing, comprising:
extracting a buyer identification and supplier quote data containing the buyer identification from at least one supplier quote data table, the primary key of the supplier quote data table including the supplier identification;
creating a buyer quotation data table by using the supplier quotation data and taking the buyer identification as a main key;
storing the buyer quotation data table in a database;
the extracting of the buyer identifier and the supplier quote data including the buyer identifier from the at least one supplier quote data table specifically includes:
grouping the supplier offer data in the at least one supplier offer data table using the buyer identification, the at least one supplier offer data including the same buyer identification being grouped into the same group such that the same group of supplier offer data is located in the created buyer offer data table.
7. A data processing system, comprising:
a database storing a first provisioning side data table, a primary key of the first provisioning side data table including a service provider identification;
the data synchronization component extracts a service demander identifier and service supply data containing the service demander identifier from the first supply side data table in at least one database, creates a second supply side data table by taking the service demander identifier as a primary key by using the service supply data, and stores the second supply side data table in the database;
the extracting, from the first provisioning-side data table in at least one of the databases, the service demander identifier and the service provisioning data including the service demander identifier specifically includes:
and grouping the service supply data in the first supply side data table in the at least one database by using the service demander identifier, wherein the at least one service supply data containing the same service demander identifier is grouped into the same group, so that the same group of service supply data is positioned in the created second supply side data table.
8. A data processing apparatus comprising:
the extraction module extracts a service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table, wherein a primary key of the first supply side data table comprises the service supplier identifier;
the data table creating module is used for creating a second supply side data table by using the service supply data and taking the service demander identification as a primary key;
a storage module that stores the second supply-side data table in a database;
the extraction module specifically comprises:
an extracting unit, configured to group the service provision data in the at least one first provisioning-side data table by using the service demander identifier, where at least one service provision data including the same service demander identifier is grouped into the same group, so that the same group of service provision data is located in the created second provisioning-side data table.
9. The apparatus of claim 8, utilizing the service provisioning data to create a second provisioning-side data table with the service requestor identification as a primary key, comprising:
inquiring a demand side data table with the service demand party identifier as a main key;
and inserting the service supply data comprising the service demander identification into the demand side data table to obtain the second supply side data table.
10. A data query apparatus, comprising:
the receiving module is used for receiving a query request, wherein the query request comprises a service demand party identifier;
the query module is used for querying a second supply side data table which takes the service demander identifier as a main key in a database by using the service demander identifier, wherein the second supply side data table is created by extracting the service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table and taking the service demander identifier as a main key by using the service supply data;
the extraction module is used for extracting service supply data containing the service demander identification from the inquired second supply side data table;
the sending module sends the service supply data containing the service demander identifier;
the extracting of the service demander identifier and the service provisioning data including the service demander identifier from the at least one first provisioning-side data table specifically includes:
and grouping the service provision data in the at least one first supply-side data table by using the service demander identifier, wherein the at least one service provision data containing the same service demander identifier is grouped into the same group, so that the same group of service provision data is positioned in the created second supply-side data table.
11. A data processing apparatus comprising:
an extraction module that extracts a buyer identifier and supplier quote data containing the buyer identifier from at least one supplier quote data table, the primary key of the supplier quote data table including the supplier identifier;
the data sheet creating module is used for creating a buyer quotation data sheet by taking the buyer identification as a main key by utilizing the supplier quotation data;
the storage module is used for storing the buyer quotation data table in a database;
the extraction module specifically comprises:
and the extraction unit is used for grouping the supplier quotation data in the at least one supplier quotation data table by utilizing the buyer identification, and the at least one supplier quotation data containing the same buyer identification is grouped into the same group, so that the same group of supplier quotation data is positioned in the created buyer quotation data table.
12. An electronic device, comprising:
at least one memory;
at least one processor;
wherein the at least one memory has a program stored therein and is configured to, with the at least one processor:
extracting a service demander identifier and service supply data containing the service demander identifier from at least one first supply-side data table, wherein a primary key of the first supply-side data table comprises the service supplier identifier;
creating a second supply side data table by using the service supply data and taking the service demander identification as a primary key;
storing the second supply-side data table in a database;
the extracting of the service demander identifier and the service provisioning data including the service demander identifier from the at least one first provisioning-side data table specifically includes:
and grouping the service provision data in the at least one first supply-side data table by using the service demander identifier, wherein the at least one service provision data containing the same service demander identifier is grouped into the same group, so that the same group of service provision data is positioned in the created second supply-side data table.
13. An electronic device, comprising:
at least one memory;
at least one processor;
wherein the at least one memory has a program stored therein and is configured to, with the at least one processor:
receiving a query request, wherein the query request comprises a service demander identifier;
inquiring a second supply side data table with the service demander identifier as a main key in a database by using the service demander identifier, wherein the second supply side data table is created by extracting the service demander identifier and service supply data containing the service demander identifier from at least one first supply side data table and using the service supply data with the service demander identifier as the main key;
extracting service supply data containing the service demander identification from the inquired second supply side data table;
the extracting a service demander identifier and service provisioning data including the service demander identifier from at least one first provisioning side data table specifically includes:
and grouping the service supply data in the at least one first supply side data table by using the service demander identifier, wherein the at least one service supply data containing the same service demander identifier is grouped into the same group, so that the same group of service supply data is positioned in the created second supply side data table.
14. An electronic device, comprising:
at least one memory;
at least one processor;
wherein the at least one memory has a program stored therein and is configured to, with the at least one processor:
extracting a buyer identification and supplier quote data containing the buyer identification from at least one supplier quote data table, the primary key of the supplier quote data table including the supplier identification;
creating a buyer quotation data table by using the supplier quotation data and taking the buyer identification as a main key;
storing the buyer quotation data table in a database;
the extracting of the buyer identifier and the supplier quote data containing the buyer identifier from at least one supplier quote data table specifically includes:
and grouping the supplier offer data in the at least one supplier offer data table by using the buyer identification, wherein the at least one supplier offer data containing the same buyer identification is grouped into the same group, so that the same group of supplier offer data is positioned in the created buyer offer data table.
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 CN110245150A (en) | 2019-09-17 |
| CN110245150B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111600926B (en) * | 2020-04-01 | 2021-03-23 | 北京创世云科技有限公司 | Data processing method and device and electronic equipment |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| 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 |
Family Cites Families (3)
| 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 |
| 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 |
-
2019
- 2019-05-30 CN CN201910462020.3A patent/CN110245150B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| 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 |
|---|
| 神东公司采购寻源及供应商管理系统的设计与实现;张水霞;《科技创新与应用》;20160908(第25期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110245150A (en) | 2019-09-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106970936B (en) | Data processing method and device and data query method and device | |
| US11204915B2 (en) | Blockchain-based data storage and query method and device | |
| CN107526777B (en) | Method and equipment for processing file based on version number | |
| CN107562775B (en) | Data processing method and device based on block chain | |
| CN109597661B (en) | Service function configuration method and device | |
| TWI748175B (en) | Data processing method, device and equipment | |
| CN107562467B (en) | Page rendering method, device and equipment | |
| CN106899666B (en) | Data processing method and device for service identification | |
| CN109344348B (en) | Resource updating method and device | |
| US11366925B2 (en) | Methods and apparatuses for chaining service data | |
| CN112016921B (en) | Transaction processing method, device and equipment | |
| CN108848244B (en) | Page display method and device | |
| CN111738737B (en) | Method, device and equipment for generating digital property right certificate | |
| CN108599973B (en) | Log association method, device and equipment | |
| CN108268289B (en) | Parameter configuration method, device and system for web application | |
| CN107391537B (en) | Method, device and equipment for generating data relation model | |
| CN107578338B (en) | Service publishing method, device and equipment | |
| CN113495797A (en) | Message queue and consumer dynamic creation method and system | |
| CN117435639A (en) | Data processing method, device, equipment and system | |
| CN112163150A (en) | Information pushing method and device | |
| CN110399359B (en) | Data backtracking method, device and equipment | |
| CN111784468A (en) | Account association method and device and electronic equipment | |
| CN110245150B (en) | Data processing method, data processing device, data query method, data query device, data processing equipment and data processing system | |
| CN108959330B (en) | Database processing and data query method and device | |
| CN111339117B (en) | Data processing method, device and equipment |
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 |