CN109766480B - Data query method and device - Google Patents
Data query method and device Download PDFInfo
- Publication number
- CN109766480B CN109766480B CN201811478387.6A CN201811478387A CN109766480B CN 109766480 B CN109766480 B CN 109766480B CN 201811478387 A CN201811478387 A CN 201811478387A CN 109766480 B CN109766480 B CN 109766480B
- Authority
- CN
- China
- Prior art keywords
- interface
- interactive interface
- resource information
- resource
- module
- 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 28
- 230000002452 interceptive effect Effects 0.000 claims abstract description 145
- 230000003993 interaction Effects 0.000 claims description 18
- 230000001360 synchronised effect Effects 0.000 claims description 8
- 230000008859 change Effects 0.000 claims description 2
- 230000000737 periodic effect Effects 0.000 claims 2
- 238000012217 deletion Methods 0.000 description 11
- 230000037430 deletion Effects 0.000 description 11
- 238000010586 diagram Methods 0.000 description 10
- 238000012545 processing Methods 0.000 description 8
- 238000004590 computer program Methods 0.000 description 5
- 230000000694 effects Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000001545 Page's trend test Methods 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
Landscapes
- Stored Programmes (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data query method and device, which are used for solving the problem that whether a resource is referenced and an object is referenced cannot be queried in the prior art. According to the embodiment of the invention, whether the target resource is referenced or not can be determined according to the binding relation between the resource information and the interface identifier, and the interactive interface corresponding to the interface identifier can be determined according to the interface identifier referencing the target resource. The embodiment of the invention provides a method for inquiring the target resource, which is convenient to operate and further improves the accuracy and efficiency of an inquiring result.
Description
Technical Field
The present invention relates to the field of internet, and in particular, to a method and apparatus for querying data.
Background
Currently, various websites or applications need to arrange the content of the interactive pages displayed to the users, for example, the first page of the search engine displays resources such as songs, videos, commodities and the like, and the content displayed on the interactive pages is more and more rich, so that various heterogeneous data such as resources such as applications, songs, videos, commodities and the like often need to be arranged in an arranging system.
Since the content to be arranged is complex, the data types are more, usually, an arrangement field containing related resource data is created in the arrangement data, wherein the related content capable of representing the resource in the arrangement field is embodied in the form of a character string, when the whole content is arranged, the whole arrangement content is stored in a JSON format, and since the whole content is arranged in one JSON string, the related content about the resource data stored in different JSON strings is different, and the storage forms are different.
At present, the system cannot analyze the resources represented by the character strings, so that it is difficult to accurately inquire which resources are referenced by the arrangement data, but in an actual service scene, if the resources cannot be inquired, whether the resources are used by the on-line arrangement data cannot be determined when the resources are deleted, and once the resources are deleted by mistake, normal operation of on-line service is affected.
In summary, it is not possible to query whether a resource is referenced or not and reference an object.
Disclosure of Invention
The invention provides a data query method and device, which are used for solving the problem that whether a resource is referenced and an object is referenced cannot be queried in the prior art.
The method comprises the following steps:
in a first aspect, a method for querying data provided by an embodiment of the present invention includes:
determining an interface identifier bound with the resource information of the target resource according to the binding relation between the resource information and the interface identifier, wherein the binding relation is generated after the resource information is read from the arrangement data corresponding to the interactive interface according to the set reading rule;
and determining an interactive interface referencing the target resource according to the interface identifier.
According to the method, whether the target resource is referenced or not can be determined according to the binding relation between the resource information and the interface identifier, and the interactive interface corresponding to the interface identifier can be determined according to the interface identifier referencing the target resource. The embodiment of the invention provides a method for inquiring the target resource, which is convenient to operate and further improves the accuracy and efficiency of an inquiring result.
In an alternative embodiment, the binding relationship between the resource identifier and the interface identifier is determined by:
determining interface identification of any interactive interface needing to establish a binding relationship; determining resource information corresponding to the interface identifier from the arrangement data corresponding to the interactive interface according to the reading rule corresponding to the interactive interface; binding the interface identification with the resource information.
In an optional implementation manner, the interactive interface needing to establish the binding relationship is an interactive interface which is not bound with the resource information or an interactive interface containing changed resource information.
In an optional implementation manner, if the interactive interface needs to be deleted, the interface identifier corresponding to the interactive interface needing to be deleted in the binding relationship is removed.
In an optional implementation manner, if the resource information bound to the interface identifier corresponding to the interactive interface to be deleted in the binding relationship is not bound to other interface identifiers, deleting the resource information bound to the interface identifier corresponding to the interactive interface to be deleted from the binding relationship.
In an optional implementation manner, the determining, according to the reading rule corresponding to the interactive interface, resource information corresponding to the interface identifier from the layout data corresponding to the interactive interface includes:
obtaining an Identification (ID) of the arrangement data and an arrangement field corresponding to the ID of the arrangement data from the arrangement data corresponding to the interactive interface according to the reading rule; analyzing resource information corresponding to the interface identifier from the arrangement field according to the reading rule; and the arrangement data is the arrangement data corresponding to the name of the interaction interface bound with the module name in the reading rule.
In a second aspect, an embodiment of the present invention further provides a terminal for querying data, where the terminal includes: a processor and a memory, wherein the memory stores program code that, when executed by the processor, causes the terminal to perform the following:
determining an interface identifier bound with the resource information of the target resource according to the binding relation between the resource information and the interface identifier, wherein the binding relation is generated after the resource information is read from the arrangement data corresponding to the interactive interface according to the set reading rule;
and determining an interactive interface referencing the target resource according to the interface identifier.
In one possible implementation, the processor determines the binding relationship between the resource identifier and the interface identifier by:
determining interface identification of any interactive interface needing to establish a binding relationship; determining resource information corresponding to the interface identifier from the arrangement data corresponding to the interactive interface according to the reading rule corresponding to the interactive interface; binding the interface identification with the resource information.
In one possible implementation manner, the interactive interface to be bound is an interactive interface which is not bound with the resource information or an interactive interface containing changed resource information.
In one possible implementation, the processor is further configured to:
and if the interactive interface needs to be deleted, clearing the interface identifier corresponding to the interactive interface needing to be deleted in the binding relation.
In one possible implementation, the processor is further configured to:
and if the resource information bound with the interface identifier corresponding to the interaction interface to be deleted in the binding relation is not bound with other interface identifiers, deleting the resource information bound with the interface identifier corresponding to the interaction interface to be deleted from the binding relation.
In one possible implementation, the processor is specifically configured to:
obtaining an arrangement data ID and an arrangement field corresponding to the arrangement data ID from the arrangement data corresponding to the interactive interface according to the reading rule; analyzing resource information corresponding to the interface identifier from the arrangement field according to the reading rule; and the arrangement data is the arrangement data corresponding to the name of the interaction interface bound with the module name in the reading rule.
In a third aspect, an embodiment of the present invention further provides a terminal for querying data, where the terminal includes:
the processing module is used for: the interface identification is used for determining the interface identification bound with the resource information of the target resource according to the binding relation between the resource information and the interface identification, wherein the binding relation is generated after the resource information is read from the arrangement data corresponding to the interactive interface according to the set reading rule;
and an operation module: and the interactive interface is used for determining and referencing the target resource according to the interface identification.
In a fourth aspect, the present application also provides a computer storage medium having stored thereon a computer program which when executed by a processor performs the steps of the method of the first aspect.
In addition, the technical effects caused by any implementation manner of the second aspect to the fourth aspect may refer to the technical effects caused by different implementation manners of the first aspect, which are not described herein.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments will be briefly described below, it will be apparent that the drawings in the following description are only some embodiments of the present invention, and that other drawings can be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of a method for querying data according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of creating a module table according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of creating a relationship table according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a query interface according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a terminal for data query according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of another data query terminal according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail below with reference to the accompanying drawings, and it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Embodiments of the invention are described in further detail below with reference to the drawings.
As shown in fig. 1, the embodiment of the invention provides a data query method, which specifically includes the following steps:
step 100: determining an interface identifier bound with the resource information of the target resource according to the binding relation between the resource information and the interface identifier, wherein the binding relation is generated after the resource information is read from the arrangement data corresponding to the interactive interface according to the set reading rule;
step 101: and determining an interactive interface referencing the target resource according to the interface identifier.
Through the scheme, whether the target resource is referenced or not can be determined according to the binding relation between the resource information and the interface identifier, and the interactive interface corresponding to the interface identifier can be determined according to the interface identifier referencing the target resource. The embodiment of the invention provides a method for inquiring the target resource, which is convenient to operate and further improves the accuracy and efficiency of an inquiring result.
The interactive interface in the embodiment of the invention can be a user interface of a webpage or an application.
Resources include, but are not limited to: goods, videos, applications, songs, pictures, web pages, etc.
Table 1 below shows an arrangement module named "home" according to an embodiment of the present invention.
TABLE 1
The interactive interface exists in the form of a piece of arrangement data in the arrangement module, such as the arrangement module containing the arrangement data of 3 web pages in table 1.
The home_layout is the name of an arranging module corresponding to a certain webpage; home_id is an orchestration field ID; home_title is the orchestration field name; navi_ids is an orchestration field containing orchestrated resource data.
The navid in navi_ids is the resource ID field; title is the resource name;
another programming module named "column" provided by an embodiment of the present invention is shown in Table 2 below.
TABLE 2
The column_layout is the name of an arranging module corresponding to a certain webpage; col_id is the orchestration field ID; col_title is the orchestration field name; recids are orchestration fields containing orchestrated resource data.
The ID in rec_ids is a resource ID field; title is the resource name.
It should be noted that the above list is merely exemplary, the content included in the resource information relates to a specific service, and the content in the resource information may also include content such as a license of the resource, and any of different manifestations of the resource information is suitable for the embodiments of the present invention.
The resource ID field and the resource type field are used for determining resource information, the arrangement module comprises a plurality of pieces of arrangement data, each piece of arrangement data corresponds to one interactive interface, and the mode of storing the resource information and the stored content corresponding to different arrangement modules are different.
After resource information is read from the arrangement data corresponding to the interactive interface according to the reading rule, the resource information is bound with the interactive interface, the binding relation is stored, and when a certain resource needs to be inquired, whether the binding relation of the target resource exists or not is searched according to the binding relation of the resource information and the interactive interface, so that whether the target resource is cited or not and which interactive interfaces are cited are determined.
For example, as shown in fig. 2, a reading rule is provided for the embodiment of the present invention, and the following details are described below:
the types of the layout modules to which the interactive interface belongs are uniformly defined, as shown in the following table 3:
| Module_id | Mudule_name |
| 8001 | front page |
| 8002 | Special fence |
| 8013 | Navigation system |
TABLE 3 Table 3
Creating a module table of the layout data, named trace_module, wherein the module_id module type; module_name module name, i.e., the name of the orchestration module; a module_table module list name, namely an arranging module list name to which arranging data corresponding to the interactive interface belongs; a module_scr_field arrangement field, i.e. an arrangement field in the arrangement data corresponding to the interactive interface; a module_field_id module primary key ID, namely an arrangement field ID of arrangement data corresponding to the interactive interface; a module_field_name module title, i.e. a name corresponding to the module primary key ID, hereinafter abbreviated as an orchestration field name; rel_id_field resource ID field name; rel_module_id resource type field name.
Wherein the module type and orchestration field ID may represent an interface identification of the interactive interface.
The sub-items included in the module table are only examples, and may be added or deleted according to the service, for example, a module_data_filter filter condition is added to the module table, so that data that does not need to establish a binding relationship is removed, and the data can be flexibly defined according to the requirement.
For example, a certain type of data has a status attribute status, if the attribute is 1, it indicates that a binding relationship needs to be established for the corresponding data, and if the attribute is 0, it indicates that the binding relationship does not need to be established for the corresponding data, and the data is not processed, so as to reduce the data volume of each traversal.
It should be noted that the sub-items defined in the module table are only examples, and the sub-items in the module table may be added or modified as required, but not every layout data has these corresponding sub-items. Any form of module table that can represent the content of the orchestration data is suitable for use with the present invention.
The module table is described below in conjunction with tables 1 and 2 and 3:
after the creation of the module table is completed, configuring an arrangement module corresponding to the arrangement data of the interactive interface needing to establish the binding relation into the module table, and correspondingly filling the arrangement module according to the module table rule, as shown in the table 4:
TABLE 4 Table 4
The module_id is a defined type of an arranging module, herein, taking home_layout data as an example for description, according to unified definition, the module type module_id of an arranging module of a "front page" is 8000, the module name module_name of the arranging module is a front page, the module table name module_table of the arranging module is "home_layout", the module primary key ID of the arranging data corresponding to an interactive interface in the arranging module is home_id, the module primary key ID of the arranging module is home_title, and the arranging field module_scr_field of the arranging module is navi_ids.
The arrangement field contains a resource ID field name, which is a naviID, and the arrangement module does not define a resource type, and because resource information needs to be determined through the resource ID and the resource type, a user is required to query the type of the resource information referenced in the arrangement module according to a uniform definition.
Determining the resource type of the arranging data according to the uniform definition, and assuming that the arranged resource in the home_layout belongs to navigation type resource, determining the definition corresponding to the navigation type resource as 8013 according to the uniform definition, so that the resource type field in the home_layout is directly defined as 8013 in a module table;
it should be noted that the above-mentioned uniformly defined content is only an example, and can be defined by a user, and a developer can determine a resource type to which the resource information referenced in the layout data belongs.
The manner in which the orchestration module com_layout is configured is similar and will not be described in detail here.
According to the embodiment of the invention, the resource information corresponding to the arrangement data is obtained by periodically inquiring the arrangement data corresponding to the interactive interface which is added to the module table and needs to establish the binding relation.
The method for determining whether the binding relation needs to be established for the layout data corresponding to the interactive interface is various, and is exemplified as follows:
determining the arrangement data needing to establish a binding relationship through the synchronous field of the arrangement data;
and adding a synchronous field rec_sync into the arrangement data, and determining whether the arrangement data needs to establish a binding relation or not through the synchronous field.
Such as: if the arrangement data has no binding relation, the synchronization field defaults to 0; if the arrangement data has a binding relationship, the synchronization field is set to 1.
It should be noted that, if the arrangement data has a binding relationship, but the resource data is modified, and the resource information under the arrangement data has a change, the synchronization field is modified to 0;
the embodiment of the invention provides a mode for reading resource information of the arrangement data in the module table, and the following is exemplified:
select trace_module.module_field_id,trace_module.module_src_field from trace_module.module_table t where t.del＝0and t.rec_sync＝0；
the del is a deletion parameter of the interactive interface, and the deletion parameter of the layout data corresponding to the interactive interface added to the module table defaults to 0; if the interactive interface added to the module table is deleted, the deletion parameter del of the layout data corresponding to the deleted interactive interface is set to 1.
The above code paraphrasing: and determining the arrangement data in the arrangement module which needs to establish the binding relation from the module table trace_module, namely reading the module_field_id arrangement field ID and the module_scr_field arrangement field corresponding to the arrangement field ID from the arrangement data corresponding to the module_ID with the synchronous field of 0 and the deletion parameter del of 0.
After the arrangement field is obtained, the resource information in the arrangement field, such as a rel_id_field resource ID field name, a rel_module_id resource type field name, and the like, is analyzed.
For example: reading an arrangement field ID-home_id and an arrangement field name_ids corresponding to the home_id from the home_layout; the resource ID field naviID in navi_ids, resource type field name 8013 is parsed.
In combination with the contents of table 1, the contents are a part of data in home_layout, and for the first line of data in home_layout, the analysis results are as follows:
module_ID＝8000；
module_field_id＝home_id＝1；
module_scr_field＝navi_ids；
rel_id_field＝naviID＝41；
rel_module_id＝8013；
and determining resource information according to the resource ID field and the resource type field, and storing the binding relation between the interface identification of the interactive interface and the resource information.
As for various modes of storing the binding relationship, the embodiment of the invention provides a mode of storing the binding relationship, as shown in fig. 3, the embodiment of the invention provides a form of a relationship list, associates the relationship list with each sub-item in the module list, and stores the query result to the corresponding sub-item of the relationship list.
Firstly, establishing a relation list named trace_object_relation, wherein ID is a main key, and the relation list corresponds to a main key in a module_field_id module main key ID in a module list; the related_object_type is a resource type, and corresponds to a resource type field name rel_module_id in a module table; the related_object_id is a resource ID, and corresponds to a resource type field name rel_module_id in the module table; the module_id is the referenced Module type and corresponds to the module_id Module type in the Module table; object_id is an orchestration field ID in the correspondence table.
The interface identifier of the interactive interface is denoted by (module_id, object_id), and it should be noted that the interface identifiers of the interactive interfaces in different lists have different manifestations.
And combining the query result of the first piece of layout data of the home_layout, determining resource information according to the resource ID field and the resource type field of the home_layout, and storing the binding relation between the interface identifier of the interactive interface and the resource information, wherein the corresponding relation among the sub-items such as the relation table, the module table, the query result and the like is shown in the following table 5:
| module meter | module_ID | module_field_id | rel_id_field | rel_module_id |
| Relationship table | module_ID | Object_id | relative_object_id | relative_object_type |
| home_layout | 8000 | home_id | naviID | Navigation system |
| QueryingResults | 8000 | 1 | 41 | 8013 |
TABLE 5
And so on, analyzing the resource information contained in the arranging field in the home_layout, and storing the binding relation between the resource ID field and the resource type field which represent the resource information and the interface identifier of the interactive interface in a relation list, wherein the binding relation between part of the resource information displayed in the relation list and the interface identifier is shown in the following table 6.
TABLE 6
It should be noted that the above relation table is only an example, sub-items in the relation table may be added or modified according to needs, and any binding relation capable of representing the resource information and the interface identifier of the interactive interface is suitable for the present invention.
After all the binding relations of the interactive interfaces which are added into the module table and need to establish the binding relations are stored into the relation table, when the target resource is inquired, the interface identification which references the target resource can be determined according to the binding relations of the resource information and the interface identification, and then the interactive interface which references the target resource is determined through the interface identification.
The method for inquiring the binding relation of the target resource is various, and an embodiment of the invention provides an implementation manner, and the detailed description is as follows:
select tor.relative_object_type as relativeModuleId,tor.relative_object_id as relativeId,tm.module_id as moduleId,tm.module_name as moduleName,tor.object_id as objectId,t.$moduleFieldName$as objectName
from trace_object_relation tor
left join trace_module tm on tor.module_id＝tm.module_id
left join$moduleTable$t on tor.object_id＝t.$moduleFieldId$
where tor.module_id＝#moduleId#and tor.relative_object_type in($relativeModuleId$)
and tor.relative_object_id in($relativeId$)
the above code paraphrasing: the query resource type is relativeModuleId, the resource id is the layout data reference corresponding to the interactive interfaces of the target resource of the relativeId, each sub-item in the result interface for displaying the query result is associated with the related sub-item in the relation table trace_mode_relation and the module table trace_mode, and the queried binding relation is displayed on the corresponding sub-item in the result interface.
The module ID is associated with the module_id in the relation table, and is the referenced module ID, namely the module type of the arranging module in the interactive interface;
the moduleName is associated with a module_name in the module table, and is the name of the arranging module corresponding to the moduleId, namely the name of the arranging module;
the objectId is associated with the object_id in the relation table, and is a primary key ID representing the orchestration module corresponding to the moduleId;
the relational module ID is associated with the relational object type in the relational table, the resource type of the resource information corresponding to the arrangement field ID in the arrangement module corresponding to the moduleId;
the relativeId is associated with a relativeObject_id in the relation table, and is a resource ID corresponding to an arrangement field ID in an arrangement module corresponding to the moduleId;
the objectName is associated with the module_field_name in the module table, and is the name corresponding to the arranging field ID in the arranging module corresponding to the module ID.
The correspondence of the query results obtained in the above manner is shown in table 7 below:
TABLE 7
For example, the relationship list is used to query the relationship of the target resource with the resource ID of 41 and the resource type of 8013, and the obtained query result is shown in the following table 8:
TABLE 8
It should be noted that the above query manner is merely an example, and many manners of querying target resources are provided, and the embodiment of the present invention supports hybrid query, and queries multiple target resources at the same time, for example, the types of the resources and the ids of the resources of the query target resources are respectively (8002,6), (2005,6), (8011,6), (8008,6), (8010,6) binding relationships.
As shown in fig. 4, the query result of the target resource applied is obtained by searching the resource ID and the resource type.
If the interactive interface in the module table needs to be deleted, the binding relation of the interface identifier of the deleted interactive interface needs to be removed, if the interactive interface is deleted, the deletion parameter del of the corresponding interactive interface in the module is set to be 1, the deleted interactive interface is determined by regularly inquiring the module table, and the interface identifier corresponding to the deleted interactive interface in the binding relation is removed.
The deletion modes provided in the embodiments of the present invention are various, and the following are exemplified:
deletion mode one: and deleting only the interface identifier of the interactive interface, and clearing the resource information if the resource information bound with the deleted interface identifier is not bound with other interface identifiers.
For example, the binding relationship shown in table 6 is incorporated.
If the name "head page test" in home_layout is to be deleted, the interface is identified as (module_id, object_id): (8000,8), all records of module_id=8000 and object_id=8 are deleted in the binding relationship, and the result after deletion is shown in table 9 below.
TABLE 9
And if the resource information bound with the interface identifier of the interaction interface to be deleted in the binding relationship is not bound with other interface identifiers, deleting the resource information bound with the interface identifier corresponding to the interaction interface to be deleted from the binding relationship.
For example, in connection with table 6, the interactive interface of module_id=8000 and object_id=8 is deleted, and the deletion result is shown in table 10 below.
Table 10
And a second deletion mode: and clearing the interface identifier and the bound resource information in the binding relation.
In connection with table 3, if the interactive interface of module_id=8000 and object_id=8 is deleted, the result after deletion can be seen in table 10.
Based on the same concept, as shown in fig. 5, an embodiment of the present invention provides a terminal for data query, including: a processor 500 and a memory 501, wherein the memory 501 stores program code that, when executed by the processor 500, causes the terminal to perform the following process:
determining an interactive interface identifier of the resource information binding of the target resource according to the binding relation between the resource information and the interactive interface identifier, wherein the binding relation is generated after the resource information is read from the arrangement data corresponding to the interactive interface identifier according to a reading rule;
and determining an interactive interface referencing the target resource according to the interactive interface identifier.
Optionally, the processor 500 is further configured to determine a binding relationship between the resource information and the interactive interface identifier by:
determining interface identification of any interactive interface needing to establish a binding relationship;
determining resource information corresponding to the interactive interface identification from the arrangement data corresponding to the interactive interface according to the reading rule corresponding to the interactive interface;
binding the interactive interface identification with the resource information.
Optionally, the interactive interface needing to establish the binding relationship is an interactive interface which is not bound with the resource information or an interactive interface containing the consultation information which is changed.
Optionally, the processor 500 is further configured to:
and if the interactive interface needs to be deleted, clearing the interface identifier corresponding to the interactive interface needing to be deleted in the binding relation.
Optionally, the processor 500 is further configured to:
and if the resource information bound with the interface identifier corresponding to the interaction interface to be deleted in the binding relation is not bound with other interface identifiers, deleting the resource information bound with the interface identifier corresponding to the interaction interface to be deleted from the binding relation.
Optionally, the processor 500 is specifically configured to:
obtaining an arrangement data ID and an arrangement field corresponding to the arrangement data ID from the arrangement data corresponding to the interactive interface according to the reading rule;
analyzing resource information corresponding to the interface identifier from the arrangement field according to the reading rule;
and the arrangement data is the arrangement data corresponding to the name of the interaction interface bound with the module name in the reading rule.
As shown in fig. 6, an embodiment of the present invention provides another terminal for querying data, including:
processing module 601: the interactive interface identification is used for determining the resource information binding of the target resource according to the binding relation between the resource information and the interactive interface identification, wherein the binding relation is generated after the resource information is read from the arrangement data corresponding to the interactive interface identification according to the reading rule;
operation module 600: and determining an interactive interface referencing the target resource according to the interactive interface identifier.
Optionally, the processing module 601 is further configured to determine a binding relationship between the resource information and the interactive interface identifier by:
determining interface identification of any interactive interface needing to establish a binding relationship;
determining resource information corresponding to the interactive interface identification from the arrangement data corresponding to the interactive interface according to the reading rule corresponding to the interactive interface;
binding the interactive interface identification with the resource information.
Optionally, the interactive interface needing to establish the binding relationship is an interactive interface which is not bound with the resource information or an interactive interface containing the consultation information which is changed.
Optionally, the processing module 601 is further configured to:
and if the interactive interface needs to be deleted, clearing the interface identifier corresponding to the interactive interface needing to be deleted in the binding relation.
Optionally, the processing module 601 is further configured to:
and if the resource information bound with the interface identifier corresponding to the interaction interface to be deleted in the binding relation is not bound with other interface identifiers, deleting the resource information bound with the interface identifier corresponding to the interaction interface to be deleted from the binding relation.
Optionally, the processing module 601 is specifically configured to:
obtaining an arrangement data ID and an arrangement field corresponding to the arrangement data ID from the arrangement data corresponding to the interactive interface according to the reading rule;
analyzing resource information corresponding to the interface identifier from the arrangement field according to the reading rule;
and the arrangement data is the arrangement data corresponding to the name of the interaction interface bound with the module name in the reading rule.
The embodiment of the invention also provides a computer readable nonvolatile storage medium, which comprises program code, wherein the program code is used for enabling a computing terminal to execute the steps of the method for data query in the embodiment of the invention when the program code runs on the computing terminal.
The present application is described above with reference to block diagrams and/or flowchart illustrations of methods, apparatus (systems) and/or computer program products according to embodiments of the application. It will be understood that one 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 computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, and/or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer and/or other programmable data processing apparatus, create means for implementing the functions/acts specified in the block diagrams and/or flowchart block or blocks.
Accordingly, the present application may also be embodied in hardware and/or in software (including firmware, resident software, micro-code, etc.). Still further, the present application may take the form of a computer program product on a computer-usable or computer-readable storage medium having computer-usable or computer-readable program code embodied in the medium for use by or in connection with an instruction execution system. In the context of this application, a computer-usable or computer-readable medium may be any medium that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present invention without departing from the spirit or scope of the invention. Thus, it is intended that the present invention also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.
Claims (12)
1. A method of data querying, the method comprising:
according to the binding relation between the resource information and the interface identifier, determining a first interface identifier bound with first resource information of a target resource, so that an interactive interface referencing the target resource can be accurately inquired when the target resource needs to be deleted or modified; the resource information is read from arrangement data according to a set reading rule, the arrangement data corresponds to the name of an interactive interface bound with the module name in the reading rule, and the data is added to the interactive interface corresponding to the interactive interface needing to establish a binding relation in a module table through periodic inquiry; the binding relation is generated after the resource information is read, and the interaction interface and the interface identifier have a corresponding relation;
determining an interactive interface referencing the target resource according to the first interface identifier;
the binding relation is generated according to the interface identification and the resource information in the arrangement data corresponding to the interactive interface; and the establishment of the binding relationship is realized by adding a synchronous field into the arrangement data, and determining whether the arrangement data needs to establish the binding relationship or not through the synchronous field.
2. The method of claim 1, wherein the binding of the resource identifier and the interface identifier is determined by:
determining interface identification of any interactive interface needing to establish a binding relationship;
determining resource information corresponding to the interface identifier from the arrangement data corresponding to the interactive interface according to the reading rule corresponding to the interactive interface;
binding the interface identification with the resource information.
3. The method of claim 2, wherein the interactive interface to be bound is an interactive interface not bound to the resource information or an interactive interface containing a change in the resource information.
4. The method of claim 2, wherein the method further comprises:
and if the interactive interface needs to be deleted, clearing the interface identifier corresponding to the interactive interface needing to be deleted in the binding relation.
5. A method as claimed in claim 3, characterized in that the method further comprises:
and if the resource information bound with the interface identifier corresponding to the interaction interface to be deleted in the binding relation is not bound with other interface identifiers, deleting the resource information bound with the interface identifier corresponding to the interaction interface to be deleted from the binding relation.
6. The method according to any one of claims 2 to 5, wherein determining the resource information corresponding to the interface identifier from the layout data corresponding to the interactive interface according to the reading rule corresponding to the interactive interface includes:
obtaining an arrangement data identification ID and an arrangement field corresponding to the arrangement data ID from the arrangement data corresponding to the interactive interface according to the reading rule;
and according to the reading rule, analyzing the resource information corresponding to the interface identifier from the arrangement field.
7. A terminal for data query, the terminal comprising: a processor and a memory, wherein the memory stores program code that, when executed by the processor, causes the terminal to perform the following:
according to the binding relation between the resource information and the interactive interface identifier, determining a first interactive interface identifier of a target resource, to which the first resource information of the target resource is bound, so that an interactive interface referencing the target resource can be accurately inquired when the target resource needs to be deleted or modified; the resource information is read from arrangement data according to a set reading rule, the arrangement data corresponds to the name of an interactive interface bound with the name of a module in the reading rule, and the data corresponds to the interactive interface which is added into a module table and needs to establish a binding relationship through periodic inquiry; the binding relation is generated after the resource information is read, and the interaction interface and the interface identifier have a corresponding relation;
determining an interactive interface referencing the target resource according to the first interactive interface identifier;
the binding relation is generated according to the interface identification and the resource information in the arrangement data corresponding to the interactive interface; and the establishment of the binding relationship is realized by adding a synchronous field into the arrangement data, and determining whether the arrangement data needs to establish the binding relationship or not through the synchronous field.
8. The terminal of claim 7, wherein the processor is further configured to determine the binding relationship of the resource information with the interactive interface identifier by:
determining interface identification of any interactive interface needing to establish a binding relationship;
determining resource information corresponding to the interactive interface identification from the arrangement data corresponding to the interactive interface according to the reading rule corresponding to the interactive interface;
binding the interactive interface identification with the resource information.
9. The terminal of claim 8, wherein the interactive interface to be bound is an interactive interface not bound with resource information or an interactive interface containing changed consultation information.
10. The terminal of claim 8, wherein the processor is further configured to:
and if the interactive interface needs to be deleted, clearing the interface identifier corresponding to the interactive interface needing to be deleted in the binding relation.
11. The terminal of claim 9, wherein the processor is further configured to:
and if the resource information bound with the interface identifier corresponding to the interaction interface to be deleted in the binding relation is not bound with other interface identifiers, deleting the resource information bound with the interface identifier corresponding to the interaction interface to be deleted from the binding relation.
12. The terminal according to any of the claims 7-11, wherein the processor is specifically configured to:
obtaining an arrangement data ID and an arrangement field corresponding to the arrangement data ID from the arrangement data corresponding to the interactive interface according to the reading rule;
and according to the reading rule, analyzing the resource information corresponding to the interface identifier from the arrangement field.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811478387.6A CN109766480B (en) | 2018-12-05 | 2018-12-05 | Data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811478387.6A CN109766480B (en) | 2018-12-05 | 2018-12-05 | Data query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109766480A CN109766480A (en) | 2019-05-17 |
| CN109766480B true CN109766480B (en) | 2024-02-23 |
Family
ID=66450336
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811478387.6A Active CN109766480B (en) | 2018-12-05 | 2018-12-05 | Data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109766480B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112667690B (en) * | 2021-01-29 | 2023-07-18 | 浪潮通用软件有限公司 | Data reference query method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060212792A1 (en) * | 2005-03-18 | 2006-09-21 | Microsoft Corporation | Synchronously publishing a web page and corresponding web page resources |
| CN102306164A (en) * | 2010-08-04 | 2012-01-04 | 微软公司 | The later stage resource localization that is used for the WEB service is bound |
| CN104484169A (en) * | 2014-12-09 | 2015-04-01 | 成都视达科信息技术有限公司 | Android software user interface generating method and system and Android application system |
-
2018
- 2018-12-05 CN CN201811478387.6A patent/CN109766480B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060212792A1 (en) * | 2005-03-18 | 2006-09-21 | Microsoft Corporation | Synchronously publishing a web page and corresponding web page resources |
| CN102306164A (en) * | 2010-08-04 | 2012-01-04 | 微软公司 | The later stage resource localization that is used for the WEB service is bound |
| CN104484169A (en) * | 2014-12-09 | 2015-04-01 | 成都视达科信息技术有限公司 | Android software user interface generating method and system and Android application system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109766480A (en) | 2019-05-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP5721818B2 (en) | Use of model information group in search | |
| US8560519B2 (en) | Indexing and searching employing virtual documents | |
| US10073881B2 (en) | Platform for authoring, storing, and searching workflows | |
| TWI564737B (en) | Web search methods and devices | |
| CN103793428B (en) | The generation method and device of web page digest information | |
| CN107870915B (en) | Indication of search results | |
| CN108228657B (en) | Method and device for realizing keyword retrieval | |
| CN103873318A (en) | Website automated testing method and automated testing system | |
| CN107391528B (en) | Front-end component dependent information searching method and equipment | |
| CN110969000B (en) | Data merging processing method and device | |
| CN110975293A (en) | Method, device, server and medium for establishing resource reference relation table | |
| US10789277B2 (en) | Systems methods, and apparatuses for creating, linking and discovering business navigation maps for analyzing data | |
| CN115422167B (en) | Cross-data source database view visualization construction method and system | |
| CN116680354A (en) | Metadata management method and system for lithium battery production and manufacturing industry | |
| CN109766480B (en) | Data query method and device | |
| US20170277687A1 (en) | System and methods for searching documents in a relational database using a tree structure stored in a tabular format | |
| US20140122693A1 (en) | Web Navigation Tracing | |
| CN107291951B (en) | Data processing method, device, storage medium and processor | |
| US20110029480A1 (en) | Method of Compiling Multiple Data Sources into One Dataset | |
| CN106570004B (en) | Data management method and device | |
| CN113392070B (en) | Online document management method, device, system, equipment and storage medium | |
| US9426237B2 (en) | Web navigation using web navigation pattern histories | |
| CN112328837A (en) | Data display method, device, equipment and storage medium | |
| CN107463570B (en) | Document retrieval/analysis method and device | |
| US10074058B2 (en) | Management method, management device, and management system |
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 |