JP2006185226A - Variable data analysis system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a variable data analysis system which analyzes data varying in time series with passage of time of a certain period, for example, one day. <P>SOLUTION: The system includes a step (1) wherein a system user accesses a LCM data analysis server 5 from a system user PC 6 through a communication network 8 to transmit a request for graph display of BEMS data in an object article 2 (○1), a step (2) wherein the LCM data analysis server 5 requests data extraction to a LCM data storage server 2b (○2), a step (3) wherein the LCM data analysis server 5 acquires pertinent data from the LCM data storage server 2b (○3), and a step (4) wherein the LCM data analysis server 5 transmits data of graph display to the system user PC6 (○4). Data edited and processed by the system user PC 6 are registered in the LCM data analysis server 5. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention is a method for analyzing, editing, and registering data that fluctuates in a time series according to a time transition within a certain period, for example, the indoor environment (temperature, power consumption, etc.) of a commercial building. The present invention relates to a data analysis system.

  When performing data analysis, for example, BEMS (Building Energy and Environmental Management System), where it is necessary to analyze data that fluctuates in time series with the time transition of the day There is. The BEMS is a system for grasping the indoor environment / energy usage status in a business building or the like and reducing the amount of energy consumption through operation management of equipment or facilities according to the indoor environment.

  BEMS mainly has the following functions. (1) Understanding energy consumption trends (energy intensity, energy consumption ratio by application, etc.). (2) Confirmation of energy saving effect and detection of waste. (3) Confirmation of indoor environment status (balance evaluation between energy saving and indoor environment). A system to which such BEMS is applied is disclosed in Patent Document 1.

JP 2003-58614 A

  As a representation method of various data that realizes the above functions in BEMS, a method is generally used in which specifications of tables and graphs are compiled in advance, software is created based on the specifications, and the software is stored in a building. As described above, the system described in Patent Document 1 has a problem that there is no degree of freedom for editing and changing after completion with respect to a data expression method. Changing the data representation method requires rewriting of software by a specialist, which requires time and money, and it has been difficult to edit the data flexibly and easily according to the actual operation.

  Due to the recent increase in interest in the environment and energy savings, changes and additions to the screen processing for data analysis evaluation are reflected promptly and at low cost for data that changes in time series over time within a certain period. Realization of possible systems is demanded by system users. However, the system described in Patent Document 1 has a problem that it cannot respond to such a request.

  The present invention has been made in view of such problems, and an object thereof is to provide a fluctuation data analysis system capable of reflecting a change / addition request for screen processing for data analysis evaluation promptly and at low cost. .

In order to achieve such an object, a fluctuation data analysis system according to an embodiment of the present invention includes a data accumulation server that accumulates data that varies in time series with time transition within a certain period, a data analysis server, A fluctuation data analysis system in which user terminals are connected via a communication network,
In response to a request from the user terminal, the predetermined data is acquired from the data storage server and displayed on the screen of the user terminal, and the data is displayed on the screen according to the authority set in advance by the user. The expression method is subjected to necessary editing and processing, and the result is registered in the data analysis server.

  The fluctuation data analysis system of the present invention is characterized in that the user terminal analyzes the data with general-purpose spreadsheet software and performs necessary editing and processing.

  In the variation data analysis system of the present invention, the data requested by the data storage server from the user terminal to the data storage server is formed in the form of a graph or a form, and is displayed on the screen of the user terminal. Thus, various editing and processing are performed on the data in the graph or form format.

  The fluctuation data analysis system according to the present invention is characterized in that the data fluctuating in time series is edited and processed in units of days, weeks, months, and years.

  The fluctuation data analysis system according to the present invention is characterized in that data registered in the data analysis server in the form of a graph or a form can be used by a user terminal according to the authority of another user.

  The fluctuation data analysis system of the present invention is characterized in that the data fluctuating in time series is applied to BEMS.

  In the fluctuation data analysis system of the present invention, the data storage server is an LCM data storage server, and the data analysis server is an LCM data analysis server.

  Also, the fluctuation data analysis system of the present invention is characterized in that a plurality of the LCM data storage server and the user terminal are installed and connected to the communication line.

  The fluctuation data analysis system according to any one of claims 1 to 7, wherein the communication network is the Internet or an intranet.

  In the fluctuation data analysis system according to the present invention, the authority preset for the user is any one or all of browsing, editing, and registration of the data.

  In the present invention, the following special effects can be obtained. (1) System users who need to analyze fluctuation data (engineers, designers, building managers, etc.) themselves set up the design of the graphs required for performance evaluation and operation evaluation, and put it into a fluctuation data analysis system. You can register. (2) System costs can be reduced (screen creation costs and costs related to screen addition changes). (3) Immediate screen editing / addition work can be realized. (4) The user editing function can be used to develop a system that is suitable for actual operation. (5) As described above, when the fluctuation data analysis system of the present invention is applied to BEMS, the original BEMS function is sufficiently exhibited, which can contribute to improvement of the indoor environment and realization of energy saving.

  Embodiments of the present invention will be described below with reference to the drawings. The fluctuation data analysis system of the present invention is an analysis / analysis of data that fluctuates in time series with time transition within a certain period, for example, equipment operation data and building operation data of a plurality of buildings, via a communication network such as an intranet or the Internet. Intended for information systems intended to evaluate.

  FIG. 1 is a system configuration diagram according to an embodiment of the present invention, and shows an example in which a fluctuation data analysis system 1 is applied to BEMS data analysis. Reference numerals 2 to 4 are data analysis target properties, and in this example, A building, B building, and C building are target properties. Each target property is provided with building management systems 2a to 4a and LCM (Life Cycle Management) data storage servers 2b to 4b. The LCM data is data used in a method for systematically managing operation management costs from the birth to the end of a structure.

  The building management systems 2a to 4a are systems that manage air conditioning, electricity, water supply, and the like of each target property 2a to 4a. The LCM data storage servers 2b to 4b store BA (Building Automation) data of each target property 2a to 4a when the building management systems 2a to 4a are operated for a long period of time. As described above, the LCM data storage servers 2b to 4b are installed for each building as a target property, and store and manage facility operation data and facility operation data in a DB (Data Base) for a long period of time. In addition, the LCM data storage servers 2b to 4b can store the results of performing statistical processing and arithmetic processing periodically as necessary.

  The LCM data analysis server 5 is configured on the basis of a Web server, and functions as a portal (entrance) site that realizes a Web-based graph / form display / edit / registration function for system users. In this way, the LCM data analysis server 5 manages the Web screen display DB for each building of each target property, and stores graphs and form settings that are registered and edited by the user. When the system user displays a graph or a form on the PC, the actual data is collected from the LCM data storage server 5. Reference numerals 6 and 7 denote system user PCs. The LCM data storage servers 2 b to 4 b, the LCM data analysis server 5, and the system user PCs 6 and 7 are connected to a communication network (Internet / Intranet) 8. The system user can access the LCM data analysis server 5 using a Web browser in an environment where the Internet / intranet can be accessed, and can perform operations permitted by authority after user authentication. For example, authority settings such as viewing, editing, and registration of graphs and forms can be made for each property. Some or all of these authorities can be granted depending on the system user.

  In FIG. 1, a specific form of a usage example of the fluctuation data analysis system 1 by a system user will be described. (1) The system user accesses the LCM data analysis server 5 from the system user PC 6 and sends a BEMS data graph display request for the target property 2 (circled numbers in the figure are ○ for reasons of conversion. 1 is displayed, and so on) (2) The LCM data analysis server 5 requests the LCM data storage server 2b to extract data (◯ 2). (3) The LCM data analysis server 5 acquires the data from the LCM data storage server 2b (◯ 3). (4) The LCM data analysis server 5 transmits the corresponding graph display data to the system user PC 6 (◯ 4).

  As described above, in the example of FIG. 1, the system user PCs 6 and 7 on the Internet / intranet access the LCM data analysis server 5 by the Web browser and select the building name from the menu. Next, the graph or form name to be executed is selected. In addition, by specifying a range of time-series data such as date, the graph or form is displayed on the screen on the PC. A user who has editing authority can edit and newly register an existing graph or form.

  A feature of the present system shown in FIG. 1 is that a graph file or a form file displayed on a PC can be freely edited and re-registered by a user on a Web browser. The format of the registered graph file or form file can also be used by other users by registering with the LCM data analysis server 5. In addition, by changing the date (year, month, week, day), the data on the date can be displayed in the edited format.

  Since graphs and forms are created using general-purpose spreadsheet software, programming knowledge is not required and editing is easy. The update operation is completed by uploading the edited file to the LCM data analysis server 5 hair. Since these series of operations can all be performed on a Web browser, dedicated software is not required for the user terminal. For this reason, when constructing a system, the operation is easy without cost.

  FIG. 2 is an explanatory diagram showing an outline of software of the LCM data storage servers 2b to 4b and the LCM data analysis server 5 in the variation data analysis system 1 shown in FIG. Software that is an embodiment of the present invention has excellent graph and spreadsheet functions, and adopts general-purpose spreadsheet software that is used as standard for data analysis applications, so that system users can edit the format of graphs and forms. Made possible. In addition, as a user interface environment for displaying and editing this, a web browser which is Internet browsing software is used to improve connectivity to the system.

  Next, the software configuration of FIG. 2 will be described. The LCM data storage servers 2 b to 4 b have a BA history management database 11. The LCM data analysis server 5 has a data extraction program 12, a WEB server 13, general-purpose spreadsheet software 14, and a format-defined file 15. The data extraction program 12 is executed when displaying a graph or a form.

  Based on the list of data specified in the edited file, the data extraction program 12 extracts data for the specified period from the BA history management database 11 and pastes the edited file in the cell. A graph linked to this data is generated and displayed on the WEB browser. In addition, the data extraction program 12 extracts time-series data at a specified point and embeds it in the worksheet of the format-defined file 15.

  The WEB server 13 serves as a user interface environment for a system user to display and edit graphs and forms. The general-purpose spreadsheet software 14 provides a spreadsheet function in a form embedded in a WEB browser. Mainly use tabular data management function and graph / form display function. The format-defined (spreadsheet) file 15 includes a template file and an edited file.

  The template file, as indicated by ○ 1 in the format-defined (spreadsheet) file 15, matches the graph representation required for analysis / evaluation of building operation data. Many formats are available as files. This template file is used when creating a new graph / form, and is edited / processed as necessary. In the template file, various graph formats that are assumed to be used, such as broken lines, bars, stacked, composite, and biaxial use, are prepared as templates.

  In the template file, it is also possible to perform arithmetic processing on the acquired data. As such arithmetic processing, for example, a method of using the obtained raw data by processing with a calculation formula on a sheet displayed on the screen and plotting the processed result on a graph can be considered. In the template stored in the template file, sheet data and a graph are linked as shown in 15a and 15b. Further, as shown in 15b, the axis and format can be edited, and characters and figures can be added and edited. The file edited by the user in this way is registered in the LCM data analysis server 5 and can be accessed by other users.

  After editing and processing the above template file in worksheet and graph format, the edited file is a list of data to be graphed and the graph format after editing and processing. It is registered and managed every time. This edited file is called when a graph or a form is displayed on the WEB browser. An example of the edited file structure is shown in ○ 2.

  As described above, in using the format-defined (spreadsheet) file 15, the user can call any template file and freely edit data processing, graph format, and the like on the PC screen. Further, it can be registered in the LCM data analysis server 5 as an edited file.

  Next, the operation outline of FIG. 2 will be described. Various processing requests from the user PC such as graph / form display / registration / deletion are all executed on the LCM data analysis server 5, and only the result is displayed on the WEB browser of the user PC. Further, since the edited file is in a general spreadsheet format, it is possible to download and use the data itself.

  FIG. 3 is an explanatory diagram showing a menu list of software used in the system user PC in the embodiment of the present invention. In FIG. 3, 1. Graph setting mode is an editing mode for newly registering and changing a graph. “Display setting file list” performs setting file name list display (for editing target selection), group name editing, and setting file name editing.

  “Graph setting function”: (a) New creation, group designation and name input, start date designation, graph type selection and graph template selection, graph display format selection (spreadsheet or Web), tag (point data name) selection ,I do. In tag (point data name) selection, keyword search is performed. Further, (b) setting change, (c) copy (save as another name), and (d) spreadsheet file download. “Graph creation” uses graph display and spreadsheet functions to edit and upload edited files.

  2. The drawing mode is a browsing mode for displaying a registered graph. “Setting file list display” displays a list of setting file names (for editing target selection). In “Create Graph”, start date is specified, spreadsheet file is downloaded, and graph is displayed. The graph display is processed by changing the start date (1 day before / after, etc.).

  3. Batch input is a batch input function such as simulation data. Input is “building name selection” and “input file name designation (reference selection). 4. Maintenance is a system management function.“ User data ”includes new registration and editing, authority level setting, and so on. Change and set the target building name. “Building DB server data” is new registration and editing. “Template data” includes new registration and editing.

  4-15 is explanatory drawing which shows embodiment of this invention, and the image displayed on the screen of system user PC is shown. FIG. 4 shows an image display based on the operation of the system user in a series of flows. The circled numbers 1 to 10 in FIG. 4 correspond to the circled numbers in the image display in FIGS. FIG. 5 (◯ 1) is a login screen when the software “BA-Graphyzar” used in the embodiment of the present invention is activated. Log in with your username and password.

  FIG. 6 (◯ 2) is a menu screen. In “graph setting mode”, new registration / editing of a graph is performed. In the “drawing mode”, only the registered graph is displayed. “Batch input” registers simulation data and the like. “Maintenance” performs system management. FIG. 7 (◯ 3) to FIG. 12 (◯ 7) are graph setting mode screens that can be used only by specially authorized users. Hereinafter, these graph setting mode screens will be described.

  FIG. 7 (◯ 3) is a graph format / data selection screen. On this screen, (1) a graph type is designated. In this process, a time series of day, week, month, and year is selected in (a) “Select horizontal axis range”. (B) In “Select Graph Type”, select a line, a bar, a stack, etc. (C) Select “Template”. (2) Select data (tag) to be displayed. The tag is selected by selecting a tag No., and a tag name corresponding to the tag No. and an item for explanation are selected.

  FIG. 8 is an explanatory diagram showing an example of a “setting graph name list” displayed in the left column of FIG. In the “building name” column, the name of the target building for displaying the created data in a graph is displayed. In the “Group name graph name” column, for example, “Indoor environment 4F indoor temperature and outside temperature (for one day)”, “Attendance information 5F Number of people in seat and lighting power consumption (for one day)”, “Power usage Amount of power received by the main building (for one year), “Water consumption for main building Water consumption for main building – actual measurement and simulation values (for one year)”, etc. are displayed.

  FIG. 9 (◯ 4) is a graph editing (data calculation / processing possible) screen. This screen shows the initial state of plotting data on the graph template. The graph displayed in this way can be edited as appropriate and processed in a visually comprehensible form. FIG. 10 (◯ 5) is a registration (upload) screen. FIG. 10 shows an example of graph editing on the screen of FIG. In this example, the character size, color, font correction, broken line thickness, color change, background change are made, and the set temperature value (27 ° C.) is additionally written with lines and characters. In FIG. 10, the edited spreadsheet file is registered in the LCM data analysis server to complete the process. Thereafter, this graph format is stored in the LCM data analysis server and can be viewed by other users.

  FIG. 11 (◯ 6) is a data (tag) selection screen. This screen searches and selects data (tags) to be displayed. For example, when the attribute “temperature (t =)”, tag name “AHU”, and description “4F” are selected, “01-A-AHU401A_L01-STR-PVt = n”... 4FL slab lower surface temperature-1 (SE ) ”, 53 tags including the tag name“ AHU ”and the description“ 4F ”are displayed on the screen.

  FIG. 12 (◯ 7) is a data processing screen. In this screen, when data calculation / processing is required, a calculation formula can be written in a cell. In addition, the setting is changed so as to graph the calculation result. This processing is based on the operation procedure of the spreadsheet software. In the example of FIG. 12, the data of the temperature measurement result of the target place on October 1, 2004 is shown every hour.

  FIG. 13 (○ 8) to FIG. 15 (○ 10) are drawing modes that can be used if a part of authority is permitted even for users who are not given special authority such as new registration and editing of graphs. It is a screen. Hereinafter, each drawing mode screen will be described. FIG. 13 (○ 8) is a graph selection screen. On this screen, click the name of the graph you want to display from the registered graph names displayed on the left side. In the example of FIG. 13, “Whole building received power amount” is selected.

  FIG. 14 (○ 9) is a data start date selection screen. On this screen, specify the start date of the data to be graphed. In the example of FIG. 14, October 21, 2004 is designated. FIG. 15 (◯ 10) is a graph display screen. On this screen, the data based on the specified start date is displayed as a graph. The range of the horizontal axis when displaying a graph can be specified as day, week, month and year.

  The demands on the fluctuation data analysis system on the user side change from day to day, so the screens created with the conventional technology do not function effectively in practice, or there are requests for improvement in detail. come. As a solution to this problem, the present invention has developed a variation data analysis system having a screen editing function as described above. Especially when this system is applied to a BEMS analysis system, a building manager and a building designer himself can easily create a display screen (form, graph). Therefore, it is possible to configure a highly flexible system that can create screens for operation data evaluation and performance evaluation necessary for actual operation without cost and time.

  The embodiment of the present invention has been described above for the BEMS such as the indoor environment (temperature, power consumption, etc.) of a commercial building. The present invention is not limited to such BEMS, but is data that fluctuates in a time series within a certain period, for example, according to the time transition of a day, such as outdoor temperature, wind speed, dam water level, etc. It is generally applicable when analyzing, editing, and processing. Moreover, although the example which analyzes the data which fluctuate | deviate within a fixed period as the minimum period was demonstrated, for example, it is also possible to set 1 hour as the minimum period. As described above, the minimum period for analyzing the data fluctuation can be arbitrarily set as necessary.

  As described above, according to the present invention, it is possible to provide a fluctuation data analysis system that analyzes, edits, and registers data that fluctuates in time series within a certain period, for example, according to a time transition of one day. it can.

1 is a system configuration diagram according to an embodiment of the present invention. It is explanatory drawing of the software structure which concerns on embodiment of this invention. It is explanatory drawing of the menu list which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention. It is explanatory drawing which concerns on embodiment of this invention.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... Fluctuation data analysis system, 2-4 ... Building for fluctuation data analysis, 5 ... LCM data analysis server, 6, 7 ... System user PC, 8 ... Communication network (Internet / Intranet), 11 ... BA history management database, 12 ... Data extraction program, 13 ... WEB, 14 ... Spreadsheet, 15 ... Format-defined file

Claims (10)

A fluctuating data analysis system in which a data accumulation server that accumulates data that fluctuates in time series with a time transition within a certain period, a data analysis server, and a user terminal are connected via a communication network,
In response to a request from the user terminal, the predetermined data is acquired from the data storage server and displayed on the screen of the user terminal, and the data is displayed on the screen according to the authority set in advance by the user. The fluctuation data analysis system is characterized in that the necessary editing and processing are performed on the expression method and the result is registered in the data analysis server. The fluctuation data analysis system according to claim 1, wherein the user terminal performs the necessary editing and processing by analyzing the data using general-purpose spreadsheet software. Data requested from the user terminal to the data storage server is formed in the form of a graph or a form by the data analysis server, and the data in the form of the graph or form is displayed on the screen of the user terminal. The variation data analysis system according to claim 1, wherein various editing and processing are performed. 4. The fluctuating data analysis system according to claim 1, wherein the data fluctuating in time series is edited and processed in units of days, weeks, months, and years. 5. The data registered in the data analysis server in the form of a graph or a form can be used by a user terminal according to the authority of another user, according to any one of claims 1 to 4. Fluctuation data analysis system. 6. The fluctuating data analysis system according to claim 1, wherein the data fluctuating in time series is applied to BEMS. The fluctuation data analysis system according to claim 6, wherein the data storage server is an LCM data storage server, and the data analysis server is an LCM data analysis server. The fluctuation data analysis system according to claim 7, wherein a plurality of said LCM data storage servers and a plurality of said user terminals are installed and connected to said communication line. The fluctuation data analysis system according to any one of claims 1 to 8, wherein the communication network is the Internet or an intranet. The variation data analysis according to any one of claims 1 to 9, wherein the authority set in advance for the user is any one or all of browsing, editing, and registration of the data. system.

Images