CN116561132A - Service data query method, electronic device and readable storage medium - Google Patents
Service data query method, electronic device and readable storage medium Download PDFInfo
- Publication number
- CN116561132A CN116561132A CN202310821466.7A CN202310821466A CN116561132A CN 116561132 A CN116561132 A CN 116561132A CN 202310821466 A CN202310821466 A CN 202310821466A CN 116561132 A CN116561132 A CN 116561132A
- Authority
- CN
- China
- Prior art keywords
- service
- data
- service data
- interface
- index
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 71
- 238000012360 testing method Methods 0.000 claims description 19
- 238000013507 mapping Methods 0.000 claims description 18
- 230000002776 aggregation Effects 0.000 claims description 17
- 238000004220 aggregation Methods 0.000 claims description 17
- 238000001914 filtration Methods 0.000 claims description 13
- 238000012986 modification Methods 0.000 claims description 10
- 230000004048 modification Effects 0.000 claims description 10
- 238000012545 processing Methods 0.000 claims description 8
- 230000001960 triggered effect Effects 0.000 claims description 8
- 230000004931 aggregating effect Effects 0.000 claims description 7
- 239000004973 liquid crystal related substance Substances 0.000 claims description 3
- 238000004590 computer program Methods 0.000 description 14
- 230000008569 process Effects 0.000 description 10
- 238000010586 diagram Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 6
- 230000009286 beneficial effect Effects 0.000 description 4
- 238000007726 management method Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 230000018109 developmental process Effects 0.000 description 3
- 238000012544 monitoring process Methods 0.000 description 3
- 238000012935 Averaging Methods 0.000 description 2
- 230000009471 action Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 238000013480 data collection Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000012384 transportation and delivery Methods 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000010367 cloning Methods 0.000 description 1
- 208000010877 cognitive disease Diseases 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000036541 health Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000033772 system development Effects 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- 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/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/244—Grouping and aggregation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24542—Plan optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Operations Research (AREA)
- Human Computer Interaction (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a service data query method, electronic equipment and a readable storage medium, wherein the service data query method comprises the following steps: acquiring at least one service association field selected by a user under a service theme corresponding to a service to be queried, wherein the service to be queried is a service waiting for service data query and lacking standard data indexes; generating a service data index of the service to be queried according to the service data fields which are jointly aggregated by the service association fields; and inquiring to obtain the service data of the service to be inquired according to the service data index. The method and the device solve the technical problem of low query efficiency of service data.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a service data query method, an electronic device, and a readable storage medium.
Background
With the continuous development of computer technology, it is considered that the daily business operations through software systems such as ERP (Enterprise Resource Planning ) and CRM (Customer Relationship Management, customer relationship management) are mainstream, and in the delivery link of a software manufacturer, it is generally required to present business data to a service object to feed back the current operation status, so the query about the business data is an unavoidable loop in the operation and maintenance process of the software manufacturer.
At present, service data is generally queried by writing codes by professional developers, but because the data volume of the service data is huge, the developers need to write a language very well when querying the data, and differentiated query is performed on the service data of different service objects, so that the situation that the developers write the same codes repeatedly easily occurs, and the current query efficiency of the service data is low.
Disclosure of Invention
The main purpose of the application is to provide a service data query method, electronic equipment and readable storage medium, which aim to solve the technical problem of low query efficiency of service data in the prior art.
In order to achieve the above object, the present application provides a service data query method, where the service data query method includes:
acquiring at least one service association field selected by a user under a service theme corresponding to a service to be queried, wherein the service to be queried is a service waiting for service data query and lacking standard data indexes;
generating a service data index of the service to be queried according to the service data fields which are jointly aggregated by the service association fields;
And inquiring to obtain the service data of the service to be inquired according to the service data index.
In order to achieve the above object, the present application further provides a service data query device, where the service data query device includes:
the system comprises an acquisition module, a query module and a query module, wherein the acquisition module is used for acquiring at least one service association field selected by a user under a service theme corresponding to a service to be queried, wherein the service to be queried is a service waiting for service data query and lacking a standard data index;
the generation module is used for generating the service data index of the service to be queried according to the service data fields which are jointly aggregated by the service association fields;
and the query module is used for querying and obtaining the service data of the service to be queried according to the service data index.
The application also provides an electronic device comprising: the system comprises a memory, a processor and a program of the service data query method stored in the memory and capable of running on the processor, wherein the program of the service data query method can realize the steps of the service data query method when being executed by the processor.
The present application also provides a computer-readable storage medium having stored thereon a program for implementing a service data query method, which when executed by a processor implements the steps of the service data query method as described above.
The present application also provides a computer program product comprising a computer program which, when executed by a processor, implements the steps of the business data query method as described above.
The application provides a service data query method, electronic equipment and a readable storage medium, namely, at least one service association field selected by a user under a service theme corresponding to a service to be queried is obtained, wherein the service to be queried is a service waiting for service data query and lacking standard data indexes; generating a service data index of the service to be queried according to the service data fields which are jointly aggregated by the service association fields; and inquiring to obtain the service data of the service to be inquired according to the service data index. After the user selects the service association field under the theme corresponding to the service to be queried, the service data index of the service to be queried can be generated through the service association field, and the service data of the service to be queried is finally queried according to the service data index, so that the purpose that the user can automatically query and obtain the service data of the service to be queried only by simply configuring the service association field of the service to be queried can be achieved, namely, a semi-automatic query means is provided for a developer to query the service data. Rather than relying entirely on manually written query codes when querying business data. Therefore, the problem that due to huge data volume of service data, developers need to write language very well when querying the data, and differentiated query is carried out on the service data of different service objects, the situation that the developers write the same code repeatedly is solved easily is solved, and therefore the query efficiency of the service data is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the application and together with the description, serve to explain the principles of the application.
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required to be used in the description of the embodiments or the prior art will be briefly described below, and it will be obvious to those skilled in the art that other drawings can be obtained from these drawings without inventive effort.
Fig. 1 is a flow chart of a service data query method according to an embodiment of the present application;
fig. 2 is a flow chart of a service data query method provided in the second embodiment of the present application;
fig. 3 is a schematic structural diagram of a service data query device according to a third embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device according to a fourth embodiment of the present application.
The implementation, functional features and advantages of the present application will be further described with reference to the accompanying drawings in conjunction with the embodiments.
Detailed Description
In order to make the above objects, features and advantages of the present invention more comprehensible, the following description of the embodiments accompanied with the accompanying drawings will be given in detail. It will be apparent that the described embodiments are only some, but not all, embodiments of the invention. 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.
In the first embodiment of the present application, it should be understood that, firstly, in terms of a delivery layer of a software manufacturer, by presenting a data index to a service object and obtaining any desired service data, and further feeding back a current running condition through the service data, a professional developer is generally required to write a query code, locate a specific interface and a calling manner in massive data, so as to query and obtain the service data, that is, for a service person who does not know a database and an SQL statement, the service person cannot autonomously perform a query on the service data, which results in the need of resorting to related developers, and meanwhile, the developer is required to write the same code repeatedly when querying the service data for different service objects, so that a method for improving the query efficiency of the service data is needed at present.
In a first embodiment of the service data query method, referring to fig. 1, the service data query method includes:
step S10, at least one service association field selected by a user under a service theme corresponding to a service to be queried is obtained, wherein the service to be queried is a service waiting for service data query and lacking a standard data index;
Step S20, generating a service data index of the service to be queried according to the service data fields which are jointly aggregated by the service association fields;
and step S30, inquiring to obtain the service data of the service to be inquired according to the service data index.
In this embodiment, it should be noted that, the service to be queried is a service waiting for querying service data and lacking standard data indexes, specifically may be a quality check data query service, a monitor data query service or an application data query service, where the service data query method is deployed in a service data query device of a software producer, the service data query device may specifically be a computer, a personal PC, a server, etc., the service topics are used to characterize topics under different service lines, specifically may be topics such as system function application data, service data, alarms generated by a system, two-way data, consultation use of the system, abnormal data of the system, and overall use condition of the system, where the service association field is used to characterize data fields associated with the service topics, for example, in an embodiment, if the service topics are alarm events, the field names of the service association fields under the service theme include an alarm number, a tenant id (Identity document, identity number), a tenant name, an area, an alarm object, a handler name and the like, wherein the field types of the service association fields can be text, the service data fields are used for representing output data fields under the service theme, and the aggregation mode can be specifically data summation, counting, averaging and the like, for example, in one implementation mode, the service data fields can be { { { a } { a.tenant_id = @ tenant }, the service data indexes can be used for representing query identifications of service data, and can be specifically SQL statement data sets for querying the service data, wherein the data set names of the service data indexes can be specifically the number of monthly users, the distribution of sales system access, the total volume of approval of the sales system in the period, the standard data index is used for representing the query identification of standard service data, the standard service data is used for representing the service data of conventional service, and the definition of the conventional service can be obtained by operation and maintenance personnel, developers and service object parties.
Additionally, it should be noted that, for the current situation that it is difficult for the current business personnel to query the business data, a standardized and normalized data asset is established through a preset data warehouse, in the preset data warehouse, the business data is divided according to the difference of business lines, topics such as system function application data, business data, two-way data and consultation use of the system (designing, each topic includes three-level business data of an operation layer (ODS), a detail layer (CDM) and an application layer (ADS), wherein, different topics take business plate + business process + analysis dimension as an architecture, a naming specification and a unified data index are established under different topics, topic domains can be divided, the topic domains can include a customer infrastructure domain, a customer product domain, a user action domain, an alarm monitoring domain, a product application domain, a risk monitoring domain, a system health domain, and the like, the data sources of the business data under different topics can be sourced from cloud customer service systems (a single system or a knowledge base, etc.), project development systems or cloud service objects can be generated in the corresponding topic data collection and the new topic data through the new-established connection between the corresponding topic nodes in the preset data warehouse, the corresponding topic domains can be generated in turn through the corresponding topic data collection management data of the three-management domains, and synchronize the details and results of each topic into a database.
Additionally, it should be noted that, in order to facilitate the user to intuitively execute the query flow of the service data, a corresponding visual configuration interface is configured at different flow stages, for example, the user may perform configuration of the service theme at the theme configuration interface, where the theme configuration includes a service data index configuration item, a data source configuration item and a theme data table configuration item, where the service data index configuration item includes a custom data index item and a standard data index item, where the standard data index item includes a data set name of the standard data index, a service theme, an application system, a service data source, and the like, the user may perform cloning and viewing operations at the standard data index item, may perform configuration of the custom data index in the custom data index item when the standard data index is difficult to satisfy a service complaint, may first perform selection of the service theme at the custom data index item, may further select a service association field at the field selection interface after the selection of the service theme, may click a "generate a data index" button at the custom data index item after the relevant content configuration is completed, and may trigger to generate a custom service data index, and further may perform a query operation in response to the data query mode of the data set of the user when the data set is difficult to satisfy the service data index, thereby the query mode is difficult to be performed by a user to search the service data set.
As an example, steps S10 to S30 include: acquiring a service theme selected by a user on a theme configuration interface for a service to be queried, and acquiring at least one service association field selected by the user under the service main body, wherein the service to be queried is a service waiting for service data query and lacking standard data indexes; aggregating the service associated fields through data field summation to obtain service data fields, and generating service data indexes of the service to be queried according to a data index generation instruction input by a user in the theme configuration interface, wherein the data index generation instruction can be triggered specifically by clicking a data index generation button in the theme configuration interface; and querying the source service database by taking the service data index as an index to obtain the service data of the service to be queried.
According to the method and the system, the visual theme configuration interface is used for acquiring the service theme selected by the user for the service to be queried and a plurality of service association fields under the service theme, the service association fields are further aggregated into the service data fields in a digital section summation aggregation mode, the service data indexes are generated through the data index generation instruction triggered by the user on the theme configuration interface, finally the service data indexes are used as indexes, the service data of the service to be queried are queried in the source service database, namely, the user can realize the purpose of interactively querying and obtaining the service data of the service to be queried through simple man-machine interaction on the theme configuration interface, and as the service theme and the service association fields under the service theme have no technical cognitive disorder for service personnel, the service personnel can still quickly query and obtain the service data of the service lacking the standard data indexes when the code writing capability is weak, and can only help professional developers to write related codes when querying the service data, so that the query efficiency of the service data is improved.
Wherein, the step of generating the service data index of the service to be queried according to the service data fields aggregated together by the service association fields includes:
step A10, aggregating each service association field according to a preset aggregation mode to obtain a service aggregation field;
step A20, filtering the service aggregation field to obtain the service data field;
and step A30, generating a service data index when the service preview data of the service data field in the corresponding data query period is detected to be the service data of the service to be queried.
In this embodiment, it should be noted that, the service aggregation field is used to characterize a data field obtained by aggregating the service association field in a preset aggregation manner, where the preset aggregation manner may specifically be summing, counting, averaging, etc. for data, after obtaining the service aggregation field, if a service data index is directly generated, in a subsequent process of querying service data, since more data conforms to the service data field, and a great amount of query time will be consumed in a query process, before the service data index is generated, i.e. in a data field configuration stage, relevant content is filtered by adding a filtering condition, where the filtering condition may specifically be determined by a service person based on an actual configuration requirement, for example, in an embodiment, the service person may have a system time built in the system, and in the future, for the service person to modify a query period range of the service data, and meanwhile, the service person may configure specific filtering parameters in a filtering condition configuration interface according to own requirement, for example, a setting condition of the filtering parameter is as follows: the service association field may be a tenant name, the operator may be equal to 20, 30 or 40, and the value and the parameter may be 20, 30 or 40, and after filtering through specific filtering conditions, redundant data may be avoided when service data meeting the conditions is queried subsequently.
In addition, it should be noted that, in order to avoid that the directly output service data is not the service data of the service to be queried, so as to cause the situation of repeatedly configuring the query condition, after the basic configuration work of generating the service data index is completed, a "preview data" button may be set on the interface, when the service personnel clicks the "preview data" button, the popup window may be triggered to display the query period selection item, the service personnel may fill the start time and the end time of the queried service data in the query period selection item, so as to define the data period of the queried service data, in the preview data link, the service personnel may manually determine whether the service data is the service data of the service to be queried through the final display result, if so, the service personnel may directly trigger to generate the service data index, and finally directly export the service data at the data set writing interface of the service data index for self-use of the service personnel.
As an example, steps a10 to a30 include: aggregating each service association field through data field summation to obtain a service aggregation field; filtering the service aggregation field according to the filtering condition input by the user in the filtering condition configuration interface to obtain the service data field; acquiring service preview data of the service data field input by a user in the query time interval selection item under the corresponding data query time interval, detecting whether the service preview data is the service data of the service to be queried, and if the service preview data is the service data of the service to be queried, generating the service data index.
Wherein, the step of generating the service data index of the service to be queried according to the service data fields aggregated together by the service association fields includes:
step B10, inquiring a corresponding service data interface in an index interface mapping table by taking the service data index as an index;
and step B20, obtaining the service data of the service to be queried by calling the service data interface.
In this embodiment, it should be noted that in the delivering link of the service object, the service data of a certain department is usually not only related to the service data of a contract department, a financial department, a system development department, a quality inspection department, a monitoring department and other departments, but also the data island between different departments is serious, further if the acquired service data relates to multiple departments, the interaction between multiple departments is usually required, which prevents sharing and application of the service data to a certain extent, further in order to enable different service parties to perform query and call of the service data mutually, the query is processed according to own service characteristics after the service data is obtained, at this time, depending on that the service data index can not meet the requirements of the service parties, further the service personnel can provide support for acquiring any service data by developing unified interface services, after writing SQL statements according to related requirements, the developer can automatically generate a service data interface by calling the service data interface, and can acquire a required data interface compared with the development work of the traditional service data interface, the unified data interface can be reduced, the service interface can be used for mapping the service data interface and the service interface is used for representing the service interface.
As an example, steps B10 to B20 include: querying a corresponding service data interface in an index mapping table by taking the service data index as an index; and obtaining the service data of the service to be queried by calling the service data interface.
Wherein when the service preview data of the service data field in the corresponding data query period is detected to be the service data of the service to be queried, the step of generating the service data index includes:
step C10, modifying the business data field according to a field modification instruction input by a user to obtain a modified data field;
step C20, generating modified preview data in the data query period according to the modified data field, and detecting whether the modified preview data is service data of the service to be queried;
step C30, if yes, generating the service data index;
and step C40, if not, taking the modified data field as the service data field, and returning to execute a field modification instruction input by a user to modify the service data field to obtain a modified data field and subsequent steps until the modified preview data is detected to be the service data of the service to be queried.
In this embodiment, it should be noted that, in the process of previewing service preview data, for a service person having a certain code writing capability, by referring to the theme data table and modifying the related code statement logic, a correct SQL query statement is obtained, and finally service data of the service to be queried is obtained, where the field modification instruction is used to modify a data field in the theme data table, specifically, may be triggered when it is detected that a default field stored in the theme data table changes, the modified data field is used to represent a service data field after modification, and the modified preview data is used to represent service preview data generated based on the modified data field.
As an example, steps C10 to C40 include: modifying the business data field into a modified data field according to a field modification instruction input by a user; generating modified preview data in the data query period according to the modified data field, and detecting whether the modified preview data is service data of the service to be queried; if the modified preview data are detected to be the service data of the service to be queried, generating the service data index; and if the modified preview data is detected not to be the service data of the service to be queried, taking the modified data field as the service data field, and returning to execute a field modification instruction input by a user to modify the service data field to obtain a step and a subsequent step of the modified data field until the modified preview data is detected to be the service data of the service to be queried.
Before the step of querying the corresponding service data interface in the index interface mapping table by taking the service data index as an index, the service data query method further comprises the following steps:
step D10, determining an interface data source of an interface to be configured in a preset interface configuration interface, and acquiring interface parameters input by a user in the preset interface configuration interface;
step D20, generating a service data interface according to the interface data source and the interface parameters;
and step D30, establishing an index interface mapping table according to the corresponding relation between the service data interface and the service data index.
In this embodiment, it should be noted that, before querying a service data interface based on an index interface mapping table, an index interface mapping table needs to be established, in the process of establishing the index interface mapping table, a corresponding service data interface needs to be developed and obtained first, for a developer, a theme domain in a preset data warehouse can already include a large number of service requirements, the developer only needs to select a corresponding theme domain according to actual service requirements, and can refer to all data tables, meanwhile, when developing the service data interface, if a provided data source (i.e. a database and the theme domain) fails to meet the service requirements of the developer, a data source can be automatically added in the background, wherein the interface to be configured is used for characterizing the service data interface waiting to be configured, a preset interface configuration interface is used for configuring the service data interface, the interface data source is used for characterizing the source of service data invoked by the service data interface, specifically can be a theme domain, the interface parameters used for characterizing parameters configuring the service data interface, specifically can include an interface calling address and an interface name, and the developer can select the data source and the theme domain according to the service requirements, and when developing the service data interface fails to meet the service requirements of the service requirements, the data source and the obtained service data source and the theme domain can be converted into additional parameters which can be completed through the specific interface configuration interface.
As an example, steps D10 to D30 include: acquiring an interface data source of an interface to be configured, which is selected by a user from a preset interface configuration interface, and acquiring an interface call address and an interface name which are input by the user through the preset interface configuration interface; generating a service data interface according to the interface data source, the interface call address and the interface name; and establishing an index interface mapping table through the corresponding relation between the service data interface and the service data index.
Wherein, after the step of generating a service data interface according to the interface data source and the interface parameter, the service data query method further includes:
step E10, detecting whether the service data called through the service data interface is correct or not according to a standard data test rule triggered by an interface test instruction input by a user;
step E20, if yes, executing the steps of: establishing an index interface mapping table according to the one-to-one correspondence between the service data interfaces and the service data indexes;
and E30, if not, displaying test failure information on the configuration interface popup window of the preset interface.
In this embodiment, it should be noted that after the configuration of the service data interface is completed, a related test program may be set to test whether the service data interface can call service data normally, and after the test results that the service data interface can call service data normally, the service data can be called through a normal interface call address, where the interface test instruction is used to trigger a standard data test rule, the standard data test rule is used to detect whether the service data interface can call service data normally, the standard data test rule may specifically include configuration of three contents including a subsystem, a version and a result format of output data, and the test failure information is used to characterize that the service data interface cannot call service data correctly, and may specifically be "data call failure".
As an example, steps E10 to E30 include: detecting whether the service data called by the service data interface is correct or not according to a standard data test rule triggered by an interface test instruction input by a user; if the service data called by the service data interface is detected to be correct, executing the steps: establishing an index interface mapping table according to the one-to-one correspondence between the service data interfaces and the service data indexes; and if the service data called by the service data interface is detected to be incorrect, displaying test failure information on the configuration interface popup of the preset interface.
The embodiment of the application provides a service data query method, namely, at least one service association field selected by a user under a service theme corresponding to a service to be queried is obtained, wherein the service to be queried is a service waiting for service data query and lacking a standard data index; generating a service data index of the service to be queried according to the service data fields which are jointly aggregated by the service association fields; and inquiring to obtain the service data of the service to be inquired according to the service data index. After the user selects the service association field under the theme corresponding to the service to be queried, the service data index of the service to be queried can be generated through the service association field, and the service data of the service to be queried is finally queried according to the service data index, so that the purpose that the user can automatically query and obtain the service data of the service to be queried only by simply configuring the service association field of the service to be queried can be achieved, namely, a semi-automatic query means is provided for a developer to query the service data. Rather than relying entirely on manually written query codes when querying business data. Therefore, the problem that due to huge data volume of service data, developers need to write language very well when querying the data, and differentiated query is carried out on the service data of different service objects, the situation that the developers write the same code repeatedly is solved easily is solved, and therefore the query efficiency of the service data is improved.
Further, referring to fig. 2, in the second embodiment of the present application, the same or similar contents as those of the first embodiment can be referred to the description above, and the description is omitted. On the basis, before the step of acquiring at least one service association field selected by a user under a service theme corresponding to the service to be queried, the service data query method further comprises the following steps:
step F10, acquiring a service data query instruction input by a user aiming at a standard query service;
step F20, configuring an interface popup window to display a data query time period item in a preset index according to the service data query instruction;
and step F30, inquiring in an index source database according to the data inquiry time period item to obtain service data of the standard inquiry service.
In this embodiment, it should be noted that, the standard query service is used for characterizing a service with a standard service data index, and for the standard query service, the query process of service data does not involve a configuration flow of data indexes, and because relevant service data is already stored in the index source database, service data in the data query period can be obtained after the data query period is selected by the data query period item, where the service data query instruction is used for querying service data, and the index source database is used for storing topic data tables in different topic domains, where the topic data tables carry service data.
As an example, steps F10 to F30 include: acquiring a service data query instruction input by a user aiming at a standard query service; according to the service data query instruction, displaying a data query time period item on a preset index configuration interface popup window; and querying in an index source database by taking the data query time period item as an index to obtain service data of the standard query service.
Before the step of querying the index source database for obtaining the service data of the standard query service according to the data query time period item, the service data query method further comprises the following steps:
step G10, acquiring service data under at least one theme zone through a preset data warehouse;
and G20, processing the service data for any topic domain, and synchronizing the processed service data to an index source database, wherein the index source database stores topic data tables of standard data indexes corresponding to the topic domains.
In this embodiment, it should be noted that, after obtaining the topic data tables of each topic domain, the data tables of the database are configured in the background, and the table structure of each target table is provided, so that different people can understand what the meaning of each target table is, meanwhile, according to the change of the service and the feedback of the service party, the data tables in the topic library are continuously enriched by the data staff, so as to provide the service staff with the data covering the whole service line, when the service staff does not clearly cover the current main whether the current main covers the required data, the data structure of the topic range and each topic data table is checked, so as to determine whether the service data is covered, in order to ensure that the service data of the standard query service can be queried through the index source number database, the relevant service data can be processed in advance, and the detail and the result of each topic can be updated synchronously in real time.
As an example, steps G10 to G20 include: acquiring service data under at least one theme zone through a preset data warehouse; and processing the service data for any topic domain, and synchronizing the processed service data to an index source database, wherein the index source database stores topic data tables of standard data indexes corresponding to the topic domains.
The embodiment of the application provides a service data query method. That is, a service data query instruction input by a user for a standard query service is acquired; according to the service data query instruction, displaying a data query time period item on a preset index configuration interface popup window; and inquiring in an index source database according to the data inquiry time period item to obtain service data of the standard inquiry service. According to the embodiment of the application, the data query time period item is displayed on the preset index configuration interface popup window through the service data query instruction, and then the service data of the standard query service is directly queried in the index source database through the data query time period item, namely, the service data of the service to be queried can be queried when the service with the standard service data index directly passes through the theme data table stored in the index source database, so that the purpose of querying the service data of the service to be queried can be achieved, and the query efficiency of the service data is improved.
The third embodiment of the present application further provides a service data query device, referring to fig. 3, where the service data query device includes:
the acquiring module 101 is configured to acquire at least one service association field selected by a user under a service theme corresponding to a service to be queried, where the service to be queried is a service waiting for service data query and lacking a standard data index;
a generating module 102, configured to generate a service data indicator of the service to be queried according to a service data field that is formed by jointly aggregating the service association fields;
and the query module 103 is configured to query and obtain the service data of the service to be queried according to the service data index.
Optionally, the generating module 102 is further configured to:
according to a preset aggregation mode, aggregating each service association field to obtain a service aggregation field;
filtering the service aggregation field to obtain the service data field;
and generating the service data index when the service preview data of the service data field in the corresponding data query period is detected to be the service data of the service to be queried.
Optionally, the generating module 102 is further configured to:
Querying a corresponding service data interface in an index interface mapping table by taking the service data index as an index;
and obtaining the service data of the service to be queried by calling the service data interface.
Optionally, the generating module 102 is further configured to:
modifying the business data field according to a field modification instruction input by a user to obtain a modified data field;
generating modified preview data in the data query period according to the modified data field, and detecting whether the modified preview data is service data of the service to be queried;
if yes, generating the service data index;
and if not, taking the modified data field as the service data field, and returning to execute a field modification instruction input by a user to modify the service data field to obtain a step and a subsequent step of the modified data field until the modified preview data is detected as the service data of the service to be queried.
Optionally, the service data query device is further configured to:
determining an interface data source of an interface to be configured on a preset interface configuration interface, and acquiring interface parameters input by a user on the preset interface configuration interface;
Generating a service data interface according to the interface data source and the interface parameters;
and establishing an index interface mapping table according to the corresponding relation between the service data interface and the service data index.
Optionally, the service data query device is further configured to:
detecting whether the service data called by the service data interface is correct or not according to a standard data test rule triggered by an interface test instruction input by a user;
if yes, executing the steps of: establishing an index interface mapping table according to the one-to-one correspondence between the service data interfaces and the service data indexes;
if not, displaying test failure information on the configuration interface popup window of the preset interface.
Optionally, the service data query device is further configured to:
acquiring a service data query instruction input by a user aiming at a standard query service;
according to the service data query instruction, displaying a data query time period item on a preset index configuration interface popup window;
and inquiring in an index source database according to the data inquiry time period item to obtain service data of the standard inquiry service.
Optionally, the service data query device is further configured to:
acquiring service data under at least one theme zone through a preset data warehouse;
And processing the service data for any topic domain, and synchronizing the processed service data to an index source database, wherein the index source database stores topic data tables of standard data indexes corresponding to the topic domains.
The service data query device provided by the invention adopts the service data query method in the embodiment, and solves the technical problem of low query efficiency for service data. Compared with the prior art, the service data query device provided by the embodiment of the invention has the same beneficial effects as the service data query method provided by the embodiment, and other technical features in the service data query device are the same as the features disclosed by the method of the embodiment, and are not repeated herein.
A fourth embodiment of the present invention provides an electronic device, including: at least one processor; and a memory communicatively coupled to the at least one processor; the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the service data query method of the above embodiment.
Referring now to fig. 4, a schematic diagram of an electronic device suitable for use in implementing embodiments of the present disclosure is shown. The electronic devices in the embodiments of the present disclosure may include, but are not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and the like, and stationary terminals such as digital TVs, desktop computers, and the like. The electronic device shown in fig. 4 is merely an example and should not be construed to limit the functionality and scope of use of the disclosed embodiments.
As shown in fig. 4, the electronic device may include a processing apparatus 1001 (e.g., a central processing unit, a graphics processor, etc.), which may perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 1002 or a program loaded from a storage apparatus 1003 into a Random Access Memory (RAM) 1004. In the RAM1004, various programs and data required for the operation of the electronic device are also stored. The processing device 1001, the ROM1002, and the RAM1004 are connected to each other by a bus 1005. An input/output (I/O) interface 1006 is also connected to the bus.
In general, the following systems may be connected to the I/O interface 1006: input devices 1007 including, for example, a touch screen, touchpad, keyboard, mouse, image sensor, microphone, accelerometer, gyroscope, and the like; an output device 1008 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage device 1003 including, for example, a magnetic tape, a hard disk, and the like; and communication means 1009. The communication means may allow the electronic device to communicate with other devices wirelessly or by wire to exchange data. While electronic devices having various systems are shown in the figures, it should be understood that not all of the illustrated systems are required to be implemented or provided. More or fewer systems may alternatively be implemented or provided.
In particular, according to embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flowcharts. In such an embodiment, the computer program may be downloaded and installed from a network via the communication device 1009, or installed from the storage device 1003, or installed from the ROM 1002. The above-described functions defined in the method of the embodiment of the present disclosure are performed when the computer program is executed by the processing device 1001.
The electronic equipment provided by the invention adopts the service data query method in the embodiment, and solves the technical problem of low query efficiency for service data. Compared with the prior art, the electronic device provided by the embodiment of the invention has the same beneficial effects as the service data query method provided by the embodiment, and other technical features in the electronic device are the same as the features disclosed by the method of the embodiment, and are not repeated here.
It should be understood that portions of the present disclosure may be implemented in hardware, software, firmware, or a combination thereof. In the description of the above embodiments, particular features, structures, materials, or characteristics may be combined in any suitable manner in any one or more embodiments or examples.
The foregoing is merely illustrative of the present invention, and the present invention is not limited thereto, and any person skilled in the art will readily recognize that variations or substitutions are within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
The fifth embodiment provides a computer-readable storage medium having computer-readable program instructions stored thereon for executing the service data query method in the above embodiment.
The computer readable storage medium according to the embodiments of the present invention may be, for example, a usb disk, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In this embodiment, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, or device. Program code embodied on a computer readable storage medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.
The above-described computer-readable storage medium may be contained in an electronic device; or may exist alone without being assembled into an electronic device.
The computer-readable storage medium carries one or more programs that, when executed by an electronic device, cause the electronic device to: acquiring at least one service association field selected by a user under a service theme corresponding to a service to be queried, wherein the service to be queried is a service waiting for service data query and lacking standard data indexes; generating a service data index of the service to be queried according to the service data fields which are jointly aggregated by the service association fields; and inquiring to obtain the service data of the service to be inquired according to the service data index.
Computer program code for carrying out operations of the present disclosure may be written in one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules described in the embodiments of the present disclosure may be implemented in software or hardware. Wherein the name of the module does not constitute a limitation of the unit itself in some cases.
The computer readable storage medium provided by the invention stores the computer readable program instructions for executing the service data query method, and solves the technical problem of low query efficiency for service data. Compared with the prior art, the beneficial effects of the computer readable storage medium provided by the embodiment of the invention are the same as those of the service data query method provided by the above embodiment, and are not described in detail herein.
A sixth embodiment of the present application further provides a computer program product, including a computer program, where the computer program when executed by a processor implements the steps of the service data query method as described above.
The computer program product provided by the application solves the technical problem of low query efficiency for service data. Compared with the prior art, the beneficial effects of the computer program product provided by the embodiment of the invention are the same as those of the service data query method provided by the embodiment, and are not described in detail herein.
The foregoing description is only of the preferred embodiments of the present application and is not intended to limit the scope of the claims, and all equivalent structures or equivalent processes using the descriptions and drawings of the present application, or direct or indirect application in other related technical fields are included in the scope of the claims.
Claims (10)
1. The service data query method is characterized by comprising the following steps:
acquiring at least one service association field selected by a user under a service theme corresponding to a service to be queried, wherein the service to be queried is a service waiting for service data query and lacking standard data indexes;
generating a service data index of the service to be queried according to the service data fields which are jointly aggregated by the service association fields;
and inquiring to obtain the service data of the service to be inquired according to the service data index.
2. The service data query method as claimed in claim 1, wherein said step of generating a service data index of said service to be queried from service data fields collectively aggregated from each of said service association fields comprises:
according to a preset aggregation mode, aggregating each service association field to obtain a service aggregation field;
filtering the service aggregation field to obtain the service data field;
and generating the service data index when the service preview data of the service data field in the corresponding data query period is detected to be the service data of the service to be queried.
3. The service data query method as claimed in claim 2, wherein said step of querying the service data of the service to be queried according to the service data index comprises:
querying a corresponding service data interface in an index interface mapping table by taking the service data index as an index;
and obtaining the service data of the service to be queried by calling the service data interface.
4. The service data query method as claimed in claim 2, wherein the step of generating the service data index when it is detected that the service preview data of the service data field in the corresponding data query period is the service data of the service to be queried comprises:
modifying the business data field according to a field modification instruction input by a user to obtain a modified data field;
generating modified preview data in the data query period according to the modified data field, and detecting whether the modified preview data is service data of the service to be queried;
if yes, generating the service data index;
and if not, taking the modified data field as the service data field, and returning to execute a field modification instruction input by a user to modify the service data field to obtain a step and a subsequent step of the modified data field until the modified preview data is detected as the service data of the service to be queried.
5. The service data query method as claimed in claim 3, wherein before said step of querying a corresponding service data interface in an index interface mapping table with said service data index as an index, said service data query method further comprises:
determining an interface data source of an interface to be configured on a preset interface configuration interface, and acquiring interface parameters input by a user on the preset interface configuration interface;
generating a service data interface according to the interface data source and the interface parameters;
and establishing an index interface mapping table according to the corresponding relation between the service data interface and the service data index.
6. The traffic data query method according to claim 5, wherein after said step of generating a traffic data interface based on said interface data source and said interface parameters, said traffic data query method further comprises:
detecting whether the service data called by the service data interface is correct or not according to a standard data test rule triggered by an interface test instruction input by a user;
if yes, executing the steps of: establishing an index interface mapping table according to the one-to-one correspondence between the service data interfaces and the service data indexes;
If not, displaying test failure information on the configuration interface popup window of the preset interface.
7. The service data query method according to claim 1, wherein, before the step of obtaining at least one service association field selected by the user under a service topic corresponding to a service to be queried, the service data query method further comprises:
acquiring a service data query instruction input by a user aiming at a standard query service;
according to the service data query instruction, displaying a data query time period item on a preset index configuration interface popup window;
and inquiring in an index source database according to the data inquiry time period item to obtain service data of the standard inquiry service.
8. The service data query method according to claim 7, wherein before the step of querying an index source database for service data of the standard query service according to the data query period term, the service data query method further comprises:
acquiring service data under at least one theme zone through a preset data warehouse;
and processing the service data for any topic domain, and synchronizing the processed service data to an index source database, wherein the index source database stores topic data tables of standard data indexes corresponding to the topic domains.
9. An electronic device, the electronic device comprising:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein, the liquid crystal display device comprises a liquid crystal display device,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the steps of the business data query method of any one of claims 1 to 8.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored thereon a program for realizing a service data query method, the program for realizing the service data query method being executed by a processor to realize the steps of the service data query method according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310821466.7A CN116561132B (en) | 2023-07-06 | 2023-07-06 | Service data query method, electronic device and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310821466.7A CN116561132B (en) | 2023-07-06 | 2023-07-06 | Service data query method, electronic device and readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116561132A true CN116561132A (en) | 2023-08-08 |
| CN116561132B CN116561132B (en) | 2023-12-22 |
Family
ID=87496799
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310821466.7A Active CN116561132B (en) | 2023-07-06 | 2023-07-06 | Service data query method, electronic device and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116561132B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014177118A1 (en) * | 2013-04-28 | 2014-11-06 | 浙江核新同花顺网络信息股份有限公司 | Query selection method and system |
| US20190095482A1 (en) * | 2017-09-28 | 2019-03-28 | Oracle International Corporation | Recommending fields for a query based on prior queries |
| CN112506946A (en) * | 2020-12-03 | 2021-03-16 | 平安科技（深圳）有限公司 | Service data query method, device, equipment and storage medium |
| CN112966004A (en) * | 2021-03-04 | 2021-06-15 | 北京百度网讯科技有限公司 | Data query method and device, electronic equipment and computer readable medium |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN113468208A (en) * | 2021-07-19 | 2021-10-01 | 网易（杭州）网络有限公司 | Method and device for generating data query statement, server and storage medium |
| CN113722289A (en) * | 2021-08-09 | 2021-11-30 | 杭萧钢构股份有限公司 | Method, device, electronic equipment and medium for constructing data service |
| CN114385721A (en) * | 2022-01-14 | 2022-04-22 | 阳光财产保险股份有限公司 | Data visualization query method and device, electronic equipment and storage medium |
| CN115794833A (en) * | 2022-12-19 | 2023-03-14 | 深圳前海微众银行股份有限公司 | Data processing method, server and computer storage medium |
| WO2023056934A1 (en) * | 2021-10-09 | 2023-04-13 | 北京字跳网络技术有限公司 | Data processing method and apparatus, and electronic device |
| CN116010439A (en) * | 2022-12-23 | 2023-04-25 | 南京中孚信息技术有限公司 | Visual Chinese SQL system and query construction method |
-
2023
- 2023-07-06 CN CN202310821466.7A patent/CN116561132B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014177118A1 (en) * | 2013-04-28 | 2014-11-06 | 浙江核新同花顺网络信息股份有限公司 | Query selection method and system |
| US20190095482A1 (en) * | 2017-09-28 | 2019-03-28 | Oracle International Corporation | Recommending fields for a query based on prior queries |
| CN112506946A (en) * | 2020-12-03 | 2021-03-16 | 平安科技（深圳）有限公司 | Service data query method, device, equipment and storage medium |
| CN112966004A (en) * | 2021-03-04 | 2021-06-15 | 北京百度网讯科技有限公司 | Data query method and device, electronic equipment and computer readable medium |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN113468208A (en) * | 2021-07-19 | 2021-10-01 | 网易（杭州）网络有限公司 | Method and device for generating data query statement, server and storage medium |
| CN113722289A (en) * | 2021-08-09 | 2021-11-30 | 杭萧钢构股份有限公司 | Method, device, electronic equipment and medium for constructing data service |
| WO2023056934A1 (en) * | 2021-10-09 | 2023-04-13 | 北京字跳网络技术有限公司 | Data processing method and apparatus, and electronic device |
| CN114385721A (en) * | 2022-01-14 | 2022-04-22 | 阳光财产保险股份有限公司 | Data visualization query method and device, electronic equipment and storage medium |
| CN115794833A (en) * | 2022-12-19 | 2023-03-14 | 深圳前海微众银行股份有限公司 | Data processing method, server and computer storage medium |
| CN116010439A (en) * | 2022-12-23 | 2023-04-25 | 南京中孚信息技术有限公司 | Visual Chinese SQL system and query construction method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116561132B (en) | 2023-12-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20160299933A1 (en) | Process metadata triggers and events | |
| US8799796B2 (en) | System and method for generating graphical dashboards with drill down navigation | |
| US9098821B2 (en) | Analytic solution integration | |
| US9176727B2 (en) | Infrastructure software patch reporting and analytics | |
| WO2020143557A1 (en) | Method and device for displaying information | |
| US20150370674A1 (en) | Tenant provisioning for testing a production multi-tenant service | |
| US9389934B1 (en) | Centralized and distributed notification handling system for software applications | |
| US20220067186A1 (en) | Privilege graph-based representation of data access authorizations | |
| US20200082307A1 (en) | Real-time matching of users to enterprise interfaces and artifacts | |
| US20210011839A1 (en) | Automation of Enterprise Software Inventory and Testing | |
| CN110334109A (en) | Relational database data query method, system, medium and electronic equipment | |
| US20130254736A1 (en) | Generating a semantic graph that allows a user to intelligently and efficiently connect with people and assets involved in projects | |
| US11334830B2 (en) | System and method for crisis and business resiliency management | |
| CN114357041A (en) | Industrial data asset publishing method and device | |
| CN113704288A (en) | Data display method and device, computer readable medium and electronic equipment | |
| CN116561132B (en) | Service data query method, electronic device and readable storage medium | |
| US20170046717A1 (en) | Database systems and user interfaces for dynamic interaction with, and comparison of, customer data | |
| CN116342342A (en) | Student behavior detection method, electronic device and readable storage medium | |
| US9524239B2 (en) | Self service propagation of custom extension fields into web services | |
| US20170277738A1 (en) | Temporal representation of structured information in an object model | |
| CN115994100B (en) | System activity detection method and device, electronic equipment and readable storage medium | |
| CN116436919B (en) | Cloud resource consumption optimization method and device, electronic equipment and readable storage medium | |
| CN115145992B (en) | Multi-source data processing method and device, electronic equipment and readable storage medium | |
| CN111143408B (en) | Event processing method and device based on business rule | |
| CN110275862B (en) | Method and device for counting number of created documents |
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 |