473,732 Members | 2,217 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3217
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...@SQLStud io.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.c om
Very helpful post. Thank you.
Dec 1 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
2203
by: xeys_00 | last post by:
I decided I need to understand math more to help me with programming. Not to mention, eventually in my degree plan I will need to do it anyway. How much math have people in this forum taken, and how much has it helped thier programming? Xeys
17
3625
by: cwdjrxyz | last post by:
Javascript has a very small math function list. However there is no reason that this list can not be extended greatly. Speed is not an issue, unless you nest complicated calculations several levels deep. In that case you need much more ram than a PC has to store functions calculated in loops so that you do not have to recalculate every time you cycle through the nest of loops. Using a HD for storage to extend ram is much too slow for many...
2
2104
by: ben | last post by:
hello, i'm following an algorithm book and am stuck on an early excersise in it, not because of the c programming side of it or even the algorithm side of it, i don't think, but because of maths. i don't really understand what is expected, or really what the question means. could anyone explain what the question's after please? any help much appreciated. thanks, ben. Prove an upper bound on the number of machine instructions required to
3
3758
by: Dave | last post by:
I'm making a physics that uses very small numbers such as 9.88E-19. that is, 9.88 times 10 to the power of -19. I've run into a few problems doing calculations with numbers like these. the first one is that I can't figure out how to write scientific notation which is that E that I used in the first sentence. it means to multiply by ten to some power. I know the math.E exists but I don't know how to use it. Maybe after I figure that...
12
12407
by: Janiek Buysrogge | last post by:
Hello, Does anyone know if there is a library or a sample project that can parse strings with mathematical expressions inside ? eg. string math = "(23 + 48) ^ 2 - (7.76 * 3.14)"; parser should calculate the result of this. Atm I have my own parser, but it can only handle very simple expressions with 2 operands eg. (34 * 89), I tried to expand the
6
5571
by: PIEBALD | last post by:
Anyone got an infix to postfix (RPN) math notation converter? I've looked around a bit and haven't found anything quite what I want. I just want a method that will take a string in infix notation and return a string in Reverse Polish Notation.
8
2335
by: brad | last post by:
How does one make the math module spit out actual values without using engineer or scientific notation? I get this from <code>print math.pow(2,64)</code>: 1.84467440737e+19 I want this: 18,446,744,073,709,551,616 I'm lazy... I don't want to convert it manually :)
2
2042
by: astrogirl77 | last post by:
Hi, I'm new to Python and am hoping to find help with coding a Python script, applet. I code in an old version of Visual Basic 4.0, I have a simple app that is about 3 and a half pages of code long it does some relatively simple math additions and subtractions The problem I have is that some numbers get to be very large integers and VB automatically converts this to scientifc notation, what I need is to have all numbers added and...
1
2073
by: astrogirl77 | last post by:
I'm new to C++ and am hoping to find help with coding a simple C program, am wanting to obtain code and functioning exe's. I code in an old version of Visual Basic 4.0, I have a simple app that is about 3 and a half pages of code long it does some relatively simple math additions and subtractions The problem I have is that some numbers get to be very large integers and VB automatically converts this to scientifc notation, what I need is...
0
8946
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9447
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9307
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8186
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4809
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3261
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2721
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2180
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.