RE: db engines VS flat files
Can you joke somewhere else please? Alex Hillman -Original Message- Sent: Monday, September 10, 2001 3:55 PM To: Multiple recipients of list ORACLE-L jey man take it easy... just a joke.. nothing serious... On Mon, 10 Sep 2001, Christopher Spence wrote: > Date: Mon, 10 Sep 2001 11:40:41 -0800 > From: Christopher Spence <[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: db engines VS flat files > > Biting your tongue is no fun, I just say what I think. > Which happens to be a whole lot of nothing. > > "Do not criticize someone until you walked a mile in their shoes, that way > when you criticize them, you are a mile a way and have their shoes." > > Christopher R. Spence > Oracle DBA > Phone: (978) 322-5744 > Fax:(707) 885-2275 > > Fuelspot > 73 Princeton Street > North, Chelmsford 01863 > > > > > -Original Message- > Sent: Monday, September 10, 2001 3:00 PM > To: Multiple recipients of list ORACLE-L > > > > Since we're not in a meeting, I don't have to bite my tongue. > > 'Context sensitive indexing' comes to mind. > > Jared > > > > > > agc > > ORACLE-L <[EMAIL PROTECTED]> > org.co> cc: > > Sent by: Subject: Re: db engines VS flat > files > [EMAIL PROTECTED] > > om > > > > > > 09/10/01 09:10 > > AM > > Please respond > > to ORACLE-L > > > > > > > > > > well so start to bite your tonge :-) because yes there are some very large > collections of datas stored as flat text files, so do bite it and do it very > hard because this large amounts of datas may almost doble the size every > year... and most of them are being searched and manipulated with perl > scripts. I do not know if has been that way because of not knowign search > engines, do not think that is the case, that I do not know but my question > remains. ok, for only seraching patterns with in this falt files wich > would be the difference between having a real search engine and just having > perl scripts for searching patterns with in this flat text files? until now > all I can say is that most of administrative tasks are quite dificult to do > under perl and shell scripts, and c progrmas, but for the rest and even > knowing that all this works under cgis, it works fine well... so do not > laught so hard may loose your tonge :-) > > On Mon, 10 Sep 2001, Jared Still wrote: > > > Date: Mon, 10 Sep 2001 06:40:19 -0800 > > From: Jared Still <[EMAIL PROTECTED]> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: Re: db engines VS flat files > > > > > > In addition to Greg's comments I would like to add > > that anyone suggesting flat files for 50 gig of data > > is probably not at all familiar with database technology. > > > > Perl is an excellent language for manipulating data, but > > it is not a database engine. 50 gigs of data is totally unmanagable > > as flat files. > > > > Personally, were someone to suggest that to me I would have to bite my > > tongue to contain the laughter. > > > > At the very least, something like MySQL should be used. > > > > For a look at what is available in the way or database interfaces for > > Perl, have a look at: > > > > http://search.cpan.org/Catalog/Database_Interfaces/ > > > > Jared > > > > > > On Sunday 09 September 2001 12:40, agc wrote: > > > I would like to know your opinion about the developments under for > > > example perl for handling large amounts of datas (sets of flats > > > files larger than 50 gigs) vs the option of using oracle for exmaple > > > for > doing > > > the same task, wich would be more eficinet? why? cheers > > > > > > The information contained in this communication is confidential, is > > > intended only for the use of the recipient named above, and may be > > > legally privileged. If the reader of this message is not the > > > intended recipient, you are hereby notified that any dissemination, > > > distribution or copying of this communication is strictly > > > prohibited. If you have received this communication in error, please > > > re-send this commu
RE: db engines VS flat files
IRS used to use flat files on IBM mainframes circa 1992. Don't know if their "Modernization" effort ever succeeded. They were trying to move it to Oracle 7 running on NCR Pentium 60's. Don't ask why. There was a Congressional inquiry. One point that should be made. When you move data from flat files to an Oracle database you do not gain any space efficiency. In fact, depending on the indexing, you can take twice as much space. Oracle's advantage is that in Oracle the data is being managed. In a flat file there is no data integrity, no relational integrity, no auditing. All of these things are available in Oracle. Christopher Spence To: Multiple recipients of list ORACLE-L Spot.com>cc: Sent by: Subject: RE: db engines VS flat files root@fatcity. com 09/10/2001 12:00 PM Please respond to ORACLE-L Huh? Doesn't the irs use flat files? :) "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 10, 2001 10:40 AM To: Multiple recipients of list ORACLE-L In addition to Greg's comments I would like to add that anyone suggesting flat files for 50 gig of data is probably not at all familiar with database technology. Perl is an excellent language for manipulating data, but it is not a database engine. 50 gigs of data is totally unmanagable as flat files. Personally, were someone to suggest that to me I would have to bite my tongue to contain the laughter. At the very least, something like MySQL should be used. For a look at what is available in the way or database interfaces for Perl, have a look at: http://search.cpan.org/Catalog/Database_Interfaces/ Jared On Sunday 09 September 2001 12:40, agc wrote: > I would like to know your opinion about the developments under for > example perl for handling large amounts of datas (sets of flats files > larger than 50 gigs) vs the option of using oracle for exmaple for > doing the same task, wich would be more eficinet? why? cheers > > The information contained in this communication is confidential, is > intended only for the use of the recipient named above, and may be > legally privileged. If the reader of this message is not the intended > recipient, you are hereby notified that any dissemination, > distribution or copying of this communication is strictly prohibited. > If you have received this communication in error, please > re-send this communication to the sender and delete the > original message or any copy of it from your computer > system. > Please do not re-send by any reazon in any way or form any of the > informatino here contained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.ora
RE: db engines VS flat files
I know it was, but I was serious :) "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 10, 2001 3:55 PM To: Multiple recipients of list ORACLE-L jey man take it easy... just a joke.. nothing serious... On Mon, 10 Sep 2001, Christopher Spence wrote: > Date: Mon, 10 Sep 2001 11:40:41 -0800 > From: Christopher Spence <[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: db engines VS flat files > > Biting your tongue is no fun, I just say what I think. > Which happens to be a whole lot of nothing. > > "Do not criticize someone until you walked a mile in their shoes, that > way when you criticize them, you are a mile a way and have their > shoes." > > Christopher R. Spence > Oracle DBA > Phone: (978) 322-5744 > Fax:(707) 885-2275 > > Fuelspot > 73 Princeton Street > North, Chelmsford 01863 > > > > > -Original Message- > Sent: Monday, September 10, 2001 3:00 PM > To: Multiple recipients of list ORACLE-L > > > > Since we're not in a meeting, I don't have to bite my tongue. > > 'Context sensitive indexing' comes to mind. > > Jared > > > > > > agc > > ORACLE-L <[EMAIL PROTECTED]> > org.co> cc: > > Sent by: Subject: Re: db engines VS flat > files > [EMAIL PROTECTED] > > om > > > > > > 09/10/01 09:10 > > AM > > Please respond > > to ORACLE-L > > > > > > > > > > well so start to bite your tonge :-) because yes there are some very > large collections of datas stored as flat text files, so do bite it > and do it very hard because this large amounts of datas may almost > doble the size every year... and most of them are being searched and > manipulated with perl scripts. I do not know if has been that way > because of not knowign search engines, do not think that is the case, > that I do not know but my question remains. ok, for only seraching > patterns with in this falt files wich would be the difference between > having a real search engine and just having perl scripts for searching > patterns with in this flat text files? until now all I can say is that > most of administrative tasks are quite dificult to do under perl and > shell scripts, and c progrmas, but for the rest and even knowing that > all this works under cgis, it works fine well... so do not laught so > hard may loose your tonge :-) > > On Mon, 10 Sep 2001, Jared Still wrote: > > > Date: Mon, 10 Sep 2001 06:40:19 -0800 > > From: Jared Still <[EMAIL PROTECTED]> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: Re: db engines VS flat files > > > > > > In addition to Greg's comments I would like to add > > that anyone suggesting flat files for 50 gig of data > > is probably not at all familiar with database technology. > > > > Perl is an excellent language for manipulating data, but > > it is not a database engine. 50 gigs of data is totally unmanagable > > as flat files. > > > > Personally, were someone to suggest that to me I would have to bite > > my > > tongue to contain the laughter. > > > > At the very least, something like MySQL should be used. > > > > For a look at what is available in the way or database interfaces > > for > > Perl, have a look at: > > > > http://search.cpan.org/Catalog/Database_Interfaces/ > > > > Jared > > > > > > On Sunday 09 September 2001 12:40, agc wrote: > > > I would like to know your opinion about the developments under for > > > example perl for handling large amounts of datas (sets of flats > > > files larger than 50 gigs) vs the option of using oracle for exmaple > > > for > doing > > > the same task, wich would be more eficinet? why? cheers > > > > > > The information contained in this communication is confidential, > > > is > > > intended only for the use of the recipient named above, and may be > > >
RE: db engines VS flat files
jey man take it easy... just a joke.. nothing serious... On Mon, 10 Sep 2001, Christopher Spence wrote: > Date: Mon, 10 Sep 2001 11:40:41 -0800 > From: Christopher Spence <[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: db engines VS flat files > > Biting your tongue is no fun, I just say what I think. > Which happens to be a whole lot of nothing. > > "Do not criticize someone until you walked a mile in their shoes, that way > when you criticize them, you are a mile a way and have their shoes." > > Christopher R. Spence > Oracle DBA > Phone: (978) 322-5744 > Fax:(707) 885-2275 > > Fuelspot > 73 Princeton Street > North, Chelmsford 01863 > > > > > -Original Message- > Sent: Monday, September 10, 2001 3:00 PM > To: Multiple recipients of list ORACLE-L > > > > Since we're not in a meeting, I don't have to bite my tongue. > > 'Context sensitive indexing' comes to mind. > > Jared > > > > > > agc > > ORACLE-L <[EMAIL PROTECTED]> > org.co> cc: > > Sent by: Subject: Re: db engines VS flat > files > [EMAIL PROTECTED] > > om > > > > > > 09/10/01 09:10 > > AM > > Please respond > > to ORACLE-L > > > > > > > > > > well so start to bite your tonge :-) because yes there are some very large > collections of datas stored as flat text files, so do bite it and do it very > hard because this large amounts of datas may almost doble the size every > year... and most of them are being searched and manipulated with perl > scripts. I do not know if has been that way because of not knowign search > engines, do not think that is the case, that I do not know but my question > remains. ok, for only seraching patterns with in this falt files wich > would be the difference between having a real search engine and just having > perl scripts for searching patterns with in this flat text files? until now > all I can say is that most of administrative tasks are quite dificult to do > under perl and shell scripts, and c progrmas, but for the rest and even > knowing that all this works under cgis, it works fine well... so do not > laught so hard may loose your tonge :-) > > On Mon, 10 Sep 2001, Jared Still wrote: > > > Date: Mon, 10 Sep 2001 06:40:19 -0800 > > From: Jared Still <[EMAIL PROTECTED]> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: Re: db engines VS flat files > > > > > > In addition to Greg's comments I would like to add > > that anyone suggesting flat files for 50 gig of data > > is probably not at all familiar with database technology. > > > > Perl is an excellent language for manipulating data, but > > it is not a database engine. 50 gigs of data is totally unmanagable > > as flat files. > > > > Personally, were someone to suggest that to me I would have to bite my > > tongue to contain the laughter. > > > > At the very least, something like MySQL should be used. > > > > For a look at what is available in the way or database interfaces for > > Perl, have a look at: > > > > http://search.cpan.org/Catalog/Database_Interfaces/ > > > > Jared > > > > > > On Sunday 09 September 2001 12:40, agc wrote: > > > I would like to know your opinion about the developments under for > > > example perl for handling large amounts of datas (sets of flats > > > files larger than 50 gigs) vs the option of using oracle for exmaple > > > for > doing > > > the same task, wich would be more eficinet? why? cheers > > > > > > The information contained in this communication is confidential, is > > > intended only for the use of the recipient named above, and may be > > > legally privileged. If the reader of this message is not the > > > intended recipient, you are hereby notified that any dissemination, > > > distribution or copying of this communication is strictly > > > prohibited. If you have received this communication in error, please > > > re-send this communication to the sender and delete the > > > original message or any copy of it from your computer > > > system. > > > Please do not re-s
RE: db engines VS flat files
Biting your tongue is no fun, I just say what I think. Which happens to be a whole lot of nothing. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 10, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Since we're not in a meeting, I don't have to bite my tongue. 'Context sensitive indexing' comes to mind. Jared agc org.co> cc: Sent by: Subject: Re: db engines VS flat files [EMAIL PROTECTED] om 09/10/01 09:10 AM Please respond to ORACLE-L well so start to bite your tonge :-) because yes there are some very large collections of datas stored as flat text files, so do bite it and do it very hard because this large amounts of datas may almost doble the size every year... and most of them are being searched and manipulated with perl scripts. I do not know if has been that way because of not knowign search engines, do not think that is the case, that I do not know but my question remains. ok, for only seraching patterns with in this falt files wich would be the difference between having a real search engine and just having perl scripts for searching patterns with in this flat text files? until now all I can say is that most of administrative tasks are quite dificult to do under perl and shell scripts, and c progrmas, but for the rest and even knowing that all this works under cgis, it works fine well... so do not laught so hard may loose your tonge :-) On Mon, 10 Sep 2001, Jared Still wrote: > Date: Mon, 10 Sep 2001 06:40:19 -0800 > From: Jared Still <[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: db engines VS flat files > > > In addition to Greg's comments I would like to add > that anyone suggesting flat files for 50 gig of data > is probably not at all familiar with database technology. > > Perl is an excellent language for manipulating data, but > it is not a database engine. 50 gigs of data is totally unmanagable > as flat files. > > Personally, were someone to suggest that to me I would have to bite my > tongue to contain the laughter. > > At the very least, something like MySQL should be used. > > For a look at what is available in the way or database interfaces for > Perl, have a look at: > > http://search.cpan.org/Catalog/Database_Interfaces/ > > Jared > > > On Sunday 09 September 2001 12:40, agc wrote: > > I would like to know your opinion about the developments under for > > example perl for handling large amounts of datas (sets of flats > > files larger than 50 gigs) vs the option of using oracle for exmaple > > for doing > > the same task, wich would be more eficinet? why? cheers > > > > The information contained in this communication is confidential, is > > intended only for the use of the recipient named above, and may be > > legally privileged. If the reader of this message is not the > > intended recipient, you are hereby notified that any dissemination, > > distribution or copying of this communication is strictly > > prohibited. If you have received this communication in error, please > > re-send this communication to the sender and delete the > > original message or any copy of it from your computer > > system. > > Please do not re-send by any reazon in any way or form any of the > > informatino here contained. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the re
Re: db engines VS flat files
Since we're not in a meeting, I don't have to bite my tongue. 'Context sensitive indexing' comes to mind. Jared agc org.co> cc: Sent by: Subject: Re: db engines VS flat files [EMAIL PROTECTED] om 09/10/01 09:10 AM Please respond to ORACLE-L well so start to bite your tonge :-) because yes there are some very large collections of datas stored as flat text files, so do bite it and do it very hard because this large amounts of datas may almost doble the size every year... and most of them are being searched and manipulated with perl scripts. I do not know if has been that way because of not knowign search engines, do not think that is the case, that I do not know but my question remains. ok, for only seraching patterns with in this falt files wich would be the difference between having a real search engine and just having perl scripts for searching patterns with in this flat text files? until now all I can say is that most of administrative tasks are quite dificult to do under perl and shell scripts, and c progrmas, but for the rest and even knowing that all this works under cgis, it works fine well... so do not laught so hard may loose your tonge :-) On Mon, 10 Sep 2001, Jared Still wrote: > Date: Mon, 10 Sep 2001 06:40:19 -0800 > From: Jared Still <[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: db engines VS flat files > > > In addition to Greg's comments I would like to add > that anyone suggesting flat files for 50 gig of data > is probably not at all familiar with database technology. > > Perl is an excellent language for manipulating data, but > it is not a database engine. 50 gigs of data is totally > unmanagable as flat files. > > Personally, were someone to suggest that to me I would have > to bite my tongue to contain the laughter. > > At the very least, something like MySQL should be used. > > For a look at what is available in the way or database > interfaces for Perl, have a look at: > > http://search.cpan.org/Catalog/Database_Interfaces/ > > Jared > > > On Sunday 09 September 2001 12:40, agc wrote: > > I would like to know your opinion about the developments under for > > example perl for handling large amounts of datas (sets of flats files > > larger than 50 gigs) vs the option of using oracle for exmaple for doing > > the same task, wich would be more eficinet? why? cheers > > > > The information contained in this communication is > > confidential, is intended only for the use of the recipient > > named above, and may be legally privileged. If the reader > > of this message is not the intended recipient, you are > > hereby notified that any dissemination, distribution or > > copying of this communication is strictly prohibited. > > If you have received this communication in error, please > > re-send this communication to the sender and delete the > > original message or any copy of it from your computer > > system. > > Please do not re-send by any reazon in any way or form any of the > > informatino here contained. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Netwo
RE: db engines VS flat files
Huh? Doesn't the irs use flat files? :) "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 10, 2001 10:40 AM To: Multiple recipients of list ORACLE-L In addition to Greg's comments I would like to add that anyone suggesting flat files for 50 gig of data is probably not at all familiar with database technology. Perl is an excellent language for manipulating data, but it is not a database engine. 50 gigs of data is totally unmanagable as flat files. Personally, were someone to suggest that to me I would have to bite my tongue to contain the laughter. At the very least, something like MySQL should be used. For a look at what is available in the way or database interfaces for Perl, have a look at: http://search.cpan.org/Catalog/Database_Interfaces/ Jared On Sunday 09 September 2001 12:40, agc wrote: > I would like to know your opinion about the developments under for > example perl for handling large amounts of datas (sets of flats files > larger than 50 gigs) vs the option of using oracle for exmaple for > doing the same task, wich would be more eficinet? why? cheers > > The information contained in this communication is confidential, is > intended only for the use of the recipient named above, and may be > legally privileged. If the reader of this message is not the intended > recipient, you are hereby notified that any dissemination, > distribution or copying of this communication is strictly prohibited. > If you have received this communication in error, please > re-send this communication to the sender and delete the > original message or any copy of it from your computer > system. > Please do not re-send by any reazon in any way or form any of the > informatino here contained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db engines VS flat files
I think it's one of those things that if you have to ask then... -Original Message- Sent: Sunday, September 09, 2001 12:40 PM To: Multiple recipients of list ORACLE-L I would like to know your opinion about the developments under for example perl for handling large amounts of datas (sets of flats files larger than 50 gigs) vs the option of using oracle for exmaple for doing the same task, wich would be more eficinet? why? cheers The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Please do not re-send by any reazon in any way or form any of the informatino here contained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: agc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: db engines VS flat files
well so start to bite your tonge :-) because yes there are some very large collections of datas stored as flat text files, so do bite it and do it very hard because this large amounts of datas may almost doble the size every year... and most of them are being searched and manipulated with perl scripts. I do not know if has been that way because of not knowign search engines, do not think that is the case, that I do not know but my question remains. ok, for only seraching patterns with in this falt files wich would be the difference between having a real search engine and just having perl scripts for searching patterns with in this flat text files? until now all I can say is that most of administrative tasks are quite dificult to do under perl and shell scripts, and c progrmas, but for the rest and even knowing that all this works under cgis, it works fine well... so do not laught so hard may loose your tonge :-) On Mon, 10 Sep 2001, Jared Still wrote: > Date: Mon, 10 Sep 2001 06:40:19 -0800 > From: Jared Still <[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: db engines VS flat files > > > In addition to Greg's comments I would like to add > that anyone suggesting flat files for 50 gig of data > is probably not at all familiar with database technology. > > Perl is an excellent language for manipulating data, but > it is not a database engine. 50 gigs of data is totally > unmanagable as flat files. > > Personally, were someone to suggest that to me I would have > to bite my tongue to contain the laughter. > > At the very least, something like MySQL should be used. > > For a look at what is available in the way or database > interfaces for Perl, have a look at: > > http://search.cpan.org/Catalog/Database_Interfaces/ > > Jared > > > On Sunday 09 September 2001 12:40, agc wrote: > > I would like to know your opinion about the developments under for > > example perl for handling large amounts of datas (sets of flats files > > larger than 50 gigs) vs the option of using oracle for exmaple for doing > > the same task, wich would be more eficinet? why? cheers > > > > The information contained in this communication is > > confidential, is intended only for the use of the recipient > > named above, and may be legally privileged. If the reader > > of this message is not the intended recipient, you are > > hereby notified that any dissemination, distribution or > > copying of this communication is strictly prohibited. > > If you have received this communication in error, please > > re-send this communication to the sender and delete the > > original message or any copy of it from your computer > > system. > > Please do not re-send by any reazon in any way or form any of the > > informatino here contained. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Please do not re-send by any reazon in any way or form any of the informatino here contained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: agc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: db engines VS flat files
In addition to Greg's comments I would like to add that anyone suggesting flat files for 50 gig of data is probably not at all familiar with database technology. Perl is an excellent language for manipulating data, but it is not a database engine. 50 gigs of data is totally unmanagable as flat files. Personally, were someone to suggest that to me I would have to bite my tongue to contain the laughter. At the very least, something like MySQL should be used. For a look at what is available in the way or database interfaces for Perl, have a look at: http://search.cpan.org/Catalog/Database_Interfaces/ Jared On Sunday 09 September 2001 12:40, agc wrote: > I would like to know your opinion about the developments under for > example perl for handling large amounts of datas (sets of flats files > larger than 50 gigs) vs the option of using oracle for exmaple for doing > the same task, wich would be more eficinet? why? cheers > > The information contained in this communication is > confidential, is intended only for the use of the recipient > named above, and may be legally privileged. If the reader > of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or > copying of this communication is strictly prohibited. > If you have received this communication in error, please > re-send this communication to the sender and delete the > original message or any copy of it from your computer > system. > Please do not re-send by any reazon in any way or form any of the > informatino here contained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db engines VS flat files
Highly depends. If your reading the data sequentially, then flat files will be faster, unless you have many multiple users. If your sorting, or doing complex things with the data, then Oracle will most likely be faster. Oracle will also allow security and integrity of the data. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Sunday, September 09, 2001 3:40 PM To: Multiple recipients of list ORACLE-L I would like to know your opinion about the developments under for example perl for handling large amounts of datas (sets of flats files larger than 50 gigs) vs the option of using oracle for exmaple for doing the same task, wich would be more eficinet? why? cheers The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Please do not re-send by any reazon in any way or form any of the informatino here contained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: agc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: db engines VS flat files
> perl for handling large amounts of data (sets of flats files People tend to push the kind of technology they are familiar with. I've seen SQL scripts that spooled out some data to a flat file, which was then processed by a series of UNIX shell scripts. By making a simple change to the SQL and adding a two SQL*Plus SET commands, I was able to produce the flat file in exactly the form desired, eliminating the need for a half dozen UNIX fairly complex shell scripts, awk, etc. I have no idea whether flat files and Perl, or Oracle, would be best for your system. But if the people proposing the flat file approach are all expert Perl coders who have very little experience with Oracle, their recommendations are suspect. They may just be proposing that solution because it's what they know best. They may be completely unaware of dozens or even hundreds of advantages you would miss if you don't use a relational database. It might be wise to bring in a top notch Oracle architect for a couple of weeks for a second opinion before making a decision to go back to the Stone Age and store huge amounts of data in flat files. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).