JP5141164B2 - Database system, server, information browsing restriction method by region, program, and recording medium - Google Patents

Description

  The present invention relates to a database system using a network, and more particularly to a method for restricting information browsing by region of database data.

  In recent years, when creating catalogs, with the spread of computers, product data to be put on catalogs has been used as a database. Collaborating with a database, catalog creation work is performed by desktop publishing (DTP) or the like, and the efficiency has been improved. For example, a database that stores product information, material information, etc., a server and a plurality of clients that manage database information and provide functions such as input / output, search, and browsing of product information and material information (product images) in the database There are information search support systems (for example, Patent Document 1) including terminals and the like, and systems that search and provide information from a database that stores and manages product information on the Web via a network.

JP 2001-324975 A

  However, in a conventional database system, a company having a sales base often has products tailored to each region. At that time, a region code or the like is often associated and managed for each product, and one region is associated with one product. For example, when two regions have the same product specifications, the above mechanism cannot be managed.

  The present invention has been made in view of such problems, and an object of the present invention is to provide a database system and the like that can restrict browsing of products in a plurality of regions at once.

In order to achieve the above-mentioned object, the first invention is a product connected to a client terminal via a network in a company having sales offices in a plurality of regions where products in different regions may have the same product specifications. A server for storing and managing related product information in a certain system, and operating and managing the database, wherein the database has at least a product name and a region ID assigned to the region information. And a product ID that uniquely associates the product information with each other and stored, and a product information table that allows the presence of the product information that gives different region IDs to the same product name , and local table storing area information imparting region ID, and a plurality of regional as one regional groups, regional group information There a database that stores a regional groups table that associates a plurality of the local ID to the regional group ID given, the user information table associating the pre-Symbol land area group ID to the user information that can connect to the database In response to a login request from the client terminal, a region group ID associated with the input user ID is acquired from the user information table, and a plurality of region IDs associated with the region group ID are obtained from the region group table. An acquisition unit that acquires the region information associated with the acquired plurality of region IDs that can be browsed, and a selection reception unit that receives the region information selected by the client terminal; was the product information that is associated with the region ID of the region, Searches the serial product information table, a server, characterized by comprising: a providing means, a to provide the product information of the region in which it has been selected as the search result to the client terminal.

Further, the selection receiving means transmits the map image generated based on the area information associated with the plurality of local ID area, desirable Rukoto to select the desired area.

The “product information” is composed of character information (such as specifications) of the product, material information (image information) of the product, and the like.
The “region group” sets a plurality of regions as one region group, and the “region group table” associates a plurality of region IDs with the region group ID. “Region” manages products (product specifications) according to each region, and associates a region code or the like for each product. The “region table” includes region information such as a region name to which a region ID is assigned.

  In the first invention, a plurality of regions can be associated with one product, and management is possible even when the plurality of regions have the same product specification. You can restrict viewing of products in multiple regions at once. Ease of browsing product information tailored to the region is improved.

The second invention stores and manages client terminals and product information related to products in a certain system in a company having sales offices in a plurality of regions where products in different regions may have the same product specifications. A database system having a database and connected to a server for operating and managing the database via a network, wherein the server includes at least a product name and a region ID assigned to the region information. And a product ID that uniquely associates the product information with each other and stored, and a product information table that allows the presence of the product information that gives different region IDs to the same product name , and local table storing area information imparting region ID, and a plurality of regional as one regional groups, regional group information Yes and regional group table that associates a plurality of the local ID to the regional group ID given, a database for storing the user information table associating the pre-Symbol land area group ID to the user information that can connect to the database In response to a login request from the client terminal, a region group ID associated with the input user ID is acquired from the user information table, and a plurality of region IDs associated with the region group ID are obtained from the region group table. An acquisition unit that acquires the region information associated with the acquired plurality of region IDs that can be browsed, and a selection reception unit that receives the region information selected by the client terminal; was the product information that is associated with the region ID of the region, before Searches the product information table, a database system, characterized by comprising: a providing means, a to provide the product information of the region in which it has been selected as the search result to the client terminal.
The second invention relates to a database system comprising the server of the first invention, a client terminal, and a database server having a database for storing and managing information and managing the database.

The third invention stores and manages client terminals and product information related to products in a certain system in a company having sales offices in a plurality of regions where products in different regions may have the same product specifications. An information browsing restriction method according to region in a database system having a database and a server that operates and manages the database connected via a network, wherein the database is assigned to a product name and region information The product information having at least a region ID and the product ID that uniquely associates the product information are stored in association with each other, and the product information that gives the same region ID to the same product name exists a product information table to allow a local table storing area information for applying the local ID, and a plurality of regions As One regional groups, users associated with regional groups table that associates a plurality of the local ID to the regional group ID given to the region group information, the pre-Symbol land area group ID to the user information that can connect to the database A database storing an information table, wherein a region group ID associated with an input user ID is acquired from the user information table in response to a login request from the client terminal executed by the server, and the region An acquisition step of acquiring a plurality of area IDs associated with a group ID from the area group table, and transmitting area information associated with the acquired plurality of area IDs that can be browsed to the client terminal, and selecting at the client terminal selection reception to receive the regional information And step, the product information associated with the area ID of the selected region, and retrieved from the product information table, and Hisage step of providing product information of the region in which it has been selected as the search result to the client terminal This is a method for restricting browsing of information by region.
The third invention is an invention related to the regional product information browsing restriction method executed by the database system of the second invention.

A fourth invention is a program for causing a computer to function as the server of the first invention.
A fifth invention is a computer-readable recording medium on which a program for causing a computer to function as the server of the first invention is recorded.

  The above-mentioned program may be held and distributed on a recording medium such as a CD-ROM, or the program can be transmitted and received via a communication line.

  The present invention can provide a database system or the like that can restrict browsing of products in a plurality of regions at once.

  Hereinafter, preferred embodiments of a database system and the like according to the present invention will be described in detail with reference to the accompanying drawings. In the following description and the accompanying drawings, the same reference numerals are given to components having substantially the same functional configuration, and redundant description is omitted.

  FIG. 1 is a diagram showing a schematic configuration of a database system 100 according to the present embodiment of the present invention.

  FIG. 1 shows an example of a database system 100. As shown in FIG. 1, the database system 100 is configured by connecting a server 101, a plurality of client terminals 103, and the like via a network 109. The database system 100 is a configuration diagram when implemented using WWW (World Wide Web) technology.

  The network 109 is a network such as the Internet, a local area network (LAN), or an in-house LAN, and may be wired or wireless.

  The server 101 is a server computer or the like, and includes a Web server 110, a regional product information browsing restriction unit 111, a database operation unit 112, a database management unit 113, a product information database 301, and the like.

The regional product information browsing restriction unit 111 obtains a regional group ID associated with the input user ID in response to a login request from the client terminal 103, and obtains a plurality of regional IDs associated with the regional group information. The region information corresponding to a plurality of region IDs acquired from the group table is transmitted to the client terminal 103, and the product information associated with the selected region is searched from the product information database 301, which is a search result. The product information of the selected region is provided to the client terminal 103.
The database operation unit 112 is called from the Web server 110 and performs a search of the product information database 301, a reference of information contents, a browsing, and the like. It also performs system operation and management such as user registration and various settings.

  The database management unit 113 performs corresponding processing for various requests such as search, reference, registration, and deletion to the product information database 301. The merchandise information database 301 stores merchandise information (text information) such as merchandise specifications, a material file composed of merchandise material information (image information), a management table that associates merchandise information and material information, and the like.

  The client terminal 103 is a personal computer, a portable terminal (Personal Digital Assistant), or the like. A web browser 120 is installed in the client terminal 103. The client terminal 103 accesses the Web server 101 via the Web browser 120 to use and maintain data such as product information.

  Next, the hardware configuration of the server 101 will be described. FIG. 2 is a hardware configuration diagram of the server 101.

  The Web server 101 is configured by connecting a control unit 201, a storage unit 202, a media input / output unit 203, a communication control unit 204, an input unit 205, a display unit 206, a printing unit 207, and the like via a system bus 209. .

  The control unit 201 includes a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), and the like.

The CPU calls a program stored in the storage unit 202, ROM, recording medium or the like to a work memory area on the RAM, executes it, controls the drive of each device connected via the system bus 209, and is performed by the server 101. Various processes described later (see FIGS. 6 to 8) are realized.
The ROM is a non-volatile memory and permanently holds a computer boot program, a program such as BIOS, data, and the like.
The RAM is a volatile memory, and temporarily stores a program, data, and the like loaded from the storage unit 202, ROM, recording medium, and the like, and includes a work area used by the control unit 201 for performing various processes.

The storage unit 202 is an HDD (hard disk drive), and stores a program executed by the control unit 201, data necessary for program execution, an OS (operating system), and the like. As for programs, a control program 391 corresponding to an OS (operating system), an application program 392 corresponding to processing described later performed by the Web server 101 to which the present computer is applied, and the like are stored.
Each of these program codes is read by the control unit 201 as necessary, transferred to the RAM, read by the CPU, and executed as various means.

  The media input / output unit 203 (drive device) performs data input / output, for example, floppy disk drive, PD drive, CD drive (-ROM, -R, -RW, etc.), DVD drive (-ROM, -R, etc.) -RW etc.) and media input / output devices such as MO drives.

  The communication control unit 204 includes a communication control device, a communication port, and the like, and is a communication interface that mediates communication between the server 101 and the network 109. Through the network 109, the server 101, the database server 102, and the client terminal The communication control between 103 is performed.

  The input unit 205 inputs data and includes, for example, a keyboard, a pointing device such as a mouse, and an input device such as a numeric keypad. An operation instruction, an operation instruction, data input, and the like can be performed on the server 101 via the input unit 205.

  The display unit 206 includes a display device such as a CRT monitor and a liquid crystal panel, and a logic circuit (such as a video adapter) for realizing a video function of the computer in cooperation with the display device.

  A printing unit 207 is a printer and performs print output processing.

  The system bus 209 is a path that mediates transmission / reception of control signals, data signals, and the like between the devices.

  Next, information stored in the storage unit 202 of the server 101 will be described with reference to FIG. FIG. 3 is a diagram illustrating information stored in the storage unit 202.

In the storage unit 202, a product information database 301, a control program 391, an application program 392, and the like are stored.
The control program 391 is a program that drives and controls each component of the server 101, and corresponds to an OS (operating system).
The application program 392 is an executable program corresponding to the later-described processing (see FIGS. 6 to 9) performed by the server 101, and includes the Web server 110, the regional product information browsing restriction unit 111, the database operation unit 112, and the database management unit. The program corresponds to 113 or the like.

FIG. 4 is a diagram illustrating an aspect of the product information database 301.
As shown in FIG. 4, a product information database 301 includes a product file (text information) such as product specifications and a material file made up of product material information (image information), a management table that associates product information and material information, and the like. Is stored. The product information database 301 includes a product information table 310, a user information table 320, a regional group table 330, a regional table 340, and the like. Note that a plurality of product information databases 301 may exist as necessary.

The product information table 310 stores the product ID (product ID) 11 that uniquely associates the product information 10 with the product information 10 (text information) having at least the product name 12 and the region ID 13 in association with each other.
The user information table 320 includes user attribute information connectable to the product information database 301 and includes at least a user ID 21, a user name 22, a regional group ID 23, a password 24, and the like. The regional group ID 23 is an ID of a regional group that can be browsed by the user, and a plurality of regions are associated with the regional group. Products (product specifications) are managed according to each region, and the region ID 13 is associated with each product.

The region group table 330 sets a plurality of regions as one region group, and associates a plurality of region IDs 13 with the region group ID 23.
The area table 340 includes area information such as the area name 41 to which the area ID 13 is assigned.

  The data configuration of the product information database 301 is not limited to this configuration.

  Next, the hardware configuration of the client terminal 103 will be described with reference to FIG. FIG. 5 is a hardware configuration diagram of the client terminal 103.

The client terminal 103 is connected to a control unit 401, a storage unit 402, a communication control unit 403, a media input / output unit 404, an input unit 405, a display unit 406, a printing unit 407, and the like via a system bus 409.
The hardware configuration of the client terminal 103 is the same as that of the server 101 described above with reference to FIG.

  Next, with reference to FIGS. 6 to 9, the processing operation of processing for performing browsing restriction on product information by region in the product information database 301 corresponding to the product information browsing restriction unit by region 111 will be described in detail.

6 and 7 are flowcharts showing the processing procedure of the browsing restriction process for the product information by region in the product information database 301.
FIG. 8 is a diagram illustrating an example of a screen transition and a process flow of a browsing restriction process for product information by region.
FIG. 9 is a diagram illustrating an example of a screen transition and a process flow of the browsing restriction process for product information by region.

In the storage unit 202 of the server 101, a Web server that is an application program 392, a database support program, and a database management program are installed. The following processing of the server 101 is performed by the control unit 201 of the server 101 according to the control of these programs.
In addition, a Web browser 120 that is an application program is installed in the storage unit 402 of the client terminal 103, and the following processing of the client terminal 103 (access to the server 101 via the Web browser 120, instructions to the server 101) Etc.) is performed by the control unit 401 of the client 103.

  The control unit 401 of the client terminal 103 accesses the server 110 and makes a login request to the product information database 301 (step S601). For example, the server 101 is accessed from the Web browser 120 of the client terminal 103 by specifying a predetermined URL of the server 101.

The control unit 201 of the server 101 transmits login screen data to the client terminal 103 via the Web server 110 (step S602). The control unit 401 of the client terminal 103 displays the login screen 50 (step S603), and transmits the input user ID 51 and password 52 to the server 101 (step S604).
As shown in FIG. 8, the login screen 50 includes an input field for a user ID 51 and a password 52, and a login button 53. For example, the user ID “kevin” and a password are input, and the login button 53 is clicked.

The control unit 201 of the server 101 performs user authentication based on the received login information such as the user ID 51 and the password 52 (step S605).
If the user is correctly authenticated, the product information database 301 having the database name 56 selected on the displayed database selection screen 55 is set and connected (step S606).

  The control unit 201 of the server 101 acquires the regional group ID 23 associated with the user ID of the logged-in user from the user information table 320 of the product information database 301 (step S607). For example, the area group ID “10101” of the logged-in user ID “Kevin” is acquired from the user information table 320 of FIG. 8 (step S81).

  The control unit 201 acquires one or more area IDs 13 associated with the acquired area group ID 23 from the area group table 330 (step S608). For example, a plurality of area IDs “101” and “103” associated with the area group ID “10101” are acquired from the area group table 330 in FIG. 8 (step S82).

The control unit 201 acquires area information such as all area names 41 associated with the acquired one or more area IDs 13 from the area table 340 (step S609). For example, the area information (area names “A”, “C”, etc.) of the plurality of area IDs “101” and “103” is acquired from the area table 340 of FIG. 8 (step S83).
The control unit 201 generates and transmits area selection screen data composed of area information that can be browsed based on area information handled by the user (step S610). For example, area map data is acquired from a map information database (not shown) using the area information (area names “A”, “C”, etc.) of a plurality of area IDs “101” and “103” as keys. The area selection screen data including the area map of the corresponding area names “A” and “C” is generated.

The control unit 401 of the client terminal 103 displays the received area selection screen 60 (step S611).
As shown in FIG. 8, the region selection screen 60 includes a region map 62 indicating one or more regions 61 that can be browsed, and selects a region 61 to browse from the region 61 that can be browsed (step S612). For example, an area “A” on the area map 62 is clicked and selected.

  The control unit 201 of the server 101 searches and extracts the corresponding product information 10 from the product information table 310 of the product information database 301 based on the region ID 13 of the selected region (step S613). For example, the corresponding product information 10 is searched from the product information table 310 of FIG. 9 based on the region ID “101” of the selected region “A”, and the product information record “product name: PC-01, power consumption” is searched. : 12A,..., “Product name: PC-02, Power consumption: 12A,. Further, product image information that is related material information is extracted from the corresponding product ID (product ID) (step S84).

  The control unit 201 transmits the regional product information list data including the search results to the client terminal 103 (step S614). Region-specific product information generated from the record “product name: PC-01, power consumption: 12A,...”, “Product name: PC-02, power consumption: 12A,. The list data is transmitted (step S85).

The control unit 401 of the client terminal 103 displays the received regional product information list screen 70 (step 615).
As shown in FIG. 9, the region-specific product information list screen 70 displays a region-specific product information list 71 for the selected region. The regional product information list 71 includes a product display unit 72 related to products associated with a region. Each product display unit 72 includes product image information 73 and product text information 74 of the product.

  As described above, according to the embodiment of the present invention, the server 101 includes the product information database 301 including the product information table 310, the user information table 320, the regional group table 330, the regional table 340, and the like, and the client terminal Accompanying the log-in request from 103, the regional group ID 23 associated with the input user ID 21 is obtained from the user information table 320, and a plurality of regional IDs 13 associated with the regional group information 23 are obtained from the regional group table 330. , Region information corresponding to a plurality of viewable region IDs is transmitted to the client terminal 103, product information associated with the selected region is searched from the product information database 301, and the selected region as a search result is selected. The product information is sent to the client terminal 103. To provide.

  As a result, a plurality of regions can be associated with one product, and management is possible even when the plurality of regions have the same product specification. It is possible to restrict browsing of products in a plurality of regions at once, and the operability of browsing product information according to the region is improved.

  In the present embodiment, the server 101 includes a Web server 110, a Web application having a function corresponding to the regional product information browsing restriction unit 111, and a database operation unit 112, a database management unit 113, and a product information database 301. 101 and the client terminal 103 are connected via a network, the server 101 is accessed from the client terminal 103, and the database support program of the Web application is started. However, the present invention is not limited to this. For example, two servers each include a Web server 110 having a Web application having a function corresponding to the regional product information browsing restriction unit 111 and the database operation unit 112, a database management unit 113, and a database server including the product information database 301. May function.

Further, in the present embodiment, the area selection is performed using the area selection screen 70 including the area map from the area information such as all area names 41 associated with the acquired one or more area IDs 13. Not limited to. For example, an area selection screen including a list of a plurality of area names 41 may be used.
In the present embodiment, the product information database 301 that stores product information and the like is used as the database. However, the present invention is not limited to product information and the like.
In this embodiment, the WWW technique is used. However, the client terminal 103 can be realized without using the WWW technique by providing a dedicated user program.

  Note that the program for performing the processing shown in FIGS. 6 to 9 and the like may be distributed by being held on a recording medium such as a CD-ROM, or may be transmitted and received via a communication line.

  The preferred embodiments of the database system and the like according to the present invention have been described above with reference to the accompanying drawings, but the present invention is not limited to such examples. It will be apparent to those skilled in the art that various changes or modifications can be conceived within the scope of the technical idea disclosed in the present application, and these naturally belong to the technical scope of the present invention. Understood.

The figure which shows schematic structure of the database system 100 which concerns on this Embodiment. Hardware configuration diagram of server 101 The figure which shows the information which the memory | storage part 202 hold | maintains The figure which shows the one aspect | mode of the merchandise information database 301 Hardware configuration diagram of the client terminal 103 The flowchart which shows the process sequence of the browsing restriction process with respect to the merchandise information according to area of the merchandise information database 301. The flowchart which shows the process sequence of the browsing restriction process with respect to the merchandise information according to area of the merchandise information database 301. The figure which shows an example of the screen transition of the browsing restriction process with respect to merchandise information according to area, and the flow of a process The figure which shows an example of the screen transition of the browsing restriction process with respect to merchandise information according to area, and the flow of a process

Explanation of symbols

100 ......... Database system 101 ......... Server 103 ......... Client terminal 109 ......... Network 110 ......... Web server 111 ......... District product information browsing restriction means 112 ......... Database operation means 113 ......... Database management means 120... Web browser 201, 401 ... Control unit 202, 402 ... Storage unit 301 ... Product information database 310 ... Product information table 320 ... User information table 330 ... Regional group table 340 ... Regional table 10 ... Product information 11 Product ID
12 ……… Product name 13 ……… Region ID
21 ……… User ID
22 ……… User name 23 ……… Regional group ID
24 ……… Password 41 ……… Regional name

Claims (7)

There are cases where products in different regions may have the same product specifications A database that stores and manages product information related to products in a certain system connected to client terminals via a network in a company that has sales offices in multiple regions A server for operating and managing the database,
The database stores the product information having at least the region ID assigned to the product name and the region information in association with the product ID that uniquely associates the product information, and for the same product name. The product information table that allows the presence of the product information that assigns different region IDs, the region table that stores the region information that assigns the region ID, and a plurality of regions as one region group are assigned to the region group information. A database storing a regional group table in which a plurality of regional IDs are associated with a regional group ID, and a user information table in which the regional group ID is associated with user information connectable to the database,
Acquires, from the user information table, a region group ID associated with the input user ID, and acquires a plurality of region IDs associated with the region group ID from the region group table in response to a login request from the client terminal. Acquisition means to
Selection receiving means for transmitting area information associated with the acquired plurality of area IDs that can be browsed to the client terminal, and receiving the area information selected in the client terminal;
Providing means for searching the product information associated with the region ID of the selected region from the product information table and providing the client terminal with the product information of the selected region as a search result;
A server comprising:   The selection receiving unit transmits a map image of a region generated based on region information associated with a plurality of region IDs, and receives the region information selected by the client terminal. 1. The server according to 1.   3. The server according to claim 1, wherein the area information is an area name. In a company having sales offices in a plurality of regions where products in different regions may have the same product specifications, a client terminal and a database for storing and managing product information related to the products in a certain system are provided. A database system in which a server to be operated and managed is connected via a network,
The server
The product information having at least the region ID assigned to the product name and the region information is stored in association with the product ID that uniquely associates the product information, and are different for the same product name. A product information table allowing the presence of the product information to which an ID is assigned, a region table storing region information to which the region ID is assigned, and a region group assigned to the region group information with a plurality of regions as one region group A database that stores a region group table in which a plurality of region IDs are associated with an ID, and a user information table in which the region group ID is associated with user information connectable to the database;
Acquires, from the user information table, a region group ID associated with the input user ID, and acquires a plurality of region IDs associated with the region group ID from the region group table in response to a login request from the client terminal. Acquisition means to
Selection receiving means for transmitting area information associated with the acquired plurality of area IDs that can be browsed to the client terminal, and receiving the area information selected in the client terminal;
Providing means for searching the product information associated with the region ID of the selected region from the product information table and providing the client terminal with the product information of the selected region as a search result;
A database system comprising: In a company having sales offices in a plurality of regions where products in different regions may have the same product specifications, a client terminal and a database for storing and managing product information related to the products in a certain system are provided. A method for restricting information browsing by region in a database system in which a server to be operated and managed is connected via a network,
The database stores the product information having at least the region ID assigned to the product name and the region information in association with the product ID that uniquely associates the product information, and for the same product name. The product information table that allows the presence of the product information that assigns different region IDs, the region table that stores the region information that assigns the region ID, and a plurality of regions as one region group are assigned to the region group information. A database storing a regional group table in which a plurality of regional IDs are associated with a regional group ID, and a user information table in which the regional group ID is associated with user information connectable to the database,
The server executes,
Acquires, from the user information table, a region group ID associated with the input user ID, and acquires a plurality of region IDs associated with the region group ID from the region group table in response to a login request from the client terminal. An acquisition step to
A selection receiving step of transmitting area information associated with the acquired plurality of area IDs that can be browsed to the client terminal and receiving the area information selected in the client terminal;
A step of searching the product information associated with the region ID of the selected region from the product information table and providing the product information of the selected region as a search result to the client terminal;
A method for restricting information browsing by region, characterized by comprising:   The program which makes a computer function as a server in any one of Claims 1 thru | or 3. A computer-readable recording medium on which a program for causing a computer to function as the server according to any one of claims 1 to 3 is recorded.

Images