CN117251457B - Grid report making method and device - Google Patents
Grid report making method and device Download PDFInfo
- Publication number
- CN117251457B CN117251457B CN202311544774.6A CN202311544774A CN117251457B CN 117251457 B CN117251457 B CN 117251457B CN 202311544774 A CN202311544774 A CN 202311544774A CN 117251457 B CN117251457 B CN 117251457B
- Authority
- CN
- China
- Prior art keywords
- query
- data set
- current database
- report
- grid report
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000004519 manufacturing process Methods 0.000 claims abstract description 21
- 238000013507 mapping Methods 0.000 claims description 4
- 238000003860 storage Methods 0.000 claims description 4
- 238000004590 computer program Methods 0.000 claims 2
- 238000011161 development Methods 0.000 abstract description 3
- 230000008569 process Effects 0.000 description 10
- 238000012545 processing Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 4
- 229910052692 Dysprosium Inorganic materials 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 2
- KBQHZAAAGSGFKK-UHFFFAOYSA-N dysprosium atom Chemical compound [Dy] KBQHZAAAGSGFKK-UHFFFAOYSA-N 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000004220 aggregation Methods 0.000 description 1
- 230000002776 aggregation Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005553 drilling Methods 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
-
- 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/2455—Query execution
-
- 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/248—Presentation of query results
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a device for manufacturing a grid report, wherein the manufacturing method comprises the following steps: adding links of other databases in the current database; acquiring table structure information of other databases, and synchronizing the table structure information into a current database; configuring a corresponding grid report according to a data source type, wherein the data source type comprises one or more of a basic table, a data set and an SQL statement; creating a query statement, and executing the query statement in a current database; presenting the query result in the grid report; the invention supports various databases, so long as the table structure information can be obtained, then the required query statement is generated, then the query statement is executed in the database, and the query result is displayed; the system can simultaneously support various databases, and is simple in manufacture, easy for secondary development for users and convenient to use.
Description
Technical Field
The invention relates to the field of table data processing, in particular to a method and a device for manufacturing a grid report.
Background
Table data processing is an important ring in the data processing process of a database, and three processing modes exist in the prior art: dynamics 365, developing corresponding pages directly and dysprosium number charts.
Dynamics 365 customer relationship management software packages developed by Microsoft, focus on enhancing customer relationships for any organization. A user can quickly create table structures, relationships, and events through an interface. Form pages, query lists, and statistics are generated quickly. However, the data structure is very known in the configuration process, and the existing service cannot be directly supported, and only the configuration can be started from 0.
Directly developing the corresponding page: the personalized requirements can be met, but most of the query pages are universal, and the personalized requirements are very small. The cost of directly developing manpower and time is relatively high.
Dysprosium number chart: the zero code data content collaboration platform helps users to easily and efficiently acquire data and display the data, and realizes effective collaboration and communication based on data content. But only Excel acquisition data can be supported, and no more data patterns can be supported.
Disclosure of Invention
In order to solve the problems, the invention provides a method and a device for manufacturing a grid report which supports various databases and is easy to develop.
In order to achieve the above object, an aspect of the present invention provides a method for manufacturing a grid report, including the following steps:
adding links of other databases in the current database;
acquiring table structure information of other databases, and synchronizing the table structure information into a current database; the table structure information comprises one or more of table names, field names, data types and field remarks;
configuring a corresponding grid report according to a data source type, wherein the data source type comprises one or more of a basic table, a data set and an SQL statement;
creating a query statement, and executing the query statement in a current database;
and presenting the query result in the grid report.
As a preferred embodiment, the dataset is created by:
selecting a table in a current database, setting a main table as a basic table, setting a connection mode and an association field after selecting other tables, and establishing an association relation between the main table and one or more tables;
and creating a data set according to the association relation.
As a preferred embodiment, the query statement includes a query condition and a query list, and the fields in the query condition include one or more of a character string type, a number type, and a date type; the fields in the query list are then added to the Select field when converted to SQL statements.
As a preferred embodiment, when the data source type is SQL statement, the query condition is inserted into the internal query, specifically comprising: and adding a preset field in the query list by using the placeholder, and inserting the query condition into the sub-query in the original SQL after the user inputs the query content.
As a preferred implementation, when the data source type is SQL statement, the codes in the query result are converted into names or codes plus names according to the corresponding relation in the field mapping table.
As a preferred embodiment, drill-down is added, which includes one or more of a mode of opening detail page, a mode of opening grid report, and a mode of opening business system.
As a preferred embodiment, the open detail page mode is used to display header and body information determined from the association relationship of the master table and the slave table added in the theme.
As a preferred embodiment, the subject is created by:
and selecting a table in the current database, setting a master table as a basic table, setting a connection mode and an association field after selecting other tables, and establishing an association relation between the master table and one or more slave tables for use in the process of drilling.
On the other hand, the invention also provides a device for manufacturing the grid report, which comprises the following steps:
the adding unit is used for adding links of other databases in the current database;
the acquisition unit is used for acquiring the table structure information of other databases and synchronizing the table structure information into the current database;
the configuration unit is used for configuring the corresponding grid report according to the data source type, wherein the data source type comprises one or more of a basic table, a data set and an SQL statement;
the creating unit is used for creating a query statement and executing the query statement in the current database;
and the display unit is used for presenting the query result in the grid report.
Compared with the prior art, the invention has the beneficial effects that: the invention supports various databases, so long as the table structure information can be obtained, then the required query statement is generated, then the query statement is executed in the database, and the query result is displayed; the system can simultaneously support various databases, and is simple in manufacture, easy for secondary development for users and convenient to use.
Drawings
FIG. 1 is a flowchart of a method for producing a grid report according to an embodiment of the present invention;
fig. 2 is a block diagram of a grid report manufacturing apparatus according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described 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.
Referring to fig. 1, the present embodiment provides a method for manufacturing a grid report, including the following steps:
s10: adding links of other databases in the current database;
in particular, the other databases may be one or more of Mysql, oracle, dream, sqlServer, jugaku Jin Cang, clickhouse, doris, etc. The database connection is added and then stored in the database of the invention, the currently used database can be switched on the page, and the relevant information configured afterwards is configured based on the database.
S20: acquiring table structure information of other databases, and synchronizing the table structure information into a current database; the table structure information comprises one or more of table names, field names, data types and field remarks;
specifically, information such as table names, field names, data types, field notes and the like is acquired in different modes according to different databases and then stored in the database of the invention. The reading and writing are processed in a batch processing mode, so that the reading and writing performance is improved. It should be noted that, the acquisition mode depends on the database, and conventional technical means in the field are not described herein.
S30: configuring a corresponding grid report according to a data source type, wherein the data source type comprises one or more of a basic table, a data set and an SQL statement;
it should be noted that, the base table refers to an actual table of the current database in this embodiment, the dataset refers to a view table formed by connecting the base database to each other, and the SQL refers to a query result table directly generated by an SQL statement.
Before grid report configuration, a theme and a data set need to be created, wherein the specific creation theme is to select a table in a current database, set a main table as a basic table, set a connection mode and an associated field after selecting other tables, and establish an associated relation between the main table and one or more slave tables for use in drill-down.
The method is characterized in that the method comprises the steps of creating a data set, namely selecting a table in a current database, setting a main table as a basic table, setting a connection mode and an association field after selecting other tables, and establishing an association relation between the main table and one or more tables. For complex situations, SQL statements can also be directly written to create data sets, such as joint queries, conditional queries, data aggregation, and other scenarios.
After the creation of the theme and the data set is completed, a grid report can be created, a basic table (original table structure) can be selected, the data set can be directly written into an SQL sentence, and the information of the columns can be obtained. If a statistical report is needed, a calculation field can be created to support various functions (SUM, MAX, MIN, AVG, etc.), or other complex calculation functions can be written by self, the function can be tested to determine whether the test statement is correct in the currently selected data type when the function is stored, and an as grammar can be used to create an alias because the field name is too long in some databases and can fail to be executed (such as the dream database).
S40: creating a query statement, and executing the query statement in a current database;
after the grid report is created, a query statement can be created, and the field list can be added into the query condition and the query list by clicking or dragging the field. The fields in the query condition are then added to the Where condition when converted to an SQL statement. The fields in the query condition can set different query modes according to different field types, for example, whether the matching mode of the character string type can be fuzzy query or accurate query can be set; for example, the number type can be set to be queried in a mode of greater than, less than, equal to or the like; for example, date type can be set up by means of annual search, monthly search, daily search, etc.
In addition, a default value can be set, and the initialization value on the page is reflected. Some properties of the page display may also be set, such as the length of the control, the reminder (PlaceHolder), whether read-only, whether the page is displayed, etc. For the data source of the SQL mode, the query condition can be inserted into the internal query, the placeholder @ a { n }, the field name @ a { n }, and after the user inputs the query content on the page, the condition can be inserted into the sub-query in the original SQL, so that the query flexibility is improved. The fields in the query list are added to the Select field when the fields are converted into SQL sentences, and the fields in the query list can be provided with display modes, such as prefix (% and $) and the like, suffix (%, chinese and the like), color, width, alignment modes and the like, which are all processed by the front end according to the query result when the page is rendered. When the query result is obtained, the relevant code in the result can be converted into a name or a code |name according to the corresponding relation in the field mapping table, in addition, the export attribute can be configured, and the configured field can export the content of the field when exporting PDF or Excel.
S50: and presenting the query result in the grid report.
Finally, the query result is presented in a grid report, the drill-down can be added, a designated field is selected, the current column can change the color after the drill-down is started, the color is highlighted, the drill-down has three modes, the first mode of opening the detail page mainly displays the table head table body information, the table body needs to be added with the association relation of the table in the theme, when the drill-down is edited, the preset theme which is used as a basic table is automatically pulled, and the association sub-table of the table is queried after the theme is selected. And the second method is to open a related grid report, after the grid report id is set, if parameters are required to be transferred, the query condition on the page and the information of the query result of the data line can be mapped into the query condition of a new grid report, and the received grid report is displayed in the query condition of the page as a default value according to whether the page request parameters are matched with the corresponding fields or not under the condition that the query condition can be matched, so as to execute the query method. And thirdly, opening a service system page, wherein the parameter transmission mode is consistent with the second mode, related query conditions exist in the service system page, transmission parameters can be accepted, and the service system page can be transmitted after a mapping relation is set.
In addition, in order to reduce the error probability of the production system, the method for producing the grid report according to the embodiment exports the related information related to the configuration process into json format files and produces compressed packets after the grid report is configured in the development environment, and then the compressed packets are imported into the production system.
In addition, the data set with slow inquiry or larger inquiry quantity can be directly landed into the Doris database through the timing task by further optimization, so that the loss generated in the inquiry process is reduced.
The grid report making method described in the embodiment can enable the grid report clients to be privately configured, in order to meet different requirements of different clients on the same Zhang Wangge report, conventional query conditions and query results are set when the grid report is made, and when the clients are used, the clients can adjust the sequence, display or hide according to the requirements of the clients, so that personalized requirements are achieved.
Referring to fig. 2, the embodiment further provides a device for making a grid report, including:
an adding unit 100, configured to add links of other databases to the current database; it should be noted that, since the specific adding method and the specific process are already described in detail in the step S10 of the method for making a grid report, the detailed description is omitted here.
An obtaining unit 200, configured to obtain table structure information of other databases, and synchronize the table structure information to a current database; it should be noted that, since the specific acquiring method and the process are already described in detail in the step S20 of the method for making a grid report, the detailed description is omitted here.
A configuration unit 300, configured to configure a corresponding grid report according to a data source type, where the data source type includes one or more of a base table, a data set, and an SQL statement; it should be noted that, since the specific configuration method and the process are already described in detail in the step S30 of the method for producing a grid report, the description is omitted here.
A creating unit 400 for creating a query sentence, the query sentence being executed in a current database; it should be noted that, since the specific creating method and process are already described in detail in the step S40 of the method for producing a grid report, the description thereof is omitted here.
A display unit 500 for presenting the query result in the grid report; it should be noted that, since the specific display method and the process are already described in detail in the step S50 of the method for producing a grid report, the description thereof is omitted here.
In addition, the embodiment of the invention also provides a computer readable storage medium, wherein the computer readable storage medium can store a program, and the program when executed comprises part or all of the steps of the method for making any grid report described in the method embodiment.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable memory. Based on this understanding, the technical solution of the present invention may be embodied essentially or partly in the form of a software product, or all or part of the technical solution, which is stored in a memory, and includes several instructions for causing a computer device (which may be a personal computer, a server, a network device, or the like) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned memory includes: a U-disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing program codes.
Those of ordinary skill in the art will appreciate that all or a portion of the steps in the various methods of the above embodiments may be implemented by a program that instructs associated hardware, and the program may be stored in a computer readable memory, which may include: flash disk, read-Only Memory (ROM), random access Memory (Random Access Memory, RAM), magnetic disk or optical disk.
An exemplary flowchart of a method for implementing grid report production according to an embodiment of the present invention is described above with reference to the accompanying drawings. It should be noted that the numerous details included in the above description are merely illustrative of the invention and not limiting of the invention. In other embodiments of the invention, the method may have more, fewer, or different steps, and the order, inclusion, functional relationship between steps may be different than that described and illustrated.
Claims (6)
1. The method for manufacturing the grid report is characterized by comprising the following steps of:
adding links of other databases in the current database;
acquiring table structure information of other databases, and synchronizing the table structure information into a current database; the table structure information comprises one or more of table names, field names, data types and field remarks;
configuring a corresponding grid report according to a data source type, wherein the data source type comprises one or more of a basic table, a data set and an SQL statement; the method comprises the steps that a basic table refers to an actual table of a current database, a data set refers to a view table formed by connecting the basic database left and right, and SQL sentences refer to a query result table directly generated through the SQL sentences; before grid report configuration, a theme and a data set are required to be created, wherein the specific theme is to select a table in a current database, set a main table as a basic table, set a connection mode and an associated field after selecting other tables, and establish an associated relation between the main table and one or more slave tables for use in drill-down; creating a data set, namely selecting a table in a current database, setting a main table as a basic table, setting a connection mode and an associated field after selecting other tables, and establishing an associated relation between the main table and one or more tables for the data set of the grid report; creating a grid report after the creation of the theme and the data set is completed, and selecting one or more of a basic table, the data set and an SQL sentence so as to acquire information of a column;
creating a query statement, and executing the query statement in a current database;
presenting the query result in the grid report;
adding drill-down aiming at drill-down requirements, wherein the drill-down comprises one or more of a detail page opening mode, a grid report opening mode and a business system opening mode; the open detail page mode is used for displaying a header and table body information, and the table body information is determined through the association relation between a master table and a slave table added in the theme.
2. The method of manufacturing according to claim 1, wherein: the query statement comprises a query condition and a query list, wherein fields in the query condition comprise one or more of a character string type, a number type and a date type; the fields in the query list are then added to the Select field when converted to SQL statements.
3. The method of claim 2, wherein when the data source type is an SQL statement, inserting the query condition into an internal query, specifically comprises: and adding a preset field in the query list by using the placeholder, and inserting the query condition into the sub-query in the original SQL after the user inputs the query content.
4. The method of manufacturing according to claim 1, wherein: and when the data source type is SQL statement, converting the code in the query result into a name or adding the name to the code according to the corresponding relation in the field mapping table.
5. The utility model provides a making device of net report, its characterized in that includes:
the adding unit is used for adding links of other databases in the current database;
the acquisition unit is used for acquiring the table structure information of other databases and synchronizing the table structure information into the current database;
the configuration unit is used for configuring the corresponding grid report according to the data source type, wherein the data source type comprises one or more of a basic table, a data set and an SQL statement; the method comprises the steps that a basic table refers to an actual table of a current database, a data set refers to a view table formed by connecting the basic database left and right, and SQL sentences refer to a query result table directly generated through the SQL sentences; before grid report configuration, a theme and a data set are required to be created, wherein the specific theme is to select a table in a current database, set a main table as a basic table, set a connection mode and an associated field after selecting other tables, and establish an associated relation between the main table and one or more slave tables for use in drill-down; creating a data set, namely selecting a table in a current database, setting a main table as a basic table, setting a connection mode and an associated field after selecting other tables, and establishing an associated relation between the main table and one or more tables for the data set of the grid report; creating a grid report after the creation of the theme and the data set is completed, and selecting one or more of a basic table, the data set and an SQL sentence so as to acquire information of a column;
the creating unit is used for creating a query statement and executing the query statement in the current database;
the display unit is used for presenting the query result in the grid report; adding drill-down aiming at drill-down requirements, wherein the drill-down comprises one or more of a detail page opening mode, a grid report opening mode and a business system opening mode; the open detail page mode is used for displaying a header and table body information, and the table body information is determined through the association relation between a master table and a slave table added in the theme.
6. A computer-readable storage medium, comprising: the computer-readable storage medium stores a computer program, wherein the computer program when executed by a processor implements the steps of a grid report making method as claimed in any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311544774.6A CN117251457B (en) | 2023-11-20 | 2023-11-20 | Grid report making method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311544774.6A CN117251457B (en) | 2023-11-20 | 2023-11-20 | Grid report making method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117251457A CN117251457A (en) | 2023-12-19 |
| CN117251457B true CN117251457B (en) | 2024-03-12 |
Family
ID=89135456
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311544774.6A Active CN117251457B (en) | 2023-11-20 | 2023-11-20 | Grid report making method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117251457B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN115639998A (en) * | 2022-09-27 | 2023-01-24 | 海尔优家智能科技（北京）有限公司 | Report management method and device, storage medium and electronic device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB201206722D0 (en) * | 2012-04-17 | 2012-05-30 | Dataline Software Ltd | Methods of querying a relational database |
-
2023
- 2023-11-20 CN CN202311544774.6A patent/CN117251457B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN115639998A (en) * | 2022-09-27 | 2023-01-24 | 海尔优家智能科技（北京）有限公司 | Report management method and device, storage medium and electronic device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117251457A (en) | 2023-12-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108197237B (en) | Visual data acquisition and display system | |
| US8122066B2 (en) | Database query profiler | |
| US8479093B2 (en) | Metamodel-based automatic report generation | |
| CN103168300B (en) | There is the incremental maintenance of the materialized view immediately of outer connection | |
| US20160224594A1 (en) | Schema Definition Tool | |
| US8983931B2 (en) | Index-based evaluation of path-based queries | |
| US20110131200A1 (en) | Complex path-based query execution | |
| US20030158947A1 (en) | Enabling online and offline operation | |
| US20090327343A1 (en) | Schema-based data transfer between a data-based application and a document application | |
| CN107368503A (en) | Method of data synchronization and system based on Kettle | |
| WO2024001493A1 (en) | Visual data analysis method and device | |
| CN108776702A (en) | A kind of data make a report on page user-defined visual configuration method | |
| CN105843867B (en) | Search method based on metadata schema and the retrieval device based on metadata schema | |
| US20070073675A1 (en) | Database query translation | |
| US20150032689A1 (en) | Data definition language (ddl) expression annotation | |
| CN109710631A (en) | Auxiliary generates method, apparatus, equipment and the computer storage medium of SQL code | |
| CN110990011A (en) | Data request method of automation interface | |
| US8688649B2 (en) | Scalable computer arrangement and method | |
| CN114090760A (en) | Data processing method of table question and answer, electronic equipment and readable storage medium | |
| CN117251457B (en) | Grid report making method and device | |
| US20060230048A1 (en) | Method and apparatus for object discovery agent based mapping of application specific markup language schemas to application specific business objects in an integrated application environment | |
| EP3832482A1 (en) | Server-side cross-model measure-based filtering | |
| CN108694172B (en) | Information output method and device | |
| CN116360881B (en) | Data set generation method and device, electronic equipment and storage medium | |
| CN113238865A (en) | Method for quickly constructing knowledge graph based on Excel one-key import |
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 |