CN116595052A

CN116595052A - Data query method, communication system and related device

Info

Publication number: CN116595052A
Application number: CN202310567370.2A
Authority: CN
Inventors: 吴经胜; 雷国华
Original assignee: Shenzhen Suyuan Technology Co ltd
Current assignee: Shenzhen Suyuan Technology Co ltd
Priority date: 2023-05-18
Filing date: 2023-05-18
Publication date: 2023-08-15

Abstract

The embodiment of the application discloses a data query method, a communication system and a related device, wherein the communication system comprises electronic equipment and a server. The server can generate a main database first and load data from different data sources in the list page to the main database in advance from a plurality of auxiliary databases, when a user requests to view the list page on the electronic equipment, the server can directly acquire the data in the list page from the main database, and the main database is generated asynchronously, so that the required data do not need to be acquired from the plurality of auxiliary databases one by one after the request is received, and the list query efficiency is improved.

Description

Data query method, communication system and related device

Technical Field

The present application relates to the field of computer technologies, and in particular, to a data query method, a communication system, and a related device.

Background

The materials designed or manufactured by the suppliers may be authorized for distribution to the agencies. The agent needs to assist in the development of clients, maintenance of client relationships, etc.

(1) And (3) material: the material may include all items other than the end product and related to the production of the end product. For example, the materials may include raw materials, semi-finished products, finished products. The material can be processed to produce the final product.

(2) The suppliers: the suppliers are companies responsible for designing and/or manufacturing materials. The materials produced by the suppliers can be directly sold to clients or authorized to be distributed to agents.

(3) Agent: the agent is a distributor for distributing materials produced by the provider after the provider is authorized. Agents need to assist suppliers in developing customers and maintaining customer relationships.

Currently, due to the comparative fragmentation of the agent's customer information, the agent may perform project management via some project management systems, and the provider may also view the projects handled by one or more agents via the same project management system. In the process, the provider can check item information, client information and the like corresponding to one or more agents in a list, but the information is often from different databases, and if list inquiry is sequentially carried out according to the address stored by the data, the reading efficiency of the data is greatly reduced. Therefore, how to improve the efficiency of list query under multiple data sources is a urgent problem to be solved.

Disclosure of Invention

The application provides a data query method, a communication system and a related device, which can improve the efficiency of list query and user experience under multiple data sources.

In a first aspect, an embodiment of the present application provides a data query method, applied to a communication system, where the communication system includes an electronic device and a server, and the server stores a plurality of secondary databases, and types of data in different secondary databases are different, the method includes: the method comprises the steps that a server creates a first main database of a first page; the electronic equipment receives and responds to the operation of opening a first page by a user, and sends a first request to a server; the server receives a first request; in response to a first request, the server sends first data of a first page to the electronic equipment, a first auxiliary database set is determined from a plurality of auxiliary databases, first target data is acquired from the first auxiliary database set, a first list is created in a first main database, the first list comprises the first target data, and one or more auxiliary databases are included in the first auxiliary database set; the electronic equipment receives the first data, displays a first page and sends a second request to the server; the server receives and responds to the second request and sends a first list to the electronic equipment; the electronic device displays a first list on a first page.

In the embodiment of the application, the server can generate the main database first and load the data from different data sources in the list page to the main database in advance from a plurality of auxiliary databases, when a user requests to view the list page, the server can directly acquire the data in the list page from the main database, and the main database is generated asynchronously, so that the need of acquiring the required data from the auxiliary databases one by one after the request is received is avoided, thereby improving the list query efficiency.

In some embodiments, the method further comprises: the server creates a second main database of the second page; the electronic equipment receives and responds to the operation of opening the second page by the user, and sends a third request to the server; the server receives and responds to a third request, second data of a second page are sent to the electronic equipment, a second auxiliary database set is determined from a plurality of auxiliary databases, second target data are obtained from the second auxiliary database set, a second list is created in a second main database, the second list comprises the second target data, and the second auxiliary database set comprises one or more auxiliary databases; the electronic equipment receives the second data, displays a second page and sends a fourth request to the server; the server receives and responds to the fourth request and sends a second list to the electronic equipment; the electronic device displays a second list on a second page.

In the embodiment of the application, different main databases can be created for different pages, and each main database stores all data required for displaying one page, so that interfaces required to be checked by a user can be displayed on electronic equipment more quickly, and the user experience is improved.

In some embodiments, the first page is associated with a third page, the third page being a sub-page of the first page, the method further comprising: in response to the first request, the server determines a third secondary database set corresponding to the third page from the plurality of secondary databases, acquires third target data from the third secondary database set, creates a third list in the first main database, the third list comprises the third target data, and the third secondary database set comprises one or more secondary databases; the electronic equipment receives and responds to the operation of opening the third page by the user, and a fifth request is sent to the server; the server receives and responds to the fifth request, and sends third data of a third page to the electronic equipment, wherein the third data comprises a third list; and after receiving the third data, the electronic equipment displays a third page and displays a third list on the third page.

In the embodiment of the application, the data included in the sub-page of the first page can be stored in the first main database, so that after the user opens the first page on the electronic device, if the user needs to view the sub-page, the server can directly acquire the data required by displaying the sub-page from the first main database, and the electronic device can display the sub-page more quickly, thereby improving user experience.

In some embodiments, after the electronic device displays the first list on the first page, the method further comprises: the electronic equipment receives and responds to the operation of refreshing the first page by a user, and sends a first request to the server; the server receives a first request; in response to the first request, the server re-acquires first target data from the first secondary database set, updates the first list in the first primary database, and sends the updated first list to the electronic device, wherein the updated first list comprises the re-acquired first target data; and after receiving the updated first list, the electronic equipment displays the updated first list on the first page.

In the embodiment of the application, the server can update the data in the main database according to the refresh request of the user, so that the user can see the latest data on the electronic equipment, and the user experience is improved.

In some embodiments, after the server receives and responds to the second request to send the first list to the electronic device, the method further comprises: the server re-acquires first target data from the first auxiliary database set according to the period; the server updates the first list based on the re-acquired first target data and sends the updated first list to the electronic equipment, wherein the updated first list comprises the re-acquired first target data; and after receiving the updated first list, the electronic equipment displays the updated first list on the first page.

In the embodiment of the application, the server can actively update the main database according to the period, namely, the server can acquire the target data from the auxiliary database set according to the period, and further, the first list can be updated based on the acquired target data, so that the server can send the updated list to the electronic equipment, the electronic equipment can automatically refresh the page content, and the user experience is improved.

In some embodiments, the server re-retrieves the first target data from the first set of secondary databases on a periodic basis, including: when the page type of the first page is the first type, the server re-acquires first target data from the first auxiliary database set according to a first period; when the page type of the first page is the second type, the server re-acquires the first target data from the first auxiliary database set according to the second period; the first type is different from the second type and the first period is different from the second period.

In the embodiment of the application, for some pages with higher real-time requirements, the updating time interval can be shortened to some pages with lower real-time requirements, and the updating time interval can be set to be longer, so that the updating frequency of the pages is optimized, and the user experience is improved.

In some embodiments, the first set of secondary databases includes a first target secondary database, the second target secondary database, and the server re-retrieves the first target data from the first set of secondary databases on a periodic basis, including: the server re-acquires the first part of data in the first target data from the first target auxiliary database in a third period; the server re-acquires the second part of data in the first target data from the second target auxiliary database in a fourth period; the update rate of the first target sub-database is different from the update rate of the second target sub-database, and the third period is different from the fourth period.

In the embodiment of the application, the secondary database set can comprise a plurality of secondary databases, and the data update speeds in different secondary databases are different, so that the target data can be obtained again in different secondary databases according to different periods, thereby optimizing the update frequency of pages and improving the user experience.

In some embodiments, the electronic device is associated with a vendor client, the first page is an agent project management page, the first set of databases includes an agent information database, an agent customer information database, an agent project information database, the first target data includes one or more of agent responsible person information, a customer name, an area, an industry, a project name, a project product quantity, a project responsible person, a project team member; the agent information database comprises agent names and agent responsible person information; the agent client information database comprises a client name, an area and an industry; the agent project information database comprises project names, project product numbers, project responsible persons and project team members.

In some embodiments, the electronic device is associated with a vendor client, the first page is a camping project management page, the first set of secondary databases includes a camping customer information database, the camping project information database, the first target data includes one or more of a customer name, an area, an industry, a project name, a project product quantity, a project responsible person, a project team member; the direct-camping client information database comprises a client name, an area and an industry; the direct-camping project information database comprises project names, project product quantity, project responsible persons and project team members.

In a second aspect, an embodiment of the present application provides a communication system, where the communication system includes an electronic device and a server, where the server stores a plurality of secondary databases, and types of data in different secondary databases are different; the server is used for creating a first main database of the first page; the electronic equipment is used for receiving and responding to the operation of opening the first page by the user and sending a first request to the server; the server is also used for receiving the first request; the server is further used for sending first data of a first page to the electronic device in response to the first request, determining a first auxiliary database set from the plurality of auxiliary databases, acquiring first target data from the first auxiliary database set, and creating a first list in the first main database, wherein the first list comprises the first target data, and the first auxiliary database set comprises one or more auxiliary databases; the electronic equipment is also used for receiving the first data, displaying the first page and sending a second request to the server; the server is further used for receiving and responding to the second request and sending a first list to the electronic equipment; the electronic device is further configured to display a first list on the first page.

In a third aspect, an embodiment of the present application provides a data query method, applied to a server, where the server stores a plurality of secondary databases, and types of data in different secondary databases are different, where the method includes: creating a first master database of a first page; receiving a first request sent by electronic equipment, wherein the first request is used for requesting to open a first page; in response to the first request, sending first data of a first page to the electronic equipment, determining a first auxiliary database set from a plurality of auxiliary databases, acquiring first target data from the first auxiliary database set, creating a first list in a first main database, wherein the first list comprises the first target data, and the first auxiliary database set comprises one or more auxiliary databases; and receiving and responding to a second request sent by the electronic equipment, and sending the first list to the electronic equipment, wherein the second request is used for requesting to reopen the first page.

In a fourth aspect, in an embodiment of the present application, there is provided a server, including: a processor, a memory, a transceiver; wherein the processor, transceiver and memory are coupled; the memory stores program instructions that, when executed by the processor, cause the server to perform the method of any one of the possible implementations of the third aspect described above.

In a fifth aspect, embodiments of the present application provide a computer readable storage medium comprising instructions which, when run on a server, cause the server to perform a method as in any one of the possible implementations of the above aspect.

In a sixth aspect, embodiments of the present application provide a computer program product for, when run on a computer, causing the computer to perform the method of any one of the possible implementations of the above aspect.

Drawings

Fig. 1a is a schematic diagram of a communication system according to the present application.

Fig. 1b is a schematic diagram of another communication system according to the present application.

Fig. 1c is a schematic diagram of a communication system according to another embodiment of the present application.

Fig. 2 is a flow chart of a data query method according to an embodiment of the present application.

Fig. 3a to 3d are schematic views of an interface of a set of first pages according to an embodiment of the present application.

Fig. 4 is a schematic flow chart of querying another list data according to an embodiment of the present application.

Fig. 5 is an interface schematic diagram of a second page according to an embodiment of the present application.

Fig. 6 is a schematic flow chart of displaying sub-pages according to an embodiment of the present application.

Fig. 7 a-7 b are schematic diagrams illustrating interfaces of a set of sub-pages according to an embodiment of the present application.

Fig. 8 is a schematic flow chart of refreshing a page according to an embodiment of the present application.

Fig. 9 is an interface schematic diagram of page refreshing according to an embodiment of the present application.

Fig. 10 is a schematic structural diagram of an electronic device according to an embodiment of the present application.

Fig. 11 is a schematic structural diagram of a server according to an embodiment of the present application.

Detailed Description

Embodiments of the present application will be described below with reference to the accompanying drawings in the embodiments of the present application.

The terminology used in the following embodiments of the application is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in the specification of the present application and the appended claims, the singular forms "a," "an," "the," and "the" are intended to include the plural forms as well, unless the context clearly indicates to the contrary. It should also be understood that the term "and/or" as used in this disclosure refers to and encompasses any or all possible combinations of one or more of the listed items.

An exemplary electronic device provided in the following embodiments of the present application is first described below.

The electronic device according to the embodiment of the present application may be a mobile phone, a tablet computer, a desktop, a laptop, a notebook, an Ultra mobile personal computer (Ultra-mobile Personal Computer, UMPC), a handheld computer, a netbook, a personal digital assistant (Personal Digital Assistant, PDA), a virtual reality device, a PDA (Personal Digital Assistant, a personal digital assistant, also referred to as a palmtop), a portable internet device, a data storage device, a smart television, a vehicle-mounted terminal (e.g., a smart screen, a vehicle-mounted camera, a display screen), or the like.

As shown in fig. 1a, fig. 1a schematically illustrates an architecture of a communication system according to the present application. The communication system may include: an electronic device 101, an electronic device 102 and a server 103.

The electronic device 101 may download and install the first application locally, or log into the first application through a web page, and after entering the first application, may indicate that the electronic device 101 has logged into the server 103. For example, the first application may be a project management platform, such as a chip service management platform (chipsource), which may be used by a vendor (e.g., chip vendor) to manage the projects handled by multiple chip agents, which may be used by an agent (e.g., chip agent) to manage the projects handled, and/or purchase orders, etc. In some embodiments, the electronic device 101 may be an agent client device.

The electronic device 102 may download and install the first application locally, or log into the first application through a web page, and after entering the first application, may indicate that the electronic device 102 has logged into the server 103. For example, the first application may be a project management platform, such as a chip service management platform (chipsource), which may be used by a vendor (e.g., chip vendor) to manage projects handled by multiple chip agents and/or purchase orders, and which may also be used by the vendor to conduct full-flow management of direct marketing projects. In some embodiments, the electronic device 102 may be a vendor client device.

The server 103 may be configured to provide a login verification function for an application (e.g., a first application), and an application layer service function for the application after the login is passed, such as a project list display, a purchase order list display, and so on.

As further shown in fig. 1b, fig. 1b schematically illustrates an architecture of another communication system provided by the present application. The communication system may include: an electronic device 111 and a server 113, an electronic device 112 and a server 114.

The electronic device 111 may download and install the first application locally, or log into the first application through a web page, and after entering the first application, may indicate that the electronic device 111 has logged into the server 113. For example, the first application may be a project management platform, such as a chip service management platform (chipsource), which may be used by a vendor (e.g., chip vendor) to manage sales projects handled by multiple chip agents, which may also be used by an agent (e.g., chip agent) to manage sales projects, and/or purchase orders. In some embodiments, the electronic device 111 may be an agent client device.

The server 113 may be configured to provide the electronic device 111 with a login checking function of an application program (e.g., a first application), and an application layer service function of the application program after the login passes, such as a function of displaying an item list.

The electronic device 112 may download and install the first application locally, or log into the first application through a web page, and after entering the first application, may indicate that the electronic device 112 has logged into the server 114. For example, the first application may be a project management platform, such as a chip service management platform (chipsource), which may be used by a vendor (e.g., chip vendor) to manage sales projects and/or purchase orders processed by multiple chip agents, and which may also be used by the vendor to conduct full-flow management of direct sales projects. In some embodiments, the electronic device 112 may be a vendor client device.

The server 114 may be configured to provide the electronic device 112 with a login verification function of an application program (e.g., a first application), and an application layer service function of the application program after the login is passed, such as a function of item list display, etc.

As further shown in fig. 1c, fig. 1c schematically illustrates an architecture of yet another communication system provided by the present application. The communication system may include: an electronic device 121 and a server 122. The electronic device 121 may download and install the first application locally, or log into the first application through a web page, and after entering the first application, it may indicate that the electronic device 121 has logged into the server 122. For example, the first application may be a project management platform, such as a chip service management platform (chipsource), which may be used by a vendor (e.g., chip vendor) to conduct a full-flow management of the marketing project being camped.

The server 122 may be configured to provide the electronic device 121 with a login checking function of an application program (e.g., a first application), and an application layer service function of the application program after the login is passed, such as a function of displaying an item list.

As shown in fig. 2, fig. 2 shows a flow of a data query method in the application scenario, where the method may be applied to the above communication system, and the communication system includes an electronic device and a server, where the server stores a plurality of secondary databases, and the types of data in the different secondary databases are different. The detailed description is as follows:

step S201: the server creates a first master database of the first page.

Step S202: the electronic device receives and responds to the operation of opening the first page by a user, and sends a first request to the server.

Specifically, the electronic device may request, from the server, data required for displaying the first page through the first request.

Step S203: the server receives a first request.

Step S204: in response to the first request, the server sends first data of a first page to the electronic device, determines a first secondary database set from the plurality of secondary databases, acquires first target data from the first secondary database set, and creates a first list in the first primary database.

Specifically, the first list includes first target data, and the first secondary database set includes one or more secondary databases.

It should be noted that the server may be a cloud server, each of the plurality of secondary databases and the primary database may be a distributed database, the storage partition and the access address of different secondary databases may be different, and the storage partition and the access address of the primary database may be different from the storage partition and the access address of the secondary database.

For example, assuming the first page is an agent project management page, the first list may be an agent project list, which may include, but is not limited to, one or more of agent name, agent responsible person information, customer name, area, industry, project name, project product quantity, project responsible person, project team member.

Step S205: the electronic device receives the first data and displays a first page.

Specifically, after the electronic device receives the first data, the first page may be displayed based on the first data, but since the first data does not include the target data in the first list at this time, the first page displayed by the electronic device at this time does not include the first list.

Step S206: the electronic device sends a second request to the server.

Specifically, the electronic device may request the server for data required for displaying the first page again through the second request.

Step S207: the server receives and responds to the second request by sending the first list to the electronic device.

Step S208: the electronic device displays a first list on a first page.

In the embodiment of the application, the server can generate the main database first and load the data from different data sources in the list page to the main database in advance from the plurality of auxiliary databases, when a user requests to view the list page, the server can directly acquire the data in the list page from the main database, and the main database is generated asynchronously, so that the required data do not need to be acquired from the plurality of auxiliary databases one by one after the request is received, thereby improving the list query efficiency.

In some embodiments, the electronic device is associated with a vendor client, as shown in fig. 3a, the first page is an agent project management page, the first set of secondary databases includes one or more of an agent information database (which may be one of a plurality of secondary databases), an agent customer information database (which may be one of a plurality of secondary databases), an agent project information database (which may be one of a plurality of secondary databases), and the first target data includes one or more of an agent name, agent responsible person information, a customer name, an area, an industry, a project name, a project product quantity, a project responsible person, a project team member; the agent information database includes, but is not limited to, agent names, agent responsible person information, etc.; agent customer information databases including, but not limited to, customer name, area, industry, etc.; the agent project information database includes, but is not limited to, project names, project product amounts, project principals, project team members, and the like.

Specifically, the electronic device may display an interface 90, and the user may click on the agent item list on the interface 90 to open an agent item management page, which may facilitate the vendor to manage sales items for one or more agents. After the electronic device receives and responds to the operation of opening the agent project management page by the user, a first request can be sent to the server. The server receives the first request and, in response to the first request, the server may send first data of the agent project management page to the electronic device while determining a first set of secondary databases from the plurality of secondary databases and obtaining first target data from the first set of secondary databases, creating a first list (i.e., an agent project list) in the first primary database. Further, the electronic device receives the first data and displays the agent project management page, and the electronic device may display the agent project management page first, but does not display the first list in the first data at this time, because the target data in the first list is not included in the first data at this time. The electronic device may send a second request to the server, the server receiving and responding to the second request, and sending the first list to the electronic device, at which time the electronic device displays the data in the first list on the agent project management page. Because the server can firstly load the data from different auxiliary databases included in the first list into the first main database in advance, when a user requests to view the agent project management page, the server can directly acquire target data included in the first list from the first main database without acquiring required data from a plurality of auxiliary databases one by one, thereby improving the list query efficiency.

In some embodiments, the electronic device is associated with a vendor client, as shown in fig. 3b, the first page is a camping project management page, the first set of secondary databases includes a camping customer information database, a camping project information database, and the first target data includes one or more of a customer name, an area, an industry, a project name, a project product quantity, a project responsible person, a project team member; the camping customer information database includes, but is not limited to, customer name, area, industry, etc.; the camping project information database includes, but is not limited to, project names, project product numbers, project principals, project team members, and the like.

Specifically, the electronic device may display the interface 91, and the user may click on the camping project management page on the interface 91 to open the camping project management page, so that the provider may manage the marketing project. After the electronic device receives and responds to the operation of opening the camping project management page by the user, a first request can be sent to the server. The server receives the first request, and in response to the first request, the server may send first data of the camping project management page to the electronic device, while determining a first set of secondary databases from the plurality of secondary databases, and obtaining first target data from the first set of secondary databases, and creating a first list (i.e., a camping project list) in the first primary database. Furthermore, the electronic device receives the first data and displays the camping project management page, and the electronic device can display the blank camping project management page first because the first data does not include the target data in the first list. The electronic device sends a second request to the server, the server receives and responds to the second request, and the first list is sent to the electronic device, and at the moment, the electronic device displays data in the first list on the camping project management page. Because the server can firstly load the data from different auxiliary databases included in the first list into the first main database in advance, when a user requests to view the camping project management page, the server can directly acquire target data included in the first list from the first main database without acquiring required data from a plurality of auxiliary databases one by one, thereby improving the list query efficiency.

In some embodiments, the electronic device is associated with a vendor client, as shown in fig. 3c, the first page is an agent sample application list interface (i.e., interface 92), the first set of secondary databases includes an agent information base, an agent client information base, an agent applied sample information base, and the first target data includes, but is not limited to, one or more of an agent name, a client name, an associated item, a sample number, a sample status, an approval status, an application date, and an agent responsible person. The agent information base may include, but is not limited to, an agent name, an agent responsible person, etc.; agent customer information bases include, but are not limited to, customer name, area, industry, etc.; sample information bases applied by agents include, but are not limited to, sample number, sample status, approval status, date of application, and the like.

In some embodiments, where the electronic device is associated with a vendor client, as shown in fig. 3d, the first page is a camping sample application listing interface (i.e., interface 93), and the first set of secondary databases may include a camping customer information base, a camping sample application information base. The first target data includes, but is not limited to, one or more of customer name, associated item, sample number, sample status, approval status, date of application, order responsible person. The camping customer information base includes, but is not limited to, customer name, area, industry, etc.; the direct-nutrient sample application information base comprises, but is not limited to, sample numbers, sample states, approval states, application dates, order responsible persons and the like.

In some embodiments, the electronic device may be the electronic device 101 or the electronic device 102 in fig. 1a, and the server may be the server 103; the electronic device may also be the electronic device 111 or the electronic device 112 in fig. 1b, and the server may be the server 113 or the server 114; the electronic device may also be the electronic device 121 in fig. 1c, and the server may be the server 122.

As shown in fig. 4, fig. 4 shows a flow of querying another list data in the application scenario, which is described in detail as follows:

step S301: the server creates a second master database of the second page.

Specifically, the second main database and the first main database are different databases.

Step S302: the electronic device receives and responds to the operation of opening the second page by the user, and sends a third request to the server.

Specifically, the electronic device may request, from the server, data required for displaying the second page through the third request.

Step S303: the server receives and responds to the third request, sends second data of a second page to the electronic equipment, determines a second secondary database set from the plurality of secondary databases, acquires second target data from the second secondary database set, and creates a second list in the second primary database.

Specifically, the second list includes second target data and the second set of secondary databases includes one or more secondary databases.

For example, when the second page is a purchase order page, the second list may be a purchase order list, which may include, but is not limited to, one or more of agent name, agent responsible person information, customer name, area, industry, associated sales items, order status, total number of orders, order date.

Step S304: the electronic device receives the second data and displays a second page.

Specifically, after the electronic device receives the second data, the second page may be displayed based on the second data, but since the second data does not include the target data in the second list at this time, the second page displayed by the electronic device at this time does not include the second list.

Step S305: the electronic device sends a fourth request to the server.

Specifically, the electronic device may request the server for data required for displaying the second page again through the fourth request.

Step S306: the server receives and responds to the fourth request by sending the second list to the electronic device.

Step S307: the electronic device displays a second list on a second page.

In some embodiments, as shown in FIG. 5, the second page may be a purchase order page, the second set of secondary databases including one or more of an agent information database, an agent customer information database, an agent purchase order information database, second target data including, but not limited to, a purchase order number, an agent name, agent responsible person information, a customer name, an area, an industry, an associated sales item, an order status, an order total, an order date; the agent information database includes, but is not limited to, agent names, agent responsible person information, etc.; agent customer information databases including, but not limited to, customer name, area, industry, etc.; the agent purchase order information database includes, but is not limited to, associated sales items, order status, total number of orders, order date, and the like.

Specifically, the electronic device may display an interface 94 and the user may click on the purchase order page on the interface 94 to open the purchase order page, which may facilitate the provider to manage the purchase orders of one or more agents. After the electronic device receives and responds to the operation of opening the purchase order page by the user, a third request can be sent to the server. The server receives the third request, and in response to the third request, the server may send second data of the purchase order page to the electronic device, while determining a second set of secondary databases from the plurality of secondary databases, and obtaining second target data from the second set of secondary databases, creating a second list (i.e., a purchase order list) in the second primary database. Further, the electronic device receives the second data and displays the purchase order page, and the electronic device may display the purchase order page first, in which case the purchase order page does not display the second list, because the second data does not include the target data in the second list. The electronic device may send a fourth request to the server, the server receives and responds to the fourth request by sending a second list to the electronic device, at which point the electronic device displays the data in the second list on the purchase order page. Because the server can firstly load the data from different auxiliary databases included in the second list into the second main database in advance, when a user requests to view the purchase order page, the server can directly acquire target data included in the second list from the second main database without acquiring required data from a plurality of auxiliary databases one by one, thereby improving the list query efficiency. In addition, in the embodiment of the application, different main databases can be created for different pages, and each main database stores all data required for displaying one page, so that interfaces required to be checked by a user can be displayed on electronic equipment more quickly, and the user experience is improved.

As shown in fig. 6, fig. 6 shows a flow of displaying sub-pages in the application scenario, where the first page is associated with a third page, and the third page is a sub-page of the first page, which is described in detail below:

step S401: in response to the first request, the server determines a third secondary database set corresponding to the third page from the plurality of secondary databases, acquires third target data from the third secondary database set, and creates a third list in the first primary database.

Specifically, the third list includes third target data, and the third secondary database set includes one or more secondary databases.

Step S402: the electronic device receives and responds to the operation of opening the third page by the user, and sends a fifth request to the server.

Specifically, the electronic device may request, from the server, data required for displaying the third page through the fifth request.

Step S403: the server receives and responds to the fifth request, and sends third data of a third page to the electronic device.

Specifically, the third data includes a third list. For example, when the first page is a camping project management page and the third page is a target camping project detail page, the third list may be a detail information list of the target camping project, where the third list may include, but is not limited to, one or more of customer name, area, industry, project name, project product number, project responsible person, project team member, project product name, project product progress, project product number, project description, project product information, sample application state information, sales offer information, price application information, and logistics information.

Step S404: and after receiving the third data, the electronic equipment displays a third page and displays a third list on the third page.

Specifically, as shown in fig. 3a, assuming that the first page is an agent project management page, the user may click on a control corresponding to the "blacksub project" on the interface 90, and then execute the above steps S401 to S404, and the interface 95 shown in fig. 7a may be displayed on the electronic device. In this scenario, the third set of databases may include one or more of an agent information database, an agent customer information database, an agent project information database, and third target data including, but not limited to, an agent name, agent responsible person information, a customer name, an area, an industry, a project name, a project product quantity, a project responsible person, a project team member, a project product name, a project product schedule, a project product quantity, and a project description. In the embodiment of the application, the data included in the sub-page of the first page can be stored in the first main database, so that after the user opens the first page on the electronic device, if the user needs to view the sub-page, the server can directly acquire the data required by displaying the sub-page from the first main database, and the electronic device can display the sub-page more quickly, thereby improving user experience.

As further shown in fig. 3b, assuming that the first page is a camping project management page, the user may click on the control corresponding to the "new energy automobile project" on the interface 91, and then may execute the above steps S401 to S404, and may display the interface 96 shown in fig. 7b on the electronic device. In this scenario, the third set of databases may include one or more of a direct marketing customer information database, a direct marketing project status database, and third target data including, but not limited to, customer name, area, industry, project name, project product quantity, project responsible person, project team member, project product name, project product progress, project product quantity, project description, project product information, sample application status information, sales offer information, price application information, and logistics information. The camping customer information database may include, but is not limited to, customer name, area, industry, etc.; the camping project information database may include, but is not limited to, one or more of project names, project product numbers, project principals, project team members, project product names, project product schedules, project product numbers, project descriptions, project product information; the camping project status database may include, but is not limited to, one or more of sample application status information, sales offer information, price application information, and logistical information. In the embodiment of the application, the data included in the sub-page of the first page can be stored in the first main database, so that after the user opens the first page on the electronic device, if the user needs to view the sub-page, the server can directly acquire the data required by displaying the sub-page from the first main database, and the electronic device can display the sub-page more quickly, thereby improving user experience.

As shown in fig. 8, fig. 8 shows a flow of refreshing a page in the application scenario, and after the electronic device displays the first list on the first page, the page may be refreshed, which is described in detail as follows:

step S501: the electronic device receives and responds to the operation of refreshing the first page by a user, and sends a first request to the server.

For example, a refresh control may be included on a first page displayed by the electronic device, and after the user clicks the refresh control, the electronic device may send a first request to the server to refresh the page content.

Step S502: the server receives a first request.

Step S503: in response to the first request, the server retrieves the first target data from the first set of secondary databases, updates the first list in the first primary database, and sends the updated first list to the electronic device.

Specifically, the updated first list includes the retrieved first target data.

Step S504: and after receiving the updated first list, the electronic equipment displays the updated first list on the first page.

For example, as shown in fig. 9, after the electronic device receives the updated first list, such as related information of the newly added agent 5, is displayed on the agent project management page.

Specifically, the server can actively update the main database according to the period, that is, the server can acquire the target data from the secondary database set according to the period, and further update the first list based on the acquired target data, so that the server can send the updated list to the electronic device, the electronic device can automatically refresh the page content, and user experience is improved.

Specifically, the page can be divided into a first type and a second type according to the update speed of the page content, and the update speed of the page content of the first type is faster than that of the page content of the second type, so that if the page is of the first type, the server can acquire the target data again from the secondary database set according to a first period (a period with a shorter time interval), and the displayed page content can be updated based on the acquired target data; if the page is of the second type, the server may retrieve the target data from the secondary database set according to the second period (a period with a longer time interval), and then update the displayed page content based on the retrieved target data. It should be noted that, the faster the page content update speed is, the shorter the period time interval is; the slower the page content update speed, the longer the time interval of the period.

Specifically, the secondary database set may include at least two target secondary databases, which may be a first target secondary database and a second target secondary database, respectively, where it is assumed that the data stored in the first target secondary database is updated faster, for example, the first target secondary database may be a sample information database, and sample logistics information updated faster is stored in the database; the update speed of the data stored in the second target auxiliary database is slower, for example, the second target auxiliary database can be a customer information database, the customer information stored in the database is basically unchanged, and the update speed is slower. The server can set different time intervals (i.e. periods) according to the data updating speeds of different auxiliary databases to actively update the information stored in the main database, namely the data updating speed of the auxiliary databases is higher, and can set shorter time intervals to update the information stored in the main database; the data updating speed of the auxiliary database is slower, and a longer time interval can be set to update the information stored in the main database, so that the updating frequency of the data in the main data is optimized.

Fig. 10 is a schematic structural diagram of an electronic device 1000 according to an embodiment of the present application. As shown in fig. 10, the electronic device 1000 includes a processor 1001 and a transceiver 1002 and a display screen 1003 in communication with the processor's internal connections. The processor 1001 is a general-purpose processor, a special-purpose processor, or the like. For example, a baseband processor or a central processing unit. The baseband processor may be used to process communication protocols and communication data, and the central processor may be used to control the electronic device, execute the computer program, and process the data of the computer program. The transceiver 1002 may be referred to as a transceiver unit, a transceiver circuit, or the like, for implementing a transceiver function. The transceiver 1002 may include a receiver, which may be referred to as a receiver or a receiving circuit, etc., for implementing a receiving function; the transmitter may be referred to as a transmitter or a transmitting circuit, etc., for implementing a transmitting function.

Optionally, the electronic device 1000 may include one or more memories 1004, on which instructions may be stored, which may be computer programs that may be executed on the electronic device 1000, so that the electronic device 1000 performs the methods described in the method embodiments above. Optionally, the memory 1004 may also have data stored therein. The electronic device 1000 and the memory 1004 may be provided separately or may be integrated. The processor 1001, the transceiver 1002, the display screen 1003, and the memory 1004 may be connected by a communication bus.

In some embodiments, the electronic device 1000 may be the electronic device 101 or the electronic device 102 in the embodiment shown in fig. 1a described above; the electronic device 1000 may also be the electronic device 111 or the electronic device 112 in the embodiment shown in fig. 1b described above; the electronic device 1000 may also be the electronic device 121 in the embodiment shown in fig. 1c described above.

Fig. 11 is a schematic structural diagram of a server 1100 according to an embodiment of the present application. As shown in fig. 11, the server 1100 includes a processor 1101 and a transceiver 1102 in communication with the processor's internal connections. The processor 1101 is a general-purpose processor, a special-purpose processor, or the like. For example, a baseband processor or a central processing unit. The baseband processor may be used to process communication protocols and communication data, and the central processor may be used to control the electronic device, execute the computer program, and process the data of the computer program. The transceiver 1102 may be referred to as a transceiver unit, a transceiver circuit, or the like, for implementing a transceiver function. The transceiver 1102 may include a receiver, which may be referred to as a receiver or a receiving circuit, etc., for implementing a receiving function; the transmitter may be referred to as a transmitter or a transmitting circuit, etc., for implementing a transmitting function.

Alternatively, the server 1100 may include one or more memories 1103, on which instructions, which may be computer programs, may be stored, which may be executed on the server 1100, so that the server 1100 performs the methods described in the above method embodiments. Optionally, the memory 1103 may also have data stored therein. The server 1100 and the memory 1103 may be provided separately or may be integrated. The processor 1101, transceiver 1102, and memory 1103 may be connected by a communication bus. In some embodiments, the server 1100 may be the server 103 in the embodiment shown in FIG. 1a described above; server 1100 may also be server 113 or server 114 in the embodiment shown in fig. 1b described above; the server 1100 may also be the server 122 in the embodiment shown in fig. 1c described above.

The embodiment of the application also provides a server, which comprises one or more functional units, wherein the one or more functional units are used for executing the method steps described in the embodiment of the method.

The embodiment of the application also provides electronic equipment, which comprises one or more functional units, wherein the one or more functional units are used for executing the method steps described in the embodiment of the method.

Embodiments of the present application also provide a computer readable storage medium having stored therein computer program code which, when executed by the above-mentioned processor, causes an electronic device to perform the method of any of the previous embodiments.

The embodiment of the application also provides a communication device which can exist in the form of a chip product, and the structure of the device comprises a processor and an interface circuit, wherein the processor is used for communicating with other devices through a receiving circuit, so that the device executes the method in any of the previous embodiments.

The above embodiments are only for illustrating the technical solution of the present application, and are not limiting; although the application has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A data query method, applied to a communication system, the communication system including an electronic device and a server, the server storing a plurality of sub databases, the types of data in different sub databases being different, the method comprising:

The server creates a first main database of a first page;

the electronic equipment receives and responds to the operation of opening the first page by a user, and sends a first request to the server;

the server receives the first request;

in response to the first request, the server sends first data of the first page to the electronic device, determines a first secondary database set from the plurality of secondary databases, acquires first target data from the first secondary database set, creates a first list in the first main database, wherein the first list comprises the first target data, and the first secondary database set comprises one or more secondary databases;

the electronic equipment receives the first data, displays the first page and sends a second request to the server;

the server receives and responds to the second request and sends the first list to the electronic equipment;

the electronic device displays the first list on the first page.

2. The method of claim 1, wherein the method further comprises:

the server creates a second main database of a second page;

The electronic equipment receives and responds to the operation of opening the second page by a user, and sends a third request to the server;

the server receives and responds to the third request, sends second data of the second page to the electronic equipment, determines a second auxiliary database set from the plurality of auxiliary databases, acquires second target data from the second auxiliary database set, creates a second list in the second main database, wherein the second list comprises the second target data, and the second auxiliary database set comprises one or more auxiliary databases;

the electronic equipment receives the second data, displays the second page and sends a fourth request to the server;

the server receives and responds to the fourth request and sends the second list to the electronic equipment;

the electronic device displays the second list on the second page.

3. The method of claim 1 or 2, wherein the first page has associated therewith a third page, the third page being a sub-page of the first page, the method further comprising:

in response to the first request, the server determines a third secondary database set corresponding to the third page from the plurality of secondary databases, acquires third target data from the third secondary database set, and creates a third list in the first main database, wherein the third list comprises the third target data, and one or more secondary databases are included in the third secondary database set;

The electronic equipment receives and responds to the operation of opening the third page by a user, and a fifth request is sent to the server;

the server receives and responds to the fifth request and sends third data of the third page to the electronic equipment, wherein the third data comprises the third list;

and after receiving the third data, the electronic equipment displays the third page and displays the third list on the third page.

4. The method of any of claims 1-3, wherein after the electronic device displays the first list on the first page, the method further comprises:

the electronic equipment receives and responds to the operation of refreshing the first page by a user, and sends the first request to the server;

the server receives the first request;

in response to the first request, the server re-acquires the first target data from the first secondary database set, updates the first list in the first primary database, and sends the updated first list to the electronic device, wherein the updated first list comprises the re-acquired first target data;

And after receiving the updated first list, the electronic equipment displays the updated first list on the first page.

5. A method as recited in any of claims 1-3, wherein after the server receives and transmits the first list to the electronic device in response to the second request, the method further comprises:

the server re-acquires the first target data from the first secondary database set according to the period;

the server updates the first list based on the re-acquired first target data and sends the updated first list to the electronic equipment, wherein the updated first list comprises the re-acquired first target data;

6. The method of claim 5, wherein the server re-acquiring the first target data from the first set of secondary databases on a periodic basis, comprises:

when the page type of the first page is a first type, the server re-acquires the first target data from the first auxiliary database set according to a first period;

When the page type of the first page is the second type, the server re-acquires the first target data from the first auxiliary database set according to a second period; the first type is different from the second type, and the first period is different from the second period.

7. The method of claim 5, wherein the first set of secondary databases includes a first target secondary database and a second target secondary database, the server retrieving the first target data from the first set of secondary databases on a periodic basis, comprising:

the server re-acquires a first part of data in the first target data from the first target auxiliary database in a third period;

the server re-acquires second partial data in the first target data from the second target auxiliary database in a fourth period; the update speed of the first target secondary database is different from the update speed of the second target secondary database, and the third period is different from the fourth period.

8. The method of any of claims 1-7, wherein the electronic device is associated with a vendor client, the first page is an agent project management page, the first set of secondary databases includes an agent information database, an agent customer information database, an agent project information database, the first target data includes one or more of agent name, agent responsible person information, customer name, area, industry, project name, project product quantity, project responsible person, project team member; the agent information database comprises agent names and agent responsible person information; the agent client information database comprises a client name, an area and an industry; the agent project information database comprises project names, project product quantity, project responsible persons and project team members.

9. The method of any of claims 1-7, wherein the electronic device is associated with a vendor client, the first page is a camping project management page, the first set of secondary databases comprises a camping customer information database, a camping project information database, and the first target data comprises one or more of a customer name, an area, an industry, a project name, a project product quantity, a project principal, a project team member; the direct-camping client information database comprises a client name, an area and an industry; the direct camping project information database comprises project names, project product quantity, project responsible persons and project team members.

10. A communication system comprising an electronic device and a server, wherein the server stores a plurality of secondary databases, and the types of data in different secondary databases are different;

the server is used for creating a first main database of a first page;

the electronic equipment is used for receiving and responding to the operation of opening the first page by a user and sending a first request to the server;

the server is further configured to receive the first request;

In response to the first request, the server is further configured to send first data of the first page to the electronic device, determine a first secondary database set from the plurality of secondary databases, obtain first target data from the first secondary database set, and create a first list in the first primary database, where the first list includes the first target data, and the first secondary database set includes one or more secondary databases;

the electronic equipment is also used for receiving the first data, displaying the first page and sending a second request to the server;

the server is further configured to receive and respond to the second request, and send the first list to the electronic device;

the electronic device is further configured to display the first list on the first page.