CN112632037B - Method and device for graphically defining query data set - Google Patents

Method and device for graphically defining query data set Download PDF

Info

Publication number
CN112632037B
CN112632037B CN202011555899.5A CN202011555899A CN112632037B CN 112632037 B CN112632037 B CN 112632037B CN 202011555899 A CN202011555899 A CN 202011555899A CN 112632037 B CN112632037 B CN 112632037B
Authority
CN
China
Prior art keywords
data
data models
query
models
configuration
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
Application number
CN202011555899.5A
Other languages
Chinese (zh)
Other versions
CN112632037A (en
Inventor
杜聪
李玉成
李文峰
孙立新
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur General Software Co Ltd
Original Assignee
Inspur General Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Inspur General Software Co Ltd filed Critical Inspur General Software Co Ltd
Priority to CN202011555899.5A priority Critical patent/CN112632037B/en
Publication of CN112632037A publication Critical patent/CN112632037A/en
Application granted granted Critical
Publication of CN112632037B publication Critical patent/CN112632037B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/211Schema design and management
    • G06F16/212Schema design and management with details for data modelling support
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2428Query predicate definition using graphical user interfaces, including menus and forms
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution

Landscapes

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

Abstract

The embodiment of the specification discloses a method and a device for graphically defining a query data set. The method comprises the following steps: analyzing the plurality of data models through a data model analyzer to obtain related information, and packaging the plurality of data models; importing the packaged data models into a graphical designer, transmitting the relevant information into a dynamic interface, connecting the data models needing to be associated by using a connecting line, and setting the association relation of the data models through the connecting line; and configuring the related information and user requirements through a configurator of the dynamic interface to obtain configuration information, and linking the configuration information through a linkage device according to the association relation.

Description

Method and device for graphically defining query data set
Technical Field
The invention relates to the field of user graphical interface modeling, in particular to a method and a device for graphically defining a query data set.
Background
In the existing method for defining the data set, a wizard mode is often adopted to configure the data model. Selecting a data model, sequentially configuring sets such as screening fields, displaying fields and the like according to steps, and finally modeling, finishing and displaying on an interface. The wizard mode is visual and convenient under a single data model, but with the improvement of business complexity, multiple data models and even different types of data models are needed for modeling, the wizard mode is difficult to maintain the association relationship among the multiple data models, and the user experience is poor when the data models are modified. In the existing mode, various data models cannot be provided for modeling, and the expansion capability is insufficient.
Based on this, a method for providing multiple data models, modeling multiple data models and even multiple data models, and maintaining the association relationship between multiple data models is needed to improve the user experience.
Disclosure of Invention
One or more embodiments of the present specification provide a method and apparatus for graphically defining a query data set. To solve the following problems: in the existing mode, a plurality of data models or a plurality of data models cannot be modeled, and the incidence relation among the plurality of data models cannot be maintained.
To solve the above technical problem, one or more embodiments of the present specification are implemented as follows:
one or more embodiments of the present specification provide a method for graphically defining a query data set, comprising:
analyzing the plurality of data models through a data model analyzer to obtain related information, and packaging the plurality of data models;
importing the packaged data models into a graphical designer, transmitting the relevant information into a dynamic interface, connecting the data models needing to be associated by using a connecting line, and setting the association relation of the data models through the connecting line;
and configuring the related information and user requirements through a configurator of the dynamic interface to obtain configuration information, and linking the configuration information through a linkage device according to the association relation.
Providing a data model analyzer, a graphical designer, a dynamic interface, a configurator and a linkage, and graphically defining and inquiring a data set through the mutual matching of the data model analyzer, the graphical designer, the dynamic interface, the configurator and the linkage. The analyzer analyzes the data model, the safety of internal logic of the data model is guaranteed, and the graphical designer simply graphs the data model and maintains the relationship among multiple data models.
Optionally, the plurality of data models includes a basic data model and a custom query interface and custom query statements provided by the tool kit.
And an extensible tool is provided, and the user can customize the tool according to different requirements of the user.
Optionally, the analyzing the plurality of data models by the data model analyzer to obtain related information, and encapsulating the plurality of data models specifically includes:
analyzing the plurality of data models through the data model analyzer to obtain the basic information, the query parameters and the query result set of the plurality of data models, and packaging the plurality of data models into a plurality of class objects.
Optionally, the connecting line is used to connect the multiple data models that need to be associated, and the association relationship of the multiple data models is set through the connecting line, which specifically includes:
and connecting the plurality of data models needing to be associated by using a connecting line, and setting and recording the association relation of the plurality of data models.
Optionally, if there is no association relationship between the multiple data models, setting the multiple data models to be in a parallel relationship, and processing the multiple data models set to be in the parallel relationship by using Union All.
Optionally, the configuring, by the configurator of the dynamic interface, the configuration information according to the related information and the user requirement is obtained, and the configuring specifically includes:
loading fields in the plurality of data models through the dynamic interface according to the user requirements and the related information transmitted to the dynamic interface, providing a display field configuration interface, a screening field configuration interface, a filtering condition, a data authority configuration interface configuration display field, a screening field, a filtering condition and an access authority, and storing the configuration information.
Optionally, the linking the configuration information through a linkage according to the association relationship specifically includes:
the linkage device records the basic information of the data models and the configuration information of the dynamic interface.
Optionally, if the basic information of the plurality of data models is modified, the linkage device modifies the configuration information correspondingly.
At least one technical scheme adopted by one or more embodiments of the specification can achieve the following beneficial effects: modeling is carried out on a plurality of data models or a plurality of data models, and the association relation among the plurality of data models is maintained. The system has an extensible tool, information can be configured according to user requirements, and the use experience of a user is improved.
One or more embodiments of the present specification provide an apparatus for graphically defining a query data set, comprising:
the data model analyzer is used for analyzing a plurality of data models, obtaining relevant information of the data models and packaging the data models;
the graphical designer imports the data models and maintains the incidence relation of the data models;
and the dynamic interface provides a configurator and a linkage device, and links the configuration information according to the related information and the user requirement configuration information.
A tool kit providing extensible tools for data modeling.
Optionally, the dynamic interface further includes a display field configuration interface, a filter condition, and a data permission configuration interface;
the display field configuration interface is used for configuring a display field;
the screening field configuration interface is used for configuring screening fields;
the filtering condition configures and filters according to the screening field;
and the data authority configuration interface is used for configuring the access authority according to different user authorities.
At least one technical scheme adopted by one or more embodiments of the specification can achieve the following beneficial effects: a plurality of data models or a plurality of data models are modeled through the mutual cooperation of a data model analyzer, a graphical designer, a dynamic interface, a configurator, a linkage device, a tool box and the like, and the incidence relation among the plurality of data models is maintained. The system has an extensible tool, information can be configured according to user requirements, and the use experience of a user is improved.
Drawings
In order to more clearly illustrate the embodiments of the present specification or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only some embodiments described in the present specification, and for those skilled in the art, other drawings can be obtained according to the drawings without any creative effort.
FIG. 1 is a flow diagram illustrating a method for graphically defining a query data set according to one or more embodiments of the present disclosure;
fig. 2 is a diagram illustrating an example of contents of a graphically defined data set according to one or more embodiments of the present disclosure.
Detailed Description
The embodiment of the specification provides a method and a device for graphically defining a query data set.
In order to make those skilled in the art better understand the technical solutions in the present specification, the technical solutions in the embodiments of the present specification will be clearly and completely described below with reference to the drawings in the embodiments of the present specification, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without making any inventive step based on the embodiments of the present disclosure, shall fall within the scope of protection of the present disclosure.
One or more embodiments of the present disclosure provide a method for graphically defining an inquiry data set, where a data model parser parses a data model, a graphical designer maintains an association relationship between multiple data models, configurator configuration information of a dynamic interface, linkage configuration information, and graphically defines an inquiry data set.
The technical solutions provided by the embodiments of the present description are described in detail below with reference to the accompanying drawings.
Fig. 1 is a flowchart illustrating a method for graphically defining a query data set according to one or more embodiments of the present disclosure.
S101: analyzing the plurality of data models through a data model analyzer to obtain related information, and packaging the plurality of data models;
the plurality of data models comprise a basic data model and a custom query interface and a custom query statement provided by a tool box.
And analyzing the plurality of data models through a data model analyzer to obtain the basic information, the query parameters and the query result set of the plurality of data models, and packaging the plurality of data models into a plurality of class objects.
And analyzing the plurality of data models through the data model analyzer, wherein the plurality of data models can be a plurality of data models of the same type or a plurality of data models of different types. The data model analyzer analyzes the plurality of data models, the data model analyzer does not sense the internal implementation logic of the plurality of data models during analysis, the internal logic of the plurality of data models is a closed and safe black box for the data model analyzer, and the data model analyzer only obtains the correlation information of the plurality of data models. The data model parser can parse a data model, and after the data model parser completes parsing of the data model to obtain relevant information, a uniform class object is instantiated to encapsulate the data model. Instantiation refers to the process of creating an object with a class in object-oriented programming and is called instantiation.
In one or more embodiments of the present specification, a plurality of data models of the same type are analyzed by a data model analyzer, for example, a plurality of query models are analyzed by the data model analyzer, the data model analyzer analyzes the plurality of query models, and according to characteristics of the query models, the data model analyzer needs to obtain basic information of the plurality of query models, query the query reference and the query result set, and does not sense internal implementation logic of the plurality of query models, thereby ensuring that the internal logic of the plurality of query models is a closed and safe black box. And after the plurality of query models are analyzed, packaging each query model. And ensuring the safety of the internal logic of the plurality of query models.
In one or more embodiments of the present specification, a data model parser parses a plurality of different types of data models, for example, the plurality of different types of data models include a query model and an entity model, and the data model parser parses the query model and the entity model, obtains relevant information according to characteristics of the query model and the entity model, does not sense internal implementation logic of the query model and the entity model, and ensures that the internal logic of the query model and the entity model is a closed and safe black box. And after the query model and the entity model are analyzed, packaging the query model and the entity model. And ensuring the safety of the internal logic of the query model and the entity model.
In one or more embodiments of the present description, the data model parser is provided by the back-end logic of the graphical designer, and the data model parser can parse a variety of data models, including custom Query interfaces and custom Query statements provided by the basic data model and the tool kit, such as a custom Query Application Programming Interface (API), a custom Structured Query Language (SQL), or a custom Business Query Language (BQL). The tool box provides extensible tools for use, the tool box provides basic elements and high-level elements, the basic elements comprise entity objects, database tables, query objects, database views, query APIs (application programming interfaces) and data set objects, and the high-level elements comprise SQL statements, BQL statements, union joint queries, subqueries and the like. The sub-query is an intermediate result query by using one SQL query statement as an intermediate result for another query statement, and the union joint query is a whole by combining a plurality of query statements. A user can create a data model through an extension tool provided by a tool box, the tool box can also use a data model resolver, and the data model resolver can be packaged into class objects as long as a query participation query result set is exposed when the tool is prefabricated.
S102: importing the packaged data models into a graphical designer, transmitting the relevant information into a dynamic interface, connecting the data models needing to be associated by using a connecting line, and setting the association relation of the data models through the connecting line;
and connecting a plurality of data models needing to be associated by using a connecting line, and setting and recording the association relation of the plurality of data models.
And if the plurality of data models have no association relationship, setting the plurality of data models to be in a parallel relationship, and processing the plurality of data models which are set to be in the parallel relationship by using Union All.
The graphical designer is the core of graphical modeling, and has the functions of combination, incidence relation and basic attribute configuration of the data model, and the back-end logic of the graphical designer provides a data model parser. When the packaged data models are imported into the graphical designer, the graphical designer simplifies the data models into graphical elements so as to facilitate the use of users.
Connecting a plurality of data models needing to be associated in the graphical designer by using connecting lines, setting and maintaining the association relation of the plurality of data models through the connecting lines and recording the association relation of the plurality of data models.
In one or more embodiments of the present specification, the basic information of the data model is stored in two tables of the graphical designer, where the two tables are created in advance by customization, and may be stored in a GspQdpDataObject and a gspqdpdataobjectrelationship table, for example. When two or more encapsulated data models exist in the graphical designer and need to be associated, the data models needing to be associated are connected by using a connecting line, an association relation is created, a table for storing the data models and the association relation is updated, for example, a GspQdpDataObjectRelation table is updated, the table name can be customized, and the data models and the association relation are recorded in the GspQdpDataObjectRelation table.
In one or more embodiments of the present disclosure, when two or more encapsulated data models exist in the graphical designer, if there is no association between the data models in the graphical designer, the data models do not need to be connected by a connection line, the graphical designer sets the association between the data models as a parallel relationship, or the graphical designer defaults the data models as a parallel relationship, and the data models defaulted as a parallel relationship by the graphical designer are processed by Union All. Where the Union All command lists All values, e.g., where two SQL statements are processed by Union All, the result of the processing lists All values regardless of whether the values listed by the two SQL statements are duplicates. For example, ALL data of data model one and data model 2 are listed, data model one includes A, B, data model two includes A, C, and after Union ALL processing, the listed value is A, B, A, C, and similarly, when a plurality of data models are in a parallel relationship, ALL data in the plurality of data models are listed after Union ALL processing.
S103: and configuring the related information and user requirements through a configurator of the dynamic interface to obtain configuration information, and linking the configuration information through a linkage device according to the association relation.
Loading fields in a plurality of data models through the dynamic interface according to user requirements and related information transmitted into the dynamic interface, providing a display field configuration interface, a screening field configuration interface, a filtering condition, a data authority configuration interface configuration display field, a screening field, a filtering condition and an access authority, and storing the configuration information.
The dynamic interface provides a configurator and a linkage, and the dynamic interface can obtain the relevant information of the data model which is analyzed by the data model and is imported into the graphical designer.
In one or more embodiments of the present description, the dynamic interface provides a configurator, and configures a display field, a filter condition, and a data permission configuration interface according to requirements of a user through the display field configuration interface, the filter condition, and the data permission configuration interface, so as to store configuration information. When the user dynamic interface configures information, some of the display fields, the screening fields, the filtering conditions, the access rights and the like can be configured, and the display fields, the screening fields, the filtering conditions and the access rights are not required to be configured. The configuration information is stored in a configuration table, and the configuration table can be customized as GspQdpParamsmapping.
In one or more embodiments of the present description, when the data model is a query model, the query with the screening field and the display field as query models is entered into a participating query result set, and different data models are unified according to user configuration. The filtering conditions configure the filtering conditions during query, namely the mapping relation between the filtering fields and the data model fields, and finally the filtering conditions are spliced into the query conditions to participate in query execution. The data access authority is configured on the data authority configuration interface, the security authority of the current user is taken out during the configuration, and the data access authority item during the query execution is modified according to the security authority, so that the query result meets the industry standard.
In one or more embodiments of the present description, when the data model is a query model, the field information in the query result set is configured while the field configuration interface configuration information is displayed. And configuring interface configuration information in the screening field, and configuring field information of the query participation. And when the condition configuration information is filtered, adding a condition into the screening condition, and participating the spliced query condition in query execution. When the configuration information of the data authority configuration interface is acquired, the security authority of the current operation user is acquired, the data access authority is different in security authority, if the security authority is A, the data access authority is only capable of accessing partial data, the security authority is B, the data access authority is capable of accessing all data, and the data access authority during query execution is modified according to the security authority. If the user A has a secret level authority of A, the data access authority is only capable of accessing partial data, the user B has a secret level authority of B, the data access authority is capable of accessing all data, under the same query condition, the query results of the user A and the user B are different, and the query result of the user B is more comprehensive than the query result of the user A.
And the linkage device records the basic information of a plurality of data models and the configuration information of the dynamic interface.
And if the basic information of the plurality of data models is modified, the linkage device correspondingly modifies the configuration information.
With the requirements of users becoming more complex and diversified, the mapping into the designer also increases the complexity of data modeling, and the requirements on the imaging designer are higher. The high complexity also reflects that more operations of adding, deleting and modifying may exist in the data modeling of the user, and if no processing mechanism is used for processing the operations, the use efficiency of the user is greatly reduced. In the specification, the dynamic interface provides a linkage device, so that a user can automatically link configuration information when performing addition and deletion modification operation, and the configuration effectiveness is ensured.
In one or more embodiments of the present specification, the linkage device compactly records data model information and configuration information of a corresponding dynamic interface, and when a user performs an add/delete operation, the linkage device scans linked information and performs corresponding processing.
In one or more embodiments of the present specification, the linkage device records the ID of the data model and the configuration information of the corresponding dynamic interface in a simplified manner. If the user deletes a certain data model, the linkage device scans the recorded data model information and the configuration information of the corresponding dynamic interface by using the ID of the deleted data model, and deletes the configuration information related to the ID of the deleted data model.
In one or more embodiments of the present specification, the linkage prunes the ID of the data model and the configuration information of the corresponding dynamic interface. If the user modifies a certain data model, the linkage device uses the ID of the modified data model to scan the recorded data model information and the configuration information of the corresponding dynamic interface, and modifies the configuration information related to the ID of the modified data model.
Fig. 2 is a diagram illustrating an example of contents of a graphically defined data set according to one or more embodiments of the present disclosure.
In one or more embodiments of the present description, the graphical designer back-end logic is embedded and uses a data model parser, the tool box also uses a data model parser, and the class objects can be encapsulated by exposing the query to the participating query result set during tool prefabrication. The linkage device records data model information transmitted by the graphical designer and configuration information of a corresponding dynamic interface in linkage mode, and displays fields, screening fields, filtering conditions and data permissions.
One or more embodiments of the present specification provide a method for graphically defining a query data set, which facilitates a user to use multiple data models for modeling, configure relationships between the data models, simplify and activate operations of adding and deleting data models for the user, and provide an extensible tool.
One or more embodiments of the present specification provide an apparatus for graphically defining a query data set, the apparatus comprising:
the data model analyzer is used for analyzing a plurality of data models, obtaining relevant information of the data models and packaging the data models;
the graphical designer imports the data models and maintains the incidence relation of the data models;
and the dynamic interface provides a configurator and a linkage device, and links the configuration information according to the related information and the user requirement configuration information.
A tool kit providing extensible tools for data modeling.
The dynamic interface also comprises a display field configuration interface, a screening field configuration interface, a filtering condition and a data authority configuration interface;
optionally, the display field configuration interface is used for configuring the display field;
optionally, the screening field configuration interface is used for configuring the screening field;
optionally, the filtering condition configures filtering according to the filtering field;
optionally, the permission configuration interface is used for configuring the access permission according to different user permissions.
The foregoing description has been directed to specific embodiments of this disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may also be possible or may be advantageous.
The above description is merely one or more embodiments of the present disclosure and is not intended to limit the present disclosure. Various modifications and alterations to one or more embodiments of the present description will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement or the like made within the spirit and principle of one or more embodiments of the present specification should be included in the scope of the claims of the present specification.

Claims (8)

1. A method of graphically defining a query data set, comprising:
analyzing the plurality of data models through a data model analyzer to obtain related information, and encapsulating the plurality of data models, wherein the method specifically comprises the following steps:
analyzing the plurality of data models through the data model analyzer, wherein the data model analyzer does not sense the implementation logic inside the plurality of data models during analysis; the internal logic of the plurality of data models is a closed and secure black box to the data model parser; the data model parser obtains only the correlation information of the plurality of data models; acquiring basic information, query parameters and a query result set of the plurality of data models, and packaging the plurality of data models into a plurality of class objects;
importing the packaged data models into a graphical designer, transmitting the relevant information into a dynamic interface, connecting the data models needing to be associated by using a connecting line, and setting the association relation of the data models through the connecting line;
configuring the configurator of the dynamic interface according to the related information and user requirements to obtain configuration information, and linking the configuration information through a linkage according to the association relationship, wherein the method specifically comprises the following steps:
loading fields in the plurality of data models through the dynamic interface according to the user requirements and the related information transmitted to the dynamic interface, and providing a display field configuration interface, a screening field configuration interface, a filtering condition and a data authority configuration interface for a user to configure the display fields, the screening fields, the filtering condition, the access authority and store the configuration information according to the user requirements;
when the data model is a query model, the screening field and the display field are a query participation query result set of the query model; unifying different data models according to user configuration; the screening conditions when the filtering condition configuration query is the mapping relation between the screening fields and the data model fields, and the screening conditions are spliced into the query conditions to participate in the query execution; the data access authority is configured on the data authority configuration interface, the security authority of the current user is taken out during the configuration, and the data access authority item during the query execution is modified according to the security authority, so that the query result meets the industry standard.
2. The method of claim 1, wherein the plurality of data models comprises custom query statements and custom query interfaces provided by a base data model and a toolkit.
3. The method according to claim 1, wherein the connecting the plurality of data models to be associated with each other with a connecting line, and the setting of the association relationship between the plurality of data models with the connecting line specifically includes:
and connecting the plurality of data models needing to be associated by using a connecting line, and setting and recording the association relation of the plurality of data models.
4. The method of claim 3, further comprising:
and if the plurality of data models have no association relationship, setting the plurality of data models to be in a parallel relationship, and processing the plurality of data models which are set to be in the parallel relationship by using Union All.
5. The method according to claim 1, wherein the linking the configuration information by a linkage according to the association relationship specifically includes:
the linkage device records the basic information of the data models and the configuration information of the dynamic interface.
6. The method of claim 5, further comprising:
and if the basic information of the plurality of data models is modified, the linkage device correspondingly modifies the configuration information.
7. An apparatus for graphically defining a query data set, performing a method of graphically defining a query data set as claimed in claim 1, comprising:
the data model analyzer is used for analyzing a plurality of data models, obtaining relevant information of the data models and packaging the data models;
the graphical designer imports the data models and maintains the incidence relation of the data models;
the dynamic interface provides a configurator and a linkage device, and links the configuration information according to the related information and the user requirement configuration information;
a tool kit providing extensible tools for data modeling.
8. The apparatus of claim 7, wherein the dynamic interface further comprises a display field configuration interface, a filter condition, a data permission configuration interface;
the display field configuration interface is used for configuring a display field;
the screening field configuration interface is used for configuring screening fields;
the filtering condition configures and filters according to the screening field;
and the data authority configuration interface is used for configuring the access authority according to different user authorities.
CN202011555899.5A 2020-12-24 2020-12-24 Method and device for graphically defining query data set Active CN112632037B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011555899.5A CN112632037B (en) 2020-12-24 2020-12-24 Method and device for graphically defining query data set

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011555899.5A CN112632037B (en) 2020-12-24 2020-12-24 Method and device for graphically defining query data set

Publications (2)

Publication Number Publication Date
CN112632037A CN112632037A (en) 2021-04-09
CN112632037B true CN112632037B (en) 2023-04-07

Family

ID=75324604

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011555899.5A Active CN112632037B (en) 2020-12-24 2020-12-24 Method and device for graphically defining query data set

Country Status (1)

Country Link
CN (1) CN112632037B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114860737B (en) * 2022-06-28 2022-09-20 北京世纪好未来教育科技有限公司 Processing method, device, equipment and medium of teaching and research data

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105160023A (en) * 2015-09-30 2015-12-16 深圳市巧捷万端云计算有限公司 Graphical data query processing method based on cloud server
CN105243162A (en) * 2015-10-30 2016-01-13 方正国际软件有限公司 Relational database storage-based objective data model query method and device
US9740713B1 (en) * 2014-07-31 2017-08-22 Quickbase, Inc. Dynamic modeling of data in relational databases
CN107515887A (en) * 2017-06-29 2017-12-26 中国科学院计算机网络信息中心 A kind of interactive query method suitable for a variety of big data management systems
CN109213754A (en) * 2018-03-29 2019-01-15 北京九章云极科技有限公司 A kind of data processing system and data processing method
CN111274269A (en) * 2020-01-17 2020-06-12 广州至真信息科技有限公司 Data processing method and device
CN111427971A (en) * 2020-03-25 2020-07-17 中国工商银行股份有限公司 Business modeling method, device, system and medium for computer system
CN111813799A (en) * 2020-07-23 2020-10-23 德清云岫科技有限公司 Database query statement generation method and device, computer equipment and storage medium

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9740713B1 (en) * 2014-07-31 2017-08-22 Quickbase, Inc. Dynamic modeling of data in relational databases
CN105160023A (en) * 2015-09-30 2015-12-16 深圳市巧捷万端云计算有限公司 Graphical data query processing method based on cloud server
CN105243162A (en) * 2015-10-30 2016-01-13 方正国际软件有限公司 Relational database storage-based objective data model query method and device
CN107515887A (en) * 2017-06-29 2017-12-26 中国科学院计算机网络信息中心 A kind of interactive query method suitable for a variety of big data management systems
CN109213754A (en) * 2018-03-29 2019-01-15 北京九章云极科技有限公司 A kind of data processing system and data processing method
CN111274269A (en) * 2020-01-17 2020-06-12 广州至真信息科技有限公司 Data processing method and device
CN111427971A (en) * 2020-03-25 2020-07-17 中国工商银行股份有限公司 Business modeling method, device, system and medium for computer system
CN111813799A (en) * 2020-07-23 2020-10-23 德清云岫科技有限公司 Database query statement generation method and device, computer equipment and storage medium

Also Published As

Publication number Publication date
CN112632037A (en) 2021-04-09

Similar Documents

Publication Publication Date Title
US10176440B2 (en) Workflow sharing
US8782081B2 (en) Query template definition and transformation
CN103425780B (en) The querying method of a kind of data and device
US20120110583A1 (en) Dynamic parallel looping in process runtime
US20040031015A1 (en) System and method for manipulation of software
CN107015804A (en) A kind of method and system by the quick exploration project of provisioning API
CN112632037B (en) Method and device for graphically defining query data set
US20050021523A1 (en) Holistic dynamic information management platform for end-users to interact with and share all information categories, including data, functions, and results, in a collaborative secure venue
CN114548915A (en) Method and system for realizing business cross-organization circulation based on process engine
DE112022000878T5 (en) DATASET MULTIPLEXER FOR DATA PROCESSING SYSTEM
CN114398694A (en) Method for realizing rapid building information model based on Dynamo program
US20060117000A1 (en) Method and apparatus for querying program design models
Shershakov VTMine framework as applied to process mining modeling
Dubois et al. A framework for dealing with and specifying security requirements in information systems
Boloix et al. Transformations using a meta-system approach to software development
CN114281797A (en) Method for quickly creating basic level data aggregation warehouse based on agile low-code platform
CN116627448A (en) Method for creating micro-service and related equipment
US9268533B2 (en) Method and apparatus for enabling layered property definition in traditional and cloud computing environments
CN103077195B (en) A kind of instrument attribute management method
Motschnig-Pitrik Contexts and views in object-oriented languages
US20020154628A1 (en) Server for gathering and providing information
JPH07114464A (en) Object-oriented data processing system
KR100327904B1 (en) System and Method for Component Customization
WO2010119628A1 (en) System and method for environment information aggregation
CN102929602A (en) System for unified treatment of processes based on process engine

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
TA01 Transfer of patent application right

Effective date of registration: 20230314

Address after: 250101 Inspur science and Technology Park, 1036 Inspur Road, hi tech Zone, Jinan City, Shandong Province

Applicant after: Inspur Genersoft Co.,Ltd.

Address before: 250101 Inspur science and Technology Park, 1036 Inspur Road, hi tech Zone, Jinan City, Shandong Province

Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd.

TA01 Transfer of patent application right
GR01 Patent grant
GR01 Patent grant