JP7128687B2 - Restaurant business condition visualization system - Google Patents

Description

The present invention visualizes the business conditions of restaurants in each area into which the visualization target area is divided into a plurality of areas so that they can be distinguished by area. The present invention relates to a restaurant business condition visualization system created by data arithmetic processing and transmitted to a user terminal of a data user.

As a system that creates the business conditions of restaurants by computer data processing, it is a restaurant that evaluates and predicts the operating status of each restaurant, such as the degree of occupancy, based on the amount of utility usage such as gas usage at that restaurant. A store evaluation system has been proposed (see, for example, Patent Document 1 below).

JP 2015-170063 A

The above restaurant evaluation system is an effective tool for objectively evaluating the business conditions of individual restaurants. It is inappropriate to consider

Usually, especially in urban areas, a certain number of restaurants are concentrated in an area of a certain size, so consumers who want to eat and drink gather in the area, and the restaurant business as a whole area. may be higher. Therefore, if a region can be divided into multiple areas and the business conditions of restaurants in each area can be objectively evaluated, individuals or companies that are considering opening new restaurants can It is possible to provide the business conditions of the evaluated restaurants. On the other hand, the business conditions of restaurants should be objectively grasped by the number of customers who actually visited the store in the area or the sales amount, but since detailed information on the number of customers and sales amount for each store is not disclosed, It cannot be used to objectively evaluate the business conditions of restaurants in various areas.

SUMMARY OF THE INVENTION The present invention has been made in view of the above-described problems, and its object is to provide a system suitable for objectively evaluating the business conditions of restaurants by area.

In order to achieve the above object, a restaurant business condition visualization system according to the present invention provides visualization data that visualizes the business conditions of restaurants in each area into which a visualization target area is divided into a plurality of areas so that they can be distinguished by area. A restaurant business condition visualization system that is created by the data arithmetic processing of and is transmitted to the user terminal of the data user who uses the visualization data via a predetermined data communication network,
a first database storing predetermined attribute data including location data relating to a gas user whose business type is a restaurant within a predetermined gas supply area including the visualization target area; comprising a second database that stores the usage amount, a data storage unit, a data input processing unit, and a data output processing unit,
a first data type group in which the type of the visualization data uses first type statistical data relating to increases and decreases in the amount of gas used by the gas users in each of the areas as index data representing the business conditions of the restaurant; A second data type group using second type statistical data relating to increases and decreases in the number of contracts of gas users in each area, and both the first type statistical data and the second type statistical data belongs to at least one data type group of the third data type group to be used,
The data input processing unit receives input data that individually designates input items including the visualization target area, the division granularity of the area, and the type of the visualization data transmitted from the user terminal, and the data storage unit configured to save to
The data output processing unit
The gas usage amount or attribute data within the visualization target period according to the type of the visualization data of each of the gas users existing in the same area, or Based on both of them, at least one of the first type statistical data and the second type statistical data determined by the type of the visualized data is created as the index data,
creating the visualization data for displaying the index data created for each area in a predetermined display format according to the type of the visualization data;
A first feature is that the visualization data is transmitted to the user terminal via the predetermined data communication network.

According to the restaurant business condition visualization system of the first feature, the data output processing unit outputs the visualization data of the type specified by the data user from the first database or the second database according to the type, gas usage Alternatively, it is possible to acquire and create information related to the number of contracts of gas users and transmit it to user terminals via a predetermined data communication network. It is possible to grasp other business conditions and consider which area is suitable for opening a restaurant.

What is noteworthy here is that the visualization data is created using data related to gas consumption and the number of contracts of gas users whose industry is a restaurant. In order to maintain a stable gas supply to many gas users, not only restaurants but also other industries and general households, gas companies have been collecting data on gas consumption and number of contracts for many years. Since the data is stored in a database, there is no need to bother to acquire the relevant data in order to evaluate the business conditions of restaurants by area. This data is formed by accumulating objective facts such as the amount of gas used and the number of contracts. In other words, visualization data created using objective, error-free data is extremely reliable.

Furthermore, in the restaurant business condition visualization system of the first feature, when there are a plurality of types of the visualization data saved as the input data, the data output processing unit performs the above for each type of the visualization data. A second feature is to create visualization data.

According to the restaurant business condition visualization system of the second feature, the data output processing unit creates visualization data for each of a plurality of types specified by the data user. It is possible to conduct a multifaceted study based on the visualization data.

Further, in the restaurant business condition visualization system having the first or second characteristic, the type of the restaurant is stored in the first database as one of the predetermined attribute data regarding the gas user,
The data input processing unit receives input data that individually designates input items including the visualization target area, the division granularity of the area, the type of the visualization data, and the type of restaurant transmitted from the user terminal. configured to receive and store in the data storage unit;
When the input data specifies a part of the types of restaurants, the data output processing unit targets only the gas users who belong to the specified types of restaurants, A third feature is that the process of creating the index data is performed.

According to the restaurant business condition visualization system of the third feature, when the trend of the business condition of restaurants by area changes depending on the type of restaurant, or when the data user is a specific type of restaurant When it is desired to evaluate business conditions for each area, it is possible to examine in more detail which area is suitable for opening a restaurant using the created visualization data.

Further, in the restaurant business condition visualization system having any one of the first to third characteristics, as the type of the visualization data belonging to the first data type group, the boundary of each area of the visualization target area is on the map , and within the boundary of each area, the ratio or rate of increase or decrease of the total amount of gas used by the gas user in each area over a period of a predetermined number of months to the total amount of gas used in the same period of the previous year, As the index data, first visualization data that is identifiably displayed by a difference in any one of color, shading, and pattern, and a year-on-year change in the total amount of gas used by the gas users in each of the areas, or the previous year It is preferable that the same-month increase/decrease rate includes, as the index data, at least one of second visualization data displayed in a graph in chronological order for each of the areas for each of the areas.

According to the above preferred embodiment, the data user can, for example, compare the business conditions by area throughout the year from the visualized data belonging to the first data type group, and grasp the general conditions of areas with high business conditions and areas with low business conditions. Furthermore, it is possible to grasp the situation such as whether the business conditions are stably high or whether the business conditions suddenly changed recently.

Furthermore, in the restaurant business condition visualization system having any one of the first to third characteristics, as the type of the visualization data belonging to the second data type group, the inside of each area of the visualization target area or the input data third visualization data in which the number of new contracts and the number of cancellations of the gas users in the specific area designated by the Display the boundaries of each of the areas of the visualization target area on a map, and within the boundaries of each of the areas or the specific areas specified by the input data, based on the number of new contracts and the number of cancellations of the gas users includes at least one of fourth visualization data identifiably displayed by a difference in any one of color, shading, and pattern as the indicator data. is preferred.

According to the preferred embodiment described above, the data user can easily distinguish, for example, an area where restaurant turnover is frequent and an area where it is not, from the visualization data belonging to the second data type group.

Further, in the restaurant business condition visualization system having any one of the first to third characteristics, the gas usage in each area of the visualization target area is set as the type of the visualization data belonging to the third data type group. The ratio or rate of increase or decrease of the total amount of gas usage over a period of a predetermined number of months to the total amount of gas usage for the same period of a predetermined number of years before is used as the first index data immediately before the same period of the predetermined number of years. The ratio or increase/decrease rate of the number of contracts of gas users immediately after the predetermined number of months to the number of contracts of gas users is the second index data, and one of the first and second index data is plotted on the vertical axis. , the fifth visualization data displayed for each area in a scatter diagram with the other as the horizontal axis, and the boundary of each area of the visualization target area are displayed on the map, and within a predetermined area on the scatter diagram at least one of sixth visualization data that is identifiably displayed by a difference in any one of color, shading, and pattern that exists within the predetermined area within the boundary of the area that exists in the is preferred.

According to the above preferred embodiment, the data user can, for example, select areas where both the total gas consumption and the number of contracts (that is, the number of stores) are increasing from the visualization data belonging to the third data type group. Areas where the total gas consumption is decreasing but the number of contracts is increasing are identified as areas where the competition between stores is intensifying, and the total gas consumption is Areas where the number of contracts is increasing but the number of contracts is decreasing are identified as areas where competition between stores has subsided, and areas where both the total gas consumption and the number of contracts are decreasing are considered to be declining as restaurants. It can be grasped as an area where

According to the restaurant business condition visualization system according to the present invention, various visualizations are provided as objective criteria that can be used for data users to consider which area is suitable for opening a restaurant. data can be provided.

1 is a block diagram schematically showing one configuration example of a restaurant business condition visualization system; FIG. 4 is a flow chart showing an outline of an example of a processing procedure of a data input processing unit and a user terminal in data input processing; 4 is a flowchart showing an outline of an example of a processing procedure of a data output processing unit in data output processing; A list that briefly summarizes the types of visualization data and the content of index data to be used. The figure which shows typically the example of an image display of 1st visualization data. The figure which shows typically the example of an image display of 2nd visualization data. The figure which shows typically the image display example (A) of 3rd visualization data, and the image display example (B) of 4th visualization data. The figure which shows typically the image display example (A) of 4th visualization data, and the image display example (B) of 5th visualization data.

An embodiment of a restaurant business condition visualization system (hereinafter abbreviated as "this system" as appropriate) according to the present invention will be described below with reference to the drawings.

[Configuration example of this system]
This system 1 creates visualization data that visualizes the business conditions of restaurants in each area in which the visualization target area is divided into multiple areas so that it can be distinguished by area, based on the amount of gas used by the restaurants in the area. , to process data to be transmitted to the user terminal 21 of the data user.

In this embodiment, a user who uses this system 1 accesses this system 1 from a user terminal 21 via a predetermined data communication network 20 such as the Internet, and inputs input data necessary for creating visualization data. The user terminal 21 receives the visualized data generated by the system 1 via the data communication network 20 and displays it on the display screen of the user terminal 21 for use. Data users. The data user is, for example, a sales representative of a gas company that supplies gas in the visualization target area, or an individual or company who opens a restaurant in the visualization target area. 1 is assumed to be a registered user who has registered as a member in advance.

The gas used in restaurants is fuel gas such as city gas, which is used as a heat source for cooking. Attribute information (contract number, contractor name, type of restaurant, supply start date, address, etc.) and monthly gas consumption of restaurants that are contractors are stored in the database of the gas supplier (hereafter referred to as the "operator database ”). Therefore, in this embodiment, the restaurant is a gas user who uses gas supplied from the gas supplier for cooking, etc., and the restaurant that is not registered in the supplier database and is not a gas user is processed by the system 1. Not covered. Hereinafter, in the description of the system 1, the terms "restaurant" and "gas user" are synonymous unless otherwise specified, except for the description of the business database.

As shown in FIG. 1, the system 1 includes a data input processing section 11, a data output processing section 12, a data storage section 13, a first database 14, and a second database 15. FIG.

The system 1 is configured as a WEB server system, and one or a plurality of users (data users) can access a predetermined URL (uniform In response to the access, the data input processing unit 11 and the data output processing unit 12 send predetermined WEB display screen data to the user terminal 21 of the user who made the access. The WEB display screen is displayed on the display screen of the user terminal 21 by the browser software for displaying WEB data installed in the user terminal 21 .

The data input processing unit 11 receives a visualization data creation request from the user terminal 21 together with the input data necessary for the creation via the data communication network 20, and stores the input data in the data storage unit 13 ( data entry process). Specifically, when the data input processing unit 11 completes user authentication through a predetermined login process for access from the user terminal 21, the WEB display screen data for accepting a visualization data creation request is Send to the user terminal 21 . The user inputs the items required for the creation request, which will be described later, on the screen for requesting creation of visualization data displayed on the display screen of the user terminal 21, and the data input processing unit 11 uses the items as input data. Send to When the data input processing unit 11 receives the input data and executes the above-described data input processing, the data output processing unit 12 creates visualization data, which will be described later, based on the input data stored in the data storage unit 13. Start execution of transmission processing. Note that the transmission and reception of the visualization data creation request and the input data between the data input processing unit 11 and the user terminal 21 do not necessarily have to be performed at the same time, and may be processed in two stages.

The input data is data in which three input items, including visualization target area, area division granularity, and visualization data type, are individually specified. The visualization target area is designated, for example, by one or more administrative districts (Osaka Prefecture, Osaka City, etc.). The area division granularity designates the degree of fineness when dividing the visualization target area into a plurality of areas in multiple stages. For example, the four levels of classification granularity are composed of a prefecture level (first level), a county/city level (second level), a ward/town/village level (third level), and a town/cage level (fourth level). As an example, "1-chome, Hirano-cho, Chuo-ku, Osaka-shi, Osaka" becomes "Osaka-fu" in the first-level area, "Osaka-shi, Osaka" in the second-level area, and " Chuo-ku, Osaka-shi, Osaka", and in the 4th level area, it will be "1-chome, Hirano-cho, Chuo-ku, Osaka-shi, Osaka". In addition, since the visualization target area is divided into a plurality of areas with the division granularity of the specified area, it is necessary to specify a wider range than each area determined by the division granularity. For example, when the classification granularity is the first level, the visualization target area is composed of a plurality of prefectures.

In addition, the method of specifying the visualization target area and the classification granularity of the area is the above-mentioned prefecture level (first level), county and city level (second level), ward level (third level), town c letter level (third level) 4 levels), for example, the classification granularity may be 3 or 5 stages instead of 4 stages. Furthermore, the finest level of classification granularity may be further subdivided than the Chocho-ji level. Also, the visualization target area does not necessarily have to cover all of Japan.

The type of visualization data is the type of display content of visualization data prepared in advance in this system 1 (the type of statistical data representing the business conditions of restaurants and the display format of the statistical data), and the first data It belongs to at least one of the data type group, the second data type group, and the third data type group. The first to third data type groups are for classifying the types of visualized data for convenience, and the visualized data targeted by the present system 1 are not necessarily the first to third data type groups. It does not mean that they are classified into one data type group.

The visualization data belonging to the first data type group is the first type of statistical data relating to changes in the amount of gas used by restaurants in each area, and is displayed in a map display or graph display format. The visualization data belonging to the second data type group is the second type of statistical data relating to increases and decreases in the number of contracts for restaurants in each area, and is displayed in a map display or graph display format. In the visualization data belonging to the third data type group, both the first type statistical data and the second type statistical data are displayed in a map display or graph display format. As an example, for the type of visualized data, a type name that can distinguish between the content of the statistical data to be displayed and the map display or graph display is prepared in advance. One or more of the type names can be specified. Specific examples of types of visualization data will be described later.

Following the data input processing of the data input processing unit 11, the data output processing unit 12 performs creation and transmission processing (data output processing) of one or more visualization data based on the input data stored in the data storage unit 13. Run. Specific processing contents of the data output processing will be described later.

The data input processing unit 11 and the data output processing unit 12 are configured on a general computer system including an arithmetic device such as a CPU (Central Processing Unit), a storage device such as a semiconductor memory, a communication device, and the like. . Specifically, the processing executed by each of the processing units 11 and 12 is such that a program code of a computer program describing specific processing contents is stored in the storage area of the storage device, and the arithmetic device It is executed by running the program.

In this embodiment, it is assumed that the data communication network 20 is the Internet, and the communication device used by the data input processing unit 11 and the data output processing unit 12 communicates with the user terminal 21 via the Internet 20 using a predetermined communication protocol. It is a communication device (hardware and software) capable of transmitting and receiving data with.

The data storage unit 13 includes, for example, a storage device capable of storing large amounts of data in a non-volatile manner such as an HDD (hard disk drive) and an SSD (solid state disk). , reading, searching, etc. are possible.

The first database 14 stores predetermined attribute data relating to gas users whose business type is restaurants within a predetermined gas supply area. configured as possible. The predetermined gas supply area corresponds to the maximum range that can be selected as the visualization target area, which is one of the input items of the input data described above.

The first database 14 is connected to the above-described operator database (not shown) via a data communication network (not shown) such as a LAN (Local Area Network) or a WAN (Wide Area Network) different from the data communication network 20. ) can be replicated in the first database 14, and is periodically (for example, daily, weekly, or monthly) synchronized with the business database, and the first It is configured to update data in the database 14 . The duplicated data is the attribute data of gas users whose industry is a restaurant among the attribute data of all gas users (including gas users other than restaurants) registered in the business database. Yes, including at least the gas user's contract number and location (address). In addition, the location (address) of the attribute data is recorded down to, for example, the chocho (fourth level) or less so that it is possible to judge whether it belongs to the area when it is divided with the finest granularity of the area classification granularity. It shall be

The second database 15 stores the amount of gas used for each predetermined period (for example, one month) in the past for a predetermined period (for example, three years) by the gas user whose business type is a restaurant registered in the first database 14. (Monthly gas usage amount) is stored, and data can be written, read, searched, etc. under the control of the arithmetic unit.

Similar to the first database 14, the second database 15, via a data communication network (not shown) such as a LAN or WAN, which is separate from the data communication network 20, is used within the above-mentioned operator database (not shown). part of the data can be replicated in the second database 15, and periodically (for example, daily, weekly, or monthly) is synchronized with the business database, and the second database 15 It is configured to update data in The data to be replicated is data for a predetermined past period (for example, 3 to 5 years) of the gas user whose industry is a restaurant among the gas usage data of all gas users registered in the business database. ), and is recorded in a searchable manner using the gas user's contract number. Therefore, the data registered in the first database 14 and the second database 15 can be interconnected through the gas user's contract number.

In this embodiment, the gas users registered in the first database 14 and the second database 15 were gas users within a predetermined period of time (for example, within 3 to 5 years). Restaurants that have canceled supply contracts and are not currently gas users (hereinafter referred to as “exit restaurants” as appropriate) are also included.

In the above explanation, the business operator database was explained as one database, but like the first database 14 and the second database 15, a part for storing attribute data of gas users and a monthly gas usage amount are stored. The part may be separated and configured as two or more databases.

The user terminal 21 is a general computer system capable of accessing the Internet 20, accessing a WEB site on the Internet 20, and displaying the WEB page screen on its own display screen. and tablet terminals, etc. are assumed.

[Processing content of this system]
Next, the contents of each process executed by the data input processing section 11 and the data output processing section 12 of the system 1 will be described with reference to the drawings. In the following explanation, each user (data user) has already completed the registration procedure with this system 1, and has a user ID and authentication procedure necessary for accessing the website of this system 1. The password etc. have already been set. In addition, since all data transmission/reception between the system 1 and the user terminal 21 is carried out via the data communication network (Internet) 20, description thereof will be omitted as appropriate. Furthermore, in data transmission/reception, it is assumed that the data transmission side performs encryption processing according to a predetermined method, and the data reception side performs decryption processing that conforms to the method. A description of the encoding and decoding processes is omitted.

[Data input processing]
FIG. 2 shows, in time series, the processing contents of the data input processing unit 11 of the system 1 and the transmission and reception of data between the data input processing unit 11 and the user terminal 21 in the data input processing (step #10). It is a flow chart.

In the data input process (step #10), first, a user (data user) who wishes to use the visualized data accesses the system 1 by specifying a predetermined URL from the user terminal 21, and performs a predetermined user authentication procedure. Later, when a predetermined WEB page for data input processing is accessed (step #201), the data input processing unit 11, in response to the access, transmits the input screen data of the input items to the user terminal 21 of the accessing user. (step #101).

In the user terminal 21, the input screen data is processed by the browser software for displaying the WEB page, and the input screen of the input item is displayed on the display screen of the user terminal 21 (step #202). On the input screen, the user selects each input item (visualization target area, area division granularity, and visualization data type) in the input space of the input item, for example, directly or from a pull-down menu. is selected and entered (step #203). When the input work for each input item is completed, the user transmits each input item specified on the input screen as input data to the system 1 (step #204).

When the data input processing unit 11 receives the input data transmitted from the user terminal 21 (step #102), it attaches data identification information to the received input data and stores it in the data storage unit 13 (step #103). ). The data identification information is composed of, for example, the user ID of the user who made the access and the date and time when the data was received.

The data input processing (step #10) of the data input processing unit 11 is executed separately each time any of the registered users starts the processing of step #201.

[Data output processing]
FIG. 3 shows, in time series, the processing contents of the data output processing unit 12 of the system 1 and the transmission and reception of data between the data output processing unit 12 and the user terminal 21 in the data output processing (step #11). It is a flow chart.

Data output processing (step #11) is for the user who started the processing of step #201 above, based on the input data saved in the data storage unit 13 in step #103, to create one or a plurality of visualization data. and transmits it to the user terminal 21 of the user.

Specifically, when the data input process (step #10) ends, the data output processing unit 12 identifies the visualization target area based on the input data saved in the data storage unit 13, and The target area is divided based on the area division granularity, and each area is specified (step #111). Subsequently, for each specified area, predetermined statistical data representing the business conditions of restaurants according to the type of visualization data is calculated as index data (step #112). Subsequently, visualization data is created that displays the index data calculated for each area in a predetermined display format according to the type of visualization data (step #113).

In the area identification processing in step #111, all the possible set visualization target areas (that is, the above-mentioned predetermined gas supply area) are divided into a plurality of areas corresponding to each level of area division granularity. It is assumed that the area number of the area is set in advance. For example, the area number consists of 10 hexadecimal or decimal numbers, the upper two digits specify the prefecture level (first level), the next two digits specify the county city level (second level), The next three digits specify the ward/town/village level (third level), and the lower three digits specify the town/chouji level (fourth level). Here, as an example, the 2-digit or 3-digit number of each level "00" or "000" designates the entire area of the level. As a result, for example, when the area division granularity is the third level, the lower three digits of the area numbers of the areas divided by the division granularity are all "000", and the area division granularity is the second level. In the case of , the lower six digits of the area numbers of the areas divided by the division granularity are all "000000".

Further, in the visualization target area identification processing in step #111, the visualization target area is identified using the upper seven digits of the area number (hereinafter referred to as "target area code"). If the visualization target area includes a plurality of prefectures, county cities, or wards, towns and villages in the first to third levels, the visualization target area is specified by combining multiple target area codes. Also, when the visualization target area is specified at the first level of area division granularity, the lower 5 digits of the target area code are "00000", and when specified at the second level of area division granularity , the lower three digits of the target area code are "000".

Therefore, in the area specifying process in step #111, all areas where the upper seven digits of the area number match one or more target area codes of the specified visualization target area are selected.

The index data calculation process in step #112 is performed for each area identified in step #111. Specifically, the correspondence between the contract number and the area number of the gas user in each identified area is determined based on the location (address) of the attribute data of each gas user stored in the first database 14. It is determined in advance using a table or the like, and in preparation for calculating the index data, the corresponding relationship (table) is used to extract the contract numbers of gas users existing in each specified area. Here, the gas user who canceled the gas supply contract within the visualization target period according to the visualization data type and became a withdrawal restaurant also used gas during the visualization target period. subject to extraction.

The index data calculated in step #112 differ according to the type of visualization data. In this embodiment, as shown in FIG. 4, as the types of visualization data, first visualization data and second visualization data belonging to the first data type group, third visualization data and fourth visualization data belonging to the second data type group Data and six types of visualization data, that is, fifth visualization data and sixth visualization data belonging to the third data type group are assumed. However, as described above, the types of visualization data targeted by the present system 1 do not need to include these six types of first to sixth visualization data, and may target only some of them. In addition to or in place of at least one of the first to sixth visualization data, types of visualization data other than the first to sixth visualization data may be targeted.

The index data used in the first and second visualization data is the first type of statistical data related to changes in the amount of gas used by gas users in each area. The ratio (UY1/UY2) or rate of change ((UY1 -UY2)/UY2) is used as index data, and in the second visualization data, the total monthly gas usage (UM1i,i = 1 to m) to the monthly total gas usage (UM2i, i = 1 to m) in the same month of the previous year (compared to the same month of the previous year: UM1i / UM2i, i = 1 to m) or rate of change (rate of change in the same month of the previous year: (UM1i-UM2i)/UM2i, i=1 to m) is used as index data. Here, each of the total gas usage amounts is obtained by totaling the gas usage amount for a predetermined number of months or by month for each area for each gas user.

In calculating the index data (UY1/UY2 or (UY1-UY2)/UY2) of the first visualization data, the data output processing unit 12 uses the contract number of each target gas user in each area as a clue, 2 From the database, the monthly gas usage amount for the last predetermined number of months and the same period of the previous year is read, and each total gas usage amount for each gas user for the latest predetermined number of months and the same period of the previous year is calculated. Then, for each area, total gas usage for each gas user is calculated, total gas usage (UY1) and total gas usage (UY2) are calculated, and index data (UY1/UY2 or (UY1 - Calculate UY2)/UY2).

Furthermore, in calculating the index data (UM1i/UM2i, i = 1 to m) of the second visualization data, the data output processing unit 12 uses the contract number of each target gas user in each area as a clue, 2 From the database, read the monthly gas usage for the last predetermined number of months m and the same period of the previous year, aggregate the monthly gas usage by area and month, and Calculate the total gas usage (UM1i, UM2i, i = 1 to m) of each month, and calculate the ratio or increase/decrease rate of the total gas usage (UM1i, UM2i, i = 1 to m) for each month Then, index data (UM1i/UM2i or (UM1i-UM2i)/UM2i, i=1 to m) is calculated.

The index data used in the third and fourth visualization data is the second type of statistical data related to changes in the number of gas user contracts in each area. Using the number of new contracts (EMi, i = 1 to m) and the number of cancellations (CMi, i = 1 to m) by month over a predetermined number of months m (for example, m = 12) as index data, the fourth visualization data Then, from the number of new contracts (EMi, i = 1 to m) and the number of cancellations (CMi, i = 1 to m) by month, the intensity of the replacement of restaurants calculated by the following equation 1 is shown. Store variation index VI is used as index data.

(Number 1)
VI=((σE/AE) ² +(σC/AC) ² ) ^0.5

However, in Equation 1, σE and AE are the standard deviation and average value of the number of new contracts (EMi, i = 1 to m) in the predetermined number of months m, and σC and AC are the number of cancellations in the predetermined number of months m ( CMi, i = 1 to m) standard deviation and mean values.

In calculating the index data (EMi, CMi, i = 1 to m) of the third visualization data, the data output processing unit 12 uses the contract number of each target gas user in each area as a clue to calculate the second database , the monthly gas usage for the last specified number of months and the previous month are read out, and gas users who did not enter the monthly gas usage in the previous month and who newly entered the monthly gas usage in the current month are new gas users. The number of new gas users was aggregated by area and month to calculate the number of new contracts (EMi, i = 1 to m), and the monthly gas usage amount was entered in the previous month. , the number of gas users who no longer input monthly gas usage in the current month is judged to be a withdrawal restaurant, and the number of withdrawal restaurants is aggregated by area and month, and the number of cancellations (CMi, i = 1 ~ m) is calculated.

Furthermore, the data output processing unit 12 calculates the index data (store variation index VI) of the fourth visualized data in the above-described manner, and converts the index data (EMi, CMi, i = 1 to m) of the third visualized data into First, calculate the number of new contracts by area (EMi, i = 1 to m) and the number of cancellations (CMi, i = 1 to m) by month, and use the derivation formula shown in Equation 1 to calculate store fluctuations. Calculate the index VI.

The index data used in the fifth and sixth visualization data are both the first and second types of statistical data, and in the fifth and sixth visualization data, the most recent predetermined The total gas usage (UY1) over a period of months m (eg, m = 12) is increased or decreased ( ΔUY=UY1-UY3) with respect to the total gas usage (UY3) for the same period n years before the specified number of years (ΔUY/UY3), and the number of contracts for gas users during the same period (m months) for the same period n years before the specified number of years from just before to just after the last predetermined number of months m (that is, before and after n years and m months have elapsed), the rate of change (ΔN/N0) is used as index data. Here, ΔN is the increase or decrease in the number of gas user contracts from just before the same period of a predetermined number of years n years ago to just after the most recent predetermined number of months m, and is given by ΔN=N1−N0. N1 is the number of contracts in the last month of the last predetermined number of months m, and N0 is the number of contracts in the previous month of the same period n years before.

In calculating the first index data (ΔUY/UY3) of the fifth and sixth visualization data, the data output processing unit 12 uses the contract number of each target gas user in each area as a clue to calculate the second From the database, the monthly gas usage amount for the same period of the latest predetermined number of months m and the predetermined number of years ago is read out, and each total gas usage amount of each gas user during the same period of the latest predetermined number of months m and the predetermined number of years ago. , total gas usage for each gas user in each area, calculate total gas usage (UY1) and total gas usage (UY3), and obtain the first index data ( ΔUY/UY3) is calculated.

Furthermore, in calculating the second index data (ΔN/N0) of the fifth and sixth visualization data, the data output processing unit 12 uses the contract number of each target gas user in each area as a clue, From the second database, read the monthly gas usage amount for each gas user in the last month of the last predetermined number of months m, and the monthly gas usage amount is not 0 (that is, the gas supply contract is valid and gas is being used) gas Count the number of users, calculate the number of contracts N1, read out the monthly gas usage amount for each gas user in the previous month during the same period n years before the specified number of years, and read out the gas user whose monthly gas usage amount is not 0 is counted, the number of contracts N0 is calculated, the increase/decrease number ΔN (=N1−N0) of the number of contracts is calculated, and the second index data (ΔN/N0) is calculated.

As the first index data of the fifth and sixth visualization data, instead of (ΔUY/UY3), (UY1/UY3) is used, and as the second index data, instead of (ΔN/N0), (N1/N0) may be used.

The visualization method (display format) of the index data used in the visualization process of step #113 differs according to the type of visualization data. The display format of the index data is roughly classified into four types.

In the first display format, in each area specified in step #111 displayed on the map, one index data calculated in step #112 is displayed according to any one of color, shade, and pattern. It is a format to be displayed in an identifiable manner.

In the second display format, in each area specified in step #111 displayed on the map, areas where the mutual relationship between the two index data calculated in step #112 satisfies a predetermined condition are displayed. This is a format in which an area is displayed so as to be distinguishable from other areas by any one difference in color, shade, or pattern.

A third display format is a format in which one index data calculated in step #112 is graphically displayed for each area in chronological order for each month.

A fourth display format is a format in which the two index data calculated in step #112 are graphically displayed as a scatter diagram in which one is plotted on the vertical axis and the other on the horizontal axis as a scatter diagram.

When the first and second display formats are used in the visualization processing of step #113, the data output processing unit 12 converts the visualization target area and each of the identified areas identified in step #111 into a predetermined map image. In order to make it identifiable on the above, the boundaries of each specified area (outer boundary lines) are displayed with solid lines, etc., and the contrast or shading of the underlying map image is displayed so that the boundaries are emphasized. is reduced, and the entire area within each area surrounded by the boundary line is displayed in any one of color, shade, and pattern according to the index data calculated in step #112.

In the visualization process of step #113, when the third display format is used, the data output processing unit 12 uses a graph format (line graph, bar graph, etc.) according to the type of visualization data and a preset format, in step Display the index data calculated in #112 in a graph.

When the fourth display format is used in the visualization process of step #113, the data output processing unit 12 outputs the two index data calculated in step #112 in a format preset according to the type of visualization data. The area corresponding to the two index data is plotted at the coordinate points on the scatter diagram indicated by using a figure of a predetermined format to create a scatter diagram consisting of a set of plots for each area.

The data output processing unit 12 performs visualization processing on the index data of the first and fourth visualization data in the first display format, and performs visualization processing on the index data of the sixth visualization data in the second display format, The index data of the second and third visualized data are visualized in the third display format, and the index data of the fifth visualized data are visualized in the fourth display format.

Note that the index data calculation process of step #112 and the visualization process of step #113 are performed when the input data received from the user terminal 21 in the data input process (step #10) specifies multiple types of visualization data. , which is not shown in FIG. 3, is repeatedly executed a plurality of times for each type.

The map display and graph display performed in the visualization process of step #113 are performed using rendering software or the like according to each display, and the visualization data is installed in the user terminal 21. Since it is created in a format that allows image display by existing web page display browser software, the technical content is well known, and detailed description thereof will be omitted.

Finally, the data output processing unit 12 transmits one or a plurality of visualization data created through steps #111 to #113 to the user terminal 21 that transmitted the input data (step #114).

[Image display example of visualized data]
One or more visualization data created by the data output process (step #11) and transmitted to the user terminal 21 can be viewed by the user using the browser software used when creating the input data (steps #201 to #203). It is displayed on the display screen of the terminal 21 in a display format corresponding to the type of visualization data. 5 to 8 show image display examples of the first to sixth visualized data displayed on the display screen of the user terminal 21, respectively. In each of the first to sixth visualization data shown in FIGS. 5 to 8, as an example, the visualization target area is Chuo Ward, Osaka City, Osaka Prefecture, and the area division granularity is the fourth level.

In the image display example of the first visualization data shown in FIG. 5, when the index data is the rate of change from the previous year ((UY1-UY2)/UY2) of the total gas usage for 12 months by area, the visualization target The boundary of each area is indicated by a solid line on the map including the area, and the index data of each area is schematically indicated by grayscale shading. In an actual embodiment, since the display screen of the user terminal 21 is normally capable of color display, it is preferable to display the index data in color instead of gray scale gradation display.

On the map shown in FIG. 5, the contents of the first to fourth levels of classification granularity are displayed outside the frame of the map screen. In the example shown in FIG. 5, the first to third levels indicate visualization target areas, and the fourth level indicates the division level of each area. Furthermore, when a specific area is indicated by a mouse pointer or finger (if the display screen has a touch sensor function), the indicated area's "chocho" is displayed within the frame of the fourth level. It is also preferable to

In the image display example of the second visualized data shown in FIG. 6, as index data, the rate of change in the same month of the previous year ((UM1i-UM2i)/UM2i, i=1 to 12) of the total gas usage by month is displayed as a line graph for each area. is displayed in

In the image display example of the third visualized data shown in FIG. 7(A), the number of new contracts (EMi, i=1 to 12) and the number of cancellations (CMi, i= 1 to 12) are displayed as line graphs by area. As an example of the two specific areas, areas with the largest and smallest store fluctuation index VI are selected.

In the image display example of the fourth visualization data shown in FIG. 7B, when the index data is the store variation index VI, the boundary of each area is displayed with a solid line on the map including the visualization target area, and the store variation index Areas with the maximum and minimum VIs are schematically represented by gray scale shading so that they can be distinguished from other areas. In an actual embodiment, since the display screen of the user terminal 21 is normally capable of color display, it is preferable to display the index data in color instead of gray scale gradation display. The number of areas to be displayed on the map is not necessarily limited to the areas where the store variation index VI is maximum and minimum, and all areas may be displayed, and the store variation index VI is within a certain range. Only areas may be selectively displayed.

Note that the arrows between FIGS. 7A and 7B are intended to facilitate understanding of the correspondence between the third and fourth visualization data, and are not necessarily attached in the actual embodiment.

In the image display example of the fifth visualization data shown in FIG. 8A, as the first index data, the total gas usage (UY1) for the most recent 12 months and the total gas usage for the 12 months three years before The rate of change (ΔUY/UY3) with respect to (UY3) is used as the second index data, and the rate of change (ΔN /N0), and on a scatter diagram with the first index data on the horizontal axis and the second index data on the vertical axis, the first and second index data in each area are indicated by the symbol An example plotted using is displayed.

Areas in the first quadrant of the scatter diagram shown in Fig. 8 (A) (the rate of increase/decrease in total gas consumption is positive, the rate of increase/decrease in the number of contracts is positive) indicates that the business conditions of restaurants are in the "revitalized" state. In the area in the second quadrant of the scatter diagram (negative rate of change in total gas consumption, positive rate of change in the number of contracts), it is estimated that the business conditions of restaurants are in a state of "intensifying competition". In the area in the third quadrant of the scatter diagram (negative rate of change in total gas consumption, negative rate of change in the number of Areas in the fourth quadrant of the scatter diagram (positive increase/decrease rate of total gas consumption, negative increase/decrease rate of number of contracts) are presumed to be in a state of "calm down competition" for restaurants.

In the image display example of the sixth visualization data shown in FIG. 8B, the boundary of each area is displayed with a solid line on the map including the visualization target area, and the first scatter diagram of the image display example of the fifth visualization data Areas within the quadrants are displayed in dark gray with grayscale shading so that they can be distinguished from other areas. In an actual embodiment, since the display screen of the user terminal 21 is normally capable of color display, it is preferable to display the index data in color instead of gray scale gradation display. In this case, it is preferable to assign a different color to each quadrant so that all four quadrant areas are displayed in different colors. Furthermore, the areas dispersed in the scatter diagram of the image display example of the fifth visualization data are classified more finely than the first to fourth quadrants, and displayed in different colors on the map shown in FIG. 8(B). It is also preferable to

[Another embodiment]
Next, another embodiment of the above embodiment will be described.

<1> In the above-described embodiment, in the above-described data input process (step #10), the input data is input by the user on the display screen of the user terminal 21 for each input item (visualization target area, area division granularity, and , type of visualization data) is created by entering it in the input space of the input item. The default input contents may be selected for the input items for which the user has not performed an input operation.

Furthermore, the timing at which the input data is created is not limited to when the user (data user) accesses the WEB page for data input processing from the user terminal 21, as described in the above data input processing (step #10). , After the visualized data created by the data output process (step #11) is received by the user terminal 21 and displayed on the display screen, the screen shifts to the input screen for each input item provided on the display screen of the visualized data. Each input item may be redesignated by clicking a button or the like with a mouse or the like.

Furthermore, it is also a preferred embodiment to add the type of restaurant as an input item constituting the input data, in addition to the visualization target area, the area division granularity, and the type of visualization data. In this case, the first database 14 needs to store the type of restaurant as the attribute data of each gas user. Note that the type of restaurant is stored in advance in the first database 14 as attribute data, and only when the type of restaurant is specified as an input item, the type of restaurant stored in the first database 14 is used. A search may be made to identify the corresponding gas user. As an example of the type of restaurant, it is assumed that it is classified by the type of food served (for example, Japanese food, Western food, Chinese food, noodles, ramen, sushi, cafe, etc.), but it is classified by other methods. It may be a type (for example, the number of customers accommodated in a store, etc.). The timing of specifying the input item for the type of restaurant is determined when the user (data user) accesses the WEB page for data input processing from the user terminal 21, as described in the above data input processing (step #10). After the visualized data created by the data output process (step #11) is received by the user terminal 21 and displayed on the display screen, a button or the like to move to an input screen for narrowing down the type of restaurant can be displayed with the mouse. The type of the restaurant may be specified by clicking on the button.

<2> In the above embodiment, the data output processing unit 12 identifies the visualization target area based on the input data saved in the data storage unit 13 in step #111 of the data output processing (step #11), A case has been described where the identified visualization target area is divided based on the area division granularity and each area is identified. However, depending on the specified visualization target area, the specified area may include an area with no restaurants or an area with very few restaurants. For example, in areas where there are no restaurants, it is impossible to calculate the index data described above. Furthermore, even if the number of restaurants is not 0, there is a high possibility that significant index data cannot be calculated if the number of samples is not sufficient within the visualization target period according to the type of visualization data. Furthermore, if the number of restaurants in an area is small, even if the index data can be calculated, the value does not necessarily represent the business conditions of the area, and the business conditions of individual restaurants. There is a possibility that it is index data that strongly depends on the degree.

Therefore, in step #111 of the data output processing (step #11), the data output processing unit 12 divides the visualization target area specified based on the area division granularity, and then the number of restaurants in each area is If the number is less than a predetermined number (eg, 5 to 30), it is also preferable to exclude the area from the visualization data creation target. Furthermore, in this case, the predetermined number or the range (lower limit, upper limit) of the number of restaurants in each area may be added to the input items constituting the input data so that the user can set it.

<3> In the above embodiment, it was assumed that the first visualized data and the second visualized data were independently image-displayed. However, for example, when a specific area on the map of the image display example of the first visualization data is indicated with a mouse pointer or finger (if the display screen has a touch sensor function), the second visualization data of that area is created, and the second visualization data is preferably displayed on a separate screen on the display screen of the user terminal 21 .

<4> In the above embodiment, the third visualized data and the fourth visualized data are associated with each other in terms of index data, but are assumed to be image-displayed independently. However, for example, when a specific area on the map of the image display example of the fourth visualization data is indicated with a mouse pointer or finger (if the display screen has a touch sensor function), the third visualization data of that area is created, and the third visualization data is preferably displayed on a separate screen on the display screen of the user terminal 21 .

<5> In the image display example of the fifth visualization data in the above embodiment, at first glance, each area on the scatter diagram is specifically which area, that is, which of the fourth level of area classification granularity Since it is unclear whether it is a "chocho", when a specific area is indicated with a mouse pointer or finger (if the display screen has a touch sensor function), the "chocho" of the indicated area will be displayed in the scatter diagram. It is also preferable to display at a predetermined location outside the frame. Furthermore, instead of or in addition to the display, only the designated area of each area displayed on the map of the image display example of the sixth visualization data is blinked or displayed in a specific color Other areas It is also preferable to highlight identifiably as .

<6> In the above embodiment, the data output processing unit 12, when calculating the index data (EMi, CMi, i = 1 to m) of the third visualization data, checks the presence or absence of monthly gas usage read from the second database. Based on this, an example of calculating the number of new contracts and the number of cancellations has been described. However, if the specified attribute data on gas users stored in the first database includes the start date and stop date of gas supply for gas users, the number of new contracts and the number of cancellations will be calculated in the target month , the number of new contracts and the number of cancellations may be calculated by determining whether or not the attribute data includes the gas supply start date and gas supply stop date.

Further, in the above embodiment, the data output processing unit 12, in calculating the second index data (ΔN/N0) of the fifth and sixth visualization data, determines whether there is monthly gas usage read from the second database. Based on this, an example of counting and calculating the number of contracts in a month related to the calculation of the number of contracts has been described. However, if the predetermined attribute data relating to gas users stored in the first database includes the start date and stop date of the gas supply of gas users, when calculating the number of contracts for a specific month, the The number of contracts for the month may be calculated by determining the magnitude relationship between the first day or the last day of the month and the gas supply start date and stop date.

INDUSTRIAL APPLICABILITY The present invention can be used in a system that is suitable for objectively evaluating the business conditions of restaurants by area.

1: Restaurant business condition visualization system 11: Data input processing unit 12: Data output processing unit 13: Data storage unit 14: First database 15: Second database 20: Data communication network (Internet)
21: User terminal

Claims (6)

Visualization data that visualizes the business conditions of restaurants in each area in which the visualization target area is divided into a plurality of areas so that they can be distinguished by area is created by computer data calculation processing, and the visualization data is transmitted via a predetermined data communication network. A restaurant business condition visualization system that transmits to the user terminal of the data user who uses
a first database storing predetermined attribute data including location data relating to a gas user whose business type is a restaurant within a predetermined gas supply area including the visualization target area; comprising a second database that stores the usage amount, a data storage unit, a data input processing unit, and a data output processing unit,
a first data type group in which the type of the visualization data uses first type statistical data relating to increases and decreases in the amount of gas used by the gas users in each of the areas as index data representing the business conditions of the restaurant; A second data type group using second type statistical data relating to increases and decreases in the number of contracts of gas users in each area, and both the first type statistical data and the second type statistical data belongs to at least one of the second data type group and the third data type group among the third data type group to be used,
The data input processing unit receives input data that individually designates input items including the visualization target area, the division granularity of the area, and the type of the visualization data transmitted from the user terminal, and the data storage unit configured to save to
The data output processing unit
The gas usage amount or attribute data within the visualization target period according to the type of the visualization data of each of the gas users existing in the same area, or Based on both of them, among the first type statistical data and the second type statistical data determined by the type of the visualized data , at least the second type statistical data is created as the index data,
creating the visualization data for displaying the index data created for each area in a predetermined display format according to the type of the visualization data;
A restaurant business condition visualization system, wherein the visualization data is transmitted to the user terminal via the predetermined data communication network.
When there are multiple types of the visualization data saved as the input data,
2. The restaurant business condition visualization system according to claim 1, wherein the data output processing unit creates the visualization data for each type of the visualization data. a type of the restaurant is stored in the first database as one of the predetermined attribute data relating to the gas user;
The data input processing unit receives input data that individually designates input items including the visualization target area, the division granularity of the area, the type of the visualization data, and the type of restaurant transmitted from the user terminal. configured to receive and store in the data storage unit;
The data output processing unit
In the input data, when a part of the types of restaurants is specified, the index data creation process is performed only for the gas users who belong to the specified types of restaurants. 3. The restaurant business condition visualization system according to claim 1 or 2, wherein: As the type of the visualization data belonging to the first data type group,
The boundary of each area of the visualization target area is displayed on a map, and the total amount of gas used by the gas user in each area over a predetermined number of months is displayed on the map. first visualization data in which the ratio or rate of increase/decrease of the total amount of gas used in a period is identifiably displayed as the index data by a difference in any one of color, shade, and pattern;
Second visualization data in which a year-on-year comparison or rate of increase/decrease in the same month of the previous year of the total amount of gas used by the gas users in each of the areas by month is graphically displayed in chronological order for each of the areas as the indicator data. 4. The restaurant business condition visualization system according to any one of claims 1 to 3, comprising at least one of As the type of the visualization data belonging to the second data type group,
The number of new contracts and the number of cancellations of gas users in each area of the visualization target area or in the specific area designated by the input data is used as the indicator data in a monthly time series for each area. Third visualization data that is graphically displayed in, and
displaying the boundaries of each of the areas of the visualization target area on a map; The store volatility index indicating the intensity of the replacement of restaurants calculated based on at least one of the fourth visualization data that is identifiably displayed by the difference in any one of color, shading, and pattern as the index data. The restaurant business condition visualization system according to any one of claims 1 to 4, characterized by comprising: As the type of the visualization data belonging to the third data type group,
The ratio or rate of increase or decrease of the total amount of gas used by the gas users in each area of the visualization target area over a period of a predetermined number of months to the total amount of gas used in the same period of a predetermined number of years before is the first index. As the data, the ratio or increase/decrease rate of the number of contracts of the gas users immediately after the predetermined number of months to the number of contracts of the gas users immediately before the same period of the predetermined number of years is used as the second index data. fifth visualization data displayed for each area in a scatter diagram with one of the first and second index data on the vertical axis and the other on the horizontal axis; and
Displaying the boundaries of the areas of the visualization target area on a map, and existing within the predetermined area within the boundaries of the areas existing within the predetermined area on the scatter diagram The restaurant business degree visualization system according to any one of claims 1 to 5, comprising at least one of the sixth visualization data that is identifiably displayed by a difference in either one of shading and pattern.

Images