CN110069547B - Online database table data statistics method, device, medium and electronic equipment - Google Patents
Online database table data statistics method, device, medium and electronic equipment Download PDFInfo
- Publication number
- CN110069547B CN110069547B CN201910206338.5A CN201910206338A CN110069547B CN 110069547 B CN110069547 B CN 110069547B CN 201910206338 A CN201910206338 A CN 201910206338A CN 110069547 B CN110069547 B CN 110069547B
- Authority
- CN
- China
- Prior art keywords
- data
- statistical
- column
- counting mode
- data type
- 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
- 238000000034 method Methods 0.000 title claims abstract description 49
- 230000008859 change Effects 0.000 claims abstract description 62
- 238000012544 monitoring process Methods 0.000 claims abstract description 39
- 238000007619 statistical method Methods 0.000 claims abstract description 7
- 238000004590 computer program Methods 0.000 claims description 9
- 230000001360 synchronised effect Effects 0.000 abstract description 6
- 230000006870 function Effects 0.000 description 15
- 238000010586 diagram Methods 0.000 description 11
- 238000004364 calculation method Methods 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 230000004044 response Effects 0.000 description 4
- 238000012935 Averaging Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 3
- 238000001514 detection method Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
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/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present disclosure provides an online database table data statistical method, apparatus, medium and electronic device, the method comprising: determining a data statistical region; acquiring data information of each column in the statistical area, and monitoring the change condition of the data information; and automatically displaying the statistical result of each column according to the change condition. According to the online database table data statistical method provided by the disclosure, the statistical rules can be directly selected through the counting modes supported by different column types, and the result can be obtained without inputting a formula. When the column property is changed, namely the cell property is changed, the supported counting mode is reserved and changed into the file corresponding to the column, and the method is very friendly to users needing only common formulas. On the grouping function provided by the online database table, the counting mode of the columns can be automatically synchronized, and the convenience of use of the user is improved.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a method, an apparatus, a medium, and an electronic device for online database table data statistics.
Background
An online database table is a table with categorizing properties that facilitates categorizing and recording data in the form of fixed data of columns. Conventional tables (e.g., excel) require setting the calculation method of the column data to obtain the desired statistical result, and the calculation method requires the operation of a user familiar with the calculation formula. For example, text columns, provide types of total number of records, unfilled, filled, unique values, and the like, and number columns additionally provide types of calculation, such as summation, average value, and the like, and the implementation of these statistical functions requires manual setting, so that the statistics of the data table becomes very cumbersome.
Therefore, how to quickly and effectively perform data statistics on the online database table becomes an urgent technical problem to be solved.
BRIEF SUMMARY OF THE PRESENT DISCLOSURE
The present disclosure is directed to an online database table data statistics method, apparatus, medium, and electronic device, which can solve at least one of the above-mentioned technical problems. The specific scheme is as follows:
according to a specific implementation manner of the present disclosure, in a first aspect, the present disclosure provides an online database table data statistics method, including:
determining a data statistical region;
acquiring data information of each column in the statistical area, and monitoring the change condition of the data information;
and automatically displaying the statistical result of each column according to the change condition.
Optionally, the obtaining data information of each column in the statistical area and monitoring a change condition of the data information include:
acquiring data type information of each column in the statistical area; monitoring the change condition of the data type information; and/or
Acquiring data counting mode information of each column in the statistical area; and monitoring the change condition of the data counting mode information.
Optionally, the automatically displaying the statistical result of each column according to the change condition includes:
finally determining the data type and/or the counting mode of each column of data according to the change condition;
sending the corresponding statistical result to a corresponding counting mode interface according to the data type of each line of data;
and the corresponding counting mode interface displays the corresponding statistical result.
Optionally, the finally determining the data type and the counting mode of each column of data according to the variation includes:
finally determining the data type of each line of data according to the change condition;
and when the data type is still matched with the previous counting mode after being changed, the changed data type is the finally determined data type of each line of data, the counting mode is kept unchanged, and otherwise, a new counting mode is matched.
Optionally, the statistical region includes a single region and a grouping region.
Optionally, when the statistical area is a single area, the statistical result is displayed at the bottom of the online database table; and/or
When the statistical area is a grouping area, the statistical results of each group are displayed at the head of each group, and the statistical results of the same data type of all groups are displayed at the bottom of the online database table.
According to a second aspect of the present disclosure, there is provided an online database table data statistics apparatus, including:
a determination unit for determining a data statistics area;
the monitoring unit is used for acquiring data information of each column in the statistical area and monitoring the change condition of the data information;
and the display unit is used for automatically displaying the statistical result of each column according to the change condition.
Optionally, the listening unit is further configured to:
acquiring data type information of each column in the statistical area; monitoring the change condition of the data type information; and/or
Acquiring data counting mode information of each column in the statistical area; and monitoring the change condition of the data counting mode information.
According to a third aspect, the present disclosure provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the method of any one of the above.
According to a fourth aspect thereof, the present disclosure provides an electronic device, comprising: one or more processors; storage means for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to carry out a method as claimed in any preceding claim.
Compared with the prior art, the scheme of the embodiment of the disclosure at least has the following beneficial effects: compared with the traditional database table such as excel, the column statistics needs to be carried out, the statistical rule of the column is set, a formula basis exists, and certain learning cost needs to be paid. According to the online database table data statistical method provided by the disclosure, the statistical rules can be directly selected through the counting modes supported by different column types, and the result can be obtained without inputting a formula. When the column property is changed, namely the cell property is changed, the supported counting mode is reserved and changed into the file corresponding to the column, and the method is very friendly to users needing only common formulas. On the grouping function provided by the online database table, the counting mode of the columns can be automatically synchronized, and the convenience of use of the user is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure. It is to be understood that the drawings in the following description are merely exemplary of the disclosure, and that other drawings may be derived from those drawings by one of ordinary skill in the art without the exercise of inventive faculty. In the drawings:
FIG. 1 shows a flow diagram of a data statistics method according to an embodiment of the present disclosure;
FIG. 2 shows a flow diagram of a data statistics method according to another embodiment of the present disclosure;
FIG. 3 shows a flow diagram of a data statistics method according to another embodiment of the present disclosure;
FIG. 4 illustrates a data statistics approach single list structure diagram according to an embodiment of the present disclosure;
FIG. 5 is a diagram illustrating a data statistics method grouping list structure according to an embodiment of the present disclosure;
FIG. 6 is a schematic diagram of a data statistics apparatus according to an embodiment of the present disclosure;
fig. 7 shows an electronic device connection structure schematic according to an embodiment of the present disclosure.
Detailed Description
To make the objects, technical solutions and advantages of the present disclosure clearer, the present disclosure will be described in further detail with reference to the accompanying drawings, and it is apparent that the described embodiments are only a part of the embodiments of the present disclosure, rather than all embodiments. All other embodiments, which can be derived by one of ordinary skill in the art from the embodiments disclosed herein without making any creative effort, shall fall within the scope of protection of the present disclosure.
The terminology used in the embodiments of the present disclosure is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. As used in the disclosed embodiments and the appended claims, the singular forms "a", "an", and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise, and "a plurality" typically includes at least two.
It should be understood that the term "and/or" as used herein is merely one type of association that describes an associated object, meaning that three relationships may exist, e.g., a and/or B may mean: a exists alone, A and B exist simultaneously, and B exists alone. In addition, the character "/" herein generally indicates that the former and latter related objects are in an "or" relationship.
It should be understood that although the terms first, second, third, etc. may be used to describe … … in embodiments of the present disclosure, these … … should not be limited to these terms. These terms are used only to distinguish … …. For example, the first … … can also be referred to as the second … … and, similarly, the second … … can also be referred to as the first … … without departing from the scope of embodiments of the present disclosure.
The words "if", as used herein, may be interpreted as "at … …" or "at … …" or "in response to a determination" or "in response to a detection", depending on the context. Similarly, the phrases "if determined" or "if detected (a stated condition or event)" may be interpreted as "when determined" or "in response to a determination" or "when detected (a stated condition or event)" or "in response to a detection (a stated condition or event)", depending on the context.
It is also noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that an 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 article or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in the article or device in which the element is included.
Alternative embodiments of the present disclosure are described in detail below with reference to the accompanying drawings.
Example 1
As shown in fig. 1, according to a specific embodiment of the present disclosure, an embodiment of the present disclosure provides an online database table data statistics method, where an online database table may be a database table of any office software, and for convenience of expression, an excel table that can be edited online by a user is taken as an example in the present embodiment for description. The method specifically comprises the following steps:
step S102: and determining a data statistical region.
The statistical area is usually an area with data, the data can be located in the same sheet of the excel sheet or in different sheets, and data statistics is carried out in a mode of function calling and a pivot sheet. For ease of understanding, the same sheet will be used for illustration.
As shown in fig. 4, the statistics area may be a single statistics area or a grouped statistics area, and as shown in fig. 5, the grouped statistics areas may be grouped in any form, each group may be arranged in N × M, and N, M are all natural numbers greater than 1, and each represents the number of rows and columns of the group.
Step S104: acquiring data information of each column in the statistical area, and monitoring the change condition of the data information;
optionally, the obtaining data information of each column in the statistical area and monitoring a change condition of the data information include: acquiring data type information of each column in the statistical area; and monitoring the change condition of the data type information.
Common data types include: numerical value, currency, date, time, percentage, score, or text, among other common data types. Of course, the data type is not limited thereto, and any data type used in the data table may be included in the embodiment.
After the database table obtains the data type information listed above, monitoring whether the data type information changes in real time, and if not, performing statistical display according to the value of the input unit table; if the data type does not match the input value type, the column of data types is automatically modified to match the input value type and then displayed with the appropriate results.
Step S106: and automatically displaying the statistical result of each column according to the data type change condition.
Specifically, step S106 can be implemented by the following steps:
step S1062: finally determining the data type and the counting mode of each line of data according to the data type change condition;
optionally, the finally determining the data type and the counting mode of each column of data according to the variation includes:
and finally determining the data type of each line of data according to the data type change condition, for example, changing the data type of the text type into the data type of the numerical value type, and determining the type of the line of data as the data type of the numerical value type at the moment.
At this time, whether the data type of the column is still matched with the counting mode before the column after being changed is judged, when the data type is still matched with the counting mode before the column after being changed, for example, the data type before the column is a text data type, summation can be performed, the data type after being changed is a numerical data type, summation can still be performed, the data type after being changed is the finally determined data type (numerical class) of each column of data, and the counting mode is kept unchanged (still is summation); otherwise, a new counting mode is matched, for example, the changed data type is a date type, and the summation operation cannot be performed, the counting mode matched with the date type needs to be changed.
Step S1064: sending the corresponding statistical result to a corresponding counting mode interface according to the data type of each line of data;
after the data type of each row is determined, the statistical result of the counting mode corresponding to the data type of the row needs to be sent to the corresponding counting mode interface, otherwise, the statistical result cannot be displayed.
Step S1066: and displaying the corresponding statistical result through the corresponding counting mode interface.
As shown in fig. 4 and 5, the statistical region includes a single region and a grouping region. When the statistical area is a single area, the statistical result is displayed at the bottom of the online database table; when the statistical region is a grouping region, the statistical results of each group are displayed at the head of each group, and the statistical results of all groups with the same data type are displayed at the bottom of the online database table.
For example, a data column of text type, the number of statistical display records; a data column of date type, counting display time range; and (4) data columns of a digital type, and counting to display a summation value.
Compared with the traditional database table such as excel, the column statistics needs to be carried out, the statistical rule of the column is set, a formula basis exists, and certain learning cost needs to be paid. According to the online database table data statistical method provided by the disclosure, the statistical rules can be directly selected through the counting modes supported by different column types, and the result can be obtained without inputting a formula. When the column property is changed, namely the cell property is changed, the supported counting mode is reserved and changed into the file corresponding to the column, and the method is very friendly to users needing only common formulas. On the grouping function provided by the online database table, the counting mode of the columns can be automatically synchronized, and the convenience of use of the user is improved.
Example 2
As shown in fig. 2, according to a specific implementation manner of the present disclosure, an embodiment of the present disclosure provides an online database table data statistics method, where an online database table may be a database table of any office software, and for convenience of expression, this embodiment takes an excel table that can be edited online by a user as an example for description. The method specifically comprises the following steps:
step S102: and determining a data statistical region.
The statistical area is usually an area with data, the data can be located in the same sheet of the excel sheet or in different sheets, and data statistics is carried out in a mode of function calling and a pivot sheet. For ease of understanding, the same sheet will be used for illustration.
As shown in fig. 4, the statistics area may be a single statistics area or a grouped statistics area, and as shown in fig. 5, the grouped statistics areas may be grouped in any form, each group may be arranged in N × M, and N, M are all natural numbers greater than 1, and each represents the number of rows and columns of the group.
Step S104: acquiring data information of each column in the statistical area, and monitoring the change condition of the data information;
optionally, the obtaining data information of each column in the statistical area and monitoring a change condition of the data information include: acquiring data counting mode information of each column in the statistical area; and monitoring the change condition of the data counting mode information.
Common counting means include summation, average, date range, unfilled, filled or unique values. Of course, the counting method may be different according to the data type, and any counting method used in the data table may be included in the embodiment, and the counting method may be manually selected by the statistical display position of the data table.
After the database table obtains the counting mode information of the column, monitoring whether the counting mode information changes in real time, if not, indicating that the current counting mode is matched with the data type, and performing statistical display according to the value of the input unit table; if the data type does not match the count pattern, the column count pattern is modified manually or automatically to match the data type, and then the statistical result is displayed with the appropriate result.
Step S106: and automatically displaying the statistical result of each column according to the change condition of the data counting mode.
Specifically, step S106 can be implemented by the following steps:
step S1062: finally determining the data type and the counting mode of each line of data according to the change condition of the data counting mode;
for example, the counting mode of each column of data is finally determined according to the change condition of the counting mode, for example, the counting mode is changed from time range to summation, and the counting mode of the column of data is determined to be summation at this time.
At this time, whether the data type of the column is matched with the counting mode of the column is judged, when the data type is matched with the counting mode, for example, the column is a text data type, summation can be performed, the changed data type is an averaging value, and the changed counting mode is the finally determined counting mode (averaging value) of each column of data; otherwise, a new counting mode is matched, for example, the changed counting mode is an average value, and the counting mode is not matched with the date class, the counting mode needs to be changed into the time range.
Step S1064: sending the corresponding statistical result to a corresponding counting mode interface according to the data type of each line of data;
after the data type of each row is determined, the statistical result of the counting mode corresponding to the data type of the row needs to be sent to the corresponding counting mode interface, otherwise, the statistical result cannot be displayed.
Step S1066: and displaying the corresponding statistical result through the corresponding counting mode interface.
As shown in fig. 5, the statistical region includes a single region and a grouped region. When the statistical area is a single area, the statistical result is displayed at the bottom of the online database table; when the statistical region is a grouping region, the statistical results of each group are displayed at the head of each group, and the statistical results of all groups with the same data type are displayed at the bottom of the online database table.
For example, a data column of text type, the number of statistical display records; a data column of date type, counting display time range; and (4) data columns of a digital type, and counting to display a summation value.
Compared with the traditional database table such as excel, the column statistics needs to be carried out, the statistical rule of the column is set, a formula basis exists, and certain learning cost needs to be paid. According to the online database table data statistical method provided by the disclosure, the statistical rules can be directly selected through the counting modes supported by different column types, and the result can be obtained without inputting a formula. When the column property is changed, namely the cell property is changed, the supported counting mode is reserved and changed into the file corresponding to the column, and the method is very friendly to users needing only common formulas. On the grouping function provided by the online database table, the counting mode of the columns can be automatically synchronized, and the convenience of use of the user is improved.
Example 3
As shown in fig. 3, according to a specific embodiment of the present disclosure, an embodiment of the present disclosure provides an online database table data statistics method, where an online database table may be a database table of any office software, and for convenience of expression, this embodiment takes an excel table that can be edited online by a user as an example for description. The method specifically comprises the following steps:
step S102: and determining a data statistical region.
The statistical area is usually an area with data, the data can be located in the same sheet of the excel sheet or in different sheets, and data statistics is carried out in a mode of function calling and a pivot sheet. For ease of understanding, the same sheet will be used for illustration.
As shown in fig. 4, the statistics area may be a single statistics area or a grouped statistics area, and as shown in fig. 5, the grouped statistics areas may be grouped in any form, each group may be arranged in N × M, and N, M are all natural numbers greater than 1, and each represents the number of rows and columns of the group.
Step S104: acquiring data information of each column in the statistical area, and monitoring the change condition of the data information;
optionally, the obtaining data information of each column in the statistical area and monitoring a change condition of the data information include: and acquiring data value change information of each column in the statistical area, and monitoring the change condition of the data value change information.
Common counting means include summation, average, date range, unfilled, filled or unique values. Of course, the counting method may be different according to the data type, and any counting method used in the data table may be included in the embodiment, and the counting method may be manually selected by the statistical display position of the data table.
After the database table obtains the counting mode information of the column, monitoring whether the counting mode information changes in real time, if not, indicating that the current counting mode is matched with the data type, and performing statistical display according to the value of the input unit table; if the data type does not match the count pattern, the column count pattern is modified manually or automatically to match the data type, and then the statistical result is displayed with the appropriate result.
Step S106: and automatically displaying the statistical result of each column according to the change condition of the data value.
Specifically, step S106 can be implemented by the following steps:
step S1062: finally determining the data type and the counting mode of each line of data according to the data value change condition;
for example, the counting manner of each line of data is finally determined according to the data value change condition, for example, the time is changed into a numerical value, at this time, the type of the line of data may be determined to be a text or a numerical value class, and the counting manner may be summation, averaging, or the like.
At this time, whether the data type of the column is matched with the counting mode of the column is judged, when the data type is matched with the counting mode, for example, the column is a text data type, the counting mode is summation, if the input is a numerical value, the input is determined to be effective, otherwise, the input content is changed.
Step S1064: sending the corresponding statistical result to a corresponding counting mode interface according to the data type of each line of data;
after the data type of each row is determined, the statistical result of the counting mode corresponding to the data type of the row needs to be sent to the corresponding counting mode interface, otherwise, the statistical result cannot be displayed.
Step S1066: and displaying the corresponding statistical result through the corresponding counting mode interface.
As shown in fig. 5, the statistical region includes a single region and a grouped region. When the statistical area is a single area, the statistical result is displayed at the bottom of the online database table; when the statistical region is a grouping region, the statistical results of each group are displayed at the head of each group, and the statistical results of all groups with the same data type are displayed at the bottom of the online database table.
For example, a data column of text type, the number of statistical display records; a data column of date type, counting display time range; and (4) data columns of a digital type, and counting to display a summation value.
Compared with the traditional database table such as excel, the column statistics needs to be carried out, the statistical rule of the column is set, a formula basis exists, and certain learning cost needs to be paid. According to the online database table data statistical method provided by the disclosure, the statistical rules can be directly selected through the counting modes supported by different column types, and the result can be obtained without inputting a formula. When the column property is changed, namely the cell property is changed, the supported counting mode is reserved and changed into the file corresponding to the column, and the method is very friendly to users needing only common formulas. On the grouping function provided by the online database table, the counting mode of the columns can be automatically synchronized, and the convenience of use of the user is improved.
Example 4
As shown in fig. 6, according to a specific embodiment of the present disclosure, an online database table data statistics apparatus provided in an embodiment of the present disclosure includes a determining unit 602, a listening unit 604, and a displaying unit 606. The online database table can be a database table of any office software, and for convenience of expression, the embodiment takes an excel table that can be edited by a user online as an example. The method specifically comprises the following steps:
the determination unit 602: for determining the data statistics area.
The statistical area is usually an area with data, the data can be located in the same sheet of the excel sheet or in different sheets, and data statistics is carried out in a mode of function calling and a pivot sheet. For ease of understanding, the same sheet will be used for illustration.
As shown in fig. 4, the statistics area may be a single statistics area or a grouped statistics area, and as shown in fig. 5, the grouped statistics areas may be grouped in any form, each group may be arranged in N × M, and N, M are all natural numbers greater than 1, and each represents the number of rows and columns of the group.
The listening unit 604: the system is used for acquiring data information of each column in the statistical area and monitoring the change condition of the data information;
optionally, the obtaining data information of each column in the statistical area and monitoring a change condition of the data information include: acquiring data type information of each column in the statistical area; and monitoring the change condition of the data type information.
Common data types include: numerical value, currency, date, time, percentage, score, or text, among other common data types. Of course, the data type is not limited thereto, and any data type used in the data table may be included in the embodiment.
After the database table obtains the data type information listed above, monitoring whether the data type information changes in real time, and if not, performing statistical display according to the value of the input unit table; if the data type does not match the input value type, the column of data types is automatically modified to match the input value type and then displayed with the appropriate results.
Optionally, the obtaining data information of each column in the statistical area and monitoring a change condition of the data information include: acquiring data counting mode information of each column in the statistical area; and monitoring the change condition of the data counting mode information.
Common counting means include summation, average, date range, unfilled, filled or unique values. Of course, the counting method may be different according to the data type, and any counting method used in the data table may be included in the embodiment, and the counting method may be manually selected by the statistical display position of the data table.
After the database table obtains the counting mode information of the column, monitoring whether the counting mode information changes in real time, if not, indicating that the current counting mode is matched with the data type, and performing statistical display according to the value of the input unit table; if the data type does not match the count pattern, the column count pattern is modified manually or automatically to match the data type, and then the statistical result is displayed with the appropriate result.
Optionally, the obtaining data information of each column in the statistical area and monitoring a change condition of the data information include: and acquiring data value change information of each column in the statistical area, and monitoring the change condition of the data value change information.
Common counting means include summation, average, date range, unfilled, filled or unique values. Of course, the counting method may be different according to the data type, and any counting method used in the data table may be included in the embodiment, and the counting method may be manually selected by the statistical display position of the data table.
After the database table obtains the counting mode information of the column, monitoring whether the counting mode information changes in real time, if not, indicating that the current counting mode is matched with the data type, and performing statistical display according to the value of the input unit table; if the data type does not match the count pattern, the column count pattern is modified manually or automatically to match the data type, and then the statistical result is displayed with the appropriate result.
The display unit 606: and automatically displaying the statistical result of each column according to the data type change condition.
Specifically, the display unit 606 is configured to:
firstly, finally determining the data type and the counting mode of each line of data according to the data type change condition;
the method specifically comprises the following steps: and finally determining the data type of each line of data according to the data type change condition, for example, changing the data type of the text type into the data type of the numerical value type, and determining the type of the line of data as the data type of the numerical value type at the moment.
At this time, whether the data type of the column is still matched with the counting mode before the column after being changed is judged, when the data type is still matched with the counting mode before the column after being changed, for example, the data type before the column is a text data type, summation can be performed, the data type after being changed is a numerical data type, summation can still be performed, the data type after being changed is the finally determined data type (numerical class) of each column of data, and the counting mode is kept unchanged (still is summation); otherwise, a new counting mode is matched, for example, the changed data type is a date type, and the summation operation cannot be performed, the counting mode matched with the date type needs to be changed.
Secondly, sending the corresponding statistical result to a corresponding counting mode interface according to the data type of each line of data; after the data type of each row is determined, the statistical result of the counting mode corresponding to the data type of the row needs to be sent to the corresponding counting mode interface, otherwise, the statistical result cannot be displayed.
And thirdly, displaying the corresponding statistical result through the corresponding counting mode interface.
As shown in fig. 4 and 5, the statistical region includes a single region and a grouping region. When the statistical area is a single area, the statistical result is displayed at the bottom of the online database table; when the statistical region is a grouping region, the statistical results of each group are displayed at the head of each group, and the statistical results of all groups with the same data type are displayed at the bottom of the online database table.
For example, a data column of text type, the number of statistical display records; a data column of date type, counting display time range; and (4) data columns of a digital type, and counting to display a summation value.
Compared with the traditional database table such as excel, the column statistics needs to be carried out, the statistical rule of the column is set, a formula basis exists, and certain learning cost needs to be paid. The online database table data statistical device provided by the disclosure can directly select statistical rules through counting modes supported by different column types, and results can be obtained without inputting formulas. When the column property is changed, namely the cell property is changed, the supported counting mode is reserved and changed into the file corresponding to the column, and the method is very friendly to users needing only common formulas. On the grouping function provided by the online database table, the counting mode of the columns can be automatically synchronized, and the convenience of use of the user is improved.
Example 5
As shown in fig. 7, the present embodiment provides an electronic device, which is used for data statistics of an online database table, and the electronic device includes: at least one processor; and a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the one processor to cause the at least one processor to perform the method steps of any of embodiments 1-3.
Example 6
Embodiments of the present disclosure provide a non-volatile computer storage medium having stored thereon computer-executable instructions that can perform any of the above methods.
Example 7
Referring now to FIG. 7, shown is a schematic diagram of an electronic device 700 suitable for use in implementing embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure may include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (personal digital assistant), a PAD (tablet computer), a PMP (portable multimedia player), a vehicle terminal (e.g., a car navigation terminal), and the like, and a stationary terminal such as a digital TV, a desktop computer, and the like. The electronic device shown in fig. 7 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.
As shown in fig. 7, electronic device 700 may include a processing means (e.g., central processing unit, graphics processor, etc.) 701 that may perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)702 or a program loaded from storage 708 into a Random Access Memory (RAM) 703. In the RAM 703, various programs and data necessary for the operation of the electronic apparatus 700 are also stored. The processing device 701, the ROM 702, and the RAM 703 are connected to each other via a bus 707. An input/output (I/O) interface 705 is also connected to the bus 707.
Generally, the following devices may be connected to the I/O interface 705: input devices 706 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; an output device 707 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 708 including, for example, magnetic tape, hard disk, etc.; and a communication device 709. The communication means 709 may allow the electronic device 700 to communicate wirelessly or by wire with other devices to exchange data. While fig. 7 illustrates an electronic device 700 having various means, it is to be understood that not all illustrated means are required to be implemented or provided. More or fewer devices may alternatively be implemented or provided.
In particular, according to an embodiment of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such embodiments, the computer program may be downloaded and installed from a network via the communication means 709, or may be installed from the storage means 708, or may be installed from the ROM 702. The computer program, when executed by the processing device 701, performs the above-described functions defined in the methods of the embodiments of the present disclosure.
It should be noted that the computer readable medium in the present disclosure can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In contrast, in the present disclosure, a computer readable signal medium may comprise a propagated data signal with computer readable program code embodied therein, either in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (radio frequency), etc., or any suitable combination of the foregoing.
The computer readable medium may be embodied in the electronic device; or may exist separately without being assembled into the electronic device.
Computer program code for carrying out operations for aspects of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present disclosure may be implemented by software or hardware. Where the name of an element does not in some cases constitute a limitation on the element itself.
Claims (6)
1. An online database table data statistical method is characterized by comprising the following steps:
determining a data statistical region;
acquiring data information of each column in the statistical area, and monitoring the change condition of the data information;
automatically displaying the statistical result of each column according to the change condition;
the acquiring data information of each column of the statistical area and monitoring the change condition of the data information includes: acquiring data type information of each column in the statistical area; monitoring the change condition of the data type information; acquiring data counting mode information of each column in the statistical area; monitoring the change condition of the data counting mode information;
the automatically displaying the statistical result of each column according to the change condition comprises: determining the data type and the counting mode of each line of data according to the change condition; sending the corresponding statistical result to a corresponding counting mode interface according to the data type of each line of data; the corresponding counting mode interface displays the corresponding statistical result;
the determining the data type and the counting mode of each column of data according to the change condition comprises the following steps:
finally determining the data type of each line of data according to the change condition;
and when the data type is still matched with the previous counting mode after being changed, the changed data type is the finally determined data type of each line of data, the counting mode is kept unchanged, and otherwise, a new counting mode is matched.
2. The method of claim 1, wherein the statistical region comprises a single region and a grouped region.
3. The method of claim 2,
when the statistical area is a single area, the statistical result is displayed at the bottom of the online database table; and/or
When the statistical area is a grouping area, the statistical results of each group are displayed at the head of each group, and the statistical results of the same data type of all groups are displayed at the bottom of the online database table.
4. An online database table statistics apparatus, comprising:
a determination unit for determining a data statistics area;
the monitoring unit is used for acquiring data information of each column in the statistical area and monitoring the change condition of the data information;
the display unit is used for automatically displaying the statistical result of each column according to the change condition;
the listening unit is further configured to: acquiring data type information of each column in the statistical area; monitoring the change condition of the data type information; acquiring data counting mode information of each column in the statistical area; monitoring the change condition of the data counting mode information;
the display unit is further configured to: determining the data type and the counting mode of each line of data according to the change condition; sending the corresponding statistical result to a corresponding counting mode interface according to the data type of each line of data; the corresponding counting mode interface displays the corresponding statistical result, and the data type and the counting mode of each line of data are determined according to the change condition, wherein the data type and the counting mode comprise the following steps: finally determining the data type of each line of data according to the change condition; and when the data type is still matched with the previous counting mode after being changed, the changed data type is the finally determined data type of each line of data, the counting mode is kept unchanged, and otherwise, a new counting mode is matched.
5. A computer-readable storage medium, on which a computer program is stored, which program, when being executed by a processor, carries out the method according to any one of claims 1 to 3.
6. An electronic device, comprising:
one or more processors;
storage means for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to carry out the method of any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910206338.5A CN110069547B (en) | 2019-03-19 | 2019-03-19 | Online database table data statistics method, device, medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910206338.5A CN110069547B (en) | 2019-03-19 | 2019-03-19 | Online database table data statistics method, device, medium and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110069547A CN110069547A (en) | 2019-07-30 |
| CN110069547B true CN110069547B (en) | 2021-10-12 |
Family
ID=67366356
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910206338.5A Active CN110069547B (en) | 2019-03-19 | 2019-03-19 | Online database table data statistics method, device, medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110069547B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111079395A (en) * | 2019-11-18 | 2020-04-28 | 北京明略软件系统有限公司 | Method, device, computer storage medium and terminal for realizing information processing |
| CN111858587A (en) * | 2020-07-10 | 2020-10-30 | 北京青云科技股份有限公司 | Database data counting method, device, equipment and storage medium |
| CN113947065A (en) * | 2021-10-14 | 2022-01-18 | 北京达佳互联信息技术有限公司 | Data processing method, data processing device, electronic equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101847152A (en) * | 2010-02-01 | 2010-09-29 | 浪潮集团山东通用软件有限公司 | Statistical analysis method and statistical analysis system for statements of various criterions based on data unit |
| CN102855229A (en) * | 2011-06-30 | 2013-01-02 | 镇江雅迅软件有限责任公司 | Self-defined statistical report form generating system based on EXCEL form |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN104978305A (en) * | 2014-04-08 | 2015-10-14 | 无锡兰霖网络科技有限公司 | Intelligent computation method of statistical index on the basis of complex function formula |
| CN106095809A (en) * | 2016-05-30 | 2016-11-09 | 广东凯通科技股份有限公司 | Data matching method and system |
| CN108460092A (en) * | 2018-01-30 | 2018-08-28 | 福建星瑞格软件有限公司 | Include the sql query statements automatic generation method and system of database built-in function |
| CN109408506A (en) * | 2018-09-05 | 2019-03-01 | 天津字节跳动科技有限公司 | Table data processing method and device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20180129642A1 (en) * | 2016-11-04 | 2018-05-10 | Erik Rucker | Systems and methods for automatic application of formulas to tabular data cells |
-
2019
- 2019-03-19 CN CN201910206338.5A patent/CN110069547B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101847152A (en) * | 2010-02-01 | 2010-09-29 | 浪潮集团山东通用软件有限公司 | Statistical analysis method and statistical analysis system for statements of various criterions based on data unit |
| CN102855229A (en) * | 2011-06-30 | 2013-01-02 | 镇江雅迅软件有限责任公司 | Self-defined statistical report form generating system based on EXCEL form |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN104978305A (en) * | 2014-04-08 | 2015-10-14 | 无锡兰霖网络科技有限公司 | Intelligent computation method of statistical index on the basis of complex function formula |
| CN106095809A (en) * | 2016-05-30 | 2016-11-09 | 广东凯通科技股份有限公司 | Data matching method and system |
| CN108460092A (en) * | 2018-01-30 | 2018-08-28 | 福建星瑞格软件有限公司 | Include the sql query statements automatic generation method and system of database built-in function |
| CN109408506A (en) * | 2018-09-05 | 2019-03-01 | 天津字节跳动科技有限公司 | Table data processing method and device |
Non-Patent Citations (2)
| Title |
|---|
| DAX入门;luowendong1210;《百度文库》;20141107;1-19 * |
| luowendong1210.DAX入门.《百度文库》.2014, * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110069547A (en) | 2019-07-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110069547B (en) | Online database table data statistics method, device, medium and electronic equipment | |
| WO2020135185A1 (en) | Method and device for notifying read receipt status of message, and electronic device | |
| CN110619099B (en) | Comment content display method, device, equipment and storage medium | |
| CN109408754B (en) | Webpage operation data processing method and device, electronic equipment and storage medium | |
| CN109389365B (en) | Multi-person collaborative document processing method and device and electronic equipment | |
| CN110188299B (en) | Response type page processing method and device and electronic equipment | |
| WO2020199749A1 (en) | Feedback-based information pushing method and apparatus, and electronic device | |
| CN110955820A (en) | Media information interest point recommendation method, device, server and storage medium | |
| CN111258998A (en) | Data verification method, device, medium and electronic equipment | |
| CN110728129B (en) | Method, device, medium and equipment for typesetting text content in picture | |
| US9934292B2 (en) | Dynamic presentation of a results set by a form-based software application | |
| CN113254139B (en) | Online education course information display method, device, terminal and storage medium | |
| CN110647369B (en) | Page dynamic display method and device, mobile terminal and storage medium | |
| CN109683726B (en) | Character input method, character input device, electronic equipment and storage medium | |
| CN112492399B (en) | Information display method and device and electronic equipment | |
| CN110489412B (en) | Data processing method, device, medium and electronic equipment | |
| CN116188622B (en) | Power index information display method and device, electronic equipment and computer medium | |
| CN110673908A (en) | Interface generation method, device, medium and electronic equipment | |
| CN109299416B (en) | Webpage processing method and device, electronic equipment and storage medium | |
| CN115562792A (en) | Page display method and device and electronic equipment | |
| CN112071313A (en) | Voice broadcasting method and device, electronic equipment and medium | |
| CN113672317A (en) | Method and device for rendering title page | |
| CN110825478A (en) | Main interface content adding method, device, medium and electronic equipment | |
| CN111190599A (en) | Method and device for realizing android self-defined soft keyboard by using Dialog and electronic equipment | |
| WO2024041566A1 (en) | Information processing method and apparatus, and electronic device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |