FreeBookSpot Databases Latest Books

SQL and Relational Theory: How to Write Accurate SQL Code 2nd edition
Posted: December 24th, 2011, 10:53pm CET

Tags:    [edit]


Product Description: SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL. This second edition includes new material on recursive queries, “missing information” without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating. If you have a modest-to-advanced background in SQL, you’ll learn how to deal with a host of common SQL dilemmas. * Why is proper column naming so important? * Nulls in your database are causing you to get wrong answers. Why? What can you do about it? * Is it possible to write an SQL query to find employees who have never been in the same department for more than six months at a time? * SQL supports “quantified comparisons,” but they’re better avoided. Why? How do you avoid them? * Constraints are crucially important, but most SQL products don’t support them properly. What can you do to resolve this situation? Database theory and practice have evolved since the relational model was developed more than 40 years ago. SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of SQL available. C.J. Date has a stature that is unique within the Read more...

Tags:    [edit]

Product Description: This book provides a comprehensive understanding of database development on the Internet. Read more...

Tags:    [edit]

Product Description: The amount of data being generated, processed, and stored has reached unprecedented levels. Even during the recent economic crisis, there has been no slow down or information recession. Instead, the need to process, move, and store data has only increased. Consequently, IT organizations are looking to do more with what they have while supporting growth along with new services without compromising on cost and service delivery. Cloud and Virtual Data Storage Networking, by savvy IT industry veteran Greg Schulz, looks at converging IT resources and management technologies for facilitating efficient and effective delivery of information services, including enabling of Information Factories. Regardless of your experience level, Schulz guides you through the various technologies and techniques available for achieving efficient information services delivery. Coverage includes: * Information services delivery model options and best practices * Metrics for efficient E2E IT management * Server, storage, I/O networking, and data center virtualization * Converged and cloud storage services (IaaS, PaaS, SaaS) * Data protection for virtual, cloud, and physical environments * Data footprint reduction and data protection modernization * High availability, business continuance, and disaster recovery This much-needed reference brings together technology themes and topics that are converging in IT and data center environments for enabling Read more...

Tags:    [edit]

Product Description: Summary MongoDB in Action is a comprehensive guide to MongoDB for application developers. The book begins by explaining what makes MongoDB unique and describing its ideal use cases. A series of tutorials designed for MongoDB mastery then leads into detailed examples for leveraging MongoDB in e-commerce, social networking, analytics, and other common applications. About the Technology Big data can mean big headaches. MongoDB is a document-oriented database designed to be flexible, scalable, and very fast, even with big data loads. It's built for high availability, supports rich, dynamic schemas, and lets you easily distribute data across multiple servers. About this Book MongoDB in Action introduces you to MongoDB and the document-oriented database model. This perfectly paced book provides both the big picture you'll need as a developer and enough low-level detail to satisfy a system engineer. Numerous examples will help you develop confidence in the crucial area of data modeling. You'll also love the deep explanations of each feature, including replication, auto-sharding, and deployment This book is written for developers. No MongoDB or NoSQL experience required. What's Inside * Indexes, queries, and standard DB operations * Map-reduce for custom aggregations and reporting * Schema design patterns * Deploying for scale and high availability ========================================?========== Table of ContentsPART 1 GETTI Read more...

Tags:    [edit]

Product Description: Gillenson's new edition of Fundamentals of Database Management Systems provides concise coverage of the fundamental topics necessary for a deep understanding of the basics. In this issue, there is more emphasis on a practical approach, with new "your turn" boxes and much more coverage in a separate supplement on how to implement databases with Access. In every chapter, the author covers concepts first, then show how they're implemented in continuing case(s.) "Your Turn" boxes appear several times throughout the chapter to apply concepts to projects. And "Concepts in Action" boxes contain examples of concepts used in practice. This pedagogy is easily demonstrable and the text also includes more hands-on exercises and projects and a standard diagramming style for the data modeling diagrams. Furthermore, revised and updated content and organization includes more coverage on database control issues, earlier coverage of SQL, and new coverage on data quality issues. Read more...

Tags:    [edit]

Product Description: Clear explanations of theory and design, broad coverage of models and real systems, and an up-to-date introduction to modern database technologies result in a leading introduction to database systems. Intended for computer science majors, Fundamentals of Database Systems, 6/e emphasizes math models, design issues, relational algebra, and relational calculus.  A lab manual and problems give students opportunities to practice the fundamentals of design and implementation. Real-world examples serve as engaging, practical illustrations of database concepts. The Sixth Edition maintains its coverage of the most popular database topics, including SQL, security, and data mining, and features increased emphasis on XML and semi-structured data. Read more...

Tags:    [edit]

Product Description: Control Intellectual Property, and Avoid Information Overload Glean actionable business information from your "digital landfill" by deploying a flexible, cost-effective content management framework across your entire organization. Transforming Infoglut!: A Pragmatic Strategy for Oracle Enterprise Content Management details, step-by-step, how to rein in the current data explosion and gain the competitive edge. Get tips for building an enterprise content management (ECM) team, centralizing storage, finding and managing information, incorporating legacy systems, and handling unstructured content. You''ll also learn how to secure your system, optimize performance, and ensure regulatory compliance. * Design and manage a dynamic Oracle ECM infrastructure * Consolidate corporate data using Oracle Universal Content Management * Implement a flexible, scalable, and extensible middleware layer * Centralize storage with Oracle Universal Records Management Suite * Encrypt and secure data enterprise-wide using Oracle Information Rights Management * Integrate Oracle WebCenter Services and Oracle Secure Enterprise Search * Enhance structured enterprise applications with unstructured content * Extend ECM functionality using cutting-edge Enterprise 2.0 tools Read more...

Tags:    [edit]

Mobile communications and ubiquitous computing generate large volumes of data. Mining this data can produce useful knowledge, yet individual privacy is at risk. This book investigates the various scientific and technological issues of mobility data, open problems, and roadmap. The editors manage a research project called GeoPKDD, Geographic Privacy-Aware Knowledge Discovery and Delivery, and this book relates their findings in 13 chapters covering all related subjects. Read more...

Tags:    [edit]

Product Description: The LNCS Journal on Data Semantics is devoted to the presentation of notable work that, in one way or another, addresses research and development on issues related to data semantics. The scope of the journal ranges from theories supporting the formal definition of semantic content to innovative domain-specific applications of semantic knowledge. Read more...

Tags:    [edit]

Product Description: A data-driven, fact-based, quantitative text on Oracle performance and scalability With database concepts and theories clearly explained in Oracle''s context, readers quickly learn how to fully leverage Oracle''s performance and scalability capabilities at every stage of designing and developing an Oracle-based enterprise application. The book is based on the author''s more than ten years of experience working with Oracle, and is filled with dependable, tested, and proven performance optimization techniques. Oracle Database Performance and Scalability is divided into four parts that enable readers to progressively learn and apply new skills: * Part 1, Getting Started with Oracle, describes how to set up a working Oracle environment, offering a quick tour to illustrate major database concepts * Part 2, Oracle Architecture from Performance and Scalability Perspectives, explains all the major database concepts and architectural features that readers need to know to optimize Oracle performance and scalability * Part 3, Optimizing Oracle Performance and Scalability, offers hands-on instructions to optimize and fine-tune performance and scalability for all database applications * Part 4, Case Studies: Oracle Meeting Real-World Performance and Scalability Challenges, sets forth quantitative case studies based on the author''s first-hand experience that demonstrate how readers can apply proven techniques to dramatically improve the p Read more...

Tags:    [edit]

Product Description: This lecture covers several core issues in user-centered data management, including how to design usable interfaces that suitably support database tasks, and relevant approaches to visual querying, information visualization, and visual data mining. Novel interaction paradigms, e.g., mobile and interfaces that go beyond the visual dimension, are also discussed. Table of Contents: Why User-Centered / The Early Days: Visual Query Systems / Beyond Querying / More Advanced Applications / Non-Visual Interfaces / Conclusions Read more...

Tags:    [edit]

This three-volume-set (CCIS 219, CCIS 220, and CCIS 221) constitutes the refereed proceedings of the International Conference on ENTERprise Information Systems, CENTERIS 2011, held in Vilamoura, Portugal, in September 2011. The approx. 120 revised full papers presented in the three volumes were carefully reviewed and selected from 180 submissions. The papers are organized in topical sections on knowledge society, EIS adoption and design, EIS implementation and impact, EIS applications, social aspects and IS in education, IT/IS management, telemedicine and imaging technologies, healthcare information management, medical records and business processes, decision support systems and business intelligence in health and social care contexts, architectures and emerging technologies in healthcare organizations, as well as m-health. Read more...

Tags:    [edit]

This three-volume-set (CCIS 219, CCIS 220, and CCIS 221) constitutes the refereed proceedings of the International Conference on ENTERprise Information Systems, CENTERIS 2011, held in Vilamoura, Portugal, in September 2011. The approx. 120 revised full papers presented in the three volumes were carefully reviewed and selected from 180 submissions. The papers are organized in topical sections on knowledge society, EIS adoption and design, EIS implementation and impact, EIS applications, social aspects and IS in education, IT/IS management, telemedicine and imaging technologies, healthcare information management, medical records and business processes, decision support systems and business intelligence in health and social care contexts, architectures and emerging technologies in healthcare organizations, as well as m-health. Read more...

Tags:    [edit]

Written by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples. Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you ll learn the essential tools and techniques for developing robust applications. Discover how to: -Program views, stored applications, triggers, and functions using T-SQL -Work with the new data types, LINQ, and the ADO.NET Entity Framework -Automate common administration and maintenance tasks -Debug databases, reports, and objects using Microsoft Visual Studio 2008 -Write transactional code and implement local and distributed transactions -Use business intelligence tools, such as SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services Many of the book s examples, exercises, and code samples are available for download from the companion Web site. Read more...

Tags:    [edit]

Product Description: This book constitutes the refereed proceedings of the 7th International Workshop on Databases in Networked Information Systems, DNIS 2011, held in Aizu-Wakamatsu, Japan in December 2011. The 18 revised full papers presented together with 6 invited talks and 1 keynote lecture were carefully reviewed and selected for inclusion in the book. The workshop generally puts the main focus on data semantics and infrastructure for information management and interchange. The papers are organized in topical sections on cloud computing access to information resources information and knowledge management bio-medical information management information extraction from data resources geo-spatial decision making networked information systems: infrastructure. Read more...

Tags:    [edit]

Product Description: Data Intensive Computing refers to capturing, managing, analyzing, and understanding data at volumes and rates that push the frontiers of current technologies. The challenge of data intensive computing is to provide the hardware architectures and related software systems and techniques which are capable of transforming ultra-large data into valuable knowledge. Handbook of Data Intensive Computing is written by leading international experts in the field. Experts from academia, research laboratories and private industry address both theory and application. Data intensive computing demands a fundamentally different set of principles than mainstream computing. Data-intensive applications typically are well suited for large-scale parallelism over the data and also require an extremely high degree of fault-tolerance, reliability, and availability. Real-world examples are provided throughout the book. Handbook of Data Intensive Computing is designed as a reference for practitioners and researchers, including programmers, computer and system infrastructure designers, and developers. This book can also be beneficial for business managers, entrepreneurs, and investors. Read more...

Tags:    [edit]

Product Description: A complete and comprehensive handbook for the application of data mining techniques in marketing and customer relationship management. It combines a technical and a business perspective, bridging the gap between data mining and its use in marketing.   It guides readers through all the phases of the data mining process, presenting a solid data mining methodology, data mining best practices and recommendations for the use of the data mining results for effective marketing. It answers the crucial question of 'what data to use' by proposing mining data marts and full lists of KPIs for all major industries.Data mining algorithms are presented in a simple and comprehensive way for the business users along with real-world application examples from all major industries. The book is mainly addressed to marketers, business analysts and data mining practitioners who are looking for a how-to guide on data mining. It presents the authors' knowledge and experience from the "data mining trenches", revealing the secrets for data mining success. Read more...

Tags:    [edit]

MCSE Training Guide: SQL Server Implementation provides users with all of the latest information they need to pass this popular exam and covers all the intracacies of the latest version of SQL Server. Utilizing the knowledge of MCSEs and MCTs, this book contains all the insider tips, notes, and strategies readers need to take a step closer to becoming an MCSE.The book contains hundreds of test questions, lists, tables, notes, tips and tricks to completely prepare readers for the exam. It's organized in a concise, easy-to-read manner to give users the most valuable information efficiently. This book inexpensive and is the fastest, most effective tool for passing the SQL Server Implementation exa Hundreds of practice test questions and hands-on lab exercises allow readers to apply what they've learned-right away!. Solid information, insider tips, and the exclusive TestPrep test engine on the CD-ROM, make this the only book readers need to pass this popular elective exam!. This book is for any network administrator, computer technology professional or certification candid. Read more...

Tags:    [edit]

Product Description: Myths about object-oriented databases are rampant. This book debunks them, so database administrators and managers can make informed decisions about the technology.This book presents comprehensive coverage of the "pros and cons" of object-oriented databases, helping managers and administrators decide whether to implement this powerful technology. Through 18 case studies written by expert practitioners, learn how to identify the right applications for OODBMS systems, and understand the hardware requirements and technical tradeoffs involved. The book also includes many never-before-published tips, tricks and techniques for successfully designing and implementing OODBMS in your organization.All database practitioners considering object-oriented database management systems. Read more...

Tags:    [edit]

Using this book can help the busy architect/engineer/contractor to optimize online time by determining the key sites to visit before connecting to the Internet. Topics are conveniently arranged by subject showing where to find the "index sites" together with details of many specialist sites. Read more...

Tags:    [edit]

Product Description: DB2 Universal Database (UDB) supports many different types of applications, on many different kinds of data, in many different software and hardware environments. This book provides a complete guide to DB2 UDB Version 5 in all its aspects, including the interfaces that support end users, application developers, and database administrators. It is complementary to the IBM product documentation, providing a clear and informal explanation of how the features of DB2 were intended to be used. It is an extensive revision of the author's earlier book, Using the New DB2: IBM's Object-Relational Database System. * Offers complete and self-contained information, and does not assume prior knowledge of DB2, SQL, or relational database concepts * Covers elementary principles of database management as well as the advanced features of UDB, including recursive queries, constraints, triggers, user-defined datatypes, stored procedures, parallel databases, and graphical tools for database administration * Includes dozens of practical tips that will save readers many hours of work in developing database applications * Provides hundreds of tested examples written in SQL, C, C++, and Java, all of which are available on the MKP web site Read more...

Tags:    [edit]

Product Description: Are you responsible for designing and creating the databases that keep your business running? Or are you studying for a module in database design? If so, Database Solutions is for you! This fully revised and updated edition will make the database design and build process smoother, quicker and more reliable. Recipe for database success * Take one RDMS -- any of the major commercial products will do: Oracle, Informix, SQL Server, Access, Paradox * Add one thorough reading of Database Solutions if you are an inexperienced database designer, or one recap of the methodology if you are an old hand * Use the design and implementation frameworks to plan your timetable, use a common data model that fits your requirements and adapt as necessary Read more...