JPH06131220A - Customer master rearranging method - Google Patents

Customer master rearranging method

Info

Publication number
JPH06131220A
JPH06131220A JP4282609A JP28260992A JPH06131220A JP H06131220 A JPH06131220 A JP H06131220A JP 4282609 A JP4282609 A JP 4282609A JP 28260992 A JP28260992 A JP 28260992A JP H06131220 A JPH06131220 A JP H06131220A
Authority
JP
Japan
Prior art keywords
data
customer information
area
date
pointer
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
JP4282609A
Other languages
Japanese (ja)
Inventor
Mari Takada
麻吏 高田
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
NEC Corp
Original Assignee
NEC Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by NEC Corp filed Critical NEC Corp
Priority to JP4282609A priority Critical patent/JPH06131220A/en
Publication of JPH06131220A publication Critical patent/JPH06131220A/en
Pending legal-status Critical Current

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

PURPOSE:To add new customer information by rearranging a customer information file and automatically deleting old data. CONSTITUTION:Customer information of old writing date is searched for by comparing dates by using a table 1 which contains the writing dates of customer information and the customer information. The searched customer information and date are moved from the table 1 to a temporary saving area 5 and the data in a final date area 3 that a pointer 4 indicates and the data in the final customer information area 2 before the pointer 4 are moved to the table whose data are stored in the temporary saving area 5. Then the data stored in the temporary saving area 5 are moved to the table that the pointer 4 indicates. Consequently, the customer data having the old date to be deleted are saved in the final table, so the data are deleted; and then the address of the last date area 3 is stored in the pointer 4 and preparations for a next deleting process are made.

Description

【発明の詳細な説明】Detailed Description of the Invention

【0001】[0001]

【産業上の利用分野】本発明は、顧客マスター整理方法
に関する。
BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a customer master organization method.

【0002】[0002]

【従来の技術】従来の顧客マスターの整理方法は、顧客
情報を格納しているテーブルの領域が満杯になったとき
に、使用者が手動で1つずつ顧客情報をみていき、削除
してもよさそうなデータを適当に選び削除している。
2. Description of the Related Art A conventional method of organizing a customer master is that even if a user manually looks at customer information one by one and deletes it when an area of a table storing customer information is full. The data that looks good is properly selected and deleted.

【0003】[0003]

【発明が解決しようとする課題】この従来の顧客マスタ
ー整理方法では、削除だけでも時間がかかるだけでな
く、ランダムに顧客データを削除するため新規データの
追記エリアをうまく確保できない。
In this conventional customer master organizing method, not only the deletion takes time, but also the customer data is deleted at random, so that the additional data writing area cannot be secured well.

【0004】[0004]

【課題を解決するための手段】本発明の顧客マスター整
理方法は、顧客情報を格納しているテーブルから削除可
能な顧客情報を検索する手段と、この検索手段によって
検索した顧客データを削除する手段と、顧客情報を格納
しているテーブルに空き領域を確保する手段とを含むこ
とを特徴とする。
A customer master organization method according to the present invention comprises means for retrieving deletable customer information from a table storing customer information, and means for deleting customer data retrieved by this retrieving means. And a means for securing a free area in a table storing customer information.

【0005】[0005]

【実施例】次に、本発明について図面を参照して説明す
る。
DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be described with reference to the drawings.

【0006】図1は本発明の一実施例の説明図であり、
図2はこの実施例の処理を示すフローチャートである。
FIG. 1 is an explanatory view of an embodiment of the present invention.
FIG. 2 is a flowchart showing the processing of this embodiment.

【0007】図1を参照すると、あらかじめテーブル1
に複数の顧客の顧客情報を顧客情報エリア2に格納し、
その格納した日付をテーブル1の日付エリア3に格納し
ておく。
Referring to FIG. 1, a table 1 is prepared in advance.
Store customer information of multiple customers in customer information area 2,
The stored date is stored in the date area 3 of the table 1.

【0008】削除したい件数を使用者が設定し、実行を
確認すると、動作が開始される。
When the user sets the number of items to be deleted and confirms the execution, the operation is started.

【0009】まず、図2の削除件数のゼロ比較処理6で
使用者が設定した削除したい件数がゼロかどうかを判別
する。ゼロでなければ日付比較処理7を行なう。テーブ
ル1の先頭の日付エリアのアドレスと、2番目の日付エ
リアのアドレスが日付比較処理7での比較データアドレ
スである。これらのアドレス内容である日付が比較され
る。
First, it is determined whether or not the number of deletions set by the user is zero in the zero comparison processing 6 of the number of deletions in FIG. If it is not zero, the date comparison process 7 is performed. The address of the first date area and the address of the second date area in Table 1 are comparison data addresses in the date comparison processing 7. The dates that are the contents of these addresses are compared.

【0010】次にテーブル1の最終顧客データの日付エ
リアのアドレスを示すポインタ4と、日付比較処理7で
比較した日付のうち大きい方のアドレスとをポインタ比
較処理8で比較する。その結果、ポインタ4の方のアド
レスが大きかった場合、日付比較処理7に戻る。そし
て、前回の日付比較処理7の結果、古い顧客データとな
った方のアドレスの内容と次の顧客データの日付エリア
のアドレス、この例では3番目の日付エリアのアドレス
の内容とで今回の日付比較処理7を行なう。
Next, in the pointer comparison processing 8, the pointer 4 indicating the address of the date area of the final customer data in the table 1 and the larger address of the dates compared in the date comparison processing 7 are compared. As a result, if the address of the pointer 4 is larger, the process returns to the date comparison process 7. Then, as a result of the previous date comparison processing 7, the content of the address of the old customer data and the address of the date area of the next customer data, in this example, the content of the address of the third date area, the current date. Comparison processing 7 is performed.

【0011】このループをポインタ4のアドレスの方が
大きい間は繰り返す。
This loop is repeated while the address of the pointer 4 is larger.

【0012】そして、ポインタ比較処理8の結果が、ポ
インタ4のアドレスと等しいとなった場合、データの入
れ替え処理9を行なう。データの入れ替え処理9では、
まず、日付比較処理7の結果、古い顧客データとなった
顧客情報エリア2のデータと日付エリア3のデータをテ
ーブル1から一時一時退避エリアに移動し格納する。そ
して、ポインタ4の示すアドレスより前の顧客情報エリ
ア2のデータと、ポインタ4の示すアドレスの日付エリ
ア3のデータをテーブル1で空きとなった顧客情報エリ
ア2と日付エリア3に移動し格納する。その後、一時退
避エリア5に格納した古い顧客データをポインタ4の示
すアドレスの前の顧客情報エリア2とポインタ4の示す
日付エリア3に移動し格納する。
Then, when the result of the pointer comparison processing 8 becomes equal to the address of the pointer 4, the data replacement processing 9 is performed. In the data exchange process 9,
First, as a result of the date comparison process 7, the data of the customer information area 2 and the data of the date area 3 which have become old customer data are moved from the table 1 to the temporary save area and stored. Then, the data in the customer information area 2 before the address indicated by the pointer 4 and the data in the date area 3 at the address indicated by the pointer 4 are moved to and stored in the customer information area 2 and the date area 3 which are empty in the table 1. . Thereafter, the old customer data stored in the temporary save area 5 is moved to and stored in the customer information area 2 before the address indicated by the pointer 4 and the date area 3 indicated by the pointer 4.

【0013】これでデータの入れ替え処理9は終了し、
カウント変更処理10を行なう。カウント変更処理10
では、ポインタ4のアドレスから顧客1件分の顧客情報
エリア長と日付エリア長を演算し、その結果をポインタ
4に格納する。また、削除件数から1を減算する。そし
て、削除処理11でポインタ4以降の顧客情報エリアの
データとそれに続く日付エリアのデータを削除する。こ
れで1件分の顧客データが削除できる。
This completes the data exchange processing 9,
Count change processing 10 is performed. Count change processing 10
Then, the customer information area length and the date area length for one customer are calculated from the address of the pointer 4, and the result is stored in the pointer 4. Also, 1 is subtracted from the number of deleted items. Then, in the deletion processing 11, the data in the customer information area after the pointer 4 and the data in the subsequent date area are deleted. With this, one customer data can be deleted.

【0014】その後、削除件数のゼロ比較処理6に戻
り、削除件数がゼロになるまでこのループを繰り返す。
After that, the process returns to the zero comparison processing 6 of the number of deletions, and this loop is repeated until the number of deletions becomes zero.

【0015】[0015]

【発明の効果】以上説明したように、本発明は、顧客情
報管理テーブルから削除可能な顧客データを検索し、削
除後、空き領域を確保するため、自動的に簡単に顧客情
報を整理することができるという効果を奏する。
As described above, according to the present invention, the customer information management table is searched for deletable customer data, and a free area is secured after the deletion, so that the customer information is automatically and easily organized. There is an effect that can be.

【図面の簡単な説明】[Brief description of drawings]

【図1】本発明の一実施例の説明図である。FIG. 1 is an explanatory diagram of an embodiment of the present invention.

【図2】本発明の一実施例の処理を示すフローチャート
である。
FIG. 2 is a flowchart showing a process of an embodiment of the present invention.

【符号の説明】[Explanation of symbols]

1 テーブル 2 顧客情報エリア 3 日付エリア 4 ポインタ 5 一時退避エリア 6 削除件数のゼロ比較処理 7 日付比較処理 8 ポインタ比較処理 9 データの入れ替え処理 10 カウント変更処理 11 削除処理 1 Table 2 Customer information area 3 Date area 4 Pointer 5 Temporary save area 6 Zero comparison processing of the number of deletions 7 Date comparison processing 8 Pointer comparison processing 9 Data replacement processing 10 Count change processing 11 Delete processing

Claims (1)

【特許請求の範囲】[Claims] 【請求項1】 顧客情報を格納しているテーブルから削
除可能な顧客情報を検索する手段と、この検索手段によ
って検索した顧客データを削除する手段と、顧客情報を
格納しているテーブルに空き領域を確保する手段とを含
むことを特徴とする顧客マスター整理方法。
1. A means for retrieving deletable customer information from a table storing customer information, a means for deleting customer data retrieved by this retrieving means, and an empty area for a table storing customer information. A method for organizing a customer master, comprising:
JP4282609A 1992-10-21 1992-10-21 Customer master rearranging method Pending JPH06131220A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP4282609A JPH06131220A (en) 1992-10-21 1992-10-21 Customer master rearranging method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP4282609A JPH06131220A (en) 1992-10-21 1992-10-21 Customer master rearranging method

Publications (1)

Publication Number Publication Date
JPH06131220A true JPH06131220A (en) 1994-05-13

Family

ID=17654744

Family Applications (1)

Application Number Title Priority Date Filing Date
JP4282609A Pending JPH06131220A (en) 1992-10-21 1992-10-21 Customer master rearranging method

Country Status (1)

Country Link
JP (1) JPH06131220A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH07325739A (en) * 1994-05-31 1995-12-12 Nec Corp File management system

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH07325739A (en) * 1994-05-31 1995-12-12 Nec Corp File management system

Similar Documents

Publication Publication Date Title
CA2501667A1 (en) System and method for managing data using static lists
CN107368545A (en) A kind of De-weight method and device based on MerkleTree deformation algorithms
JPH06131220A (en) Customer master rearranging method
JPH06202919A (en) Dynamic change system for logical data structure of data base
JPH096653A (en) Data base checking information processor
JPH07152615A (en) Data base reorganization system
JP2741999B2 (en) Data storage management method
US6330571B1 (en) Method and computer program product for implementing datalink path protection
JP2616686B2 (en) Database reorganization during business process
US8069214B1 (en) Method and apparatus for managing messaging identities
JPH08328929A (en) Database split management system
JPS58114149A (en) Electronic filing system
US20040103392A1 (en) Saving and retrieving archive data
JPH0385650A (en) Disk volume restoration system
JPH04252342A (en) Data archive controller for information processing system
JPH06103134A (en) Constructing method for index
JP2658964B2 (en) Data record storage position control method
JP2000148548A (en) Unnecessary record deleting device
JP2834985B2 (en) Equipment number management device
JPH06223146A (en) Data storing method
JP2785966B2 (en) Foreign key dynamic resolution processing method
JPS60148251A (en) Mail box management system
JPH05151037A (en) Reorganization processing system for database in business processing
JP3398672B2 (en) Intermediate data storage device
JP2643850B2 (en) File processing device

Legal Events

Date Code Title Description
A02 Decision of refusal

Free format text: JAPANESE INTERMEDIATE CODE: A02

Effective date: 19991019