Базы данных - скачать книги или читать онлайн. Страница 5

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’s so popular that previous editions have made it a bestseller too. Crystal Reports 2008 For Dummies gives you just what you should know to produce the reports you’ll need most often, including how to: Pull specific information from your database, sort and group it, and find the details you need Use dynamic or cascading prompts Troubleshoot and print reports and save time with templates View reports on your LAN Write formulas to retrieve specific information Create and update OLAP reports Format reports, control page breaks, and even add graphics or Flash files Enhance your reports with charts and maps Use Crystal Reports in the enterprise There’s also a companion Web site with sample reports from the book and links to sites with more related information. With Crystal Reports 2008 For Dummies by your side, you’ll soon be able to create reports from simple to spectacular, whenever the need arises.

Create and modify databases and keep them secure Get up to speed on using T-SQL to store and manipulate data SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You'll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more. * Create queries to retrieve data * Ensure SQL Server security * Use Visual Studio(r) 2005 with SQL Server * Create tables, views, and indexes * Work with Common Language Runtime * Query XML data

Reviews planning and designing architecture and implementing the data warehouse. Includes discussions on how and why to apply IBM tools. Offers tips, tricks, and workarounds to ensure maximum performance. Companion Web site includes technical notes, product updates, corrections, and links to relevant material and training.

"Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues." -Aki Ratner, President, Precise Software Solutions Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of «performance tuning»– that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system–not just the database. High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system. The book provides practical solutions for: * Choosing physical layout for ease of administration and efficient use of space * Managing indexes, including detecting unused indexes and automating rebuilds * SQL and system tuning using the powerful new features in Oracle9i Release 2 * Improving SQL performance without modifying code * Running Oracle Real Application Clusters (RAC) for performance and availability * Protecting data using Recover Manager (RMAN), and physical and logical standby databases The companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.

Packed with more than forty percent new and updated material, this edition shows business managers, marketing analysts, and data mining specialists how to harness fundamental data mining methods and techniques to solve common types of business problems Each chapter covers a new data mining technique, and then shows readers how to apply the technique for improved marketing, sales, and customer support The authors build on their reputation for concise, clear, and practical explanations of complex concepts, making this book the perfect introduction to data mining More advanced chapters cover such topics as how to prepare data for analysis and how to create the necessary infrastructure for data mining Covers core data mining techniques, including decision trees, neural networks, collaborative filtering, association rules, link analysis, clustering, and survival analysis

Your all-in-one resource for using Pentaho with MySQL for Business Intelligence and Data Warehousing Open-source Pentaho provides business intelligence (BI) and data warehousing solutions at a fraction of the cost of proprietary solutions. Now you can take advantage of Pentaho for your business needs with this practical guide written by two major participants in the Pentaho community. The book covers all components of the Pentaho BI Suite. You'll learn to install, use, and maintain Pentaho-and find plenty of background discussion that will bring you thoroughly up to speed on BI and Pentaho concepts. Of all available open source BI products, Pentaho offers the most comprehensive toolset and is the fastest growing open source product suite Explains how to build and load a data warehouse with Pentaho Kettle for data integration/ETL, manually create JFree (pentaho reporting services) reports using direct SQL queries, and create Mondrian (Pentaho analysis services) cubes and attach them to a JPivot cube browser Review deploying reports, cubes and metadata to the Pentaho platform in order to distribute BI solutions to end-users Shows how to set up scheduling, subscription and automatic distribution The companion Web site provides complete source code examples, sample data, and links to related resources.

Improved Speed, Accuracy, and Convenience—Yours for the Taking eBay is continuously improving the features it offers buyers and sellers. Now, the biggest improvements are ones you can build for yourself. Mining eBay Web Services teaches you to create custom applications that automate buying and selling tasks and make searches more precise. Do you have dozens of items to sell? You can prepare complete descriptions and terms and submit them all with one click. Are you searching for an item with special purchasing or shipping conditions? You can't do this manually, but your custom application can. Would you benefit from charting your buying and selling trends? This book shows you how to mine and organize information that simply isn't available otherwise. All by itself, the improvement in speed will dwarf anything you've experienced—especially if you connect to eBay via dial-up. But speed is just one piece of an entirely new way of navigating the eBay marketplace. Here's a little of what you'll find covered inside: Creating new listings in bulk and automatically submitting them Getting all the facts you need about an item in one step Performing searches based on shipping or payment terms Completing tasks more quickly by working with locally stored eBay data Working with eBay's new authentication and authorization technology Ensuring the accuracy of your listings Quickly accessing buyer and seller information Using the new Java and SOAP interfaces Using calls to perform tasks not supported by the manual interface Charting trends in your buying and selling habits Tracking eBay listings with mobile devices Developing secure applications Automatically submitting feedback in batches You'll learn to do all of this and more using the language of your choice: JavaScript, VBA, Visual Basic 6, Visual C++ 6, Visual Basic .NET, C#, PHP, or Java. You also get all the details on participating in various eBay developer programs, where everything you need as an individual is completely free.

Are you a visual learner? Do you prefer instructions that show you how to do something – and skip the long-winded explanations? If so, then this book is for you. Open it up, and you will find clear, step-by-step screen shots that show you how to tackle more than 170 Access 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including * Navigating the new interface * Using templates to create databases * Entering and editing data * Working with tables and fields * Creating simple or summary queries * Linking to Excel(r) worksheets * Helpful sidebars offer practical tips and tricks * Full-color screen shots demonstrate each task * Succinct explanations walk you through step by step * Two-page lessons break big topics into bite-sized modules

Get the scoop on designing databases for Mac and Windows Use FileMaker Pro design and scripting to quickly, easily build databases that solve real problems FileMaker Pro has grown up, and it's better than ever! This easy-to-use guide shows you how to design a great FileMaker application, build a database that works, add the functionality you need, populate your database, and venture into programming with ScriptMaker. You'll find out how to share and protect your database, too. Discover how to * Build a layout that works * Create custom triggers and calculated fields * Generate reports automatically * Manage security * Publish your database on the Web * Embed pictures, sound, and video

Researchers often use data from multiple datasets to conduct credible econometric and statistical analysis. The most reliable way to link entries across such datasets is to exploit unique identifiers if those are available. Such linkage however may result in privacy violations revealing sensitive information about some individuals in a sample. Thus, a data curator with concerns for individual privacy may choose to remove certain individual information from the private dataset they plan on releasing to researchers. The extent of individual information the data curator keeps in the private dataset can still allow a researcher to link the datasets, most likely with some errors, and usually results in a researcher having several feasible combined datasets. One conceptual framework a data curator may rely on is k-anonymity, k ≥ 2, which gained wide popularity in computer science and statistical community. To ensure k-anonymity, the data curator releases only the amount of identifying information in the private dataset that guarantees that every entry in it can be linked to at least k different entries in the publicly available datasets the researcher will use. In this paper, we look at the data combination task and the estimation task from both perspectives – from the perspective of the researcher estimating the model and from the perspective of a data curator who restricts identifying information in the private dataset to make sure that k-anonymity holds. We illustrate how to construct identifiers in practice and use them to combine some entries across two datasets. We also provide an empirical illustration on how a data curator can ensure k-anonymity and consequences it has on the estimation procedure. Naturally, the utility of the combined data gets smaller as k increases, which is also evident from our empirical illustration.

Two Microsoft Access MVPs show how you can become an Access power user Microsoft Access is the world’s leading database system, with millions of users and hundreds of thousands of developers. The best practices, tips, and techniques in this book can turn users into power users. Millions of eager users make Access the most popular database system in the world These Microsoft MVPs exploit key features in Access, providing advice on techniques for capturing, sharing and reporting Access data. Each tip provides detailed solutions with clear instructions for implementation, and samples of all can be found on the companion Web site Access 2010 Solutions offers professional advice that enables every Access user to get greater value from the Access database system.

A complete guide to Pentaho Kettle, the Pentaho Data lntegration toolset for ETL This practical book is a complete guide to installing, configuring, and managing Pentaho Kettle. If you’re a database administrator or developer, you’ll first get up to speed on Kettle basics and how to apply Kettle to create ETL solutions—before progressing to specialized concepts such as clustering, extensibility, and data vault models. Learn how to design and build every phase of an ETL solution. Shows developers and database administrators how to use the open-source Pentaho Kettle for enterprise-level ETL processes (Extracting, Transforming, and Loading data) Assumes no prior knowledge of Kettle or ETL, and brings beginners thoroughly up to speed at their own pace Explains how to get Kettle solutions up and running, then follows the 34 ETL subsystems model, as created by the Kimball Group, to explore the entire ETL lifecycle, including all aspects of data warehousing with Kettle Goes beyond routine tasks to explore how to extend Kettle and scale Kettle solutions using a distributed “cloud” Get the most out of Pentaho Kettle and your data warehousing with this detailed guide—from simple single table data migration to complex multisystem clustered data integration tasks.