468,457 Members | 1,763 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,457 developers. It's quick & easy.

math notation in db?

I'm not a professional dba or dbd, but I'm proficient in the basics of
database design and sql. I want to create a database of math
definitions, and I'm wondering how one would go about creating a
database that contains mathematical notation (and I'm not just talking
about basic symbols where I could get away with ascii code). I need
to be able to insert a wide variety of mathematical expressions, from
fractions to integrals, into fields (just like you can enter in-line
math symbols in MS Word using equation editor). I have no clue how to
go about this. Is it a matter of developing certain programming
skills/languages? Would such a capabliltiy be proprietary (dbms-
specific)? Is it possible at all? Any help would be appreciated.
Thank you.
Dec 1 '07 #1
3 2945
One way to implement this is to use the Mathematical Markup Language
(MathML). MathML is based on XML and is used for describing mathematical
notation and encoding both its structure and content. The main purpose of
MathML is to enable mathematics to be used on Internet, but since it is XML
based it is widely used in applications that can process XML.

SQL Server supports Unicode and also SQL Server 2005 adds support for XML
data type. There are many parsers, and any browser can serve as presentation
layer.

See more info on the official W3C site at the links below:
http://www.w3.org/Math/whatIsMathML.html
http://www.w3.org/Math/
http://www.w3.org/TR/2007/WD-MathML3-20070427/
http://www.w3.org/Math/XSL/
http://www.w3.org/Math/XSL/pmathml2.xml
http://www.w3.org/Math/XSL/csmall2.xml

I have seen some applications that use MathML to store mathematical
notations, but developed in Oracle (still storing in XML columns).

HTH,

Plamen Ratchev
http://www.SQLStudio.com
Dec 1 '07 #2
>MathML is based on XML <<

How is this standard doing? I think I might be behind the curve,
since I have not done any math writing in a very long time. LaTEX was
the standard in the US for the American Mathematical Association
papers and other journals. It was also popular with textbook
publishers because you could get Knuth's Metafont symbols for
typesetting.
Dec 1 '07 #3
On Nov 30, 5:43 pm, "Plamen Ratchev" <Pla...@SQLStudio.comwrote:
One way to implement this is to use the Mathematical Markup Language
(MathML). MathML is based on XML and is used for describing mathematical
notation and encoding both its structure and content. The main purpose of
MathML is to enable mathematics to be used on Internet, but since it is XML
based it is widely used in applications that can process XML.

SQL Server supports Unicode and also SQL Server 2005 adds support for XML
data type. There are many parsers, and any browser can serve as presentation
layer.

See more info on the official W3C site at the links below:http://www.w3.org/Math/whatIsMathML....SL/csmall2.xml

I have seen some applications that use MathML to store mathematical
notations, but developed in Oracle (still storing in XML columns).

HTH,

Plamen Ratchevhttp://www.SQLStudio.com
Very helpful post. Thank you.
Dec 1 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by xeys_00 | last post: by
17 posts views Thread by cwdjrxyz | last post: by
3 posts views Thread by Dave | last post: by
12 posts views Thread by Janiek Buysrogge | last post: by
8 posts views Thread by brad | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by subhajit12345 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.