SQLServer Tutorial

3 MDX The MDX syntax defines multidimensional objects and queries and manipulates multidimensional data in OLAP databases. OLE DB & ODBC API's Client applications use OLE DB and Open Database Connectivity (ODBC), application programming interfaces (APIs) to send commands to a database. Commands that you send through these APIs use the Transact-SQL language. ActiveX Data Objects (ADO) / ADO Multidimensional Microsoft ActiveX® Data Objects (ADO) and ActiveX Data Objects (Multidimensional) (ADO MD) wrap OLE DB for use in languages such Microsoft Visual Basic®, Visual Basic for Applications, Active Server Pages, and Microsoft Internet Explorer Visual Basic Scripting. You use ADO to access data in OLTP databases. You use ADO MD to access data in Analysis Services data cubes. English Query This application provides an Automation API that lets users resolve natural-language questions instead of writing complex Transact-SQL or MDX statements about information in a database. For example, users are able to ask the question, "What are the total sales for Region 5?"