SQL modeling method and system for SAP HANA database

Abstract

The invention provides an SQL modeling method and system for an SAP HANA database, and the method comprises the steps: tracking a plurality of object modeling logs of the SAP HANA database, and obtaining a plurality of pieces of modeling log tracking information; the modeling log tracking information is used for determining model creation operation data; according to the multiple pieces of modeling log tracking information and a preset SQL language rule, obtaining HANA SQL modeling data; and SQL modeling of the SAP HANA database is carried out according to the HANA SQL modeling data. Through the SQL modeling mode, the complexity of operation is reduced, higher operation efficiency and more accurate model construction can be realized, and the project implementation period can be remarkably shortened, so that the business requirements are quickly met, and the project delivery is accelerated.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing and provides an SQL modeling method and system for a SAP HANA database. Background Art

[0002] HANA modeling is a key technology for data modeling and analysis on the SAP HANA database platform. SAP HANA is an innovative in-memory database and data processing platform designed to meet large-scale data processing needs. It provides excellent high performance and real-time data processing and analysis capabilities. In the context of HANA modeling, users can carefully design and build data models to effectively store, organize and analyze data to meet diverse business needs.

[0003] The core value of HANA modeling is to give enterprises a deeper understanding of data, enabling them to extract valuable insights from massive data, thereby providing solid support for business decisions, future forecasts and strategic planning. This process provides business users and data analysts with a variety of powerful tools and functions to better utilize the excellent performance and functions provided by SAP HANA.

[0004] In the traditional HANA modeling process, a graphical interface tool is needed to define the model's structure, tables, and fields. This usually involves multiple steps and interface jumps, which increases the complexity of the operation and lengthens the modeling process. Summary of the invention

[0005] The embodiment of the present invention provides a SQL modeling method and system for SAP HANA database, which is used to solve the defects of complex operation and lengthy modeling process in related technologies. The present invention reduces the complexity of operation through SQL modeling, can achieve higher operation efficiency and more accurate model construction, can significantly shorten the project implementation cycle, thereby quickly meeting business needs and accelerating project delivery.

[0006] The present invention provides an SQL modeling method for a SAP HANA database, comprising: tracking a plurality of object modeling logs of the SAP HANA database to obtain a plurality of modeling log tracking information; the modeling log tracking information is used to determine model creation operation data; according to the plurality of modeling log tracking information and preset SQL language rules, HANASQL modeling data is obtained; and SQL modeling of the SAP HANA database is performed according to the HANA SQL modeling data.

[0007] According to a SQL modeling method for a SAP HANA database provided by the present invention, tracking a plurality of object modeling logs of the SAP HANA database to obtain a plurality of modeling log tracking information includes: acquiring a plurality of object modeling log information of the SAP HANA database; performing log structure analysis according to the plurality of log information to determine a plurality of process information; the process information is information of a model creation operation process; performing process object analysis according to the plurality of process information to obtain a plurality of modeling log tracking information.

[0008] According to an SQL modeling method for a SAP HANA database provided by the present invention, the method obtains HANA SQL modeling data according to a plurality of modeling log tracking information and preset SQL language rules, including: determining a plurality of statement encapsulation elements according to a plurality of modeling log tracking information; the statement encapsulation elements include system tables, stored procedures, functions or triggers; determining a plurality of model creation operation data according to the plurality of statement encapsulation elements and the preset SQL language rules; and obtaining the HANA SQL modeling data by taking the intersection of the plurality of model creation operation data.

[0009] According to a SQL modeling method for a SAP HANA database provided by the present invention, the HANA SQL modeling data includes model definition data, model architecture data, BMIC information and operation object information; the model definition data is basic definition data for SQL code to create a model in the HANA database, and the model architecture data is design element data required for the SQL code to build a model in the HANA database; the BMIC information includes BIMC attribute information, BIMC dimension information and BIMC aggregation information; the operation object information includes creating a calculation plan, creating a column view, creating a view note, creating a column note and creating a view column.

[0010] The SQL modeling method for SAP HANA database provided by the present invention further includes: controlling the user authority of creating the model.

[0011] According to a SQL modeling method for a SAP HANA database provided by the present invention, controlling the user authority for creating a model includes: controlling designated users to have the authority for creating a model, and controlling undesignated users to not have the authority for creating a model.

[0012] The present invention also provides an SQL modeling system for a SAP HANA database, comprising: a tracking module, used to track a plurality of object modeling logs of the SAP HANA database to obtain a plurality of modeling log tracking information; the modeling log tracking information is used to determine model creation operation data; a HANA SQL modeling data determination module, used to obtain HANA SQL modeling data according to the plurality of modeling log tracking information and preset SQL language rules; and a modeling module, used to perform SQL modeling of the SAP HANA database according to the HANA SQL modeling data.

[0013] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the SQL modeling method for the SAP HANA database described above is implemented.

[0014] The present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the SQL modeling method for the SAP HANA database as described in any one of the above is implemented.

[0015] The present invention also provides a computer program product, comprising a computer program, wherein when the computer program is executed by a processor, the computer program implements any one of the above-mentioned SQL modeling methods for the SAP HANA database.

[0016] The present invention provides a method and system for SQL modeling of a SAP HANA database, the method comprising: tracking a plurality of object modeling logs of the SAP HANA database to obtain a plurality of modeling log tracking information; the modeling log tracking information is used to determine model creation operation data; according to the plurality of modeling log tracking information and preset SQL language rules, HANA SQL modeling data is obtained; and SQL modeling of the SAP HANA database is performed according to the HANA SQL modeling data. The present invention reduces the complexity of operation through SQL modeling, can achieve higher operation efficiency and more accurate model construction, can significantly shorten the project implementation cycle, thereby quickly meeting business needs and accelerating project delivery. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the technical solutions in the present invention or the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0018] Figure 1The present invention is a flowchart of the SQL modeling method for the SAP HANA database.

[0019] Figure 2 The diagram is a schematic diagram of the principles of the SQL modeling method for the SAP HANA database provided by the present invention.

[0020] Figure 3 It is a structural schematic diagram of the SQL modeling system of the SAP HANA database provided by the present invention.

[0021] Figure 4 It is a structural schematic diagram of the electronic device provided by the present invention. DETAILED DESCRIPTION

[0022] The following embodiments of the present invention are described in further detail in conjunction with the accompanying drawings and examples. The following examples are used to illustrate the present invention, but are not intended to limit the scope of the present invention.

[0023] In the process of implementing HANA projects, enterprises usually need to customize data models to better adapt to the operational process requirements of the enterprise to meet the specific needs of the enterprise's business operations. However, although these customized models can meet the diverse needs of users, they are also accompanied by a series of challenges.

[0024] The traditional HANA modeling approach is to select different types of data models, including relational data models, multidimensional data models, and graphical data models, and then use interface tools to define the model's structure, tables, and fields. Use a graphical interface to import data or integrate data from different data sources into the HANA database. This may involve setting up data source connections, data mapping, and data conversion rules. Use interface tools to create various types of views, including database views, model views, and calculated columns. Manage access rights to models and data. This may include defining users and roles, assigning permissions, and setting security rules. After the model is verified and prepared, use the interface tool to publish and deploy it to the production environment for access and use by users and applications.

[0025] In the traditional HANA modeling process, it is necessary to define the structure, tables, and fields of the model through a graphical interface tool, which usually involves multiple steps and interface jumps, increasing the complexity of the operation and making the modeling process lengthy. These problems need to be solved to ensure that the best practices of HANA modeling are developed and implemented to make it more efficient, secure, and easier to use. Therefore, improving and optimizing the HANA modeling process will help overcome these obstacles, enabling it to better meet the needs of enterprises and promote data-driven business success. Therefore, it is necessary to improve the efficiency of HANA data analysis model establishment.

[0026] Please refer to Figure 1, Figure 1 A schematic diagram of the flow of the SQL modeling method for the SAP HANA database provided by the present invention.

[0027] The present invention discloses a SQL modeling method for SAP HANA database, which aims to optimize the creation process of HANA model while taking into account the update and modification of existing models. Through this method, HANA models can be built in an efficient and accurate manner, and the comprehensive management capabilities of these models can be improved. This not only helps to shorten the project implementation cycle, but also effectively reduces project costs and reduces risks during project execution. The core principle of the present invention is to analyze the SQL principles of HANA modeling, convert these analysis results into a new SQL modeling method, and finally replace the traditional graphical modeling tool with SQL modeling, so that once the method is established, it can be widely used in various HANA modeling scenarios.

[0028] The present invention provides a SQL modeling method for a SAP HANA database, comprising: 101: Tracking several object modeling logs of the SAP HANA database to obtain several modeling log tracking information; the modeling log tracking information is used to determine the model creation operation data; 102: Obtain HANA SQL modeling data according to several modeling log tracking information and preset SQL language rules; 103: Perform SQL modeling of SAP HANA database based on HANA SQL modeling data.

[0029] The present invention improves modeling efficiency and simplifies the operation process in an automated manner, utilizes SQL language rules to automate the modeling process, thereby reducing dependence on a graphical interface and achieving fast and accurate database modeling.

[0030] Specifically, first, modeling log tracking is performed for multiple objects in the SAP HANA database. This step involves turning on the database system log tracking function to capture the generation log information of the model object. The log information includes but is not limited to the creation time, modification history, and operation user of the object. By analyzing these logs, the operation data in the model creation process can be determined, including database objects such as system tables, storage, functions, and triggers. Then, the preset SQL language rules are used to parse these log tracking information. These rules define how to convert the log information into SQL statements. Therefore, HANA SQL modeling data, that is, a series of SQL statements for defining the database model structure, can be obtained. Finally, actual SQL modeling is performed based on the obtained HANA SQL modeling data. This step involves executing the previously generated SQL statements to create corresponding model objects in the SAP HANA database. Through the method of the present invention, a complex database model can be quickly constructed while maintaining a high degree of consistency and accuracy, which not only improves the modeling efficiency, but also enhances the maintainability and scalability of the model.

[0031] Please refer to Figure 2 , Figure 2 A schematic diagram of the principles of the SQL modeling method for the SAP HANA database provided by the present invention.

[0032] As a preferred embodiment, several object modeling logs of the SAP HANA database are tracked to obtain several modeling log tracking information, including: obtaining several object modeling log information of the SAP HANA database; performing log structure analysis according to the several log information to determine several process information; the process information is information of the model creation operation process; performing process object analysis according to the several process information to obtain several modeling log tracking information.

[0033] In this embodiment, first, by enabling the log tracking function of the SAP HANA database, the log information generated during the database object modeling process is captured. This information records in detail the key data such as the time point of object creation, modification or deletion, the operation type, and the operation user. Then, the collected log information is structured and analyzed to determine the key steps in the model creation operation process. This step involves parsing the log information, extracting the operation sequence and dependency, and thus constructing the complete process information of model creation. Based on the process information obtained by the analysis, process object analysis is performed. This step involves a detailed analysis of the database objects (such as system tables, storage, functions, triggers, etc.) involved in each operation process to obtain complete modeling log tracking information. This information will be used to generate corresponding SQL statements, thereby realizing automated database modeling.

[0034] As a preferred embodiment, HANA SQL modeling data is obtained according to a plurality of modeling log tracking information and preset SQL language rules, including: determining a plurality of statement encapsulation elements according to a plurality of modeling log tracking information; the statement encapsulation elements include system tables, stored procedures, functions or triggers; determining a plurality of model creation operation data according to the plurality of statement encapsulation elements and preset SQL language rules; and obtaining HANA SQL modeling data by taking the intersection of the plurality of model creation operation data.

[0035] In this embodiment, by tracking the modeling log of SAP HANA database objects, key log tracking information is obtained. Based on this information, a series of statement encapsulation elements are determined. Statement encapsulation elements refer to basic building blocks that can be reused in SQL modeling. They can be system tables, stored procedures (stored), functions or triggers, etc. These elements are the basic components of the database model, and each element corresponds to a specific object in the database. Then, according to these statement encapsulation elements and preset SQL language rules, a series of model creation operation data are determined. These operation data describe in detail how to create or modify objects in the database through SQL statements. For example, if a statement encapsulation element is a system table, the corresponding model creation operation data may include table creation statements, column definitions, data type specifications, etc. Then, all these model creation operation data are summarized and the intersection is taken to obtain the final HANASQL modeling data. The purpose of taking the intersection is to ensure that the obtained SQL modeling data is complete and consistent. It contains all the information necessary to create a database model while avoiding redundant or conflicting operations.

[0036] As a preferred embodiment, HANA SQL modeling data includes model definition data, model architecture data, BMIC information and running object information; the model definition data is the basic definition data for SQL code to create a model in the HANA database, and the model architecture data is the design element data required for the SQL code to build a model in the HANA database; the BMIC information includes BIMC attribute information, BIMC dimension information and BIMC aggregation information; the running object information includes creating a calculation plan, creating a column view, creating a view note, creating a column note and creating a view column.

[0037] In this embodiment, after HANA graphical modeling is performed, SQL codes (HANA SQL modeling data) are generated, which define the structure of the model, data import and processing methods. By carefully analyzing these generated SQL statements, important information about the data storage location can be obtained.

[0038] Model definition data is the basic definition data for SQL code to create a model in the HANA database, including information such as name and permissions. HANA model definition is stored in the catalog schema ("PACKAGE_CATALOG") table, and mainly uses fields such as package ID ("PACKAGE_ID"), target system ("SRC_SYSTEM"), target tenant ("SRC_TENANT"), description ("DESCRIPTION"), resource overview ("RESPONSIBLE"), delivery month ("DELIVERY_UNIT"), text ("TEXT_COLLECTION"), text status ("TEXT_STATUS"), text domain ("TEXT_TERMINOLOGY_DOMAIN"), transaction hints ("HINTS_FOR_TRANSLATION"), and DU vendor ("DU_VENDOR") as model definitions.

[0039] Model architecture data is the design element data required by SQL code to build a model in the HANA database, including detailed information such as the data tables involved and references to other models.

[0040] The main tables involved are: Activation Object Help 2 ("ACTIVATION_HELPER2"), Activation Object Content Text ("ACTIVE_CONTENT_TEXT"), Activation Content Text 2 ("ACTIVE_CONTENT_TEXT_CONTENT"), Activation Object Text ("ACTIVE_OBJECT_TEXT"), Activation Object Text Content ("ACTIVE_OBJECT_TEXT_CONTENT"), Activation Object Reference ("ACTIVE_OBJECTCROSSREF"), and Activation Object ("ACTIVE_OBJECT"). The information of the newly created model needs to be written into these tables through the insert into statement.

[0041] BMIC information is mainly stored in three data tables: BIMC property information ("BIMC_PROPERTIES"), BIMC dimension information ("BIMC_ALL_DIMENSIONS"), and BIMC aggregation information ("BIMC_ALL_CUBES"). SQL is used to generate BIMC property information.

[0042] BIMC attribute information includes: INSERT INTO "_SYS_BI"."BIMC_PROPERTIES"

[0043] SELECT FROM BIMC_PROPERTIES_BAK; BIMC dimension information includes: INSERT INTO "_SYS_BI"."BIMC_ALL_DIMENSIONS"

[0044] SELECT FROM BIMC_ALL_DIMENSIONS_BAK; BIMC aggregated information includes: INSERT INTO "_SYS_BI"."BIMC_ALL_CUBES"

[0045] SELECT FROM BIMC_ALL_CUBES_BAK.

[0046] The running object information includes the definition and name of the calculated columns in statements such as Create calculation scheme (CREATE CALCULATION SCENARIO), Create column view (CREATE COLUMN VIEW), Create view comment (COMMENT ON VIEW), Create column comment (COMMENT ONCOLUMN), and Create view column (CREATE VIEW COLUMN).

[0047] As a preferred embodiment, the method further includes: controlling the user authority for creating the model.

[0048] According to a SQL modeling method for a SAP HANA database provided by the present invention, controlling the user authority for creating a model includes: controlling a designated user to have the authority for creating a model, and controlling an undesignated user to not have the authority for creating a model.

[0049] Consider that the implementation of HANA data modeling requires a certain learning cost. Customizing models may involve the use of complex tools and technologies, requiring team members to master new knowledge and skills, which may lead to a certain learning curve and time investment. At the same time, in the graphical modeling interface, managing modeling permissions may become complicated. Especially for large organizations, ensuring that only authorized users can access and modify models may become cumbersome and prone to improper permission management. In addition to this, different users may create their own models, which may lead to data inconsistency and confusion. Maintaining data consistency may become a challenge.

[0050] In this embodiment, the SQL modeling method based on the SAP HANA database can realize the rapid generation of HANA models, solving the problem that models can only be generated through the HANA studio tool. After this problem is solved, HANA models can be generated through other applications (java, pyhton, etc.). This embodiment can control the creation permissions of HANA models. It can be defined that only designated users can create HANA models, and undesignated users cannot create models but can modify models. The flexibility of HANA permissions can be achieved.

[0051] In the process of creating HANA models, the SQL modeling method can achieve rapid and accurate model construction, thereby achieving the following multiple advantages: (1) Improved project efficiency: SQL modeling can significantly shorten the project implementation cycle. Compared with traditional methods, it allows models to be defined and configured more quickly, thereby quickly meeting business needs and accelerating project delivery.

[0052] (2) Cost reduction: SQL modeling reduces project implementation costs by reducing the waste of human and time resources. This is an important economic advantage for enterprises, allowing limited resources to be used for more valuable tasks.

[0053] (3) Improved management and control capabilities: SQL modeling provides more detailed permission management and control capabilities, helping enterprises better manage HANA models. It can ensure data security and compliance, as well as better resource allocation.

[0054] (4) Risk reduction: By using SQL modeling, potential problems can be more easily detected and corrected, reducing project implementation risks.

[0055] (5) Business flexibility: SQL modeling provides greater flexibility, allowing for rapid adjustment and modification of models based on changing business needs. This helps companies better adapt to market changes and business challenges.

[0056] The SQL modeling system for the SAP HANA database provided by the present invention is described below. The SQL modeling system for the SAP HANA database described below and the SQL modeling method for the SAP HANA database described above can be referred to each other.

[0057] Please refer to Figure 3 , Figure 3 This is a schematic diagram of the structure of the SQL modeling system for the SAP HANA database provided by the present invention.

[0058] The present invention also provides an SQL modeling system for a SAP HANA database, comprising: a tracking module 301, used to track a plurality of object modeling logs of the SAP HANA database to obtain a plurality of modeling log tracking information; the modeling log tracking information is used to determine model creation operation data; a HANA SQL modeling data determination module 302, used to obtain HANA SQL modeling data according to the plurality of modeling log tracking information and preset SQL language rules; and a modeling module 303, used to perform SQL modeling of the SAP HANA database according to the HANA SQL modeling data.

[0059] Figure 4 An example of a structural diagram of an electronic device is shown in FIG. Figure 4 As shown, the electronic device may include: a processor 410, a communication interface 420, a memory 430 and a communication bus 440, wherein the processor 410, the communication interface 420 and the memory 430 communicate with each other through the communication bus 440. The processor 410 may call the logic instructions in the memory 430 to execute the SQL modeling method of the SAP HANA database, the method comprising: tracking a plurality of object modeling logs of the SAP HANA database to obtain a plurality of modeling log tracking information; the modeling log tracking information is used to determine the model creation operation data; according to the plurality of modeling log tracking information and the preset SQL language rules, HANA SQL modeling data is obtained; and SQL modeling of the SAP HANA database is performed according to the HANA SQL modeling data.

[0060] In addition, the logic instructions in the above-mentioned memory 430 can be implemented in the form of a software functional unit and can be stored in a computer-readable storage medium when it is sold or used as an independent product. Based on this understanding, the technical solution of the present invention, or the part that contributes to the relevant technology or the part of the technical solution, can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods of each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.

[0061] An embodiment of the present invention discloses a computer program product, which includes a computer program stored on a non-transitory computer-readable storage medium. The computer program includes program instructions. When the program instructions are executed by a computer, the computer can execute the SQL modeling method of the SAP HANA database provided by the above-mentioned method embodiments. The method includes: tracking a plurality of object modeling logs of the SAP HANA database to obtain a plurality of modeling log tracking information; the modeling log tracking information is used to determine model creation operation data; according to the plurality of modeling log tracking information and preset SQL language rules, HANA SQL modeling data is obtained; and SQL modeling of the SAP HANA database is performed according to the HANA SQL modeling data.

[0062] On the other hand, an embodiment of the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the method for executing the SQL modeling method for the SAP HANA database provided in the above embodiments is implemented, the method comprising: tracking a plurality of object modeling logs of the SAP HANA database to obtain a plurality of modeling log tracking information; the modeling log tracking information is used to determine model creation operation data; according to the plurality of modeling log tracking information and preset SQL language rules, HANA SQL modeling data is obtained; and SQL modeling of the SAP HANA database is performed according to the HANA SQL modeling data.

[0063] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.

[0064] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the relevant technology can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiment.

[0065] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A SQL modeling method for SAP HANA database, characterized in that: include: Track several object modeling logs of the SAP HANA database to obtain several modeling log tracking information; The modeling log tracking information is used to determine model creation operation data; Obtaining HANA SQL modeling data according to the modeling log tracking information and preset SQL language rules; Perform SQL modeling of the SAP HANA database based on the HANA SQL modeling data.

2. The SQL modeling method for SAP HANA database according to claim 1, characterized in that: The tracking of several object modeling logs of the SAPHANA database obtains several modeling log tracking information, including: Obtaining log information of several object modeling of the SAP HANA database; Performing log structure analysis based on the plurality of log information to determine a plurality of process information; the process information is information about the model creation operation process; Process object analysis is performed based on the plurality of process information to obtain the plurality of modeling log tracking information.

3. The SQL modeling method for SAP HANA database according to claim 1, characterized in that: The obtaining of HANA SQL modeling data according to the modeling log tracking information and the preset SQL language rules includes: Determine a plurality of statement encapsulation components according to a plurality of modeling log tracking information; the statement encapsulation components include system tables, stored procedures, functions or triggers; Determining a plurality of model creation operation data according to a plurality of the statement encapsulation elements and the preset SQL language rules; The intersection of several of the model creation operation data is taken to obtain the HANA SQL modeling data.

4. The SQL modeling method for SAP HANA database according to claim 1, characterized in that: The HANA SQL modeling data includes model definition data, model architecture data, BMIC information and running object information; the model definition data is the basic definition data for SQL code to create a model in the HANA database, and the model architecture data is the design element data required for the SQL code to build a model in the HANA database; the BMIC information includes BIMC attribute information, BIMC dimension information and BIMC aggregation information; The running object information includes creating a calculation plan, creating a column view, creating a view note, creating a column note, and creating a view column.

5. The SQL modeling method for SAP HANA database according to any one of claims 1 to 4, characterized in that: Also includes: Controls user permissions for creating models.

6. The SQL modeling method for SAP HANA database according to claim 5, characterized in that: The control of user permissions for creating models includes: Controls whether specified users have the permission to create models, and controls whether unspecified users have the permission to create models.

7. A SQL modeling system for SAP HANA database, characterized in that: include: The tracking module is used to track several object modeling logs of the SAP HANA database and obtain several modeling log tracking information; The modeling log tracking information is used to determine model creation operation data; A HANA SQL modeling data determination module, used to obtain HANA SQL modeling data according to a number of modeling log tracking information and preset SQL language rules; The modeling module is used to perform SQL modeling of the SAP HANA database according to the HANA SQL modeling data.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the program, the SQL modeling method for the SAP HANA database according to any one of claims 1 to 6 is implemented.

9. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the SQL modeling method for the SAP HANA database according to any one of claims 1 to 6 is implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the SQL modeling method for the SAP HANA database according to any one of claims 1 to 6 is implemented.

Images