XML/PDF/Images/Pictures/Audio/Video files
A user asked whether Informix 11.5 can store XML, PDF, images, audio and video, and how/where to store and retrieve them. Answers: yes, using large object types — "dumb" TEXT/BYTE objects held in the table or in a blobspace (onspaces -b), or "smart" CLOB/BLOB objects in a smart blobspace (onspaces -S). Smart LOBs allow partial reads/updates and are always logged (so replicate to MACH11 secondaries); blobspace blobs aren't logged but perform better than tablespace blobs. No DataBlade is needed unless extra features (e.g. text search, Timeseries) are wanted; for syntax and examples the poster was pointed to the manuals and the "samples" directory.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi All, I am looking for some information on whether or not it is possible to store any or all of the subjected files in Informix Database 11.5. If it is possible, would you please provide little detail information on each of these? Information like; a) where to store? i.e. the space for each type of file. b) how to store? i.e. Create table, column type and Insert statement information. c) how to fetch data? i.e. how to select the stored information from database for each of these files. d) Any other information that you might think would be helpful for me to understand the said concept better.. Please let me know if I you need more information from me on this. Thanks in advance.. Regards, Dharmendra
Quoting DHARMENDRA SHARMA <dharmendrasharma@hotmail.com>:
> I am looking for some information on whether or not it is possible to store
> any or all of the subjected files in Informix Database 11.5.
> Is it is possible, would you please provide little detail information on each
> of these? Information like;
Yes, we have a document store in an Informix RDBMS.
> a) where to store? i.e. the space for each type of file.
? In a BLOB space.
> b) how to store? i.e. Create table, column type and Insert statement
> information.
As BLOB values.
> c) how to fetch data? i.e. how to select the stored information from database
> for each of these files.
SELECT statements.
> d) Any other information that you might think would be helpful for me to
> understand the said concept better..
I don't think storing BLOBs in a DB has been anything out of the
ordinary for years.
Yes to all, see details below.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Fri, Nov 5, 2010 at 3:20 PM, DHARMENDRA SHARMA <
dharmendrasharma@hotmail.com> wrote:
> Hi All,
>
> I am looking for some information on whether or not it is possible to store
> any or all of the subjected files in Informix Database 11.5.
>
> If it is possible, would you please provide little detail information on
> each
> of these? Information like;
>
> a) where to store? i.e. the space for each type of file.
>
These documents can all be stored in one of Informix's Large Object types.
There are four:
- Dumb Large Objects - These are created either within table space or in
separate "Blobspaces" created with the onspaces utility using the -b flag.
- TEXT - a "dumb" large object suitable for printable text files such as
XML or PDF documents.
- DATA - a "dumb" large object suitable for non-printable or binary
files such as the Images, Pictures, Audio, and Video files you mention.
- Smart Large Objects - These are created in SmartBlobSpaces created
with the onspaces utility using the -S flag
- CLOB - a "smart" large object suitable for printable text files such
as XML or PDF documents.
- BLOB - a "smart" large object suitable for non-printable or binary
files such as the Images, Pictures, Audio, and Video files you mention.
The main difference between Dumb and Smart large objects is that you can
easily retrieve and update partial data from a Smart Large Object but not
from a Dumb Large Object. Other differences: Smart Large Objects are always
logged and so can be replicated on MACH11 secondary servers. Dumb Large
Objects can only be logged if they are stored "IN TABLE" (also known as
Tablespace Blobs) not in a Blobspace. DLOs stored in Blobspaces (known as
Blobspace Blobs) are not logged. However, Blobspace Blobs perform better
than Tablespace Blobs.
>
> b) how to store? i.e. Create table, column type and Insert statement
> information.
>
RTFineManual and look at the example programs in the the "samples"
subdirectory.
>
> c) how to fetch data? i.e. how to select the stored information from
> database
> for each of these files.
>
RTFineManual and look at the example programs in the the "samples"
subdirectory.
>
> d) Any other information that you might think would be helpful for me to
> understand the said concept better..
>
RTFineManual and look at the example programs in the the "samples"
subdirectory.
>
> Please let me know if I you need more information from me on this.
>
> Thanks in advance..
>
> Regards,
>
> Dharmendra
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016361e7c680ea307049453b8fd
Thanks!
Regards,
Dharmendra
> To: ids@iiug.org
> From: adam@morrison-ind.com
> Subject: Re: XML/PDF/Images/Pictures/Audio/Video files [21885]
> Date: Fri, 5 Nov 2010 15:25:44 -0400
>
> Quoting DHARMENDRA SHARMA <dharmendrasharma@hotmail.com>:
> > I am looking for some information on whether or not it is possible to store
> > any or all of the subjected files in Informix Database 11.5.
> > Is it is possible, would you please provide little detail information on
> each
> > of these? Information like;
>
> Yes, we have a document store in an Informix RDBMS.
>
> > a) where to store? i.e. the space for each type of file.
>
> ? In a BLOB space.
>
> > b) how to store? i.e. Create table, column type and Insert statement
> > information.
>
> As BLOB values.
>
> > c) how to fetch data? i.e. how to select the stored information from
> database
> > for each of these files.
>
> SELECT statements.>
> > d) Any other information that you might think would be helpful for me to
> > understand the said concept better..
>
> I don't think storing BLOBs in a DB has been anything out of the
> ordinary for years.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Thanks a lot Art for explaining this in detail.
One additional question related to this is, in order to use Smart large
object, do I need to have a DataBlade too?
or it can be used without DataBlade products..
Regards,
Dharmendra
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: XML/PDF/Images/Pictures/Audio/Video files [21886]
> Date: Fri, 5 Nov 2010 16:00:03 -0400
>
> Yes to all, see details below.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Fri, Nov 5, 2010 at 3:20 PM, DHARMENDRA SHARMA <
> dharmendrasharma@hotmail.com> wrote:
>
> > Hi All,
> >
> > I am looking for some information on whether or not it is possible to store
> > any or all of the subjected files in Informix Database 11.5.
> >
> > If it is possible, would you please provide little detail information on
> > each
> > of these? Information like;
> >
> > a) where to store? i.e. the space for each type of file.
> >
>
> These documents can all be stored in one of Informix's Large Object types.
> There are four:
>
> - Dumb Large Objects - These are created either within table space or in
>
> separate "Blobspaces" created with the onspaces utility using the -b flag.
>
> - TEXT - a "dumb" large object suitable for printable text files such as
>
> XML or PDF documents.
>
> - DATA - a "dumb" large object suitable for non-printable or binary
>
> files such as the Images, Pictures, Audio, and Video files you mention.
>
> - Smart Large Objects - These are created in SmartBlobSpaces created
>
> with the onspaces utility using the -S flag
>
> - CLOB - a "smart" large object suitable for printable text files such
>
> as XML or PDF documents.
>
> - BLOB - a "smart" large object suitable for non-printable or binary
>
> files such as the Images, Pictures, Audio, and Video files you mention.
>
> The main difference between Dumb and Smart large objects is that you can
> easily retrieve and update partial data from a Smart Large Object but not
> from a Dumb Large Object. Other differences: Smart Large Objects are always
> logged and so can be replicated on MACH11 secondary servers. Dumb Large
> Objects can only be logged if they are stored "IN TABLE" (also known as
> Tablespace Blobs) not in a Blobspace. DLOs stored in Blobspaces (known as
> Blobspace Blobs) are not logged. However, Blobspace Blobs perform better
> than Tablespace Blobs.
>
> >
> > b) how to store? i.e. Create table, column type and Insert statement
> > information.
> >
>
> RTFineManual and look at the example programs in the the "samples"
> subdirectory.
>
> >
> > c) how to fetch data? i.e. how to select the stored information from
> > database
> > for each of these files.
> >
>
> RTFineManual and look at the example programs in the the "samples"
> subdirectory.
>
> >
> > d) Any other information that you might think would be helpful for me to
> > understand the said concept better..
> >
>
> RTFineManual and look at the example programs in the the "samples"
> subdirectory.
>
> >
> > Please let me know if I you need more information from me on this.
> >
> > Thanks in advance..
> >
> > Regards,
> >
> > Dharmendra
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --0016361e7c680ea307049453b8fd
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
No, no datablades unless you need some of the functionality that a datablade
will give you like the Basic Text Search or Excalibur Text Datablades for
advanced text blob searching or the Timeseries Datablade to process time
related streaming data quickly.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Sat, Nov 6, 2010 at 11:28 AM, Dharmendra Sharma <
dharmendrasharma@hotmail.com> wrote:
> Thanks a lot Art for explaining this in detail.
>
> One additional question related to this is, in order to use Smart large
> object, do I need to have a DataBlade too?
> or it can be used without DataBlade products..
>
> Regards,
>
> Dharmendra
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: XML/PDF/Images/Pictures/Audio/Video files [21886]
> > Date: Fri, 5 Nov 2010 16:00:03 -0400
> >
> > Yes to all, see details below.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > IIUG Board of Directors (art@iiug.org)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> > do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other
> > organization with which I am associated either explicitly, implicitly, or
> by
> > inference. Neither do those opinions reflect those of other individuals
> > affiliated with any entity with which I am affiliated nor those of the
> > entities themselves.
> >
> > On Fri, Nov 5, 2010 at 3:20 PM, DHARMENDRA SHARMA <
> > dharmendrasharma@hotmail.com> wrote:
> >
> > > Hi All,
> > >
> > > I am looking for some information on whether or not it is possible to
> store
> > > any or all of the subjected files in Informix Database 11.5.
> > >
> > > If it is possible, would you please provide little detail information
> on
> > > each
> > > of these? Information like;
> > >
> > > a) where to store? i.e. the space for each type of file.
> > >
> >
> > These documents can all be stored in one of Informix's Large Object
> types.
> > There are four:
> >
> > - Dumb Large Objects - These are created either within table space or in
> >
> > separate "Blobspaces" created with the onspaces utility using the -b
> flag.
> >
> > - TEXT - a "dumb" large object suitable for printable text files such as
> >
> > XML or PDF documents.
> >
> > - DATA - a "dumb" large object suitable for non-printable or binary
> >
> > files such as the Images, Pictures, Audio, and Video files you mention.
> >
> > - Smart Large Objects - These are created in SmartBlobSpaces created
> >
> > with the onspaces utility using the -S flag
> >
> > - CLOB - a "smart" large object suitable for printable text files such
> >
> > as XML or PDF documents.
> >
> > - BLOB - a "smart" large object suitable for non-printable or binary
> >
> > files such as the Images, Pictures, Audio, and Video files you mention.
> >
> > The main difference between Dumb and Smart large objects is that you can
> > easily retrieve and update partial data from a Smart Large Object but not
> > from a Dumb Large Object. Other differences: Smart Large Objects are
> always
> > logged and so can be replicated on MACH11 secondary servers. Dumb Large
> > Objects can only be logged if they are stored "IN TABLE" (also known as
> > Tablespace Blobs) not in a Blobspace. DLOs stored in Blobspaces (known as
> > Blobspace Blobs) are not logged. However, Blobspace Blobs perform better
> > than Tablespace Blobs.
> >
> > >
> > > b) how to store? i.e. Create table, column type and Insert statement
> > > information.
> > >
> >
> > RTFineManual and look at the example programs in the the "samples"
> > subdirectory.
> >
> > >
> > > c) how to fetch data? i.e. how to select the stored information from
> > > database
> > > for each of these files.
> > >
> >
> > RTFineManual and look at the example programs in the the "samples"
> > subdirectory.
> >
> > >
> > > d) Any other information that you might think would be helpful for me
> to
> > > understand the said concept better..
> > >
> >
> > RTFineManual and look at the example programs in the the "samples"
> > subdirectory.
> >
> > >
> > > Please let me know if I you need more information from me on this.
> > >
> > > Thanks in advance..
> > >
> > > Regards,
> > >
> > > Dharmendra
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --0016361e7c680ea307049453b8fd
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016363b7a92e1dd3504946bf70d
Great!! Thanks a lot again for this important information..
Regards,
Dharmendra
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: XML/PDF/Images/Pictures/Audio/Video files [21889]
> Date: Sat, 6 Nov 2010 20:55:55 -0400
>
> No, no datablades unless you need some of the functionality that a datablade
> will give you like the Basic Text Search or Excalibur Text Datablades for
> advanced text blob searching or the Timeseries Datablade to process time
> related streaming data quickly.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Sat, Nov 6, 2010 at 11:28 AM, Dharmendra Sharma <
> dharmendrasharma@hotmail.com> wrote:
>
> > Thanks a lot Art for explaining this in detail.
> >
> > One additional question related to this is, in order to use Smart large
> > object, do I need to have a DataBlade too?
> > or it can be used without DataBlade products..
> >
> > Regards,
> >
> > Dharmendra
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: XML/PDF/Images/Pictures/Audio/Video files [21886]
> > > Date: Fri, 5 Nov 2010 16:00:03 -0400
> > >
> > > Yes to all, see details below.
> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Advanced DataTools (www.advancedatatools.com)
> > > IIUG Board of Directors (art@iiug.org)
> > > Blog: http://informix-myview.blogspot.com/
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and
> > > do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> > other
> > > organization with which I am associated either explicitly, implicitly, or
> > by
> > > inference. Neither do those opinions reflect those of other individuals
> > > affiliated with any entity with which I am affiliated nor those of the
> > > entities themselves.
> > >
> > > On Fri, Nov 5, 2010 at 3:20 PM, DHARMENDRA SHARMA <
> > > dharmendrasharma@hotmail.com> wrote:
> > >
> > > > Hi All,
> > > >
> > > > I am looking for some information on whether or not it is possible to
> > store
> > > > any or all of the subjected files in Informix Database 11.5.
> > > >
> > > > If it is possible, would you please provide little detail information
> > on
> > > > each
> > > > of these? Information like;
> > > >
> > > > a) where to store? i.e. the space for each type of file.
> > > >
> > >
> > > These documents can all be stored in one of Informix's Large Object
> > types.
> > > There are four:
> > >
> > > - Dumb Large Objects - These are created either within table space or in
> > >
> > > separate "Blobspaces" created with the onspaces utility using the -b
> > flag.
> > >
> > > - TEXT - a "dumb" large object suitable for printable text files such as
> > >
> > > XML or PDF documents.
> > >
> > > - DATA - a "dumb" large object suitable for non-printable or binary
> > >
> > > files such as the Images, Pictures, Audio, and Video files you mention.
> > >
> > > - Smart Large Objects - These are created in SmartBlobSpaces created
> > >
> > > with the onspaces utility using the -S flag
> > >
> > > - CLOB - a "smart" large object suitable for printable text files such
> > >
> > > as XML or PDF documents.
> > >
> > > - BLOB - a "smart" large object suitable for non-printable or binary
> > >
> > > files such as the Images, Pictures, Audio, and Video files you mention.
> > >
> > > The main difference between Dumb and Smart large objects is that you can
> > > easily retrieve and update partial data from a Smart Large Object but not
> > > from a Dumb Large Object. Other differences: Smart Large Objects are
> > always
> > > logged and so can be replicated on MACH11 secondary servers. Dumb Large
> > > Objects can only be logged if they are stored "IN TABLE" (also known as
> > > Tablespace Blobs) not in a Blobspace. DLOs stored in Blobspaces (known as
> > > Blobspace Blobs) are not logged. However, Blobspace Blobs perform better
> > > than Tablespace Blobs.
> > >
> > > >
> > > > b) how to store? i.e. Create table, column type and Insert statement
> > > > information.
> > > >
> > >
> > > RTFineManual and look at the example programs in the the "samples"
> > > subdirectory.
> > >
> > > >
> > > > c) how to fetch data? i.e. how to select the stored information from
> > > > database
> > > > for each of these files.
> > > >
> > >
> > > RTFineManual and look at the example programs in the the "samples"
> > > subdirectory.
> > >
> > > >
> > > > d) Any other information that you might think would be helpful for me
> > to
> > > > understand the said concept better..
> > > >
> > >
> > > RTFineManual and look at the example programs in the the "samples"
> > > subdirectory.
> > >
> > > >
> > > > Please let me know if I you need more information from me on this.
> > > >
> > > > Thanks in advance..
> > > >
> > > > Regards,
> > > >
> > > > Dharmendra
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --0016361e7c680ea307049453b8fd
> > >
> > >
> > >
> >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --0016363b7a92e1dd3504946bf70d
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>