CN113760254A - Data model generation method and device, electronic equipment and computer readable medium - Google Patents

Data model generation method and device, electronic equipment and computer readable medium Download PDF

Info

Publication number
CN113760254A
CN113760254A CN202110038818.2A CN202110038818A CN113760254A CN 113760254 A CN113760254 A CN 113760254A CN 202110038818 A CN202110038818 A CN 202110038818A CN 113760254 A CN113760254 A CN 113760254A
Authority
CN
China
Prior art keywords
data
data model
data source
user
configuration information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202110038818.2A
Other languages
Chinese (zh)
Inventor
刘倩
贾广亮
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Jingdong Century Trading Co Ltd
Beijing Wodong Tianjun Information Technology Co Ltd
Original Assignee
Beijing Jingdong Century Trading Co Ltd
Beijing Wodong Tianjun Information Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Jingdong Century Trading Co Ltd, Beijing Wodong Tianjun Information Technology Co Ltd filed Critical Beijing Jingdong Century Trading Co Ltd
Priority to CN202110038818.2A priority Critical patent/CN113760254A/en
Publication of CN113760254A publication Critical patent/CN113760254A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/34Graphical or visual programming
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/211Schema design and management
    • G06F16/212Schema design and management with details for data modelling support
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The embodiment of the disclosure discloses a data model generation method, a data model generation device, electronic equipment and a computer readable medium. One embodiment of the method comprises: in response to the completion of the selection operation of a user for at least one data source control in the graphical interface, determining the number of data sources corresponding to the data source selection operation, wherein each data source control corresponds to one data source; configuring corresponding data model types for the graphical interface according to the number of the data sources; receiving data model configuration information input by a user in a graphical interface, wherein the data model configuration information is used for generating a target data table based on at least one data source; a data model is generated based on the at least one data source, the data model class, and the data model configuration information. The embodiment realizes the generation of the data model through a visual graphical interface.

Description

Data model generation method and device, electronic equipment and computer readable medium
Technical Field
Embodiments of the present disclosure relate to the field of computer technologies, and in particular, to a data model generation method, apparatus, electronic device, and computer-readable medium.
Background
Data models can be used to describe data, organize data, and manipulate data. In general, generation of the data model requires a developer to implement using some programming Language (e.g., Structured Query Language).
However, when the data model generation is performed in the above manner, there are often technical problems as follows: developers need to learn programming languages to manually develop data models, and the data models are high in learning cost and low in development efficiency.
Disclosure of Invention
This summary is provided to introduce a selection of concepts in a simplified form that are further described below in the detailed description. This summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used to limit the scope of the claimed subject matter. Some embodiments of the present disclosure propose data model generation methods, apparatuses, electronic devices and computer readable media to solve one or more of the technical problems mentioned in the background section above.
In a first aspect, some embodiments of the present disclosure provide a data model generation method, including: in response to the completion of the selection operation of a user for at least one data source control in the graphical interface, determining the number of data sources corresponding to the data source selection operation, wherein each data source control corresponds to one data source; configuring corresponding data model types for the graphical interface according to the number of the data sources; receiving data model configuration information input by a user in a graphical interface, wherein the data model configuration information is used for generating a target data table based on at least one data source; a data model is generated based on the at least one data source, the data model class, and the data model configuration information.
In a second aspect, some embodiments of the present disclosure provide an apparatus for generating a data model, the apparatus comprising: the determining unit is configured to respond to the completion of the selection operation of at least one data source control in the graphical interface by a user, and determine the number of data sources corresponding to the data source selection operation, wherein each data source control corresponds to one data source; the configuration unit is configured to configure corresponding data model types for the graphical interface according to the number of the data sources; the receiving unit is configured to receive data model configuration information input in a graphical interface by a user, and the data model configuration information is used for generating a target data table based on at least one data source; a generating unit configured to generate a data model based on at least one data source, a data model category, and data model configuration information.
In a third aspect, some embodiments of the present disclosure provide an electronic device, comprising: one or more processors; a storage device having one or more programs stored thereon, which when executed by one or more processors, cause the one or more processors to implement the method described in any of the implementations of the first aspect.
In a fourth aspect, some embodiments of the disclosure provide a computer readable medium having a computer program stored thereon, where the program when executed by a processor implements the method described in any of the implementations of the first aspect.
The above embodiments of the present disclosure have the following advantages: the data model generation can be realized through a visual graphical interface, and the threshold and the development cost of model development are reduced. In the process, different data model categories can be configured according to different data source numbers so as to adapt to different user requirements. In addition, the user is supported to input model configuration information in a graphical interface, and therefore personalized configuration of the model is achieved.
Drawings
The above and other features, advantages and aspects of various embodiments of the present disclosure will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic and that elements and elements are not necessarily drawn to scale.
FIG. 1 is a schematic illustration of one application scenario of a data model generation method according to some embodiments of the present disclosure;
FIG. 2 is a flow diagram of some embodiments of a data model generation method according to the present disclosure;
FIG. 3 is a flow diagram of further embodiments of a data model generation method according to the present disclosure;
FIG. 4 is a structural schematic diagram of some embodiments of a data model generation apparatus according to the present disclosure;
FIG. 5 is a structural schematic diagram of an electronic device suitable for use in implementing some embodiments of the present disclosure.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it is to be understood that the disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the disclosure are for illustration purposes only and are not intended to limit the scope of the disclosure.
It should be noted that, for convenience of description, only the relevant portions of the related invention are shown in the drawings. The embodiments and features of the embodiments in the present disclosure may be combined with each other without conflict.
It should be noted that the terms "first", "second", and the like in the present disclosure are only used for distinguishing different devices, modules or units, and are not used for limiting the order or interdependence of the functions performed by the devices, modules or units.
It is noted that references to "a", "an", and "the" modifications in this disclosure are intended to be illustrative rather than limiting, and that those skilled in the art will recognize that "one or more" may be used unless the context clearly dictates otherwise.
The names of messages or information exchanged between devices in the embodiments of the present disclosure are for illustrative purposes only, and are not intended to limit the scope of the messages or information.
The present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
FIG. 1 is a schematic diagram of one application scenario of a data model generation method according to some embodiments of the present disclosure.
As shown in FIG. 1, a user may select a desired data source control among a plurality of data source controls displayed in graphical interface 101. The graphical interface 101 may be a graphical interface of various clients, for example, a graphical interface of a personal computer. In the application scenario, 3 controls displayed in the image interface 101 are taken as an example, and are respectively a data source control 102, a data source control 103, and a data source control 104. Each data source control corresponds to a data source. As shown in fig. 1, the data source control 102 corresponds to the data source 1, the data source control 103 corresponds to the data source 2, and the data source control 104 corresponds to the data source 3. By way of example, the user may drag a desired data source control into region 105 to select the data source control. In the application scenario, for example, the user selects two data source controls, namely the data source control 102 and the data source control 104, which correspond to two data sources. On the basis, in response to the selection operation of the user, the execution main body (for example, the personal computer) of the data model generation method may determine the number of the data sources corresponding to the data source selection operation. Under the application scene, the user selects two data sources. Then, the execution body may configure the corresponding data model type for the image interface 101 according to the number of the data sources. Thereafter, data model configuration information entered by the user at graphical interface 101 may be received. For example, data source 1 may be user age information and data source 2 may be user preferred item category information. The user wants to get user preferred item category information between the ages of 20-30. At this time, the model configuration information may include a filtering condition for the age field in the data source, i.e., the age is between 20-30. In addition, the model configuration information may also include field logic between the two data sources, i.e., the data in the data source 2 is filtered according to the data in the filtered data source 1. As shown in fig. 1, represented as a line with an arrow that is pointed to by data source control 102 at data source control 104.
On this basis, the data model may be generated based on the data source 1 and the data source 104, the data model class, and the data model configuration information.
It should be noted that the execution subject for the data model generation method provided by the embodiment of the present disclosure may be hardware or software. When hardware, it may be various electronic devices with information processing capabilities, including but not limited to smart phones, tablet computers, e-book readers, laptop portable computers, desktop computers, and the like. When the execution subject is software, the software can be installed in the electronic device listed above. It may be implemented as multiple software or software modules, for example to provide distributed services, or as a single software or software module. And is not particularly limited herein.
With continued reference to FIG. 2, a flow 200 of some embodiments of a data model generation method according to the present disclosure is shown. The data model generation method comprises the following steps:
step 201, in response to the completion of the selection operation of the user for at least one data source control in the graphical interface, determining the number of data sources corresponding to the data source selection operation, where each data source control corresponds to one data source.
In some embodiments, the graphical interface may be a graphical interface of various clients, for example, a graphical interface of a personal computer or a smart phone. Wherein the graphical interface can be configured to include at least one data source control. The user can select the needed data source control by executing certain user operation on the data source controls. Because each data source control corresponds to one data source, a user can select the data source through the selection of the data source control. For example, the user may select a desired data source control by clicking, dragging, and the like. On this basis, an execution subject of the data model generation method (for example, a personal computer in the application scenario corresponding to fig. 1) may determine the number of data sources corresponding to the data source selection operation in response to the completion of the user selection operation. That is, the user has selected several data sources. In practice, the completion of the selection operation may be determined in a number of ways. For example, the user may click on a control that characterizes "pick complete," so that the execution body may determine that the user has finished picking.
Step 202, configuring a corresponding data model type for the graphical interface according to the number of the data sources.
In some embodiments, the execution subject may configure a corresponding data model category for the graphical interface according to the number of the data sources. As an example, the graphical interface may be configured in a single table category or a multi-table category depending on whether the number of data sources is one or two or more.
Step 203, receiving data model configuration information input by a user in the graphical interface, wherein the data model configuration information is used for generating a target data table based on at least one data source.
In some embodiments, the execution agent may receive data model configuration information input by a user in a graphical interface. Wherein the data model configuration information is used to generate a target data table based on at least one data source. By way of example, the data model configuration information may include, but is not limited to, at least one of: associations between data sources, association fields between data sources, filtering conditions for association fields, and the like. For example, the association relationship between the data sources may indicate whether to perform an aggregation operation on the two data sources. For example, for the data source a and the data source B, the data source B is screened according to the data corresponding to the field X in the data source a if necessary. Then there is an association between data source a and data source B and field X is the association field between data source a and data source B.
In some optional implementations of some embodiments, receiving data model configuration information input by a user in a graphical interface, the data model configuration information being used to generate a target data table based on at least one data source, includes: receiving an incidence relation between at least one data source and an incidence field between at least one data source, wherein the incidence relation between at least one data source is input by a user through adjusting a connection relation between at least one data source control; and generating a data model based on the at least one data source, the data model category, and the data model configuration information, including: and generating the data model based on the at least one data source, the data model class, the association relation between the at least one data source and the association field between the at least one data source.
In some optional implementations of some embodiments, receiving data model configuration information input by a user in a graphical interface, the data model configuration information being used to generate a target data table based on at least one data source, includes: and receiving field logic set by a user for each associated field, wherein the field logic is set by selecting a target aggregation function or inputting the target aggregation function from a plurality of preset aggregation functions by the user.
In some optional implementations of some embodiments, receiving data model configuration information input by a user in a graphical interface, the data model configuration information being used to generate a target data table based on at least one data source, includes: and receiving the filtering condition set by the user for each associated field. On this basis, the data in the associated field in the data source may be filtered by the filtering condition before the aggregation operation is performed.
Step 204, generating a data model based on the at least one data source, the data model category, and the data model configuration information.
In some embodiments, as an example, the execution subject may modify a pre-generated data model template file to generate the data model based on at least one data source and data model configuration information. In the process, the data model type can be checked to improve the correctness of the data model.
With further reference to FIG. 3, a flow 300 of further embodiments of a data model generation method is illustrated. The process 300 of the data model generation method includes the following steps:
step 301, in response to the completion of the selection operation of the user for at least one data source control in the graphical interface, determining the number of data sources corresponding to the data source selection operation, where each data source control corresponds to one data source.
And 302, configuring a corresponding data model type for the graphical interface according to the number of the data sources.
Step 303, receiving data model configuration information input by a user in the graphical interface, where the data model configuration information is used for generating a target data table based on at least one data source.
In some embodiments, the specific implementation of steps 301 and 303 and the technical effect thereof can refer to steps 201 and 203 in the embodiments corresponding to fig. 2, which are not described herein again.
Step 304, generating a target data definition language based on the at least one data source, the data model category and the data model configuration information, the target data definition language being used for characterizing the processing logic of the data model.
And 305, sending the target data definition language to a data processing end, wherein the data processing end is used for creating a target data table based on the target data definition language.
In some embodiments, the target data definition language may be a DDL statement. The data processing side is a platform for executing processing such as data storage and operation.
And step 306, receiving result information which is sent by the data processing terminal and used for representing whether the target data table is successfully created.
In some embodiments, the data processing side may create the target data table using the received DDL statement. If the creation is successful, result information for representing the successful creation of the target data table can be returned to the execution main body.
And 307, in response to the result information representation target data table is not successfully created, sending the target data definition language to the data processing terminal again. Therefore, the data processing end can recreate the target data table.
And 308, responding to the result information representation target data table successfully created, and uploading the script corresponding to the data model to the data processing terminal.
In some embodiments, the execution subject may generate a script corresponding to the data model by adjusting a program template, or the like. On the basis, the script can be uploaded to a data processing end.
And 309, responding to successful uploading of the script, uploading deployment scheduling related information to the data processing terminal, wherein the deployment scheduling related information is used for deployment scheduling of the data model.
In some embodiments, by way of example, deployment schedule-related information includes, but is not limited to, the following: the computing engine, life cycle, location information, task information, operation mechanism, early warning mechanism, etc. of the table.
As can be seen from fig. 3, compared with the description of some embodiments corresponding to fig. 2, the flow 300 of the data model generation method in some embodiments corresponding to fig. 3 adds steps of uploading data definition language, uploading script, uploading deployment scheduling related information, and the like. Thereby realizing the deployment of the model at the data processing end.
With further reference to fig. 4, as an implementation of the methods illustrated in the above figures, the present disclosure provides some embodiments of a data model generation apparatus, which correspond to those of the method embodiments illustrated in fig. 2, and which may be applied in various electronic devices in particular.
As shown in fig. 4, the data model generation apparatus 400 of some embodiments includes: a determination unit 401, a configuration unit 402, a reception unit 403 and a generation unit 404. The determining unit 401 is configured to determine, in response to completion of a selection operation on at least one data source control in the graphical interface by a user, the number of data sources corresponding to the data source selection operation, where each data source control corresponds to one data source; a configuration unit 402 configured to configure a corresponding data model category for the graphical interface according to the number of data sources; a receiving unit 403, configured to receive data model configuration information input by a user in a graphical interface, the data model configuration information being used for generating a target data table based on at least one data source; a generating unit 404 configured to generate a data model based on the at least one data source, the data model category, and the data model configuration information.
In an optional implementation of some embodiments, the generating unit 404 is further configured to generate a target data definition language for characterizing the processing logic of the data model based on the at least one data source, the data model category, and the data model configuration information; sending the target data definition language to a data processing end, wherein the data processing end is used for creating a target data table based on the target data definition language; receiving result information which is sent by a data processing end and used for representing whether the target data table is successfully created; and in response to the result information representation target data table is not successfully created, the target data definition language is sent to the data processing terminal again.
In an optional implementation manner of some embodiments, the generating unit 404 is further configured to upload the script to the data processing end in response to the result information representing that the target data table is successfully created; and responding to successful uploading of the script, uploading deployment scheduling related information to a data processing end, wherein the deployment scheduling related information is used for deployment scheduling of the data model.
In an optional implementation manner of some embodiments, the receiving unit 403 is further configured to receive an association relationship between at least one data source and an association field between at least one data source, which are input by a user in the graphical interface, where the association relationship between at least one data source is input by the user by adjusting a connection relationship between at least one data source control; and the generation unit 404 is further configured to: and generating the data model based on the at least one data source, the data model category, the association relation between the at least one data source and the association field between the at least one data source.
In an optional implementation manner of some embodiments, the receiving unit 403 is further configured to receive field logic set by the user for each associated field, wherein the field logic is set by the user selecting a target aggregation function from a plurality of preset aggregation functions or inputting the target aggregation function.
In an optional implementation of some embodiments, the receiving unit 403 is further configured to: and receiving the filtering condition set by the user for each associated field.
It will be understood that the units described in the apparatus 400 correspond to the various steps in the method described with reference to fig. 2. As such, the operations, features, and resulting benefits described above for the method are equally applicable to the device 400 and the units contained therein, and are not redundantly described here.
Referring now to FIG. 5, a schematic diagram of an electronic device 500 suitable for use in implementing some embodiments of the present disclosure is shown. The electronic device in some embodiments of the present disclosure may include, but is not limited to, mobile terminals such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (personal digital assistant), a PAD (tablet computer), a PMP (portable multimedia player), a vehicle mounted terminal (e.g., a car navigation terminal), and the like, and fixed terminals such as a digital TV, a desktop computer, and the like. The electronic device shown in fig. 5 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.
As shown in fig. 5, electronic device 500 may include a processing means (e.g., central processing unit, graphics processor, etc.) 501 that may perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)502 or a program loaded from a storage means 508 into a Random Access Memory (RAM) 503. In the RAM 503, various programs and data necessary for the operation of the electronic apparatus 500 are also stored. The processing device 501, the ROM 502, and the RAM 503 are connected to each other through a bus 504. An input/output (I/O) interface 505 is also connected to bus 504.
Generally, the following devices may be connected to the I/O interface 505: input devices 506 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; output devices 507 including, for example, a Liquid Crystal Display (LCD), speakers, vibrators, and the like; storage devices 508 including, for example, magnetic tape, hard disk, etc.; and a communication device 509. The communication means 509 may allow the electronic device 500 to communicate with other devices wirelessly or by wire to exchange data. While fig. 5 illustrates an electronic device 500 having various means, it is to be understood that not all illustrated means are required to be implemented or provided. More or fewer devices may alternatively be implemented or provided. Each block shown in fig. 5 may represent one device or may represent multiple devices as desired.
In particular, according to some embodiments of the present disclosure, the processes described above with reference to the flow diagrams may be implemented as computer software programs. For example, some embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such embodiments, the computer program may be downloaded and installed from a network via the communication device 509, or installed from the storage device 508, or installed from the ROM 502. The computer program, when executed by the processing device 501, performs the above-described functions defined in the methods of some embodiments of the present disclosure.
It should be noted that the computer readable medium described in some embodiments of the present disclosure may be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In some embodiments of the disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In some embodiments of the present disclosure, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (radio frequency), etc., or any suitable combination of the foregoing.
In some embodiments, the clients, servers may communicate using any currently known or future developed network Protocol, such as HTTP (HyperText Transfer Protocol), and may interconnect with any form or medium of digital data communication (e.g., a communications network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the Internet (e.g., the Internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed network.
The computer readable medium may be embodied in the electronic device; or may exist separately without being assembled into the electronic device. The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: responding to the completion of the selection operation of a user for at least one data source control in a graphical interface, and determining the number of data sources corresponding to the data source selection operation, wherein each data source control corresponds to one data source; configuring corresponding data model types for the graphical interface according to the number of the data sources; receiving data model configuration information input by a user in a graphical interface, wherein the data model configuration information is used for generating a target data table based on at least one data source; a data model is generated based on the at least one data source, the data model category, and the data model configuration information.
Computer program code for carrying out operations for embodiments of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in some embodiments of the present disclosure may be implemented by software, and may also be implemented by hardware. The described units may also be provided in a processor, and may be described as: a processor includes a determination unit, a configuration unit, a reception unit, and a generation unit. The names of the units do not form a limitation on the units themselves in some cases, for example, the determining unit may also be described as a unit for determining the number of data sources corresponding to the data source selecting operation.
The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), systems on a chip (SOCs), Complex Programmable Logic Devices (CPLDs), and the like.
The foregoing description is only exemplary of the preferred embodiments of the disclosure and is illustrative of the principles of the technology employed. It will be appreciated by those skilled in the art that the scope of the invention in the embodiments of the present disclosure is not limited to the specific combination of the above-mentioned features, and other embodiments formed by any combination of the above-mentioned features or their equivalents are also encompassed by the present invention without departing from the above-mentioned inventive concept. For example, the above features and (but not limited to) the features with similar functions disclosed in the embodiments of the present disclosure are mutually replaced to form the technical solution.

Claims (9)

1. A data model generation method, comprising:
responding to the completion of the selection operation of a user for at least one data source control in a graphical interface, and determining the number of data sources corresponding to the data source selection operation, wherein each data source control corresponds to one data source;
configuring corresponding data model types for the graphical interface according to the number of the data sources;
receiving data model configuration information input by the user in the graphical interface, wherein the data model configuration information is used for generating a target data table based on the at least one data source;
generating the data model based on the at least one data source, the data model category, and the data model configuration information.
2. The method of claim 1, wherein the generating the data model based on the at least one data source, the data model category, and the data model configuration information comprises:
generating a target data definition language for characterizing processing logic of the data model based on the at least one data source, the data model category, and the data model configuration information;
sending the target data definition language to a data processing end, wherein the data processing end is used for creating a target data table based on the target data definition language;
receiving result information which is sent by the data processing terminal and used for representing whether the target data table is successfully created or not;
and in response to the result information representing that the target data table is not successfully created, sending the target data definition language to a data processing terminal again.
3. The method of claim 2, wherein the generating the data model based on the at least one data source, the data model category, and the data model configuration information comprises:
responding to the result information representing that the target data table is successfully established, and uploading the script corresponding to the data model to the data processing terminal;
and responding to the successful uploading of the script, uploading deployment scheduling related information to the data processing terminal, wherein the deployment scheduling related information is used for deploying and scheduling the data model.
4. The method of claim 2, wherein receiving data model configuration information entered by the user in the graphical interface for generating a target data table based on the at least one data source comprises:
receiving an association relationship between the at least one data source and an association field between the at least one data source, which are input in the graphical interface by the user, wherein the association relationship between the at least one data source is input by the user by adjusting a connection relationship between the at least one data source control; and
generating the data model based on the at least one data source, the data model category, and the data model configuration information, includes:
generating the data model based on the at least one data source, the data model category, the association between the at least one data source, and the association field between the at least one data source.
5. The method of claim 4, wherein the receiving data model configuration information entered by the user in the graphical interface for generating a target data table based on the at least one data source comprises:
receiving field logic set by the user for each associated field, wherein the field logic is set by the user selecting a target aggregation function from a plurality of preset aggregation functions or inputting the target aggregation function.
6. The method of claim 5, wherein the receiving data model configuration information entered by the user in the graphical interface for generating a target data table based on the at least one data source comprises:
and receiving the filtering condition set by the user for each associated field.
7. A data model generation apparatus comprising:
the determining unit is configured to determine the number of data sources corresponding to at least one data source control in response to the completion of a selection operation of a user on the at least one data source control in a graphical interface, wherein each data source control corresponds to one data source;
the configuration unit is configured to configure corresponding data model types for the graphical interface according to the number of the data sources;
a receiving unit configured to receive data model configuration information input by the user in the graphical interface, the data model configuration information being used for generating a target data table based on the at least one data source;
a generating unit configured to generate the data model based on the at least one data source, the data model category, and the data model configuration information.
8. An electronic device, comprising:
one or more processors;
a storage device having one or more programs stored thereon,
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-6.
9. A computer-readable medium, on which a computer program is stored, wherein the program, when executed by a processor, implements the method of any one of claims 1-6.
CN202110038818.2A 2021-01-12 2021-01-12 Data model generation method and device, electronic equipment and computer readable medium Pending CN113760254A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110038818.2A CN113760254A (en) 2021-01-12 2021-01-12 Data model generation method and device, electronic equipment and computer readable medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110038818.2A CN113760254A (en) 2021-01-12 2021-01-12 Data model generation method and device, electronic equipment and computer readable medium

Publications (1)

Publication Number Publication Date
CN113760254A true CN113760254A (en) 2021-12-07

Family

ID=78786281

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110038818.2A Pending CN113760254A (en) 2021-01-12 2021-01-12 Data model generation method and device, electronic equipment and computer readable medium

Country Status (1)

Country Link
CN (1) CN113760254A (en)

Similar Documents

Publication Publication Date Title
CN109523187B (en) Task scheduling method, device and equipment
CN110781373B (en) List updating method and device, readable medium and electronic equipment
CN112684968A (en) Page display method and device, electronic equipment and computer readable medium
CN115145560B (en) Business orchestration method, apparatus, device, computer-readable medium, and program product
CN111461967B (en) Picture processing method, device, equipment and computer readable medium
CN111596991A (en) Interactive operation execution method and device and electronic equipment
CN111190657B (en) Activity configuration method and device, readable medium and electronic equipment
CN115357350A (en) Task configuration method and device, electronic equipment and computer readable medium
CN111857720A (en) Method and device for generating user interface state information, electronic equipment and medium
CN113392018B (en) Traffic distribution method and device, storage medium and electronic equipment
CN110879729A (en) Channel configuration method and device for live broadcast room, readable medium and electronic equipment
CN112764629B (en) Augmented reality interface display method, device, equipment and computer readable medium
CN114428925A (en) Page rendering method and device, electronic equipment and computer readable medium
CN113760254A (en) Data model generation method and device, electronic equipment and computer readable medium
CN110619079B (en) Method and device for pushing information
CN112148417A (en) Page adjusting method and device, electronic equipment and computer readable medium
CN113296771A (en) Page display method, device, equipment and computer readable medium
CN111309323A (en) Parameter initialization method and device and electronic equipment
CN112346728B (en) Device adaptation method, apparatus, device and computer readable medium
CN111857879B (en) Data processing method, device, electronic equipment and computer readable medium
CN116974684B (en) Map page layout method, map page layout device, electronic equipment and computer readable medium
CN112883697B (en) Workflow form generation method, device, electronic equipment and computer readable medium
CN113779468A (en) Method and device for processing page interface data
CN115826981A (en) Real-time operating system driver adaptation method and device, electronic equipment and readable medium
CN113220293A (en) Page display method and device, electronic equipment and computer readable medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination