Database

IBM Cognos 8 Report Studio Cookbook

Over 80 great recipes for taking control of Cognos 8 Report Studio Learn advanced techniques to produce real-life reports that meet business demands Tricks and hacks for speedy and effortless report development and to overcome tool-based limitations Peek into the best practices used in industry and discern ways to work like a pro Part of Packt’s Cookbook series-each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible In Detail Cognos Report Studio is widely used for creating and managing business reports in medium to large companies. It is simple enough for any business analyst, power user, or developer to pick up and start developing basic reports. However, when it comes to developing more sophisticated, fully functional business reports for wider audiences, report authors will need guidance.

This book helps you understand and use all the features provided by Report Studio to generate impressive deliverables. It will take you from being a beginner to a professional report author. It bridges the gap between basic training provided by manuals or trainers and the practical techniques learned over years of practice.

This book covers all the basic and advanced features of Report Authoring. It begins by bringing readers on the same platform and introducing the fundamental features useful across any level of reporting. Then it ascends to advanced techniques and tricks to overcome Studio limitations.Develop excellent reports using dimensional data sources by following best practices that development work requires in Report Studio. You will also learn about editing the report outside the Studio by directly editing the XML specifications. Provide richness to the user interface by adding JavaScript and HTML tags. The main focus is on the practical use of various powerful features that Report Studio has to offer to suit your business requirements.

Learn techniques and hacks to make the best out of your Cognos 8 Report Studio

Continue reading…

Microsoft Dynamics NAV 2009 Application Design

A focused tutorial for Microsoft Dynamics NAV application development

Learn how Dynamics NAV ERP suite is set up and customized for various industries Integrate numerous parts of a company’s operations including financial reporting, sales, order management, inventory, and forecasting Develop complete applications and not just skeleton systems Covers the design and implementation of two new add-on services: The Squash application and the Storage & Logistics application Also usable for previous versions such as 3.x, 4.0, and 5.0 Easy-to-read style, packed with hard-won practical advice Real-world examples with step-by-step explanations In Detail

Dynamics NAV 2009 is an Enterprise Resource Planning (ERP) software product from Microsoft that can be used for variety of business needs. It is part of the Microsoft Dynamics family, and intended to assist with finance, manufacturing, Customer Relationship Management, supply chains, analytics, and electronic commerce for small and medium-sized enterprises.

This book is a focused tutorial on Microsoft Dynamics NAV application development, so you can develop complete applications and not just application outlines. It will show NAV developers how to create different kinds of applications. Different kinds of application are vital in different industries like fashion, automobile, retail, books (education), and other industries. It starts off by introducing the supply chain that you will be using throughout the book. You will implement the Microsoft Dynamics NAV ERP suite and learn how it is set up and customized for various industries.

You will be able to customize Dynamics NAV to suit the different aspects of a business such as Financial Management, Relationship Management, Production, Jobs, Trade, Storage, Logistics, and so on. The book will take you through these Microsoft-designed application features and show you how to customize and extend them safely. Thus, you will be able to create a structure of your own in Microsoft Dynamics NAV.

A focused tutorial for Microsoft Dynamics NAV application development

Continue reading…

Oracle 11g Streams Implementer’s Guide
Design, implement, and maintain a distributed environment with Oracle Streams.Implement Oracle Streams to manage and coordinate the resources, information, and functions of a distributed system Get to grips with in-depth explanations of the components that make up Oracle Streams, and how they work together Learn design considerations that help identify and avoid Oracle Streams obstacles – before you get caught in them Covers implementation steps with explanations of ‘why’ as well as ‘how’.

In Detail
From smaller businesses through to huge enterprises – users all over the world often require access to data 24 hours a day. Distributed database systems proliferate the world of data sharing providing an ability to access real-time data anywhere, anytime. Oracle Streams, a built-in feature of the Oracle database, is a data replication and integration feature critical to the success and wellbeing of enterprises in today’s fast moving economy. This book provides the reader with solid techniques to master Oracle Streams technology and successfully deploy distributed database systems.  This book quickly goes over the basics and gets you up and running with a simple Oracle 11g Streams environment. It will serve as an excellent companion to the Oracle Streams Administration Guide. It is intended for Oracle database architects and administrators, and provides in-depth discussion on must-know information for the design, implementation, and maintenance of an Oracle Streams environment.  The book does not attempt to regurgitate all the information in the Oracle Streams Administration Guides, but rather provides additional clarification and explanation of design, implementation, and troubleshooting concepts that are often elusive in Streams documentation. It also identifies helpful tools and Oracle resources to add to your knowledge base, as well as tried and tested tricks and tips to help you tame Oracle Streams.  The book starts by introducing and explaining the components of Oracle Streams and how they work together. It then moves on logically, helping you to determine your distributed environment requirements and design your Streams implementation to meet those requirements. Once these concepts are discussed, the book moves to configuration and basic implementation examples to help solidify those concepts. It then addresses advanced features such as tags, down-stream capture, and conflict resolution. You then move on to maintenance techniques such as documenting the environment, effectively planning and implementing changes to the environment, and monitoring and troubleshooting the environment. When you have studied the techniques and completed the hands-on examples, you will have an understanding of Oracle Streams’ core concepts and functionally that will allow you to successfully design, implement, and maintain an Oracle Streamed environment.
Continue reading…

jBPM Developer Guide Summary:

jBPM is an open source business process management (BPM) solution used for defining and executing business processes. Java developers can use jBPM to analyze, improve, and maintain their business processes. This book steers you through each point of the jBPM framework and its implementation to model your business processes. The book starts by explaining the key concepts in a Business Process Management framework. It will help you to learn and practice all of the conceptual and theoretical terms used in the Business Process Management field. Then you will master jPDL, the preferred process language for jBMP, which will let you specify exactly how your processes must be defined and implemented. Continue reading…

The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability

Performance and scalability are more critical than ever in today’s enterprise database applications, and traditional database tuning isn’t nearly enough to solve the performance problems you are likely to see in those applications. Nowadays, 75-95% of the time it takes to process a data request is typically spent in the database middleware. Today’s worst performance and scalability problems are generally caused by issues with networking, database drivers, the broader software/hardware environment, and inefficient coding of data requests. In The Data Access Handbook, two of the world’s leading experts on database access systematically address these issues, showing how to achieve remarkable improvements in performance of real-world database applications. Drawing on their unsurpassed experience with every leading database system and database connectivity API, John Goodson and Rob Steward reveal the powerful ways middleware affects application performance and guide developers with designing and writing API code that will deliver superior performance in each leading environment. In addition to covering essential concepts and techniques that apply across database systems and APIs, they present many API examples for ODBC, JDBC, and ADO.NET as well as database system examples for DB2, Microsoft SQL Server, MySQL, Oracle, and Sybase. Continue reading…

Oracle PL/SQL Programming, Fifth Edition

English | 1226 pages | O’Reilly Media, Inc.; 5 edition (October 1, 2009) | ISBN: 0596514468 | PDF | 15 MB

Continue reading…

Oracle Database 11g A Beginners Guide By McGraw Hill

McGraw-Hill | ISBN: 0071604596 | 2008 | PDF | 432 pages | 5.02 MB
Continue reading…

McGraw Hill Crystal Reports 2008 The Complete Reference Jun 2008

Your One-Stop Guide to Enterprise Reporting with Crystal Reports 2008 Transform disconnected corporate data into compelling, interactive business intelligence using all of the powerful tools available in Crystal Reports 2008. Through detailed explanations, real-world examples, and expert advice, this comprehensive guide shows you how to create, maintain, and distribute dynamic, visually appealing enterprise database reports. Crystal Reports 2008: The Complete Reference explains how to select and gather pertinent business data, organize it into manageable groups, and assemble it into user-friendly business reports. Continue reading…

Crystal Reports 2008 For Dummies
Allen G.Taylor | PDF | English | 411 pages | 7.7 MB

A report is only useful if those who receive it understand what it means. Knowing how to use Crystal Reports gives you the edge in producing reports from your database that really are crystal clear. Crystal Reports 2008 For Dummies is a quick and easy guide to get you going with the latest version of this bestselling report-writing software. In fact, it is so popular that previous editions have made it a bestseller too.
Continue reading…

Product Description

Extensible Stylesheet Language Transformations (XSLT) is a language for transforming XML documents and data from one format to another. Answering the demand for an introductory book on XSLT processing, Ian Williams presents a clear, concise resource on XSLT concepts and methods and explains how and why XSLT relies on the XML Path language (XPath).As you gain a solid foundation in XSLT processing, you’ll learn the basic node tree structure that is used in the data model and discover how XSLT differs from the approach used in other programming languages. Example-laden chapters include both versions 1.0 and 2.0 features and demonstrate how to transform one XML data format to another. The book covers the key structural elements of an XSLT file and shows you how to use simple XPath expressions to match and select source file content. Along the way, you’ll uncover a rich set of XPath functions that will benefit you again and again as you develop your XSLT skills.

Continue reading…