CN112926858A

CN112926858A - Power marketing service operation index design method and device

Info

Publication number: CN112926858A
Application number: CN202110216187.9A
Authority: CN
Inventors: 李明; 袁葆; 张靖; 雷霆; 张波; 吕斌; 刘辉舟; 林鸿; 张文; 陈雁; 欧阳红; 吴尚; 唐轶轩; 俞骏豪; 张亮
Original assignee: State Grid Corp of China SGCC; State Grid Information and Telecommunication Co Ltd; State Grid Anhui Electric Power Co Ltd; Beijing China Power Information Technology Co Ltd; Information and Telecommunication Branch of State Grid Anhui Electric Power Co Ltd
Current assignee: State Grid Corp of China SGCC; State Grid Information and Telecommunication Co Ltd; State Grid Anhui Electric Power Co Ltd; Beijing China Power Information Technology Co Ltd; Information and Telecommunication Branch of State Grid Anhui Electric Power Co Ltd
Priority date: 2021-02-26
Filing date: 2021-02-26
Publication date: 2021-06-08

Abstract

The invention discloses a method and a device for designing operation indexes of power marketing business, wherein the method comprises the following steps: defining basic index items, managing basic index database and configuring algorithm rules to realize unification of calculation and storage of service operation indexes; performing index model design, index calculation and index sharing service configuration to realize one-time processing and multi-place sharing of service operation index data; and establishing a business operation index asset directory and configuring specific indexes of the power marketing business operation, and realizing service registration, external service release and call and value evaluation of index services. The realization establishes a unified, standard and sharable power marketing service operation index data system, designs a model from a service architecture, and develops data service from data research and development to data service, so that data manageability and traceability can be realized, repeated construction can be avoided, powerful data support is provided for planning and developing power marketing service operation, and the power marketing service operation quality and efficiency are greatly improved.

Description

Power marketing service operation index design method and device

Technical Field

The invention relates to a data processing technology, in particular to a method and a device for designing operation indexes of power marketing business.

Background

At present, the statistical index data of the power marketing service is redundant and is easy to be repeatedly built, namely, a similar index system is built on similar services, meanwhile, the problem that data chimneys (the data are independent and cannot be shared and used) and the data are inconsistent easily occurs, and the data of each channel and the operation data of users, products, activities and contents need to be classified, organized and stored respectively.

However, the above situation not only generates excessive pressure on the storage system, but also is not favorable for unified management of data, and meanwhile, data sharing between different systems cannot be realized, so that the user is extremely inconvenient to use and experiences poor experience.

Disclosure of Invention

In view of this, the present invention provides the following technical solutions:

a power marketing service operation index design method comprises the following steps:

defining basic index items, managing basic index database and configuring algorithm rules to realize unification of calculation and storage of service operation indexes;

performing index model design, index calculation and index sharing service configuration to realize one-time processing and multi-place sharing of service operation index data;

and establishing a business operation index asset directory and configuring specific indexes of the power marketing business operation, and realizing service registration, external service release and call and value evaluation of index services.

Optionally, the performing of basic index item definition, basic index library management, and algorithm rule configuration includes:

after analyzing all operation services, performing index item definition on a basic index item, wherein the definition content of the index item definition comprises a basic index item category, a basic index item name and a basic index item code;

configuring corresponding management functions for all the basic index items, wherein the management functions comprise manual filling, auditing and data generating functions aiming at each basic index item, a function of providing basic index calculation process data and result data and a function of providing index model management;

and providing a function of managing the calculation rules of single or multiple basic index items, wherein the management of the calculation rules comprises the functions of creating, modifying, issuing and inquiring the index rules.

Optionally, the configuring of the index model design, the index calculation, and the index sharing service includes:

based on the configuration content of the basic configuration module, carrying out hierarchical management on an electric power marketing business operation index model, wherein the electric power marketing business operation index model at least comprises a shared detail layer model, a shared summary layer model and an analysis layer index model;

performing index processing based on the definition, algorithm rule and model of each basic index item, wherein the index processing at least comprises task configuration, data acquisition, index calculation and timing refreshing of the basic index items;

and providing a uniform access service of the index result data of the basic index item, wherein the uniform access service at least comprises the functions of inquiry, release, real-time push, subscription and management.

Optionally, the shared summary layer model includes a shared summary layer dimension model and a shared summary layer fact table model.

Optionally, the establishing a business operation index asset directory and configuring a specific index of the power marketing business operation include:

establishing a business operation index asset directory at least comprising index directory identification, index directory maintenance, index directory release and index directory deletion;

and configuring specific indexes of the operation of the electricity marketing service, wherein the specific indexes at least comprise an income class, a traffic class, a user class, a derivative class, an activity class and a content class.

An electric power marketing business operation index design device comprises:

the basic configuration module is used for defining basic index items, managing basic index database and configuring algorithm rules so as to realize the unification of the calculation and storage of the service operation indexes;

the data processing module is used for designing an index model, calculating indexes and configuring index sharing services so as to realize one-time processing and multi-place sharing of service operation index data;

and the service management module is used for establishing a business operation index asset directory and configuring specific indexes of the power marketing business operation, and realizing service registration, external service release and call and value evaluation of index services.

Optionally, the basic configuration module includes:

the index definition module is used for performing index item definition on a basic index item after analyzing all operation services, and the definition content of the index item definition comprises a basic index item category, a basic index item name and a basic index item code;

the index management module is used for configuring corresponding management functions for all the basic index items, and comprises the functions of manual filling, auditing and data generation aiming at each basic index item, the function of providing basic item index calculation process data and result data and the function of providing index model management;

and the rule configuration module is used for providing a function of managing the calculation rules of the single or the plurality of basic index items, and the management of the calculation rules comprises the functions of creating, modifying, issuing and inquiring the index rules.

Optionally, the data processing module includes:

the model design module is used for carrying out hierarchical management on the electric power marketing business operation index model based on the configuration content of the basic configuration module, and the electric power marketing business operation index model at least comprises a shared detail layer model, a shared summary layer model and an analysis layer index model;

the index calculation module is used for carrying out index processing based on the definition, the algorithm rule and the model of each basic index item, wherein the index processing at least comprises task configuration, data acquisition, index calculation and timing refreshing of the basic index items;

and the sharing service module is used for providing a uniform access service of the index result data of the basic index item, and the uniform access service at least comprises the functions of inquiry, release, real-time push, subscription and management.

Optionally, the service management module includes:

the system comprises a catalog establishing module, a catalog identification module, a catalog maintenance module, a catalog deletion module and a catalog deletion module, wherein the catalog establishing module is used for establishing a business operation index asset catalog at least comprising index catalog identification, index catalog maintenance, index catalog release and index catalog deletion;

and the index configuration module is used for configuring specific indexes of the operation of the power marketing service at least comprising income class, traffic class, user class, derivative class, activity class and content class.

Compared with the prior art, the embodiment of the invention discloses a method and a device for designing the operation indexes of the power marketing service, wherein the method comprises the following steps: defining basic index items, managing basic index database and configuring algorithm rules to realize unification of calculation and storage of service operation indexes; performing index model design, index calculation and index sharing service configuration to realize one-time processing and multi-place sharing of service operation index data; and establishing a business operation index asset directory and configuring specific indexes of the power marketing business operation, and realizing service registration, external service release and call and value evaluation of index services. The realization establishes a unified, standard and sharable power marketing service operation index data system, avoids redundant index data and saves storage cost; moreover, based on the implementation scheme, the data can be managed and traced from the business architecture design to the model and from the data research and development to the data service, repeated construction can be avoided, powerful data support is provided for planning and developing the power marketing business operation, and the power marketing business operation quality and efficiency are greatly improved.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.

FIG. 1 is a flowchart of a method for designing an operation index of a power marketing service according to an embodiment of the present invention;

FIG. 2 is a first processing flow chart of a power marketing service operation index design method disclosed in the embodiment of the present invention;

FIG. 3 is a second processing flow chart of the method for designing the operation index of the power marketing service according to the embodiment of the present invention;

FIG. 4 is a third processing flow chart of the method for designing the operation index of the power marketing service according to the embodiment of the present invention;

fig. 5 is a schematic structural diagram of an electric power marketing service operation index design device disclosed in the embodiment of the present invention.

Detailed Description

For the sake of reference and clarity, the descriptions, abbreviations or abbreviations of the technical terms used hereinafter are summarized as follows:

electric power marketing: electric power marketing is that in the changing market environment of electric power enterprise, with the purpose of satisfying people's electric power consumption demand, through electric power enterprise's a series of relevant business activities in market, provide the electric power product and the corresponding service that satisfy the consumption needs to realize the target of enterprise. The essence of power marketing is to adjust the demand level and the demand time of a power market, meet the reasonable power utilization requirement of users with good service quality, realize mutual coordination between power supply and demand, establish a cooperative partner relationship between power enterprises and users, promote the users to actively change consumption behaviors and power utilization modes, improve power utilization efficiency and further increase the benefits of the enterprises.

The power customer: organizations or individuals that legally establish power supply and utilization relationships with power supply enterprises are referred to as power customers.

And (4) service operation: aiming at different user groups, business marketing is carried out through operation modes such as users, products, activities, contents, channels and the like, and business operation means, product functions, user experience and the like are optimized through data indexes.

The operation indexes are as follows: the method comprises the steps of defining service operation data indexes, creating a data reporting channel and a rule flow, promoting efficient realization of data requirements, monitoring data such as user operation, product operation, activity operation, content operation and channel operation, deeply digging reasons of data change, providing data basis for decision making, and finally achieving a set target of service operation by data-driven growth.

ETL: the abbreviation of Extract-Transform-Load in english is used to describe the process of extracting (Extract), converting (Transform), and loading (Load) data from a source end to a destination end. The term ETL is more commonly used in data warehouses, but its objects are not limited to data warehouses.

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

Fig. 1 is a flowchart of a method for designing an operation index of a power marketing service according to an embodiment of the present invention, and as shown in the diagram, the method may include:

step 101: and defining basic index items, managing basic index database and configuring algorithm rules to realize the unification of calculation and storage of the service operation indexes.

The definition of the basic index item refers to that the basic index item is defined after analyzing user operation, product operation, activity operation, content operation, channel operation, customer service type business and the like, and the basic index item comprises basic information such as basic index classification, name, code and the like.

Basic index library management, namely establishing management of basic indexes such as user operation, product operation, activity operation, content operation, channel operation, customer service and the like, wherein the basic index library management needs to provide manual index filling application and verification functions, provide index calculation process data and result data and provide an index model management function of an index library. The index model can include but is not limited to contents such as a shared detail layer model, a shared summary layer dimension model, a shared summary layer fact table model, an analysis layer index model and the like.

And (3) algorithm rule configuration, namely, comprehensively managing single or composite index calculation rules of user operation, product operation, activity operation, content operation, channel operation, customer service and the like based on index definition, and providing functions of creating, modifying, releasing, inquiring and the like of the index rules.

Step 102: and performing index model design, index calculation and index sharing service configuration to realize one-time processing and multi-place sharing of the service operation index data.

The index model design, namely the hierarchical management of the electric power marketing service operation index model is realized based on the index rule, and mainly comprises a detail layer, a sharing layer and an analysis layer model design. The index rule is an index calculation rule; and associating elements in the formula with the database table and the fields according to an index calculation formula defined in the index definition, and generating an index calculation rule.

And index calculation, namely, index processing is carried out based on the definition, rules and models of user operation, product operation, activity operation, content operation, channel operation and customer service indexes, and the index calculation comprises the functions of task configuration, data acquisition, index calculation, timing refreshing and the like of the indexes.

The index sharing service, namely, the unified access service for providing index result data, comprises the functions of querying, publishing, pushing in real time, subscribing, managing and the like of core index services such as user operation, product operation, activity operation, content operation, channel operation, customer service and the like.

Step 103: and establishing a business operation index asset directory and configuring specific indexes of the power marketing business operation, and realizing service registration, external service release and call and value evaluation of index services.

The power marketing service operation index asset directory refers to functions of automatic identification, index release, index maintenance, index deletion and the like of an index asset directory providing operation indexes such as income classes, service volumes, user classes, derivation classes, activities and content classes.

The design method of the electric power marketing business operation index of the embodiment constructs a unified, standard and sharable electric power marketing business operation index data system, avoids redundant index data and saves storage cost; moreover, based on the implementation scheme, the data can be managed and traced from the business architecture design to the model and from the data research and development to the data service, repeated construction can be avoided, powerful data support is provided for planning and developing the power marketing business operation, and the power marketing business operation quality and efficiency are greatly improved.

With reference to the content of the foregoing embodiment, fig. 2 shows a first processing flow of the power marketing service operation index design method, and with reference to fig. 2, the performing basic index item definition, basic index library management, and algorithm rule configuration may include:

step 201: after analyzing all the operation services, performing index item definition on the basic index item, wherein the definition content of the index item definition comprises the category of the basic index item, the name of the basic index item and the code of the basic index item.

Step 202: and configuring corresponding management functions for all the basic index items, wherein the management functions comprise the functions of manual filling, auditing and data generation aiming at each basic index item, the function of providing basic index calculation process data and result data and the function of providing index model management.

Step 203: and providing a function of managing the calculation rules of single or multiple basic index items, wherein the management of the calculation rules comprises the functions of creating, modifying, issuing and inquiring the index rules.

For ease of understanding, the following detailed description of the above process flow is provided:

1. definition of basic index items

In practical application, according to specific service conditions, the definition and calculation rules of basic index items need to be unified, and the basic attributes, the index calibers and the like of indexes are specified, including the functions of index item planning, naming specification, index maintenance and the like.

(1) Planning of index items

The index item planning comprises the contents of data domain division, business process analysis, time period planning, modifier planning, dimension and attribute planning, core index planning, extended index planning and the like.

Data domain division: and the data domain division determines the data domain of the index and classifies the index. When the data domain is divided, the method can cover all current service requirements, and can be included in the existing data domain and expanded without influence when a new service enters.

The data domain division can be divided into three levels, namely index major class, index minor class, analysis subject and the like. The index large-class division is to comb index logic rules and define the index large classes of indexes, including platform indexes and business indexes. The index subclass division is to comb index logic rules and define index subclasses of indexes, including power supply service, channel popularization, business operation, user operation, content operation and the like. The analysis theme division is used for combing the index logic rule and defining the analysis theme of the index.

Analyzing a business process: providing an online business process planning function and determining the business process of the index. The business process is an irreparable action event and business activity event in the enterprise, and the business process comprises the steps of ordering, paying and refunding.

And (4) index coding carding is used for defining index coding of the index, and the index is automatically generated according to coding rules. Index name combing defines index names of indexes. The index description is associated with the definition of the index description of the index.

Planning a time period: and providing an online time period planning function and determining the statistical period of the index. The time period specifies the time range or time point of the data statistics, such as the last 30 days, the natural week, the day of the day, etc.

And (4) planning modifiers: and providing an online modifier planning function and determining modifiers of the indexes. A modifier is an abstract division of modifiers such as payment type (modifier) of a payment field (data field) encompassing a first payment application name, a second payment application name, etc.

Dimension and attribute planning: and providing an online dimension and attribute definition function, and determining the dimension and attribute of the index. The dimension reflects a class of attributes of the business, and a set of such attributes constitutes a dimension, which may also be referred to as an entity object, such as a geographic dimension (including provinces, regions, counties, etc.), and a time dimension (including years, seasons, months, weeks, days, etc.).

Analyzing the logic rule of the region combing index, and defining the analysis region of the index, wherein the logic rule comprises the following steps: national/province/city/county (district). The customer type combing index logic rule defines the customer type of the index, and comprises the following steps: total/high/low/personal/business. And (4) analyzing a channel combing index logic rule, and defining an analysis channel of the index.

And (3) core index planning: providing an online core index definition function, and determining a core index, wherein the core index is a minimum and non-differentiable measurement based on a certain business behavior and has a noun with a clear business meaning, such as the bill amount of the electric charge.

And (3) expanding index planning: the method comprises the steps of providing an online extension index definition function, determining an extension index, wherein the extension index is an index which is based on a core index, has a certain time period and a plurality of additional modification definitions and is generally used as a definition of a core index service statistical range. If the core indicator is the payment amount, the extension indicator is the amount paid by the customer through the first payment application on the last 1 day.

(2) Naming convention

The naming specification comprises the specifications of business process, core index, modifier, expansion index and the like. The term maintenance provides a general term function in the definition process of the online maintenance basic index item. The name of the index can be abbreviated as English, and can also be English, and when the index English name is too long, the name can be named by the first letter of Chinese pinyin.

And (3) service process: the name of English: english or English abbreviations or Chinese pinyin shorthand; the name of Chinese: the specific business process is Chinese; the following steps are described: the business process is described in detail.

The core indexes are as follows: the name of English: action + metric, automatically generated; the name of Chinese: action + metric, generated automatically. When the core index is defined, a business process must be selected.

And combing the index logic rule by the associated data table, and defining the associated data table of the index. And combing the index logic rule by the calculation formula, and defining the calculation formula of the index.

Modifier: the time period is named in english, has two bits of length, for example 3d for the last 3 days, and the like, and is selected from the term specification. Other modifiers only have Chinese names, and can self-define the Chinese names.

Modifier-measurement unit combing index logic rules to define the measurement unit of the index, including but not limited to: household, secondary, individual, human, hour, second, day, kilowatt-hour, yuan, etc. The data precision carding index logic rule defines the data precision of the index, and comprises the following steps: integer, decimal 2 bits later. Updating a frequency combing index logic rule, defining the updating frequency of the index, and comprising the following steps: hour, day, 5 seconds, 5 minutes, 1 minute, week, month, 15 minutes. Analyzing the granularity combing index logic rule, and defining the analysis granularity of the index, wherein the definition comprises the following steps: hour, day, 15 minutes, week, month.

Expanding indexes: the name of English: the core index English name + time period + sequence number is automatically generated; the name of Chinese: and the time period, other modifiers and the core index are automatically generated.

(3) Index maintenance

The index maintenance comprises basic index query, basic index newly-increased application, basic index newly-increased examination and approval, index newly-increased application, index newly-increased examination and approval, index stop application, index stop examination and approval, index modification application, index modification examination and approval and the like.

Basic index query: the method calls an electric power marketing service operation index asset directory to inquire basic indexes.

Newly adding a basic index: and applying for newly-added basic indexes and sending the application to the power marketing service operation index asset directory.

Application and approval of basic indexes: the method refers to an approval function for newly added application of basic indexes. After the approval is passed, the subsequent basic index development is carried out by the power marketing service operation index asset directory and is provided for the service index to be used when the service index is formulated.

Newly adding an index: after selecting corresponding basic indexes through the index catalog, setting parameters such as a calculation formula, data precision, a metering unit and the like, and completing the operation of newly adding and applying the service indexes.

Newly adding indexes and approving: and the function of examining and approving newly added application of the indexes.

Index stop application: refers to a function that initiates a decommission application for an index that has not been called for a long time or is no longer used.

Index deactivation approval: the application approval function is disabled for the index.

Index modification application: the function of initiating modification application of the index rule to the index with disputed calibration definition is indicated, and the function comprises maintenance application to attributes such as a calculation formula, data precision, a measurement unit and the like.

Index modification approval: and the examination and approval function is used for modifying and applying attributes including a calculation formula, data precision, a measurement unit and the like in the index.

Of course, the processing content defined by the basic index item in the present application is not limited to the foregoing several items, and in an actual application situation, relevant configuration may be performed according to the needs of the field.

2. Basic index library management

The basic index library management comprises basic index classification management, basic index maintenance, basic index deletion, basic index management and the like.

(1) Base index classification management

The method realizes unified management and maintenance of the classification of the basic indexes, and comprises the functions of basic index classification maintenance, auditing, inquiring and the like.

And (3) basic index classification maintenance: the method realizes centralized management and maintenance of basic index classification, and provides functions of inquiry, addition, modification and deletion of classification.

And (4) classification and audit of basic indexes: the method realizes centralized management and maintenance of basic index classification, and provides an auditing function for judging whether the newly added classification meets the standard or not.

Basic index query: and checking all the defined basic indexes.

(2) Base indicator maintenance

The method realizes the uniform maintenance of the basic indexes, including advanced query of the basic indexes, audit of the basic indexes, modification of definition information of the basic indexes, modification of classification of the basic indexes and the like.

Advanced query of basic indexes: the combined query of whether the basic indexes are cancelled or not through the classification of the basic indexes, the newly added time, the names of the basic indexes is realized.

And (4) auditing basic indexes: and auditing the normalization of the newly added basic indexes and judging whether the newly added basic indexes can be called as a service interface or not.

Modifying basic index definition information: the modification of relevant information such as data fields, time periods, modifiers, dimensions, attributes, core indexes, extension indexes and the like defined by the basic indexes is realized.

Modifying the classification of the basic indexes: and modifying the index classification to which the basic index belongs.

(3) Base indicator deletion

The basic index deletion comprises the contents of basic index cancellation inquiry, basic index cancellation verification, basic index cancellation and the like.

And (3) logging out basic index query: the method and the device realize the query of the cancelled basic indexes in the power marketing service operation index asset directory.

And (5) logging off basic index auditing: and auditing the service value of the cancelled basic index and judging the necessity of storage.

Canceling basic index deletion: and deleting the unregistered basic indexes which are not required to be stored.

(4) Index model management

The index model management comprises the contents of process control, version management, model source tracing and the like of the index model.

Process management and control: the method supports the data model change control process and provides online, whole-process and flow change management from design, submission, review, release and implementation to extinction of the data model.

Version management: the versioning management of the data models of each system is realized, version number and version change detail information are automatically generated, and management personnel of the data models can be assisted to manage the data models of different versions.

Model tracing: the data model design state at any time point and the requirement of data model design change are traced back, so that effective control and management of each system data model are realized, and the control capability of a user on the data model is enhanced.

Similarly, the processing content of the basic index classification management is not fixedly limited, and the corresponding processing or management content in practical application can be set to be richer.

3. Algorithm rule configuration

The algorithm rule configuration comprises index metadata identification, data structure mapping, scheduling task configuration, calculation rule maintenance and the like. The index metadata is descriptive information of data and information resources, and describes original information of the index data, and contents such as conversion description, data mapping, access authority and the like.

(1) Index metadata identification

Metadata access source adaptation: and the adaptive capacity of the related metadata of a relational database, a big data platform and an ETL tool.

And (4) metadata classification: and the management and maintenance of the metadata according to the classification are supported, and the metadata are supported to be displayed in a grading way according to the dependency relationship.

Version management: metadata version management is supported, version number and version change detail information are automatically generated, and management of metadata of different versions can be assisted by data model management personnel.

Relationship management: and automatically analyzing metadata in the ETL script, automatically establishing the relationship between the metadata and the data entity, and supporting the metadata relationship maintenance function.

(2) Data structure mapping

Mapping and associating the database table description, the table name, the field name and the field type, carrying out data standard definition such as a service plate, a data field, a service process, a modifier, a time period, a modifier, a dimension and the like, and supporting online development of an index model.

(3) Scheduling task configuration

And the overall process task of index data development is visually configured, and operations such as query, addition, deletion, modification and the like are supported. The index data development tasks comprise an ETL task, a data synchronization task, a model algorithm task, data desensitization and other tasks.

Scheduling task query: and inquiring the scheduling task according to the condition, and displaying detailed information of the task.

Scheduling task addition: and adding a new scheduling task, and processing the stop state after the task addition is completed.

And (3) scheduling task modification: dynamically modifying task state, suspending/resuming task, terminating running task, and taking effect immediately.

Scheduling task deletion: when the task state is inactive, the scheduled task may be deleted.

(4) Computation rule maintenance

The calculation rule maintenance comprises the contents of rule pre-generation, rule configuration, rule maintenance, rule release and the like.

Rule pre-generation: and according to an index calculation formula defined in the index definition, associating elements in the formula with a database table and fields, and automatically generating an index calculation rule.

Rule configuration: and providing an online index calculation formula configuration function.

And (3) rule maintenance: the method comprises the steps of associating elements in a formula with a database table and fields according to an index calculation formula defined in an index definition, configuring the index calculation formula on line, automatically generating an index calculation rule, and providing operations such as inquiry, addition, deletion, modification and the like.

And (3) rule release: and after the configuration of the index calculation rule is finished, issuing the index rule, automatically calling index calculation through an index scheduling task, generating index data according to an index model, and calling the index data by a front-end application through an index sharing service.

With reference to the content of the foregoing embodiment, fig. 3 shows a second processing flow of the power marketing service operation index design method, and with reference to fig. 3, the performing index model design, index calculation, and configuration of the index sharing service may include:

step 301: and carrying out hierarchical management on the electric power marketing business operation index model based on the configuration content of the basic configuration module, wherein the electric power marketing business operation index model at least comprises a shared detail layer model, a shared summary layer model and an analysis layer index model.

The shared summary layer model comprises a shared summary layer dimension model and a shared summary layer fact table model.

Step 302: and performing index processing based on the definition, the algorithm rule and the model of each basic index item, wherein the index processing at least comprises task configuration, data acquisition, index calculation and timing refreshing of the basic index items.

Step 303: and providing a uniform access service of the index result data of the basic index item, wherein the uniform access service at least comprises the functions of inquiry, release, real-time push, subscription and management.

1. design of index model

The index model design comprises a shared detail layer model, a shared summary layer dimension model, a shared summary layer fact table model, an analysis layer index model and the like.

(1) Shared detail layer model

The detail layer cleans and integrates the data of the source layer, forms detail data with unified model and consistent data, and the design of the data model of the detail layer comprises the steps of data source tracing, data change control, model domain division, logic data model design, physical model design and the like.

Data tracing: and on the basis of the source system model, a source service system for identifying the table data is added for data tracing.

Data change management and control: and on the basis of the source system model, data change identification, access time and update time are increased, and data change management and control are realized.

Model domain division: the detail layer model carries out domain management according to a global model division rule, the first-level domain is a customer domain, the second-level domain is a customer domain, metering, payment, customer service, customer public, an electronic mall, electricity charging (changing) service, comprehensive energy service and energy efficiency service, and the customer, customer service and metering domain in the second-level domain need to be designed in a key mode.

Designing a logic data model: the analyzed model is required to be expanded and perfected, analysis and discussion are carried out on cross-professional data objects in a universe core business object list based on design results of all business field design groups, and the data model is standardized, unified in meaning, de-duplicated, merged, integrated and split.

Designing a physical data model: and converting the entities and the attributes into data tables and fields of a physical data model, and converting the relationship between the entities in the logic model into a main foreign key relationship between the tables. According to the typical design of a source end service system, the physical data model design is completed according to the characteristics of a database product on the basis of meeting the three-model standardization requirement by combining with the service application requirement. And finally, finishing the mapping relation combing of the entities, the attributes and the tables and the fields.

(2) Shared summary level dimension model

The summary layer generates summary data such as storage index data (core indexes and extension indexes), dimension data, light summary data and wide table data according to the detailed layer data, the summary layer model is designed by taking requirements as driving, dimensions and indexes are identified, a fact table and a dimension table are designed and formed, and the model is continuously iterated and perfected along with the change of application requirements in the future. The main process comprises the following steps:

selecting the existing dimension or the newly-built dimension: the index model must guarantee uniqueness of the dimension. If the dimension is newly created, the dimension can be obtained in a report, or the dimension or dimension attribute can be found in a conversation with business personnel. As they often appear within the "by" (by) statement in a query or report request. For example, if a user wants to view sales "by" month and product, then the natural methods used to describe their business should be included in the dimension model as dimensions or dimension attributes.

Determining a main dimension table: typically selected from a source tier, such as a power customer profile.

Determining a relevant dimension table: according to the service combing, determining which tables are associated with the main dimension table, and selecting some tables to generate dimension attributes, such as customer address and customer protocol.

Determining the dimension attribute: the method mainly comprises two stages, wherein the first stage is to select dimension attributes from a main dimension table or generate new dimension attributes; the second stage is to select dimension attributes from the associated dimension table or to generate new dimension attributes.

(3) Shared summary level fact table model

The sharing summary level fact table model process comprises the following steps:

selecting a service process and determining a fact table type: after the business requirements are clarified, the whole life cycle of the business is analyzed, and key business steps are clarified, so that business processes related to the requirements are selected, and the fact table type is determined. Such as selecting the business process of payment by the buyer, the fact table should be a single-transaction fact table containing only the business process of payment by the buyer.

Statement granularity: the finest level of atomic granularity should be chosen as much as possible to ensure the greatest flexibility in the application of fact tables. For example, for the order process, the granularity may be defined as the finest order level.

Determining the dimension: after the granular declaration is completed, meaning that the primary key determines that dimension information that can describe the environment in which the business process is clearly located should be selected. For example, in the order payment transaction fact table, the granularity is a sub-order, and the related dimensions are dimensions of a buyer, a seller, a commodity, a receiver information service type, order time and the like.

Determining the fact: all facts relevant to the business process should be selected and the granularity of the facts is to be consistent with the granularity of the declared fact table.

Redundant dimension: in the design of a fact table model of big data, the use efficiency of a downstream user is improved, the complexity of data acquisition is reduced, and the number of associated tables is reduced. Therefore, the common dimension which is convenient for downstream users to use is redundant in the fact table, so that operations of filtering query, controlling aggregation hierarchy, sorting data, defining master-slave relationship and the like of the fact table are realized.

According to different types of fact tables, respective design methods are refined for three fact tables:

transaction fact table: the transaction fact table is used for tracking individual behaviors defining a business process, provides analysis capability, and is used as detail data of a data warehouse atom and divided into a single transaction fact table and a multi-transaction fact table. The single-transaction fact table is a fact table of one business process, and the multi-transaction fact table is a fact table of a plurality of business processes.

The transaction fact table design principle needs to follow: the integrity of the fact, as much as possible obtains the measurement of the business process; fact consistency, like unit price and quantity, can redundantly store the total amount, and can keep the measurement consistency in the fact table; the fact is additive, percentage data (profit margin, sharing proportion and the like) are not required to be stored as much as possible, and the percentage data are divided into original calculation data; when the granularity is consistent with the dimension, selecting a plurality of transaction fact tables as much as possible; when the single business process has more facts, the single business implementation table is selected as much as possible.

Periodic snapshot fact table: the periodic snapshot fact table is used for sampling the measurement of the entity in a determined interval and carrying out state measurement and is divided into a single-dimensional periodic snapshot fact table and a multi-dimensional periodic snapshot fact table. For example, the single-dimensional snapshot fact table is generated by calculating the amount of the order from the current day to the current day of the seller, and the multi-dimensional snapshot fact table is generated by increasing the buyer granularity on the basis. First, the snapshot granularity, sampling granularity and period need to be determined, for example, for each day of the seller to sample; status metrics are then determined, such as vendor history to date, payment summary, and are determined according to granularity.

Cumulative snapshot fact table: the accumulated snapshot fact table is used for a series of scenes of business processes with short life cycles with clear start and stop time, and the time intervals among the business processes are calculated to form a detailed data table of the multidimensional generalization fact.

(4) Index model of analysis layer

The analysis layer stores personalized statistical data of data products, the personalized statistical data is processed and generated according to the summary data and the detail data of the sharing layer, statistical dimension data which are not particularly general can be placed in the layer, the statistical dimension data are constructed according to the mode of subject domains such as customers, channels and industries, data statistics is carried out on the basis of the summary data or the detail data of the sharing layer in a specific service scene according to different statistical granularities, and the statistical data are stored in a physical table in a broad-table mode to form an index model of the service scene.

2. Index calculation

The index calculation comprises the contents of task execution, data acquisition, index calculation, timing refreshing and the like.

(1) And (3) task execution: the task execution needs to consider flexible scaling and task monitoring.

Elastic expansion: and executing the data development task in a timing triggering mode according to the task configuration in the data development process, and providing rich routing strategies to flexibly allocate resources according to the task running condition. The task trigger is to execute the data development task in a timing trigger mode according to the task configuration in the data development process. Distributed execution is to provide distributed execution according to task execution conditions. The routing strategy can provide rich routing strategy to flexibly allocate resources.

And (3) task monitoring: the whole data development process is used for monitoring tasks such as an ETL task, a data synchronization task, a model algorithm task, data desensitization and the like. By monitoring and scheduling the running condition of the data development task in real time, the task is ensured to be accurately executed and not to be blocked.

(2) Data acquisition

The data acquisition comprises the contents of data acquisition, data source configuration, synchronous content configuration, synchronous mechanism configuration, synchronous frequency configuration, synchronous exception handling and the like.

Data source configuration: and carrying out data configuration on the temporary data. The data source is formed by processing and processing data through an ETL tool. And configuring data sources of the data source according to the requirements of the application scene, the use period, the display frequency and the like of the data.

And (3) synchronous content configuration: synchronizing content is the content configuration from the aspects of business scenarios, functional descriptions, interface requirements, etc. And outputting the synchronized content according to the data service and product requirements, and simultaneously finishing secondary processing of the internal data.

And (3) configuring a synchronization mechanism: the synchronization mechanism is used for synchronizing contents to be synchronized according to a preset mode, and the data synchronization mechanism comprises a real-time synchronization mode and an asynchronous synchronization mode. And configuring real-time temporary data by adopting a real-time synchronization mechanism, and configuring data with lower timeliness by adopting an asynchronous synchronization mode.

And (3) synchronous frequency configuration: the data synchronization frequency is determined according to the timeliness of the data, and the frequency for configuring the synchronous data comprises real time, 5min, 1hour, 1day and 1 month. And the data service and the product acquire corresponding synchronous data according to the service requirements.

Synchronous exception handling: by means of a distributed exception handling mode, after distributed operation, the operation conditions of all sub-services can be checked in an interface history log, the sub-services with operation errors exist, color labeling is carried out, and the operation errors of the task are shown. And the data which is abnormally synchronized is subjected to breakpoint continuous transmission in a manual trigger execution mode.

(3) Index calculation

The index calculation comprises the contents of data temporary combination, data grouping, field mapping, data sorting, data filtering, offline desensitization, online desensitization and the like.

And (3) temporarily merging data: and extracting the required data of data development from the source database to the temporary database, and developing the integrated and combined data.

Data grouping: grouping the data according to the temporary data requirement to be developed from dimensions such as data type, life cycle and the like, and respectively storing the data in different databases.

And (3) field mapping: when data are merged, under the condition that the temporary data are heterogeneous with the source data, the configuration can be carried out according to the field names of the source data end and the temporary database and the heterogeneous field mapping rule.

Data sorting: and (4) sequencing the temporary data according to a configuration rule by developing the characteristic configuration of the temporary data field for the data.

And (3) data filtering: and filtering useless fields or invalid data by configuring a filtering rule for the development temporary data.

Off-line desensitization: when the data service is provided for the third party, the real-time requirement is low, and the data can be extracted to the temporary storage area. And (4) isolating the desensitized temporary data storage from the source data source, and ensuring the security of the source database.

Online desensitization: when data service is provided for a third party, a scene with high real-time requirement is realized, and online real-time desensitization of data of the data access interface is realized through configuration of a data desensitization format and a desensitization rule.

(4) And according to an index refreshing frequency rule configured in the index rule and synchronous frequency configuration in task configuration, calculating the index in real time according to an index model, and pushing the index to the front end for presentation in real time through an index sharing service to realize a timing index refreshing function.

3. Index sharing service

The index sharing service comprises index service inquiry, index service release, index real-time push, index service subscription, index service management and the like.

(1) Index service query

The method comprises the steps that index data query is provided externally in a mode of providing a unified interface, a data demand party sends a request to a unified index query interface server side of an electric power marketing service operation index asset directory through an agreed data query interface specification, the server side sends an analyzed data request to index calculation nodes of the electric power marketing service operation index asset directory according to the interface specification, and then feedback results of the calculation nodes are fed back to the data demand party in an agreed mode.

(2) Index service publishing

According to the requirements of each business department, the data of the power marketing business operation index asset directory is rapidly packaged into a data service interface, authority control and data desensitization are carried out on service contents, the safety of the service contents is guaranteed, the service contents are released to a sharing portal in a one-key mode, and services are displayed in a service directory mode for subscribing services of each unit and each channel.

(3) Real-time index pushing

The pushing service of the real-time index mainly provides real-time index support for an operation management system and a monitoring and early warning system, a business system subscribes the required index in a subscription mode according to business requirements, and an electric power marketing business operation index asset directory pushes data for each business system in real time according to the subscription by using index data integration coding specifications. The real-time pushing provides interaction of messages among different applications mainly in a message queue mode, provides message routing and guarantees message transmission, is used for solving the problems of application coupling, asynchronous messages and the like, realizes a high-performance, high-availability, scalable and final consistency framework, and improves the efficiency and reliability of data transmission in a large-scale distributed application environment.

(4) Index service subscription

The index service subscription mainly provides data services such as standard regular data report services, user query services and the like, provides a uniform service portal, a service system registers required data into the data services according to self service requirements and uniformly accesses the data services to the outside, and other application systems can acquire the required data in a service application and subscription mode when needing to use the data services.

(5) Index service management

The management of the power marketing business operation index asset directory index service comprises three parts of service application management, configuration management and service monitoring:

service application management: the data demander submits a data demand application through the operation support platform, after the audit is passed by the service management department, the operation and maintenance management department can execute relevant configuration on the platform according to the audit result, and after the configuration of the platform is confirmed to be completed and relevant data can be provided, the interface specification and the access mode are informed to the data demander.

Configuration management: after receiving a data demand application of an external system, performing function configuration such as authority configuration, parameter configuration, data object configuration, data publishing configuration, real-time data subscription and the like on different demand objects so as to ensure that data is safely and accurately pushed to other service systems.

Service monitoring: in order to ensure the stability and accuracy in the data sharing process, the data and service interaction process between the data and the external system is monitored and managed, and the data publishing and sharing real-time monitoring and management are realized through the configuration of configurable data objects, data publishing, data parameters, data subscription, monitoring content, monitoring frequency and the like.

With reference to the content of the foregoing embodiment, fig. 4 shows a third processing flow of the power marketing service operation index design method, and with reference to fig. 4, the establishing of the asset directory of the service operation index and the configuring of the specific power marketing service operation index may include:

step 401: and establishing a business operation index asset directory at least comprising index directory identification, index directory maintenance, index directory release and index directory deletion.

Step 402: and configuring specific indexes of the operation of the electricity marketing service, wherein the specific indexes at least comprise an income class, a traffic class, a user class, a derivative class, an activity class and a content class.

1. index asset directory creation

The establishment of the index asset directory comprises the contents of index directory identification, index directory maintenance, index directory release, index directory deletion and the like.

(1) Index catalog identification

And after the index calculation generates result data, automatically identifying and generating an index directory according to index classification, specifically describing an index entity from the aspects of basic information, source responsibility confirmation information, open sharing information, data item information and associated information, and constructing an index library facing to each field topic.

(2) Index directory maintenance

And maintenance functions of index directory inquiry, positioning, retrieval, modification and the like are provided. Index directory retrieval provides functions of query, positioning and retrieval of index directories. The index directory addition is to provide an index directory addition function for the index without automatic identification. The index directory maintenance provides the modification maintenance function of the index directory.

(3) Index directory publishing

The index catalog release provides the registration of the index in the data sharing service module, the index catalog can be discovered and called by the application after release, and the called times, called modules, called time and the like of the index are recorded. Index directory registration is a registration function of an index in a data sharing service module. The index directory is issued in a unified service, and the external application can be visible and called according to the configured authority. And index calling and checking data statistics and data checking of the number of times of calling the index, the called module, the calling time and the like.

(4) Pointer directory deletion

After evaluation, the indexes with low value are deleted, after the index directory is deleted, logical filing is carried out, the indexes are cancelled in the data sharing service, other applications are invisible, corresponding scheduling tasks, index calculation and data extraction programs are automatically stopped, and data are automatically filed. And the index directory can be restored and restarted after being deleted.

Filing an index directory: and after evaluation, deleting the indexes with low value, and logically archiving the indexes after the index directory is deleted.

And (3) logging out the index directory: the pointer directory is logged off in the data sharing service and other applications are not visible.

Stopping a scheduling task: the scheduling task, index calculation and data extraction program corresponding to the index automatically stop.

Data archiving: and automatically archiving data corresponding to the index directory.

And (4) index directory recovery: and the index directory can be restored and restarted after being deleted.

And (3) scheduling task recovery: the scheduling task, index calculation and data extraction program corresponding to the index are automatically started.

2. Specific design of electric power marketing operation indexes

And (4) providing a reference design of the electric power marketing operation index, but not limited to the specific design content. Specific electricity marketing operation indexes can include indexes in the aspects of income classes, traffic classes, user classes, derivative classes, activity classes, content classes and the like.

(1) Income index

The online payment stroke index: summarizing and displaying the number of online fees and the index completion percentage of the annual/monthly/daily cycles.

Active user metrics for billing: summarizing and displaying the number of active users for paying in the period of year/month/day and the index completion percentage.

Per capita payment index: and summarizing and displaying the per-capita payment number and the index completion percentage of the annual/monthly/daily equal periods.

And (3) accumulating the payment indexes: the accumulated charge index number and the completion percentage of the year/month/day period are summarized and displayed.

The ratio of same ratio/ring ratio corresponding to the index: summarizing and displaying the same ratio (ring ratio) condition display of each main index.

(2) Traffic class index

Transaction amount indicator completion: summarizing and displaying the number of online transactions and the index completion percentage.

And the bill browsing amount index is as follows: and summarizing and displaying the bill browsing amount and the index completion percentage.

The electric charge settlement amount index: summarizing and displaying the electricity charge settlement stroke number and the index completion percentage.

And (3) completion of business expansion load index: and summarizing and displaying the business expansion loading and the index completion percentage.

And (3) fault repair amount index completion condition: and summarizing and displaying the completion condition of the on-line fault repair proportion index.

And (3) promoting the completion condition of activity index: operation promotion activity and index completion percentage.

Electricity charge settlement unity/ring ratio: and summarizing and displaying the conditions of the same proportion and the ring proportion of the current electric charge settlement amount.

Fault repair amount same ratio/ring ratio: and summarizing and displaying the conditions of the same ratio and the ring ratio of the current fault repair amount.

Business expansion load per ring ratio: summarizing and displaying the conditions of the same ratio and the ring ratio of the current business expansion amount.

(3) User class indicator

Index of the number of registered users: and summarizing and displaying the number of registered users and the index completion percentage.

Real name authentication number index: summarizing and displaying the number of real-name authentication users and the index completion percentage.

Binding the number index of the family: and summarizing and displaying the bound number of the users and the index completion percentage.

The number of reserved users index: summarizing and displaying the number of the reserved users and the index completion percentage.

Loss user number index: summarizing and displaying the number of lost users and the index completion percentage.

Active user number index: summarizing and displaying the number of active users and the index completion percentage.

The loss rate index is as follows: and summarizing and displaying the completion condition of the user loss rate index.

The amount of registered users: and summarizing and displaying the newly added registered user quantity of the operation activities.

The active user amount: the number of active users among the users participating in the activity is summarized and presented.

Number of real name authentications: and summarizing and displaying the user quantity of the new real name authentication of the operation activities.

(4) Derived index

The index proportion condition of the service index is as follows: and summarizing and displaying the completion proportion condition of the business indexes.

Mean condition of service index: and summarizing and exhibiting the average condition of the business indexes.

The accumulated value condition of the service index: and summarizing and displaying the accumulated completion condition of the service indexes.

And the benchmarking condition of the service indexes is as follows: and summarizing and displaying the benchmarking completion condition of the service indexes.

(5) Activity index

Active access volume: and summarizing and displaying the access user amount of the activity.

Activity participation amount: the participating user volumes of the activity are aggregated and presented.

Activity independent visitor volume: user visits for independently participating activities are summarized and presented.

Activity sharing amount: and summarizing and displaying the forwarding sharing quantity of the activity.

Activity conversion rate: and summarizing and displaying the number of the users successfully participating in the activity after being forwarded and shared.

(6) Content index

Content distribution amount: summarizing and displaying the information and the number of advertisements issued.

Content reading amount: and summarizing and displaying the read quantity of each piece of content.

Content sharing amount: and summarizing and displaying the forwarding sharing quantity of the content.

Content heat: summarizing and displaying the attention area popularity, comments, praise, forwarding indexes and the like of the published content.

Content propagation rate: and summarizing and displaying the conditions of successfully participating in comments, praise and retransmission after being forwarded and shared.

According to the method for designing the operation indexes of the power marketing service, provided by the embodiment of the invention, the data standard is unified through the construction of the service operation indexes, the basic indexes are processed at one time and shared at multiple positions, the repeated development of the similar indexes is reduced, and the repeated development cost is reduced; the unified calculation of the basic indexes of each power marketing service is realized, the data storage redundancy can be reduced, the waste of calculation resources and the calculation and storage cost required by voltage drop are avoided; the online development of the business operation statistical index is realized, the research and development resource investment is reduced, and the personnel cost is greatly saved.

While, for purposes of simplicity of explanation, the foregoing method embodiments have been described as a series of acts or combination of acts, it will be appreciated by those skilled in the art that the present invention is not limited by the illustrated ordering of acts, as some steps may occur in other orders or concurrently with other steps in accordance with the invention. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required by the invention.

The method is described in detail in the embodiments disclosed above, and the method of the present invention can be implemented by various types of apparatuses, so that the present invention also discloses an apparatus, and the following detailed description will be given of specific embodiments.

Fig. 5 is a schematic structural diagram of an electric power marketing service operation index design device disclosed in an embodiment of the present invention, and referring to fig. 5, the electric power marketing service operation index design device 50 may include:

and the basic configuration module 501 is configured to perform basic index item definition, basic index library management and algorithm rule configuration, so as to realize unification of service operation index calculation and storage.

The data processing module 502 is configured to perform index model design, index calculation, and configuration of an index sharing service, so as to implement one-time processing and multi-place sharing of service operation index data.

The service management module 503 is configured to establish a business operation index asset directory and configure specific indexes of power marketing business operation, so as to implement service registration, external service release and invocation, and value evaluation of index services.

The electric power marketing business operation index design device of the embodiment constructs a unified, standard and sharable electric power marketing business operation index data system, avoids redundant index data and saves storage cost; moreover, based on the implementation scheme, the data can be managed and traced from the business architecture design to the model and from the data research and development to the data service, repeated construction can be avoided, powerful data support is provided for planning and developing the power marketing business operation, and the power marketing business operation quality and efficiency are greatly improved.

In the above embodiment, the basic configuration module may include: the index definition module is used for performing index item definition on a basic index item after analyzing all operation services, and the definition content of the index item definition comprises a basic index item category, a basic index item name and a basic index item code; the index management module is used for configuring corresponding management functions for all the basic index items, and comprises the functions of manual filling, auditing and data generation aiming at each basic index item, the function of providing basic item index calculation process data and result data and the function of providing index model management; and the rule configuration module is used for providing a function of managing the calculation rules of the single or the plurality of basic index items, and the management of the calculation rules comprises the functions of creating, modifying, issuing and inquiring the index rules.

In the above embodiment, the data processing module may include: the model design module is used for carrying out hierarchical management on the electric power marketing business operation index model based on the configuration content of the basic configuration module, and the electric power marketing business operation index model at least comprises a shared detail layer model, a shared summary layer model and an analysis layer index model; the index calculation module is used for carrying out index processing based on the definition, the algorithm rule and the model of each basic index item, wherein the index processing at least comprises task configuration, data acquisition, index calculation and timing refreshing of the basic index items; and the sharing service module is used for providing a uniform access service of the index result data of the basic index item, and the uniform access service at least comprises the functions of inquiry, release, real-time push, subscription and management.

In the above embodiment, the service management module may include: the system comprises a catalog establishing module, a catalog identification module, a catalog maintenance module, a catalog deletion module and a catalog deletion module, wherein the catalog establishing module is used for establishing a business operation index asset catalog at least comprising index catalog identification, index catalog maintenance, index catalog release and index catalog deletion; and the index configuration module is used for configuring specific indexes of the operation of the power marketing service at least comprising income class, traffic class, user class, derivative class, activity class and content class.

The power marketing service operation index design device in any one of the above embodiments includes a processor and a memory, wherein a basic configuration module, a data processing module, a service management module, an index definition module, an index library management module, a rule configuration module, a model design module, an index calculation module, a shared service module, a directory establishment module, an index configuration module, and the like in the above embodiments are stored in the memory as program modules, and the processor executes the program modules stored in the memory to implement corresponding functions.

The processor comprises a kernel, and the kernel calls the corresponding program module from the memory. The kernel can be provided with one or more, and the processing of the return visit data is realized by adjusting the kernel parameters.

The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.

An embodiment of the present invention provides a storage medium, on which a program is stored, where the program, when executed by a processor, implements the power marketing service operation index design method described in the above embodiment.

The embodiment of the invention provides a processor, which is used for running a program, wherein the power marketing business operation index design method in the embodiment is executed when the program runs.

Further, the present embodiment provides an electronic device, which includes a processor and a memory. Wherein the memory is used for storing executable instructions of the processor, and the processor is configured to execute the power marketing business operation index design method described in the above embodiments via executing the executable instructions.

The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.

It is further noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.

The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may reside in Random Access Memory (RAM), memory, Read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.

The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for designing operation indexes of power marketing business is characterized by comprising the following steps:

2. The power marketing service operation index design method according to claim 1, wherein the performing of basic index item definition, basic index library management and algorithm rule configuration comprises:

3. The electric marketing service operation index design method according to claim 1, wherein the performing of index model design, index calculation and configuration of index sharing service comprises:

4. The power marketing business operation index design method of claim 3, wherein the shared summary level model comprises a shared summary level dimension model and a shared summary level fact table model.

5. The method for designing the operation index of the electricity marketing service according to claim 1, wherein the establishing of the asset directory of the service operation index and the configuring of the operation specific index of the electricity marketing service comprise:

6. An electric power marketing business operation index design device comprises:

7. The electricity marketing service operation index design device according to claim 6, wherein the basic configuration module comprises:

8. The electricity marketing service operation index design device according to claim 6, wherein the data processing module comprises:

9. The electricity marketing service operation index design device of claim 8, wherein the shared summary level model comprises a shared summary level dimension model and a shared summary level fact table model.

10. The electricity marketing service operation index design device according to claim 6, wherein the service management module comprises: