KR100556597B1 - Fixing System and Method of Field Attribute of Raw Data, Transmission System and Method of Message merged with Attribute Fixed Data from Raw Data - Google Patents

Abstract

The present invention relates to a system and method for determining field attributes of raw data, and to a message transmission system and method for merging analysis data having determined field attributes of raw data and transmitting a message. You can build a meaningful database by analyzing and merging the properties of fields stored in raw data obtained from file, html, Paradox, sql, Sybase, Interbase, etc. Using such a database, a short message (SMS), an e-mail, a DM (DM), or the like can be transmitted to a plurality of users, or real name or electronic name card can be delivered.

Database, Merge, Message, Content, Network

Description

FIXING SYSTEM AND METHOD OF FIELD Attribute of Raw Data, Transmission System and Method of Message merged with Attribute Fixed Data from Raw Data}

1 is a block diagram showing a system for determining field attributes of raw data according to an embodiment of the present invention.

2 is a flowchart illustrating an operation of a field attribute determination system of raw data according to an embodiment of the present invention.

3A and 3B are conceptual views illustrating a field attribute determination process of a field attribute determination system of raw data according to an embodiment of the present invention.

4 is a flowchart illustrating a message transmission process of a field attribute determination system of raw data according to another embodiment of the present invention.

FIG. 5 is a conceptual diagram illustrating a merging process of a message transmission system for merging analysis data having determined field attributes of raw data and transmitting a message according to another embodiment of the present invention.

6 is a block diagram showing a message transmission system for transmitting a message by merging the analysis data of the field attribute of the raw data according to another embodiment of the present invention.

7 is a flowchart illustrating an operation of a message transmission system for merging analysis data having determined field attributes of raw data and transmitting a message according to another embodiment of the present invention.

The present invention relates to a system and method for field attribute determination of raw data, and to a message transmission system and method for merging analytical data for determining field attributes of raw data and transmitting a message. More specifically, the present invention relates to an Excel or access method. Message that transmits a message after loading data file such as (access) and merging the field attribute determination data that analyzes the attribute of each field and combines with other data to determine the field attribute of the raw data to build a meaningful database. The present invention relates to a transmission method and a system.

In general, the mobile communication system is a communication system for mobile devices such as people, automobiles, ships, trains, and aircrafts, which includes key phone systems, mobile phones (cell phones, PCS, vehicle phones), port phones, aircraft phones, and mobile public phones. (Installed on trains, cruise ships, express buses, etc.), radio calling, radiotelephone, satellite mobile communication, amateur radio, fishing service ship.

In addition, short message service (SMS) enables voice or text message communication between mobile communication terminals such as Global System for Mobile communication (GSM), Code Division Multiple Access (CDMA), and Personal Communication System (PCS). It is a service to be used, and is mainly used in a situation where it is difficult to make a voice call between users.

Here, the situation in which a voice call is difficult means a case where a user of a sending / receiving terminal is in a place where a personal voice phone call is difficult, such as a conference hall. In this case, even if the terminal is called, it is difficult to make a voice call with the other party in response to the call. If there is an urgent need to make a call, it is difficult to make a voice call even if the call is made by the other terminal. You are in trouble.

In this case, the terminal users may contact the terminal user by using a short message by sending / receiving a text message, but may contact each other about necessary contents.

In recent years, communication using short messages has been frequently conducted mainly among teenagers, and product advertisements of respective companies or information transmission of financial companies are also performed using short messages.

However, these technologies have to build a new database in order to send a short message to a large number of users at the same time, there is a drawback that the simultaneous transmission is possible only by creating a well-aligned database such as phone numbers or addresses.

In addition, since the same message is always transmitted to a plurality of users, the user may not be familiar with the user who receives the message, and the advertisement effect is lowered due to a rejection such as spam mail.

In addition, even if there are other sorted databases, since only a part of them cannot be copied and pasted, there is a disadvantage in that data update or update is difficult.

The present invention has been made to solve the above problems, an object of the present invention is to build a meaningful database using an external database such as data, html, paradox or Sybase, such as Excel or Access By using this, a system and method for determining field attributes of raw data that can send a short message, email, DM, or real name or electronic name card to a large number of users, and merging analysis data that determines field attributes of raw data It is to provide a message transmission system and method for transmitting.

Another object of the present invention is a system and method for field attribute determination of raw data capable of sending a message to a plurality of users at the same time by merging the contents of a database and a message by sending a short message or the like and changing only the information of the receiver in the same content. In addition, the present invention provides a message transmission system and method for transmitting a message by merging analysis data having determined field attributes of raw data.

The above object is, according to an embodiment of the present invention, a field attribute determination system that includes a central computing device, a memory, a user interface, and retrieves raw data including personal information of a plurality of users to determine attributes of each field. Extracting a portion of the plurality of records included in the plurality of fields of the raw data to search for whether the specific data representing the specific field is included in each of the fields, and as a result of the searching, the specific data is relatively It is achieved by the field attribute determination system of the raw data, including; field attribute determination module for determining the most contained field as the specific field.

The field attribute determination module extracts the entire record included in the field when the probability of the field containing the most specific data as a result of the search is lower than a predetermined value and indicates the specific field in the respective field. Search for whether is included, and determine as a specific field a field containing the most relatively the specific data as a result of the search.

The specific field may include a name field, a phone number field, an address field, and an e-mail address field.

The raw data is data described in any one or more of an Excel DB, an access DB, various text files, html, sql, Paradox, Sybase, and Interbase. It features.

In addition, the above object is, according to another embodiment of the present invention, a field attribute for determining the properties of each field by retrieving the raw data including the central computing device, memory, user interface, including the personal information of a plurality of users A determination system, comprising: extracting a part of a plurality of records included in a plurality of fields of the raw data to search whether each field contains specific data representing a specific field, and as a result of the searching the specific data is A field attribute determination module for determining a field including the most relatively as the specific field; A merging module for merging contents of a message to be transmitted and a record of the specific field to send a message in which different items are described to a plurality of users; It is achieved by a message transmission system for transmitting a message by merging the field attribute determination data that determines the field attribute of the raw data, including a transmission module for transmitting the message to a plurality of users.

The transmission system may further include a content DB storing content data authenticated to be executable only by the user terminal that has been authenticated as a plurality of contents included in the message.

In addition, the above object is a message transmission method using a message transmission system including a central processing unit, a memory, a field attribute determination module, a merging module, according to another embodiment of the present invention, a plurality of from the memory or an external database A first step of importing raw data including personal information of the receiver; Extracting a part of a plurality of records included in the plurality of fields of the raw data, searching whether the specific data representing a specific field is included in each field, and as a result of the searching, the specific data is relatively the most A second step of determining the included field as the specific field is achieved by a method comprising a.

If the probability of the field containing the most specific data is lower than a predetermined value as a result of the search, the entire record included in the field is extracted to search whether the specific data representing the specific field is included in each field. And determining, as a result of the search, a field containing the largest amount of the specific data as the specific field.

The raw data is data described in any one or more of an Excel DB, an access DB, various text files, html, sql, Paradox, Sybase, and Interbase. It features.

In addition, the above object is a message transmission method using a message transmission system including a central processing unit, a memory, a field attribute determination module, a merging module, according to another embodiment of the present invention, a plurality of from the memory or an external database A first step of importing raw data including personal information of the receiver; Extracting a part of a plurality of records included in the plurality of fields of the raw data, searching whether the specific data representing a specific field is included in each field, and as a result of the searching, the specific data is relatively the most Determining a field included in the specific field; If the probability of the field containing the most specific data is lower than a predetermined value as a result of the search, the entire record included in the field is extracted to search whether the specific data representing the specific field is included in each field. A third step of determining, as a result of the search, a field containing the most relatively specific data as the specific field; Merging the contents of the message to be transmitted and the record of the specific field and merging a message describing a different item to a plurality of users; And a fifth step of transmitting the message to a plurality of users, by merging the field attribute determination data that determines the field attribute of the raw data, and transmitting the message.

In addition, the above object is a message transmission method using a message transmission system including a central processing unit, a memory, a field attribute determination module, a merging module, according to another embodiment of the present invention, a plurality of from the memory or an external database A first step of importing raw data including personal information of the receiver; Extracting a part of a plurality of records included in the plurality of fields of the raw data, searching whether the specific data representing a specific field is included in each field, and as a result of the searching, the specific data is relatively the most Determining a field included in the specific field; If the probability of the field containing the most specific data is lower than a predetermined value as a result of the search, the entire record included in the field is extracted to search whether the specific data representing the specific field is included in each field. A third step of determining, as a result of the search, a field containing the most relatively specific data as the specific field; Merging the contents of the message to be transmitted and the record of the specific field and merging a message describing a different item to a plurality of users; Inserting a plurality of contents into the contents of the message;

And a sixth step of transmitting the message to a plurality of users; merging the field attribute determination data that determines the field attribute of the raw data to transmit the message.

The content is characterized in that the authentication process to be executable only in the user terminal receiving the member authentication.

DETAILED DESCRIPTION Hereinafter, exemplary embodiments of the present invention will be described with reference to the accompanying drawings so that those skilled in the art may easily implement the present invention.

Example 1

1 is a block diagram showing the configuration of a configuration diagram showing a field attribute determination system (hereinafter referred to as "determination system") of raw data according to an embodiment of the present invention.

As shown in FIG. 1, the determination system 100 includes a user interface 110, a field attribute determination module 120, a merging module 130, an analysis information DB 140, a RAM 150, and a CPU 160. ), And a transmission module 170.

The user interface 110 uses a determination system 100 to allow a user who wants to determine field attributes of raw data to execute a dedicated program or to input raw data from the outside.

Here, the raw data includes data written in any one or more of Excel DB, access DB, various text files, html, sql, Paradox, Sybase, and Interbase. Say.

That is, it is possible to extract raw data having a total of 100 records by extracting 40 records from 30 html from an Excel DB and 30 HTML from an Access DB.

When the user inputs raw data, the field attribute determination module 120 extracts a portion (for example, five records) of a plurality of records included in a plurality of fields of the raw data, and selects a specific field in each field. It searches whether the specific data indicating the data is included and determines the field containing the most specific data as a result of the search as the specific field.

If the raw data is obtained from a plurality of databases of different types, the sample data must be extracted from each type of database.

Also, if the result of the search is that the probability of the field containing the most specific data is lower than the predetermined value (for example, 30%), the specific data representing the specific field in each field is extracted by extracting the entire record included in the field. It searches whether it is included and determines the field that contains the most specific data as a specific field.

The merging module 130 connects the contents of the message to be transmitted and the record of the analysis information determined by the field property determination module 120 to send a message in which different items are described to a plurality of users.

The analysis information DB 140 stores the analysis information in which the field property determination module 120 determines the property. The user may temporarily store the analysis information on the memory and use the analysis information, or may store the analysis information in the analysis information DB 140 and continue using the analysis information.

The RAM 150 temporarily stores the raw data input by the user and the analysis information determined by the field property determination module 120, and provides the same in a merge or transfer process. The RAM 150 may be replaced with a general memory device. have.

The CPU 160 drives the user interface 110 and records data in various databases.

The transmission module 170 transmits a message written by the user to a plurality of users.

Next, the operation of the determination system 100 according to an embodiment of the present invention will be described with reference to FIGS. 2, 3A, and 3B.

By analyzing the raw data, the property of each field is determined, and the user who wants to send a message to a plurality of users executes the user interface 110 by using the same (S100).

The user may use the raw data stored in the RAM 150 inside the determination system 100 or may load the raw data collected from an external database (S110).

The field attribute determination module 120 extracts a part of the records of each field of the input raw data as a sample record (S120). For example, if the raw data composed of four fields each including 100 records is input, The field attribute determination module 120 extracts the first five records. The number of such sample records may be determined differently according to the situation of the determination system 100.

The field attribute determination module 120 executes a search for determining the attribute of the field with respect to the sample record thus extracted (S130).

In other words, each of the five records extracted from the first to the fourth field is searched for specific data representing a name, for example, the letters 'kim, lee, bak'.

If the first field is a name field, it is very likely that one of the five records contains one of 'kim, lee, bak'.

In the same way, for each of the five records in the second to fourth fields, the same way is searched for the letters 'Kim, Lee, Park'.

If the second to fourth fields are unnamed fields, the probability of these characters is very low.

As a result, if there is a 70% probability that the first field contains 'Kim, Lee, Park', and the rest is 0%, 20%, and 10%, respectively, the first field may be a recorded field.

When the search for 'name' is finished, this time the search for the 'phone number' field is performed.

Again, the search is done in the same way as before, but the specific data representing the attribute of the field will be a number such as '0, 1, 2'.

Next, search for 'address' with 'Seoul, Busan, Daegu' as the specific data, and 'email address' with '@, com, net' as the specific data. The field becomes the field of the attribute.

The field attribute determination module 120 determines whether the field attribute determination condition is satisfied in order to determine whether such a search result has sufficient reliability to determine each field (S140).

If the first to fourth field search results for 'name' result in probability of 70, 0, 10 and 0%, respectively, the first field may be determined as the 'name' field.

However, in the first five records of the first field, only one person may have the last name 'Kim, Lee, Park', and the remaining fields may not have any of these letters.

The search results at this time will be 20, 0, 0, and 0%, respectively. The probability of determining that the first field is the 'name' field is low with only 20% of such probability.

As such, when the probability is less than a predetermined value (for example, 30%), a method of increasing the reliability should be taken.

That is, 100 records included in each field are extracted (S150), and a search for determining the attribute of a field is performed for all records in the same manner as described above (S160).

If a search result for a sample record shows a probability that has sufficient reliability, or if there is a field indicating the highest probability by re-searching the entire record, the attribute of the corresponding field is determined and recorded in the RAM 150. (S170)

The CPU 160 stores the data (hereinafter referred to as "analysis information") in which the attribute of each field is determined in the analysis information DB 140 as described above (S180).

3A and 3B are conceptual views illustrating a field attribute determination process by the field attribute determination module 120, and illustrates how the raw data (FIG. 3A) for which the attribute of each field is not yet determined is changed to analysis information (FIG. 3B). Specifically shown.

Example 2

4 is a flowchart illustrating a message transmission process of merging analysis data obtained by determining field attributes of raw data and transmitting a message according to another embodiment of the present invention.

Referring to Figure 4 describes the message transmission process of the determination system 100, the user loads the analysis information stored in the analysis information DB 140 using the CPU (160) (S200).

The user writes a message to be transmitted to another user using the user interface 110 (S210).

The merging module 130 determines whether to merge the message and the analysis information created by the user (S220), and if there is no request for this, the transmission module 170 transmits the corresponding message to the designated recipient (S240).

If there is a merge request, the operation of merging the created message and the analysis information (S230).

A merging operation associates a particular part of a message with a particular record in that field. If there is a part in the same message that indicates a name, address, etc., it does not repeat it. To connect.

The message that completes the merge operation is transmitted to the receiver designated by the transmission module 170.

5A, 5B, and 5C are conceptual views illustrating a merge process of the determination system 100 according to another embodiment of the present invention.

FIG. 5A illustrates contents of merging corresponding data into analysis information while a user composes a message. Each message becomes a form of FIGS. 5B and 5C through such merging.

Example 3

6 is a block diagram illustrating a message transmission system for merging analysis data obtained by determining field attributes of raw data and transmitting a message according to another embodiment of the present invention.

Referring to Fig. 6, a message transmission system (hereinafter referred to as "transmission system") for merging analysis data having determined field attributes of raw data and transmitting a message will be described.

The transmission system 200 is connected to the above-described determination system 100 and the plurality of receiver terminals 300 through an open network 400 including the Internet.

The transmission system 200 includes a web server 210, a member authentication module 220, a member information DB 230, a content DB 240, and a dedicated program DB 250.

The web server 210 provides an interface through which the decision system 100 connected to the transmission system 200 through the network 400 can use the message transmission service. In addition, the web server 210 serves to transmit a message produced by the transmission system 200, that is, a short message (SMS), an e-mail, a DM (DM), etc. to a plurality of recipient terminals 300.

The member authentication module 220 manages personal information of a user registered as a member in the transmission system 200, and performs an authentication procedure using an ID and password when the user logs in to use the transmission system 200. do.

Each user may transmit a message using various message servers he has, or may transmit a message through the transmission system 200.

In addition, when you want to insert a background picture or emoticon, etc. in the message written by the user, it goes through the membership authentication process.

Member information DB 230 stores the personal information of the user registered as a member in the transmission system 200, and if a member information request for membership authentication is input from the member authentication module 220, it serves to retrieve and output it do.

In addition, the member information DB 230 may provide the decision system 100 or another receiver terminal 300 with respect to the information of the member who wishes to disclose his information.

The content DB 240 stores content data such as a background picture, emoticon, music, text, and the like, which is inserted into a message written by a user logged in to the delivery system 200.

The content data stored here includes music files such as mp3, picture files such as jpeg, text files containing song lyrics and poems, etc., and are stored and transmitted in a state where copying is prevented through normal security authentication technology. do.

Therefore, the message in which such content is inserted can be used only in the terminal of the authenticated member, and the reproduction or reproduction to the third party is blocked.

In addition, the content data may be produced by the transmission system 200 itself or may be produced by other members.

When other members insert content data produced and stored in the content DB 240 into a message, a predetermined cost thereof must be paid, and such a cost can be distributed to a user who produced the content at a predetermined rate.

Dedicated program DB 250 stores a dedicated program that allows the general receiver terminal 300 to operate as the determination system 100 according to an embodiment of the present invention, the receiver subscribed to the transmission system 200 as a member Send and install a dedicated program to the terminal 300.

The receiver terminal 300 includes a general computer, a mobile phone (cell phone, PCS), a personal digital assistant (PDA), and the like, and includes all devices capable of communication and message transmission through a network.

When the user receives the dedicated program from the dedicated program DB 250 of the transmission system 200 and installs it in his / her receiver terminal 300, the corresponding terminal may perform a function as the determination system 100.

The network 400 connects the determination system 100, the transmission system 200, and the receiver terminal 300. The network 400 corresponds to a mobile communication network capable of data communication, including the Internet.

7 is a flowchart illustrating the operation of a transmission system 200 according to another embodiment of the present invention.

Referring to FIG. 7, the operation of the transmission system 200 will be described. The determination system 100 loads analysis information stored in its memory (S300), determines the content of a message to be transmitted, and creates a message (S310). )

As described above, the message to be sent may be merged as necessary.

When inserting content such as a background picture or text in the created message (S320), the determination system 100 is connected to the transmission system 200 through the network 400, the member authentication module 220 is a member information DB The member authentication operation is performed based on the user's personal information stored at 230. (S330).

When the member authentication procedure is completed and logged in, the web server 210 extracts the content data stored in the content DB 240 and transmits the content data to the determination system 100, and the determination system 100 inserts the content to be inserted. (S340)

Determination system 100 is to pay a predetermined cost for the selected content (S350), such a payment system and payment method is a conventional technique, the description thereof will be omitted.

The content insertion complete message is transmitted to the corresponding receiver terminal 300, and the procedure ends.

In the above description, a system and method for determining field attributes of raw data according to the present invention, and a message transmission system and method for merging analytical data that determines field attributes of raw data and transmitting a message are described. It is not limited.

That is, in the present invention, the field attribute analysis module extracts and searches only five records of each field, but the number can be easily changed by those skilled in the art.

In addition, although the attribute of the field is set to four such as 'name, address, phone number, and e-mail address' in the present invention, the number may be increased when more information is required.

In addition, as a method of searching for the attribute of a field, all the fields can be searched for names, and then the numbers, addresses, and e-mail addresses can be identified in order. After searching for all the entries, you can also search for the next field.

In addition, although Embodiment 3 of the present invention lists some types of contents that can be interchanged by a user, other types of data that can be exchanged with each other over network communication may also be included in the contents.

As described above, the present invention can construct a meaningful database by searching each field of the raw data existing outside such as Excel or Access and determining its properties, and by using this, a short message to a plurality of users, You can send messages such as e-mail and DM.

In addition, it is possible to decorate a message by inserting various types of content in a message transmitted between a plurality of users, and to distribute a predetermined cost to a user who produced the content, thereby providing economic benefits to activate the use. It can be effective.

In addition, the present invention has the effect that it is possible to send a message to a plurality of users at the same time by merging the record of each field of the database and the content of the message when sending the message to change only the specific information in the same content.

Claims (12)

A field property determination system for retrieving raw data including a central computing device, a memory, and a user interface and including personal information of a plurality of users and determining the properties of each field, Extracting a part of a plurality of records included in the plurality of fields of the raw data, searching whether the specific data representing a specific field is included in each field, and as a result of the searching, the specific data is relatively the most And a field attribute determination module for determining an included field as the specific field. The method of claim 1, The field attribute determination module If the probability of the field containing the most specific data is lower than a predetermined value as a result of the search, the entire record included in the field is extracted to search whether the specific data representing the specific field is included in each field. And determining, as a result of the search, a field containing the most relatively specific data as the specific field. The method of claim 2, The specific field A field attribute determination system of raw data, comprising a name field, a telephone number field, an address field, and an email address field. The method of claim 3, The raw data is data described in any one or more of an Excel DB, an access DB, various text files, html, sql, Paradox, Sybase, and Interbase. Field attribute determination system of raw data characterized by the above-mentioned. A field property determination system for retrieving raw data including a central computing device, a memory, and a user interface and including personal information of a plurality of users and determining the properties of each field, Extracting a part of a plurality of records included in the plurality of fields of the raw data, searching whether the specific data representing a specific field is included in each field, and as a result of the searching, the specific data is relatively the most A field attribute determination module for determining an included field as the specific field; A merging module for merging contents of a message to be transmitted and a record of the specific field to send a message in which different items are described to a plurality of users; And a transmission module for transmitting the message to a plurality of users. The message transmission system for merging the field attribute determination data determining the field attribute of the raw data, and transmitting the message. The method of claim 5, The transmission system Merge the field attribute determination data that determines the field attribute of the raw data, further comprising a content DB storing content data authenticated to be executable only by the user terminal that has been authenticated as a plurality of contents included in the message. A message transmission system that sends a message by sending a message. A field attribute determination method using a message transmission system including a central computing unit, a memory, a field attribute determination module, and a merging module, A first step of importing raw data including personal information of a plurality of recipients from the memory or an external database; Extracting a part of a plurality of records included in the plurality of fields of the raw data, searching whether the specific data representing a specific field is included in each field, and as a result of the searching, the specific data is relatively the most And a second step of determining an included field as the specific field. The method of claim 7, wherein If the probability of the field containing the most specific data is lower than a predetermined value as a result of the search, the entire record included in the field is extracted to search whether the specific data representing the specific field is included in each field. And determining, as a result of the search, a field containing the largest amount of the specific data as the specific field. 3. The method of claim 8, The raw data is Raw data characterized in that the data described in any one or more of an Excel DB, an access DB, various text files, html, sql, Paradox, Sybase, Interbase. How to determine field attributes of data. A message transmission method using a message transmission system including a central computing device, a memory, a field property determination module, and a merging module, A first step of importing raw data including personal information of a plurality of recipients from the memory or an external database; Extracting a part of a plurality of records included in the plurality of fields of the raw data, searching whether the specific data representing a specific field is included in each field, and as a result of the searching, the specific data is relatively the most Determining a field included in the specific field; If the probability of the field containing the most specific data is lower than a predetermined value as a result of the search, the entire record included in the field is extracted to search whether the specific data representing the specific field is included in each field. A third step of determining, as a result of the search, a field containing the most relatively specific data as the specific field; Merging the contents of the message to be transmitted and the record of the specific field and merging a message describing a different item to a plurality of users; And a fifth step of transmitting the message to a plurality of users; merging the field attribute determination data that determines the field attribute of the raw data, and transmitting the message. A message transmission method using a message transmission system including a central computing device, a memory, a field property determination module, and a merging module, A first step of importing raw data including personal information of a plurality of recipients from the memory or an external database; Extracting a part of a plurality of records included in the plurality of fields of the raw data, searching whether the specific data representing a specific field is included in each field, and as a result of the search, the specific data is relatively the most Determining a field included in the specific field; If the probability of the field containing the most specific data is lower than a predetermined value as a result of the search, the entire record included in the field is extracted to search whether the specific data representing the specific field is included in each field. A third step of determining, as a result of the search, a field containing the most relatively specific data as the specific field; Merging the contents of the message to be transmitted and the record of the specific field and merging a message describing a different item to a plurality of users; Inserting a plurality of contents into the contents of the message; Transmitting the message by merging the field attribute determination data that determines the field attribute of the raw data, the sixth step of transmitting the message to a plurality of users. The method of claim 11, And transmitting the message by merging the field attribute determination data that determines the field attribute of the raw data, wherein the content is authenticated so as to be executable only by the user terminal which has received the member authentication.

Images