JPH06131220A - Customer master rearranging method - Google Patents
Customer master rearranging methodInfo
- 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
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
【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.
【図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.
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)
除可能な顧客情報を検索する手段と、この検索手段によ
って検索した顧客データを削除する手段と、顧客情報を
格納しているテーブルに空き領域を確保する手段とを含
むことを特徴とする顧客マスター整理方法。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:
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)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH07325739A (en) * | 1994-05-31 | 1995-12-12 | Nec Corp | File management system |
-
1992
- 1992-10-21 JP JP4282609A patent/JPH06131220A/en active Pending
Cited By (1)
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 |