CN115617816B - System for acquiring specified ammeter data table - Google Patents
System for acquiring specified ammeter data table Download PDFInfo
- Publication number
- CN115617816B CN115617816B CN202211465173.1A CN202211465173A CN115617816B CN 115617816 B CN115617816 B CN 115617816B CN 202211465173 A CN202211465173 A CN 202211465173A CN 115617816 B CN115617816 B CN 115617816B
- Authority
- CN
- China
- Prior art keywords
- node
- data
- data table
- display interface
- electric meter
- 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.)
- Active
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/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/248—Presentation of query results
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Arrangements For Transmission Of Measured Signals (AREA)
- Measurement And Recording Of Electrical Phenomena And Electrical Characteristics Of The Living Body (AREA)
Abstract
The invention provides a system for acquiring an appointed electric meter data table, which acquires corresponding target text characteristics according to a target text input by a user, traverses a time section data list according to the target text characteristics, acquires a key text characteristics set, thereby acquiring the appointed electric meter data table and displaying the electric meter data corresponding to the time point in the appointed electric meter data table to the user, so that the user can more intuitively and conveniently watch the required electric meter data on a mobile terminal, and carries out separate storage on the initial data of the electric meter according to the week, month and year, therefore, when a processor searches the electric meter data, the time for traversing the initial data table of the electric meter can be saved, and the time efficiency is improved.
Description
Technical Field
The invention relates to the technical field of ammeter data processing, in particular to a system for acquiring a specified ammeter data table.
Background
In the prior art, usually, a data table recorded by an ammeter can only be clicked and checked at a PC (personal computer) terminal, when a user inconveniently checks the ammeter data by using the PC terminal, all table data can only be obtained on a mobile terminal, the date required to be checked and the ammeter data required to be checked cannot be selected, and the date required to be checked and the ammeter data required to be checked are difficult to find, so that the user inconveniently searches required contents, the time resource of the user is wasted, and the user experience is low; moreover, when the user does not specify the search content, the mobile terminal does not provide a fixed display interface to display the data collected by the electric meter, and the existing display interface is not intuitive, so that a technology for establishing a more intuitive and concise electric meter data display interface of the mobile terminal is urgently needed.
Disclosure of Invention
Aiming at the technical problems, the technical scheme adopted by the invention is as follows:
a system for obtaining a data table for a given electricity meter, comprising: a database, a processor, and a memory storing a computer program, wherein the database comprises: initial data table list a = { a = { (a) 1 ，A 2 ，……，A i ，……，A m Wherein, the initial data table A of the ith meter i ={A i1 ，A i2 ，……，A ij ，……，A in（i） }，A ij =（RA ij ，ZA 1 ij ，ZA 2 ij ，……，ZA r ij ……，ZA s ij ，SA 1 ij ，SA 2 ij ，……，SA r ij ，……，SA s ij ），RA ij For the jth data acquisition time point, ZA, in the initial data table of the ith electric meter r ij Is the r initial field, SA, corresponding to the j data acquisition time point in the initial data table of the ith electric meter r ij Is ZA r ij The value of r is 1 to s, s is the number of initial fields corresponding to the initial data table of the ith electric meter, j is 1 to n (i), n (i) is the number of data acquisition time points in the initial data table of the ith electric meter, i is 1 to m, and m is the number of electric meters; when executed by a processor, the computer program performs the steps of:
s100, based on A, a first time period data list B = { B1, B2,. Eta, bi,. Eta, bm }, wherein the first time period data Bi = { Bi } of the ith electric meter 1 ,Bi 2 ,...,Bi q ,...,Bi Q }，Bi q ={Bi q0 ，Bi q1 ，Bi q2 ，……，Bi qg ，……，Bi qG（q） Is A i Wherein, Q is the total number of weeks contained in the time interval consisting of n (i) data acquisition time points, bi q0 Week ID, bi for the qth week qg Is the g-th data acquisition time point in the q-th week, bi qg ∈{RA i1 ,RA i2 ,...,RA in(i) And G takes values from 1 to G (q), and G (q) is the number of data sampling time points included in the qth week.
S200, based on A, a second time period data list C = { C1, C2,. So., ci,. So., cm }, is obtained, wherein the second time period data Ci = { Ci of the ith electric meter 1 ,Ci 2 ,...,Ci y ,...,Ci Y }，Ci y ={Ci y0 ，Ci y1 ，Ci y2 ，……，Ci yd ，……，Ci yP（y） Is A i In the group consisting of n (i) data acquisition time pointsData corresponding to the Y-th month in the time interval, Y being the total number of months contained in the time interval consisting of n (i) data acquisition time points, ci j0 Month ID, ci for the y-th month yd Is the d-th data acquisition time point in the y-th month, ci yd ∈{RA i1 ,RA i2 ,...,RA in(i) And d takes values from 1 to P (y), which is the number of data sampling time points included in the y-th month.
S300, based on A, a third time period data list D = { D1, D2,. Multidot.,. Di,. Multidot.,. Dm }, is obtained, wherein the third time period data Di = { Di of the ith electric meter is obtained 1 ,Di 2 ,...,Di f ,...,Di F }，Di f ={Di f0 ，Di f1 ，Di f2 ，……，Di fu ，……，Di fU(f) Is A i Wherein, the data corresponding to the F-th year in the time interval composed of n (i) data acquisition time points, F is the total number of years contained in the time interval composed of n (i) data acquisition time points, di f0 Year ID, di corresponding to the f-th year fu Is the u-th data acquisition time point, di, in the f-th year fu ∈{RA i1 ,RA i2 ,...,RA in(i) And U takes values from 1 to U (f), and U (f) is the number of data sampling time points included in the f-th year.
S400, acquiring a target text feature list H = { H) input by a user 1 ，H 2 ，……，H z ，……，H γ }，H z The method is characterized in that the method is the z-th feature of a target text, the value of z is 1 to gamma, gamma is the number of features in the target text, and the target text features comprise: the system comprises a target electric meter identification, a target time period starting point, a target time period end point and a target field.
S500, vectorizing H, traversing B, C and D, and acquiring a key text feature set E = (E) 0 j ，RE 1 ，RE 2 ，...，RE t ，...，RE T ，ZE 1 ，ZE 2 ，...，ZE b ，...，ZE c ），E 0 j For target meter identification, RE t Is the first time period included in the target time periodT data sampling time points, T being 1 to T, T being the number of data sampling time points included in the target time period, ZE b B is the name of the b-th target field included by the target text, the value of b is 1 to c, c is the number of the field names corresponding to the target text, ZE b Is E 0 j One of all initial fields contained in the initial data table of the corresponding electricity meter.
S600, traversing A based on E, and obtaining an electric meter specified data table F = (F) 0 ，RE 1 ，RE 2 ，...，RE t ，...，RE T ，ZE 1 ，ZE 2 ，...，ZE b ，...，ZE c ，SF 1 ，SF 2 ，...，SF b ，...，SF c ），F 0 For specifying electric meter identity, RE t For specifying the t-th data sampling time point, ZE, included in the meter b For specifying the b-th specified field, SF, included in the meter b Is ZE b The corresponding specified field data value.
The invention has at least the following beneficial effects:
(1) The method has the advantages that the corresponding target text characteristics can be obtained according to the target text input by a user, the time zone data list is traversed according to the target text characteristics, the key text characteristics are obtained, the electric meter appointed data list is obtained, the electric meter data corresponding to the time points in the electric meter appointed data list is presented to the user, the user can watch the required electric meter data more visually and more conveniently on the mobile terminal, and the initial data of the electric meter is stored in a separated form according to week, month and year, so that when the processor searches the electric meter data, the time for traversing the initial data list of the electric meter can be saved, and the time efficiency is improved.
(2) The initial ammeter data are displayed in a tree form, so that a user can find needed contents more visually and conveniently in the tree form, for each node with the sub-nodes exceeding the set number, only the set number of the sub-nodes is displayed instead of being completely displayed, a display interface is simpler and more visual, the sub-nodes are displayed for the user in a ceaseless rotation mode, and the experience of the user can be improved; and for different placing forms of the mobile terminal, the number of the nodes displayed at each level can be correspondingly adjusted, and finally, the length and the width of the data table can be correspondingly adjusted so as to enable the display interface to be simpler and more visual.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a schematic flow chart of acquiring a data table of a designated electric meter according to an embodiment of the present invention.
Detailed Description
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 obtained by a person skilled in the art without inventive step based on the embodiments of the present invention, are within the scope of protection of the present invention.
The invention provides a system for acquiring a data table of a designated electric meter, which comprises: a database, a processor, and a memory storing a computer program, wherein the database comprises: initial data table list a = { a = { (a) 1 ，A 2 ，……，A i ，……，A m Wherein, the initial data table A of the ith meter i ={A i1 ，A i2 ，……，A ij ，……，A in（i） }，A ij =（RA ij ，ZA 1 ij ，ZA 2 ij ，……，ZA r ij ……，ZA s ij ，SA 1 ij ，SA 2 ij ，……，SA r ij ，……，SA s ij ），RA ij Is the jth data acquisition time point, ZA, in the initial data table of the ith electric meter r ij Is the r initial field, SA, corresponding to the j data acquisition time point in the initial data table of the ith electric meter r ij Is ZA r ij And the value of r is 1 to s, s is the number of initial fields corresponding to the initial data table of the ith electric meter, j is 1 to n (i), n (i) is the number of data acquisition time points in the initial data table of the ith electric meter, i is 1 to m, and m is the number of electric meters.
In particular, RA ij =（NA ij ，YA ij ，DA ij ），NA ij Is RA ij Corresponding year, YA ij Is RA ij Corresponding month, DA ij Is RA ij The corresponding date.
Further, in the embodiments of the present invention, RA ij -RA i（j-1） =RA i（j+1） -RA ij Can be understood as RA ij The corresponding time point is in hours.
As shown in fig. 1, the computer program, when executed by a processor, performs the steps of:
s100, based on A, obtaining a first time period data list B = { B1, B2,. Multidot.,. Bi,. Multidot.,. Bm }, wherein the first time period data Bi = { Bi } of the ith electric meter 1 ,Bi 2 ,...,Bi q ,...,Bi Q }，Bi q ={Bi q0 ，Bi q1 ，Bi q2 ，……，Bi qg ，……，Bi qG（q） Is A i Wherein, Q is the total number of weeks contained in the time interval consisting of n (i) data acquisition time points, bi q0 Week ID, bi for the qth week qg Is the g-th data acquisition time point in the q-th week, bi qg ∈{RA i1 ,RA i2 ,...,RA in(i) And G takes values from 1 to G (q), and G (q) is the number of data sampling time points included in the qth week.
Specifically, bi q0 =（NBi q0 ，ZBi q0 ），NBi q0 For the corresponding year of the qth week, ZBi q0 The week corresponding to the qth week, for example: NBi q0 2012, ZBi q0 Week 51.
Further, the week ID corresponding to the qth week is a unique identifier of the qth week.
S200, based on A, a second time segment data list C = { C1, C2,. Eta, ci,. Eta, cm } is obtained, wherein the second time segment data Ci = { Ci ] of the ith electric meter 1 ,Ci 2 ,...,Ci y ,...,Ci Y }，Ci y ={Ci y0 ，Ci y1 ，Ci y2 ，……，Ci yd ，……，Ci yP（y） Is A i Wherein the data corresponding to the Y-th month in the time interval consisting of n (i) data acquisition time points, Y is the total number of months contained in the time interval consisting of n (i) data acquisition time points, ci j0 Month ID, ci corresponding to the y-th month yd D data acquisition time point in y month, ci yd ∈{RA i1 ,RA i2 ,...,RA in(i) D takes values from 1 to P (y), and P (y) is the number of data sampling time points included in the y month.
Specifically, ci y0 =（NCi y0 ，YCi y0 ），NCi y0 Year corresponding to month y, YCi y0 For the month corresponding to the y-th month, for example: NCi y0 2021, YCi y0 Month 6.
Further, the month ID corresponding to the y month is a unique identifier of the y month.
S300, based on A, a third time period data list D = { D1, D2,. Multidot.,. Di,. Multidot.,. Dm }, is obtained, wherein the third time period data Di = { Di of the ith electric meter is obtained 1 ,Di 2 ,...,Di f ,...,Di F }，Di f ={Di f0 ，Di f1 ，Di f2 ，……，Di fu ，……，Di fU(f) Is A i Wherein the data corresponding to the F year in the time interval consisting of n (i) data acquisition time points, and F is the data corresponding to the n (i) data acquisition time pointsThe total number of years, di, contained in the time interval of the time points f0 Year ID, di corresponding to the f-th year fu Is the u-th data acquisition time point, di, in the f-th year fu ∈{RA i1 ,RA i2 ,...,RA in(i) And U takes values from 1 to U (f), and U (f) is the number of data sampling time points included in the f-th year.
Specifically, the year ID corresponding to the f-th year is a unique identifier of the f-th year.
S400, acquiring a target text feature list H = { H) input by a user 1 ，H 2 ，……，H z ，……，H γ }，H z The method is characterized in that the method is the z-th feature of a target text, the value of z is 1 to gamma, and gamma is the number of features in the target text, wherein the target text features comprise: the system comprises a target electric meter identification, a target time period starting point, a target time period end point and a target field.
S500, vectorizing H, traversing B, C and D, and acquiring a key text feature set E = (E) 0 j ，RE 1 ，RE 2 ，...，RE t ，...，RE T ，ZE 1 ，ZE 2 ，...，ZE b ，...，ZE c ），E 0 j For target meter identification, RE t The value of T is 1 to T for the T-th data sampling time point included in the target time period, T is the number of the data sampling time points included in the target time period, ZE b B is the name of the b-th target field included by the target text, the value of b is 1 to c, c is the number of the field names corresponding to the target text, ZE b Is E 0 j One of all initial fields contained in the initial data table of the corresponding electricity meter.
Specifically, those skilled in the art know that any method for vectorizing the target text features falls within the scope of the present invention, and will not be described herein again.
S600, traversing A based on E, and obtaining an electric meter specified data table F = (F) 0 ，RE 1 ，RE 2 ，...，RE t ，...，RE T ，ZE 1 ，ZE 2 ，...，ZE b ，...，ZE c ，SF 1 ，SF 2 ，...，SF b ，...，SF c ），F 0 To specify the meter identity, RE t For specifying the t-th data sampling time point, ZE, included in the meter b For specifying the b-th specified field, SF, included in the meter b Is ZE b The corresponding specified field data value.
According to the embodiment of the invention, the corresponding target text feature can be obtained according to the target text input by the user, the time section data list is traversed according to the target text feature set, and the key text feature set is obtained, so that the electric meter specified data table is obtained, the electric meter data corresponding to the time point in the electric meter specified data table is presented to the user, the user can watch the required electric meter data on the mobile terminal more intuitively and conveniently, and the initial electric meter data is stored in a form of dividing the electric meter according to the week, the month and the year, so that when the processor searches the electric meter data, the time for traversing the initial electric meter data table is saved, and the time efficiency is improved.
In another embodiment of the present invention, the specified electric meter data table may be obtained by the following steps:
s1, obtaining a target mobile terminal information set Y = (Y) 0 ，LY 0 ，DY 0 ，XY 0 ），Y 0 Is a target mobile terminal ID, LY 0 Is Y 0 Gravity value, DY, obtained by the corresponding gravity sensing module 0 Is Y 0 Corresponding angle, XY 0 Is Y 0 And displaying the corresponding interface direction.
S2, when XY 0 And when the current display interface direction is the first display interface direction, obtaining a first display interface information set M1= (KM 1, CM 1), where KM1 is a width of a display interface when the target mobile terminal is in the first display interface direction, and CM1 is a length of the display interface when the target mobile terminal is in the first display interface direction, and the length of the first display interface corresponding to the first display interface direction is greater than the width of the first display interface corresponding to the first display interface direction.
Specifically, those skilled in the art know that any method for determining the display interface direction according to the gravity value and the angle value of the mobile terminal falls within the scope of the present invention, and will not be described herein again.
S3, mixing A i And displaying in a tree form on the first display interface, wherein each node is displayed in a circle, and a descriptor of the corresponding node is arranged on the surface of each circle.
Specifically, the descriptor is a time point corresponding to the node.
S3 specifically comprises the following steps:
s31, displaying a root node R in the middle of a first display area of the first display interface n When n > 1, at the root node R n Rear side of (2) shows except for R n The values of n are 1 to w, and w is A i Number of years in the corresponding time point.
Specifically, in the embodiment of the present invention, the root node displayed in the middle position is drawn by a solid line, and the node on the rear side of the root node is drawn by a dotted line.
Further, the root node at the middle position has the same radius as the node at the rear side of the root node.
S32, displaying a node R in a second display area of the first display interface n And the first node in the first level node layer is a month node corresponding to the root node.
Further, in the embodiment of the present application, S32 may further include:
s321, if the first node number S in the first level node layer 0 ≤K 0 Then, displaying each first node of the first level node layer in a first circle in a second display area and each first node is located on a same straight line with a width W, wherein K is 0 =⌊W/(d 1 +L 0 ) ⌋, W = a1 × KM1, a1 being a coefficient less than 1, d 1 Is the diameter of the first circle, L 0 Is the distance between two adjacent nodes of the first level node layer.
Specifically, in the embodiment of the present invention, the first circle is drawn as a solid line.
Further, a person skilled in the art can set the diameter of the first circle according to actual requirements, and details are not described herein.
Further, in the embodiment of the present invention, S 0 =12。
S323, if the first node number in the first level node layer is S 0 ＞K 0 Displaying the first level node layer in a rotating manner on the second display area, and displaying K in a second circle on the front side of the first rotating path 0 A first node displaying K in a second circle on the rear side of the first rotation path 0 -2 nodes, wherein the number of nodes is S when the first node is 0 ＞2*K 0 At time-2, (S) 0 -K 0 ) The first node is displayed in a hidden state.
Specifically, in the embodiment of the present invention, the second circle is drawn by a dotted line.
Further, the second circle has the same diameter as the first circle.
Further, when the hidden node is rotated to the second circular position, the hidden node is changed into the second circular shape, and similarly, when the second circular shape is rotated to the first circular position, the hidden node is changed into the first circular shape, and the two circles are sequentially circulated to show all the nodes.
S325, displaying the v-th level node layer in the (v + 1) th display area of the first display interface, wherein the value of v is from 2 to v 0 Wherein v is 0 The following conditions are met: v. of 0 =⌊C/(d 1 +Lʹ 0 ) ⌋, C = a2 CM1, a2 is a coefficient less than 1, L ʹ 0 Is the distance of the adjacent node between the two node layers.
Specifically, in the present embodiment, the rotation speed and the rotation direction of the circle on any stage node layer are the same.
Further, a person skilled in the art may set the rotation speed and the rotation direction of the circle on the node layer according to actual requirements, and details are not described herein.
Further, the first circle on any level node layer has the same radius as the second circle, and the first circle on any level node layer has the same radius.
S33, displaying the v-th level node layer in the v +1 th display area of the first display interface,v is a value from 2 to v 0 Wherein v is 0 The following conditions are met: v. of 0 =⌊C/(d 1 +Lʹ 0 ) ⌋, C = a2 CM1, a2 is a coefficient less than 1, L ʹ 0 The distance between two adjacent nodes between two node layers;
specifically, a2= a1.
And S4, when detecting that any one node is clicked or slides to the middle position of the first display area, updating each level of nodes displayed on the display interface to each level of nodes corresponding to the clicked or sliding root node.
And S5, when the node in any first-level node layer is detected to be clicked, displaying the clicked node in any first-level node layer at the middle position of the first display area, and updating each level of node of the first display interface to be a lower level node of the clicked node in any first-level node layer.
S6, when the v-th signal is detected 0 When any node in the level node layer is located at the middle position of the first display area, a first final data table list Z = { Z = corresponding to the level-v node at the middle position of the first display area is obtained 1 ，Z 2 ，……，Z e ，……，Z E }，Z e And E is a value from 1 to E of the first final data table corresponding to the E-th acquisition time point, and E is the number of the first final data tables.
Further, the method comprises the following steps of obtaining E:
s61, acquiring the maximum display data table number c ʹ, wherein c ʹ meets the following conditions: c ʹ = ⌊ w ʹ by c ʺ ⌋;
wherein W ʹ = ⌊ W/W 0 ⌋，cʺ=⌊(C-C1)/c 0 ⌋，w 0 Is the width corresponding to the first final data table, C1 is the length corresponding to the first display area, C 0 For the length corresponding to the first final data table, "⌊, ⌋" is the lower integer symbol;
specifically, in the embodiment of the present invention, w 0 ＜c 0 。
S63, acquiring a first time interval t ʹ based on c ʹ, wherein t ʹ = ⌊/c ʹ ⌋;
s65, obtaining E based on t ʹ, wherein E =60/t ʹ.
Specifically, in the embodiment of the present invention, the first final data table is an average value of initial field values in the initial meter data within a time interval t ʺ.
And S7, when any one first final data table is detected to be clicked, the clicked first final data table is used as a specified electric meter data table.
In the embodiment of the present invention, after S1, the following steps are further included to obtain a specified electric meter data table:
s10, when XY 0 And when the current mobile terminal is in the second display interface direction, obtaining a second display interface information set M2= (KM 2, CM 2), where KM2 is a width of a second display interface when the target mobile terminal is in the second display interface direction, and CM2 is a length of the second display interface when the target mobile terminal is in the second display interface direction, and the length of the second display interface corresponding to the second screen direction is smaller than the width of the second display interface corresponding to the second screen direction.
S20, mixing A i And displaying in a tree form on the second display interface, wherein each node is displayed in a circle, and a descriptor of the corresponding node is arranged on the surface of each circle.
S20 specifically comprises the following steps:
s201, displaying a root node R in the middle of a first display area of the second display interface n When n > 1, at the root node R n Rear side of (2) shows except R n And the value of n of the other root nodes is 1 to w, and w is the number of the root nodes in the time point corresponding to the initial electric meter data table.
S203, displaying a node R in a second display area of the second display interface n And the first node in the first level node layer is a month node corresponding to the root node.
Further, in the embodiment of the present application, S203 may further include:
s2031, if the first node number S in the first level node layer 0 ≤Kʹ 0 Then, each node of the first level node layer is displayed in a first circle in a second display areaAnd each node is positioned on the same straight line with the width of W ʹ, wherein K ʹ 0 =⌊Wʹ/(d 1 +L 0 )⌋，Wʹ=a1*KM2。
S2033, if the first node number S in the first level node layer 0 ＞Kʹ 0 Displaying the first level node layer in a rotating manner on the second display area, and displaying K in a second circle on the front side of the first rotating path 0 A first node displaying K ʹ in a second circle at the rear side of the first rotation path 0 -2 nodes, wherein the number of nodes is S when the first node is 0 ＞2*Kʹ 0 At time-2, (S) 0 -K 0 ) The first node is displayed in a hidden state.
Specifically, S2033 may be replaced with the following steps: if the first node number S in the first level node layer 0 ＞Kʹ 0 Obtaining a target first circular diameter d ʹ 1 Wherein d ʹ 1 =⌊Wʹ/12-L 0 ⌋, therefore, all the first nodes can be displayed on the display interface, and the user experience is improved.
S2035, displaying a v ʹ level node layer in a (v ʹ + 1) th display area of the display interface, wherein the value of v ʹ is 2 to v ʹ 0 Wherein v ʹ 0 The following conditions are met: v ʹ 0 =⌊Cʹ/(d 1 +Lʹ 0 )⌋，Cʹ=a2*CM2。
S30, when it is detected that any one node is clicked or any one node slides to the middle position of the first display area, updating each level of nodes of the second display to each level of nodes corresponding to the clicked or sliding root node;
s40, when the node in any node layer is detected to be clicked, the node in any node layer is displayed in the middle of the first display area, and each node of the second display interface is updated to be a lower node of the node in any node layer;
s50, when the v ʹ is detected 0 When any node in the level node layer is in the middle position of the first display area, a second final data table list Z ʹ = { Z ʹ) corresponding to the level node at the v ʹ in the middle position of the first display area is obtained 1 ，Zʹ 2 ，……，Zʹ η ，……，Zʹ θ }，Zʹ η A second final data table corresponding to the eta time acquisition point is obtained, wherein the eta value is from 1 to theta, and theta is the number of the second final data tables;
specifically, the method comprises the following steps of obtaining theta:
s501, acquiring the maximum display data table number c ', c' = ⌊ ⌊ W ʹ/W ʹ 0 ⌋*⌊(C-C2)/cʹ 0 ⌋⌋，wʹ 0 Is the width corresponding to the second final data table, C2 is the length corresponding to the first display area, C ʹ 0 The length corresponding to the second final data table;
specifically, w ʹ 0 ＞cʹ 0 。
S503, obtaining a second time interval t "based on c", where t "= ⌊/c" ⌋;
and S505, acquiring theta based on t ', wherein theta = 60/t'.
Specifically, in the embodiment of the present invention, the second final data table is an average value of the initial field values in the initial meter data in the time interval of t ″.
And S60, when any second final data table is detected to be clicked, the second final data table which is clicked is used as the specified electric meter data table.
According to the method, when the user cannot determine the required electric meter data, the initial electric meter data is displayed in the tree form, so that the user can find the required content in the tree form more visually and conveniently, each node with the sub-nodes exceeding the set number only displays the set number of the sub-nodes instead of completely displaying the sub-nodes, a display interface is simpler and more visual, the sub-nodes are displayed for the user in a continuous rotation mode, and the user experience can be improved; and for different placing forms of the mobile terminal, the number of the nodes displayed at each level can be correspondingly adjusted, and finally, the length and the width of the data table can be correspondingly adjusted so as to enable the display interface to be simpler and more visual.
Although some specific embodiments of the present invention have been described in detail by way of illustration, it should be understood by those skilled in the art that the above illustration is only for the purpose of illustration and is not intended to limit the scope of the invention. It will also be appreciated by those skilled in the art that various modifications may be made to the embodiments without departing from the scope and spirit of the invention. The scope of the invention is defined by the appended claims.
Claims (8)
1. A system for obtaining a data sheet for a given electricity meter, the system comprising: a database, a processor, and a memory storing a computer program, wherein the database comprises: initial data sheet list a = { a = 1 ，A 2 ，……，A i ，……，A m In which the initial data table A of the ith meter i ={A i1 ，A i2 ，……，A ij ，……，A in（i） And f, data information set A of the jth data acquisition time point of the ith initial data table ij =（RA ij ，ZA 1 ij ，ZA 2 ij ，……，ZA r ij ……，ZA s ij ，SA 1 ij ，SA 2 ij ，……，SA r ij ，……，SA s ij ），RA ij Is the jth data acquisition time point, ZA, in the initial data table of the ith electric meter r ij Is the r initial field, SA, corresponding to the j data acquisition time point in the initial data table of the ith electric meter r ij Is ZA r ij The value of r is 1 to s, s is the number of initial fields corresponding to the initial data table of the ith electric meter, j is 1 to n (i), n (i) is the number of data acquisition time points in the initial data table of the ith electric meter, i is 1 to m, and m is the number of electric meters; when executed by a processor, the computer program performs the steps of:
s100, based on A, obtaining a first time period data list B = { B1, B2,. Multidot.,. Bi,. Multidot.,. Bm }, wherein the first time period data Bi = { Bi } of the ith electric meter 1 ,Bi 2 ,...,Bi q ,...,Bi Q }，Bi q ={Bi q0 ，Bi q1 ，Bi q2 ，……，Bi qg ，……，Bi qG（q） }，Bi q Is A i Wherein, Q is the total number of weeks contained in the time interval consisting of n (i) data acquisition time points, bi q0 Week ID, bi for the qth week qg Is the g-th data acquisition time point in the q-th week, bi qg ∈{RA i1 ,RA i2 ,...,RA in(i) G takes values from 1 to G (q), and G (q) is the number of data sampling time points included in the qth week;
s200, based on A, a second time segment data list C = { C1, C2,. Eta, ci,. Eta, cm } is obtained, wherein the second time segment data Ci = { Ci ] of the ith electric meter 1 ,Ci 2 ,...,Ci y ,...,Ci Y }，Ci y ={Ci y0 ，Ci y1 ，Ci y2 ，……，Ci yd ，……，Ci yP（y） }，Ci y Is A i Wherein the data corresponding to the Y-th month in the time interval consisting of n (i) data acquisition time points, Y is the total number of months contained in the time interval consisting of n (i) data acquisition time points, ci j0 Month ID, ci corresponding to the y-th month yd Is the d-th data acquisition time point in the y-th month, ci yd ∈{RA i1 ,RA i2 ,...,RA in(i) D takes values from 1 to P (y), and P (y) is the number of data sampling time points included in the y month;
s300, based on A, a third time period data list D = { D1, D2,. Multidot.,. Di,. Multidot.,. Dm }, is obtained, wherein the third time period data Di = { Di of the ith electric meter is obtained 1 ,Di 2 ,...,Di f ,...,Di F }，Di f ={Di f0 ，Di f1 ，Di f2 ，……，Di fu ，……，Di fU(f) }，Di f Is A i Wherein, the data corresponding to the F-th year in the time interval composed of n (i) data acquisition time points, F is the total number of years contained in the time interval composed of n (i) data acquisition time points, di f0 Year ID, di corresponding to the f-th year fu Within the f yearU-th data acquisition time point, di fu ∈{RA i1 ,RA i2 ,...,RA in(i) The value of U is 1 to U (f), and U (f) is the number of data sampling time points included in the f-th year;
s400, acquiring a target text feature list H = { H } input by a user 1 ，H 2 ，……，H z ，……，H γ }，H z The method is characterized in that the method is the z-th feature of a target text, the value of z is 1 to gamma, and gamma is the number of features in the target text, wherein the target text features comprise: the method comprises the steps of identifying a target ammeter, starting a target time period, ending a target time period and a target field;
s500, vectorizing H, traversing B, C and D, and acquiring a key text feature set E = (E) 0 j ，RE 1 ，RE 2 ，...，RE t ，...，RE T ，ZE 1 ，ZE 2 ，...，ZE b ，...，ZE c ），E 0 j For target meter identification, RE t The value of T is 1 to T for the T-th data sampling time point included in the target time period, T is the number of the data sampling time points included in the target time period, ZE b B is the name of the b-th target field included by the target text, the value of b is 1 to c, c is the number of the field names corresponding to the target text, ZE b Is E 0 j One of all initial fields contained in an initial data table of the corresponding electric meter;
s600, traversing A based on E, and obtaining an electric meter specified data table F = (F) 0 ，RE 1 ，RE 2 ，...，RE t ，...，RE T ，ZE 1 ，ZE 2 ，...，ZE b ，...，ZE c ，SF 1 ，SF 2 ，...，SF b ，...，SF c ），F 0 To specify the meter identity, RE t For specifying the t-th data sampling time point, ZE, included in the meter b For specifying the b-th specified field, SF, included in the meter b Is ZE b The corresponding specified field data value.
2. Root of herbaceous plantsThe system of claim 1, wherein RA is ij =（NA ij ，YA ij ，DA ij ），NA ij Is RA ij Corresponding year, YA ij Is RA ij Corresponding month, DA ij Is RA ij The corresponding date.
3. The system of claim 1, wherein RA is ij -RA i（j-1） =RA i（j+1） -RA ij 。
4. The system of claim 1, wherein the designated meter data table is further obtained by:
s1, obtaining a target mobile terminal information set Y = (Y) 0 ，LY 0 ，DY 0 ，XY 0 ），Y 0 Is a target mobile terminal ID, LY 0 Is Y 0 Gravity value, DY, obtained by the corresponding gravity sensing module 0 Is Y 0 Corresponding angle, XY 0 Is Y 0 A corresponding display interface direction;
s2, when XY 0 When the current display interface direction is a first display interface direction, obtaining a first display interface information set M1= (KM 1, CM 1), wherein KM1 is the width of a display interface when a target mobile terminal is in the first display interface direction, CM1 is the length of the display interface when the target mobile terminal is in the first display interface direction, and the length of the first display interface corresponding to the first display interface direction is greater than the width of the first display interface corresponding to the first display interface direction;
s3, mixing A i Displaying in a tree form on a display interface, wherein each node is displayed in a circle, and a descriptor of a corresponding node is arranged on the surface of each circle;
s3 specifically comprises the following steps:
s31, displaying a root node R in the middle of a first display area of the first display interface n When n > 1, at the root node R n Rear side of (2) shows except for R n The value of n is 1 to w, and w is A i The number of years in the corresponding time point;
s32, displaying the node R in a second display area of the first display interface n The corresponding first-level node layer, wherein a first node in the first-level node layer is a month node corresponding to the root node;
wherein if the first node number S in the first level node layer 0 ≤K 0 Then, displaying each first node of the first level node layer in a first circle in a second display area and each first node is located on a same straight line with a width W, wherein K is 0 =⌊W/(d 1 +L 0 ) ⌋, W = a1 × KM1, a1 being a coefficient less than 1, d 1 Is the diameter of the first circle, L 0 The distance between two adjacent nodes of the first level node layer is defined;
if the first node number S in the first level node layer 0 ＞K 0 Displaying the first level node layer in a rotating manner on the second display area, and displaying K in a second circle on the front side of the first rotating path 0 A first node displaying K in a second circle at the rear side of the first rotation path 0 -2 nodes, wherein when the first number of nodes is S 0 ＞2*K 0 At the time of-2, S 0 -K 0 The first node is displayed in a hidden state;
s33, displaying the v-th level node layer in the v +1 th display area of the first display interface, wherein the value of v is 2 to v 0 Wherein v is 0 The following conditions are met: v. of 0 =⌊C/(d 1 +Lʹ 0 ) ⌋, C = a2 CM1, a2 is a coefficient less than 1, L ʹ 0 Is the distance of the adjacent nodes between the two node layers;
s4, when it is detected that any one node is clicked or any one node slides to the middle position of the first display area, updating each level of nodes displayed on the display interface to each level of nodes corresponding to the clicked or sliding root node;
s5, when the node in any one first-level node layer is detected to be clicked, the clicked node in any one first-level node layer is displayed in the middle of the first display area, and each level of node of the first display interface is updated to be a lower level node of the clicked node in any one first-level node layer;
s6, when the v-th signal is detected 0 When any node in the level node layer is located at the middle position of the first display area, a first final data table list Z = { Z = corresponding to the level-v node at the middle position of the first display area is obtained 1 ，Z 2 ，……，Z e ，……，Z E }，Z e The value of E is 1 to E, and E is the number of the first final data tables, wherein the value of E is the first final data table corresponding to the E-th acquisition time point;
and S7, when any one of the first final data tables is detected to be clicked, using the clicked first final data table as a specified electric meter data table.
5. The system of claim 4, wherein the rotational speed and rotational direction of the circle at any level of the node layer are the same.
6. The system of claim 4, wherein a1= a2.
7. The system according to claim 4, wherein in S6, the following steps are included to obtain E:
s61, acquiring the maximum display data table number c ʹ, wherein c ʹ meets the following conditions: c ʹ = ⌊ w ʹ by c ʺ ⌋;
wherein W ʹ = ⌊ W/W 0 ⌋，cʺ=⌊(C-C1)/c 0 ⌋，w 0 Is the width corresponding to the first final data table, C1 is the length corresponding to the first display area, C 0 For the length corresponding to the first final data table, "⌊ ⌋" is the lower integer symbol;
s63, acquiring a first time interval t ʹ based on c ʹ, wherein t ʹ = ⌊ 60/c ʹ ⌋;
s65, obtaining E based on t ʹ, wherein E =60/t ʹ.
8. The system of claim 7, wherein w is 0 ＜c 0 。
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211465173.1A CN115617816B (en) | 2022-11-22 | 2022-11-22 | System for acquiring specified ammeter data table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211465173.1A CN115617816B (en) | 2022-11-22 | 2022-11-22 | System for acquiring specified ammeter data table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115617816A CN115617816A (en) | 2023-01-17 |
| CN115617816B true CN115617816B (en) | 2023-03-17 |
Family
ID=84879095
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211465173.1A Active CN115617816B (en) | 2022-11-22 | 2022-11-22 | System for acquiring specified ammeter data table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115617816B (en) |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016123327A1 (en) * | 2015-01-29 | 2016-08-04 | Dominion Resources, Inc. | Electric power system control with measurement of energy demand and energy efficiency |
| CN106251034A (en) * | 2016-07-08 | 2016-12-21 | 大连大学 | Wisdom energy saving electric meter monitoring system based on cloud computing technology |
| CN106604344B (en) * | 2016-11-28 | 2021-11-16 | 中国电力科学研究院 | RPL-based power utilization information system and networking and communication method thereof |
| CN112905732A (en) * | 2019-11-19 | 2021-06-04 | 成都长城开发科技有限公司 | Method and device for acquiring reading success rate of electric meter |
| CN111738521B (en) * | 2020-06-24 | 2024-04-05 | 山东大学 | Non-invasive power load monitoring sequence generation method, system, equipment and medium |
| CN115187425A (en) * | 2022-04-13 | 2022-10-14 | 安科瑞电气股份有限公司 | Power utilization data processing method based on configuration software and relational database trigger |
-
2022
- 2022-11-22 CN CN202211465173.1A patent/CN115617816B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN115617816A (en) | 2023-01-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10996823B2 (en) | Interactive geospatial map | |
| US20170186206A1 (en) | Representation of overlapping visual entities | |
| EP3133510A1 (en) | Interactive geospatial map | |
| US20130086501A1 (en) | Visualizing related events within a timeline | |
| US10644964B2 (en) | Method and system for discovering and presenting access information of network applications | |
| US20140365389A1 (en) | Interactive Organization Visualization Tools For Use in Analyzing Multivariate Human-Resource Data of Organizations | |
| JP2010191997A (en) | Method for clustering and querying media item | |
| CN107506499B (en) | Method, device and server for establishing logical relationship between interest point and building | |
| CN101889294A (en) | Hotel rate analytic system | |
| US10135854B2 (en) | Method, apparatus, and computer-readable medium for generating a data proliferation graph | |
| CN111078689B (en) | Data processing method and system of discontinuous pre-ordering traversal tree algorithm | |
| Deritei et al. | Community detection by graph Voronoi diagrams | |
| US20100199223A1 (en) | Hierarchy display | |
| CN113326314B (en) | Data visualization method, device, electronic equipment and readable storage medium | |
| CN110796357B (en) | Asset group display method and device | |
| Nye | Trees of trees: an approach to comparing multiple alternative phylogenies | |
| CN115617816B (en) | System for acquiring specified ammeter data table | |
| US20170351386A1 (en) | Infographic search | |
| CN114092024A (en) | Investment project full-process management method and system | |
| CN105138636A (en) | Graph construction method and device for entity relationship | |
| CN107402986B (en) | Visual display method and system for multi-dimensional data | |
| Zaslavsky et al. | Visualization of large influenza virus sequence datasets using adaptively aggregated trees with sampling-based subscale representation | |
| Fuchs | Glyph design for temporal and multi-dimensional data: Design considerations and evaluation | |
| CN115730604A (en) | Index aggregation method, device, equipment and storage medium based on index library | |
| CN110717083A (en) | Visualization method, realization device and storage medium of multi-dimensional data |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |