WO2019080431A1 - 电子装置、数据查询的方法、系统及存储介质 - Google Patents

电子装置、数据查询的方法、系统及存储介质

Info

Publication number
WO2019080431A1
WO2019080431A1 PCT/CN2018/077673 CN2018077673W WO2019080431A1 WO 2019080431 A1 WO2019080431 A1 WO 2019080431A1 CN 2018077673 W CN2018077673 W CN 2018077673W WO 2019080431 A1 WO2019080431 A1 WO 2019080431A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
window function
group
paging
field
Prior art date
Application number
PCT/CN2018/077673
Other languages
English (en)
French (fr)
Inventor
杨军
Original Assignee
平安科技（深圳）有限公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 平安科技（深圳）有限公司 filed Critical 平安科技（深圳）有限公司
Publication of WO2019080431A1 publication Critical patent/WO2019080431A1/zh

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2457—Query processing with adaptation to user needs
    • G06F16/24578—Query processing with adaptation to user needs using ranking
    • 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/242—Query formulation
    • G06F16/2433—Query languages

Definitions

  • the present application relates to the field of database technologies, and in particular, to an electronic device, a data query method, a system, and a storage medium.
  • the purpose of the application is to provide an electronic device, a data query method, a system and a storage medium, which are intended to simplify database query operations and improve database query efficiency.
  • the present application provides an electronic device including a memory and a processor coupled to the memory, the memory storing a processing system operable on the processor, the processing The system implements the following steps when executed by the processor:
  • Receiving a window function step receiving a SQL query statement input by a user and including a window function, the window function including a partition window function, a sort window function, and a page window function;
  • a component page query step when executing the SQL query statement, acquiring group data corresponding to each grouping field of the partition window function in the database, and sorting each component group data according to the sorting field of the sort window function, and Sorting the sorted group data according to the paging window function;
  • Output step Convert each group data after paging into a form to be output and perform output.
  • the present application further provides a data query method, where the data query method includes:
  • S1 Receive a SQL query statement that is input by a user and includes a window function, where the window function includes a partition window function, a sort window function, and a page window function;
  • the present application further provides a system for data query, where the system for querying data includes:
  • a receiving module configured to receive a SQL query statement that is input by a user and includes a window function, where the window function includes a partition window function, a sort window function, and a page window function;
  • a paging module configured to: when executing the SQL query statement, acquire packet data corresponding to each grouping field of the partition window function in the database, and sort the group group data according to the sorting field of the sort window function, and Sorting the sorted group data according to the paging window function;
  • the conversion module is configured to convert the grouped group data into a form to be output and perform an output.
  • the application further provides a computer readable storage medium having a processing system stored thereon, the processing system being implemented by a processor to implement the steps:
  • Receiving a window function step receiving a SQL query statement input by a user and including a window function, the window function including a partition window function, a sort window function, and a page window function;
  • a component page query step when executing the SQL query statement, acquiring group data corresponding to each grouping field of the partition window function in the database, and sorting each component group data according to the sorting field of the sort window function, and Sorting the sorted group data according to the paging window function;
  • Output step Convert each group data after paging into a form to be output and perform output.
  • the present application utilizes a window function to perform a component group page query on the data of the database: when executing the SQL query statement, the group data corresponding to the grouping field of the partition window function in the database is acquired, and the sorting field based on the sorting window function is obtained. Sorting the data of each component group, and paging the sorted group data according to the paging window function, converting the grouped data into the form to be output and performing output, and the user only needs the user when performing the query. Enter the SQL query statement containing the window function, and perform an operation. The operation is simple and fast, which greatly improves the efficiency of database query.
  • FIG. 1 is a schematic diagram of an optional application environment of each embodiment of the present application.
  • FIG. 2 is a schematic flowchart diagram of an embodiment of a method for data query according to the present application.
  • FIG. 1 it is a schematic diagram of an application environment of a preferred embodiment of the data query method of the present application.
  • the application environment diagram includes an electronic device 1 and a terminal device 2.
  • the electronic device 1 can perform data interaction with the terminal device 2 through a suitable technology such as a network or a near field communication technology.
  • the terminal device 2 includes, but is not limited to, any electronic product that can interact with a user through a keyboard, a mouse, a remote controller, a touch panel, or a voice control device, for example, a personal computer, a tablet computer, or a smart phone. , Personal Digital Assistant (PDA), game consoles, Internet Protocol Television (IPTV), smart wearable devices, navigation devices, etc., or mobile devices such as digital TVs, desktop computers, Fixed terminal for notebooks, servers, etc.
  • PDA Personal Digital Assistant
  • IPTV Internet Protocol Television
  • smart wearable devices navigation devices, etc.
  • mobile devices such as digital TVs, desktop computers, Fixed terminal for notebooks, servers, etc.
  • the user inputs the SQL query statement in the terminal device 2, and sends the SQL query statement to the electronic device 1, and the electronic device 1 executes the query according to the SQL query statement.
  • the electronic device 1 is an apparatus capable of automatically performing numerical calculation and/or information processing in accordance with an instruction set or stored in advance.
  • the electronic device 1 may be a computer, a single network server, a server group composed of multiple network servers, or a cloud-based cloud composed of a large number of hosts or network servers, where cloud computing is a type of distributed computing.
  • a super virtual computer consisting of a group of loosely coupled computers.
  • the electronic device 1 may include, but is not limited to, a memory 11 communicably connected to each other through a system bus, a processor 12, and a network interface 13, and the memory 11 stores a processing system operable on the processor 12. It should be noted that FIG. 1 only shows the electronic device 1 having the components 11-13, but it should be understood that not all illustrated components are required to be implemented, and more or fewer components may be implemented instead.
  • the memory 11 includes a memory and at least one type of readable storage medium.
  • the memory provides a cache for the operation of the electronic device 1;
  • the readable storage medium may be, for example, a flash memory, a hard disk, a multimedia card, a card type memory (eg, SD or DX memory, etc.), a random access memory (RAM), a static random access memory (SRAM).
  • a non-volatile storage medium such as a read only memory (ROM), an electrically erasable programmable read only memory (EEPROM), a programmable read only memory (PROM), a magnetic memory, a magnetic disk, an optical disk, or the like.
  • the readable storage medium may be an internal storage unit of the electronic device 1, such as a hard disk of the electronic device 1; in other embodiments, the non-volatile storage medium may also be external to the electronic device 1.
  • a storage device such as a plug-in hard disk equipped with an electronic device 1, a smart memory card (SMC), a Secure Digital (SD) card, a flash card, or the like.
  • the readable storage medium of the memory 11 is generally used to store an operating system and various types of application software installed in the electronic device 1, such as program code for storing a processing system in an embodiment of the present application. Further, the memory 11 can also be used to temporarily store various types of data that have been output or are to be output.
  • the processor 12 may be a Central Processing Unit (CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments.
  • the processor 12 is typically used to control the overall operation of the electronic device 1, such as performing control and processing related to data interaction or communication with the terminal device 2.
  • the processor 12 is configured to run program code or process data stored in the memory 11, such as running a processing system or the like.
  • the network interface 13 may comprise a wireless network interface or a wired network interface, which is typically used to establish a communication connection between the electronic device 1 and other electronic devices.
  • the network interface 13 is mainly used to connect the electronic device 1 with one or more terminal devices 2, and establish a data transmission channel and a communication connection between the electronic device 1 and one or more terminal devices 2.
  • the processing system is stored in the memory 11 and includes at least one computer readable instruction stored in the memory 11, the at least one computer readable instruction being executable by the processor 12 to implement the methods of various embodiments of the present application;
  • the at least one computer readable instruction can be classified into different logic modules depending on the functions implemented by its various parts.
  • Receiving window function step receiving a SQL query statement input by a user and containing a window function
  • the user operates on the terminal device 2, and can directly write an SQL query statement including a window function; or input corresponding data according to a predetermined SQL query structure including a window function to form an SQL query statement, for example, when When the course and the grades of each class need to be inquired, the related data includes the name of each class, the name of the course, and the name of the subject, etc., and the SQL query statement is sent to the electronic device 1 to execute the query, and the electronic device 1 uses the SQL query statement.
  • Sub-component page queries can be implemented.
  • the window function includes a partition window function, a sort window function and a page window function
  • the partition window function is preferably a PARTION BY partition query function
  • the PARTITION BY partition query function is used to group data according to a specific field
  • the partition window function can also Is another function, such as GROUP BY group query function.
  • the sort window function is preferably an ORDER BY ranking function.
  • the sort window function may also be other sort functions, such as a ROW_NUMBER ranking function, a RANK ranking function, a DENSE_RANK ranking function, or an NTILE ranking function.
  • the paging window function is, for example, the ROW NUMBER function.
  • a component page query step when executing the SQL query statement, acquiring group data corresponding to each grouping field of the partition window function in the database, and sorting each component group data according to the sorting field of the sort window function, and Sorting the sorted group data according to the paging window function;
  • the partition window function groups the data according to a specific field or according to a boundary value.
  • the partition window function is recalculated, for example, dividing a part of the data into two parts, male and female. , the two fields are grouped, the data belonging to the male is grouped, and the data belonging to the female is divided into another group.
  • the sort window function forces the grouped data to be sorted, including ascending order (ASC) and descending order (DESC). If no ascending or descending order is specified, the default is ascending (small to large).
  • the sort field of the sort window function is a field that can be incremented or decremented.
  • the type of the sort field includes characters, numbers, or time, such as an ID number, a data generation time, and the like.
  • the paging window function can be used with the partition window function. When crossing the partition boundary, the paging window function divides the previous data into one page and then starts the calculation of the next page.
  • the window function further includes a statistical window function.
  • the method further includes: performing, according to the statistical window function, data of each component group data after paging according to a predefined statistical field.
  • Statistics wherein the predefined statistical field is, for example, an order number, and the statistical window function can count the number or sum of predetermined fields of each component group data to facilitate user viewing.
  • Output step Convert each group data after paging into a form to be output and perform output.
  • the statistical group data when the statistical group data is converted into the form of the component page to be output, for example, the same group of packet data is identically identified, and different groups of packet data are differently identified, for each component group.
  • the data is in the form of pagination, the data is arranged in a predetermined number of rows for one page, the data after the predetermined number of rows is arranged to another page, and so on, and the other groups of data are processed in the same manner so as to be grouped.
  • the query is output to the data in the form of a page.
  • grouping pages are exemplified by querying all orders belonging to the same customer in the database:
  • the user inputs a SQL query statement containing a window function.
  • the grouping fields in the partition window function are, for example, client 1, client 2, and client 3, each client is a group
  • the sort window function ORDER
  • the sort field in BY is, for example, the time to generate according to the order.
  • the order is divided into pages, and the data corresponding to customer 1, customer 2 and customer 3 are respectively obtained, and then the total number corresponding to the order statistics of customer 1, customer 2 and customer 3 is respectively obtained by using the statistical window function, and customer 1, customer 2 and customer 3 are respectively obtained.
  • the corresponding order totals, the orders corresponding to the customer 1, the customer 2, and the customer 3 are converted into the form of the divided component pages to be output, and the output is performed.
  • the form of the divided component pages is, for example, a form of one set, and each table may have one Page or multiple pages.
  • the present embodiment utilizes a window function to perform a component group page query on the data of the database: when executing the SQL query statement, the group data corresponding to the grouping field of the partition window function in the database is obtained, and the sorting is based on the sorting window function.
  • the field sorts the data of each component group, and sorts the sorted group data according to the paging window function, converts the grouped data into pages to be outputted, and performs output.
  • only the query is performed. The user needs to input the SQL query statement containing the window function, and the operation can be performed once, the operation is simple and fast, and the efficiency of the database query is greatly improved.
  • the outputting step specifically includes:
  • the data output is performed in the same group as the same table.
  • each group of data after paging is loaded into the newly created table in a page-by-page order
  • Table 1 corresponds to data of all orders of customer 1
  • Table 2 corresponds to data of all orders of customer 2
  • table 3 corresponding to the data of all the orders of the customer 3
  • the first page group data corresponds to the first page in the loading table
  • the second page group data corresponds to the second page in the loading table
  • the data output is performed in the same group and the same table.
  • the data output is performed in the same group and the same table, so that the user can view and use the data.
  • the outputting step specifically includes:
  • a new corresponding view is created for each group data after paging, and the corresponding grouped paging data is loaded in each view, and the data output is performed in the form of a view.
  • a new corresponding view is created for each group data after paging, and the grouped data of the page to be loaded is added in the newly created view, and each group data corresponds to one view until the data of each component group is loaded.
  • the data output is performed in the form of a view.
  • the data output is performed in the form of a view, which is convenient for the user to view and use the data.
  • FIG. 2 is a schematic flowchart of a method for data query according to an application of the present application.
  • the method for querying data includes the following steps:
  • Step S1 receiving a SQL query statement input by a user and including a window function, where the window function includes a partition window function, a sort window function, and a page window function;
  • the user operates on the terminal device 2, and can directly write an SQL query statement including a window function; or input corresponding data according to a predetermined SQL query structure including a window function to form an SQL query statement, for example, when When the course and the grades of each class need to be inquired, the related data includes the name of each class, the name of the course, and the name of the subject, etc., and the SQL query statement is sent to the electronic device 1 to execute the query, and the electronic device 1 uses the SQL query statement.
  • Sub-component page queries can be implemented.
  • the window function includes a partition window function, a sort window function and a page window function
  • the partition window function is preferably a PARTION BY partition query function
  • the PARTITION BY partition query function is used to group data according to a specific field
  • the partition window function can also Is another function, such as GROUP BY group query function.
  • the sort window function is preferably an ORDER BY ranking function.
  • the sort window function may also be other sort functions, such as a ROW_NUMBER ranking function, a RANK ranking function, a DENSE_RANK ranking function, or an NTILE ranking function.
  • the paging window function is, for example, the ROW NUMBER function.
  • Step S2 when executing the SQL query statement, acquiring group data corresponding to each grouping field of the partition window function in the database, and sorting each group group data according to the sorting field of the sorting window function, and based on the The paging window function performs paging on the sorted group data;
  • the partition window function groups the data according to a specific field or according to a boundary value.
  • the partition window function is recalculated, for example, dividing a part of the data into two parts, male and female. , the two fields are grouped, the data belonging to the male is grouped, and the data belonging to the female is divided into another group.
  • the sort window function forces the grouped data to be sorted, including ascending order (ASC) and descending order (DESC). If no ascending or descending order is specified, the default is ascending (small to large).
  • the sort field of the sort window function is a field that can be incremented or decremented.
  • the type of the sort field includes characters, numbers, or time, such as an ID number, a data generation time, and the like.
  • the paging window function can be used with the partition window function. When crossing the partition boundary, the paging window function divides the previous data into one page and then starts the calculation of the next page.
  • the window function further includes a statistical window function.
  • the method further includes: performing, according to the statistical window function, data of each component group data after paging according to a predefined statistical field.
  • Statistics wherein the predefined statistical field is, for example, an order number, and the statistical window function can count the number or sum of predetermined fields of each component group data to facilitate user viewing.
  • step S3 the data of each component group after paging is converted into a form to be output and output is performed.
  • the statistical group data when the statistical group data is converted into the form of the component page to be output, for example, the same group of packet data is identically identified, and different groups of packet data are differently identified, for each component group.
  • the data is in the form of pagination, the data is arranged in a predetermined number of rows for one page, the data after the predetermined number of rows is arranged to another page, and so on, and the other groups of data are processed in the same manner so as to be grouped.
  • the query is output to the data in the form of a page.
  • a sub-component page is taken as an example of querying all orders belonging to the same customer in the database:
  • the user inputs a SQL query statement containing a window function.
  • the grouping fields in the partition window function are, for example, client 1, client 2, and client 3, each client is a group
  • the sort window function ORDER
  • the sort field in BY is, for example, the time to generate according to the order.
  • the order is divided into pages, and the data corresponding to customer 1, customer 2 and customer 3 are respectively obtained, and then the total number corresponding to the order statistics of customer 1, customer 2 and customer 3 is respectively obtained by using the statistical window function, and customer 1, customer 2 and customer 3 are respectively obtained.
  • the corresponding order totals, the orders corresponding to the customer 1, the customer 2, and the customer 3 are converted into the form of the divided component pages to be output, and the output is performed.
  • the form of the divided component pages is, for example, a form of one set, and each table may have one Page or multiple pages.
  • the present embodiment utilizes a window function to perform a component group page query on the data of the database: when executing the SQL query statement, the group data corresponding to the grouping field of the partition window function in the database is obtained, and the sorting is based on the sorting window function.
  • the field sorts the data of each component group, and sorts the sorted group data according to the paging window function, converts the grouped data into pages to be outputted, and performs output.
  • only the query is performed. The user needs to input the SQL query statement containing the window function, and the operation can be performed once, the operation is simple and fast, and the efficiency of the database query is greatly improved.
  • the step S3 specifically includes:
  • the data output is performed in the same group as the same table.
  • each group of data after paging is loaded into the newly created table in a page-by-page order
  • Table 1 corresponds to data of all orders of customer 1
  • Table 2 corresponds to data of all orders of customer 2
  • table 3 corresponding to the data of all the orders of the customer 3
  • the first page group data corresponds to the first page in the loading table
  • the second page group data corresponds to the second page in the loading table
  • the data output is performed in the same group and the same table.
  • the data output is performed in the same group and the same table, so that the user can view and use the data.
  • the step S3 specifically includes:
  • a new corresponding view is created for each group data after paging, and the corresponding grouped paging data is loaded in each view, and the data output is performed in the form of a view.
  • a new corresponding view is created for each group data after paging, and the grouped data of the page to be loaded is added in the newly created view, and each group data corresponds to one view until the data of each component group is loaded.
  • the data output is performed in the form of a view.
  • the data output is performed in the form of a view, which is convenient for the user to view and use the data.
  • the present application also provides a computer readable storage medium having stored thereon a processing system, the processing system being executed by a processor to perform the steps of the method of data query described above.
  • the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be through hardware, but in many cases, the former is better.
  • Implementation Based on such understanding, the technical solution of the present application, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk,
  • the optical disc includes a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present application.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

本申请涉及一种电子装置、数据查询的方法、系统及存储介质，数据查询的方法包括：接收用户输入的包含窗口函数的SQL查询语句，所述窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数；在执行所述SQL查询语句时，获取数据库中与所述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；对分页后的各组分组数据转换为待输出的形式并执行输出。本申请能够简化数据库查询操作，提高数据库查询的效率。

Description

电子装置、数据查询的方法、系统及存储介质
优先权申明
本申请基于巴黎公约申明享有2017年10月27日递交的申请号为CN201711029511.6、名称为“电子装置、数据查询的方法及存储介质”中国专利申请的优先权，该中国专利申请的整体内容以参考的方式结合在本申请中。
技术领域
本申请涉及数据库技术领域，尤其涉及一种电子装置、数据查询的方法、系统及存储介质。
背景技术
目前，在对数据库中的数据进行分组分页查询时，例如对于某一组数据，需要发送查询该组数据的总数的请求及发送查询该组数据的实际详细数据的请求，需要用户进行2次操作。如果查询N组数据，则需要用户发送N+N个请求，即进行2N次操作，这种查询方式比较繁琐，使得数据库分组分页查询的效率低下。
发明内容
本申请的目的在于提供一种电子装置、数据查询的方法、系统及存储介质，旨在简化数据库查询操作，提高数据库查询的效率。
为实现上述目的，本申请提供一种电子装置，所述电子装置包括存储器及与所述存储器连接的处理器，所述存储器中存储有可在所述处理器上运行的处理系统，所述处理系统被所述处理器执行时实现如下步骤：
接收窗口函数步骤：接收用户输入的包含窗口函数的SQL查询语句，所述窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数；
分组分页查询步骤：在执行所述SQL查询语句时，获取数据库中与所述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；
输出步骤：对分页后的各组分组数据转换为待输出的形式并执行输出。
为实现上述目的，本申请还提供一种数据查询的方法，所述数据查询的方法包括：
S1，接收用户输入的包含窗口函数的SQL查询语句，所述窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数；
S2，在执行所述SQL查询语句时，获取数据库中与所述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；
S3，对分页后的各组分组数据转换为待输出的形式并执行输出。
为实现上述目的，本申请还提供一种数据查询的系统，所述数据查询的系统包括：
接收模块，用于接收用户输入的包含窗口函数的SQL查询语句，所述窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数；
分页模块，用于在执行所述SQL查询语句时，获取数据库中与所述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；
转换模块，用于对分页后的各组分组数据转换为待输出的形式并执行输 出。
本申请还提供一种计算机可读存储介质，所述计算机可读存储介质上存储有处理系统，所述处理系统被处理器执行时实现步骤：
接收窗口函数步骤：接收用户输入的包含窗口函数的SQL查询语句，所述窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数；
分组分页查询步骤：在执行所述SQL查询语句时，获取数据库中与所述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；
输出步骤：对分页后的各组分组数据转换为待输出的形式并执行输出。
本申请的有益效果是：本申请利用窗口函数对数据库的数据进行分组分页查询：在执行SQL查询语句时，获取数据库中与分区窗口函数的分组字段对应的分组数据，基于排序窗口函数的排序字段对各组分组数据进行排序，并基于分页窗口函数对排序后的各组分组数据进行分页，对分页后的分组数据转换为待输出的形式并执行输出，本申请在进行查询时，只需要用户输入包含窗口函数的SQL查询语句，进行一次操作即可，操作简单快捷，极大地提高数据库查询的效率。
附图说明
图1为本申请各个实施例一可选的应用环境示意图；
图2为本申请数据查询的方法一实施例的流程示意图。
具体实施方式
为了使本申请的目的、技术方案及优点更加清楚明白，以下结合附图及实施例，对本申请进行进一步详细说明。应当理解，此处所描述的具体实施 例仅用以解释本申请，并不用于限定本申请。基于本申请中的实施例，本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例，都属于本申请保护的范围。
需要说明的是，在本申请中涉及“第一”、“第二”等的描述仅用于描述目的，而不能理解为指示或暗示其相对重要性或者隐含指明所指示的技术特征的数量。由此，限定有“第一”、“第二”的特征可以明示或者隐含地包括至少一个该特征。另外，各个实施例之间的技术方案可以相互结合，但是必须是以本领域普通技术人员能够实现为基础，当技术方案的结合出现相互矛盾或无法实现时应当认为这种技术方案的结合不存在，也不在本申请要求的保护范围之内。
参阅图1所示，是本申请数据查询的方法的较佳实施例的应用环境示意图。该应用环境示意图包括电子装置1及终端设备2。电子装置1可以通过网络、近场通信技术等适合的技术与终端设备2进行数据交互。
所述终端设备2包括，但不限于，任何一种可与用户通过键盘、鼠标、遥控器、触摸板或者声控设备等方式进行人机交互的电子产品，例如，个人计算机、平板电脑、智能手机、个人数字助理(Personal Digital Assistant，PDA)、游戏机、交互式网络电视(Internet Protocol Television,IPTV)、智能式穿戴式设备、导航装置等等的可移动设备，或者诸如数字TV、台式计算机、笔记本、服务器等等的固定终端。用户在终端设备2输入SQL查询语句，将SQL查询语句发送至电子装置1，电子装置1根据SQL查询语句执行查询。
所述电子装置1是一种能够按照事先设定或者存储的指令，自动进行数值计算和/或信息处理的设备。所述电子装置1可以是计算机、也可以是单个网络服务器、多个网络服务器组成的服务器组或者基于云计算的由大量主机或者网络服务器构成的云，其中云计算是分布式计算的一种，由一群松散耦 合的计算机集组成的一个超级虚拟计算机。
在本实施例中，电子装置1可包括，但不仅限于，可通过系统总线相互通信连接的存储器11、处理器12、网络接口13，存储器11存储有可在处理器12上运行的处理系统。需要指出的是，图1仅示出了具有组件11-13的电子装置1，但是应理解的是，并不要求实施所有示出的组件，可以替代的实施更多或者更少的组件。
其中，存储器11包括内存及至少一种类型的可读存储介质。内存为电子装置1的运行提供缓存；可读存储介质可为如闪存、硬盘、多媒体卡、卡型存储器(例如，SD或DX存储器等)、随机访问存储器(RAM)、静态随机访问存储器(SRAM)、只读存储器(ROM)、电可擦除可编程只读存储器(EEPROM)、可编程只读存储器(PROM)、磁性存储器、磁盘、光盘等的非易失性存储介质。在一些实施例中，可读存储介质可以是电子装置1的内部存储单元，例如该电子装置1的硬盘；在另一些实施例中，该非易失性存储介质也可以是电子装置1的外部存储设备，例如电子装置1上配备的插接式硬盘，智能存储卡(Smart Media Card,SMC)，安全数字(Secure Digital,SD)卡，闪存卡(Flash Card)等。本实施例中，存储器11的可读存储介质通常用于存储安装于电子装置1的操作系统和各类应用软件，例如存储本申请一实施例中的处理系统的程序代码等。此外，存储器11还可以用于暂时地存储已经输出或者将要输出的各类数据。
所述处理器12在一些实施例中可以是中央处理器(Central Processing Unit，CPU)、控制器、微控制器、微处理器、或其他数据处理芯片。该处理器12通常用于控制所述电子装置1的总体操作，例如执行与所述终端设备2进行数据交互或者通信相关的控制和处理等。本实施例中，所述处理器12用于运行所述存储器11中存储的程序代码或者处理数据，例如运行处理系统等。
所述网络接口13可包括无线网络接口或有线网络接口，该网络接口13通常用于在所述电子装置1与其他电子设备之间建立通信连接。本实施例中，网络接口13主要用于将电子装置1与一个或多个终端设备2相连，在电子装置1与一个或多个终端设备2之间建立数据传输通道和通信连接。
所述处理系统存储在存储器11中，包括至少一个存储在存储器11中的计算机可读指令，该至少一个计算机可读指令可被处理器器12执行，以实现本申请各实施例的方法；以及，该至少一个计算机可读指令依据其各部分所实现的功能不同，可被划为不同的逻辑模块。
在一实施例中，上述处理系统被所述处理器12执行时实现如下步骤：
接收窗口函数步骤：接收用户输入的包含窗口函数的SQL查询语句；
对于SQL查询，是指从数据库中取得数据的子集。本实施例中，用户在终端设备2上进行操作，可以直接编写包括包含窗口函数的SQL查询语句；或者基于预定的包含窗口函数的SQL查询结构输入对应的相关数据，形成SQL查询语句，例如当需要对各个班级的课程及成绩进行查询时，该相关数据包括各班级的名称、课程的名称及科目名称等，将该SQL查询语句发送给电子装置1执行查询，电子装置1利用该SQL查询语句可以实现分组分页查询。
其中，窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数，分区窗口函数优选为PARTION BY分区查询函数，PARTITION BY分区查询函数用于将数据按照特定字段进行分组，当然，分区窗口函数也可以是其他的函数，例如GROUP BY分组查询函数等。排序窗口函数优选为ORDER BY排名函数，当然，排序窗口函数也可以是其他的排序函数，例如ROW_NUMBER排名函数、RANK排名函数、DENSE_RANK排名函数或者NTILE排名函数等。分页窗口函数例如为ROW NUMBER函数。
分组分页查询步骤：在执行所述SQL查询语句时，获取数据库中与所 述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；
本实施例中，分区窗口函数将数据按照特定字段或按照边界值分组，在执行过程中，如果超出了分组，则分区窗口函数会重新计算，例如，将某部分数据分为男性和女性两部分，则针对这两字段进行分组，将属于男性的数据分到一组，将属于女性的数据分到另一组。排序窗口函数将分组后的数据进行强制排序，包括升序(ASC)和降序(DESC)，如果不指定升序或者降序，则默认为升序(由小到大)。排序窗口函数的排序字段为可递增或可递减的字段，优选地，排序字段的类型包括字符、数字或者时间，例如为ID号码、数据生成时间等等。分页窗口函数可与分区窗口函数一起使用，当穿越分区边界时，分页窗口函数将前面的数据分为一页，然后开始下一页的计算。
优选地，所述窗口函数还包括统计窗口函数，所述处理系统被所述处理器执行时，还包括：基于所述统计窗口函数对分页后的各组分组数据按照预定义的统计字段进行数据统计，其中，预定义的统计字段例如为订单号，统计窗口函数可以统计各组分组数据的预定字段的数量或总和等，以方便用户查看。
输出步骤：对分页后的各组分组数据转换为待输出的形式并执行输出。
本实施例中，对统计后的各组分组数据转换为待输出的分组分页的形式时，例如对同组的分组数据进行相同标识，对不同组的分组数据进行不同标识，对于每一组分组数据采用分页的形式，以预定的行数为一页排布数据，超过该预定的行数之后的数据排布到另一页，以此类推，其他组的数据做同样的处理，以便以分组分页的形式输出查询到数据。
在一实施例中，以查询数据库中属于同一客户的所有订单为例进行分组 分页：
用户输入包含窗口函数的SQL查询语句，在SQL查询语句中，分区窗口函数(PARTITON BY)中的分组字段例如为客户1、客户2及客户3，每一客户为一组，排序窗口函数(ORDER BY)中的排序字段例如为按照订单生成时间。在执行SQL查询语句时，获取数据库中与分组字段对应的分组数据，即获取客户1的所有订单、获取客户2的所有订单及获取客户3的所有订单，按照排序字段分别对客户1、客户2及客户3的各组分组数据进行排序，例如按照订单生成时间分别对客户1、客户2及客户3的分组数据进行排序，然后利用分页窗口函数分别对排序后的客户1、客户2及客户3的订单分页，分别得到客户1、客户2及客户3对应的数据，然后利用统计窗口函数分别对客户1、客户2及客户3的订单统计对应的总数，分别得到客户1、客户2及客户3对应的订单总数，对客户1、客户2及客户3对应的订单转换为待输出的分组分页的形式，并执行输出，该分组分页的形式例如为一组一表的形式，每一表可以有一页或多页。
与现有技术相比，本实施例利用窗口函数对数据库的数据进行分组分页查询：在执行SQL查询语句时，获取数据库中与分区窗口函数的分组字段对应的分组数据，基于排序窗口函数的排序字段对各组分组数据进行排序，并基于分页窗口函数对排序后的各组分组数据进行分页，对分页后的分组数据转换为待输出的形式并执行输出，本实施例在进行查询时，只需要用户输入包含窗口函数的SQL查询语句，进行一次操作即可，操作简单快捷，极大地提高数据库查询的效率。
在一优选的实施例中，在上述图1的实施例的基础上，所述输出步骤，具体包括：
对分页后的每组分组数据按照分页的顺序逐页载入新建的表中，直至将 各组分组数据载入对应的新建的表中；
在载入数据完成后，以同组同表的形式执行数据输出。
本实施例中，对分页后的每组分组数据按照分页的顺序逐页载入新建的表中，例如表1对应客户1的所有订单的数据，表2对应客户2的所有订单的数据，表3对应客户3的所有订单的数据，在每一表中，第一页分组数据对应载入表中的第一页，第二页分组数据对应载入表中的第二页，以此类推，直至将各组分组数据载入对应的新建的表中，在载入数据完成后，以同组同表的形式执行数据输出。
本实施例中在载入数据完成后，以同组同表的形式执行数据输出，方便用户进行数据的查看及使用。
在另一优选的实施例中，在上述图1的实施例的基础上，所述输出步骤，具体包括：
对分页后的每组分组数据新建对应的视图，在每一视图中载入对应的分页后的分组数据，以视图的形式执行数据输出。
本实施例中，对分页后的每组分组数据新建对应的视图，在新建的视图中添加所要载入的分页后的分组数据，每组分组数据对应一个视图，直至将各组分组数据载入对应的新建的视图中，在载入数据完成后，以视图的形式执行数据输出。
本实施例中在载入数据完成后，以视图的形式执行数据输出，方便用户进行数据的查看及使用。
如图2所示，图2为本申请数据查询的方法一实施例的流程示意图，该数据查询的方法包括以下步骤：
步骤S1，接收用户输入的包含窗口函数的SQL查询语句，所述窗口函 数包括分区窗口函数、排序窗口函数及分页窗口函数；
对于SQL查询，是指从数据库中取得数据的子集。本实施例中，用户在终端设备2上进行操作，可以直接编写包括包含窗口函数的SQL查询语句；或者基于预定的包含窗口函数的SQL查询结构输入对应的相关数据，形成SQL查询语句，例如当需要对各个班级的课程及成绩进行查询时，该相关数据包括各班级的名称、课程的名称及科目名称等，将该SQL查询语句发送给电子装置1执行查询，电子装置1利用该SQL查询语句可以实现分组分页查询。
其中，窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数，分区窗口函数优选为PARTION BY分区查询函数，PARTITION BY分区查询函数用于将数据按照特定字段进行分组，当然，分区窗口函数也可以是其他的函数，例如GROUP BY分组查询函数等。排序窗口函数优选为ORDER BY排名函数，当然，排序窗口函数也可以是其他的排序函数，例如ROW_NUMBER排名函数、RANK排名函数、DENSE_RANK排名函数或者NTILE排名函数等。分页窗口函数例如为ROW NUMBER函数。
步骤S2，在执行所述SQL查询语句时，获取数据库中与所述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；
本实施例中，分区窗口函数将数据按照特定字段或按照边界值分组，在执行过程中，如果超出了分组，则分区窗口函数会重新计算，例如，将某部分数据分为男性和女性两部分，则针对这两字段进行分组，将属于男性的数据分到一组，将属于女性的数据分到另一组。排序窗口函数将分组后的数据进行强制排序，包括升序(ASC)和降序(DESC)，如果不指定升序或者降序，则默认为升序(由小到大)。排序窗口函数的排序字段为可递增或可递 减的字段，优选地，排序字段的类型包括字符、数字或者时间，例如为ID号码、数据生成时间等等。分页窗口函数可与分区窗口函数一起使用，当穿越分区边界时，分页窗口函数将前面的数据分为一页，然后开始下一页的计算。
优选地，所述窗口函数还包括统计窗口函数，所述处理系统被所述处理器执行时，还包括：基于所述统计窗口函数对分页后的各组分组数据按照预定义的统计字段进行数据统计，其中，预定义的统计字段例如为订单号，统计窗口函数可以统计各组分组数据的预定字段的数量或总和等，以方便用户查看。
步骤S3，对分页后的各组分组数据转换为待输出的形式并执行输出。
本实施例中，对统计后的各组分组数据转换为待输出的分组分页的形式时，例如对同组的分组数据进行相同标识，对不同组的分组数据进行不同标识，对于每一组分组数据采用分页的形式，以预定的行数为一页排布数据，超过该预定的行数之后的数据排布到另一页，以此类推，其他组的数据做同样的处理，以便以分组分页的形式输出查询到数据。
在一实施例中，以查询数据库中属于同一客户的所有订单为例进行分组分页：
用户输入包含窗口函数的SQL查询语句，在SQL查询语句中，分区窗口函数(PARTITON BY)中的分组字段例如为客户1、客户2及客户3，每一客户为一组，排序窗口函数(ORDER BY)中的排序字段例如为按照订单生成时间。在执行SQL查询语句时，获取数据库中与分组字段对应的分组数据，即获取客户1的所有订单、获取客户2的所有订单及获取客户3的所有订单，按照排序字段分别对客户1、客户2及客户3的各组分组数据进行排序，例如按照订单生成时间分别对客户1、客户2及客户3的分组数据进行排序，然后利用分页窗口函数分别对排序后的客户1、客户2及客户3的 订单分页，分别得到客户1、客户2及客户3对应的数据，然后利用统计窗口函数分别对客户1、客户2及客户3的订单统计对应的总数，分别得到客户1、客户2及客户3对应的订单总数，对客户1、客户2及客户3对应的订单转换为待输出的分组分页的形式，并执行输出，该分组分页的形式例如为一组一表的形式，每一表可以有一页或多页。
与现有技术相比，本实施例利用窗口函数对数据库的数据进行分组分页查询：在执行SQL查询语句时，获取数据库中与分区窗口函数的分组字段对应的分组数据，基于排序窗口函数的排序字段对各组分组数据进行排序，并基于分页窗口函数对排序后的各组分组数据进行分页，对分页后的分组数据转换为待输出的形式并执行输出，本实施例在进行查询时，只需要用户输入包含窗口函数的SQL查询语句，进行一次操作即可，操作简单快捷，极大地提高数据库查询的效率。
在一优选的实施例中，在上述图2的实施例的基础上，所述步骤S3，具体包括：
对分页后的每组分组数据按照分页的顺序逐页载入新建的表中，直至将各组分组数据载入对应的新建的表中；
在载入数据完成后，以同组同表的形式执行数据输出。
本实施例中，对分页后的每组分组数据按照分页的顺序逐页载入新建的表中，例如表1对应客户1的所有订单的数据，表2对应客户2的所有订单的数据，表3对应客户3的所有订单的数据，在每一表中，第一页分组数据对应载入表中的第一页，第二页分组数据对应载入表中的第二页，以此类推，直至将各组分组数据载入对应的新建的表中，在载入数据完成后，以同组同表的形式执行数据输出。
本实施例中在载入数据完成后，以同组同表的形式执行数据输出，方便 用户进行数据的查看及使用。
在一优选的实施例中，在上述图2的实施例的基础上，所述步骤S3，具体包括：
对分页后的每组分组数据新建对应的视图，在每一视图中载入对应的分页后的分组数据，以视图的形式执行数据输出。
本实施例中，对分页后的每组分组数据新建对应的视图，在新建的视图中添加所要载入的分页后的分组数据，每组分组数据对应一个视图，直至将各组分组数据载入对应的新建的视图中，在载入数据完成后，以视图的形式执行数据输出。
本实施例中在载入数据完成后，以视图的形式执行数据输出，方便用户进行数据的查看及使用。
本申请还提供一种计算机可读存储介质，所述计算机可读存储介质上存储有处理系统，所述处理系统被处理器执行时实现上述的数据查询的方法的步骤。
上述本申请实施例序号仅仅为了描述，不代表实施例的优劣。
通过以上的实施方式的描述，本领域的技术人员可以清楚地了解到上述实施例方法可借助软件加必需的通用硬件平台的方式来实现，当然也可以通过硬件，但很多情况下前者是更佳的实施方式。基于这样的理解，本申请的技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来，该计算机软件产品存储在一个存储介质(如ROM/RAM、磁碟、光盘)中，包括若干指令用以使得一台终端设备(可以是手机，计算机，服务器，空调器，或者网络设备等)执行本申请各个实施例所述的方法。
以上仅为本申请的优选实施例，并非因此限制本申请的专利范围，凡是利用本申请说明书及附图内容所作的等效结构或等效流程变换，或直接或间 接运用在其他相关的技术领域，均同理包括在本申请的专利保护范围内。

Claims (20)

  1. 一种电子装置，其特征在于，所述电子装置包括存储器及与所述存储器连接的处理器，所述存储器中存储有可在所述处理器上运行的处理系统，所述处理系统被所述处理器执行时实现如下步骤：
    接收窗口函数步骤：接收用户输入的包含窗口函数的SQL查询语句，所述窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数；
    分组分页查询步骤：在执行所述SQL查询语句时，获取数据库中与所述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；
    输出步骤：对分页后的各组分组数据转换为待输出的形式并执行输出。
  2. 根据权利要求1所述的电子装置，其特征在于，所述输出步骤，具体包括：
    对分页后的每组分组数据按照分页的顺序逐页载入新建的表中，直至将各组分组数据载入对应的新建的表中；
    在载入数据完成后，以同组同表的形式执行数据输出。
  3. 根据权利要求1所述的电子装置，其特征在于，所述输出步骤，具体包括：
    对分页后的每组分组数据新建对应的视图，在每一视图中载入对应的分页后的分组数据，以视图的形式执行数据输出。
  4. 根据权利要求1至3任一项所述的电子装置，其特征在于，所述窗口函数还包括统计窗口函数，所述处理系统被所述处理器执行时，还包括：
    基于所述统计窗口函数对分页后的各组分组数据按照预定义的统计字段进行数据统计。
  5. 根据权利要求1所述的电子装置，其特征在于，所述排序字段为可递 增的字段或可递减的字段。
  6. 一种数据查询的方法，其特征在于，所述数据查询的方法包括：
    S1，接收用户输入的包含窗口函数的SQL查询语句，所述窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数；
    S2，在执行所述SQL查询语句时，获取数据库中与所述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；
    S3，对分页后的各组分组数据转换为待输出的形式并执行输出。
  7. 根据权利要求6所述的数据查询的方法，其特征在于，所述步骤S3，具体包括：
    对分页后的每组分组数据按照分页的顺序逐页载入新建的表中，直至将各组分组数据载入对应的新建的表中；
    在载入数据完成后，以同组同表的形式执行数据输出。
  8. 根据权利要求6所述的数据查询的方法，其特征在于，所述步骤S3，具体包括：
    对分页后的每组分组数据新建对应的视图，在每一视图中载入对应的分页后的分组数据，以视图的形式执行数据输出。
  9. 根据权利要求6至8任一项所述的数据查询的方法，其特征在于，所述窗口函数还包括统计窗口函数，所述步骤S3之前，还包括：
    基于所述统计窗口函数对分页后的各组分组数据按照预定义的统计字段进行数据统计。
  10. 根据权利要求6所述的数据查询的方法，其特征在于，所述排序字段为可递增的字段或可递减的字段。
  11. 一种数据查询的系统，其特征在于，所述数据查询的系统包括：
    接收模块，用于接收用户输入的包含窗口函数的SQL查询语句，所述窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数；
    分页模块，用于在执行所述SQL查询语句时，获取数据库中与所述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；
    转换模块，用于对分页后的各组分组数据转换为待输出的形式并执行输出。
  12. 根据权利要求11所述的数据查询的系统，其特征在于，所述转换模块，具体用于对分页后的每组分组数据按照分页的顺序逐页载入新建的表中，直至将各组分组数据载入对应的新建的表中；在载入数据完成后，以同组同表的形式执行数据输出。
  13. 根据权利要求11所述的数据查询的系统，其特征在于，所述转换模块，具体用于对分页后的每组分组数据新建对应的视图，在每一视图中载入对应的分页后的分组数据，以视图的形式执行数据输出。
  14. 根据权利要求11至13任一项所述的数据查询的系统，其特征在于，所述窗口函数还包括统计窗口函数，所述数据查询的系统还包括：
    统计模块，用于基于所述统计窗口函数对分页后的各组分组数据按照预定义的统计字段进行数据统计。
  15. 根据权利要求11所述的数据查询的系统，其特征在于，所述排序字段为可递增的字段或可递减的字段。
  16. 一种计算机可读存储介质，其特征在于，所述计算机可读存储介质上存储有处理系统，所述处理系统被处理器执行时实现步骤：
    接收窗口函数步骤：接收用户输入的包含窗口函数的SQL查询语句，所述窗口函数包括分区窗口函数、排序窗口函数及分页窗口函数；
    分组分页查询步骤：在执行所述SQL查询语句时，获取数据库中与所述分区窗口函数的各分组字段对应的分组数据，基于所述排序窗口函数的排序字段对各组分组数据进行排序，并基于所述分页窗口函数对排序后的各组分组数据进行分页；
    输出步骤：对分页后的各组分组数据转换为待输出的形式并执行输出。
  17. 根据权利要求16所述的计算机可读存储介质，其特征在于，所述输出步骤，具体包括：
    对分页后的每组分组数据按照分页的顺序逐页载入新建的表中，直至将各组分组数据载入对应的新建的表中；
    在载入数据完成后，以同组同表的形式执行数据输出。
  18. 根据权利要求16所述的计算机可读存储介质，其特征在于，所述输出步骤，具体包括：
    对分页后的每组分组数据新建对应的视图，在每一视图中载入对应的分页后的分组数据，以视图的形式执行数据输出。
  19. 根据权利要求16至18任一项所述的计算机可读存储介质，其特征在于，所述窗口函数还包括统计窗口函数，所述处理系统被所述处理器执行时，还包括：
    基于所述统计窗口函数对分页后的各组分组数据按照预定义的统计字段进行数据统计。
  20. 根据权利要求16所述的计算机可读存储介质，其特征在于，所述排序字段为可递增的字段或可递减的字段。
PCT/CN2018/077673 2017-10-27 2018-02-28 电子装置、数据查询的方法、系统及存储介质 WO2019080431A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201711029511.6 2017-10-27
CN201711029511.6A CN107992516A (zh) 2017-10-27 2017-10-27 电子装置、数据查询的方法及存储介质

Publications (1)

Publication Number Publication Date
WO2019080431A1 true WO2019080431A1 (zh) 2019-05-02

Family

ID=62031072

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/077673 WO2019080431A1 (zh) 2017-10-27 2018-02-28 电子装置、数据查询的方法、系统及存储介质

Country Status (2)

Country Link
CN (1) CN107992516A (zh)
WO (1) WO2019080431A1 (zh)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116361319A (zh) * 2023-05-17 2023-06-30 山东浪潮科学研究院有限公司 一种数据库查询方法、装置、设备及存储介质

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109857771A (zh) * 2019-01-31 2019-06-07 平安科技（深圳）有限公司 具有排名的sql排列的获取方法、装置和计算机设备
CN112199407B (zh) * 2020-10-12 2023-10-27 上海达梦数据库有限公司 一种数据分组排序方法、装置、设备及存储介质
CN113204602B (zh) * 2021-05-07 2023-08-01 星环信息科技(上海)股份有限公司 数据处理方法、装置、设备及存储介质
CN113723696B (zh) * 2021-09-07 2023-08-08 上海达梦数据库有限公司 一种排名分析函数处理方法、装置、电子设备及存储介质

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102521406A (zh) * 2011-12-26 2012-06-27 中国科学院计算技术研究所 海量结构化数据复杂查询任务的分布式查询方法和系统
CN105653611A (zh) * 2015-12-24 2016-06-08 深圳市汇朗科技有限公司 分表分页排序查询方法及装置
CN106227894A (zh) * 2016-08-24 2016-12-14 中国农业银行股份有限公司 一种数据分页查询方法和装置
US20170109377A1 (en) * 2015-10-19 2017-04-20 Oracle International Corporation Filtered partition maintenance operations

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020029207A1 (en) * 2000-02-28 2002-03-07 Hyperroll, Inc. Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein
CN101197876B (zh) * 2006-12-06 2012-02-29 中兴通讯股份有限公司 一种对消息类业务数据进行多维分析的方法和系统
CN101251861B (zh) * 2008-03-18 2010-04-21 北京锐安科技有限公司 一种海量数据加载和查询的方法
CN103678634A (zh) * 2013-12-19 2014-03-26 北京锐安科技有限公司 一种提高J-Hi开源开发平台中数据查询速度的方法
CN105786808B (zh) * 2014-12-15 2019-06-18 阿里巴巴集团控股有限公司 一种用于分布式执行关系型计算指令的方法与设备

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102521406A (zh) * 2011-12-26 2012-06-27 中国科学院计算技术研究所 海量结构化数据复杂查询任务的分布式查询方法和系统
US20170109377A1 (en) * 2015-10-19 2017-04-20 Oracle International Corporation Filtered partition maintenance operations
CN105653611A (zh) * 2015-12-24 2016-06-08 深圳市汇朗科技有限公司 分表分页排序查询方法及装置
CN106227894A (zh) * 2016-08-24 2016-12-14 中国农业银行股份有限公司 一种数据分页查询方法和装置

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116361319A (zh) * 2023-05-17 2023-06-30 山东浪潮科学研究院有限公司 一种数据库查询方法、装置、设备及存储介质
CN116361319B (zh) * 2023-05-17 2023-08-29 山东浪潮科学研究院有限公司 一种数据库查询方法、装置、设备及存储介质

Also Published As

Publication number Publication date
CN107992516A (zh) 2018-05-04

Similar Documents

Publication Publication Date Title
WO2019080431A1 (zh) 电子装置、数据查询的方法、系统及存储介质
WO2019100619A1 (zh) 电子装置、多表关联查询的方法、系统及存储介质
US9817858B2 (en) Generating hash values
CN111090628A (zh) 一种数据处理方法、装置、存储介质及电子设备
US9524318B2 (en) Minimizing result set size when converting from asymmetric to symmetric requests
CN111865970B (zh) 用于实现接口幂等性的方法和装置
CN111258966A (zh) 一种数据去重方法、装置、设备及存储介质
CN110737659A (zh) 图数据存储和查询方法、装置及计算机可读存储介质
CN107729137B (zh) 服务器、区块链验签解密的方法及存储介质
US20150012513A1 (en) Providing a query results page
US11132362B2 (en) Method and system of optimizing database system, electronic device and storage medium
JP2021089704A (ja) データ照会方法、装置、電子機器、可読記憶媒体、及びコンピュータープログラム
CN112307062B (zh) 数据库聚合查询方法、装置及系统
WO2019071958A1 (zh) 基于云计算的薪资计算方法、应用服务器及计算机可读存储介质
CN113010542B (zh) 业务数据处理方法、装置、计算机设备及存储介质
WO2024022180A1 (zh) 网盘文档索引方法、装置、网盘及存储介质
US10303687B2 (en) Concurrent processing of data sources
WO2019071907A1 (zh) 基于操作页面识别帮助信息的方法及应用服务器
CN111949648B (zh) 内存缓存数据系统和数据索引方法
WO2019024238A1 (zh) 范围值数据统计方法、系统、电子装置及计算机可读存储介质
CN110704404A (zh) 一种数据质量校验方法、装置、系统
CN113342822B (zh) 基于多类型数据库的数据查询方法、装置、电子设备及介质
JP2015162039A (ja) 情報処理装置、情報処理方法、プログラム及びデータ構造
CN108427663B (zh) 电子装置、页面表格数据的处理方法及存储介质
US20150074143A1 (en) Distributed storage system with pluggable query processing

Legal Events

Date Code Title Description
NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 01/10/2020)

121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18871147

Country of ref document: EP

Kind code of ref document: A1

122 Ep: pct application non-entry in european phase

Ref document number: 18871147

Country of ref document: EP

Kind code of ref document: A1