CN110928879A - Wide table generation method and device - Google Patents
Wide table generation method and device Download PDFInfo
- Publication number
- CN110928879A CN110928879A CN201911138232.2A CN201911138232A CN110928879A CN 110928879 A CN110928879 A CN 110928879A CN 201911138232 A CN201911138232 A CN 201911138232A CN 110928879 A CN110928879 A CN 110928879A
- Authority
- CN
- China
- Prior art keywords
- data
- wide table
- wide
- data tables
- module
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured databases
Abstract
The disclosure relates to a method and a device for generating a wide table. The method comprises the following steps: displaying information of a plurality of data tables related to the electric power service system on a display interface; determining a plurality of selected target data tables in the plurality of data tables; acquiring configuration information aiming at a plurality of target data tables, wherein the configuration information comprises association fields among the plurality of target data tables and association relations corresponding to the association fields; judging whether a wide table can be generated or not according to the associated fields among the target data tables and the associated relation corresponding to the associated fields; if the wide table can be generated, the wide table is generated. According to the embodiment of the disclosure, the plurality of data tables are displayed on the display interface, the selected plurality of target data tables and the configuration information aiming at the plurality of target data tables are determined, whether the wide table can be generated is judged, and the wide table is generated under the condition that the wide table can be generated, so that the wide table is generated through visual configuration, and the operation complexity of generating the wide table is reduced.
Description
Technical Field
The present disclosure relates to the field of data processing, and in particular, to a method and an apparatus for generating a wide table.
Background
The broad table is a database table with more fields, and generally refers to a database table in which indexes, dimensions and attributes related to business topics are associated together. With the continuous progress of science and technology, the amount of data in the power system is continuously increased, but due to different focuses of attention of all business departments, data storage is also dispersed in all business systems, data sharing and fusion are difficult, full-business monitoring and data analysis are difficult to develop, in the related technology, data of the power system are sorted by generating and utilizing a wide table, but the problems of high requirements on the technical level of operators and high operation complexity of technicians exist.
Disclosure of Invention
In view of this, the present disclosure provides a wide table generation method, which can implement visual configuration and generate a wide table, and reduce the complexity of operations for generating the wide table.
According to an aspect of the present disclosure, there is provided a wide table generation method, the method including:
displaying information of a plurality of data tables related to an electric power service system on a display interface, wherein each data table comprises at least one field;
determining a plurality of target data tables selected from the plurality of data tables;
acquiring configuration information aiming at the target data tables, wherein the configuration information comprises association fields among the target data tables and association relations corresponding to the association fields;
judging whether a wide table can be generated or not according to the associated fields among the target data tables and the associated relation corresponding to the associated fields;
in the case where a wide table can be generated, the wide table is generated.
For the above method, in one possible implementation, the method further includes:
acquiring a data table set corresponding to each power service system, wherein the data table set comprises at least one data table;
generating a data dictionary according to the data table set corresponding to each power service system,
wherein the displaying displays information of a plurality of data tables related to the power service system on the display interface,
the method comprises the following steps:
and displaying the information of the plurality of data tables on the display interface in the form of the data dictionary.
For the above method, in one possible implementation, in a case where a wide table can be generated, generating the wide table includes:
acquiring the service data corresponding to the selected target data tables from a database;
and generating the wide table according to the service data and the configuration information.
For the above method, in one possible implementation, the method further includes:
hooking a data tool, wherein the data tool comprises a big data mining algorithm package and/or a big data BI tool;
determining a data tool selected for application to the wide table;
performing data analysis based on the broad table and the data tool to obtain a data analysis result;
and displaying the data analysis result.
For the above method, in a possible implementation manner, performing data analysis based on the wide table and the data tool to obtain a data analysis result includes:
performing data cleaning processing on the service data of the wide table to obtain cleaned service data;
and performing data analysis according to the cleaned service data and the data tool to obtain a data analysis result.
For the above method, in one possible implementation, the power service system includes at least one of a 95598 client system, an OMS scheduling system, a marketing service system, and a PMS production management system.
For the above method, in one possible implementation, the method further includes:
in the case that the wide table cannot be generated, acquiring configuration information of the selected target data tables again;
and judging whether the selected target data tables can generate wide tables or not according to the acquired configuration information.
For the above method, in one possible implementation, the method further includes:
and displaying the information of the wide list in a view form on the display interface.
According to another aspect of the present disclosure, there is provided a wide table generating apparatus, the apparatus including:
the system comprises a first display module, a second display module and a display module, wherein the first display module is used for displaying information of a plurality of data tables related to an electric power service system on a display interface, and each data table comprises at least one field;
the first determining module is used for determining a plurality of selected target data tables in the plurality of data tables;
a first obtaining module, configured to obtain configuration information for the target data tables, where the configuration information includes association fields between the target data tables and association relations corresponding to the association fields;
the first judgment module is used for judging whether the wide table can be generated or not according to the association fields among the target data tables and the association relation corresponding to the association fields;
and the wide table generating module is used for generating the wide table under the condition that the wide table can be generated.
For the above apparatus, in one possible implementation manner, the apparatus further includes:
the second acquisition module is used for acquiring a data table set corresponding to each power service system, and the data table set comprises at least one data table;
a data dictionary generating module for generating a data dictionary according to the data table set corresponding to each power service system,
wherein the first display module comprises:
and the display sub-module is used for displaying the information of the data tables on the display interface in the form of the data dictionary.
For the apparatus, in a possible implementation manner, the wide table generating module includes:
the first obtaining submodule is used for obtaining the service data corresponding to the selected target data tables from a database;
and the wide table generating submodule is used for generating the wide table according to the service data and the configuration information.
For the above apparatus, in one possible implementation manner, the apparatus further includes:
the data tool hooking module is used for hooking data tools, and the data tools comprise a big data mining algorithm package and/or a big data BI tool;
a second determination module to determine the data tools selected to apply to the wide table;
the third determining module is used for carrying out data analysis based on the broad table and the data tool to obtain a data analysis result;
and the second display module is used for displaying the data analysis result.
For the apparatus, in a possible implementation manner, the third determining module includes:
the first determining submodule is used for carrying out data cleaning processing on the service data of the wide table to obtain the cleaned service data;
and the second determining submodule is used for carrying out data analysis according to the cleaned service data and the data tool to obtain a data analysis result.
For the above apparatus, in one possible implementation, the power service system includes at least one of a 95598 client system, an OMS scheduling system, a marketing service system, and a PMS production management system.
For the above apparatus, in one possible implementation manner, the apparatus further includes:
a third obtaining module, configured to, if it is determined that the wide table cannot be generated, obtain configuration information for the selected target data tables again;
and the second judging module is used for judging whether the selected target data tables can generate the wide table or not according to the newly acquired configuration information.
For the above apparatus, in one possible implementation manner, the apparatus further includes:
and the third display module is used for displaying the information of the wide list in a view form on the display interface.
According to another aspect of the present disclosure, there is provided a wide table generating apparatus including: a processor; a memory for storing processor-executable instructions; wherein the processor is configured to perform the above method.
According to another aspect of the present disclosure, there is provided a non-transitory computer readable storage medium having computer program instructions stored thereon, wherein the computer program instructions, when executed by a processor, implement the above-described wide table generation method.
According to the embodiment of the disclosure, information of a plurality of data tables related to a power business system is displayed on a display interface, the selected target data tables and configuration information for the target data tables are determined, whether a wide table can be generated is judged, and the wide table is generated under the condition that the wide table can be generated, so that visual configuration is realized, the wide table is generated, and the operation complexity of generating the wide table is reduced.
Other features and aspects of the present disclosure will become apparent from the following detailed description of exemplary embodiments, which proceeds with reference to the accompanying drawings.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate exemplary embodiments, features, and aspects of the disclosure and, together with the description, serve to explain the principles of the disclosure.
FIG. 1 shows a flow diagram of a wide table generation method according to an embodiment of the present disclosure.
Fig. 2 illustrates a block diagram of a wide table generation apparatus according to an embodiment of the present disclosure.
Fig. 3 shows a block diagram of a wide table generation apparatus according to an embodiment of the present disclosure.
Detailed Description
Various exemplary embodiments, features and aspects of the present disclosure will be described in detail below with reference to the accompanying drawings. In the drawings, like reference numbers can indicate functionally identical or similar elements. While the various aspects of the embodiments are presented in drawings, the drawings are not necessarily drawn to scale unless specifically indicated.
The word "exemplary" is used exclusively herein to mean "serving as an example, embodiment, or illustration. Any embodiment described herein as "exemplary" is not necessarily to be construed as preferred or advantageous over other embodiments.
Furthermore, in the following detailed description, numerous specific details are set forth in order to provide a better understanding of the present disclosure. It will be understood by those skilled in the art that the present disclosure may be practiced without some of these specific details. In some instances, methods, means, elements and circuits that are well known to those skilled in the art have not been described in detail so as not to obscure the present disclosure.
FIG. 1 shows a flow diagram of a wide table generation method according to an embodiment of the present disclosure. The wide table generation method can be applied to a terminal. As shown in fig. 1, the wide table generating method includes:
in step S11, displaying information of a plurality of data tables related to the power service system on a display interface, each of the data tables including at least one field;
in step S12, determining a plurality of target data tables selected from the plurality of data tables;
in step S13, obtaining configuration information for the target data tables, where the configuration information includes association fields between the target data tables and association relations corresponding to the association fields;
in step S14, determining whether a wide table can be generated according to the association fields between the target data tables and the association relationship corresponding to the association fields;
in step S15, if the wide table can be generated, the wide table is generated.
According to the embodiment of the disclosure, information of a plurality of data tables related to a power business system is displayed on a display interface, the selected target data tables and configuration information for the target data tables are determined, whether a wide table can be generated is judged, and the wide table is generated under the condition that the wide table can be generated, so that visual configuration is realized, the wide table is generated, and the operation complexity of generating the wide table is reduced.
For example, information of a plurality of data tables can be displayed on a terminal display interface for selection by an operator, and each data table comprises at least one field. The information of the data tables can be description information of the data tables displayed in a catalog, list or description information mode, and service data related to the power service system corresponding to the data tables can be stored in a corresponding database. The information of the plurality of data tables may also include service data of the data tables. The present disclosure does not limit the display manner of the information of the plurality of data tables and the content of the information of the plurality of data tables.
In one possible implementation, the method further includes:
acquiring a data table set corresponding to each power service system, wherein the data table set comprises at least one data table;
generating a data dictionary according to the data table set corresponding to each power service system,
wherein, the displaying information of the plurality of data tables on the display interface (step S11) may include:
and displaying the information of the plurality of data tables on the display interface in the form of the data dictionary.
The power service system may be any system related to power operation, for example, the power service system may include at least one of a 95598 customer system, an OMS scheduling system, a marketing service system, and a PMS production management system. The number and the types of the power business systems are not limited by the disclosure.
In one possible implementation, the information for displaying the plurality of data tables on the terminal display interface may be determined according to each power service system. For example, a data table set corresponding to each power service system may be obtained, where the data table set corresponding to each power service system may include all or part of data tables in the power service system. Each data table records all field names, field types, etc. it contains. The data dictionary may be generated by parsing each power service system and the set of data tables corresponding to each power service system. The data dictionary may be divided into a plurality of areas according to each power service system, and a directory, a list or description information of a data table set of the corresponding power service system is displayed in each area. The method for generating the data dictionary and the form of the data dictionary are not limited by the disclosure.
In one possible implementation, the information of the plurality of data tables may be displayed on the display interface in the form of the data dictionary. For example, as described above, the data dictionary may be divided into a plurality of areas according to each power service system, and then, in the display interface, the directory, list, description information, and the like of the data table set corresponding to each power service system may be displayed in the form of the data dictionary.
Therefore, the data dictionary is adopted to uniformly describe the data tables of the power service systems, so that the data tables scattered in the power service systems can be uniformly displayed, and the data dictionary is convenient to check and access.
As described above, the operator may select the data table, for example, the operator may select a plurality of target data tables from the directory information of the plurality of data tables displayed on the display interface as needed, or sequentially select the required target data tables from the data dictionary in a what you see is what you get manner, and put the selected target data tables in the same visual view in a dragging manner. The terminal can determine a plurality of selected target data tables in the plurality of data tables according to corresponding operation of an operator.
In a possible implementation manner, an operator may configure the target data table, for example, configure associated target data tables, configure associated fields between the target data tables, configure association relations corresponding to the associated fields, or configure fields to be reserved in the wide table to be generated. The association relationship corresponding to the association field may refer to a rule for performing association operation on the association field. For example, the association relationship may include a left connection (left join), a right connection (right join), an inner connection (inner join), and the like. The terminal may obtain configuration information for the plurality of target data tables according to an operation of an operator, where the configuration information is information that is determined by the terminal according to the configuration operation of the operator and is used to generate the wide table. For example, the association fields among the multiple target data tables and the association relations corresponding to the association fields may be included, and the association information of the multiple target data tables and the field information to be reserved in the wide table to be generated may also be included.
And the terminal judges whether the wide table can be generated or not according to the associated fields among the target data tables and the associated relation corresponding to the associated fields. For example, the terminal may automatically generate an SQL statement for testing according to the association fields between the multiple target data tables and the association relationship corresponding to the association fields, and determine whether the wide table may be generated according to a test result returned after the SQL statement is executed.
In one possible implementation, the wide table is determined to be composed when the number of result sets returned after execution according to the SQL statement is greater than or equal to a result set threshold. Wherein, the result set is that the object contains all row sets which meet the conditions in the SQL statement. The value of the result set threshold is not limited by the present disclosure.
In one possible implementation, the method may further include:
in the case that the wide table cannot be generated, acquiring configuration information of the selected target data tables again;
and judging whether the selected target data tables can generate wide tables or not according to the acquired configuration information.
For example, when the number of result sets returned after execution according to the SQL statement is less than the result set threshold, it is determined that the wide table cannot be generated. In the event that it is determined that the wide table cannot be generated, configuration information for the selected plurality of target data tables may be retrieved. For example, a prompt message that a broad list cannot be generated may be displayed on the display interface. The operator may reconfigure, and the terminal may retrieve the configuration information for the selected target data tables, and determine whether the selected target data tables can generate the wide table according to the retrieved configuration information. It should be understood that, when it is determined that the wide table cannot be generated based on the newly acquired configuration information, the step of newly acquiring the configuration information for the selected plurality of target data tables and determining whether the wide table can be generated may be performed cyclically until it is determined that the wide table can be generated based on the configuration information configured by the operator. Thus, visual configuration and wide table generation are realized, and the operation complexity of wide table generation is reduced.
And the terminal generates the wide table under the condition that the wide table can be generated. For example, the terminal may generate the wide table according to the obtained configuration information and the service data corresponding to the plurality of corresponding target data tables obtained from the database. As described above, the configuration information may further include field information that needs to be reserved in the wide table to be generated, and when the wide table is generated, records corresponding to the field information that needs to be reserved in the wide table to be generated of the configuration information may be reserved. The manner in which the broad table is generated is not limited by this disclosure.
In a possible implementation manner, in a case that a wide table can be generated, generating the wide table (step S15) may include:
acquiring the service data corresponding to the selected target data tables from a database;
and generating the wide table according to the service data and the configuration information.
For example, as described above, the target data tables may be distributed in different power service systems, the data tables of each power service system may be stored in different databases, and the terminal may obtain service data corresponding to the selected target data tables from the databases. For example, the terminal may automatically execute the SQL statement to retrieve rows from the database that meet the conditions in the SQL statement. Wherein the optional database may comprise a full-service data center, an enterprise cloud platform, and the like.
In this way, visual configuration and wide table generation are realized, and the operation complexity of wide table generation is reduced.
In one possible implementation, the method may further include:
and displaying the information of the wide list in a view form on the display interface.
For example, the information of the wide table may be displayed in a view form, for example, various kinds of description information such as the name and the field type of the wide table are displayed, so that the display effect of the wide table is more intuitive.
In one possible implementation, the method may further include:
hooking a data tool, wherein the data tool comprises a big data mining algorithm package and/or a big data BI tool;
determining a data tool selected for application to the wide table;
performing data analysis based on the broad table and the data tool to obtain a data analysis result;
and displaying the data analysis result.
For example, the terminal may configure one or more data tools for the wide table, such as an automatic attach data tool, where the data tools may include a big data mining algorithm package and/or a big data BI tool. For example, big data applications, including data statistics analysis-like applications, business intelligence-like tools, including but not limited to tableau, echarts, and the like. The terminal may determine the data tools selected to apply to the wide list. For example, the operator may wish to analyze the generated wide table in combination with the data tool, namely, tableau, and in response to the operation related to the operator, the terminal may determine that the data tool selected to be applied to the wide table is tableau. The terminal may perform data analysis based on the broad form and the data tool to obtain a data analysis result, for example, applying the service data of the broad form to the tableau to obtain the data analysis result. The terminal can display the data analysis result in a view mode.
The big data analysis can comprise descriptive statistical analysis, R language modeling analysis, clustering analysis and the like, and the displaying of the data analysis result can comprise visual display by adopting a business intelligent tool, R language programming visual display and the like. The present disclosure does not limit the type of data tool, the big data analysis, and the way of displaying the analysis result.
It should be understood that a large amount of power operation data exists in each power service system, the focus of attention of each power service department is different, data sharing and aggregation are difficult, and data mining, big data analysis and power grid full-service monitoring are difficult to develop macroscopically. According to the embodiment of the disclosure, the wide table is generated according to the service data of each power service system, and data sharing and aggregation of the power service systems are realized. A BI tool or a big data mining algorithm package is automatically articulated, diversified analysis and mining are carried out by using a data tool based on a generated wide table, visual display is carried out based on analysis and mining results, the value in electric power operation data can be effectively mined, the big data mining efficiency and practicability of the power grid are improved, full-service effective monitoring and intelligent decision making are carried out on the power grid, and data support and basis are provided.
In a possible implementation manner, performing data analysis based on the broad table and the data tool to obtain a data analysis result may include:
performing data cleaning processing on the service data of the wide table to obtain cleaned service data;
and performing data analysis according to the cleaned service data and the data tool to obtain a data analysis result.
For example, before performing data analysis based on the wide table, data cleaning processing may be performed on the service data of the wide table to obtain cleaned service data, which may include, for example, removing blank field data, removing duplicate service data by field, and the like. The present disclosure does not limit the manner of performing data cleaning processing on the service data of the wide table. The terminal can perform data analysis according to the cleaned service data and the data tool to obtain the data analysis result.
By the method, the quality of the service data can be improved, data analysis is carried out based on the service data with higher quality, and the accuracy of the data analysis result can be improved.
Fig. 2 illustrates a block diagram of a wide table generation apparatus according to an embodiment of the present disclosure. Referring to fig. 2, the apparatus includes:
a first display module 21, configured to display information of a plurality of data tables related to an electric power service system on a display interface, where each data table includes at least one field;
a first determining module 22, configured to determine a plurality of target data tables selected from the plurality of data tables;
a first obtaining module 23, configured to obtain configuration information for the multiple target data tables, where the configuration information includes association fields between the multiple target data tables and association relations corresponding to the association fields;
a first judging module 24, configured to judge whether a wide table can be generated according to the association fields among the multiple target data tables and the association relations corresponding to the association fields;
and a wide table generating module 25, configured to generate the wide table if the wide table can be generated.
In one possible implementation, the apparatus further includes:
the second acquisition module is used for acquiring a data table set corresponding to each power service system, and the data table set comprises at least one data table;
a data dictionary generating module for generating a data dictionary according to the data table set corresponding to each power service system,
wherein the first display module comprises:
and the display sub-module is used for displaying the information of the data tables on the display interface in the form of the data dictionary.
In one possible implementation, the wide table generating module includes:
the first obtaining submodule is used for obtaining the service data corresponding to the selected target data tables from a database;
and the wide table generating submodule is used for generating the wide table according to the service data and the configuration information.
In one possible implementation, the apparatus further includes:
the data tool hooking module is used for hooking data tools, and the data tools comprise a big data mining algorithm package and/or a big data BI tool;
a second determination module to determine the data tools selected to apply to the wide table;
the third determining module is used for carrying out data analysis based on the broad table and the data tool to obtain a data analysis result;
and the second display module is used for displaying the data analysis result.
In one possible implementation manner, the third determining module includes:
the first determining submodule is used for carrying out data cleaning processing on the service data of the wide table to obtain the cleaned service data;
and the second determining submodule is used for carrying out data analysis according to the cleaned service data and the data tool to obtain a data analysis result.
In one possible implementation, the power services system includes at least one of a 95598 client system, an OMS scheduling system, a marketing services system, and a PMS production management system.
In one possible implementation, the apparatus further includes:
a third obtaining module, configured to, if it is determined that the wide table cannot be generated, obtain configuration information for the selected target data tables again;
and the second judging module is used for judging whether the selected target data tables can generate the wide table or not according to the newly acquired configuration information.
In one possible implementation, the apparatus further includes:
and the third display module is used for displaying the information of the wide list in a view form on the display interface.
Fig. 3 shows a block diagram of a wide table generation apparatus according to an embodiment of the present disclosure. For example, the apparatus 800 may be a mobile phone, a computer, a digital broadcast terminal, a messaging device, a game console, a tablet device, a medical device, an exercise device, a personal digital assistant, and the like.
Referring to fig. 3, the apparatus 800 may include one or more of the following components: processing component 802, memory 804, power component 806, multimedia component 808, audio component 810, input/output (I/O) interface 812, sensor component 814, and communication component 816.
The processing component 802 generally controls overall operation of the device 800, such as operations associated with display, telephone calls, data communications, camera operations, and recording operations. The processing components 802 may include one or more processors 820 to execute instructions to perform all or a portion of the steps of the methods described above. Further, the processing component 802 can include one or more modules that facilitate interaction between the processing component 802 and other components. For example, the processing component 802 can include a multimedia module to facilitate interaction between the multimedia component 808 and the processing component 802.
The memory 804 is configured to store various types of data to support operations at the apparatus 800. Examples of such data include instructions for any application or method operating on device 800, contact data, phonebook data, messages, pictures, videos, and so forth. The memory 804 may be implemented by any type or combination of volatile or non-volatile memory devices such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disks.
The multimedia component 808 includes a screen that provides an output interface between the device 800 and a user. In some embodiments, the screen may include a Liquid Crystal Display (LCD) and a Touch Panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive an input signal from a user. The touch panel includes one or more touch sensors to sense touch, slide, and gestures on the touch panel. The touch sensor may not only sense the boundary of a touch or slide action, but also detect the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 808 includes a front facing camera and/or a rear facing camera. The front camera and/or the rear camera may receive external multimedia data when the device 800 is in an operating mode, such as a shooting mode or a video mode. Each front camera and rear camera may be a fixed optical lens system or have a focal length and optical zoom capability.
The audio component 810 is configured to output and/or input audio signals. For example, the audio component 810 includes a Microphone (MIC) configured to receive external audio signals when the apparatus 800 is in an operational mode, such as a call mode, a recording mode, and a voice recognition mode. The received audio signals may further be stored in the memory 804 or transmitted via the communication component 816. In some embodiments, audio component 810 also includes a speaker for outputting audio signals.
The I/O interface 812 provides an interface between the processing component 802 and peripheral interface modules, which may be keyboards, click wheels, buttons, etc. These buttons may include, but are not limited to: a home button, a volume button, a start button, and a lock button.
The sensor assembly 814 includes one or more sensors for providing various aspects of state assessment for the device 800. For example, the sensor assembly 814 may detect the open/closed status of the device 800, the relative positioning of components, such as a display and keypad of the device 800, the sensor assembly 814 may also detect a change in the position of the device 800 or a component of the device 800, the presence or absence of user contact with the device 800, the orientation or acceleration/deceleration of the device 800, and a change in the temperature of the device 800. Sensor assembly 814 may include a proximity sensor configured to detect the presence of a nearby object without any physical contact. The sensor assembly 814 may also include a light sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 814 may also include an acceleration sensor, a gyroscope sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.
The communication component 816 is configured to facilitate communications between the apparatus 800 and other devices in a wired or wireless manner. The device 800 may access a wireless network based on a communication standard, such as WiFi, 2G or 3G, or a combination thereof. In an exemplary embodiment, the communication component 816 receives a broadcast signal or broadcast related information from an external broadcast management system via a broadcast channel. In an exemplary embodiment, the communication component 816 further includes a Near Field Communication (NFC) module to facilitate short-range communications. For example, the NFC module may be implemented based on Radio Frequency Identification (RFID) technology, infrared data association (IrDA) technology, Ultra Wideband (UWB) technology, Bluetooth (BT) technology, and other technologies.
In an exemplary embodiment, the apparatus 800 may be implemented by one or more Application Specific Integrated Circuits (ASICs), Digital Signal Processors (DSPs), Digital Signal Processing Devices (DSPDs), Programmable Logic Devices (PLDs), Field Programmable Gate Arrays (FPGAs), controllers, micro-controllers, microprocessors or other electronic components for performing the above-described methods.
In an exemplary embodiment, a non-transitory computer-readable storage medium, such as the memory 804, is also provided that includes computer program instructions executable by the processor 820 of the device 800 to perform the above-described methods.
In an exemplary embodiment, a non-transitory computer readable storage medium, such as the memory 1932, is also provided that includes computer program instructions executable by the processing component 1922 of the apparatus 1900 to perform the above-described methods.
The present disclosure may be systems, methods, and/or computer program products. The computer program product may include a computer-readable storage medium having computer-readable program instructions embodied thereon for causing a processor to implement various aspects of the present disclosure.
The computer readable storage medium may be a tangible device that can hold and store the instructions for use by the instruction execution device. The computer readable storage medium may be, for example, but not limited to, an electronic memory device, a magnetic memory device, an optical memory device, an electromagnetic memory device, a semiconductor memory device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: 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), a Static Random Access Memory (SRAM), a portable compact disc read-only memory (CD-ROM), a Digital Versatile Disc (DVD), a memory stick, a floppy disk, a mechanical coding device, such as punch cards or in-groove projection structures having instructions stored thereon, and any suitable combination of the foregoing. Computer-readable storage media as used herein is not to be construed as transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide or other transmission medium (e.g., optical pulses through a fiber optic cable), or electrical signals transmitted through electrical wires.
The computer-readable program instructions described herein may be downloaded from a computer-readable storage medium to a respective computing/processing device, or to an external computer or external storage device via a network, such as the internet, a local area network, a wide area network, and/or a wireless network. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers and/or edge servers. The network adapter card or network interface in each computing/processing device receives computer-readable program instructions from the network and forwards the computer-readable program instructions for storage in a computer-readable storage medium in the respective computing/processing device.
The computer program instructions for carrying out operations of the present disclosure may be assembler instructions, Instruction Set Architecture (ISA) instructions, machine-related instructions, microcode, firmware instructions, state setting data, or source or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The computer-readable program instructions 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). In some embodiments, the electronic circuitry that can execute the computer-readable program instructions implements aspects of the present disclosure by utilizing the state information of the computer-readable program instructions to personalize the electronic circuitry, such as a programmable logic circuit, a Field Programmable Gate Array (FPGA), or a Programmable Logic Array (PLA).
Various aspects of the present disclosure are described herein with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the disclosure. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer-readable program instructions.
These computer-readable program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks. These computer-readable program instructions may also be stored in a computer-readable storage medium that can direct a computer, programmable data processing apparatus, and/or other devices to function in a particular manner, such that the computer-readable medium storing the instructions comprises an article of manufacture including instructions which implement the function/act specified in the flowchart and/or block diagram block or blocks.
The computer readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other devices to cause a series of operational steps to be performed on the computer, other programmable apparatus or other devices to produce a computer implemented process such that the instructions which execute on the computer, other programmable apparatus or other devices implement the functions/acts specified in the flowchart and/or block diagram block or blocks.
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 instructions, which comprises one or more executable instructions for implementing the specified logical function(s). 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.
Having described embodiments of the present disclosure, the foregoing description is intended to be exemplary, not exhaustive, and not limited to the disclosed embodiments. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments. The terms used herein were chosen in order to best explain the principles of the embodiments, the practical application, or technical improvements to the techniques in the marketplace, or to enable others of ordinary skill in the art to understand the embodiments disclosed herein.
Claims (18)
1. A method for generating a wide table, the method comprising:
displaying information of a plurality of data tables related to an electric power service system on a display interface, wherein each data table comprises at least one field;
determining a plurality of target data tables selected from the plurality of data tables;
acquiring configuration information aiming at the target data tables, wherein the configuration information comprises association fields among the target data tables and association relations corresponding to the association fields;
judging whether a wide table can be generated or not according to the associated fields among the target data tables and the associated relation corresponding to the associated fields;
in the case where a wide table can be generated, the wide table is generated.
2. The method of claim 1, further comprising:
acquiring a data table set corresponding to each power service system, wherein the data table set comprises at least one data table;
generating a data dictionary according to the data table set corresponding to each power service system,
wherein the displaying displays information of a plurality of data tables related to the power service system on the display interface,
the method comprises the following steps:
and displaying the information of the plurality of data tables on the display interface in the form of the data dictionary.
3. The method of claim 1, wherein generating the wide table if the wide table can be generated comprises:
acquiring the service data corresponding to the selected target data tables from a database;
and generating the wide table according to the service data and the configuration information.
4. The method of claim 1, further comprising:
hooking a data tool, wherein the data tool comprises a big data mining algorithm package and/or a big data BI tool;
determining a data tool selected for application to the wide table;
performing data analysis based on the broad table and the data tool to obtain a data analysis result;
and displaying the data analysis result.
5. The method of claim 4, wherein performing data analysis based on the broad table and the data tool to obtain data analysis results comprises:
performing data cleaning processing on the service data of the wide table to obtain cleaned service data;
and performing data analysis according to the cleaned service data and the data tool to obtain a data analysis result.
6. The method of claim 2, wherein the power service system comprises at least one of a 95598 client system, an OMS scheduling system, a marketing service system, and a PMS production management system.
7. The method of claim 1, further comprising:
in the case that the wide table cannot be generated, acquiring configuration information of the selected target data tables again;
and judging whether the selected target data tables can generate wide tables or not according to the acquired configuration information.
8. The method of claim 1, further comprising:
and displaying the information of the wide list in a view form on the display interface.
9. An apparatus for generating a wide table, the apparatus comprising:
the system comprises a first display module, a second display module and a display module, wherein the first display module is used for displaying information of a plurality of data tables related to an electric power service system on a display interface, and each data table comprises at least one field;
the first determining module is used for determining a plurality of selected target data tables in the plurality of data tables;
a first obtaining module, configured to obtain configuration information for the target data tables, where the configuration information includes association fields between the target data tables and association relations corresponding to the association fields;
the first judgment module is used for judging whether the wide table can be generated or not according to the association fields among the target data tables and the association relation corresponding to the association fields;
and the wide table generating module is used for generating the wide table under the condition that the wide table can be generated.
10. The apparatus of claim 9, further comprising:
the second acquisition module is used for acquiring a data table set corresponding to each power service system, and the data table set comprises at least one data table;
a data dictionary generating module for generating a data dictionary according to the data table set corresponding to each power service system,
wherein the first display module comprises:
and the display sub-module is used for displaying the information of the data tables on the display interface in the form of the data dictionary.
11. The apparatus of claim 9, wherein the wide table generation module comprises:
the first obtaining submodule is used for obtaining the service data corresponding to the selected target data tables from a database;
and the wide table generating submodule is used for generating the wide table according to the service data and the configuration information.
12. The apparatus of claim 9, further comprising:
the data tool hooking module is used for hooking data tools, and the data tools comprise a big data mining algorithm package and/or a big data BI tool;
a second determination module to determine the data tools selected to apply to the wide table;
the third determining module is used for carrying out data analysis based on the broad table and the data tool to obtain a data analysis result;
and the second display module is used for displaying the data analysis result.
13. The apparatus of claim 12, wherein the third determining module comprises:
the first determining submodule is used for carrying out data cleaning processing on the service data of the wide table to obtain the cleaned service data;
and the second determining submodule is used for carrying out data analysis according to the cleaned service data and the data tool to obtain a data analysis result.
14. The apparatus of claim 10, wherein the power service system comprises at least one of a 95598 client system, an OMS scheduling system, a marketing service system, and a PMS production management system.
15. The apparatus of claim 9, further comprising:
a third obtaining module, configured to, if it is determined that the wide table cannot be generated, obtain configuration information for the selected target data tables again;
and the second judging module is used for judging whether the selected target data tables can generate the wide table or not according to the newly acquired configuration information.
16. The apparatus of claim 9, further comprising:
and the third display module is used for displaying the information of the wide list in a view form on the display interface.
17. A wide table generating apparatus, comprising:
a processor;
a memory for storing processor-executable instructions;
wherein the processor is configured to: performing the method of any one of claims 1 to 8.
18. A non-transitory computer readable storage medium having computer program instructions stored thereon, wherein the computer program instructions, when executed by a processor, implement the method of any of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911138232.2A CN110928879A (en) | 2019-11-20 | 2019-11-20 | Wide table generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911138232.2A CN110928879A (en) | 2019-11-20 | 2019-11-20 | Wide table generation method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110928879A true CN110928879A (en) | 2020-03-27 |
Family
ID=69851258
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911138232.2A Pending CN110928879A (en) | 2019-11-20 | 2019-11-20 | Wide table generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110928879A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109800215A (en) * | 2018-12-26 | 2019-05-24 | 北京明略软件系统有限公司 | Method, apparatus, computer storage medium and the terminal of a kind of pair of mark processing |
| CN111814445A (en) * | 2020-06-19 | 2020-10-23 | 第四范式（北京）技术有限公司 | Data table generation method, device and system |
| CN112231299A (en) * | 2020-09-27 | 2021-01-15 | 中国建设银行股份有限公司 | Method and device for dynamically adjusting feature library |
| CN112380117A (en) * | 2020-11-11 | 2021-02-19 | 中国人寿保险股份有限公司 | Production method and device of software test basic case and electronic equipment |
| CN112395291A (en) * | 2020-11-24 | 2021-02-23 | 深圳市麦谷科技有限公司 | Method and system for dynamically generating wide table according to data assets |
| CN113220593A (en) * | 2021-06-04 | 2021-08-06 | 中国农业银行股份有限公司 | Method, apparatus, device, storage medium and program product for generating test data |
| CN113392105A (en) * | 2021-05-24 | 2021-09-14 | 国网河北省电力有限公司衡水供电分公司 | Service data processing method and terminal equipment |
| CN113535817A (en) * | 2021-07-13 | 2021-10-22 | 浙江网商银行股份有限公司 | Method and device for generating characteristic broad table and training business processing model |
| CN113672671A (en) * | 2020-05-15 | 2021-11-19 | 西安京迅递供应链科技有限公司 | Method and device for realizing data processing |
| CN113765876A (en) * | 2020-11-30 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Report processing software access method and device |
| WO2022033511A1 (en) * | 2020-08-13 | 2022-02-17 | 北京字节跳动网络技术有限公司 | Data display method and apparatus, storage medium, and electronic device |
| CN113535817B (en) * | 2021-07-13 | 2024-05-14 | 浙江网商银行股份有限公司 | Feature broad table generation and service processing model training method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101400043A (en) * | 2007-09-25 | 2009-04-01 | 中兴通讯股份有限公司 | Method and system for consistency comparison of front-background data in mobile communication system |
| CN109446197A (en) * | 2018-09-26 | 2019-03-08 | 深圳壹账通智能科技有限公司 | User information processing method, device, computer equipment and storage medium |
| CN109523316A (en) * | 2018-11-16 | 2019-03-26 | 杭州珞珈数据科技有限公司 | The automation modeling method of commerce services model |
| CN109684332A (en) * | 2018-12-20 | 2019-04-26 | 贵州工程应用技术学院 | A kind of wide table generating method of data, apparatus and system |
| CN110019397A (en) * | 2017-12-06 | 2019-07-16 | 北京京东尚科信息技术有限公司 | For carrying out the method and device of data processing |
-
2019
- 2019-11-20 CN CN201911138232.2A patent/CN110928879A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101400043A (en) * | 2007-09-25 | 2009-04-01 | 中兴通讯股份有限公司 | Method and system for consistency comparison of front-background data in mobile communication system |
| CN110019397A (en) * | 2017-12-06 | 2019-07-16 | 北京京东尚科信息技术有限公司 | For carrying out the method and device of data processing |
| CN109446197A (en) * | 2018-09-26 | 2019-03-08 | 深圳壹账通智能科技有限公司 | User information processing method, device, computer equipment and storage medium |
| CN109523316A (en) * | 2018-11-16 | 2019-03-26 | 杭州珞珈数据科技有限公司 | The automation modeling method of commerce services model |
| CN109684332A (en) * | 2018-12-20 | 2019-04-26 | 贵州工程应用技术学院 | A kind of wide table generating method of data, apparatus and system |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109800215A (en) * | 2018-12-26 | 2019-05-24 | 北京明略软件系统有限公司 | Method, apparatus, computer storage medium and the terminal of a kind of pair of mark processing |
| CN109800215B (en) * | 2018-12-26 | 2020-11-24 | 北京明略软件系统有限公司 | Bidding processing method and device, computer storage medium and terminal |
| CN113672671B (en) * | 2020-05-15 | 2024-04-19 | 西安京迅递供应链科技有限公司 | Method and device for realizing data processing |
| CN113672671A (en) * | 2020-05-15 | 2021-11-19 | 西安京迅递供应链科技有限公司 | Method and device for realizing data processing |
| CN111814445A (en) * | 2020-06-19 | 2020-10-23 | 第四范式（北京）技术有限公司 | Data table generation method, device and system |
| WO2022033511A1 (en) * | 2020-08-13 | 2022-02-17 | 北京字节跳动网络技术有限公司 | Data display method and apparatus, storage medium, and electronic device |
| CN112231299A (en) * | 2020-09-27 | 2021-01-15 | 中国建设银行股份有限公司 | Method and device for dynamically adjusting feature library |
| CN112231299B (en) * | 2020-09-27 | 2024-02-20 | 中国建设银行股份有限公司 | Method and device for dynamically adjusting feature library |
| CN112380117A (en) * | 2020-11-11 | 2021-02-19 | 中国人寿保险股份有限公司 | Production method and device of software test basic case and electronic equipment |
| CN112395291A (en) * | 2020-11-24 | 2021-02-23 | 深圳市麦谷科技有限公司 | Method and system for dynamically generating wide table according to data assets |
| CN113765876B (en) * | 2020-11-30 | 2023-09-26 | 北京沃东天骏信息技术有限公司 | Report processing software access method and device |
| CN113765876A (en) * | 2020-11-30 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Report processing software access method and device |
| CN113392105B (en) * | 2021-05-24 | 2023-03-24 | 国网河北省电力有限公司衡水供电分公司 | Service data processing method and terminal equipment |
| CN113392105A (en) * | 2021-05-24 | 2021-09-14 | 国网河北省电力有限公司衡水供电分公司 | Service data processing method and terminal equipment |
| CN113220593A (en) * | 2021-06-04 | 2021-08-06 | 中国农业银行股份有限公司 | Method, apparatus, device, storage medium and program product for generating test data |
| CN113535817A (en) * | 2021-07-13 | 2021-10-22 | 浙江网商银行股份有限公司 | Method and device for generating characteristic broad table and training business processing model |
| CN113535817B (en) * | 2021-07-13 | 2024-05-14 | 浙江网商银行股份有限公司 | Feature broad table generation and service processing model training method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110928879A (en) | Wide table generation method and device | |
| CN108093315B (en) | Video generation method and device | |
| CN106960014B (en) | Associated user recommendation method and device | |
| US20190379942A1 (en) | Method and apparatus for processing multimedia resources | |
| CN106919629B (en) | Method and device for realizing information screening in group chat | |
| CN110858924B (en) | Video background music generation method and device and storage medium | |
| CN108320208B (en) | Vehicle recommendation method and device | |
| CN110941942A (en) | Method, device and system for checking circuit schematic diagram | |
| CN106599191B (en) | User attribute analysis method and device | |
| CN110493637B (en) | Video splitting method and device | |
| CN114741292A (en) | Test script management method and device, electronic equipment and storage medium | |
| CN111694571B (en) | Compiling method and device | |
| CN109189822B (en) | Data processing method and device | |
| CN106851418B (en) | Video recommendation method and device | |
| CN112883073B (en) | Data screening method, device, equipment, readable storage medium and product | |
| CN111275394B (en) | Message reminding method and device and electronic equipment | |
| CN110969569A (en) | Method and device for generating test-mirror video | |
| CN107168693B (en) | Display method and device of screen locking interface | |
| CN112291581A (en) | Server, terminal equipment, information processing method and device | |
| CN110245343B (en) | Bullet screen analysis method and device | |
| CN111767249B (en) | Method and device for determining self-running time of function | |
| CN115794853B (en) | Updating method and device of government affair data resource catalog, electronic equipment and medium | |
| CN115202888B (en) | Equipment scheduling method and device, electronic equipment and readable storage medium | |
| CN118035363A (en) | Nuclear power station document association method and device | |
| CN112069163A (en) | Data processing method and device, electronic equipment and storage 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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200327 |