Базы данных

Пособие является результатом многолетнего преподавания программирования и представляет собой сборник программ и задач для самостоятельного решения в среде программирования Delphi. Основная цель книги — сформировать у студентов понимание ключевых аспектов объектно-ориентированного программирования (ООП) на языке Delphi, достаточное для практического использования в дальнейшем обучении и в работе. Для достижения этой цели авторы предлагают решения задач различной степени сложности, которые демонстрируют возможности среды разработки Delphi.

В учебном пособии даны расчеты строительных конструкций с использованием метода конечных элементов (т.е. разделения рассчитываемой системы на отдельные части). Приведены расчеты стержневой системы с растянутыми (сжатыми) элементами и системы с изгибаемыми и растянутыми (сжатыми) элементами. Описаны общий подход для получения матриц жесткости стержневых КЭ, основанный на вариационном принципе Лагранжа, а также примеры решения задач по МКЭ. Практический раздел пособия содержит общие сведения о программном комплексе SCAD, варианты заданий для расчетно-графической работы и пример выполнения расчетно-графической работы.

Learn to take advantage of the opportunities offered by SQL Server 2014 Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry. The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment. Authors Adam Jorgensen, Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the dream team of the SQL Server community, and they put their expertise to work guiding you through the changes. Improve oversight with better management and monitoring Protect your work with enhanced security features Upgrade performance tuning, scaling, replication, and clustering Learn new options for backup and recovery Professional Microsoft SQL Server 2014 includes a companion website with sample code and efficient automation utilities, plus a host of tips, tricks, and workarounds that will make your job as a DBA or database architect much easier. Stop getting frustrated with administrative issues and start taking control. Professional Microsoft SQL Server 2014 is your roadmap to mastering the update and creating solutions that work.

An updated guide for an updated certification exam! As the most popular database software in the world, Oracle Database 12c has been updated for the first time in nearly six years and the changes are significant. This study guide reviews how Oracle 12c allows multiple instances to be used simultaneously via the cloud. You'll sharpen your skills to prepare for the three levels of certification: Oracle Certified Associate, Oracle Certified Professional, and Oracle Certified Master. Workbook exercise appendix, test engine, chapter review questions, electronic flashcards, searchable PDF glossary, and two bonus practice exams all help to enhance your preparation to take the Oracle 12c exam. Addresses such topics as: database architecture, configuring and recoverability, configuring backup specifications, and performing user-managed backup and recovery Reviews how to use RMAN to create backups, perform recovery, and duplicate a database Looks at performing tablespace point-in-time recovery and using flashback technology Covers diagnosing the database, managing memory, managing resources, and automating tasks Focusing 100 percent on the exam objectives, OCP: Oracle Database 12c Administrator Certified Professional Study Guide is designed for those who feel they are ready to attempt this challenging exam.

Leverage the integration of SQL Server and Office for more effective BI Applied Microsoft Business Intelligence shows you how to leverage the complete set of Microsoft tools—including Microsoft Office and SQL Server—to better analyze business data. This book provides best practices for building complete BI solutions using the full Microsoft toolset. You will learn how to effectively use SQL Server Analysis and Reporting Services, along with Excel, SharePoint, and other tools to provide effective and cohesive solutions for the enterprise. Coverage includes BI architecture, data queries, semantic models, multidimensional modeling, data analysis and visualization, performance monitoring, data mining, and more, to help you learn to perform practical business analysis and reporting. Written by an author team that includes a key member of the BI product team at Microsoft, this useful reference provides expert instruction for more effective use of the Microsoft BI toolset. Use Microsoft BI suite cohesively for more effective enterprise solutions Search, analyze, and visualize data more efficiently and completely Develop flexible and scalable tabular and multidimensional models Monitor performance, build a BI portal, and deploy and manage the BI Solution

Cut warranty costs by reducing fraud with transparent processes and balanced control Warranty Fraud Management provides a clear, practical framework for reducing fraudulent warranty claims and other excess costs in warranty and service operations. Packed with actionable guidelines and detailed information, this book lays out a system of efficient warranty management that can reduce costs without upsetting the customer relationship. You'll dig into the whole spectrum of warranty fraud, from simple sloppy procedures to systematic organized crime, and get to know the fraudulent parties, the victims, as well as the objectives and methods of the fraudulent activities in different scenarios. You'll learn how to implement controls to detect and reduce fraudulent claims and decrease the overall warranty costs. The impact of fraudulent claims is plainly spelled out alongside detailed descriptions of typical symptoms and process gaps present in diverse companies. A comprehensive, multi-modal framework for robust warranty management is presented as a template for revamping your own company's strategy. Fraudulent warranty claims occupy an estimated 3-15 percent of the average company's warranty costs, which generally average between 1-4 percent of sales. Many companies are unaware of the issue or struggle to take action against the claims for fear of upsetting business partners, or because they lack tangible evidence. This book details a robust warranty control framework that institutes transparency and control over the whole warranty chain—supporting the process far beyond just fraud reduction. Understand the different actors (customers, sales channels, service agents, warranty providers, etc.) and different forms of warranty fraud Uncover issues in your company's warranty processes Learn methods to detect and prevent fraudulent activities Implement a robust system of warranty cost control Warranty fraud is a major cost-control issue for most companies, but the sensitive nature of the topic leaves most reluctant to share their experiences and divulge their strategies. Warranty Fraud Management brings warranty fraud out into the open, and provides a clear, actionable framework for cost-savings through fraud reduction.

Optimize reporting and BI with Microsoft SQL Server 2016 Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design, and filtering techniques. Expert guidance provides insight into common report types and explains where each could be made more efficient, while providing step-by step instruction on Microsoft SQL Server 2016. All changes to the 2016 release are covered in detail, including improvements to the Visual Studio Report Designer (SQL Server Data Tools) and Report Builder, Mobile Dashboard Designer, the new Report Portal Interface, HTML-5 Rendering, Power BI integration, Custom Parameters Pane, and more. The Microsoft SQL Server 2016 release will include significant changes. New functionality, new capabilities, re-tooled processes, and changing support require a considerable update to existing knowledge. Whether you're starting from scratch or simply upgrading, this book is an essential guide to report design and business intelligence solutions. Understand BI fundamentals and Reporting Services architecture Learn the ingredients to a successful report design Get up to speed on Microsoft SQL Server 2016 Grasp the purpose behind common designs to optimize your reporting Microsoft SQL Server Reporting Services makes reporting faster, easier, and more powerful than ever in web, desktop and portal solutions. Compatibility with an extensive variety of data sources makes it a go-to solution for organizations across the globe. The 2016 release brings some of the biggest changes in years, and the full depth and breadth of these changes can create a serious snag in your workflow. For a clear tutorial geared toward the working professional, Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports is the ideal guide for getting up to speed and producing successful reports.

Detect fraud earlier to mitigate loss and prevent cascading damage Fraud Analytics Using Descriptive, Predictive, and Social Network Techniques is an authoritative guidebook for setting up a comprehensive fraud detection analytics solution. Early detection is a key factor in mitigating fraud damage, but it involves more specialized techniques than detecting fraud at the more advanced stages. This invaluable guide details both the theory and technical aspects of these techniques, and provides expert insight into streamlining implementation. Coverage includes data gathering, preprocessing, model building, and post-implementation, with comprehensive guidance on various learning techniques and the data types utilized by each. These techniques are effective for fraud detection across industry boundaries, including applications in insurance fraud, credit card fraud, anti-money laundering, healthcare fraud, telecommunications fraud, click fraud, tax evasion, and more, giving you a highly practical framework for fraud prevention. It is estimated that a typical organization loses about 5% of its revenue to fraud every year. More effective fraud detection is possible, and this book describes the various analytical techniques your organization must implement to put a stop to the revenue leak. Examine fraud patterns in historical data Utilize labeled, unlabeled, and networked data Detect fraud before the damage cascades Reduce losses, increase recovery, and tighten security The longer fraud is allowed to go on, the more harm it causes. It expands exponentially, sending ripples of damage throughout the organization, and becomes more and more complex to track, stop, and reverse. Fraud prevention relies on early and effective fraud detection, enabled by the techniques discussed here. Fraud Analytics Using Descriptive, Predictive, and Social Network Techniques helps you stop fraud in its tracks, and eliminate the opportunities for future occurrence.

This book reviews state-of-the-art methodologies and techniques for analyzing enormous quantities of raw data in high-dimensional data spaces, to extract new information for decision making. The goal of this book is to provide a single introductory source, organized in a systematic way, in which we could direct the readers in analysis of large data sets, through the explanation of basic concepts, models and methodologies developed in recent decades. If you are an instructor or professor and would like to obtain instructor’s materials, please visit http://booksupport.wiley.com If you are an instructor or professor and would like to obtain a solutions manual, please send an email to: pressbooks@ieee.org

In The Patient Revolution, author Krisa Tailor—a noted expert in health care innovation and management—explores, through the lens of design thinking, how information technology will take health care into the experience economy. In the experience economy, patients will shift to being empowered consumers who are active participants in their own care. Tailor explores this shift by creating a vision for a newly designed health care system that's focused on both sickness and wellness, and is driven by data and analytics. The new system seamlessly integrates health into our daily lives, and delivers care so uniquely personalized that no two people are provided identical treatments. Connected through data, everyone across the health care ecosystem, including clinicians, insurers, and researchers, will be able to meet individuals wherever they are in their health journey to reach the ultimate goal of keeping people healthy. The patient revolution has just begun and an exciting journey awaits us. Praise for the patient revolution «A full 50% of the US population has at least one chronic disease that requires ongoing monitoring and treatment. Our current health care system is woefully inadequate in providing these individuals with the treatment and support they need. This disparity can only be addressed through empowering patients to better care for themselves and giving providers better tools to care for their patients. Both of those solutions will require the development and application of novel technologies. In Krisa Tailor's book The Patient Revolution, a blueprint is articulated for how this could be achieved, culminating in a vision for a learning health system within 10 years.» —Ricky Bloomfield, MD, Director, Mobile Technology Strategy; Assistant Professor, Duke Medicine «In The Patient Revolution, Krisa Tailor astutely points out that 80% of health is impacted by factors outside of the health care system. Amazon unfortunately knows more about our patients than we do. The prescriptive analytics she describes will allow health care providers to use big data to optimize interventions at the level of the individual patient. The use of analytics will allow providers to improve quality, shape care coordination, and contain costs. Advanced analytics will lead to personalized care and ultimately empowered patients!» —Linda Butler, MD, Vice President of Medical Affairs/Chief Medical Officer/Chief Medical Information Officer, Rex Healthcare «The Patient Revolution provides a practical roadmap on how the industry can capture value by making health and care more personalized, anticipatory, and intuitive to patient needs.» —Ash Damle, CEO, Lumiata «Excellent read. For me, health care represents a unique economy—one focused on technology, but requiring a deep understanding of humanity. Ms. Tailor begins the exploration of how we provide care via the concepts of design thinking, asking how we might redesign care with an eye toward changing the experience. She does an excellent job deconstructing this from the patient experience. I look forward to a hopeful follow-up directed at changing the provider culture.» —Alan Pitt, MD, Chief Medical Officer, Avizia «Whether you're a health care provider looking to gain an understanding of the health care landscape, a health data scientist, or a seasoned business pro, you'll come away with a deeper, nuanced understanding of today's evolving health care system with this book. Krisa Tailor ties together—in a comprehensive, unique way—the worlds of health care administration, clinical practice, design thinking, and business strategy and innovation.» —Steven Chan, MD, MBA, University of California, Davis

Helping tech-savvy marketers and data analysts solve real-world business problems with Excel Using data-driven business analytics to understand customers and improve results is a great idea in theory, but in today's busy offices, marketers and analysts need simple, low-cost ways to process and make the most of all that data. This expert book offers the perfect solution. Written by data analysis expert Wayne L. Winston, this practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques—and achieve optimum results. Practical exercises in each chapter help you apply and reinforce techniques as you learn. Shows you how to perform sophisticated business analyses using the cost-effective and widely available Microsoft Excel instead of expensive, proprietary analytical tools Reveals how to target and retain profitable customers and avoid high-risk customers Helps you forecast sales and improve response rates for marketing campaigns Explores how to optimize price points for products and services, optimize store layouts, and improve online advertising Covers social media, viral marketing, and how to exploit both effectively Improve your marketing results with Microsoft Excel and the invaluable techniques and ideas in Marketing Analytics: Data-Driven Techniques with Microsoft Excel.

Learn what it takes to succeed in the the most in-demand tech job Harvard Business Review calls it the sexiest tech job of the 21st century. Data scientists are in demand, and this unique book shows you exactly what employers want and the skill set that separates the quality data scientist from other talented IT professionals. Data science involves extracting, creating, and processing data to turn it into business value. With over 15 years of big data, predictive modeling, and business analytics experience, author Vincent Granville is no stranger to data science. In this one-of-a-kind guide, he provides insight into the essential data science skills, such as statistics and visualization techniques, and covers everything from analytical recipes and data science tricks to common job interview questions, sample resumes, and source code. The applications are endless and varied: automatically detecting spam and plagiarism, optimizing bid prices in keyword advertising, identifying new molecules to fight cancer, assessing the risk of meteorite impact. Complete with case studies, this book is a must, whether you're looking to become a data scientist or to hire one. Explains the finer points of data science, the required skills, and how to acquire them, including analytical recipes, standard rules, source code, and a dictionary of terms Shows what companies are looking for and how the growing importance of big data has increased the demand for data scientists Features job interview questions, sample resumes, salary surveys, and examples of job ads Case studies explore how data science is used on Wall Street, in botnet detection, for online advertising, and in many other business-critical situations Developing Analytic Talent: Becoming a Data Scientist is essential reading for those aspiring to this hot career choice and for employers seeking the best candidates.

Integrate big data into business to drive competitive advantage and sustainable success Big Data MBA brings insight and expertise to leveraging big data in business so you can harness the power of analytics and gain a true business advantage. Based on a practical framework with supporting methodology and hands-on exercises, this book helps identify where and how big data can help you transform your business. You'll learn how to exploit new sources of customer, product, and operational data, coupled with advanced analytics and data science, to optimize key processes, uncover monetization opportunities, and create new sources of competitive differentiation. The discussion includes guidelines for operationalizing analytics, optimal organizational structure, and using analytic insights throughout your organization's user experience to customers and front-end employees alike. You'll learn to “think like a data scientist” as you build upon the decisions your business is trying to make, the hypotheses you need to test, and the predictions you need to produce. Business stakeholders no longer need to relinquish control of data and analytics to IT. In fact, they must champion the organization's data collection and analysis efforts. This book is a primer on the business approach to analytics, providing the practical understanding you need to convert data into opportunity. Understand where and how to leverage big data Integrate analytics into everyday operations Structure your organization to drive analytic insights Optimize processes, uncover opportunities, and stand out from the rest Help business stakeholders to “think like a data scientist” Understand appropriate business application of different analytic techniques If you want data to transform your business, you need to know how to put it to use. Big Data MBA shows you how to implement big data and analytics to make better decisions.

Hands-on troubleshooting methods on the most recent release of SQL Server The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any performance issue on any server running SQL Server. Covers the core technical topics required to understand how SQL Server and Windows should be working Shares best practices so that you know how to proactively monitor and avoid problems Shows how to use tools to quickly gather, analyze, and effectively respond to the source of a system-wide performance issue Professional SQL Server 2012 Internals and Troubleshooting helps you to quickly become familiar with the changes of this new release so that you can best handle database performance and troubleshooting.

A hands-on resource for SQL Server 2008 troubleshooting methods and tools SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system. You'll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side. Topics Covered: SQL Server Architecture Understanding Memory SQL Server Waits and Extended Events Working with Storage CPU and Query Processing Locking and Latches Knowing Tempdb Defining Your Approach To Troubleshooting Viewing Server Performance with PerfMon and the PAL Tool Tracing SQL Server with SQL Trace and Profiler Consolidating Data Collection with SQLDiag and the PerfStats Script Introducing RML Utilities for Stress Testing and Trace File Analysis Bringing It All Together with SQL Nexus Using Management Studio Reports and the Performance Dashboard Using SQL Server Management Data Warehouse Shortcuts to Efficient Data Collection and Quick Analysis Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

The ultimate handbook for Excel analysts who need reporting solutions using Access Excel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions. Sales managers, operations analysts, administrative assistants, office managers, and many others who rely heavily on data can benefit from learning to integrate Excel and Access, and this book shows you how. Coverage includes: Data Analysis in Access & the Basics of Access Beyond Select Queries Transforming Your Data with Access Working with Calculations and Dates Performing Conditional Analysis Adding Dimension with Subqueries and Domain Aggregate Functions Running Descriptive Statistics in Access Scheduling and Running Batch Analysis Leveraging VBA to Enhance Data Analysis Reports, Dashboards, and Visualization in Access Presenting Data with Access Reports Using Pivot Tables and Pivot Charts in Access Enhancing Queries and Reports with Visualizations Advanced Excel and Access Integration Techniques Getting Access Data into Excel Using VBA to Move Data between Excel and Access Exploring Excel and Access Automation Integrating Excel and Access with XML Integrating Excel and Other Office Applications Access VBA Fundamentals Understanding and Using SQL and more! The Excel Analyst's Guide to Access helps you get more from both applications. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

The next wave of business intelligence, Self-Service BI, seeks to meet the demands of powerful hardware and shorter decision time frames. This book introduces PowerPivot for Excel and SharePoint, showing you how to use this innovative software for self-service analytics and reporting. Authored by key members of the Microsoft team that built the product, this book will guide you through the use of in-memory BI server technology, data analytics eXpressions, and report gallery. The book also discusses how to deploy and manage sandbox servers, and a companion website provides sample reports and applications.

The leading introductory book on data mining, fully updated and revised! When Berry and Linoff wrote the first edition of Data Mining Techniques in the late 1990s, data mining was just starting to move out of the lab and into the office and has since grown to become an indispensable tool of modern business. This new edition—more than 50% new and revised— is a significant update from the previous one, and shows you how to harness the newest data mining methods and techniques to solve common business problems. The duo of unparalleled authors share invaluable advice for improving response rates to direct marketing campaigns, identifying new customer segments, and estimating credit risk. In addition, they cover more advanced topics such as preparing data for analysis and creating the necessary infrastructure for data mining at your company. Features significant updates since the previous edition and updates you on best practices for using data mining methods and techniques for solving common business problems Covers a new data mining technique in every chapter along with clear, concise explanations on how to apply each technique immediately Touches on core data mining techniques, including decision trees, neural networks, collaborative filtering, association rules, link analysis, survival analysis, and more Provides best practices for performing data mining using simple tools such as Excel Data Mining Techniques, Third Edition covers a new data mining technique with each successive chapter and then demonstrates how you can apply that technique for improved marketing, sales, and customer support to get immediate results.

Implement, maintain, and repair SQL Server 2012 databases As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server's roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them. Includes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certification Explores the skills you'll need on the job as a SQL Server 2012 DBA Discusses designing and implementing database solutions Walks you through administrating, maintaining, and securing SQL Server 2012 Addresses implementing high availability and data distribution Includes bonus videos where the author walks you through some of the more difficult tasks expected of a DBA Featuring hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases.

With big data analytics comes big insights into profitability Big data is big business. But having the data and the computational power to process it isn't nearly enough to produce meaningful results. Big Data, Data Mining, and Machine Learning: Value Creation for Business Leaders and Practitioners is a complete resource for technology and marketing executives looking to cut through the hype and produce real results that hit the bottom line. Providing an engaging, thorough overview of the current state of big data analytics and the growing trend toward high performance computing architectures, the book is a detail-driven look into how big data analytics can be leveraged to foster positive change and drive efficiency. With continued exponential growth in data and ever more competitive markets, businesses must adapt quickly to gain every competitive advantage available. Big data analytics can serve as the linchpin for initiatives that drive business, but only if the underlying technology and analysis is fully understood and appreciated by engaged stakeholders. This book provides a view into the topic that executives, managers, and practitioners require, and includes: A complete overview of big data and its notable characteristics Details on high performance computing architectures for analytics, massively parallel processing (MPP), and in-memory databases Comprehensive coverage of data mining, text analytics, and machine learning algorithms A discussion of explanatory and predictive modeling, and how they can be applied to decision-making processes Big Data, Data Mining, and Machine Learning provides technology and marketing executives with the complete resource that has been notably absent from the veritable libraries of published books on the topic. Take control of your organization's big data analytics to produce real results with a resource that is comprehensive in scope and light on hyperbole.