PostgreSQL Essential Reference


Book Description

A hands-on solution provider to PostgreSQL. Expert advice by a highly respected author within the PostgreSQL user community, this book provides detailed, useable information in the popular Essential Reference format. Includes tables within each chapter that organize the material both alphabetically and by task so that readers will have two options for finding the information.




Data Management for Researchers


Book Description

A comprehensive guide to everything scientists need to know about data management, this book is essential for researchers who need to learn how to organize, document and take care of their own data. Researchers in all disciplines are faced with the challenge of managing the growing amounts of digital data that are the foundation of their research. Kristin Briney offers practical advice and clearly explains policies and principles, in an accessible and in-depth text that will allow researchers to understand and achieve the goal of better research data management. Data Management for Researchers includes sections on: * The data problem – an introduction to the growing importance and challenges of using digital data in research. Covers both the inherent problems with managing digital information, as well as how the research landscape is changing to give more value to research datasets and code. * The data lifecycle – a framework for data’s place within the research process and how data’s role is changing. Greater emphasis on data sharing and data reuse will not only change the way we conduct research but also how we manage research data. * Planning for data management – covers the many aspects of data management and how to put them together in a data management plan. This section also includes sample data management plans. * Documenting your data – an often overlooked part of the data management process, but one that is critical to good management; data without documentation are frequently unusable. * Organizing your data – explains how to keep your data in order using organizational systems and file naming conventions. This section also covers using a database to organize and analyze content. * Improving data analysis – covers managing information through the analysis process. This section starts by comparing the management of raw and analyzed data and then describes ways to make analysis easier, such as spreadsheet best practices. It also examines practices for research code, including version control systems. * Managing secure and private data – many researchers are dealing with data that require extra security. This section outlines what data falls into this category and some of the policies that apply, before addressing the best practices for keeping data secure. * Short-term storage – deals with the practical matters of storage and backup and covers the many options available. This section also goes through the best practices to insure that data are not lost. * Preserving and archiving your data – digital data can have a long life if properly cared for. This section covers managing data in the long term including choosing good file formats and media, as well as determining who will manage the data after the end of the project. * Sharing/publishing your data – addresses how to make data sharing across research groups easier, as well as how and why to publicly share data. This section covers intellectual property and licenses for datasets, before ending with the altmetrics that measure the impact of publicly shared data. * Reusing data – as more data are shared, it becomes possible to use outside data in your research. This chapter discusses strategies for finding datasets and lays out how to cite data once you have found it. This book is designed for active scientific researchers but it is useful for anyone who wants to get more from their data: academics, educators, professionals or anyone who teaches data management, sharing and preservation. "An excellent practical treatise on the art and practice of data management, this book is essential to any researcher, regardless of subject or discipline." —Robert Buntrock, Chemical Information Bulletin




Concise Guide to Databases


Book Description

This easy-to-read textbook/reference presents a comprehensive introduction to databases, opening with a concise history of databases and of data as an organisational asset. As relational database management systems are no longer the only database solution, the book takes a wider view of database technology, encompassing big data, NoSQL, object and object-relational and in-memory databases. The text also examines the issues of scalability, availability, performance and security encountered when building and running a database in the real world. Topics and features: presents review and discussion questions at the end of each chapter, in addition to skill-building, hands-on exercises; introduces the fundamental concepts and technologies in database systems, placing these in an historic context; describes the challenges faced by database professionals; reviews the use of a variety of database types in business environments; discusses areas for further research within this fast-moving domain.




Optimal Database Marketing


Book Description

"Destined to be the definitive guide to database marketing applications, analytical strategies and test design." - Brian Kurtz, Executive Vice President, Boardroom Inc., 2000 DMA List Leader of the Year and DMA Circulation Hall of Fame Inductee "This book is well written with interesting examples and case studies that both illustrate complex techniques and tie the chapters together. The level of detail and treatment of statistical tools and methods provides both understanding and enough detail to begin to use them immediately to target marketing efforts efficiently and effectively. It is perfect for a course in database marketing or as a handy reference for those in the industry. " - C. Samuel Craig, New York University, Stern School of Business "This book should be studied by all who aspire to have a career in direct marketing. It provides a thorough overview of all essential aspects of using customer databases to improve direct marketing results. The material is presented in a style that renders even the technical subjects understandable to the novice direct marketer" Kari Regan, Vice President, Database Marketing Services, The Reader′s Digest Association "Finally, practical information on database marketing that tackles this complex subject but makes it clear enough for the novice to understand. This book serves as more than a primer for any senior manager who needs to know the whole story. As one who has spent over 20 years of his career involved in publishing and database marketing, I have a real appreciation for how difficult it is to explain the finer points of this discipline, while keeping it understandable. This book does that admirably. Well done!" - Patrick E. Kenny, Executive Vice President, Qiosk.com "This book is especially effective in describing the breadth and impact of the database marketing field. I highly recommend this book to anyone who has anything to do with database marketing! -- works in or with this dynamic area." - Naomi Bernstein, Vice President, BMG Direct "Ron Drozdenko and Perry Drake have written a guide to database marketing that is thorough and that covers the subject in considerable depth. It presents both the concepts underlying database marketing efforts and the all-important quantitative reasoning behind it. The material is accessible to students and practitioners alike and will be an important contribution to improved understanding of this important marketing discipline. " Mary Lou Roberts, Boston University and author of Direct Marketing Management "I think it is a terrific database marketing book, it′s got it all in clear and logical steps. The benefit to the marketing student and professional is that complex database concepts are carefully developed and thoroughly explained. This book is a must for all marketing managers in understanding database issues to successfully manage and structure marketing programs and achieve maximum results. " - Dante Cirille, DMEF Board Member and Retired President, Grolier Direct Marketing "An excellent book on the principles of Direct Marketing and utilization of the customer database to maximize profits. It is one of the best direct marketing books I have seen in years in that it is broad with specific examples. I am going to require new hires to read this (book) to get a better understanding of the techniques used in Database Marketing." - Peter Mueller, Assistant Vice President of Analysis, Scholastic, Grolier Division "This is an amazingly useful book for direct marketers on how to organize and analyze database information. It′s full of practical examples that make the technical material easy to understand and apply by yourself. I strongly recommend this book to direct and interactive marketers who want to be able to perform professional database analyses themselves, or be better equipped to review the work of analysts. " - Pierre A. Passavant, Professor of Direct Marketing, Mercy College and Past Director, Center for Direct Marketing, New York University "The most useful database marketing reference guide published today. The authors do an excellent job of laying out all the steps required to plan and implement an effective database marketing strategy in a clear and concise manner. A must have for academics, marketing managers and business executives." - Dave Heneberry, Director, Direct Marketing Certificate programs, Western Connecticut State University and Past Chair, Direct Marketing Association "This book is essential for all direct marketers. It serves as a great introduction to the technical and statistical side of database marketing. It provides the reader with enough information on database marketing and statistics to effectively apply the techniques discussed or manage others in the environment " - Richard Hochhauser, President, Harte-Hanks Direct Marketing Ronald G. Drozdenko, Ph.D., is Professor and Chair of the Marketing Department, Ancell School of Business, Western Connecticut State University. He is also the founding Director of the Center for Business Research at the Ancell School. He has more than 25 years of teaching experience. The courses he teaches include Strategic Marketing Databases, Interactive/Direct Marketing Management, Product Management, Marketing Research, and Consumer Behavior. He is collaborating with the Direct Marketing Education foundation to develop a model curriculum for universities pursing the area of interactive or direct marketing. Working with an advisory board of industry experts, he co-developed the Marketing Database course in model curriculum. Dr. Drozdenko has co-directed more than 100 proprietary research projects since 1978 for the marketing and research and development of several corporations, including major multinationals. These projects were in the areas of strategic planning, marketing research, product development, direct marketing, and marketing database analysis. He also has published several articles and book chapters. He holds a Ph.D. in Experimental Psychology from the University of Missouri and is a member of the American Marketing Association, the Society for Consumer Psychology, and the Academy of Marketing Sciences. He is also the co-inventor on three U.S. patents. Perry D. Drake has been involved in the direct marketing industry for nearly 15 years. He is currently the Vice President of Drake Direct, a database marketing consulting firm specializing in response modeling, customer file segmentation, lifetime value analysis, customer profiling, database consulting, and market research. Prior to this, Perry worked for approximately 11 years in a variety of quantitative roles at The Reader′s Digest Association, most recently as the Director of Marketing Services. In addition to consulting, Perry has taught at New York University in the Direct Marketing Master′s Degree program since Fall, 1998, currently teaching "Statistics for Direct Marketers" and "Database Modeling." Perry was the recipient of the NYU Center for Direct and Interactive Marketing′s "1998-1999" Outstanding Master′s Faculty Award. Perry also lectures on testing and marketing financials for Western Connecticut State University′s Interactive Direct Marketing Certificate Program. Along with Ron, he is collaborating with the Direct Marketing Education Foundation to develop a model curriculum for universities pursuing the area of interactive or direct marketing. Perry earned a Masters of Science in Applied Statistics from the University of Iowa and a Bachelor of Science in Economics from the University of Missouri. The book evolved from an outlined developed by an advisory board of industry experts that was established by the Direct Marketing Educational Foundation. Contemporary direct marketing and e-commerce could not exist without marketing databases. Databases allow marketers to reach customers and cultivate relationships more effectively and efficiently. While databases provide a means to establish and enhance relationships, they can also be used incorrectly, inefficiently, and unethically. This book looks beyond the temptation of the quick sale to consider the long-term impact of database marketing techniques on the organization, customers, prospective customers, and society in general. Ron Drozdenko and Perry Drake help the reader gain a thorough understanding of how to properly establish and use databases in order to build strong relationships with customers. There is not another book on the market today that reveals the level of detail regarding database marketing applications - the how′s, why′s and when′s. Features/Benefits: Draws on numerous examples from real businesses Includes applications to all direct marketing media including the Internet Describes in step-by-step detail how databases are developed, maintained, and mined Considers both business and social issues of marketing databases Contains a sample database allowing the reader to apply the mining techniques Offers access to comprehensive package of academic support materials




Practical Issues in Database Management


Book Description

The aim of this work is to provide a correct and up-to-date understanding of the practical aspects of crucial, yet little- understood core database issues. The author identifies fundamental concepts, principles, and techniques and assesses the treatment of those issues in SQL (both the standard and commercial implementations) and gives advice on how to deal with them. Topics covered include complex data types, missing information, data hierarchies, and quota queries. Annotation copyrighted by Book News, Inc., Portland, OR




Implementing Database Security and Auditing


Book Description

This book is about database security and auditing. You will learn many methods and techniques that will be helpful in securing, monitoring and auditing database environments. It covers diverse topics that include all aspects of database security and auditing - including network security for databases, authentication and authorization issues, links and replication, database Trojans, etc. You will also learn of vulnerabilities and attacks that exist within various database environments or that have been used to attack databases (and that have since been fixed). These will often be explained to an "internals level. There are many sections which outline the "anatomy of an attack – before delving into the details of how to combat such an attack. Equally important, you will learn about the database auditing landscape – both from a business and regulatory requirements perspective as well as from a technical implementation perspective.* Useful to the database administrator and/or security administrator - regardless of the precise database vendor (or vendors) that you are using within your organization.* Has a large number of examples - examples that pertain to Oracle, SQL Server, DB2, Sybase and even MySQL.. * Many of the techniques you will see in this book will never be described in a manual or a book that is devoted to a certain database product.* Addressing complex issues must take into account more than just the database and focusing on capabilities that are provided only by the database vendor is not always enough. This book offers a broader view of the database environment - which is not dependent on the database platform - a view that is important to ensure good database security.




Encyclopedia of Database Technologies and Applications


Book Description

"Addresses the evolution of database management, technologies and applications along with the progress and endeavors of new research areas."--P. xiii.




Publication Manual of the American Psychological Association


Book Description

The Publication Manual of the American Psychological Association is the style manual of choice for writers, editors, students, and educators in the social and behavioral sciences, nursing, education, business, and related disciplines.




Optimal Database Marketing


Book Description

This informative book looks at the long-term impact of database marketing techniques on the organisation, customers, both actual and prospective, and society in general. The authors advise on how to use databases to build strong customer relationships.




Information Literacy for Science and Engineering Students


Book Description

This engaging handbook gives students and working scientists and engineers the information literacy skills they need to find, evaluate, and use information. Beginning with a strong foundation in the utility, structure, and packaging of information, this useful handbook helps students and working professionals decode real-world information literacy problems. Mary DeJong provides a compelling context and rationale for the skills scientists and engineers need to succeed in challenging careers that rely on the successful discovering and sharing of complex information. Students will appreciate the in-depth information on sources, especially those needed for research assignments, and scientists and engineers who write for publication will benefit from chapters on searching databases and organizing and citing sources. Written with science and engineering students and professionals in mind, this book is thorough, well-paced, engaging, and even funny.