[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1731
  • Last Modified:

Math equations in database

Hi Experts
I want to develop a database where I want to store math equations or some pictures with text. How and in which datatype I can store.
I want to use MS equation Editor for equations
0
Luhana
Asked:
Luhana
  • 5
  • 4
  • 2
  • +3
4 Solutions
 
Patrick MatthewsCommented:
Hello Luhana,

You can do this, but the consensus opinion among Experts here is that it is bad practice, as
it bloats your db and leads to file corruption.

The best practice is to store your image etc files outside the db, and to store the path to the
files instead.

Regards,

Patrick
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I will disagree about bad practice of storing images - unless it's maybe 10's of thousands .... this product basically eliminates bloat:

http://www.ammara.com/  DBPix ...

I can totally vouch for this program.  

It does all the work for you. Examples show how to add a simple 'control' panel to Load, Save, Zoom In/Out, Size To Fit and much more.  AND ... virtually eliminates BLOAT associated with storing images in an Access MDB.

Note. I have no connection with DBPix ... except I have used it many times ...

mx
0
 
LuhanaAuthor Commented:
Well here is proper proble details
I want to make a MCQ system where choices may contain few pictures or math equations.  for space I have 600 MB (CD) to store database. But I m new to this kind of database system :(

regards
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
Patrick MatthewsCommented:
MX,

I shall have to take a look at that sometime.  For myself, I have never seen a happy ending
when people try to store such files in Access.

:)

Regards,

Patrick
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yes you and the others *should* look at it ... because it *works* - seriously. It's a beautiful magic thing :-)

I have 3 clients all of which have commercial Access runtime products that use DBPix - all with a very happy ending.  

You can download for free and try ... just a nag screen.

mx
0
 
PaulHewsCommented:
I would normally recommend to save binary objects to file, saving the path or filename in the database.  There isn't much advantage to storing them in the database except in the case where data binding requires it.  The disadvantages are that it is more work for your program to retrieve the data from a database than from a disk file, and your database fills much faster when you start adding binary data.  

The database is great for searching and indexing and retrieving information quickly... but you can neither search nor index memo or OLE fields, so those advantages do not exist.

If you do require it, here are some code samples from MS showing how to get binary data into and out of the database.

How To Read and Write BLOBs Using GetChunk and AppendChunk
http://support.microsoft.com/kb/q194975/
0
 
Gustav BrockCIOCommented:
We use a compromise. Data is stored in one mdb and pictures in another. This allows for easy backup and restore and - if requested - a simple routine to dump the stored pictures as discrete files.

After much research we decided for the csXImage ActiveX control which is not expensive, has a bunch of features, and carries excellent support:
http://www.chestysoft.com/ximage/default.asp

It stores the images as blobs. A black/white scanned page takes about 15K saved in compressed TIFF format, which means about 100.000 pictures can be stored in one mdb.

/gustav
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
It would be interesting to compare Chestsoft with DBPix - which is somewhat less expensive. I've found DBPix *very* easy to use ... and being able to have a 'control' panel with useful functions on a form - which require just a couple lines of code ... is very cool.  Also, if you set it up right ... you have full intellisense.

mx
0
 
Gustav BrockCIOCommented:
Right. I guess it depends on the application and the functions you request.

CsXImage, for example, has full support for scanners and can convert to numerous formats including pdf which lets you build a complete electronic document store around this control.

Intellisense is at hand for most controls if you use early binding - highly recommended.

Note the difference between a license for a single install and a developer license with free and unlimited distribution rights for the finished application.

/gustav
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
It would be most interesting to compare mainly ... the storage efficiency.  Seems to me they would have to be more or less the same?

mx
0
 
PaulHewsCommented:
A BLOB is a BLOB is a BLOB.... Why do you need these components anyway?
0
 
Gustav BrockCIOCommented:
Yes, when you turn to storing blobs, you are in control (within the capabilities of the picture control, of course) and you can easily find out by storing your prepared pictures as separate files; if the picture file takes, say, 127K the blob will be of equal size and add that byte count to your database file when stored in this.

There is a lower limit for certain purposes. I've found that an A4 page of text scanned at 150 dpi in black/white can be compressed in TIFF to about 15K where it looks pretty much as a faxed page (normally at 200 dpi). Below 150 dpi it becomes unreadable. If you need presentation quality in 24 bit colour the size will, of course, be much higher.

/gustav
0
 
Gustav BrockCIOCommented:
> Why do you need these components anyway?

To prepare and/or convert the picture. In one case I used it for reading any common file format, converting and compressing it to TIFF before storing.
When stored, it can be read and saved directly as a pdf file - extremely convenient when handling scanned documents.

/gustav
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"Why do you need these components anyway?"

Because for $100 ... they have done ALL the work for you ... why re-invent the wheel!

Even if your hourly consulting rate is only $125/hour ... do the math!

mx
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now