First of all, thanks Christi and James for replying to my email. I am trying to test the performance of a specific data organization, which works well so far, but my query language is pretty simplistic right now. Since I do not want to create a full SQL parser, it would be great if I could benefit from an existing database's functionality in queries, and share some of it.
Unfortunately, since manipulating binary data is much faster and more compact than using ASCII data, I am "forced" to work with binary data. Thank you, Antonios Deligiannakis On Mon, 12 Nov 2001, Fortier, Christi (USPC.PCT.Hopewell) wrote: > Antonios, > Curiosity: > - Are you are building your own database, compiler & search tool at a > granular level within a model (database)? So, if you are working at that > layer, and not employing the benefits of a database,why use a database? > > If you are truly mixing these layers, then you will want to explore terms > like data mining & business intelligence. DB2 has Intelligent Miner for > text where you can run all kinds of analytics on text. > > If you want to build subordinate data models in your existing model, explore > DB2 on AS400, where you could use encoded vectore indices: > http://www.as400.ibm.com/developer/bi/evi.html. > > You could also use DB2 binary and build your functions off of that, but DB2 > is very limited here. Sybase or MS SQL allow you to explore bitmaps and > binary math better. > -----Original Message----- > From: James Campbell [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 12, 2001 3:16 AM > To: [EMAIL PROTECTED] > Subject: DB2EUG: Re: Calling user code from DB2 > > > I really think that DB2 does not provide the functionality you are > looking for. > > I suggest you get the source for MySQL (it is open source) and > hack that to your heart's content. > > James Campbell > > > > --------------- MESSAGE db2eug.v002.n204.1 --------------- > > > > From: Antonios Deligiannakis <[EMAIL PROTECTED]> > > Subject: Calling user code from DB2 > > Date: Sat, 10 Nov 2001 21:41:12 -0500 (EST) > > MIME-Version: 1.0 > > Content-Type: TEXT/PLAIN; charset=US-ASCII > > > > Hi, > > I am using the DB2 Universal Database Version 7.2 for Linux. I > > want to build a simplified database, where I will store the information > > for each table in a file, and the tuples of each table in a binary format > > in that file. I will thus NOT use any tables from DB2 to store the > > information. I will have the information stored in a format that I want. > > > > My question is the following: can I add SQL-like commands to > > DB2, so that my user-defined functions for creation of tables and queries > > are used? I would like to have some of the functionality provided by DB2 > > to be maintained: for example, I want to provide a search function > > (possibly by using an iterator), but I do not want to replicate the > > functionality of all the commands (like the ORDER-BY clause) that exist in > > DB2. This is something that in Informix could be done by using > > data-blades. Is there something equivalent in DB2? For example, is there > > an extender (or anything else) that might help me with my problem? > > > > I would appreciate any help on this (links to pages, name of commands to > > look for...). > > > > Thank you in advance, > > Antonios Deligiannakis > > > > James A Campbell > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod > > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod > > ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
