From owner-freebsd-database Thu Dec 17 21:23:56 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA19902 for freebsd-database-outgoing; Thu, 17 Dec 1998 21:23:56 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id VAA19775 for ; Thu, 17 Dec 1998 21:23:51 -0800 (PST) (envelope-from tom@sdf.com) Received: from tom by misery.sdf.com with esmtp (Exim 1.82 #3) id 0zqrUU-0005Hv-00; Thu, 17 Dec 1998 20:26:14 -0800 Date: Thu, 17 Dec 1998 20:26:04 -0800 (PST) From: Tom To: jonathan michaels cc: freebsd-database@FreeBSD.ORG Subject: Re: conversion from asksam In-Reply-To: <19981218152005.A411@caamora.com.au> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 18 Dec 1998, jonathan michaels wrote: > i have recently, taken over a task that involves maintaining an asksam (for > dos) database. i was thinking that it would be much easier to have an office > i realise that schemas are going to have to be built and teh asksam database > exported .. this isn't a problem or an issue. what i need to know is wether or > not thier is a sql (assuming sql is up to the task) based methodology to > handle purely text based information and or wether or not it is possible to > get text information fields to be searcable ? What kind of database is asksam? It is flat file database? You seem to imply that it is some kind of free-form text database. A SQL RDMS might be poorly suited to a free-form test system. Oracle has a cool ConText package that provides nice free-form text indexing and searching, but it is very costly and kinda of useless if you aren't going to be using the rest of Oracle too. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message