CN112445873B - List display processing method, related device, equipment and medium - Google Patents
List display processing method, related device, equipment and medium Download PDFInfo
- Publication number
- CN112445873B CN112445873B CN202011390918.3A CN202011390918A CN112445873B CN 112445873 B CN112445873 B CN 112445873B CN 202011390918 A CN202011390918 A CN 202011390918A CN 112445873 B CN112445873 B CN 112445873B
- Authority
- CN
- China
- Prior art keywords
- sorting
- list
- values
- data
- value
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 21
- 238000012545 processing Methods 0.000 claims description 31
- 238000000034 method Methods 0.000 claims description 29
- 238000004590 computer program Methods 0.000 claims description 15
- 238000004891 communication Methods 0.000 description 15
- 238000010586 diagram Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 8
- 238000012423 maintenance Methods 0.000 description 7
- 230000003287 optical effect Effects 0.000 description 7
- 230000004044 response Effects 0.000 description 4
- 230000003068 static effect Effects 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000001514 detection method Methods 0.000 description 3
- 230000003190 augmentative effect Effects 0.000 description 2
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012797 qualification Methods 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000000903 blocking effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 239000000470 constituent Substances 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 230000000149 penetrating effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000001356 surgical procedure Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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
- G06F16/2453—Query optimisation
-
- 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/26—Visual data mining; Browsing structured data
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the application discloses a list display processing method, which comprises the following steps: receiving a list display instruction; requesting list data from a server according to the list display instruction; wherein the original data of the requested list data is in a plurality of fields of a plurality of different database tables; receiving list data returned by a server; the returned list data is the list data selected by the server according to the maintained sorting value table; the ordering value table is a field and comprises a plurality of ordering values; the ordering value is obtained by respectively generating corresponding values for a plurality of fields of a plurality of different database tables by the server, and then splicing each value according to an ordering rule; and displaying the list according to the list data. The technical problem that the database is easy to be blocked when the database queries the data in the prior art can be well solved.
Description
Technical Field
The present disclosure relates to the field of internet technologies, and in particular, to a list display processing method, a list display processing device, a list display processing apparatus, and a computer readable storage medium.
Background
With the rapid development of computer network computing, especially the development of the mobile internet, the mobile internet is gradually penetrating into various fields of people's life and work. The user can complete various transactions by only installing various application programs on the electronic equipment according to the own requirements.
In a mobile terminal, such as a smart phone, a user often needs to request a server to display some list data during use of each application platform or software. For example, based on instant messaging software or platform, when a user refreshes or displays a user list, a server receives a list data request and then queries a database for list data corresponding to the user initiating the request.
In the prior art, when JAVA realizes multi-table sorting and complex sorting logic query of a MySql database, the query is usually performed simply by means of structured query language (Structured Query Language, SQL) of the database, but the database is stressed due to the large data volume. In particular to multi-condition ordering rules, when each rule comes from a stationary database table, database blocking is easily caused by SQL query in the prior art when the database user quantity reaches more than a million levels.
Disclosure of Invention
The embodiment of the application provides a list display processing method, a list display processing device, list display processing equipment and a computer readable storage medium, which can well solve the technical problem that a database is easy to be blocked when the database queries data in the prior art.
In a first aspect, an embodiment of the present application provides a list display processing method, where the method includes:
receiving a list display instruction;
requesting list data from a server according to the list display instruction; wherein the original data of the requested list data is in a plurality of fields of a plurality of different database tables;
receiving list data returned by the server; the returned list data are list data selected by the server according to the maintained sorting value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting value is obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule;
and displaying a list according to the list data.
In one possible implementation, the list display instruction is used to indicate entering a target page; the target page comprises a list for displaying the ordering of a plurality of different objects;
one sorting value in the sorting value table corresponds to one object; different ranking values correspond to different objects.
In a second aspect, an embodiment of the present application provides a list display processing method, including:
Generating and maintaining a ranking value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting value is obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule;
receiving a list data request sent by a terminal;
selecting list data according to the sorting value table;
and sending the selected list data to the terminal.
In one possible implementation, the list display instruction is used to indicate entering a target page; the target page comprises a list for displaying the ordering of a plurality of different objects;
one sorting value in the sorting value table corresponds to one object; different ranking values correspond to different objects.
In one possible implementation, the N fields of the plurality of different database tables generate corresponding N values; the sorting value is a value obtained by splicing the N values;
the generating and maintaining a ranking value table includes: when a target sorting value set exists, splicing a random number behind each sorting value in the target sorting value set; wherein the target ranking value set consists of ranking values with the same numerical value.
In one possible implementation, the number of digits x of the random number is related to the number of ranking values y in the target set of ranking values, where x=z+1; and z is the number of bits of the y.
In one possible implementation, the plurality of fields of the plurality of different database tables include: whether within an application, online type, idle, authentication condition, perfect profile condition, good rating, last video or voice ending time point of a user, whether an IOS user.
In a third aspect, an embodiment of the present application provides a list display processing apparatus, including:
an instruction receiving unit configured to receive a list display instruction;
a request unit for requesting list data from a server according to the list display instruction; wherein the original data of the requested list data is in a plurality of fields of a plurality of different database tables;
the data receiving unit is used for receiving list data returned by the server; the returned list data are list data selected by the server according to the maintained sorting value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting value is obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule;
And the display unit is used for displaying the list according to the list data.
In one possible implementation, the list display instruction is used to indicate entering a target page; the target page comprises a list for displaying the ordering of a plurality of different objects;
one sorting value in the sorting value table corresponds to one object; different ranking values correspond to different objects.
In a fourth aspect, an embodiment of the present application provides a list display processing apparatus, including:
the generation and maintenance unit is used for generating and maintaining the sorting value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting value is obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule;
a request receiving unit, configured to receive a list data request sent by a terminal;
a data selecting unit, configured to select list data according to the ranking value table;
and the data transmitting unit is used for transmitting the selected list data to the terminal.
In one possible implementation, the list display instruction is used to indicate entering a target page; the target page comprises a list for displaying the ordering of a plurality of different objects;
One sorting value in the sorting value table corresponds to one object; different ranking values correspond to different objects.
In one possible implementation, the N fields of the plurality of different database tables generate corresponding N values; the sorting value is a value obtained by splicing the N values;
the generation and maintenance unit is specifically configured to: when a target sorting value set exists, splicing a random number behind each sorting value in the target sorting value set; wherein the target ranking value set consists of ranking values with the same numerical value.
In one possible implementation, the number of digits x of the random number is related to the number of ranking values y in the target set of ranking values, where x=z+1; and z is the number of bits of the y.
In one possible implementation, the plurality of fields of the plurality of different database tables include: whether within an application, online type, idle, authentication condition, perfect profile condition, good rating, last video or speech ending time point of a user, whether a mobile operating system (IOS) user developed by apple company.
In a fifth aspect, an embodiment of the present application provides a list display processing apparatus, where the list display processing apparatus includes a processor and a memory, where the memory is used for a program, the processor executes the program stored in the memory, and when the program stored in the memory is executed, the processor is used to execute a list display processing method provided in any implementation manner of the first aspect or the second aspect.
In a sixth aspect, embodiments of the present application provide a computer readable storage medium storing a computer program, the computer program including program instructions that, when executed by a processor, cause the processor to perform a list display processing method provided by any one of the implementation manners of the first aspect.
In a seventh aspect, embodiments of the present application further provide a computer program, where the computer program includes program instructions, where the program instructions when executed by a processor cause the processor to perform the list display processing method provided in any one of the implementation manners of the first aspect.
According to the embodiment of the application, list data selected by the server according to the maintained sorting value table; the ordering value table is a field and comprises a plurality of ordering values; the ordering value is obtained by respectively generating corresponding values for a plurality of fields of a plurality of different database tables by the server, and then splicing each value according to an ordering rule; that is to say, the server can uniformly maintain each ordering rule into an ordering value so as to count multiple tables and multiple fields of the MySql database into one field, thereby greatly optimizing the query time of SQL, and solving the technical problem that the database is easy to be blocked when the user quantity of the database reaches more than one million grades because the data quantity is very large in the prior art and causes great pressure on the database, in particular to the multi-condition ordering rules and all the rules are from the motionless database table. The database inquiry pressure is greatly reduced, the inquiry speed is greatly improved, and the user can use the product more smoothly.
In addition, when the target sorting value set exists, each sorting value in the target sorting value set is spliced with a random number; wherein the target ranking value set consists of ranking values of the same value. The database query method and the database query system have the advantages that the database query can be efficiently performed, the problem that repeated list data are easy to occur when the list data are refreshed under the condition that the user data are fewer is avoided, the user experience is improved, and the use viscosity of the user to products is increased.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the description of the embodiments will be briefly described below.
FIG. 1 is a schematic diagram of a system architecture of a list explicit processing method provided in the present application;
fig. 2 is a schematic flow chart of a list display processing method provided in an embodiment of the present application;
fig. 3 is a schematic structural diagram of a list display processing apparatus provided in an embodiment of the present application;
FIG. 4 is a schematic diagram of a list display processing apparatus according to another embodiment of the present application;
fig. 5 is a schematic structural diagram of a list display processing apparatus provided in an embodiment of the present application;
fig. 6 is a schematic structural view of a list display processing apparatus according to another embodiment provided in the present application.
Detailed Description
The following description of the technical solutions in the embodiments of the present application will be made with reference to the drawings in the embodiments of the present application, and it is apparent that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present disclosure.
It should be understood that the terms "comprises" and "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It is also to be understood that the terminology used in the description of the present application is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in this specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes such combinations.
As used in this specification and the appended claims, the term "if" may be interpreted as "when..once" or "in response to a determination" or "in response to detection" depending on the context. Similarly, the phrase "if a determination" or "if a [ described condition or event ] is detected" may be interpreted in the context of meaning "upon determination" or "in response to determination" or "upon detection of a [ described condition or event ]" or "in response to detection of a [ described condition or event ]".
For a better understanding of the present application, a network architecture to which the present application applies is described below. Referring to fig. 1, fig. 1 is a schematic system architecture diagram of a list display processing method provided in the present application. As shown in fig. 1, the system architecture may include:
the server 101 may be a background server of an application. Such as instant messaging software or a management server of the platform. Instant messaging software primarily refers to a series of functions associated with instant messaging services, such as online chat, online live, etc., provided by a software or platform operator. Applications in embodiments of the present application include, but are not limited to, instant messaging software.
Terminal 103 may refer to a user-side terminal. The terminal 103 may be installed and run with a client, such as an instant messaging client. The user can register an account through the client side and perform instant communication with other users.
In the embodiment of the invention, the client side refers to a program corresponding to the server and providing local service for the client. Here, the local service may include, but is not limited to: man-machine interaction services, local data acquisition and maintenance services, communication services between local and server, etc.
Specifically, the client may include: locally running applications, functions running on a Web browser (also known as Web App), applets embedded in email, applets embedded in client software for instant messaging (e.g., weChat), and functions embedded in other applications (e.g., weChat) (e.g., weChat public numbers), etc. For clients, a corresponding server program needs to be run on the server to provide corresponding services, such as database services, data calculation, decision execution, and the like.
The terminal referred to in the embodiments of the present application may also be referred to as a User Equipment (UE), a Mobile Station (MS), a Mobile Terminal (MT), etc., and is a device that provides voice/data connectivity to a user, for example, a handheld device with a wireless connection function, a vehicle-mounted device, etc. Examples of some terminals are: a mobile phone, a tablet, a notebook, a palm, a mobile internet device (mobile internet device, MID), a wearable device, a Virtual Reality (VR) device, an augmented reality (augmented reality, AR) device, a wireless terminal in industrial control (industrial control), a wireless terminal in unmanned (self driving), a wireless terminal in teleoperation (remote medical surgery), a wireless terminal in smart grid (smart grid), a wireless terminal in transportation security (transportation safety), a wireless terminal in smart city (smart city), a wireless terminal in smart home (smart home), a vehicle containing a cockpit domain controller, and the like.
In the embodiment of the application, the instant messaging software is taken as an example for explanation, the instant messaging software is installed on the terminal, the user starts the instant messaging software by using the terminal, and can log in to the interface of the instant messaging software after registering, and when the user enters the target page of the instant messaging software, the user list information of other logged-in users can be displayed. The process is realized by the data interaction between the terminal side client and the server, wherein the displayed list is the list which is needed to be obtained through database query. The following description is made with reference to a flowchart of a list display processing method provided in the embodiment of the present application and shown in fig. 2, where how the list display processing method provided in the present application implements database query may include the following steps:
step S200: generating and maintaining a ranking value table;
specifically, the ranking value table in the embodiment of the present application is a field, and may include a plurality of ranking values; the sorting values are obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule.
According to the method and the server, the multiple tables and the multiple fields of the database are counted into one field in one database table by means of generating and maintaining the ordering value table, so that the query time of SQL (structured query language) can be greatly optimized, and the technical problem that the database is stressed greatly due to the fact that the data size is very large in the prior art is solved.
For example:
as shown in table 1 below, if there are 8 dimensions:
TABLE 1
The data corresponding to the dimension is the original data of the list data to be requested by the subsequent client. When the subsequent server selects list data, the list data is selected according to the data corresponding to the 8 dimensions.
The data corresponding to the different dimensions are in different database tables, or at least the data corresponding to the two dimensions are in different database tables. For example, if dimension 1 "is in the application" corresponding data (i.e., indicates yes or no) in database table 1, dimension 2 "on-line type" corresponding data (i.e., indicates time-frequency on-line, voice on-line, or private on-line) in database table 2, dimension 3 "is idle" corresponding data in database table 3, dimension 4 "authentication case" corresponding data in database table 4, dimension 5 "perfect material" corresponding data in database table 5, dimension 6 "good score" corresponding data in database table 6, dimension 7 "last video or voice end time" corresponding data in database table 7, and dimension 8 "is IOS user" corresponding data in database table 8; for another example, dimension 1 and dimension 2 are in database table 1, and dimension 3 through dimension 8 are in database table 3 through database table 8, respectively. Etc.
Then, the plurality of fields of the plurality of different database tables in the embodiment of the present application may include: whether within an application, online type, idle, authentication condition, perfect profile condition, good rating, last video or voice ending time point of a user, whether an IOS user.
The server of the embodiment of the application generates corresponding numerical values from a plurality of fields in the plurality of different database tables. For example, "whether in the application" is "and" no "(i.e., up state and down state) correspond to the values 2 and 1, respectively; in the "online type", the "video online", "voice online" and "private letter online" correspond to the values 11, 10 and 01, respectively; yes and no in "idle" correspond to data 2 and 1, respectively; in the authentication condition, according to the priority of head portrait authentication, identity authentication, academic authentication, professional authentication and most authentication, different values such as 100, 090, 080, 070 and … corresponding to different authentication conditions are respectively set; the values of 100, 080 and 060 are respectively corresponding to the complete data, the complete basic data of more than 80 percent and the complete other data or the complete basic data of less than 80 percent; the "good score rate" of the "good score rate of 100% -80%", "good score rate of 80% -70%" and "good score rate of below 70%" correspond to the values of 100, 080, 070 respectively; in the 'latest ending time point of the video or the voice', according to the priority recommendation of the user who ends the video and the voice within 30 minutes of the refreshing time point, different values such as 30, 10 and the like are respectively set; yes and no in the IOS user correspond to the values 2 and 1, respectively.
For different objects, i.e. different login accounts (corresponding to different users), respective corresponding ranking values are generated. For example, the object A (equivalent to the login account A) is currently in the application, the video is online and currently idle, and head portrait authentication, identity authentication, academic authentication and professional authentication are completed; the data are all perfect 100%, the qualification rate is 95%, and the latest video end point is within 30 minutes, so that the video end point is an IOS user. In addition, if each ranking value in the embodiment of the present application is obtained by stitching each numerical value according to the dimension (ranking rule) from left to right in table 1, the ranking value corresponding to the object a is 2112100100100302. For another example, the object B (equivalent to the login account A) is currently in the application, the video is online and currently idle, and head portrait authentication, identity authentication, academic authentication and professional authentication are completed; the data are all perfect 100%, the qualification rate is 77%, and the latest video end point is outside 30 minutes, so that the data are IOS users. Then object B corresponds to a ranking value of 2112100100080102.
The ranking value table generated and maintained by the server of the present application may be as follows in table 2:
| ranking value |
| 2112100100100302 |
| 2112100100080102 |
| … |
TABLE 2
One sorting value in the sorting value table corresponds to one object; different ranking values correspond to different objects. Generating N corresponding numerical values by N fields of the plurality of different database tables; the sorting value is a value obtained by splicing the N values. As in table 1 above, there are 8 fields (i.e., dimensions), then 8 values corresponding to the 8 fields are generated, as shown in the example above, with some values having a number of bits greater than 1 bit.
In one embodiment, the server may periodically update and maintain the ranking value table, such as by refreshing the status of each object every 5 minutes, and updating its corresponding ranking value in the ranking value table.
Step S202: receiving a list display instruction;
specifically, the list display instruction in the embodiment of the present application is used to indicate entering a target page; the target page includes a list for displaying an ordering of a plurality of different objects. For example, when a user runs instant messaging software through a terminal and an account logs in successfully and accesses a home page, the home page can be a target page, and the home page can display a user list, namely a list of other users or other accounts. Then the user's command to access the home page can be considered as a list explicit command, including a click-to-home command, a swipe-to-home command, etc. After receiving the list display instruction, the terminal executes step S204.
Step S204: requesting list data from a server according to the list display instruction;
specifically, the instant messaging software running on the terminal triggers sending a request to the server based on the list display instruction, the original data of the requested list data being in a plurality of fields of a plurality of different database tables, such as the data in table 1 above.
Step S206: receiving a list data request sent by a terminal;
specifically, the server receives a list data request sent by the terminal, and learns to select list data from the maintained ordering value table according to the list data request.
Step S208: selecting list data according to the sorting value table;
specifically, taking the list data of 8 dimensions in the above table 1 as an example, in the prior art, the server will sort according to the sorting rule (or sorting logic), and assume that the list data is obtained by sorting according to the dimensions from left to right in the above table 1, reading or querying the original data from the fields of different servers, and sorting according to the original data corresponding to each dimension. The obtained list data corresponds to each user account. If 90 ordered list data are obtained, the terminal loads 30 per refresh, then the terminal may present 30 per load (e.g., sliding refresh list) in order.
The technical means in the prior art is that multi-condition ordering rules are involved when a database is queried, all the rules are from a stationary database table, different database tables are queried once when list data are selected for each query, and the query efficiency is low; particularly when the data volume is large, a great pressure is caused on the database, and the database is easy to be blocked.
The server queries the selection list data according to the pre-generated and maintained sorting value table, and realizes unified maintenance of each sorting rule into a sorting value so as to count multiple tables and fields of the MySql database into one field, thereby greatly optimizing the query time of SQL.
It is understood that the ordering rules or ordering logic in embodiments of the present application may also be adjustable.
Step S210: sending the selected list data to the terminal;
specifically, the server transmits the selected list data to the terminal,
step S212: receiving list data returned by the server;
specifically, the list data returned by the server is received by the terminal in the embodiment of the application, which is the list data selected by the server according to the maintained sorting value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting value is obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule;
step S214: and displaying a list according to the list data.
Specifically, the terminal displays the list data in an interface of the running instant messaging software.
In one embodiment, if a plurality of ranking values are identical in the ranking value table maintained by the server, that is, if there is a target ranking value set (the target ranking value set is composed of ranking values with identical values), the ranking values with identical values may be arranged in an out-of-order manner. For example, 30 ranking values are the same, and then the 30 ranking positions occupy random positions every time a query is refreshed, so that the users displayed by the final terminal are different, and the users are more felt. As another example, there are 90 ranking values that are the same, and after the 90 ranking values are randomly located, the next 30 users' presentations will not appear for the previous 30 users each time 30 are loaded.
In one embodiment, when a plurality of sorting values are the same in the sorting value table maintained by the server, that is, when a target sorting value set exists, each sorting value in the target sorting value set may be spliced with a random number;
in one implementation, the number of bits x of the random number in the embodiment of the present application is related to the number of sorting values y in the target sorting value set, where x=z+1; and z is the number of bits of the y. That is, if there are 15 sorting values in the target sorting value set, that is, 15 are the same, 15 is 2 digits, then the number of digits of the random number is 3 digits. If the value before the random number is spliced in the target sequence value set is 2112100100080102, the value after splicing can be 2112100100080102rrr, r represents a random number, for example, the value after splicing can be 2112100100080102010, 2112100100080102201, 2112100100080102120 or the like.
According to the embodiment of the application, when the target sorting value set exists, each sorting value in the target sorting value set is spliced with a random number; wherein the target ranking value set consists of ranking values of the same value. The database query method and the database query system have the advantages that the database query can be efficiently performed, the problem that repeated list data are easy to occur when the list data are refreshed under the condition that the user data are fewer is avoided, the user experience is improved, and the use viscosity of the user to products is increased. Further, the number of digits x of the random number is related to the number of ranking values y in the target set of ranking values, where x = z +1; the z is the number of the y digits, which is obtained through specific research and analysis, and the balance between the random number digits and the query efficiency can be well considered, so that the database query can be efficiently performed, and the problem that the list data is easy to repeat when the list data is refreshed under the condition of less user data is avoided.
In order to facilitate better implementation of the above method according to the embodiment of the present application, the embodiment of the present application further describes a schematic structural diagram of a list display processing device and a list display processing apparatus under the same application concept as the embodiment of the above method. The following detailed description is made with reference to the accompanying drawings:
As shown in fig. 3, the structure schematic diagram of the list display processing apparatus provided in the embodiment of the present application, the list display processing apparatus 30 includes an instruction receiving unit 300, a requesting unit 302, a data receiving unit 304, and a display unit 306, where:
the instruction receiving unit 300 is configured to receive a list display instruction;
the request unit 302 is configured to request list data from a server according to the list display instruction; wherein the original data of the requested list data is in a plurality of fields of a plurality of different database tables;
the data receiving unit 304 is configured to receive list data returned by the server; the returned list data are list data selected by the server according to the maintained sorting value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting value is obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule;
the display unit 306 is used for displaying a list according to the list data.
In one possible implementation, the list display instruction is used to indicate entering a target page; the target page comprises a list for displaying the ordering of a plurality of different objects;
One sorting value in the sorting value table corresponds to one object; different ranking values correspond to different objects.
It will be appreciated that the descriptions of the respective units in the list display processing apparatus 30 may also correspond to the descriptions related to the terminal device in the foregoing embodiment of fig. 2 for implementing the list display processing method, which will not be described in detail herein.
The present application as shown in fig. 4 provides a schematic structural diagram of a list display processing apparatus of another embodiment, and the list display processing apparatus 40 includes a generation maintenance unit 400, a request receiving unit 402, a data selecting unit 404, and a data transmitting unit 406, wherein:
the generation and maintenance unit 400 is used for generating and maintaining a ranking value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting value is obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule;
the request receiving unit 402 is configured to receive a list data request sent by a terminal;
the data selecting unit 404 is configured to select list data according to the ranking value table;
the data transmitting unit 406 is configured to transmit the selected list data to the terminal.
In one possible implementation, the list display instruction is used to indicate entering a target page; the target page comprises a list for displaying the ordering of a plurality of different objects;
one sorting value in the sorting value table corresponds to one object; different ranking values correspond to different objects.
In one possible implementation, the N fields of the plurality of different database tables generate corresponding N values; the sorting value is a value obtained by splicing the N values;
the generation and maintenance unit is specifically configured to: when a target sorting value set exists, splicing a random number behind each sorting value in the target sorting value set; wherein the target ranking value set consists of ranking values with the same numerical value.
In one possible implementation, the number of digits x of the random number is related to the number of ranking values y in the target set of ranking values, where x=z+1; and z is the number of bits of the y.
In one possible implementation, the plurality of fields of the plurality of different database tables include: whether within an application, online type, idle, authentication condition, perfect profile condition, good rating, last video or speech ending time point of a user, whether a mobile operating system (IOS) user developed by apple company.
It will be appreciated that the descriptions of the respective units in the list display processing apparatus 40 may also correspond to the descriptions related to the server in the embodiment of fig. 2 for implementing the list display processing method, which are not described in detail here.
The following description is made with reference to fig. 5 and fig. 6, which provide a schematic structural diagram of a list display processing device according to an embodiment of the present application, where the list display processing device 50 is a terminal device in the foregoing method embodiment, and may include a processor 500, a memory 502, a display screen 504, and a communication module 506.
The processor 500 may be a general purpose Central Processing Unit (CPU), microprocessor, application Specific Integrated Circuit (ASIC), or one or more integrated circuits for controlling the execution of the above program schemes.
The Memory 502 may be, but is not limited to, read-Only Memory (ROM) or other type of static storage device that can store static information and instructions, random access Memory (random access Memory, RAM) or other type of dynamic storage device that can store information and instructions, but may also be electrically erasable programmable read-Only Memory (Electrically Erasable Programmable Read-Only Memory, EEPROM), compact disc read-Only Memory (Compact Disc Read-Only Memory) or other optical disc storage, optical disc storage (including compact disc, laser disc, optical disc, digital versatile disc, blu-ray disc, etc.), magnetic disk storage media or other magnetic storage devices, or any other medium that can be used to carry or store desired program code or computer programs in the form of instructions or data structures and that can be accessed by a computer. The memory 502 may be self-contained and coupled to the processor 500 via a bus. Memory 502 may also be integrated with processor 500.
A display screen 504 is coupled to the processor 500. For displaying information.
The communication module 506 is used for receiving and transmitting information;
the list display processing device 50 may also include other hardware modules, such as at least one sensor, etc. This application is not repeated.
The memory 502 is used for storing a computer program for executing the above scheme, and is controlled by the processor 500 to execute the program. The processor 500 is configured to execute a computer program stored in the memory 502.
When the program stored in the memory 502 is executed, the processor 500 is configured to execute the steps related to the terminal device in the list display processing method provided in fig. 2 above:
the processor 500 may receive list display instructions via a touch screen (such as display screen 504);
the processor 500 requests list data from the server through the communication module 506 according to the list display instruction; wherein the original data of the requested list data is in a plurality of fields of a plurality of different database tables;
the processor 500 receives the list data returned by the server through the communication module 506; the returned list data are list data selected by the server according to the maintained sorting value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting value is obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule;
The processor 500 performs list display through the display screen 504 according to the list data.
The specific implementation manner may refer to the implementation manner of the method embodiment, and will not be described herein.
As shown in fig. 6, the present application provides a schematic structural diagram of a list display processing device according to another embodiment, where the list display processing device 60 is a server in the above method embodiment, and may include a processor 600, a memory 602, and a communication module 604.
The processor 500 may be a general purpose Central Processing Unit (CPU), microprocessor, application Specific Integrated Circuit (ASIC), or one or more integrated circuits for controlling the execution of the above program schemes.
The Memory 602 may be, but is not limited to, a read-Only Memory (ROM) or other type of static storage device that can store static information and instructions, a random access Memory (random access Memory, RAM) or other type of dynamic storage device that can store information and instructions, an electrically erasable programmable read-Only Memory (Electrically Erasable Programmable Read-Only Memory, EEPROM), a compact disc read-Only Memory (Compact Disc Read-Only Memory) or other optical disk storage, a compact disc storage (including compact disc, laser disc, optical disc, digital versatile disc, blu-ray disc, etc.), a magnetic disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store desired program code or computer programs in the form of instructions or data structures and that can be accessed by a computer. The memory 602 may be stand alone and coupled to the processor 600 via a bus. Memory 602 may also be integrated with processor 600.
The communication module 604 is used for receiving and transmitting information;
the memory 602 is used for storing a computer program for executing the above scheme, and is controlled by the processor 600 to execute the program. The processor 600 is configured to execute a computer program stored in the memory 602.
The program stored in the memory 602 is executed, and the processor 600 is configured to perform the steps related to the server in the list display processing method provided in fig. 2 above:
processor 600 generates and maintains a sorted value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting value is obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule;
the processor 600 receives a list data request sent by a terminal through the communication module 604;
processor 600 selects list data according to the ranking value table;
the processor 600 sends the selected list data to the terminal via the communication module 604.
The specific implementation manner may refer to the implementation manner of the method embodiment, and will not be described herein.
Embodiments also provide a computer storage medium having instructions stored therein, which when run on a computer or processor, cause the computer or processor to perform one or more steps of the method of any of the embodiments described above. The respective constituent modules of the above apparatus, if implemented in the form of software functional units and sold or used as separate products, may be stored in the computer-readable storage medium, and based on such understanding, the technical solution of the present application may be embodied essentially or partly or wholly or partly in the form of a software product, which is stored in the computer-readable storage medium.
The computer readable storage medium may be an internal storage unit of the apparatus according to the foregoing embodiment, such as a hard disk or a memory. The computer-readable storage medium may be an external storage device of the above device, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), or the like. Further, the computer-readable storage medium may include both an internal storage unit and an external storage device of the above device. The computer-readable storage medium is used to store the computer program and other programs and data required by the apparatus. The above-described computer-readable storage medium may also be used to temporarily store data that has been output or is to be output.
Those skilled in the art will appreciate that implementing all or part of the above-described embodiment methods may be accomplished by way of a computer program, which may be stored in a computer-readable storage medium and which, when executed, may comprise the steps of the embodiments of the methods described above. And the aforementioned storage medium includes: various media capable of storing program code, such as ROM, RAM, magnetic or optical disks.
The steps in the method of the embodiment of the application can be sequentially adjusted, combined and deleted according to actual needs.
The modules in the device of the embodiment of the application can be combined, divided and deleted according to actual needs.
It will be appreciated by those of ordinary skill in the art that the various exemplary elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
Those of skill in the art will appreciate that the functions described in connection with the various illustrative logical blocks, modules, and algorithm steps described in connection with the embodiments disclosed herein may be implemented as hardware, software, firmware, or any combination thereof. If implemented in software, the functions described by the various illustrative logical blocks, modules, and steps may be stored on a computer readable medium or transmitted as one or more instructions or code and executed by a hardware-based processing unit. Computer-readable media may include computer-readable storage media corresponding to tangible media, such as data storage media, or communication media including any medium that facilitates transfer of a computer program from one place to another (e.g., according to a communication protocol). In this manner, a computer-readable medium may generally correspond to (1) a non-transitory tangible computer-readable storage medium, or (2) a communication medium, such as a signal or carrier wave. Data storage media may be any available media that can be accessed by one or more computers or one or more processors to retrieve instructions, code and/or data structures for implementing the techniques described herein. The computer program product may include a computer-readable medium.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, and are not repeated herein.
In the several embodiments provided in this application, it should be understood that the disclosed systems, devices, and methods may be implemented in other manners. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in each embodiment of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is merely specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily think about changes or substitutions within the technical scope of the present application, and the changes and substitutions are intended to be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (10)
1. A list display processing method, characterized by comprising:
receiving a list display instruction;
requesting list data from a server according to the list display instruction; wherein the original data of the requested list data is in a plurality of fields of a plurality of different database tables;
receiving list data returned by the server; the returned list data are list data selected by the server according to the maintained sorting value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting value is obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by the server, and then splicing each numerical value according to a sorting rule;
and displaying a list according to the list data.
2. The method of claim 1, wherein the list display instruction is to indicate entry into a target page; the target page comprises a list for displaying the ordering of a plurality of different objects;
one sorting value in the sorting value table corresponds to one object; different ranking values correspond to different objects.
3. A list display processing method, characterized by comprising:
Generating and maintaining a ranking value table; the sorting value table is a field and comprises a plurality of sorting values; the sorting values are obtained by respectively generating corresponding numerical values for a plurality of fields of a plurality of different database tables by a server and then splicing each numerical value according to a sorting rule;
receiving a list data request sent by a terminal;
selecting list data according to the sorting value table;
and sending the selected list data to the terminal.
4. A method as claimed in claim 3, wherein one of the ranking values in the ranking value table corresponds to one of the objects; different ranking values correspond to different objects.
5. The method of claim 4, wherein N fields of the plurality of different database tables generate corresponding N values; the sorting value is a value obtained by splicing the N values;
the generating and maintaining a ranking value table includes: when a target sorting value set exists, splicing a random number behind each sorting value in the target sorting value set; wherein the target ranking value set consists of ranking values with the same numerical value.
6. The method of claim 5, wherein the number of digits x of the random number is related to a number y of ranking values in the set of target ranking values, where x = z +1; and z is the number of bits of the y.
7. The method of any of claims 3-6, wherein the plurality of fields of the plurality of different database tables comprise: whether within an application, online type, idle, authentication condition, perfect profile condition, good rating, last video or voice ending time point of a user, whether an IOS user.
8. List display processing device, characterized by comprising functional units for performing the method according to any of claims 1-7.
9. A list display processing apparatus characterized by comprising: a memory for a program and a processor executing the program stored in the memory, the processor being adapted to perform the method of any one of claims 1-7 when the program stored in the memory is executed.
10. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program comprising program instructions which, when executed by a processor, cause the processor to perform the method of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011390918.3A CN112445873B (en) | 2020-12-02 | 2020-12-02 | List display processing method, related device, equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011390918.3A CN112445873B (en) | 2020-12-02 | 2020-12-02 | List display processing method, related device, equipment and medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112445873A CN112445873A (en) | 2021-03-05 |
| CN112445873B true CN112445873B (en) | 2024-03-26 |
Family
ID=74738950
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011390918.3A Active CN112445873B (en) | 2020-12-02 | 2020-12-02 | List display processing method, related device, equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112445873B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113282838A (en) * | 2021-06-23 | 2021-08-20 | 歌尔科技有限公司 | Ranking generation method and device, computer medium and intelligent wearable device |
| CN115114491B (en) * | 2022-07-08 | 2023-08-11 | 广东好太太科技集团股份有限公司 | Intelligent household appliance reservation control method, device and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103631910A (en) * | 2013-11-26 | 2014-03-12 | 烽火通信科技股份有限公司 | Distributed database multi-column composite query system and method |
| WO2018107942A1 (en) * | 2016-12-15 | 2018-06-21 | Huawei Technologies Co., Ltd. | System and method of adaptively partitioning data to speed up join queries on distributed and parallel database systems |
| CN108563736A (en) * | 2018-04-10 | 2018-09-21 | 口碑(上海)信息技术有限公司 | The method and device of data is inquired based on data characteristics |
| WO2019150287A1 (en) * | 2018-01-30 | 2019-08-08 | Encapsa Technology Llc | Method and system for encapsulating and storing information from multiple disparate data sources |
| CN110188100A (en) * | 2019-05-17 | 2019-08-30 | 中国银行股份有限公司 | Data processing method, device and computer storage medium |
| CN110298023A (en) * | 2019-07-04 | 2019-10-01 | 中原银行股份有限公司 | A kind of joining method and system of report |
| CN111459982A (en) * | 2020-03-27 | 2020-07-28 | 中国平安人寿保险股份有限公司 | Data query method and device, terminal device and storage medium |
-
2020
- 2020-12-02 CN CN202011390918.3A patent/CN112445873B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103631910A (en) * | 2013-11-26 | 2014-03-12 | 烽火通信科技股份有限公司 | Distributed database multi-column composite query system and method |
| WO2018107942A1 (en) * | 2016-12-15 | 2018-06-21 | Huawei Technologies Co., Ltd. | System and method of adaptively partitioning data to speed up join queries on distributed and parallel database systems |
| WO2019150287A1 (en) * | 2018-01-30 | 2019-08-08 | Encapsa Technology Llc | Method and system for encapsulating and storing information from multiple disparate data sources |
| CN108563736A (en) * | 2018-04-10 | 2018-09-21 | 口碑(上海)信息技术有限公司 | The method and device of data is inquired based on data characteristics |
| CN110188100A (en) * | 2019-05-17 | 2019-08-30 | 中国银行股份有限公司 | Data processing method, device and computer storage medium |
| CN110298023A (en) * | 2019-07-04 | 2019-10-01 | 中原银行股份有限公司 | A kind of joining method and system of report |
| CN111459982A (en) * | 2020-03-27 | 2020-07-28 | 中国平安人寿保险股份有限公司 | Data query method and device, terminal device and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 支持密文查询的云数据库加密技术研究;李东民;《中国优秀硕士学位论文全文数据库信息科技辑》(第02期);I138-235 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112445873A (en) | 2021-03-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11985037B2 (en) | Systems and methods for conducting more reliable assessments with connectivity statistics | |
| US11968105B2 (en) | Systems and methods for social graph data analytics to determine connectivity within a community | |
| US20230275817A1 (en) | Parallel computational framework and application server for determining path connectivity | |
| CN108701309A (en) | A kind of distributed user profile authentication system for security of e-commerce transactions | |
| US11106767B2 (en) | Decentralized name verification using recursive attestation | |
| CN109983456B (en) | Method and system for searching key range in memory | |
| CN111814179A (en) | User authority management and data control method and related equipment thereof | |
| CN112445873B (en) | List display processing method, related device, equipment and medium | |
| EP3245569A1 (en) | Record level data security | |
| US11244153B2 (en) | Method and apparatus for processing information | |
| CN110036381B (en) | In-memory data search technique | |
| CN113761565A (en) | Data desensitization method and apparatus | |
| CN116842012A (en) | Method, device, equipment and storage medium for storing Redis cluster in fragments | |
| CN110826977A (en) | Data updating method and device, computer equipment and storage medium | |
| CN111311374A (en) | University student-based idle commodity exchange method, device, equipment and storage medium | |
| CN112182107B (en) | List data acquisition method, device, computer equipment and storage medium | |
| CN114925275A (en) | Product recommendation method and device, computer equipment and storage medium | |
| CN112804134B (en) | Task initiating method based on instant messaging, related device, equipment and medium | |
| CN114650252B (en) | Routing method and device based on enterprise service bus and computer equipment | |
| CN115758300B (en) | Data processing method, device, electronic equipment and storage medium | |
| CN116401681A (en) | Big data-based information management method, readable storage medium and computer device | |
| CN116842541A (en) | Data encryption and decryption processing method and device, computer equipment and storage medium | |
| CN117056425A (en) | Cross-regional library information sharing method and system | |
| CN117853241A (en) | Risk service provider identification method, apparatus, device and storage medium thereof | |
| CN118093727A (en) | Order library construction method based on multistage distribution |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |