Databases / Data management Books

Book SynopsisDelivering concise, cutting-edge coverage, CONCEPTS OF DATABASE MANAGEMENT, 8e uses real-world cases, examples, and illustrations to give students a thorough understanding of such critical issues as database design, data integrity, concurrent updates, data security, and more. Completely updated to Microsoft Access 2013 standards, the text presents SQL in a database-neutral environment and covers all major topics, including E-R diagrams, normalization, and database design. It provides detailed coverage of the relational model (including QBE and SQL), normalization and views, database administration and management, and more. Advanced topics covered include distributed databases, data warehouses, stored procedures, triggers, data macros, and Web Apps. Ideal for an introductory database course in an information systems, business, or CIS program, CONCEPTS OF DATABASE MANAGEMENT, 8e can be used in varying disciplines by instructors who want database coverage without using a trade book or a lTable of Contents1. Introduction to Database Management. 2. The Relational Model 1: Introduction, QBE, and Relational Algebra. 3. The Relational Model 2: SQL. 4. The Relational Model 3: Advanced Topics. 5. Database Design 1: Normalization. 6. Database Design 2: Design Method. 7. DBMS Functions. 8. Database Administration. 9. Database Management Approaches. Appendix A: Comprehensive Design Example: Marvel College. Appendix B: SQL Reference. Appendix C: How Do I" Reference. Appendix D: Answers to Odd-Numbered Review Questions. Appendix E: Access Web Apps. Appendix F: Systems Analysis Approach to Information-Level Requirements."

Read more less

Book SynopsisGain a thorough, applied understanding of critical database issues with Starks/Pratt/Last's CONCEPTS OF DATABASE MANAGEMENT, 9E. Real cases, examples and screenshots in this concise presentation help clarify database design, data integrity, normalization, concurrent updates, data security, and big data. Completely updated to SQL Server 2016, Microsoft Access 2016, and Office 365 standards, this edition explores SQL in a database-neutral environment while addressing E-R diagrams, normalization, and database design. Detailed coverage presents the relational model (including QBE and SQL), normalization and views, database administration and management. You also examine advanced topics such as distributed databases, data warehouses, stored procedures, triggers, data macros and Web Apps. This introduction to database is ideal for mastering today's database techniques.Table of Contents1. Introduction to Database Management. 2. The Relational Model 1: Introduction, QBE, and Relational Algebra. 3. The Relational Model 2: SQL. 4. The Relational Model 3: Advanced Topics. 5. Database Design 1: Normalization. 6. Database Design 2: Design Method. 7. DBMS Functions. 8. Database Administration. 9. Database Management Approaches. Appendix A: Comprehensive Design Example: Marvel College. Appendix B: SQL Reference. Appendix C: MySQL. Appendix D: How Do I" Reference. Appendix E: Using Access to Create a Web App. Appendix F: A Systems Analysis Approach to Information-Level Requirements."

Read more less

Book SynopsisIn order to become an IBM Certified Database Administrator - DB2 9 DBA for z/OS, you must pass two exams: DB2 9 Fundamentals Exam (Exam 730), and DB2 9 Database Administrator for z/OS (Exam 732)—the primary focus focus of this book.Written by two members of the team who participated in the actual writing of the exam, this specialized study guide covers every topic that you will need to know to pass Exam 732, including database design and implementation, operation and recovery, security and auditing, performance, as well as installation and migration/upgrade. But that is only the beginning. It also covers the new features of DB2 9 for both database and application development.This comprehensive guide includes an extensive set of practice questions in each chapter that closely model the actual exam, along with an answer key with a description of why the answer is the correct one. No other source gives you this much help in passing the exam.Whether you plan to take Exam 732 or just want to master the skills needed to be an effective database administrator on z/OS systems, this is the only book you’ll need.With the DB2 9 for z/OS Database Administration Certification Study Guide, you will:• Discover the changes to DB2 9 that you’ll need to know in order to be successful when taking the exam • Learn how to effectively administer a DB2 database • Receive an explanation of every objective included on the test…by someone involved in the creation of the actual exam • Find 85 practice questions based on the actual exam’s format and approach, along with comprehensive answers to help you gain understandingPublisher’s Note: While this book covers much of the information needed to prepare for Exam 730, a far more in-depth review of topics specifically related to Exam 730 can be found in the MC Press companion book: DB2 9 Fundamentals Certification Study Guide by Roger E. Sanders.Table of ContentsDB2 Product Fundamentals Environment Access and Security Database Objects Retrieving and Manipulating Database Objects Advanced SQL Coding Maintaining Data Recovery and Restart Data Sharing Using SQL in an Application Pogram Binding an Application Program Application Program Features Stored Procedures Accessing Distributed Data Advanced Functionality Locking and Concurrency Performance Monitoring and Tuning

Read more less

Book SynopsisIn DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade Certification Study Guide , Roger E. Sanders--one of the world's leading DB2 authors and an active participant in the development of IBM's DB2 certification exams--covers everything a reader needs to know to pass the short--but notoriously challenging--DB2 9 for LUW DBA Certification Upgrade exam (Exam 736). This specialized study guide steps you through all of the topics that are covered on the exam, including server management, data placement, XML concepts, activity analysis, high availability, database security, and much more. Everything new to DB2 9 that you will need to know in order to successfully pass the exam is covered in this book. Taking and passing the DB2 9 for LUW DBA Certification Upgrade exam (Exam 736) provides validation that you have mastered DB2 9. Passing this exam also earns you the IBM Certified Database Administrator or Advanced Database Administrator certification. This concentrated guide includes an extensive set of practice questions in each chapter that closely models the actual exam, along with an answer key with a full description of why the answer is the correct one. No other source gives you this much help in passing the exam. With the DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade Certification Study Guide , you will: Gain the knowledge necessary to pass the DB2 9 for LUW DBA Upgrade Certification exam (Exam 736) Discover the changes to DB2 9 that you'll need to know in order to be successful when taking the exam Receive an explanation of every topic included on the test...by someone involved in the creation of the actual exam Find 60 practice questions based on the actual exam's format and approach, along with comprehensive answers to the test questions to help you gain understandingTable of ContentsChapter 1: IBM DB2 9 Certification Chapter 2: Server Management Chapter 3: Data Placement Chapter 4: XML Concepts Chapter 5: Analyzing DB2 Activity Chapter 6: High Availability Chapter 7: Security

Read more less

Book SynopsisThrough a series of case studies from a variety of industries to show how customer experience analytics (CEA) is reshaping business, this book explores the technologies available to help businesses create a competitive advantage and real-time relationship with customers. This book provides a program based in business values that appeal to senior management and a solution architecture that utilizes the fast, intelligent, and productive capabilities of CEA. Exploring the internet's impact on consumer power, this book reflects on the sophistication of business markets in multisupplier management, electronic gateways, and customer and product data across the supply hierarchy.

Read more less

Book SynopsisProviding expert knowledge about the features in the new release of DB2 for z/OS, this extensive guide details the innovations of DB2 10’s SQL and pureXML enhancements—which increase productivity, enhance performance, and simplify application ports. DB2 for z/OS continues to be the undisputed leader in total system availability, scalability, security, and reliability at the lowest cost per transaction. This resource focuses on the features and functions of DB2 10 for IT, including improving operational efficiencies and reducing costs, as well as covering innovations in resiliency for business-critical information, rapid application and warehouse deployment for business growth, and enhanced business analytics and mathematical functions with QMF.

Read more less

Book SynopsisThe relational database-management system DB2 9.7 is given detailed and comprehensive treatment in this exam-preparation resource. Compiled from presentation material used in the popular “Crammer Course” at the IBM Information On Demand Conference, everything required for certification is presented here, including server management, design, business rules implementation, activity monitoring, security, and networking. An essential resource, this guide is helpful when studying to pass the official DB2 9.7 for LUW DBA certification exam.

Read more less

Book SynopsisMuch more than a simple certification study aid, this comprehensive 1,248 page book is designed to help you master all aspects of IBM DB2 database administration and prepare you to take and pass IBM's Certification Exams 611 and 311: Certified Database Administrator. Building on years of extensive hands-on experience, the authors step you through all the areas covered on the test. The book dives deep inside each certification topic: DB2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, security, and connectivity and networking. There is even a "crash course" chapter on DB2 10.5 features. Each chapter includes an extensive set of practice questions along with carefully explained answers. This book provides more than 400 practice questions and answers, more than 120 "flash cards" to help you study for the exam, and 50 step-by-step DB2 feature implementation procedures.Trade Review"This resource is designed to give the DB2 professional the information required in order to successfully obtain certification, or even to simply enhance their existing scope of DB2 knowledge. The authors have done an excellent job of distilling their many years of experience, both within the lab environment and within the live production environment into a logical, well-organized reference. Each section contains the fundamentals, plus valuable insights from the authors, and is backed up with sample exam questions, as well as detailed answers . . . . I am confident that with this guide, your certification will not be far away!" Eric Sheley, Global IT Director, FTSE 100 Global Consumer Goods Company

Read more less

Book SynopsisBringing a practitioner s view to big data analytics, this work examines the drivers behind big data, postulates a set of use cases, identifies sets of solution components, and recommends various implementation approaches. This work also addresses and thoroughly answers key questions on this emerging topic, including What is big data and how is it being used? How can strategic plans for big data analytics be generated? and How does big data change analytics architecture? The author, who has more than 20 years of experience in information management architecture and delivery, has drawn the material from a large breadth of workshops and interviews with business and information technology leaders, providing readers with the latest in evolutionary, revolutionary, and hybrid methodologies of moving forward to the brave new world of big data.

Read more less

Book SynopsisCelebrating the 30th anniversary of the first release of DB2, this book highlights the important milestones, capabilities, and impacts of the database management software for IBM s mainframe operating system. Special focus is given to IBM DB2 Analytics Accelerator, covering the key design and operational aspects that enable IBM DB2 for z/OS clients to benefit from faster performance, reduced CPU usage, and lower costs. The second half of the book discusses performance enhancements and cost-saving measures in the version 10 release and is rich with hints and tips for a successful upgrade. A special section on query performance and IBM DB2 Optimizer illustrates how DB2 10 addresses customer issues such as reducing total cost of ownership while maintaining stability and reliability. The final section is a collection of case studies in which DB2 10 for z/OS customers share their migration experiences and articulate the business benefits they are seeing since upgrading to the new release.

Read more less

Book SynopsisData is becoming the world's new "natural resource," transforming industries and professions across the board. Smart, innovative organizations know that data is the new basis of gaining a competitive advantage. DB2 for z/OS remains the leading database for storing mission-critical data. This book explains how DB2 for z/OS and supporting products enable businesses to use their data to gain a competitive advantage.

Read more less

Book SynopsisRoger E. Sanders, a leading DB2 author and an active participant in the development of DB2 certification exams, covers everything a reader needs to know to take and pass the DB2 10.5 DBA for LUW Upgrade from DB2 10.1 certification exam. This set of study notes takes the reader through each of the topics: DB2 server management; physical design; monitoring DB2 activity; high availability; and utilities. In addition, this book contains a complete practice exam with 60 questions, which closely models the actual 311 exam, along with a detailed answer key.

Read more less

Book SynopsisCombining multiple sensors in order to better grasp a tricky, or even critical, situation is an innate human reflex. Indeed, humans became aware, very early on, of the need to combine several of our senses so as to acquire a better understanding of our surroundings when major issues are at stake. On the basis of this need, we have naturally sought to equip ourselves with various kinds of artificial sensors to enhance our perceptive faculties. The association of multiple heterogeneous sensors provides a reliable and efficient situation assessment in difficult operational contexts, but imperfect local observations need to be managed in a suitable way (uncertainty, imprecision, incompleteness, unreliability, etc.). The theories of uncertainty make it possible to benefit from such information, but the implementation of these theories requires specific developments to meet the needs of multisensor data fusion. This book first discusses basic questions such as: Why and when is multiple sensor fusion necessary? How can the available measurements be characterized in such a case? What is the purpose and the specificity of information fusion processing in multiple sensor systems? Considering the different uncertainty formalisms (probability, fuzzy set theory, possibility theory, belief function theory), a set of coherent operators corresponding to the different steps of a complete fusion process is then developed, in order to meet the requirements identified in the first part of the book. Furthermore, the implementation of these operators is illustrated and discussed within the framework of generic applications.Table of ContentsINTRODUCTION ix CHAPTER 1. MULTISENSOR DATA FUSION 1 1.1. Issues at stake 1 1.2. Problems 4 1.2.1. Interpretation and modeling of data 8 1.2.2. Reliability handling 10 1.2.3. Knowledge propagation 11 1.2.4. Matching of ambiguous data 12 1.2.5. Combination of sources14 1.2.6. Decision-making 16 1.3. Solutions 21 1.3.1. Panorama of useful theories 21 1.3.2. Process architectures 24 1.4. Position of multisensor data fusion 27 1.4.1. Peculiarities of the problem 27 1.4.2. Applications of multisensor data fusion 28 CHAPTER 2. REFERENCE FORMALISMS 31 2.1. Probabilities 31 2.2. Fuzzy sets 35 2.3. Possibility theory 39 2.4. Belief functions theory 43 2.4.1. Basic functions 44 2.4.2. A few particularly useful cases 47 2.4.3. Conditioning/deconditioning 49 2.4.4. Refinement/coarsening 50 CHAPTER 3. SET MANAGEMENT AND INFORMATION PROPAGATION 53 3.1. Fuzzy sets: propagation of imprecision 53 3.2. Probabilities and possibilities: the same approach to uncertainty 56 3.3. Belief functions: an overarching vision in terms of propagation 57 3.3.1. A generic operator: extension 58 3.3.2. Elaboration of a mass function with minimum specificity 61 3.3.3. Direct exploitation of the operator of extension 64 3.4. Example of application: updating of knowledge over time 66 CHAPTER 4. MANAGING THE RELIABILITY OF INFORMATION 71 4.1. Possibilistic view 72 4.2. Discounting of belief functions 73 4.3. Integrated processing of reliability 75 4.4. Management of domains of validity of the sources 77 4.5. Application to fusion of pixels from multispectral images 82 4.6. Formulation for problems of estimation 87 CHAPTER 5. COMBINATION OF SOURCES 91 5.1. Probabilities: a turnkey solution, Bayesian inference 92 5.2. Fuzzy sets: a grasp of axiomatics 94 5.3. Possibility theory: a simple approach to the basic principles 102 5.4. Theory of belief functions: conventional approaches 106 5.5. General approach to combination: any sets and logics 113 5.6. Conflict management 118 5.7. Back to Zadeh’s paradox 122 CHAPTER 6. DATA MODELING 127 6.1. Characterization of signals 127 6.2. Probabilities: immediate taking into account 130 6.3. Belief functions: an open-ended and overarching framework 131 6.3.1. Integration of data into the fusion process 132 6.3.2. Generic problem: modeling of Cij values 135 6.3.3. Modeling measurements with stochastic learning 139 6.3.4. Modeling measurements with fuzzy learning 144 6.3.5. Overview of models for belief functions 148 6.4. Possibilities: a similar approach 153 6.5. Application to a didactic example of classification 157 CHAPTER 7. CLASSIFICATION: DECISION-MAKING AND EXPLOITATION OF THE DIVERSITY OF INFORMATION SOURCES 165 7.1. Decision-making: choice of the most likely hypothesis 166 7.2. Decision-making: determination of the most likely set of hypotheses 168 7.3. Behavior of the decision operator: some practical examples 171 7.4. Exploitation of the diversity of information sources: integration of binary comparisons 175 7.5. Exploitation of the diversity of information sources: classification on the basis of distinct but overlapping sets 179 7.6. Exploitation of the diversity of the attributes: example of application to the fusion of airborne image data 189 CHAPTER 8. SPATIAL DIMENSION: DATA ASSOCIATION 193 8.1. Data association: a multiform problem, which is unavoidable in multisensor data fusion 194 8.2. Construction of a general method for data association 197 8.3. Simple example of the implementation of the method 203 CHAPTER 9. TEMPORAL DIMENSION: TRACKING 211 9.1. Tracking: exploitation of the benefits of multisensory data fusion 211 9.2. Expression of the Bayesian filter 218 9.2.1. Statistical gating 218 9.2.2. Updating 219 9.2.3. Prediction 220 9.3. Signal discrimination process 221 9.3.1. Fusion at the level of each resolution cell 222 9.3.2. Fusion at the level of the validation gate 224 9.3.3. Overview of a practical implementation of the discrimination method 226 9.4. Extensions of the basic MSF 228 9.4.1. Data association 228 9.4.2. Joint tracking of multiple targets 229 9.4.3. Multi-model filtering 231 9.5. Examples of application 232 9.5.1. Extraction power 233 9.5.2. Handling of unfamiliar signatures 235 9.5.3. Tracking on spatially ambiguous observations 238 CONCLUSION 241 BIBLIOGRAPHY 249 INDEX 257

Read more less

Book Synopsis1. Snowflake.- 2. The Snowflake Data Cloud.- 3. Getting Started with Snowflake SQL API.- 4. SQL Basics in Snowflake Using Snowflake SQL API.- 5. Advanced SQL Techniques using Snowflake SQL API.- 6. Data Security and Access Control.- 7. Performance Tuning and Optimization.- 8. Data Warehousing Best Practices.- 9. Working With Laravel 10.- 10. Architectural Patterns and Solutions.- 11. Community and Resources.- 12. Conclusion.

Read more less

Book SynopsisHarness the capabilities of Python and gain the expertise need to master data science techniques. This step-by-step book guides you through using Python to achieve tasks related to data cleaning, statistics, and visualization. You'll start by reviewing the foundational aspects of the data science process. This includes an extensive overview of research points and practical applications, such as the insightful analysis of presidential elections. The journey continues by navigating through installation procedures and providing valuable insights into Python, data types, typecasting, and essential libraries like Pandas and NumPy. You'll then delve into the captivating world of data visualization. Concepts such as scatter plots, histograms, and bubble charts come alive through detailed discussions and practical code examples, unraveling the complexities of creating compelling visualizations for enhanced data understanding. Statistical analysis, linear models, and advanced data preprocessing techniques are also discussed before moving on to preparing data for analysis, including renaming variables, variable rearrangement, and conditional statements. Finally, you'll be introduced to regression techniques, demystifying the intricacies of simple and multiple linear regression, as well as logistic regression. What You'll LearnUnderstand installation procedures and valuable insights into Python, data types, typecastingExamine the fundamental statistical analysis required in most data science and analytics reportsClean the most common data set problemsUse linear progression for data predictionWho This Book Is ForData Analysts, data scientists, Python programmers, and software developers new to data science.

Read more less

Book SynopsisYour MySQL instances are probably broken. Many developers face slow-running queries, issues related to database architecture, replication, or database securityand that's only the beginning. This book will deliver answers to your most pressing MySQL database questions related to performance, availability, or security by uncovering what causes databases to break in the first place. At its core, this book provides you with the knowledge necessary for you to break your database instances so you can better optimize it for performance and secure it from data breaches. In other words, you'll discover the sorts of actions, minor and major, that degrade databases so you can fix and ultimately preempt them. MySQL sometimes acts according to its own rules, and this book will help you keep it working on your terms. At the same time, you will learn to optimize your backup and recovery procedures, determine when and which data to index to achieve maximum performance, and choose the best MySQL configurations, among other essential skills. Most MySQL books focus exclusively on optimization, but this book argues that it's just as important to pay attention to the ways databases break. Indeed, after reading this book, you will be able to safely break your database instances to expose and overcome the nuanced issues that affect performance, availability, and security. What You Will LearnKnow the basics of MySQL and the storage engines innoDB and MyISAMSpot the ways you are harming your database's performance, availability and security without even realizing itFix minor bugs and issues that have surprisingly serious impactOptimize schema, data types, queries, indexes, and partitions to head off issuesUnderstand key MySQL security strategiesWho This Book Is ForDatabase administrators, web developers, systems administrators, and security professionals with an intermediary knowledge of database management systems and building applications in MySQL

Read more less

Book SynopsisMaster Oracle Database administration in both on-premises and cloud environments. This new edition covers the tasks you'll need to perform to keep your databases tuned and performing, and includes new, important innovations with AI Vector Search, JSON Duality Views, and Select AI. Since Oracle Database 23ai offers a choice of platforms with on-premises and cloud, the book also includes administrative tasks specific to cloud environments, including the Oracle Autonomous Database running in the Oracle Cloud Infrastructure. New in this edition is help for DBAs who are becoming involved in data management, and a look at the idea of a converged database and what that means in handling various data types and workloads. The book covers some of the machine learning features now in Oracle and shows how the same SQL that you know for database administration also helps you with data management tasks. The information in this book helps you to apply the right solution at the right time, mitigating risk and making robust choices that protect your data and avoid midnight phone calls. Data management is increasingly a DBA function, and DBAs are often called upon for help in getting data loaded into analytics environments such as a data lakehouse or a data mesh. This book addresses this fast-growing new role for database administrators and helps you build on your existing knowledge to make the transition into a new skill set that is in high demand. You'll learn how to look at data optimization from the standpoint of data analysis and machine learning so that you can be seen as a key player in preparing your organization's data for those type of activities. You'll know how to pull back information from a combination of relational tables and JSON structures. You'll become familiar with the tools that Oracle Database provides to make analytics easier and more straightforward. And you'll learn simpler ways to manage time-based tables that eliminate the need for painfully creating triggers to track the history of row changes over time. This book builds your skills as an Oracle Database administrator with the aim of helping you to be seen as a key player in data management as your organization pivots toward cloud computing and a greater use of machine learning and analytics technologies. What You Will LearnConfigure and manage Oracle 23ai databases both on-premises and in the cloudMeet your DBA responsibilities in the Oracle Cloud and with Database Cloud ServicesLeverage converged database capabilities to manage different workloads, structured and unstructured dataPerform administrative tasks for Autonomous Database dedicated environmentsPerform DBA tasks and effectively use data management toolsMigrate from on-premises to the Oracle Cloud InfrastructureTroubleshoot issues with Oracle 23ai databases and quickly solve performance problemsArchitect cloud, on-premises, hybrid, and multi-cloud database environmentsWho This Book Is ForOracle database administrators (DBAs) who want to be current with the new features in Oracle Database 23ai. For any DBA who is tasked with managing Oracle databases in cloud, hybrid cloud, and multi-cloud configurations. Also helpful for data architects who are designing analytic solutions in data lake house and data mesh environments.

Read more less

Book SynopsisChapter 1: PostgreSQL System Architecture.- Chapter 2: Installation and Database Clusters.- Chapter 3: PostgreSQL Physical Structures.- Chapter 4: Management of Database Cluster/Schemas/Users.- Chapter 5: Backup, Recovery, and Point in Time Recovery.- Chapter 6: Routine Maintenance Tasks.- Chapter 7: Monitoring PostgreSQL.- Chapter 8: Migration from Oracle to PostgreSQL.- Chapter 9: Replication from Oracle to PostgreSQL.

Read more less

Book SynopsisChapter 1: Introduction to SAP Fiori.- Chapter 2: SAP Fiori Apps Reference Library.- Chapter 3: SAP Fiori Apps Recommendation Report.- Chapter 4: SAP Fiori Implementation and Deployment.- Chapter 5: SAP Fiori Configuration.- Chapter 6: Introduction to Fiori Apps.- Chapter 7: Introduction to SAP Fiori Catalogs.- Chapter 8: SAP Fiori Launchpad App Manager.- Chapter 9: SAP Fiori Launchpad Content Manager.- Chapter 10: Introduction to SAP Fiori Spaces and Pages.- Chapter 11: Converting SAP Fiori Groups to Pages.- Chapter 12: Configure Custom SAP Fiori Apps.- Chapter 13: SAP Fiori App Support and Troubleshooting.- Chapter 14: SAP Fiori Upgrade Impact Analysis.- Chapter 15: SAP Fiori Adapt UI.- Chapter 16: SAP Fiori Reports.

Read more less