Method for generating data table design information

Abstract

The invention discloses a method for generating data table design information. The method comprises the steps of obtaining first prompt information and second prompt information in response to a data table design request; first prompt information and second prompt information are provided for a data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information and a target knowledge base associated with the data table design model, and the target knowledge base is used for storing at least one sample data table; providing second prompt information and the initial data table design information for a data table design model, so that the data table design model generates target data table design information corresponding to the generation request of the data table design information according to the second prompt information and the initial data table design information, and displaying the target data table design information, role process guidance, sample experience reuse and iterative optimization are realized, standard and accurate data table design is output, and quality and efficiency are improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of human-computer interaction, and in particular to a data table design information generation method. BACKGROUND

[0002] With the deepening of digital transformation, the data scale of various industries has increased rapidly. As the core carrier of data storage and management, the design quality of the data table directly affects the system performance and maintainability.

[0003] In related technologies, AI models are usually generated based on requirement descriptions. The models output based on general knowledge lack technical role and process constraints, and are prone to violate architecture specifications. The knowledge base of stored sample data tables is not utilized, making it difficult to draw on industry best practices and the design is not targeted. Moreover, only initial solutions are generated at a single time, lacking iterative optimization, resulting in insufficient accuracy and practicality of the results, poor adaptability in complex business scenarios, and the need for a large amount of manual correction, with low efficiency and quality. SUMMARY

[0004] The present application provides a data table design information generation method to solve the problem of lack of technical role process guidance, sample reference, and iterative optimization when intelligently generating data tables in related technologies, resulting in design inconsistency with architecture and low quality.

[0005] According to an aspect of the present application, a data table design information generation method is provided, comprising:

[0006] In response to a data table design request, first prompt information and second prompt information are obtained. The first prompt information includes requirement description information for the data table, and the second prompt information is used to prompt the data table design model to generate the data table in the role of a data architecture designer according to a preset process.

[0007] The first prompt information and the second prompt information are provided to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information, and a target knowledge base associated with the data table design model. The target knowledge base is used to store at least one sample data table.

[0008] The second prompt information and the initial data table design information are provided to the data table design model, so that the data table design model generates target data table design information corresponding to the data table design information generation request according to the second prompt information and the initial data table design information, and displays the target data table design information.

[0009] According to another aspect of the present application, a data table design information generation apparatus is provided, comprising:

[0010] The acquisition module is configured to acquire the first prompt information and the second prompt information in response to a data table design request, wherein the first prompt information comprises requirement description information of the data table, and the second prompt information is used for prompting that the data table design model needs to generate the data table in the role of a data architecture designer according to a preset process.

[0011] The initial data table design information determination module is configured to provide the first prompt information and the second prompt information to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information and a target knowledge base associated with the data table design model, and the target knowledge base is used for storing at least one sample data table.

[0012] The data table design information determination module is configured to provide the second prompt information and the initial data table design information to the data table design model, so that the data table design model generates target data table design information corresponding to the generation request of the data table design information according to the second prompt information and the initial data table design information, and displays the target data table design information.

[0013] According to another aspect of the present application, an electronic device is provided, which comprises:

[0014] at least one processor; and

[0015] a memory connected with the at least one processor in communication; wherein,

[0016] the memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor to enable the at least one processor to execute the data table design information generation method according to any one of the embodiments of the present application.

[0017] According to another aspect of the present application, a computer readable storage medium is provided, which stores computer instructions for enabling a processor to implement the data table design information generation method according to any one of the embodiments of the present application when executed by the processor.

[0018] The technical scheme of the embodiment of the present application, by responding to the data table design request, obtaining the first prompt information and the second prompt information, the first prompt information includes the demand description information of the data table, the second prompt information is used to prompt the data table design model to generate the data table in the role of the data architecture designer according to the preset process, the technical role process and the demand are clear, the design professional of the data table, the standard and the consistency with the architecture are improved; the first prompt information and the second prompt information are provided to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information and the target knowledge base associated with the data table design model, the target knowledge base is used to store at least one sample data table, and the demand, the standard and the historical sample are fused, the accuracy and the professional of the initial table design are improved; the second prompt information and the initial data table design information are provided to the data table design model, so that the data table design model generates target data table design information corresponding to the generation request of the data table design information according to the second prompt information and the initial data table design information, and displays the target data table design information, combines the process constraint and the initial design iteration optimization, outputs the accurate and available design and intuitively displays, solves the problems that the intelligent generation of the data table lacks the technical role process guidance, the sample reference and the iteration optimization in the related art, the design is inconsistent with the architecture and the quality is low, realizes the role process guidance, the sample experience reuse and the iteration optimization, outputs the standard and accurate data table design, and improves the quality and the efficiency.

[0019] It should be understood that the content described in this part is not intended to identify the key or important features of the embodiments of the present application, nor is it intended to limit the scope of the present application. Other features of the present application will become apparent from the following description. BRIEF DESCRIPTION OF DRAWINGS

[0020] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the following will briefly introduce the drawings needed in the embodiment description. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can also be obtained by those skilled in the art without creative labor.

[0021] Figure 1 It is a flow chart of a data table design information generation method provided by the first embodiment of the present application;

[0022] Figure 2 It is a flow chart of a data table design information generation method provided by the second embodiment of the present application;

[0023] Figure 3 It is a structural schematic diagram of a data table design information generation device provided by the third embodiment of the present application;

[0024] Figure 4 FIG. 1 is a structural schematic diagram of an electronic device for implementing a data table design information generation method according to an embodiment of the present application. DETAILED DESCRIPTION

[0025] In order to make the personnel in the technical field better understand the present application scheme, the technical scheme in the embodiment of the present application will be described clearly and completely below in combination with the drawings in the embodiment of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, not all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by the person skilled in the art without creative labor should belong to the scope of protection of the present application.

[0026] It should be noted that the terms "first", "second" and the like in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and do not necessarily indicate a specific order or a chronological sequence. It should be understood that the data thus used can be interchanged under appropriate circumstances, so that the embodiments of the present application described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "include" and "have" and any variations thereof are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device including a series of steps or units does not necessarily have to be limited to those steps or units clearly listed, but can include other steps or units not clearly listed or inherent to these processes, methods, products or devices.

[0027] It should be noted that the modification of "one" or "multiple" mentioned in the present disclosure is illustrative but not restrictive, and those skilled in the art should understand that unless otherwise explicitly indicated in the context, it should be understood as "one or more".

[0028] The names of the messages or information exchanged between the plurality of devices in the embodiments of the present disclosure are only for illustrative purposes, and are not intended to limit the scope of the messages or information.

[0029] It can be understood that before using the technical solutions disclosed in the embodiments of the present disclosure, the type, use range, use scenario and the like of the personal information involved in the present disclosure should be informed to the user and the authorization of the user should be obtained in accordance with relevant laws and regulations.

[0030] For example, in response to receiving an active request of a user, prompt information is sent to the user to explicitly prompt the user that the operation requested to be performed will require obtaining and using personal information of the user. Thus, the user can autonomously select whether to provide personal information to the software or hardware, such as an electronic device, an application program, a server, or a storage medium, etc. that performs the operation of the technical solution of the present disclosure according to the prompt information.

[0031] As an optional but non-limiting implementation manner, in response to receiving an active request of a user, the manner of sending prompt information to the user may, for example, be a pop-up window manner, in which the prompt information can be presented in a text manner. In addition, the pop-up window can also carry selection controls for the user to select “agree” or “disagree” to provide personal information to the electronic device.

[0032] It can be understood that the above notification and obtaining user authorization process is only illustrative and does not limit the implementation manner of the present disclosure, and other manners meeting relevant laws and regulations can also be applied to the implementation manner of the present disclosure.

[0033] It can be understood that the data (including but not limited to the data itself, the obtaining or use of the data) involved in the technical solution should comply with the requirements of relevant laws and regulations and relevant provisions.

[0034] Embodiment one

[0035] Figure 1 A flowchart of a data table design information generation method is provided for the embodiment one of the present disclosure. The present embodiment can be applicable to a complex business requiring high-quality and standardized data table design. The method can be executed by a data table design information generation device, which can be realized in the form of hardware and / or software. Optionally, the data table design information generation device can be realized by an electronic device, which can be a mobile terminal, a PC terminal, or a server, etc.

[0036] As shown in Figure 1 , the method can specifically include:

[0037] S110, in response to a data table design request, obtaining first prompt information and second prompt information, the first prompt information including demand description information of the data table, and the second prompt information being used to prompt that a data table design model needs to be generated as a data architecture designer according to a preset process.

[0038] The data table design request can be understood as an explicit instruction or requirement input initiated by a user or a system, which requires the generation of a data table meeting specific needs, and is the trigger starting point of the entire process, driving subsequent operations such as obtaining prompt information, calling a data table design model, etc. The first prompt information can be understood as a textual description of the specific requirements of the data table, which is used to clearly define the business or functional requirements that the data table needs to meet, provides the core requirement input for the data table design model, ensures that the initial design information generated by the model fits the actual business scenario of the user, and avoids deviation from the target. The requirement description information can be understood as a textual expression of the specific requirements, constraints and business goals of the data table required by the user or the system, including but not limited to field type, association relationship, constraint condition, etc. The second prompt information can be understood as a prompt content for guiding the role positioning and execution process of the data table design model, which requires it to act as a "data architecture designer" to generate a data table, standardize the behavior logic and output path of the model, ensure the professional and controllable nature of the design process, and avoid random or non-standard output. The second prompt information includes at least one of role setting description information, design target description information, design specification description information, model thinking chain description information, and data table check description information, etc. The role setting description information can be understood as a description content for clearly defining the specific identity or perspective that the data table design model needs to play, which restricts the behavior logic of the model by setting the role, makes it analyze the problem from the perspective of the specified role (such as "data architecture designer" needs to focus on data standardization, scalability, and cross-system integration), ensures that the design process conforms to the professional methodology of the role, and avoids the model generating a one-sided solution based on general logic. The design target description information can be understood as a textual description of the core purpose, business use or expected effect of the data table to be generated, which provides a clear direction for the model and avoids deviation from the core value during the design process. The design specification description information can be understood as a set of standards, rules or constraints that the data table design needs to follow, including but not limited to field naming specification (such as "user ID is unified as user_id"), data type limitation, constraint condition, etc., which eliminates the randomness of the design by standardizing the rules and ensures the consistency and maintainability of the output. The model thinking chain description information can be understood as a step-by-step explanation for guiding the data table design model to perform logical reasoning and problem decomposition, which forces the model to process requirements according to a structured process and avoids jumping or randomly generating designs. The data table check description information can be understood as a verification item or quality evaluation standard that needs to be performed after the data table design is completed, such as "check if the fields cover all the attributes described in the requirement description", "verify if the primary key is unique and non-empty", "evaluate if the index can optimize high-frequency queries", "confirm if the foreign key constraint is consistent with the business rules", etc. The model is driven to perform self-checking or iterative optimization on the initial design information by clearly defining the check items, ensuring that the output meets the quality requirements.The data table design model can be understood as an intelligent system constructed based on algorithms or rules, which can generate or optimize data table design schemes according to input prompt information and knowledge base content. As a core processing unit, it integrates the first prompt information, the second prompt information and the associated knowledge base, completes the conversion from demand to design, and outputs the available data table design result. The data architecture designer can be understood as a professional role responsible for designing the overall structure of the database. The second prompt information requires the model to "play" this role to ensure that the output is professional, scalable and consistent. The preset process can be understood as a pre-defined sequence of data table design steps (such as "demand analysis, knowledge base retrieval, initial design generation, verification and optimization", etc.). It is specified by the second prompt information and is a constraint on the execution order and methodology of the data table design model, ensuring that the design process is systematic and standardized.

[0039] S120, providing the first prompt information and the second prompt information to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information and the target knowledge base associated with the data table design model, the target knowledge base being used to store at least one sample data table.

[0040] The target knowledge base can be understood as a database or knowledge collection that stores at least one sample data table. Sample data tables usually contain verified design patterns, field specifications, and association relationships, providing a reference for the data table design model. The initial data table design information can be understood as the preliminary design scheme generated by the data table design model based on the first prompt information (demand), the second prompt information (process) and the target knowledge base (sample) for the first time. It is a "draft" of the design process and may contain basic fields and simple association relationships, but needs further verification or optimization. The sample data table can be understood as a specific data example stored in the target knowledge base, which usually corresponds to a table structure that has been implemented or verified in a real business scenario. As a "best practice" template, it provides specific references such as field definitions, primary / foreign key designs, and index strategies to assist in generating initial designs that meet industry or enterprise standards.

[0041] S130, providing the second prompt information and the initial data table design information to the data table design model, so that the data table design model generates target data table design information corresponding to the generation request of the data table design information according to the second prompt information and the initial data table design information, and displays the target data table design information.

[0042] The generation request can be understood as a request for generating final available data table design information, and the demand description of the first prompt information constitutes the task target of the model. The target data table design information can be understood as a mature data table design scheme that meets all requirements after the data table design model is processed in the second stage (combined with the second prompt information and the initial design information), which is the final output of the process and directly meets the functional and normative requirements of the user on the data table.

[0043] On the basis of the above scheme, optionally, the first prompt information and the second prompt information are provided to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information and the target knowledge base associated with the data table design model. The method comprises: providing the first prompt information and the second prompt information to the data table design model, so that the data table design model determines the data table design features according to the first prompt information and the second prompt information, determines the reference data table from the plurality of sample data tables associated with the target knowledge base according to the data table design features, and generates the initial data table design information according to the first prompt information, the second prompt information and the reference data table.

[0044] The data table design features can be understood as key design attributes or dimensions extracted by the data table design model based on the first prompt information and the second prompt information, which are used to describe the core features of the current data table design and serve as a "bridge" connecting the demand and the knowledge base. The design features convert abstract requirements (such as "supporting fast query of user orders") into quantifiable labels, helping the model accurately locate the matching sample data table in the target knowledge base. The reference data table can be understood as one or more sample tables that match the current demand and are filtered from the plurality of sample data tables in the target knowledge base according to the data table design features, which are the core reference objects of the initial design and need to be highly consistent with the current demand in design features. The reference range can be narrowed through accurate matching to avoid interference of irrelevant samples on the model.

[0045] By fusing user requirements and design specifications to extract structured data table design features, and intelligently matching the most relevant reference table from the sample data tables in the target knowledge base based on these features, the rationality, completeness and normativity of the initial data table design are significantly improved, the cost of manual repeated design is reduced, the defects caused by insufficient experience in table building are avoided, and a solid foundation is laid for subsequent high-quality database construction.

[0046] The technical scheme of the embodiment of the present application acquires first prompt information and second prompt information in response to a data table design request, the first prompt information includes demand description information for the data table, and the second prompt information is used to prompt that a data table design model needs to generate a data table in the role of a data architecture designer according to a preset process, to clearly define the technical role process and the demand, and to improve the professional nature, the standardization and the consistency with the architecture of the data table design; the first prompt information and the second prompt information are provided to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information and a target knowledge base associated with the data table design model, the target knowledge base is used to store at least one sample data table, to integrate the demand, the standard and the historical sample, and to improve the accuracy and the professional nature of the initial table design; the second prompt information and the initial data table design information are provided to the data table design model, so that the data table design model generates target data table design information corresponding to a generation request of the data table design information according to the second prompt information and the initial data table design information, and displays the target data table design information, to combine the process constraint and the initial design iterative optimization, to output the accurate and usable design and to intuitively display, to solve the problems of lack of technical role process guidance, sample reference and iterative optimization in intelligent generation of a data table in the related art, to cause the design to be inconsistent with the architecture and low in quality, to realize the role process guidance, the sample experience reuse and the iterative optimization, to output the standard and accurate data table design, and to improve the quality and the efficiency.

[0047] Embodiment two

[0048] Figure 2 A flowchart of a data table design information generation method provided by the second embodiment of the present application, the present embodiment is further refined on the basis of the above-mentioned embodiments. Optionally, the first prompt information is acquired, including: acquiring original prompt information input through a preset interactive control in a preset interactive interface, the original prompt information is used to describe the expectation of the presentation information of the data table design information to be generated; the data table design model is provided with the original prompt information, so that the data table design model determines the first prompt information according to the original prompt information. The specific embodiment can be referred to the description of the present embodiment. Wherein, the same or similar technical features as the foregoing embodiments are not described herein.

[0049] As Figure 2 shown, the method can specifically include:

[0050] S210, in response to a data table design request, acquiring original prompt information input through a preset interactive control in a preset interactive interface, the original prompt information is used to describe the expectation of the presentation information of the data table design information to be generated.

[0051] The preset interaction interface can be understood as a pre-designed and configured human-computer interaction operation interface (such as a web form, a desktop application window, a mobile APP page, etc.), which is used for information input, instruction transmission or result viewing between the user and the system, and serves as a "communication medium" between the user and the system. The preset interaction interface reduces the threshold of user input (such as replacing code input with visual controls), and at the same time, restricts the input form (such as mandatory fields and option restrictions), so as to avoid information parsing errors caused by user input format confusion. The preset interaction control can be understood as a pre-configured operable component in the preset interaction interface, which is used for receiving user input or selecting specific content. The user can be guided to provide information in the format required by the system through a structured control, to ensure the parsability and integrity of the input content. The original prompt information can be understood as specific content directly input or selected through the preset interaction control in the preset interaction interface, which is used to describe the expected "presentation information" of the "to-be-generated data table design information", and is the original input carrier of the user demand, which directly reflects the user's expectation of the "presentation form" or "display effect" of the data table design result. The presentation information can be understood as the form or specific requirement of the data table design information (such as table structure, field definition, etc.) when it is displayed, including but not limited to display format, content emphasis, interaction mode, etc.

[0052] S220, providing the original prompt information to the data table design model, so that the data table design model determines the first prompt information according to the original prompt information, and obtains the second prompt information.

[0053] On the basis of the above scheme, optionally, the step of providing the original prompt information to the data table design model so that the data table design model determines the first prompt information according to the original prompt information comprises: providing the original prompt information to the data table design model so that the data table design model determines a target demand description template from a preset demand description template associated with the data table design model according to the original prompt information, and displays the target demand description template; receiving an editing operation on the target demand description template, generating an initial demand description file based on the editing operation and the target demand description template, and determining the first prompt information according to the initial demand description file.

[0054] The preset requirement description template can be understood as a structured requirement description framework pre-associated and stored by the data table design model, which is organized by fixed fields, classifications or logical structures, etc. The template has multiple templates for standardizing the expression of user requirements for data tables. The template itself does not contain specific content, but defines the format specification of "which dimensions should the requirement contain". The preset requirement description template includes but is not limited to a workflow scenario table design template (applicable to a workflow scenario, used for approval, work order and other process-driven businesses), a simple scenario table design template (applicable to simple data management without process and attachment, such as log recording) and a complex scenario table design template (applicable to complex functions such as workflow, attachment and permission management). The target requirement description template can be understood as a template that is most suitable for the current requirement matched from the preset requirement description template set by the data table design model according to the original prompt information provided by the user, so as to narrow the range of user editing and improve the efficiency of requirement input. The editing operation can be understood as an interactive behavior of the user for modifying, supplementing or confirming the blank fields, pre-filled contents or options in the template after viewing the target requirement description template. The initial requirement description file can be understood as a file or data structure containing specific requirement contents generated by the user after completing the editing operation of the target requirement description template.

[0055] By intelligently matching the original prompt information input by the user to the preset requirement description template, generating a structured target requirement description template and supporting interactive editing of the user, the technical solution effectively guides the user to express complete and clear table building requirements, not only reduces the requirement description threshold of non-professional users, but also improves the standardization and analyzability of requirement information, thereby providing reliable input for subsequent accurate generation of high-quality data table design, and significantly enhancing the efficiency of human-computer collaboration and the business fit of design results.

[0056] On the basis of the above-mentioned solution, optionally, the first prompt information is determined according to the initial requirement description file, including: providing the initial requirement description file to the data table design information generation module, so that the data table design information generation module detects the content of the initial requirement description file; in the case that the detection result is not passed, generating content adjustment information corresponding to the initial requirement description file through the data table design information generation module, and displaying the content adjustment information; in response to receiving the supplementary description information for the initial requirement description file, providing the supplementary description information to the data table design model, so that the data table design model determines the first prompt information according to the supplementary description information and the initial requirement description file.

[0057] The content detection can be understood as a systematic checking process of the data table design information generation module on the initial requirement description file, and is mainly used for detecting at least one of whether the initial requirement description file includes a preset type of content and whether the expression intention of the content in the initial requirement description file is clear, filtering incomplete or ambiguous requirements through content detection, and ensuring that the first prompt information generated subsequently has completeness and analyzability. The content adjustment information can be understood as an adjustment suggestion generated by the data table design information generation module after detecting that the initial requirement description file does not pass, which is used to indicate the content that needs to be adjusted in the initial requirement description file, provide an operable improvement direction for the user, and reduce the difficulty of the user supplementing requirements. The supplement description information can be understood as specific description supplemented by the user for the content that needs to be adjusted after receiving the content adjustment information, which can be in the form of text input, option selection or modification of existing content, repairing defects of the initial requirement description file, meeting the passing condition of content detection, and providing a basis for generating accurate first prompt information.

[0058] By introducing the content detection and feedback correction mechanism, the initial requirement description file is checked for completeness and clarity, missing or ambiguous content is automatically identified, and targeted adjustment suggestions are generated. After the user supplements the information, the original and supplemented content are fused to generate high-quality first prompt information, effectively avoiding design deviation caused by unclear requirements, improving the accuracy, robustness and business adaptation ability of the data table generation, and realizing reliable alignment between requirement expression and professional modeling.

[0059] On the basis of the above-mentioned scheme, optionally, the data table design model is provided with the original prompt information, so that the data table design model determines a target requirement description template from a preset requirement description template associated with the data table design model according to the original prompt information, comprising: providing the data table design model with the original prompt information, so that the data table design model determines a target application scenario of the data table to be designed according to the original prompt information, and determines a target requirement description template from a preset requirement description template associated with the data table design model according to the target application scenario.

[0060] The target application scenario can be understood as a business or technical scenario in which the data table to be designed is actually applied, which is determined by the data table design model according to the original prompt information, and serves as a "bridge" connecting the original prompt information and the requirement description template. The target application scenario determines which type of template is most suitable for the current requirement.

[0061] The technical scheme is adopted, the business semantics in the original prompt information is recognized, the target application scene of the to-be-designed data table is determined, and the most suitable preset demand description template is accurately matched according to the target application scene, the pertinence and the structured degree of demand guidance are effectively improved, the expression threshold of the user is reduced, and an accurate demand basis is laid for subsequent high-quality table building.

[0062] On the basis of the above scheme, optionally, the first prompt information is determined according to the initial demand description file, including: providing the data table design model with the original prompt information and the initial demand description file, so that the data table design model updates at least part of the content of the initial demand description file according to the original prompt information to obtain a target demand description file, and determines the first prompt information according to the target demand description file.

[0063] The update can be understood as an operation of adjusting part or all of the content of the initial demand description file according to the original prompt information, including but not limited to supplementing part of the demand description information, correcting contradictory expressions (such as the original prompt requiring "field name in all lowercase", but the initial file uses uppercase), and clarifying ambiguous descriptions (such as the original prompt mentioning "fast query", and the model refines it to "support 1000 queries per second"). The target demand description file can be understood as a final version of the demand description document generated after the data table design model updates the initial demand description file, which retains the structured framework of the initial file, and through the supplement and correction of the original prompt information, the completeness and unambiguity directly determine the correctness and usability of subsequent data table design.

[0064] The technical scheme is adopted, the initial demand description file is intelligently updated by combining the original prompt information, the semantic details that may be missed or weakened in the editing process are made up, a more complete and accurate target demand description file is generated, the business fitting degree and the expression integrity of the first prompt information are improved, and a reliable basis is provided for high-quality data table design.

[0065] On the basis of the above scheme, optionally, the first prompt information is determined according to the initial demand description file, including: providing the data table design model with the original prompt information and the initial demand description file, so that the data table design model updates at least part of the content of the initial demand description file according to the original prompt information to obtain a target demand description file, and determines the first prompt information according to the target demand description file.

[0066] The requirement adjustment information can be understood as a guiding suggestion generated by the data table design model according to the original prompt information, which is used to clearly indicate the missing, ambiguous or contradictory content in the original prompt information, provide an operable improvement direction for the user, and reduce the difficulty of the user to supplement the requirement. The supplement description information can be understood as a specific description (such as adding a core field definition, clarifying a relationship, and correcting a contradictory expression) supplemented by the user for the missing, ambiguous or contradictory content in the original prompt after receiving the requirement adjustment information, which repairs the defects of the original prompt information, and makes it more complete and clear to reflect the user requirement.

[0067] An optional implementation is that after the sql information is output, the user can use the optimization design instruction to perform sql optimization on a single table. The sql statement can be adjusted according to the user requirement, the database design specification to be followed in the design and the database design specification customized by the user, and the existing sql optimization data table design is combined to check the specification again, so as to ensure that the generated data table design follows the database design specification.

[0068] By updating the initial requirement description file by combining the original prompt information, the technical solution can make up for the semantic details that may be omitted or weakened in the editing process, generate a more complete and accurate target requirement description file, thereby improving the business fitting degree and expression integrity of the first prompt information, and providing a reliable basis for high-quality data table design.

[0069] On the basis of the above scheme, optionally, the preset interactive control includes at least one of an information input control and a file upload control; the first prompt information is obtained by at least one of the following: receiving the original prompt information input through the information input control in the preset interactive interface, providing the original prompt information to the data table design model, so that the data table design model determines the first prompt information according to the original prompt information; receiving the uploaded original requirement description document through the file upload control in the preset interactive interface, providing the original requirement description document to the data table design model, so that the data table design model determines the first prompt information according to the original requirement description document.

[0070] The information input control can be understood as a component in the preset interactive control for directly inputting or recording information, supporting a user to provide original prompt information through manual input or voice recording, including but not limited to at least one of a text input control and an audio input control, covering input forms such as text and voice. The text input control can be understood as a component in the information input control specially for inputting text content, supporting a user to input text, symbols or formatted content through a keyboard. The audio input control can be understood as a component (such as a microphone button, a voice input box) in the information input control supporting voice recording, which can convert a user's spoken description into text and can support real-time recording or uploading of an audio file. The file uploading control can be understood as a component in the preset interactive control allowing a user to upload a locally stored document (such as Word, PDF, TXT, etc.), which is used to submit an already arranged original requirement description document, meets the scenario of a user submitting a structured or long text requirement, and avoids the tediousness of inputting word by word through the information input control.

[0071] According to the technical solution, user requirements can be flexibly obtained through the information input control or the file uploading control, real-time input of natural language description is allowed, and uploading of a structured document is also supported, different user habits and scene requirements are considered, a model generates first prompt information according to unified analysis, convenience, compatibility and expression integrity of requirement collection are improved, and diversified input guarantee is provided for subsequent high-quality data table design.

[0072] S230, providing the first prompt information and the second prompt information to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information and a target knowledge base associated with the data table design model, and the target knowledge base is used to store at least one sample data table.

[0073] S240, providing the second prompt information and the initial data table design information to the data table design model, so that the data table design model generates target data table design information corresponding to the generation request of the data table design information according to the second prompt information and the initial data table design information, and displays the target data table design information.

[0074] The technical scheme of the embodiment of the present application guides the user to input the original prompt information through the interaction control in the preset interaction interface, explicitly expresses the expectation of the user on the target data table design information in terms of content composition, structure organization or display form (such as field range, annotation requirement, grouping logic, etc.), so that the data table design model can not only understand the user demand, but also on this basis, the model can convert the presentation intention of the user into structured and executable first prompt information, effectively improves the business fitting degree and user experience of the subsequently generated data table, at the same time, the interactive input reduces the use threshold of non-technical personnel, enhances the accuracy and integrity of the requirement expression, and lays a solid foundation for realizing high-quality and high-usable automatic database design.

[0075] Embodiment three

[0076] Figure 3 A structural schematic diagram of a data table design information generation device provided by the third embodiment of the present application is shown in FIG. 3. As shown in the figure, the device comprises an acquisition module 310, an initial data table design information determination module 320 and a data table design information determination module 330. Among them, Figure 3

[0077] The acquisition module 310 is configured to acquire first prompt information and second prompt information in response to a data table design request, wherein the first prompt information comprises requirement description information of the data table, and the second prompt information is used to prompt the data table design model to generate the data table in the role of a data architecture designer according to a preset process; the initial data table design information determination module 320 is configured to provide the first prompt information and the second prompt information to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information and a target knowledge base associated with the data table design model, wherein the target knowledge base is used to store at least one sample data table; and the data table design information determination module 330 is configured to provide the second prompt information and the initial data table design information to the data table design model, so that the data table design model generates target data table design information corresponding to the generation request of the data table design information according to the second prompt information and the initial data table design information, and displays the target data table design information.

[0078] ​The technical scheme of the embodiment of the present application, in response to a data table design request, the acquisition module acquires first prompt information and second prompt information, the first prompt information includes demand description information of the data table, and the second prompt information is used to prompt that the data table design model needs to generate the data table in the role of a data architecture designer according to a preset process, to clarify the technical role process and the demand, and to improve the professional nature, the standardization and the consistency with the architecture of the data table design; the initial data table design information determination module provides the first prompt information and the second prompt information to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information and a target knowledge base associated with the data table design model, the target knowledge base is used to store at least one sample data table, to integrate the demand, the standard and the historical sample, and to improve the accuracy and the professional nature of the initial table design; the data table design information determination module provides the second prompt information and the initial data table design information to the data table design model, so that the data table design model generates target data table design information corresponding to the generation request of the data table design information according to the second prompt information and the initial data table design information, and displays the target data table design information, combines the process constraint and the initial design iterative optimization, outputs the accurate and available design and intuitively displays, solves the problems of lack of technical role process guidance, sample reference and iterative optimization in intelligent generation of a data table in the related art, causes the design to be inconsistent with the architecture and low in quality, realizes the role process guidance, the sample experience reuse and the iterative optimization, outputs the standard and accurate data table design, and improves the quality and the efficiency.

[0079] On the basis of the above scheme, optionally, the acquisition module includes an original prompt information acquisition submodule and a first prompt information determination submodule. The original prompt information acquisition submodule is configured to acquire original prompt information input through a preset interactive control in a preset interactive interface, the original prompt information being used to describe an expectation of presentation information of to-be-generated data table design information. The first prompt information determination submodule is configured to provide the original prompt information to the data table design model, so that the data table design model determines first prompt information according to the original prompt information.

[0080] Based on the above scheme, optionally, the first prompt information determination sub-module comprises a target requirement description template determination unit and a first prompt information determination unit. The target requirement description template determination unit is configured to provide the original prompt information to the data table design model, so that the data table design model determines a target requirement description template from preset requirement description templates associated with the data table design model according to the original prompt information, and displays the target requirement description template. The first prompt information determination unit is configured to receive an editing operation on the target requirement description template, generate an initial requirement description file based on the editing operation and the target requirement description template, and determine the first prompt information according to the initial requirement description file.

[0081] Based on the above scheme, optionally, the first prompt information determination unit comprises a content detection sub-unit, a content adjustment information generation sub-unit and a first prompt information determination unit. The content detection sub-unit is configured to provide the initial requirement description file to the data table design information generation module, so that the data table design information generation module performs content detection on the initial requirement description file. The content detection is at least one of detecting whether the initial requirement description file includes a preset type of content and whether the expression intention of the content in the initial requirement description file is clear. The content adjustment information generation sub-unit is configured to generate content adjustment information corresponding to the initial requirement description file by the data table design information generation module in the case that the detection result is failed, and display the content adjustment information. The content adjustment information is used to indicate the content in the initial requirement description file that needs to be adjusted. The first prompt information determination unit is configured to provide the supplementary description information to the data table design model in response to receiving the supplementary description information of the initial requirement description file, so that the data table design model determines the first prompt information according to the supplementary description information and the initial requirement description file.

[0082] Based on the above scheme, optionally, the target requirement description template determination unit is specifically configured to provide the original prompt information to the data table design model, so that the data table design model determines a target application scenario of a data table to be designed according to the original prompt information, and determines a target requirement description template from preset requirement description templates associated with the data table design model according to the target application scenario.

[0083] On the basis of the above-mentioned scheme, optionally, the first prompt information determination unit is further configured to provide the original prompt information and an initial requirement description file to the data table design model, so that the data table design model updates at least part of content of the initial requirement description file according to the original prompt information to obtain a target requirement description file, and determines the first prompt information according to the target requirement description file.

[0084] On the basis of the above-mentioned scheme, optionally, the first prompt information determination sub-module comprises a requirement adjustment information determination unit and a first prompt information generation unit. The requirement adjustment information determination unit is configured to provide the original prompt information to the data table design model, so that the data table design model generates requirement adjustment information according to the original prompt information and displays the requirement adjustment information. The first prompt information generation unit is configured to provide the supplementary description information to the data table design model in response to receiving the supplementary description information for the original prompt information, so that the data table design model determines the first prompt information according to the supplementary description information and an initial requirement description file.

[0085] On the basis of the above-mentioned scheme, optionally, the preset interactive control comprises at least one of an information input control and a file upload control. The information input control comprises at least one of a text input control and an audio input control. The data table design information generation apparatus further comprises a second acquisition module. The second acquisition module is configured to at least one of: receive the original prompt information input through the information input control in the preset interactive interface, provide the original prompt information to the data table design model, so that the data table design model determines the first prompt information according to the original prompt information; and receive the original requirement description document uploaded through the file upload control in the preset interactive interface, provide the original requirement description document to the data table design model, so that the data table design model determines the first prompt information according to the original requirement description document.

[0086] On the basis of the above-mentioned scheme, optionally, the initial data table design information determination module is specifically configured to provide the first prompt information and the second prompt information to the data table design model, so that the data table design model determines data table design features according to the first prompt information and the second prompt information, determines a reference data table from a plurality of sample data tables in a target knowledge base associated with the data table design model according to the data table design features, and generates initial data table design information according to the first prompt information, the second prompt information and the reference data table.

[0087] Optionally, the second prompt information comprises at least one of role setting description information, design target description information, design specification description information, model thinking chain description information, and data table check description information.

[0088] The data table design information generation apparatus provided by the embodiment of the present application can execute the data table design information generation method provided by any of the embodiments of the present application, and has the function modules and advantages corresponding to the execution method.

[0089] Embodiment Four

[0090] Figure 4 A structural schematic diagram of an electronic device 10 that can be used to implement embodiments of the present application is shown. The electronic device is intended to represent various forms of digital computers, such as laptops, desktops, tablets, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device can also represent various forms of mobile devices, such as personal digital processors, cellular telephones, smart phones, wearable devices (e.g., headsets, glasses, watches, etc.), and other similar computing devices. The components shown here, their connections and relationships, and their functions, are meant to be examples only, and are not intended to limit the implementations of the present application described and / or claimed in this document.

[0091] As shown in Figure 4 The electronic device 10 includes at least one processor 11, and a memory, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., which is communicatively connected to the at least one processor 11, wherein the memory stores a computer program that can be executed by the at least one processor. The processor 11 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 into the random access memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0092] A plurality of components in the electronic device 10 are connected to the I / O interface 15, including: an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, a speaker, etc.; a storage unit 18, such as a magnetic disk, an optical disk, etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices through a computer network, such as the Internet, and / or various telecommunications networks.

[0093] The processor 11 can be various general and / or special purpose processing components with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special-purpose artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 11 performs various methods and processes described above, such as a method of generating data table design information.

[0094] In particular, the processes described above with reference to the flowcharts can be implemented as a computer software program according to embodiments of the present application. For example, embodiments of the present application include a computer program product comprising a computer program carried on a non-transitory computer-readable medium, the computer program containing program code for performing the methods illustrated by the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network by the communication unit 19, or installed from the storage unit 18, or installed from the ROM 12. When the computer program is executed by the processor 11, the above-described functions defined in the methods of embodiments of the present application are performed.

[0095] In some embodiments, a method of generating data table design information can be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as the storage unit 18. In some embodiments, part or all of the computer program can be loaded and / or installed onto the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded onto the RAM 13 and executed by the processor 11, one or more steps of a method of generating data table design information described above can be performed. Alternatively, in other embodiments, the processor 11 can be configured to perform a method of generating data table design information by any other appropriate means, such as by means of firmware.

[0096] The various embodiments of the systems and techniques described above can be implemented in digital electronic circuitry, integrated circuitry, a field programmable gate array (FPGA), an application specific integrated circuit (ASIC), a system on a chip (SOC), a complex programmable logic device (CPLD), computer hardware, firmware, software, and / or combinations thereof. These various embodiments can include implementation in one or more computer programs that are executable and / or interpretable on a programmable system including at least one programmable processor, which can be special or general purpose, coupled to receive data and instructions from, and to transmit data and instructions to, a storage system, at least one input device, and at least one output device.

[0097] Computer programs used to implement the processes of the application can be written in any combination of one or more programming languages. These computer programs can be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer program

[0098] In the context of the present application, a computer-readable storage medium can be a tangible medium that can contain or store computer programs for use by or in connection with an instruction execution system, apparatus, or device. Computer-readable storage media can include, but are not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium can be a machine-readable signal medium. More specific examples of the machine-readable storage medium will include one or more lines of a program of instructions in a transitory signal, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0099] To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user and a keyboard and a pointing device (e.g., a mouse or a trackball) by which the user can provide input to the electronic device. Other kinds of devices can be used to provide for interaction with a user as well; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form, including acoustic, speech, or tactile input.

[0100] The systems and techniques described here can be implemented in a computing system that includes a back end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front end component (e.g., a user computer having a graphical user interface or a Web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back end, middleware, or front end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0101] The computing system can include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. A server can be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system, to solve the defects of large management difficulty and weak business scalability in traditional physical host and VPS service.

[0102] It should be understood that the various forms of flow shown above can be re-ordered, added to, or deleted from without departing from the scope of the present disclosure. For example, the steps recited in the present disclosure can be executed in parallel, executed in sequence, or executed in a different order, as long as the desired results of the present disclosure are achieved, and the present disclosure is not limited herein.

[0103] The specific embodiments described above are not intended to be limiting, and persons skilled in the art will appreciate that various modifications, combinations, sub-combinations and alternatives can be made to the specific embodiments without departing from the spirit and principles of the disclosure. Accordingly, the disclosure is not limited to the specific embodiments described above, but only by the scope of the appended claims.

Claims

1. A method of generating data table design information, characterized by, The method comprises: in response to a data table design request, obtaining first prompt information and second prompt information, the first prompt information comprising requirement description information of a data table, and the second prompt information being used for prompting a data table design model to generate a data table in the role of a data architecture designer according to a preset process; providing the first prompt information and the second prompt information to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information, and a target knowledge base associated with the data table design model, the target knowledge base being used for storing at least one sample data table; providing the second prompt information and the initial data table design information to the data table design model, so that the data table design model generates target data table design information corresponding to the generation request of the data table design information according to the second prompt information and the initial data table design information, and displays the target data table design information.

2. The method of generating data sheet design information according to claim 1, wherein, The first prompt information is obtained by: obtaining original prompt information input through a preset interactive control in a preset interactive interface, the original prompt information being used for describing an expectation of presentation information of to-be-generated data table design information; providing the original prompt information to the data table design model, so that the data table design model determines the first prompt information according to the original prompt information.

3. The method of generating data sheet design information according to claim 2, wherein, The original prompt information is provided to the data table design model, so that the data table design model determines the first prompt information according to the original prompt information, comprising: providing the original prompt information to the data table design model, so that the data table design model determines a target requirement description template from a preset requirement description template associated with the data table design model according to the original prompt information, and displays the target requirement description template; receiving an editing operation on the target requirement description template, generating an initial requirement description file based on the editing operation and the target requirement description template, and determining the first prompt information according to the initial requirement description file.

4. The method of generating data sheet design information according to claim 3, wherein, The first prompt information is determined according to the initial requirement description file, comprising: providing the initial requirement description file to a data table design information generation module, so that the data table design information generation module performs content detection on the initial requirement description file, the content detection being used for at least one of detecting whether the initial requirement description file includes content of a preset type and detecting whether an expression intention of the content in the initial requirement description file is clear; in a case where the detection result is failed, generating content adjustment information corresponding to the initial requirement description file by the data table design information generation module, and displaying the content adjustment information, the content adjustment information being used for indicating content that needs to be adjusted in the initial requirement description file; in response to receiving supplementary description information for the initial requirement description file, providing the supplementary description information to the data table design model, so that the data table design model determines the first prompt information according to the supplementary description information and the initial requirement description file.

5. The method of generating data sheet design information according to claim 3, wherein, The original prompt information is provided to the data table design model, so that the data table design model determines a target requirement description template from preset requirement description templates associated with the data table design model according to the original prompt information. The original prompt information is provided to the data table design model, so that the data table design model determines a target application scenario of a data table to be designed according to the original prompt information, and determines a target requirement description template from preset requirement description templates associated with the data table design model according to the target application scenario.

6. The method of generating data sheet design information according to Claim 3, wherein, The first prompt information is determined according to the initial requirement description file, and includes: The original prompt information and the initial requirement description file are provided to the data table design model, so that the data table design model updates at least part of content of the initial requirement description file according to the original prompt information to obtain a target requirement description file, and determines the first prompt information according to the target requirement description file.

7. The method of generating data sheet design information according to Claim 2, wherein The original prompt information is provided to the data table design model, so that the data table design model determines the first prompt information according to the original prompt information, and includes: The original prompt information is provided to the data table design model, so that the data table design model generates requirement adjustment information according to the original prompt information, and displays the requirement adjustment information. In response to receiving supplementary description information for the original prompt information, the supplementary description information is provided to the data table design model, so that the data table design model determines the first prompt information according to the supplementary description information and an initial requirement description file.

8. The method of generating data sheet design information according to claim 2, wherein, The preset interactive control includes at least one of an information input control and a file upload control; the information input control includes at least one of a text input control and an audio input control; and the first prompt information is obtained by at least one of the following: The original prompt information input through the information input control in the preset interactive interface is provided to the data table design model, so that the data table design model determines the first prompt information according to the original prompt information. The original requirement description document uploaded through the file upload control in the preset interactive interface is provided to the data table design model, so that the data table design model determines the first prompt information according to the original requirement description document.

9. The method of generating data sheet design information according to Claim 1, wherein, The first prompt information and the second prompt information are provided to the data table design model, so that the data table design model generates initial data table design information according to the first prompt information, the second prompt information, and a target knowledge base associated with the data table design model, and includes: The first prompt information and the second prompt information are provided to the data table design model, so that the data table design model determines data table design features according to the first prompt information and the second prompt information, determines a reference data table from a plurality of sample data tables in a target knowledge base associated with the data table design model according to the data table design features, and generates initial data table design information according to the first prompt information, the second prompt information and the reference data table.

10. The method of generating data sheet design information according to Claim 1, wherein, The second prompt information includes at least one of role setting description information, design target description information, design specification description information, model thinking chain description information and data table checking description information.

Images