CN111488368A - Data query method and device and electronic equipment - Google Patents

Data query method and device and electronic equipment Download PDF

Info

Publication number
CN111488368A
CN111488368A CN202010246887.8A CN202010246887A CN111488368A CN 111488368 A CN111488368 A CN 111488368A CN 202010246887 A CN202010246887 A CN 202010246887A CN 111488368 A CN111488368 A CN 111488368A
Authority
CN
China
Prior art keywords
data query
element combination
function
obtaining
result
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.)
Withdrawn
Application number
CN202010246887.8A
Other languages
Chinese (zh)
Inventor
王海鹏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Mobai Beijing Information Technology Co Ltd
Original Assignee
Mobai Beijing Information Technology Co Ltd
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 Mobai Beijing Information Technology Co Ltd filed Critical Mobai Beijing Information Technology Co Ltd
Priority to CN202010246887.8A priority Critical patent/CN111488368A/en
Publication of CN111488368A publication Critical patent/CN111488368A/en
Withdrawn legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • G06F16/244Grouping and aggregation

Abstract

The invention relates to a data query method and device and electronic equipment. The method comprises the following steps: obtaining a data query instruction, wherein the data query instruction comprises at least one element combination function, and the element combination function is used for obtaining at least one element combination among a plurality of elements; obtaining the element combination according to the element combination function; and acquiring a data query result according to the element combination. The method can accurately and flexibly obtain the combined result, thereby improving the quality and speed of data query.

Description

Data query method and device and electronic equipment
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data query method, a data query apparatus, an electronic device, and a computer-readable storage medium.
Background
Hive is a set of data warehouse analysis systems constructed based on Hadoop, and provides rich SQ L (Structured Query L arrangement) Query modes to analyze data stored in a Hadoop distributed file system, and can map Structured data files into a database table and provide a complete SQ L Query function.
The Grouping Sets (Grouping Sets) are a union of a plurality of groups, are used for performing aggregation operation on the Sets according to different Grouping columns in one query, and are equivalent to calculating a union of a plurality of result Sets by using 'union all' for a single group. In the existing hive sql system, the Grouping Sets of Grouping Sets are added manually by the developer. Assuming a total of n fields requiring a group, the fields are combinedThe number of (a) is 1 to 2nMeanwhile, when a great number of combinations need to be added, manual addition is time-consuming and labor-consuming, and problems of omission, repetition, combination errors and the like also occur, so that the quality of output data is finally influenced.
Therefore, a new technical solution for data query is needed.
Disclosure of Invention
The invention provides a new technical scheme for data query.
According to a first aspect of the present invention, there is provided a data query method, including:
obtaining a data query instruction, wherein the data query instruction comprises at least one element combination function, and the element combination function is used for obtaining at least one element combination among a plurality of elements;
obtaining the element combination according to the element combination function;
and acquiring a data query result according to the element combination.
Optionally, the data query instruction includes at least one of the following element combination functions:
specifying grouped element composition functions;
incrementing the grouped element combining function;
element combining functions of the single element groups;
fully combining grouped element combining functions.
Optionally, the data query instruction includes a plurality of element combination functions, and the element combination functions are in a nested relationship;
obtaining the element combination according to the element combination function includes:
sequentially acquiring the operation result of each element combination function according to a preset sequence;
and obtaining the element combination according to the final operation result.
Optionally, the sequentially obtaining the operation result of each element combination function according to a preset sequence includes:
and sequentially acquiring the operation result of each element combination function according to the sequence from inside to outside.
Optionally, the data query instruction further comprises a grouping sets function;
the obtaining of the data query result according to the element combination includes:
and inputting the element combination into the grouping set function of the grouping sets to obtain the data query result.
Optionally, the data query instruction further includes a search range;
the obtaining of the data query result includes:
and searching the data in the searching range to obtain the query result.
Optionally, the method further comprises:
and displaying the data query result.
According to a second aspect of the present invention, there is provided a data query apparatus including:
the data query instruction comprises at least one element combination function, and the element combination function is used for obtaining at least one element combination among a plurality of elements;
the first processing module is used for obtaining the element combination according to the element combination function;
and the second processing module is used for acquiring a data query result according to the element combination.
According to a third aspect of the present invention, there is provided an electronic apparatus comprising:
a memory for storing executable commands;
a processor for implementing the method of the first aspect of the invention under control of the executable command.
According to a fourth aspect of the present invention, there is provided a computer readable storage medium storing executable instructions which, when executed by a processor, implement the method of the first aspect of the present invention.
According to the data query method in the embodiment, the element combination result is obtained according to the at least one element combination function, and then the data query result is obtained according to the element combination result, so that the existing manual element combination input mode can be replaced, the combination result can be accurately and flexibly obtained, and the quality and the speed of data query are improved.
Other features of the present invention and advantages thereof will become apparent from the following detailed description of exemplary embodiments thereof, which proceeds with reference to the accompanying drawings.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description, serve to explain the principles of the invention.
FIG. 1 is a schematic diagram of an electronic device that may be used to implement an embodiment of the invention.
Fig. 2 is a flowchart of a data query method according to an embodiment of the present invention.
Detailed Description
Various exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that: the relative arrangement of the components and steps, the numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present invention unless specifically stated otherwise.
The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way intended to limit the invention, its application, or uses.
Techniques, methods, and apparatus known to those of ordinary skill in the relevant art may not be discussed in detail, but are intended to be part of the specification where appropriate.
In all examples shown and discussed herein, any particular value should be construed as merely illustrative, and not limiting. Thus, other examples of the exemplary embodiments may have different values.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, further discussion thereof is not required in subsequent figures.
< hardware configuration >
FIG. 1 is a schematic diagram of an electronic device that may be used to implement an embodiment of the invention.
As shown in fig. 1, the electronic device 1100 includes a processor 1110, a memory 1120, an interface device 1130, a communication device 1140, an output device 1150, and an input device 1160. The processor 1110 is, for example, a central processing unit CPU, a microprocessor MCU, or the like. The memory 1120 is, for example, a ROM (read only memory), a RAM (random access memory), a nonvolatile memory such as a hard disk, or the like. The interface device 1130 is, for example, a USB interface, a headphone interface, or the like. The communication device 1140 is capable of wired or wireless communication, for example. The output device 1150 is, for example, a liquid crystal display, a touch panel, a speaker, or the like. The input device 1160 is, for example, a touch screen, a keyboard, a mouse, a microphone, or the like.
The electronic device 1100 shown in fig. 1 is merely illustrative and is in no way intended to limit the present invention, its application, or uses.
< method examples >
The present embodiment provides a data query method, for example, implemented by the electronic device 1100 shown in fig. 1.
As shown in fig. 2, the data query method includes the following steps S1100-S1300.
In step S1100, a data query instruction is obtained, the data query instruction including at least one element combination function, the element combination function being used to obtain at least one element combination among the plurality of elements.
In this embodiment, the data query command is, for example, a query code input by the user through the console.
The elements in this embodiment are, for example, fields in a data table.
In this embodiment, the element combination function is used to obtain at least one element combination among the plurality of elements. For example, the input of the element combination function is a plurality of elements, and the output is an element combination formed by the plurality of elements according to a preset rule. The parameter type, operation rule and other elements of the element combination function can be preset, and a user can call the element combination function by the function name.
In one example, the data query instruction includes at least one of the following element composition functions: specifying grouped element composition functions; incrementing the grouped element combining function; element combining functions of the single element groups; fully combining grouped element combining functions.
A grouped element combination function, denoted group (), is specified for fixing elements into a unique combination such that the elements in the unique combination no longer appear as a single element. For example, the element combination function goup (a, b, c) specifying grouping can group the elements a, b, c, and the resulting combination result includes only one element combination, i.e., (a, b, c).
The increment grouped element combination function, denoted as rollup (), is used to increment the elements in order to form a combined result. For example, the incrementally grouped element combination function rollup (a, b, c) can be sequentially and incrementally combined for the elements a, b, c, and the resulting combination result includes three element combinations, sequentially (a), (a, b, c).
The element combination function of the single element grouping is denoted as element () and is used for processing the elements into combinations which are independent and appear independently. The element combining function of a single element grouping can avoid forming a combination including a plurality of elements at the same time. For example, the element combination function element (a, b, c) of a single element grouping can process the elements a, b, c into combinations independent of each other, and the resulting combination result includes three element combinations, i.e., (a), (b), (c).
And the element combination function of the fully-combined grouping is marked as withcube () and is used for executing fully-combined operation on the elements. It is easily understood that assuming that the number of elements is n, the combined result includes 2nSeed element combinations (including null combinations, denoted ()). For example, the element combination function withcube (a, b, c) of the full combination grouping can perform the full combination operation on the elements a, b, c, and the obtained combination result includes 8 element combinations, i.e., (), (a), (b), (c), (a, b), (a, c), (b, c), (a, b, c).
The element combination functions provide common element combination functions and can meet the query requirements under common conditions.
In other embodiments, the data query instruction may further include other types of element combination functions, which is not limited in this embodiment.
In one example, the data query instruction includes a plurality of element composition functions, the plurality of element composition functions being in a nested relationship. The multiple element composition functions used by nesting may be heterogeneous, such as rolup (a, group (b, c)). The multiple element combining functions used in nesting may be of the same kind, for example, withcube (a, withcube (b, c)).
By nesting and using a plurality of element combination functions, various combination functions can be realized, the diversified requirements of users are met, and the flexibility of the scheme is improved.
In step S1200, an element combination is obtained according to the element combination function.
In this embodiment, the electronic device performs calculation according to an operation rule corresponding to the element combination function to obtain a corresponding element combination.
In the case of a plurality of nested uses, step S1200 includes: sequentially acquiring the operation result of each element combination function according to a preset sequence; and obtaining element combination according to the final operation result. The predetermined sequence is, for example, an inside-out sequence.
Taking the nested expression rolup (element (a, group (b, c))) as an example, the element combination function group (b, c) of the innermost layer is first calculated, and the calculation result is (b, c). On the basis of the calculation, the second layer element combination function (a, (b, c)) is calculated, and the results are (a) and (b, c). And finally, calculating an outermost element combination function rollup (a, (b, c)), and obtaining a final operation result (a), (a, b, c), namely a result of element combination. Thus, reasonable operation can be carried out on the element combination under the nesting condition.
A specific example of obtaining a combination of elements is provided below. In this example, the elements include city, city name, province name, China, overseas, date and type, and the number is 8. Before inputting the query instruction, the user can analyze the elements according to the actual situation. For example, city and city names, province and province names in actual demand are co-occurring without splitting, so these elements can be processed using a specified grouping of element combination function, gourp (), i.e., group (province, province name), group (city, city name). For another example, china and overseas are mutually exclusive relationships, and these 2 elements do not need to be combined together, so that the element can be processed using element combination function element () of a single element group, namely element (china and overseas). For another example, two elements of date and type are not necessarily linked to other elements, and need to be processed in full combination with other elements, i.e., withcube. Based on the requirement analysis, a plurality of element combination functions can be nested and used to obtain a final expression. The final expression is, for example, withcube (element (china, group (province, province name), group (city, city name)), overseas), date, type).
By performing analytical operation on the above expression, the combination result can be: () "type", "date", "type", "china, date", "china, type", "date, type", "overseas, date", "overseas, type", "overseas, date, type", "china, province name, date", "china, province name, type", "china, province name, date), (type), (china, province name, city name), (china, province name, city name, date), (china, province name, city name, type), (china, province name, city name, date, type).
In step S1300, a data query result is obtained according to the element combination.
In one example, the data query instruction also includes a grouping sets function. Step S1300 includes: and inputting the element combination into grouping sets function to obtain data query result.
For example, the grouping results such as (a), (a, b, c) are substituted into the grouping sets function, and grouping sets are processed on the basis of the grouping sets function. Through the mode, the existing mode of manually inputting and combining in grouping sets expressions can be replaced, on one hand, the data query efficiency is improved, on the other hand, the problems of omission, repetition, combination errors and the like can be avoided, and finally, the quality of data query results is improved.
According to the data query method in the embodiment, the element combination result is obtained according to the at least one element combination function, and then the data query result is obtained according to the element combination result, so that the existing manual element combination input mode can be replaced, the combination result can be accurately and flexibly obtained, and the quality and the speed of data query are improved.
The data query instruction comprises a data table, a search range, a search result and a search result, wherein the search range is selected from the data table by using an SE L ECTcolumn _ name statement.
In one example, the data query method further includes: and displaying the data query result. For example, the data query results are displayed on the screen in a graph or the like. Therefore, the user can intuitively obtain the query result.
< apparatus embodiment >
The embodiment provides a data query device which comprises the following modules.
The data query instruction comprises at least one element combination function, and the element combination function is used for obtaining at least one element combination among the elements.
And the first processing module is used for obtaining the element combination according to the element combination function.
And the second processing module is used for acquiring a data query result according to the element combination.
In one example, the data query instruction includes at least one of the following element composition functions: specifying grouped element composition functions; incrementing the grouped element combining function; element combining functions of the single element groups; fully combining grouped element combining functions.
In one example, the data query instruction comprises a plurality of element combination functions, and the element combination functions are in a nested relation; the first processing module is used for: sequentially acquiring the operation result of each element combination function according to a preset sequence; and obtaining element combination according to the final operation result.
In one example, the first processing module is to: and sequentially acquiring the operation result of each element combination function according to the sequence from inside to outside.
In one example, the data query instruction also includes a grouping sets function. The second processing module is used for: and inputting the element combination into grouping sets function to obtain data query result.
In one example, the data query instruction further includes a lookup range. The second processing module is used for: and searching the data in the searching range to obtain a query result.
In one example, the data query apparatus further comprises a display module configured to: and displaying the data query result.
The data query device in this embodiment can implement the steps of the data query method described in this embodiment of the method of the present invention, and therefore the same technical effects can be achieved, and details are not described here to avoid repetition.
< electronic device embodiment >
The embodiment provides an electronic device comprising a memory and a processor. The memory is used for storing executable commands. The processor is used for executing the data query method described in the embodiment of the method under the control of the executable command.
< computer-readable storage Medium embodiment >
The present embodiment provides a computer-readable storage medium, in which an executable command is stored, and when the executable command is executed by a processor, the data query method described in the method embodiment of the present invention is implemented.
The present invention may be a system, method and/or computer program product. The computer program product may include a computer-readable storage medium having computer-readable program instructions embodied therewith for causing a processor to implement various aspects of the present invention.
The computer readable storage medium may be a tangible device that can hold and store the instructions for use by the instruction execution device. The computer readable storage medium may be, for example, but not limited to, an electronic memory device, a magnetic memory device, an optical memory device, an electromagnetic memory device, a semiconductor memory device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a Static Random Access Memory (SRAM), a portable compact disc read-only memory (CD-ROM), a Digital Versatile Disc (DVD), a memory stick, a floppy disk, a mechanical coding device, such as punch cards or in-groove projection structures having instructions stored thereon, and any suitable combination of the foregoing. Computer-readable storage media as used herein is not to be construed as transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide or other transmission medium (e.g., optical pulses through a fiber optic cable), or electrical signals transmitted through electrical wires.
The computer-readable program instructions described herein may be downloaded from a computer-readable storage medium to a respective computing/processing device, or to an external computer or external storage device via a network, such as the internet, a local area network, a wide area network, and/or a wireless network. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers and/or edge servers. The network adapter card or network interface in each computing/processing device receives computer-readable program instructions from the network and forwards the computer-readable program instructions for storage in a computer-readable storage medium in the respective computing/processing device.
Computer program instructions for carrying out operations of the present invention may be assembler instructions, Instruction Set Architecture (ISA) instructions, machine-related instructions, microcode, firmware instructions, state setting data, or source or object code written in any combination of one or more programming languages, including AN object oriented programming language such as Smalltalk, C + +, or the like, as well as conventional procedural programming languages, such as the "C" language or similar programming languages.
Aspects of the present invention are described herein with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer-readable program instructions.
These computer-readable program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks. These computer-readable program instructions may also be stored in a computer-readable storage medium that can direct a computer, programmable data processing apparatus, and/or other devices to function in a particular manner, such that the computer-readable medium storing the instructions comprises an article of manufacture including instructions which implement the function/act specified in the flowchart and/or block diagram block or blocks.
The computer readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other devices to cause a series of operational steps to be performed on the computer, other programmable apparatus or other devices to produce a computer implemented process such that the instructions which execute on the computer, other programmable apparatus or other devices implement the functions/acts specified in the flowchart and/or block diagram block or blocks.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of instructions, which comprises one or more executable instructions for implementing the specified logical function(s). In some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions. It is well known to those skilled in the art that implementation by hardware, implementation by software, and implementation by a combination of software and hardware are equivalent.
Having described embodiments of the present invention, the foregoing description is intended to be exemplary, not exhaustive, and not limited to the embodiments disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments. The terminology used herein is chosen in order to best explain the principles of the embodiments, the practical application, or improvements made to the technology in the marketplace, or to enable others of ordinary skill in the art to understand the embodiments disclosed herein. The scope of the invention is defined by the appended claims.

Claims (10)

1. A method of data query, comprising:
obtaining a data query instruction, wherein the data query instruction comprises at least one element combination function, and the element combination function is used for obtaining at least one element combination among a plurality of elements;
obtaining the element combination according to the element combination function;
and acquiring a data query result according to the element combination.
2. The method of claim 1, wherein the data query instruction comprises at least one of the following element composition functions:
specifying grouped element composition functions;
incrementing the grouped element combining function;
element combining functions of the single element groups;
fully combining grouped element combining functions.
3. The method of claim 1, wherein the data query instruction comprises a plurality of element composition functions, the plurality of element composition functions being in a nested relationship;
obtaining the element combination according to the element combination function includes:
sequentially acquiring the operation result of each element combination function according to a preset sequence;
and obtaining the element combination according to the final operation result.
4. The method according to claim 3, wherein the sequentially obtaining the operation result of each element combination function in a preset order comprises:
and sequentially acquiring the operation result of each element combination function according to the sequence from inside to outside.
5. The method of claim 1, wherein the data query instruction further comprises a grouping sets function;
the obtaining of the data query result according to the element combination includes:
and inputting the element combination into the grouping set function of the grouping sets to obtain the data query result.
6. The method of claim 1, wherein the data query instruction further comprises a lookup range;
the obtaining of the data query result includes:
and searching the data in the searching range to obtain the query result.
7. The method of claim 1, further comprising:
and displaying the data query result.
8. A data query apparatus, comprising:
the data query instruction comprises at least one element combination function, and the element combination function is used for obtaining at least one element combination among a plurality of elements;
the first processing module is used for obtaining the element combination according to the element combination function;
and the second processing module is used for acquiring a data query result according to the element combination.
9. An electronic device, comprising:
a memory for storing executable commands;
a processor for implementing the method of any one of claims 1 to 7 under the control of the executable commands.
10. A computer-readable storage medium storing executable instructions that, when executed by a processor, implement the method of any of claims 1-7.
CN202010246887.8A 2020-03-31 2020-03-31 Data query method and device and electronic equipment Withdrawn CN111488368A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010246887.8A CN111488368A (en) 2020-03-31 2020-03-31 Data query method and device and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010246887.8A CN111488368A (en) 2020-03-31 2020-03-31 Data query method and device and electronic equipment

Publications (1)

Publication Number Publication Date
CN111488368A true CN111488368A (en) 2020-08-04

Family

ID=71797570

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010246887.8A Withdrawn CN111488368A (en) 2020-03-31 2020-03-31 Data query method and device and electronic equipment

Country Status (1)

Country Link
CN (1) CN111488368A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113420050A (en) * 2021-06-28 2021-09-21 平安普惠企业管理有限公司 Data query management method and device, computer equipment and readable storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5963936A (en) * 1997-06-30 1999-10-05 International Business Machines Corporation Query processing system that computes GROUPING SETS, ROLLUP, and CUBE with a reduced number of GROUP BYs in a query graph model
CN103020150A (en) * 2011-11-22 2013-04-03 微软公司 Multidimensional grouping operators
CN104303176A (en) * 2012-05-15 2015-01-21 惠普发展公司,有限责任合伙企业 Query processing
US20160378827A1 (en) * 2015-06-29 2016-12-29 Oracle International Corporation Query optimization for group-by extensions and distinct aggregate functions

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5963936A (en) * 1997-06-30 1999-10-05 International Business Machines Corporation Query processing system that computes GROUPING SETS, ROLLUP, and CUBE with a reduced number of GROUP BYs in a query graph model
CN103020150A (en) * 2011-11-22 2013-04-03 微软公司 Multidimensional grouping operators
CN104303176A (en) * 2012-05-15 2015-01-21 惠普发展公司,有限责任合伙企业 Query processing
US20160378827A1 (en) * 2015-06-29 2016-12-29 Oracle International Corporation Query optimization for group-by extensions and distinct aggregate functions

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
张玉杰;于双元;: "大数据查询综述", 计算机与现代化 *
陈耀旺;朱宁;施扬朋;: "基于Hive的大数据在线分析处理", 计算机时代 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113420050A (en) * 2021-06-28 2021-09-21 平安普惠企业管理有限公司 Data query management method and device, computer equipment and readable storage medium
CN113420050B (en) * 2021-06-28 2023-08-25 深圳华科讯通科技有限公司 Data query management method, device, computer equipment and readable storage medium

Similar Documents

Publication Publication Date Title
CN111177231B (en) Report generation method and report generation device
CN111190718A (en) Method, device and system for realizing task scheduling
CN110704398A (en) Database migration method and device from MySQL to Oracle and computer equipment
CN110489087B (en) Method, device, medium and electronic equipment for generating fractal structure
CN109871311B (en) Method and device for recommending test cases
US10318094B2 (en) Assistive technology (AT) responsive to cognitive states
CN103873318A (en) Website automated testing method and automated testing system
CN113419789A (en) Method and device for generating data model script
CN111967234A (en) Visual report generation method and device, terminal equipment and storage medium
CN104508616A (en) Text input method and device and terminal
US10359836B2 (en) Assistive technology (AT) responsive to cognitive states
CN111488368A (en) Data query method and device and electronic equipment
US20190205359A1 (en) Evaluation of formulas via modal attributes
US20200089687A1 (en) Collaborative search of databases
US20200073919A1 (en) Virtual agent creation platform
CN105893614A (en) Information recommendation method and device and electronic equipment
US10628397B2 (en) Navigation of data set preparation
CN111143464B (en) Data acquisition method and device and electronic equipment
US20130124686A1 (en) System and a Method for Sharing Computing Resources Associated to Scientific Publications
CN111309988B (en) Character string retrieval method and device based on coding and electronic equipment
CN113760969A (en) Data query method and device based on elastic search
CN111488341A (en) Database index management method and device and electronic equipment
US20150370460A1 (en) Business-to-business document user interface and integration design
CN105979385A (en) Method and device for joining Weibo topic discussion
CN111222066A (en) Pull-down component system and method for event processing and searching

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
WW01 Invention patent application withdrawn after publication

Application publication date: 20200804

WW01 Invention patent application withdrawn after publication