SAP Sybase IQ 16 In-Database Analytics Option – This is a technical overview of the SAP Sybse IQ In-Database Analytics Option. This options delivers fast, accurate insights quickly to help make the decisions needed to win in today’s competitive environment.
SAP Sybase IQ 16 Advanced Security Option – SAP Sybase IQ 16 Advanced Security Option Technical Overview. This option allows advanced protection of your valuable data assets without sacrificing flexibility.
Lesson 2: Product Installation and Database Creation – This chapter discusses installing Sybase IQ, verifying the installation, starting up the server and using client tools to connect to it. It will show you how to create a Sybase IQ database. It will also describe the TPCH schema that you will be creating in your Sybase IQ database. This schema will be the basis for the work you will be doing in subsequent chapters of this book.
Lesson 3: Create Schema and Load Data – This chapter discusses creating users in the database you created in the previous chapter, installing the TPCH schema, and loading data into the tables.
Lesson 4: Optimize a Query Using the Sybase IQ Query Plan – In this chapter, you will learn how Sybase IQ executes queries, and how to interpret the Sybase IQ query plan. The focus will be on query optimization on a single IQ server, not distributed query processing in a Multiplex. That is addressed in another lesson, “Scaling Out with Multiplex and Distributed Query Processing”. In this lesson, you will execute a SQL query, and perform some analysis to optimize the query.
Lesson 5: Monitoring Sybase IQ with Sybase Control Center – Once you have your database up and running, there are administrative tasks that you need to know how to perform in order to insure the health – responsiveness and longevity – of your system. This lesson is going to focus on Sybase Control Center – a graphical monitoring and administration tool for all types of Sybase servers, including Sybase IQ.
Lesson 7: Pattern Matching with a C++ in-Database UDF – When you want to perform analysis on the data in your Sybase IQ database, you normally will write a SQL query or stored procedure. But Sybase IQ has taken analytics to another level with its in-database analytics feature. Sybase IQ has created an API for extending the functionality of the Sybase IQ database server with user defined functions called UDFs.