CN111666294B - Method for acquiring data set, terminal equipment and computer readable storage medium - Google Patents
Method for acquiring data set, terminal equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN111666294B CN111666294B CN201910164290.6A CN201910164290A CN111666294B CN 111666294 B CN111666294 B CN 111666294B CN 201910164290 A CN201910164290 A CN 201910164290A CN 111666294 B CN111666294 B CN 111666294B
- Authority
- CN
- China
- Prior art keywords
- target
- data set
- group
- cursor
- access
- 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
- 238000000034 method Methods 0.000 title claims abstract description 31
- 238000004590 computer program Methods 0.000 claims description 14
- 238000010586 diagram Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 230000002776 aggregation Effects 0.000 description 3
- 238000004220 aggregation Methods 0.000 description 3
- 230000001960 triggered effect Effects 0.000 description 3
- 238000003491 array Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000006467 substitution reaction 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/24—Querying
- G06F16/242—Query formulation
- G06F16/243—Natural language query formulation
Abstract
The invention is applicable to the technical field of data set acquisition, and provides a method for acquiring a data set, terminal equipment and a computer readable storage medium. When a target instruction for accessing a target result set is detected, a target cursor group is determined from cursor groups of the target result set based on access keywords contained in the target instruction, and then the target data set is acquired from the target result set based on the access keywords and the target cursor group, so that the data set in the target result set is directly acquired, a basis is provided for directly processing target data in the target result set, and the efficiency of acquiring the data set is improved.
Description
Technical Field
The present invention relates to the field of data set acquisition technology, and in particular, to a data set acquisition method, a terminal device, and a computer readable storage medium.
Background
Along with the development of science and technology, more and more fields need to acquire, process, analyze and the like by means of big data when products are developed or market is expanded, and meanwhile, a corresponding database needs to be constructed, so that the data can be stored and extracted conveniently. The structured query language (Structured Query Language, SQL) is a database query and programming language for accessing data and querying, updating and managing databases. SQL is the most important relational database operating language, and the influence thereof exceeds the database field, and is also valued and used in other fields, such as data retrieval in the artificial intelligence field, languages requiring embedding SQL, and the like.
The existing databases all adopt SQL language to process data, but after the SQL language is adopted to process the original data set to obtain a result set, the data in the result set cannot be directly processed, for example, after the SQL language is adopted to group the original data set to obtain a grouped result set, only the grouping is supported to process an aggregation function, and the data in each grouping in the result set cannot be directly processed by using a select statement. For another example, for nested multi-tiered queries, when cross-tier access is performed in select, the cross-tier result set needs to be expressed in a manner that includes aliases, etc., which has the problem of low efficiency in achieving the acquisition of the data set.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method, a terminal device, and a computer-readable storage medium for acquiring a data set, which can improve the efficiency of acquiring the data set.
A first aspect of an embodiment of the present invention provides a method for acquiring a data set, including:
if a target instruction for accessing a target result set is detected, determining a target cursor group from cursor groups of the target result set based on an access keyword contained in the target instruction;
and acquiring a target data set from the target result set based on the access key word and the target cursor group.
A second aspect of an embodiment of the present invention provides an apparatus for acquiring a data set, including:
the determining unit is used for determining a target cursor group from cursor groups of the target result set based on access keywords contained in the target instruction if the target instruction accessing the target result set is detected;
and the acquisition unit is used for acquiring a target data set from the target result set based on the access key word and the target cursor group.
A third aspect of an embodiment of the present invention provides a terminal device, including: a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the method of the first aspect described above when the computer program is executed.
A fourth aspect of the embodiments of the present invention provides a computer readable storage medium, which when executed by a processor, implements the steps of the method described in the first aspect.
According to the embodiment of the invention, when the target instruction accessing the target result set is detected, the target cursor set is determined from the cursor sets of the target result set based on the access key words contained in the target instruction, and then the target data set is acquired from the target result set based on the access key words and the target cursor set, so that the data set in the target result set is directly acquired, a basis is provided for directly processing target data in the target result set, and the data set acquisition efficiency is improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the embodiments or the description of the prior art will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic flow chart of a method for acquiring a data set according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a method for acquiring a data set according to another embodiment of the present invention;
FIG. 3 is a schematic structural diagram of an apparatus for acquiring a data set according to an embodiment of the present invention;
fig. 4 is a schematic diagram of a terminal device according to an embodiment of the present invention.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth such as the particular system architecture, techniques, etc., in order to provide a thorough understanding of the embodiments of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail.
In order to illustrate the technical scheme of the invention, the following description is made by specific examples.
Referring to fig. 1, which is a flowchart illustrating an implementation of a method for acquiring a data set according to an embodiment of the present invention, an execution body of the method for acquiring a data set in this embodiment may be a client or a server for storing the data set, and since storage of the data set may be in a database or other storage space, detailed description of a specific storage manner of the data set is omitted in this embodiment.
The method of acquiring a data set as shown in fig. 1 may include:
s11: and if a target instruction accessing to a target result set is detected, determining a target cursor group from cursor groups of the target result set based on an access keyword contained in the target instruction.
In step S11, the data in the target result set corresponds to cursors in the cursor group one by one. The cursor group can be obtained by data storage according to a preset storage rule or can be obtained by setting a fixed arrangement rule.
In this embodiment, the target instruction may specifically be an instruction written in SQL language for processing data in the target result set, where the instruction includes an access key for accessing the target result set.
In all embodiments of the present application, before the target result set is specified, the user may input a corresponding data processing instruction to process the original data set according to the requirement, for example, perform grouping processing on the original data set or perform query processing on the original data set. And processing the original data set to obtain a result set, and determining a target result set from the result set according to the target instruction.
It should be noted that, the timing of detecting whether the target instruction is triggered may include, but is not limited to, the following scenarios.
For example, after processing the original data set, it is detected whether a target instruction accessing the target result set is triggered.
Specifically, grouping processing or query processing is carried out on the original data set, and after a result set is obtained, whether a target instruction for accessing a target result set is triggered or not is detected; the target instruction is used for determining a target result set from the result set and representing a cursor group in the target result set.
It can be appreciated that in practical applications, since the processed result cannot be directly further processed after the original data set is processed, for example, the keyword "Select" cannot be used to directly operate on the processed packet result after the original data is processed BY using the "GOUP BY" statement. In the method for acquiring the data set provided by the embodiment, the cursor group in the target result set pointed by the access keyword is configured, so that when the data in the target result set needs to be further processed, the characteristic of the cursor group corresponding to the grouping pointed by the keyword can be directly utilized, and the direct processing of the grouped result set is realized.
S12: and acquiring a target data set from the target result set based on the access key word and the target cursor group.
In step S12, since the data in the target result set corresponds to the cursors in the target cursor group one by one, that is, the data in the target result set corresponds to one cursor.
It should be noted that the target data set is used to characterize all data in the target result set.
According to the embodiment of the invention, when the target instruction accessing the target result set is detected, the target cursor set is determined from the cursor sets of the target result set based on the access key words contained in the target instruction, and then the target data set is acquired from the target result set based on the access key words and the target cursor set, so that the data set in the target result set is directly acquired, a basis is provided for directly processing target data in the target result set, and the data set acquisition efficiency is improved.
Referring to fig. 2, fig. 2 is a schematic flow chart of a method for acquiring a data set according to another embodiment of the present invention. The difference between this embodiment and the previous embodiment is that step S10 is further included before step S11. Specifically:
s10: configuring a standard file for defining access keywords in a preset Structured Query Language (SQL) rule file to obtain a new SQL rule file; the new SQL rule file is used to describe and respond to target instructions that access a target result set.
In step S10, the SQL rule file is used to define a usage specification of the query statement. The specification file of the access key is a protocol file for describing a data access rule of the access key.
In this embodiment, a preset instruction for determining a target result set from a result set is defined in a new SQL rule file, and when a target instruction for the target result set is detected, a cursor group of the target result set is further obtained by responding to the target instruction.
It should be noted that, in this embodiment, by configuring a specification file for defining an access keyword to an SQL rule file, a new SQL rule file is obtained, and since the new aggregate function rule file is used for describing and responding to a target instruction for determining a target result set from a result set, when a target instruction for the target result set is detected, target data in the target result set may be acquired by responding to the target instruction.
In all embodiments of the present application, the new SQL rule file is configured with a specification file defining an access key, which is a protocol file for describing extraction rules of the access key.
Because the new SQL rule file is used for describing and responding to the target instruction accessing the target result set, when the target data in the target result set needs to be processed, the direct operation on the data in the target result set can be realized by responding to the target instruction containing the access key words.
Further, as a possible implementation manner of this embodiment, the target result set is two or more group data sets obtained by grouping based on the original data set; the access key is used for referring to a cursor group in a target group data set when traversing the group data set, wherein the target group data set is any group data set in two or more group data sets; step S11 may specifically include:
and determining a target group data set from two or more group data sets according to the access keywords, and identifying a cursor group in the target group data set as a target cursor group.
Further, step S12 may specifically include:
and acquiring a target data set pointed by the target cursor group from the target result set.
In this embodiment, the access key is used to refer to a cursor group in a target group dataset when traversing the group dataset, where the target group dataset is any one of two or more group datasets, and supports the cursor group in the target group dataset as a query object, that is, access in the FROM clause of the SELECT statement.
It should be noted that, the existing aggregation function of SQL can count the original data set groups, but cannot perform complex processing on the content in each group after grouping, and is difficult to return the result in the group.
For example:
assume that the score table is called score table, contains the fields: ID. Score, lesson; if we want to count the highest score for each subject, we can use the following statement:
“Select Lesson，Max(Score)from ScoreTable Group By Lesson”
if it is also necessary to learn what each subject is the best, it is complicated and not straightforward to write, and it is inefficient.
In the embodiment, the key words of the grouping cursor groups are added to characterize the cursor groups of the target result set, so that the target result set is accessed and processed. We assume that this keyword is called ThisGroup.
For example, assuming the table of achievements is named ScatTable, with the field class representing class, the ThisGroup may be accessed in sub-queries if access to the contents of each group is required when grouping classes. thisGroup represents a cursor group for each grouping in the data result set.
The implementation statement is "Select Class, select from ThisGroup from ScoreTable group by Class", and in this mode, the packet may be treated not only using an aggregation function, but also as a set of common results.
Further, as a possible implementation manner of this embodiment, the target result set is a hierarchical data set group obtained after performing data query based on the original data set; the access keywords are used for distinguishing a target level data set from the level data set group and referring to a cursor group corresponding to the target level data set; step S11 may specifically include:
and determining a target hierarchical data set from the hierarchical data set according to the access key, and identifying a cursor group corresponding to the target hierarchical data set as a target cursor group.
In this embodiment, the target result set is a hierarchical data set group obtained after data query is performed based on the original data set; the access key is used to reference a cursor group in a target hierarchical dataset, where the target hierarchical dataset may be any one of the hierarchical dataset groups.
Taking the example that the keyword is RefsOf, its syntax is: refs of (Exp, N), where Exp is used to describe the target result set and N is used to specify the target hierarchy.
For example, the highest-ranking result set needs to be accessed in the sub-queries of the group to find the highest-ranking ID of english in each class group, which can be implemented by using the following statement:
“Select Class,Max(English)，(select top 1ID from ThisGroup where English＝RefsOf(Max(English),1))from ScoreTable group by Class”
with RefsOf, we do not need to make any alias for the result set, we can access the upper layer result set, also can access the upper layer result set, etc., so that the access makes the data processing process simpler.
It can be appreciated that when another query statement is nested in the existing query statement, accessing the result set of the parent query statement in the child query statement query is not convenient enough, and when access to the same data list exists between two query operations, different aliases are required for identification, and confusion of semantic understanding is increased. In the method provided by the embodiment, the cursor group in the target level data set is referenced by the access key words, so that the result set of the query can be accessed very conveniently, no matter how many levels of nested queries can be realized by using simpler access key words, and confusion caused by aliases is avoided.
As can be seen from the above, in the embodiment of the present invention, when the target instruction for accessing the target result set is detected, the target cursor set is determined from the cursor set of the target result set based on the access key included in the target instruction, and then the target data set is acquired from the target result set based on the access key and the target cursor set, so that the data set in the target result set is directly acquired, which provides a basis for directly processing the target data in the target result set, and improves the efficiency of acquiring the data set.
Referring to fig. 3, fig. 3 is a schematic block diagram of an apparatus for acquiring a data set according to an embodiment of the present invention. The apparatus 30 for acquiring a data set in this embodiment includes units for performing the steps in the embodiment corresponding to fig. 2, and specifically please refer to the related description in the embodiment corresponding to fig. 2, which is not repeated here. An apparatus 30 for acquiring a data set of the present embodiment includes: a determination unit 301 and an acquisition unit 302. Specifically:
the determining unit 301 is configured to determine, if a target instruction for accessing a target result set is detected, a target cursor group from cursor groups of the target result set based on an access key included in the target instruction.
And the obtaining unit 302 is configured to obtain a target data set from the target result set based on the access key and the target cursor group.
Further, as a possible implementation manner of this embodiment, the apparatus for acquiring a data set 30 further includes: the configuration unit 300 is configured to configure a specification file for defining access keywords in a preset structured query language SQL rule file to obtain a new SQL rule file; the new SQL rule file is used to describe and respond to target instructions that access a target result set.
Further, as a possible implementation manner of this embodiment, the target result set is two or more group data sets obtained by grouping based on the original data set; the access key is used to refer to a cursor group in a target group dataset when traversing the group dataset, the target group dataset being any one of two or more group datasets.
The determining unit 301 is specifically configured to determine a target group data set from two or more of the group data sets according to the access key, and identify a cursor group in the target group data set as a target cursor group.
Further, as a possible implementation manner of this embodiment, the obtaining unit 302 is specifically configured to obtain, from the target result set, a target data set pointed by the target cursor set.
Further, as a possible implementation manner of this embodiment, the target result set is a hierarchical data set group obtained after performing data query based on the original data set; the access keywords are used for distinguishing a target level data set from the level data set group and referring to a cursor group corresponding to the target level data set; the determining unit 301 is specifically further configured to determine, according to the access key, a target hierarchical data set from the hierarchical data set groups, and identify a cursor group corresponding to the target hierarchical data set as a target cursor group.
Referring to fig. 4, a schematic block diagram of a terminal device according to another embodiment of the present invention is provided. The terminal device 400 in the present embodiment as shown in the drawing may include: one or more processors 401; one or more input devices 402, one or more output devices 403, and a memory 404. The processor 401, the input device 402, the output device 403, and the memory 404 are connected by a bus 405. The memory 404 is used for storing, and the computer program includes instructions, and the processor 401 performs the following operations by retrieving the computer program stored in the memory 404:
the processor 401 is configured to: and if a target instruction accessing to a target result set is detected, determining a target cursor group from cursor groups of the target result set based on an access keyword contained in the target instruction.
The processor 401 is configured to: and acquiring a target data set from the target result set based on the access key word and the target cursor group.
As a possible implementation of this embodiment, the processor 401 is further configured to: configuring a standard file for defining access keywords in a preset Structured Query Language (SQL) rule file to obtain a new SQL rule file; the new SQL rule file is used to describe and respond to target instructions that access a target result set.
As one possible implementation manner of this embodiment, the processor 401 is specifically configured to:
as one possible implementation manner of this embodiment, the target result set is two or more group data sets obtained by grouping based on the original data set; the access key is used for referring to a cursor group in a target group data set when traversing the group data set, wherein the target group data set is any group data set in two or more group data sets; the processor 401 is specifically configured to: and determining a target group data set from two or more group data sets according to the access keywords, and identifying a cursor group in the target group data set as a target cursor group.
As one possible implementation manner of this embodiment, the processor 401 is specifically configured to: and acquiring a target data set pointed by the target cursor group from the target result set.
As a possible implementation manner of this embodiment, the target result set is a hierarchical data set group obtained after performing data query based on an original data set; the access keywords are used for distinguishing a target level data set from the level data set group and referring to a cursor group corresponding to the target level data set; the processor 401 is specifically configured to: and determining a target hierarchical data set from the hierarchical data set according to the access key, and identifying a cursor group corresponding to the target hierarchical data set as a target cursor group.
It should be appreciated that in embodiments of the present invention, the processor 501 may be a central processing unit (Central Processing Unit, CPU), which may also be other general purpose processors, digital signal processors (Digital Signal Processor, DSPs), application specific integrated circuits (Application Specific Integrated Circuit, ASICs), off-the-shelf programmable gate arrays (Field-Programmable Gate Array, FPGAs) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The input device 402 may include a touch pad, a fingerprint sensor (for collecting fingerprint information of a user and direction information of a fingerprint), a microphone, etc., and the output device 403 may include a display (LCD, etc.), a speaker, etc.
The memory 404 may include read only memory and random access memory and provide instructions and data to the processor 401. A portion of memory 404 may also include non-volatile random access memory. For example, memory 404 may also store information of device type.
In a specific implementation, the processor 401, the input device 402, and the output device 403 described in the embodiments of the present invention may perform an implementation described in the embodiments of a method for acquiring a data set provided in the embodiments of the present invention, and may also perform an implementation of a device described in the embodiments of the present invention, which is not described herein again.
In another embodiment of the present invention, there is provided a computer-readable storage medium storing a computer program which, when executed by a processor, implements:
if a target instruction for accessing a target result set is detected, determining a target cursor group from cursor groups of the target result set based on an access keyword contained in the target instruction;
and acquiring a target data set from the target result set based on the access key word and the target cursor group.
As a possible implementation manner of this embodiment, the computer program when executed by the processor further implements:
configuring a standard file for defining access keywords in a preset Structured Query Language (SQL) rule file to obtain a new SQL rule file; the new SQL rule file is used to describe and respond to target instructions that access a target result set.
As one possible implementation manner of this embodiment, the target result set is two or more group data sets obtained by grouping based on the original data set; the access key is used for referring to a cursor group in a target group data set when traversing the group data set, wherein the target group data set is any group data set in two or more group data sets; the computer program, when executed by the processor, further implements:
and determining a target group data set from two or more group data sets according to the access keywords, and identifying a cursor group in the target group data set as a target cursor group.
As a possible implementation manner of this embodiment, the computer program when executed by the processor further implements:
and acquiring a target data set pointed by the target cursor group from the target result set.
As a possible implementation manner of this embodiment, the target result set is a hierarchical data set group obtained after performing data query based on an original data set; the access keywords are used for distinguishing a target level data set from the level data set group and referring to a cursor group corresponding to the target level data set; the computer program, when executed by the processor, further implements:
and determining a target hierarchical data set from the hierarchical data set according to the access key, and identifying a cursor group corresponding to the target hierarchical data set as a target cursor group.
As can be seen from the above, in the embodiment of the present invention, when the target instruction for accessing the target result set is detected, the target cursor set is determined from the cursor set of the target result set based on the access key included in the target instruction, and then the target data set is acquired from the target result set based on the access key and the target cursor set, so that the data set in the target result set is directly acquired, which provides a basis for directly processing the target data in the target result set, and improves the efficiency of acquiring the data set.
The computer readable storage medium may be an internal storage unit of the apparatus according to any of the foregoing embodiments, for example, a hard disk or a memory of a computer. The computer readable storage medium may also be an external storage device of the 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, which are provided on the device. Further, the computer readable storage medium may also include both internal storage units and external storage devices of the device. The computer-readable storage medium is used to store the computer program and other programs and data required by the device. The computer-readable storage medium may also be used to temporarily store data that has been output or is to be output.
In addition, each functional unit in the embodiments of the present invention 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 integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including 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 method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (6)
1. A method of acquiring a data set, comprising:
configuring a standard file for defining access keywords in a preset Structured Query Language (SQL) rule file to obtain a new SQL rule file; the new SQL rule file is used for describing and responding to a target instruction of the access target result set, and the standard file of the access key is a protocol file used for describing the data access rule of the access key;
if a target instruction for accessing a target result set is detected, determining a target cursor group from cursor groups of the target result set based on an access keyword contained in the target instruction, wherein the target result set is two or more group data sets obtained by grouping based on an original data set, the access keyword is used for referring to the cursor groups of the target group data set when traversing the group data set, or the target result set is a level data set group obtained by performing data query based on the original data set, and the access keyword is used for distinguishing a target level data set from the level data set group and referring to the cursor group corresponding to the target level data set;
acquiring a target data set from the target result set based on the access key word and the target cursor group;
the target result set is two or more small group data sets obtained by grouping the original data sets; the access key is used for referring to a cursor group of the target group data set when traversing the group data set;
the determining a target cursor group from cursor groups of the target result set based on the access keywords contained in the target instruction comprises:
and determining the target group data set from two or more group data sets according to the access keywords, and identifying a cursor group in the target group data set as a target cursor group.
2. The method of claim 1, wherein the obtaining a target dataset from the target result set based on the access key and the target cursor group comprises:
and acquiring a target data set pointed by the target cursor group from the target result set.
3. The method of claim 1, wherein the target result set is the hierarchical data set group obtained after data query based on the original data set; the access keywords are used for distinguishing the target level data set from the level data set group and referring to a cursor group corresponding to the target level data set;
the determining a target cursor group from cursor groups of the target result set based on the access keywords contained in the target instruction comprises:
and determining the target hierarchical data set from the hierarchical data set according to the access key, and identifying the cursor group corresponding to the target hierarchical data set as a target cursor group.
4. An apparatus for acquiring a data set, the apparatus for acquiring a data set comprising:
the configuration unit is used for configuring a specification file for defining access keywords into a preset Structured Query Language (SQL) rule file to obtain a new SQL rule file; the new SQL rule file is used for describing and responding to a target instruction of the access target result set, and the standard file of the access key is a protocol file used for describing the data access rule of the access key;
the determining unit is used for determining a target cursor group from cursor groups of the target result set based on an access key contained in the target instruction if a target instruction for accessing the target result set is detected, wherein the target result set is two or more group data sets obtained by grouping based on an original data set, the access key is used for referring to the cursor groups of the target group data set when traversing the group data set, or the target result set is a level data set group obtained by carrying out data query based on the original data set, and the access key is used for distinguishing the target level data set from the level data set group and referring to the cursor group corresponding to the target level data set;
the acquisition unit is used for acquiring a target data set from the target result set based on the access key words and the target cursor group;
the target result set is two or more small group data sets obtained by grouping the target result set based on the original data set; the access key is used for referring to a cursor group in a target group data set, and the target group data set is any group data set in two or more group data sets;
the determining unit is specifically configured to determine a target group data set from two or more group data sets according to the access key, and identify a cursor group in the target group data set as a target cursor group.
5. A terminal device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor, when executing the computer program, realizes the steps of the method of acquiring a data set according to any one of claims 1 to 3.
6. A computer-readable storage medium storing a computer program, characterized in that the computer program, when being executed by a processor, implements the steps of the method of acquiring a data set according to any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910164290.6A CN111666294B (en) | 2019-03-05 | 2019-03-05 | Method for acquiring data set, terminal equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910164290.6A CN111666294B (en) | 2019-03-05 | 2019-03-05 | Method for acquiring data set, terminal equipment and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111666294A CN111666294A (en) | 2020-09-15 |
| CN111666294B true CN111666294B (en) | 2024-03-08 |
Family
ID=72381524
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910164290.6A Active CN111666294B (en) | 2019-03-05 | 2019-03-05 | Method for acquiring data set, terminal equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111666294B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115645905B (en) * | 2022-10-21 | 2023-06-20 | 圣名科技(广州)有限责任公司 | Cursor display method and device, electronic equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6226765B1 (en) * | 1999-02-26 | 2001-05-01 | Advantest Corp. | Event based test system data memory compression |
| CN103455338A (en) * | 2013-09-22 | 2013-12-18 | 广州中国科学院软件应用技术研究所 | Method and device for acquiring data |
| CN104504001A (en) * | 2014-12-04 | 2015-04-08 | 西北工业大学 | Massive distributed relational database-oriented cursor creation method |
| CN105354256A (en) * | 2015-10-22 | 2016-02-24 | 浪潮电子信息产业股份有限公司 | Data pagination query method and apparatus |
| WO2016193671A1 (en) * | 2015-06-01 | 2016-12-08 | Mobile Content Management Solutions Limited | Data search method and device |
| CN108874994A (en) * | 2018-06-12 | 2018-11-23 | 北京奇虎科技有限公司 | A kind of piecemeal reads the method, apparatus and computer storage medium of data |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7761451B2 (en) * | 2005-06-17 | 2010-07-20 | Microsoft Corporation | Efficient querying and paging in databases |
| US7836100B2 (en) * | 2007-10-26 | 2010-11-16 | Microsoft Corporation | Calculating and storing data structures including using calculated columns associated with a database system |
-
2019
- 2019-03-05 CN CN201910164290.6A patent/CN111666294B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6226765B1 (en) * | 1999-02-26 | 2001-05-01 | Advantest Corp. | Event based test system data memory compression |
| CN103455338A (en) * | 2013-09-22 | 2013-12-18 | 广州中国科学院软件应用技术研究所 | Method and device for acquiring data |
| CN104504001A (en) * | 2014-12-04 | 2015-04-08 | 西北工业大学 | Massive distributed relational database-oriented cursor creation method |
| WO2016193671A1 (en) * | 2015-06-01 | 2016-12-08 | Mobile Content Management Solutions Limited | Data search method and device |
| CN105354256A (en) * | 2015-10-22 | 2016-02-24 | 浪潮电子信息产业股份有限公司 | Data pagination query method and apparatus |
| CN108874994A (en) * | 2018-06-12 | 2018-11-23 | 北京奇虎科技有限公司 | A kind of piecemeal reads the method, apparatus and computer storage medium of data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111666294A (en) | 2020-09-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP7021228B2 (en) | Blockchain-based data storage and query methods and devices | |
| US10423652B2 (en) | Knowledge graph entity reconciler | |
| US11120019B2 (en) | Adapting a relational query to accommodate hierarchical data | |
| US8468146B2 (en) | System and method for creating search index on cloud database | |
| US20170116260A1 (en) | Using a dimensional data model for transforming a natural language query to a structured language query | |
| MX2013014800A (en) | Recommending data enrichments. | |
| US10878000B2 (en) | Extracting graph topology from distributed databases | |
| WO2021179722A1 (en) | Sql statement parsing method and system, and computer device and storage medium | |
| CN110737689B (en) | Data standard compliance detection method, device, system and storage medium | |
| WO2019161645A1 (en) | Shell-based data table extraction method, terminal, device, and storage medium | |
| WO2023160137A1 (en) | Graph data storage method and system, and computer device | |
| US9239889B2 (en) | Adaptive search and navigation through semantically aware searching | |
| JP6670097B2 (en) | Cross-column retrieval of relational database tables | |
| TW202001621A (en) | Corpus generating method and apparatus, and human-machine interaction processing method and apparatus | |
| CN111666294B (en) | Method for acquiring data set, terminal equipment and computer readable storage medium | |
| CN112347055A (en) | Medical data processing method and system based on cloud computing | |
| US20220138186A1 (en) | Data set acquisition method, terminal device and computer readable storage medium | |
| US20230153455A1 (en) | Query-based database redaction | |
| CN112417154B (en) | Method and device for determining similarity of documents | |
| CN115114420A (en) | Knowledge graph question-answering method, terminal equipment and storage medium | |
| CN114356912A (en) | Method for writing data into database and computer equipment | |
| US20170031909A1 (en) | Locality-sensitive hashing for algebraic expressions | |
| CN111666295B (en) | Data extraction method, terminal device and computer readable storage medium | |
| CN109918367B (en) | Structured data cleaning method and device, electronic equipment and storage medium | |
| CN112395387A (en) | Full-text retrieval method and device, computer storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |