JP2004152214A - Database management server - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To manage/integrate information for each and every entrepreneur, analyze sales information, additional sales information and affiliated store information according to business type/condition, and provide each entrepreneur with information for making business judgement. <P>SOLUTION: A database management server 100 having a plurality of independent entrepreneurs as clients, is provided with a database 101 to which at least the affiliated stores of the entrepreneurs are connected through a network, for receiving sales information, additional sales information or affiliated store information transmitted from the affiliated stores, and for storing/updating the information for each entrepreneur; and is provided with a management and integration part 102 for managing/integrating whole data for each entrepreneur stored in the database 101, analyzing the sales information, additional sales information and affiliate store information according to business type/condition, and providing each entrepreneur with information for making business judgement. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a database management server having a database for storing data transmitted from a store of a business.
[0002]
[Prior art]
2. Description of the Related Art Conventionally, for the purpose of integrated data management, an electronic data integrated data management system that is interoperable between different systems has been proposed. (For example, see Patent Document 1)
[0003]
[Patent Document 1]
JP-A-2002-92324
[Problems to be solved by the invention]
However, it has a plurality of independent businesses as clients, receives sales information, additional sales information, or member store information from the stores of the businesses, and stores those information in the database for each business. Manages and integrates all the stored data of each business operator, analyzes sales information, additional sales information, and member store information for each type of business and business type, and provides each business operator with information that contributes to management decision-making There was no system to do it.
[0005]
The present invention manages and integrates information for each business operator, analyzes sales information, additional sales information, and member store information for each business type and business type, and provides each business operator with information that contributes to management judgment. The main purpose is.
[0006]
[Means for Solving the Problems]
A first invention is a database management server having a plurality of independent businesses as clients,
At least the merchants of the business are connected via a network, receive sales information, additional sales information, or member store information from those merchants, and store and update the information for each business. Database and
Manages and integrates all data of each business stored in the above database, analyzes sales information, additional sales information, and member store information for each business type and business type, and provides each business with information that contributes to management decisions. It is characterized by comprising a management integration unit to provide.
[0007]
In addition, each of the above-mentioned business headquarters accesses the above-mentioned database, refers to the sales information, the sales additional information, and the member store information from the above-mentioned respective member stores, analyzes the respective information, and obtains a total sales amount. It is characterized by performing management and schedule management.
[0008]
A second invention is a database management server having a business as a client, a store of the business being connected via the Internet, and a database storing and updating data from the store,
The database management server prepares several types of program modules for analyzing and processing data from the store, and the user A who is a contractor of the server selects and downloads a desired program module from the above program modules. Is configured so that
The program module includes a report creation wizard that allows the user A to set conditions and types required for creating a report. The program module in which the conditions and types are set by the user A is managed in a database. When transmitted to the server, a report is created according to the contents selected in the report creation wizard.
[0009]
The contents set by the report creation wizard are registered in the database management server together with a storage number.
[0010]
Further, when registering the contents set by the report creation wizard in the database management server, a URL for displaying the report is generated.
[0011]
In addition, the user is charged based on the download of the program module.
[0012]
A third invention is a database management server having a business as a client, a store of the business being connected via a network, and a database storing and updating data from the store,
The database management server has a store-specific data definition that allows a user to select and register data items required for each store,
The data of each store in the database is accessed through the store-specific data definition, and the data from each store is converted according to the store-specific data definition and stored in the database.
[0013]
BEST MODE FOR CARRYING OUT THE INVENTION
Embodiment 1 FIG.
FIG. 1 is a block diagram showing a database management server system according to Embodiment 1 of the present invention.
[0014]
In the database management server system of FIG. 1, the database management server 100 includes a database 101 and a management integration unit 102 that manages the database 101.
[0015]
The database management server 100 is connected to a plurality of independent business headquarters serving as clients and their member stores via a network typified by the Internet. Here, in FIG. 1, as examples of the business, the franchise headquarters 10 and the franchise member stores A, B, C associated therewith, the shopping district secretariat 20 and the stores D, E, F associated therewith, and a multi-store type deployment type The headquarters 30 and the directly-managed stores G, H, and I connected thereto exist.
[0016]
The database 101 includes sales information, additional sales information, and schedule information from franchise member stores A, B, and C, stores D, E, and F, and directly managed stores G, H, and I, which are member stores of the business, via a network. Are transmitted as needed and stored / updated for each business operator. That is, from each member store (1) Who is it? Where? What did you buy? Sales information such as (2) last visit date, number of visits, average unit price, etc., and (3) schedule information of each member store are transmitted to the database 101 and stored and updated for each business operator.
[0017]
The franchise headquarters 10, the store secretariat 20, and the multi-store development headquarters 30, which are the business headquarters, can access the database 101 via the network, and can refer to the information transmitted and stored from each member store of the business. In other words, the franchise headquarters 10 stores the information of the franchise member stores A, B, and C stored in the database 101, and the shopping mall secretariat 20 stores the information of the stores D, E, and F stored in the database 101, and stores the multi-store information. The unfoldable headquarters 30 can refer to the information of the directly managed stores G, H, and I stored in the database 101.
[0018]
The franchise headquarters 10, the store secretariat 20, and the multi-store development headquarters 30, which are the business headquarters, access the database 101 as described above, and (1) who is from each member store? Where? What did you buy? Sales information such as (2) last visit date, number of visits, average unit price, etc., and (3) schedule information of each member store, and analyze each information to comprehensively manage sales.・ Schedule management can be performed.
[0019]
Further, the management integration unit 102 in the database management server 100 can manage all data of each business stored in the database 101, and can calculate the average value of sales information and sales additional information for each type of business and business, By calculating the analysis value, it is possible to provide each company with information that contributes to the management decision-making material.
[0020]
Embodiment 2 FIG.
FIG. 2 is a block diagram showing a database management server system according to Embodiment 2 of the present invention.
[0021]
In the database management server system of FIG. 2, similarly to FIG. 1, the database management server 100 includes a database 101 and a management integration unit 102 that manages the database 101.
[0022]
Further, the database management server 100 is connected to the business headquarters P as clients and the stores S1, S2, S3,... Which are member stores thereof through a network 200 typified by the Internet. In addition, as an example of a business operator, as shown in FIG. 1, the franchise headquarters 10 and the franchise member stores A, B, and C associated therewith, the shopping mall secretariat 20 and the stores D, E, and F associated therewith, and many stores The mold development headquarters 30 and the directly managed stores G, H, and I connected thereto may be connected. That is, in the present embodiment, there may be a plurality of operators as in Embodiment 1, or a single operator.
[0023]
In the database 101, sales information, sales additional information, schedule information, and the like are transmitted from the stores S1, S2, S3,... That is, from each store (1) Who is it? Where? What did you buy? Sales information such as (2) last visit date, number of visits, average unit price, and (3) schedule information of each member store are transmitted to the database 101 and stored / updated.
[0024]
The business headquarters P can access the database 101 via the network 200, and can refer to information transmitted and stored from each store.
[0025]
The users 50 and 60 who are contractors of the database management server 100 can also access the database 101 via the network 200.
[0026]
Next, download, registration, and reference operations of a program module according to the second embodiment will be described with reference to the flowchart of FIG.
[0027]
(1). The user 50 who is a contractor of the database management server 100 accesses the database 101 via the network 200 using an ID and a password provided in advance from the server. The database management server 100 prepares in advance several types of program modules for processing sales data and the like, such as analysis and tabulation, and the user 50 freely selects and downloads a program module of a function to be used from the program modules. can do. For example, a salesperson who is required to submit sales documents at the end of the month selects and downloads a program (for example, an analysis report creation module) for sales by product from a menu displayed on a Web browser.
[0028]
(2). When the download of the desired program module is completed, a report creation wizard is displayed on the browser, and the user 50 creates a report according to the instructions of the report creation wizard. In this wizard, select the necessary conditions for each report (for example, period of sales date and time, sales department, classification of product to be reported, etc.) and report type (graph, summary table, etc.), and finally press the create button Has become. The program module in which the conditions and types are set is accessed by the database management server 100, creates a report according to the contents selected by the wizard, and displays the report result on the personal computer of the user 50.
[0029]
(3). The user 50 can use the created report program anytime and anywhere in an environment where the Internet (network) can be used. That is, by registering the contents (hereinafter, referred to as a catalog) set by the wizard of (2) in the database management server 100 (hereinafter, referred to as catalog registration), even from another place or another personal computer as necessary. It can be used freely and does not have to be created with the wizard each time it is displayed. For example, a catalog of sales report for each product created as a report for sales report at the office is registered in the database management server 100, and a report sentence is created to return to home and view the created sales report for each product and submit to the boss. be able to. In this case, by simply specifying the storage number (hereinafter, referred to as a catalog number) specified for the catalog stored in the office, the generated report result is promptly displayed. Also, since the contents registered in the catalog are only the creation conditions / creation charts, they are totaled and displayed based on the latest data each time they are displayed. The catalog can be stored with a password protected in addition to the catalog number.
[0030]
(4) and (5). When the user 50 depresses a “URL generation button” during catalog generation, a URL for displaying a report is generated and displayed. When the URL is transmitted to the user 60 by e-mail or the like, the received user 60 can easily refer to the report by clicking the URL. For example, when the user 50 who is the person in charge of creating a report presses the URL generation button, a URL “http://www.asnal.com/xxx/report001” is generated and displayed on the screen. This is described and transmitted by copy and paste in the text of an e-mail addressed to the user 60 as the boss. The received user 60 clicks the URL, and the report created by the user 50 is directly displayed. Since the report result is created each time a request is made, the display content reflects the data generated after the user 50 transmitted the e-mail. It can be protected with a password according to the intention of the created user 50. If a password is set, a password request will be made immediately after opening the report page.
[0031]
Next, a charging operation for searching for and downloading a program module according to the second embodiment will be described with reference to the flowchart of FIG.
[0032]
(1) and (2). The database management server 100 has a program search wizard. When the user 50 searches for a program module having a function according to the purpose from several types of program modules, the user 50 can easily search for the program module using the program search wizard described above. For example, in this program search wizard, select from the classification of business type and business type (retail business, service business, etc.), and then select from the program form (input program, analysis program, tabulation program, tabulation program, etc.) The user 50 can narrow down and select a program having a desired function from the classified programs. The selected program module can be downloaded immediately, and every time the user downloads the program module, the date and time of use is recorded in the database management server 100. Then, the usage record of the program module is sent from the database management server 100 to the charging unit 300. This billing unit 300 may be inside the database management server 100 or outside.
[0033]
(3) and (4). The billing unit 300 counts and requests for each user based on the usage record sent from the database management server 100 on the accounting closing day. That is, in the present embodiment, the billing amount is determined based on the usage amount of the program module.
[0034]
Embodiment 3 FIG.
FIG. 5 is a block diagram showing a database management server system according to Embodiment 3 of the present invention.
[0035]
In the database management server system of FIG. 5, the database management server 100 includes a database 101, a management integration unit 102 that manages the database 101, and a store-specific data definition 103.
[0036]
Further, the database management server 100 is connected to the business headquarters P as clients and the stores S1, S2, S3,..., Sn as their member stores via a network 200 typified by the Internet. I have. In addition, as an example of a business operator, as shown in FIG. 1, the franchise headquarters 10 and the franchise member stores A, B, and C associated therewith, the shopping mall secretariat 20 and the stores D, E, and F associated therewith, and many stores The mold development headquarters 30 and the directly managed stores G, H, and I connected thereto may be connected. That is, in the present embodiment, there may be a plurality of operators as in Embodiment 1, or a single operator.
[0037]
The stores 101, sales information, additional information, schedule information, etc. are transmitted from the stores S1, S2, S3,... Is done. That is, from each store (1) Who is it? Where? What did you buy? Sales information such as (2) last visit date, number of visits, average unit price, etc., and (3) schedule information of each member store are transmitted to the database 101 via the store-specific data definition 103 and stored and stored. Be updated.
[0038]
The business headquarter P can access the database 101 via the network 200 and the store-specific data definition 103, and can refer to information transmitted and stored from each store.
[0039]
Next, an operation of creating a store-specific data definition according to the third embodiment will be described with reference to the flowchart of FIG.
[0040]
A user 70 (system designer) who is a contractor of the database management server 100 accesses the database 101 via the network 200 using an ID and a password provided from the server side. The database management server 100 prepares a tool for creating the store-specific data definition 103 in advance, and the user 70 selects data items necessary for each store from various data items according to the tool. The data item selected for each store is registered in the store-specific data definition 103 for each store. When the database 101 is used, the database 101 is accessed via the store-specific data definition 103, and only the data items selected for each store are reflected.
[0041]
FIG. 7 is a flowchart illustrating the use of store-specific data definition according to the third embodiment. As shown in the figure, data for each store in the database 101 is accessed through a store-specific data definition 103, and is provided after being converted into data according to store-specific rules. On the other hand, data from each store is also converted according to the store-specific data definition 103 and stored in the database 101.
[0042]
【The invention's effect】
According to the first aspect of the invention, at least member stores of a plurality of independent businesses are connected via a network, and sales information, sales additional information, or member store information is transmitted from the member stores. Manages and integrates a database that stores and updates such information for each company, and all data for each business operator stored in the above database, and analyzes sales information, additional sales information, and franchise information for each type of business and business. For example, the average value and the analysis value of sales information and additional sales information for each type of business and business type can be calculated, and each company is provided with information contributing to management decision-making information. be able to.
[0043]
According to the second invention, several types of program modules for analyzing and processing data from the store are prepared, and the user A who is a contractor of the server selects a desired program module from the program modules. The program module is provided with a report creation wizard that allows the user A to set the conditions and types required for creating a report, and the conditions and types are set by the user A. When a program module is sent to the database management server, a report is created according to the contents selected in the report creation wizard, so that data analysis, tabulation, and processing using the program module can be performed easily and quickly. .
[0044]
According to the third invention, the data for each store in the database is accessed through the store-specific data definition, and the data from each store is also converted according to the store-specific data definition and stored in the database. The data for each store can be used and stored through the data items, thereby optimizing the use of data and improving the efficiency.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a database management server system according to a first embodiment of the present invention.
FIG. 2 is a block diagram showing a database management server system according to a second embodiment of the present invention.
FIG. 3 is a flowchart showing download, registration, and reference operations of a program module according to a second embodiment of the present invention.
FIG. 4 is a flowchart showing an operation of searching for and downloading a program module according to Embodiment 2 of the present invention;
FIG. 5 is a block diagram showing a database management server system according to Embodiment 3 of the present invention.
FIG. 6 is a flowchart showing an operation of creating a store-specific data definition according to the third embodiment of the present invention.
FIG. 7 is a flowchart illustrating use of store-specific data definition according to Embodiment 3 of the present invention;
[Explanation of symbols]
100 database management server, 101 database, 102 management integration unit, 103 data definition by store, 200 network.

Claims (7)

A database management server having a plurality of independent businesses as clients,
At least the merchants of the business are connected via a network, receive sales information, additional sales information, or member store information from those merchants, and store and update the information for each business. Database and
Manages and integrates all data of each business stored in the above database, analyzes sales information, additional sales information, and member store information for each business type and business type, and provides each business with information that contributes to management decisions. A database management server comprising a management integration unit to provide. By accessing the database, each of the business headquarters refers to the sales information, the sales additional information, and the member store information from the respective member stores, analyzes the respective information, and performs comprehensive sales management / The database management server according to claim 1, wherein schedule management is performed. A database management server having a business as a client, a store of the business being connected via the Internet, and a database storing and updating data from the store,
The database management server prepares several types of program modules for analyzing and processing data from the store, and the user A who is a contractor of the server selects and downloads a desired program module from the above program modules. Is configured so that
The program module includes a report creation wizard that allows the user A to set conditions and types required for creating a report. The program module in which the conditions and types are set by the user A is managed in a database. A database management server that is configured to send reports to the server according to the selections made in the Report Creation Wizard. The database management server according to claim 3, wherein the content set by the report creation wizard is registered in the database management server together with a storage number. 5. The database management server according to claim 4, wherein a URL for displaying the report is generated when the content set by the report creation wizard is registered in the database management server. 4. The database management server according to claim 3, wherein the user is charged based on the download of the program module. A database management server having a business as a client, a store of the business being connected via a network, and a database storing and updating data from the store,
The database management server has a store-specific data definition that allows a user to select and register data items required for each store,
A database management server wherein data for each store in a database is accessed through a store-specific data definition, and data from each store is also converted according to the store-specific data definition and stored in the database.

Images