KR100618164B1 - Database interlinking system for providing community in cyber space - Google Patents

Abstract

The present invention provides a DNS zone for outputting domain related information corresponding to a call signal for a specific domain input from one domain zone, a DBMS zone for connecting to a corresponding database according to domain information and control signals of a DNS unit, and between domains. It consists of a DB unit that stores various data of each domain area, including a relational DB for setting the relationship of one, and under certain requirements, one domain area transfers data to its own domain area as well as other domain areas, or Provides an information exchange community between groups of groupware concepts that can be downloaded. In addition, by providing a system in which a specific group can utilize e-CRM according to the partnership set in the relational DB, it is possible not only to exchange information among its own members of a specific group, but also to use information of other groups under certain requirements. It is possible to form a place of information exchange with families, relatives, neighbors, villages, etc., including not only within a specific group but also with other groups, and through this, businesses can smoothly provide commercial information to related villages and families. As a member, companies can effectively conduct customer marketing.

Community, E-CRM, DNS, DBMS

Description

Database interlinking system for providing community in cyber space

1 is a block diagram of an information exchange community system between groups according to the present invention;

Figure 2 is a block diagram showing the configuration of the DBMS of Figure 1, and

3 and 4 is a block diagram showing an embodiment of a community providing system according to the present invention.

The present invention relates to a database interworking system for providing a community in a virtual space, and more particularly, to manage a group of data in a single database and to use members of a specific group and data of another group under specific conditions. It relates to an inter-group community providing system in the form of a groupware configured to allow.

With the development of telecommunications and networks, the utilization rate is rapidly increasing so that the Internet is indispensable in business and life.

The convenience of living has been improved, but the opportunities for meetings and conversations between people are decreasing. To complement this, services such as providing a virtual conversation space through chat on the Internet or exchanging information through a homepage are provided.

However, these services provide one-to-one or one-way information, and do not provide a shared space between group members such as family members, relatives, neighbors, and villages offline. In order to solve this problem, the prior art discloses an information exchange system configured such that only members of a specific group such as family members or relatives can share information. For example, a technology for providing a family community system in a virtual space that can exchange genealogical information, large and small information, various life information, etc. among family members within an independent group called a family is disclosed.

However, in the conventional virtual space community system, only members belonging to a specific group share information in the group. In other words, it is possible to set up a relative community space through the linkage between one family and another family, to set up a neighboring community space as an extension of a relative community space, and to establish a village or a municipality space as an expansion of a neighboring community space. It does not adequately support information exchange patterns.

The present invention is to solve this problem, to build a community system for information exchange so that not only the information exchange between its own members of a specific group, but also the information of other groups under certain requirements, so that family, relatives, neighbors, It aims to exchange necessary information among various groups such as villages, and to include corporate groups as a unit to effectively carry out customer marketing of specific companies.

In order to achieve this object, the present invention is connected to the own domain site of the external company, main server for controlling the main domain area including a virtual domain area (mapping) mapped with the company's own domain site; A domain name server (DNS) for outputting domain-related information called in response to a call signal for a specific domain inputted from an own domain area of the enterprise; A database unit for storing various data of each domain area, including a relationship DB for establishing a relationship between the domains; And a database management system (DBMS) area for connecting to a corresponding database according to domain information and control signals of the domain name server and controlling data interworking of the database according to an alliance relationship set in the relational database. Provide a community-provided system of spaces.

That is, according to the present invention, a domain name server (hereinafter referred to as DNS) area for outputting domain related information corresponding to a call signal for a specific domain inputted from one domain area, domain information of a DNS area and a control signal It consists of a database management system (hereafter referred to as DBMS) that connects to the corresponding database, and a database section (hereinafter referred to as DB section) that stores various data in each domain area, including a relational DB that establishes relationships between domains. However, under certain requirements, one domain area provides a group-to-group information exchange community that can transfer data to or download data from its domain area as well as other domain areas. In addition, it is to provide a system that a specific group can utilize e-CRM according to the partnership set in the relational DB.

Hereinafter, the present invention will be described in detail with reference to the accompanying drawings.

1 is a block diagram of an information exchange community system between groups according to the present invention. As shown in FIG. 1, the information exchange community system between groups includes a web server 100, 200, a DNS 300, a main server 400, a virtual domain area 500, and a DBMS area operated by a specific group. 600), the DB unit 700 and the like.

Group web servers 100 and 200 are servers that manage real domains of companies registered as members. For example, Samsung web server is a server managing www.samsung.com or www.samsung.co.kr, and LG web server is a server managing www.lg.com or www.lg.co.kr. do. Here, in addition to large companies such as Samsung and LG, the group includes organizations of various sizes such as SMEs, government agencies, local governments and universities.

The DNS 300 connects to the main server 400 in response to the connection request of the plurality of group web servers 100 or 200. For example, if a member belonging to a specific group enters the virtual domain of the group belonging to the group under the main server 400 on the homepage of the group web server to which the member belongs, in the address bar, the DNS 300 requests an access request of a member of the specific group. Connect to the main server (400).

The main server 400 is a server of an independent main domain such as www.e-hom.net, and has a plurality of database systems including a virtual domain area 500 for a plurality of companies underneath, and each of these databases is integrated. Can be operated. Even when a large number of separate database systems are operated by each company, the movement of data between the separate database systems must be guaranteed under certain conditions.

In the virtual domain area 500, a plurality of corporate domains registered as members are virtually set up to form independent areas, and each has a database management system DBMS and a database DB. For example, a virtual domain exists with domain names such as samsung.e-hom.net, lg.e-hom.net, hyundai.e-hom.net, and the virtual domain is www.e-hom.net. Since it exists in one independent domain area, you can use the domain such as www.samsung.com that each company actually uses.

DBMS area 600 is to control the storage, change, transfer, etc. of the relevant data of the virtual domain existing under the main server (400). In FIG. 1, a plurality of DBMSs are connected to one virtual domain, but may be integrated into one DBMS. When composed of multiple DBMSs, each DBMS should be connected to each other so that data of each DB connected to the lower level can be interchanged.

Meanwhile, although FIG. 1 shows that the DBMS area 600 exists under the main server 400 and each virtual domain 500, the DBMS area 600 is actually a member within the space of the main server 400. It controls the setting of virtual domains, storage of data, modification of data, movement of data, etc. according to their registration. Thus, the main server 400 and the virtual domain 500 are controlled by the DBMS 600.

An example of the mapping process of the virtual domain by the DBMS 600 will be described below with reference to FIG. 3. With the main domain that manages the entire system, each company's independent domain generates a key of www.e-hom.net and maps it with the company's domain. In a community system in a virtual space, if a company wants to use the domain actually used as its virtual domain, that is, if the Samsung group uses www.samsung.com as a virtual domain under the main server www.e-hom.net, www DB association is created in the form of .samsung.com = samsung.e-hom.net, this information is mapped to www.samsung.com = 218.123.11.21 on DNS server, and 218.123.11.21 is samsung.e in DB -mapped to link to hom.net Therefore, when the customer requests "htto: //www.samsung.net" as shown in FIG. 3, the DNS server recognizes the IP address as ": //211.32.119.135" and 119.32 in the reverse lookup area of DNS. .211.in-addr.arpa Traces back the IP address and converts it to the domain name "http://www.samsung.net" in the domain finder area of DNS. DBMS calls "http: samsung.e-hom.net" mapped to "http://www.samsung.net" from the DB section, and "http://samsung.e-hom.net" is called. When the web server is running "http://218.123.11.21/default.htm"

Depending on the domain driving scheme of each company, the domains of each company may or may not be linked to each other according to a sharing concept. It is linked by determining whether to connect based on the relationship between objects in the actual DB. The interworking is connected by the related software of the DBMS area 600 and the metadata and relational data of the DB unit 700. If the DB is managed on a relational basis, part or all of each DB unit managed under each virtual domain may be opened to the other party, thereby forming an extended information exchange field.

On the other hand, by establishing a DBMS and DB to allow sharing of specific information only among employees of each company within the DB department under a specific virtual domain, it is possible to form a limited information exchange area for specific employees.

In the above, the formation of an independent information exchange with a company unit has been described. However, within a single enterprise, an independent information exchange can be formed according to various topics such as a specific region, school, interests, and place of residence. In an integrated area including the virtual domain area of the domain or other virtual domain areas, information exchange may be formed in various forms such as a family, a relative, a neighbor, a village, and the like.

DB unit 700 may be built in each DB department individual DB, department DB, group DB, affiliate DB, my home DB, relative DB, relationship DB, external public DB, authority setting DB, neighbor DB, village It can be built in various areas such as DB. These DBs are related hierarchically or in parallel as sub-DBs within one particular company's DB. In addition, one specific company DB is controlled to allow mutual data exchange in connection with another specific company DB or independent DB such as an individual or an organization, and is an independent area in which data interchange is limited within one specific company DB. It can be constructed to be formed.

For example, in a personal DB, personal information of a member, input contents, usage history, etc. are stored. Authority setup DB stores authority and duty of each member. My home DB stores the usage contents and history of the programs used jointly among the family members who make up my home, and the usage contents and history of the programs decided to be shared only by our members in each individual DB. The external public DB stores the usage contents and history of the program which are supposed to be shared to all the users who access through the DNS server or to the limited specific users. And, when the relation DB is related to unspecified external territory such as family, relative, village, department, etc., the authority and duty related to the relation establishment are stored, and the access history and related to the stored contents shared according to the relation are stored. The contents of the program are stored.

2 is a configuration diagram of a DBMS. As shown in FIG. 2, each DBMS in the DBMS area includes a first interface unit 610, a system manager 620, a service manager 630, a second interface unit 640, a data manager 650, and the like. do.

The first interface unit 610 connects between the DNS zone 300 and the DBMS zone 600, and functions to smoothly transfer signals therebetween.

The system manager 620 manages overall hardware and programs used by members.

The service manager 630 manages a virtual domain, an ID, a password, and the like.

The second interface unit 640 connects the DBMS area 600 and the DB unit 700 to facilitate signal transmission therebetween.

The above has described the information exchange community system for each company that has built a plurality of virtual domain areas under the main server, but it is possible to build a community system that does not build the virtual domain areas for each company under the main server.

In each case, the following is an example of how e-CRM can be operated. First, in a company-specific information exchange community system that establishes a plurality of virtual domain areas under a main server, information on affiliated villages, affiliated families, etc. set by a relational DB, which is a component of the DB unit 700, for example, an advertisement. By providing information, you can build e-CRM. Second, if a company-specific virtual domain area is not established under the main server, the individual affiliates are searched on the server of the actual corporate domain existing outside the main server by searching for the address information of the affiliated villages and affiliated families of the relational DB included in the DB section. By providing advertisement information and the like directly to villages and affiliated families, an e-CRM can be constructed.

4 is a block diagram showing an embodiment of using the e-CRM with reference to the drawings illustrating an embodiment using the e-CRM by the community providing system according to the present invention. The company's own domain is connected to the main server that provides community services through the Http protocol, and recognizes the domain address in the DNS area of the main server and maps the company's own domain to a virtual domain controlled by the main server. It is linked from the domain to the corporate virtual domain. The corporate virtual domain is linked to the affiliated village site. In other words, the registered domain is recognized through the domain information of the DNS server, finds the DBMS using the information, shares basic relational data of the registered website, and forms a community. Therefore, registered company domains can exchange services with each other in the integrated DBMS in the main server, and process their services through the HTTP protocol by configuring and managing their own independent DBMS, thus providing independence and extensibility. Independence can be given.

As shown, the company's own domain site is connected to the main server using the http protocol and mapped to the company's virtual domain, ie, the affiliated town corporate domain address. Therefore, among the contents uploaded to the server of the company's own domain site, the corresponding contents are stored in the affiliated village DBMS, which is a data store of the affiliated village, by URL data transmission through the HTTP protocol. The content is included in the I-frame form at the CP location of the main page of the affiliated village. When the affiliated village manager system transmits the data to the client site of the affiliated family, the content data is stored in the client DBMS, and the stored data is displayed on the client site.

In addition, when the analysis data for each individual is transmitted to the affiliated village manager system through the client site and saved, the results of the analyzed data are displayed on the main page of the affiliated village. This data is then transmitted and displayed on the corporate homepage server by the URL data transmission method through the HTTP protocol.

The affiliated village site and the client site include both independent control functions and integrated control functions. If the affiliated site wants to be released from the client site to the affiliated town, the data is displayed in a specific corner of the affiliated town, and the affiliated town is also known to each individual client. Is published and controlled by the administrator system so that the data can be displayed on the main page of each individual client site. These features can be diversified to give builders a step-by-step flexibility to give them more flexibility from the user's point of view and control over various user interfaces.

As described above, not only data presentation from the corporate site to the client site but also data presentation in the reverse direction is possible. In other words, materials that want to be released from the client site to the affiliated village site are expressed in a specific corner of the affiliated village, and the data from the affiliated village site to the corporate site can also be expressed. Therefore, when the publicity data is disclosed and controlled by the affiliated village site manager system, the data is displayed on the main screen of each individual client site. These functions can be made by diversifying the structure to give builder functions step by step to give more flexibility from the user's point of view and control through various user interfaces.

Since the main server 400 operates domains for each company through its own DNS server, the domain interworking between the main server and the company is mapped to each other in a relational DB of a master domain: company N = 1: N relationship. In addition, when expanding from an individual to a family, a neighbor, a relative, or a town or city, the flexibility of granting a domain is basically provided, so that the database is configured in an efficient form, thereby making the basic home database a specialized CRM.

In addition, it is possible to configure different domain addresses of different companies independently to perform their own community functions, and to integrate and manage different personal blog functions.

On the other hand, the client site and the affiliated town site that make up the community have independent control and integrated control. In other words, the homepage of each company is linked with the affiliated village site, and the affiliated village site is linked with the affiliated clients between the affiliated villages and the information is automatically uploaded to the affiliated village site if the company has its own products or contents to be announced. Information posted in affiliated villages can be shared through client sites.

According to the above-mentioned information exchange community system for each company, not only information exchange among members of a specific group, but also information of another group can be utilized under certain requirements, so that not only a specific group but also a family, relative, or neighbor including another group It is possible to form a place of information exchange in various ways such as villages and villages, and through this, companies can smoothly provide commercial information to related villages and families, so that companies joined as members can effectively perform customer marketing.

Claims (4)

In a database interworking system for providing a community in a virtual space, A main server connected to an external company's own domain site and controlling a main domain area including a plurality of virtual domain areas mapped with the company's own domain site; A domain name server (DNS) for outputting domain-related information called in response to a call signal for a specific domain inputted from an own domain area of the enterprise; A DB unit for storing various data of each domain area, including a relationship DB for establishing a relationship between the domains; And A database management system (DBMS) area for connecting to the corresponding database according to domain information and control signals of the domain name server and controlling data of the database to be interlocked according to the partnership set in the relational DB; Each DBMS of the database management system (DBMS) area, A first interface unit connecting the DNS zone and the DBMS zone; System management unit for managing the overall hardware and programs used by the member; A service manager to manage a virtual domain, an ID, a password, and the like; And And a second interface unit for connecting the DBMS region and the DB unit. The method of claim 1, And the DB unit integrally operates a plurality of databases including the virtual domain regions mapped to the respective corporate domains. The method of claim 1, And the DB unit separates and operates a database system for each company, and the separated database system is configured to interlock data according to an affiliate relationship set in the relationship DB. The method of claim 1, And a plurality of virtual domain areas are set according to a plurality of corporate domains registered in the main domain area to build independent areas, and each includes a database management system and a database underneath.

Images