KR20010045614A - Method for Associating Two Databases in Internet Service - Google Patents

Abstract

PURPOSE: A two internet service site member combination method is provided to accept the member information of the other party if there is no overlapped ID, and otherwise, add a specific ID to the conventional ID when the member informations of the two party are combined. CONSTITUTION: The method comprises steps of extracting overlapped IDs by comparing the IDs of the first database with the IDs of the second database, making the first database add the IDs of the second database with respect to no overlapped ID, making the second database add the IDs of the first database with respect to no overlapped ID, making the first internet service company add a specific ID part to the IDs of members of the second internet service company with respect to the overlapped IDs and combine the second internet company member data including the added IDs with the conventional member data, and making the second internet service company add a specific ID part to the IDs of members of the first internet service company with respect to the overlapped IDs and combine the first internet company member data including the added IDs with the conventional member data.

Description

How to federate members of two different Internet services {Method for Associating Two Databases in Internet Service}

The present invention relates to a method for integrating different groups of Internet members.

Recently, the number of providers that provide various services using the Internet is increasing. These Internet service providers have their own characteristics such as chat, special information, community activities, e-commerce activities, shopping malls, auctions, reverse auctions, cyber securities business, and e-mail account granting. These operators often operate a membership system to register customers as members. Therefore, the internet service provider should select a unique ID and password when the member joins so that the member can use it when logging in to the Internet site. It is common to build databases and manage members on a unit basis.

Since Internet service businesses can attract advertisements when they have a large number of members, and their information itself is considered to have property value, securing and increasing the number of members determines the success of these businesses. It is recognized. Therefore, in addition to making efforts to increase the number of members themselves, Internet service providers may associate or integrate with different Internet service providers depending on the direction or nature of the business. In the case of integrating two or more operators into one provider, this method requires a process of integrating different management systems into the same database, and when it is completed, it becomes one provider. This is necessary.

On the other hand, there are cases where alliances allow different operators to share their members with other service providers while maintaining their service businesses. Since the alliance between the service providers greatly increases the number of members while providing services having mutual advantages, they are preferred as a way to greatly increase the number of members among the service providers. In addition, the members can also use other Internet services without a separate subscription process, so the association between service providers is in a widespread situation without great objection.

However, in the alliance between the Internet service providers, IDs that overlap with each other and with different ID systems are emerging as a major obstacle. In other words, the ID of one service provider member may be duplicated if the ID of another service provider is combined.

Since the member's ID usually selects what the subscriber wants for himself, it is easy to use names, aliases, or buzzwords that are commonly preferred by the general public. In the case of the same operator, there is no duplicate ID by rejecting the same ID at the time of membership registration.However, in the case of combining the IDs of different service providers, not only the duplicate ID is found, but also the total number of duplicate IDs It can range from a few percent to tens of percent. Such a large number of duplicate IDs is a major obstacle to the association of services, and as a subscriber, causes a great confusion in the use of both services.

Accordingly, it is an object of the present invention to provide a method for distinguishing duplication of member IDs generated when federating member databases of different Internet service providers by introducing an identification unit.

It is another object of the present invention to provide a method of distinguishing between two different IDs generated when assigning an e-mail account in the process of associating member databases of different Internet service providers. To provide.

According to the present invention, there is provided a first database in which member information including IDs and passwords of a plurality of members subscribed to a service service provided by a first Internet service provider, and a service service provided by a second Internet service provider are provided. A method of associating a second database in which member information including member IDs and passwords of a plurality of subscribed members has been constructed, the same overlapping with each other by comparing the ID of the first database and the ID of the second database. Extracting an ID; Adding, to the first database, the member information including the ID of the second database, with respect to IDs which do not overlap with each other as a result of the comparison; Adding, to the second database, the member information including the ID of the first database, with respect to IDs not overlapping with each other in the comparison result; The first Internet service provider adds the extracted duplicate ID among the members of the second Internet service provider to the first database as member information including an ID of a combined form by adding a distinguishable identification unit to the ID. Wow; The second internet service provider adds the extracted duplicate ID among the members of the first internet service provider to the second database as member information including a combined ID by adding a distinguishable identification unit to the ID. It is provided a method comprising;

Hereinafter, the present invention will be described in detail according to an embodiment of the present invention.

Internet service operated by membership system collects member information into database in order to effectively manage its members. Membership information includes the member's ID, login in password, name, age, phone number, address, electronic mail address, occupation, income, hobbies and interests, as required. Includes information such as fields. This information varies from service provider to service provider, but must include an ID and password, and in fact considers the ID as a member object.

Therefore, when two different first Internet service providers and a second Internet service provider allied together and share a member database to share their members, the IDs of the two databases having a plurality of member informations are identified. Compare with each other as a standard.

As a result of the comparison, for the different IDs, the member information including the other party's ID is introduced into the own database and added. Here, if the composition of the member information is exactly the same, the member information of the second database is added to the first database, and the second internet service provider adds the member information of the first database to the second database, thereby sharing the desired member. You can do Here, in the method of adding the counterpart member to its own database, only a part of the member information can be selectively added to the own database or added through the necessary modification.

However, it is a rare case that the structure and system of member databases are the same in this way, and it is common that the structure and system are different. Therefore, it is not possible to add the other member information to its own database as it is, but this can be solved by absorbing the relative ID based on the ID or operating the relative database as a lower database with a different system.

As a result of the comparison, for the IDs which are not duplicated in both databases, the first database adds the member information including the ID of the second database, and the second database includes the ID of the first database. Add the member information.

In this case, when the two service providers allied to share the other member, the member of the first Internet service can log in to the second Internet service and use the service without going through a separate membership process. Similarly, a member of the second internet service can use the first internet service by omitting a separate subscription procedure.

However, when the two databases are compared, the IDs may overlap. Internet users prefer to have good images or popular letters and numbers when choosing IDs, so comparing two databases reveals a lot of duplicate IDs.

When such a duplicate ID is found, the first internet service provider adds a distinguishable identification unit to the extracted duplicate ID among the members of the second internet service provider and adds the member information including the combined ID to the first ID. Add to database

In the same manner, the second Internet service provider adds a distinguishable identification unit to the ID for the duplicate ID extracted from the members of the first Internet service provider, and adds the member information including the combined ID to the second database. .

Here, the identification unit refers to the name of the delimiter and the second Internet service provider in succession after the duplicate member ID, and can form a new ID combined with the ID to avoid ID duplication. The ID is added to the first database along with the member information.

For example, when the name of the first service provider is "aaa", the name of the second service provider is "bbb", and the duplicate ID is "love", the first database sets the ID of the second service provider member to "love". Share your members with an ID that has been transformed into "bbb". Here, "@bbb" added to and combined with the original ID for identification is an identification unit, and the "@" symbol serving as a separator in this identification unit may use other symbols as necessary. In addition, in this specification, the "business name" may be a real name or domain name of the corresponding business operator, or may be a name specially selected for changing the ID. Therefore, the "business name" will be selected and combined to distinguish these IDs, and in most cases, some names of the domain names will be used.

In the same way, the second Internet service provider may modify the ID in the form of "love @ aaa" for the duplicate "love" ID and add it to the second database.

In this way, when a service is formed by a contract between both service providers and sharing of members starts, a member of the first provider becomes a member of the second Internet service without using the first Internet service without registering separately. You can log in to the Internet site and use the service. However, the right to use may vary between the original member and the member added by the association depending on the contents of the service. In other words, the original member is allowed to use all the services, and the members added by the federation can restrict the use of some services.

As described above, when a member of the first Internet service logs in to the website to use the second Internet service when the association is made between the first service provider and the second service provider, if there is no duplication of ID, You can enter the ID of the ID, but in the case of duplicate IDs of both services, you must enter the ID that added the identification unit to its original ID.

That is, in the above example, when the "love" ID is duplicated, the first service member must input the ID "love @ aaa" to log in to the website of the second service. In addition, the owner of the "love" ID of the second service must enter the ID "love @ bbb" in order to log in to the website of the first service.

In this way, additionally inputting the identification part is unfamiliar to the member and very burdensome. Therefore, the first service provider may provide a selection button so that the user can select a button when logging in when the second service member is a login screen of the website. Pressing this button configures the interface so that the identifier is automatically entered for the entered ID.

If the user tries to log in without selecting this button, the login will fail because the password is different. In this case, it is desirable to allow the user to log in conveniently by inquiring whether the second service member is asked again from the screen that guides the login failure and automatically providing an identification unit when responding thereto. This method can be applied to the second Internet service provider in the same way.

According to another aspect of the present invention, there is provided a first database in which information including an ID and a password of a member subscribed to a service service provided by a first Internet service provider, and a service service provided by a second Internet service provider. A method of assigning an e-mail account by associating a second database in which information including an ID and a password of a registered member is established, wherein the ID of the first database and the ID of the second database are overlapped with each other. Extracting the same ID; As a result of the comparison, for IDs that are not duplicated in both databases, the first database is in the form of its ID, an "at" symbol, and an email domain name of the first provider for the added ID of the second database. Granting an email account as; As a result of the comparison, for the IDs that are not duplicated in both databases, the second database is in the form of an ID, an "at" symbol, and an e-mail domain name of a second provider for an added ID of the first database. Assigning an email account; As a result of the comparison, for the IDs overlapping with each other, the first database has an ID, an "at" symbol, a second operator name, and an email domain name of the first operator for the added ID of the second database. Granting an email account as; As a result of the comparison, for the IDs overlapping with each other, the second database has an ID, an "at" symbol, a first operator name, and an e-mail domain name of the second operator for the added ID of the first database. A method for providing an email account is provided.

Internet service providers often provide e-mail accounts to their members while providing services that provide various contents or information. Therefore, when an e-mail account is assigned to each other when an association is made between two Internet service providers, an e-mail address is duplicated for a duplicate ID.

In order to avoid duplication of e-mail addresses, IDs of both databases are compared. For IDs that do not overlap, the e-mail account is given by assigning its own domain name to the original ID.

In the method of the present invention, first, IDs of the first database and IDs of the second database are compared to extract identical IDs that overlap each other. As a result of this comparison, the first database does not need to modify any IDs that do not overlap each other, so that the first database has an ID, an "at" symbol, and a first operator for the added ID of the second database. You can assign an email account in the form of an email domain name. This is essentially the same way of giving your members an account.

Here, "email domain name" means, for example, that the domain name of the first Internet service provider is "www.aaa.com" and the member ID of the service is "magic". You will be given an email account in the form of "magic@aaa.com". Therefore, in this specification, the email domain name refers to the at sign (@) added to the member's ID and the domain name ("@ aaa.com" in the above example) used for the email address.

Thus, the first internet service provider gives the member an email account in the form of an ID and an email domain name in this way, and the member also assigns an email account to a member of the second internet service provider added by the federation. The second Internet service provider also assigns an email account to the first Internet service member in the same manner (eg, the first service member's ID is "rainbow" and the second Internet service provider's domain name is "www.bbb.com". ", An email account is given in the form of" rainbow@bbb.com ").

However, as a result of comparing IDs of both federated databases, if an email account is assigned in the above manner for duplicate IDs, this method cannot be used. Therefore, the first database assigns an email account to the added ID of the second database in the form of its ID, " at " symbol, second carrier name and first carrier's email domain name. Here, the "at" symbol "@" is a symbol that is required for all e-mail addresses, and the second provider name added may be a real company name or domain name of the service provider, as defined above. It may be the name you choose. Thus, "business name" will be selected and combined for this distinction, and will often use some name of the domain name.

For example, the first Internet service (if "www.aaa.com") for an ID of "love" found as a duplicate ID in both databases would originally have an email account of "love@aaa.com" for its members. However, the subscription member of the second Internet service to be added is given an email account in the form of "love@bbb.aaa.com". Therefore, it is possible to avoid duplication by distinguishing it from its original member's email address "love@aaa.com".

Similarly, for IDs that overlap each other, the second database is in the form of an ID, an "at" symbol, a first operator name, and an email domain name of the second operator for the added ID of the first database. Give an email account.

For example, if the domain name of the second Internet service provider is "www.bbb.com" and the duplicate ID is "love", the original member is given an e-mail of "love@bbb.com" but the first one is given. Members added as members of the Internet service are given an email account in the form of "love@aaa.bbb.com".

Although the above has been described based on the association between the first service provider and the second service provider, the same method may be applied to the case where three or more service providers are united. Procedurally, it is possible to first complete the alliance between the two operators and to associate them with third parties, or to proceed simultaneously.

As apparent from the above description, according to the method of the present invention, it is possible to easily solve the problem of overlapping member IDs when the Internet service providers are associated with each other. In addition, there is an advantage of facilitating association between different operators because duplication can be avoided in the method of assigning an email account.

Claims (6)

A first database in which a plurality of member information including IDs and passwords of members subscribed to service tasks provided by the first Internet service provider are constructed, and a plurality of members subscribed to service tasks provided by the second Internet service provider; In the method of associating a second database in which member information including an ID and a password of the user is constructed, Comparing the ID of the first database with the ID of the second database and extracting the same ID that overlaps each other; Adding, to the first database, the member information including the ID of the second database, with respect to IDs which do not overlap with each other as a result of the comparison; Adding, to the second database, the member information including the ID of the first database, with respect to IDs not overlapping with each other in the comparison result; The first internet service provider adding member information including an ID of a combined type by adding a distinguishable identification unit to the extracted duplicate ID among members of the second internet service provider, to the first database; Wow; The second internet service provider adding member information including an ID of a combined type to the second database by adding a distinguishable identification unit to the extracted duplicate ID among members of the first internet service provider; ;, Including. The method of claim 1, wherein the distinguishable identification unit is integrated into the first database together with the member information as an ID having a combination of a delimiter and a name of a second Internet service provider. The method of claim 1, wherein the distinguishable identification unit is integrated into the second database together with the member information by an ID having a combination of a delimiter and a name of the first Internet service provider. 4. A method according to any one of the preceding claims, wherein said delimiter is an "at" sign (@). The method of claim 1, wherein the delimiter and the name of the second Internet service provider are automatically input when the member belonging to the first database logs in to the service service of the second Internet service provider. The first database that contains information including the ID and password of the member who subscribed to the service service provided by the first Internet service provider, and the ID and password of the member who subscribed to the service service provided by the second Internet service provider. In the method of granting an e-mail account by associating a second database in which information is included, Comparing the ID of the first database with the ID of the second database and extracting the same ID that overlaps each other; As a result of the comparison, for IDs that are not duplicated in both databases, the first database is in the form of its ID, an "at" symbol, and an email domain name of the first provider for the added ID of the second database. Granting an email account as; As a result of the comparison, for the IDs that are not duplicated in both databases, the second database is in the form of an ID, an "at" symbol, and an e-mail domain name of a second provider for an added ID of the first database. Assigning an email account; As a result of the comparison, for the IDs overlapping with each other, the first database has an ID, an "at" symbol, a second operator name, and an email domain name of the first operator for the added ID of the second database. Granting an email account as; As a result of the comparison, for the IDs overlapping with each other, the second database has an ID, an "at" symbol, a first operator name, and an e-mail domain name of the second operator for the added ID of the first database. Granting an email account to the method.