Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!netsys!macomh!macom1!larry
From: larry@macom1.UUCP (Larry Taborek)
Newsgroups: comp.sources.wanted
Subject: Re: ascii database program package?
Message-ID: <4858@macom1.UUCP>
Date: 14 Jul 89 12:00:53 GMT
References: <1356@nosc.NOSC.MIL>
Organization: CENTEL Federal Systems, Reston, VA. 22091-1506
Lines: 40

From article <1356@nosc.NOSC.MIL>, by dennis@peanuts.nosc.mil (Dennis Cottel):
> I once read an article about a package of routines that manipulated
> databases organized as records in a normal ASCII file.  The package
> provided programs acting as filters to select records by keyword and
> to format them into reports.  Can anyone give me a reference to that
> article or to a similar set of programs?  Thanks,
> 
> 	Dennis Cottel  Naval Ocean Systems Center, San Diego, CA  92152
> 	(619) 553-1645      dennis@nosc.MIL      sdcsvax!noscvax!dennis

Unix comes with several tools that can allow you to build a
relational dbms and maintain it.

The tool join can do a relational join between two files on a
'key' field.

The tool sort can sort files.

The tool uniq can be used after a join/sort to remove duplicate
records.

The tool sed can be used to delete records, or extract records.

The tool awk can do math operations on records, or reform
records.

The tool cut can extract fields from records.

If you feel that it is just too hard to try to manipulate a
database with these, then there is always a shell language to try
to put a easier front end between you and the tools.

Also, its free, and you already have it.


-- 
Larry Taborek	..!uunet!grebyn!macom1!larry	Centel Federal Systems
		larry@macom1.UUCP		11400 Commerce Park Drive
						Reston, VA 22091-1506
						703-758-7000