Results 1 to 3 of 3

Thread: RE: MDX Versus T-SQL

  1. Oct 10th, 2005, 05:33 PM #1
    kaihirst
    kaihirst is offline

    Thread Starter
    Fanatic Member kaihirst's Avatar
    Join Date
    Jul 2005
    Location
    The Resaurant At the End of The Universe
    Posts
    633

    RE: MDX Versus T-SQL

    Hi,

    Does or has anybody used Multi-dimensional Expressions in SQL server application model in 2003 or 2005 beta yet???

    AND, What is the general opinion o fthis langauge? I personally use it, but none of my other developers do, or any of my industry contacts nether. Is it that BAD? or is it just inaccessible forthe average "run of the mill" programmer??

    Sugestions or 10c/10p/10eur appreciated

    ta

    kai
    As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..

    A few things that make a good Developer a Great One.
    Methodical and a thorough approach to research and design inevitably leads to success.
    Forward thinking is the key to Flow of control.
    Never test in the design environment, always test in real time, you get the REAL results.
    CBSE & OOSE are the same animal, they just require different techniques, and thinking.
    SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
    The key to good design is explicit attention to both detail and response.
    Think Freely out of the "Box" you're in..... You will soar to better heights.

    Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT

    Reply With Quote Reply With Quote
  2. Oct 13th, 2005, 01:22 AM #2
    StrangerInBeijing
    StrangerInBeijing is offline
    Frenzied Member StrangerInBeijing's Avatar
    Join Date
    Mar 2005
    Location
    Not in Beijing
    Posts
    1,666

    Re: MDX Versus T-SQL

    Multidimensional Expressions (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases so you cannot compare the two.

    Data (let's stick to SQL Server now) are stored in 2 ways. Flat (rows & columns) or multi-dimensional (dimensions)

    Flat data you query using SQL. Multi-Dimensional Data with MDX.

    Flat data are ideal for OLTP, and are normalized.

    To make use of the power of OLAP, you break up your database into smaller databases, denormalize them, then create cube/s, dimensions, measures, etc in MS Analysis Server. You will use MDX to query this data.

    MDX were referred to as SQL on steriods, and in a way it is true. But don't let it intimidate you. OLAP is one hellova powerfull technology, not known well by many, so dig in and learn this beast..that's my 2 cents!

    Good Luck!

    ps. Forget getting any help on OLAP on this forums. I forgot the exact address, but the Microsoft OLAP / Analysis Server / MDX discussion board will be more helpfull.
    Install and Configure Eclipse For both Java and PHP development
    Accessible Ajax/jQuery Forms Degrade gracefully with JavaScript Disabled
    Reply With Quote Reply With Quote
  3. Oct 13th, 2005, 01:28 AM #3
    StrangerInBeijing
    StrangerInBeijing is offline
    Frenzied Member StrangerInBeijing's Avatar
    Join Date
    Mar 2005
    Location
    Not in Beijing
    Posts
    1,666

    Re: MDX Versus T-SQL

    Here is some MDX related links

    If you want to write applications that automate OLAP task, use DSO for administrative stuff (creating cube objects, etc), and ADOMD.Net for anything that work with data. Google it.

    I'm sure this is worth a rating? (pimping myself you see?)
    Install and Configure Eclipse For both Java and PHP development
    Accessible Ajax/jQuery Forms Degrade gracefully with JavaScript Disabled
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width