SQLServer Tutorial

4 Client-Server Architecture Client Components Client Application A client application ends Transact-SQL statements and receives result sets. You develop an application by using a database API. Database API Database API (OLE DB, ODBC) uses a provider, driver, or DLL to pass Transact-SQL statements and receive result sets. This is an interface that an application uses to send requests to SQL Server and to process results that SQL Server returns. Client Net-Library This is a communication software component that packages the database requests and results for transmission by the appropriate network protocol. Server Components

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?"

SQLServer Tutorial

2 Data Storage Models OLTP Databases Data in an OLTP database is generally organized into relational tables to reduce redundant information and to increase the speed of updates. OLAP Databases OLAP technology organizes and summarizes large amounts of data so that an analyst can evaluate data quickly and in real time. Client Applications Transact-SQL the primary database query and programming language that SQL Server uses. XML This format returns data from queries and stored procedures by using URLs or templates over Hypertext Transfer Protocol (HTTP). You also can use XML to insert, delete, and update values in a database.

SQLServer Tutorial

1 What Is SQL Server? You use SQL Server to manage two types of databases--online transaction processing (OLTP) databases, and online analytical processing (OLAP) databases. SQL Server is a relational database management system (RDBMS) Relational Database Management System - Maintaining the relationships among data in a database. _ Ensuring that data is stored correctly and that the rules defining the relationships among data are not violated. _ Recovering all data to a point of known consistency, in the event of a system failure.