Applied Mathematics for Database Professionals

Applied Mathematics for Database Professionals
Author: Lex deHaan
Publisher: Apress
Total Pages: 389
Release: 2007-10-24
Genre: Computers
ISBN: 143020348X

This book touches on an area seldom explored: the mathematical underpinnings of the relational database. The topic is important, but far too often ignored. This is the first book to explain the underlying math in a way that’s accessible to database professionals. Just as importantly, if not more so, this book goes beyond the abstract by showing readers how to apply that math in ways that will make them more productive in their jobs. What’s in this book will "open the eyes" of most readers to the great power, elegance, and simplicity inherent in relational database technology.

DBASE IV

DBASE IV
Author: Kerman D. Bharucha
Publisher:
Total Pages: 640
Release: 1989
Genre: Computers
ISBN:

Database Tuning

Database Tuning
Author: Dennis Shasha
Publisher: Elsevier
Total Pages: 441
Release: 2002-06-07
Genre: Computers
ISBN: 0080503780

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one. - Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner - Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM) - Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis - Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment - Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series - Describes performance-monitoring techniques that will help you recognize and troubleshoot problems

Microsoft Jet Database Engine Programmer's Guide

Microsoft Jet Database Engine Programmer's Guide
Author: Dan Haught
Publisher:
Total Pages: 628
Release: 1995
Genre: Computers
ISBN: 9781556158773

This is the official technical reference on Jet, the powerful database engine used in Microsoft Access and Visual Basic for Windows 95. The book starts by describing what Jet is, how to use it, and how it compares to other databases. Each chapter includes a simple Basic program that it builds upon within the chapter to illustrate points. CD includes the Jet Database Engine.

Databases for Small Business

Databases for Small Business
Author: Anna Manning
Publisher: Apress
Total Pages: 319
Release: 2015-11-21
Genre: Computers
ISBN: 1484202775

This book covers the practical aspects of database design, data cleansing, data analysis, and data protection, among others. The focus is on what you really need to know to create the right database for your small business and to leverage it most effectively to spur growth and revenue. Databases for Small Business is a practical handbook for entrepreneurs, managers, staff, and professionals in small organizations who are not IT specialists but who recognize the need to ramp up their small organizations’ use of data and to round out their own business expertise and office skills with basic database proficiency. Anna Manning—a data scientist who has worked on database design and data analysis in a computer science university research lab, her own small business, and a nonprofit—walks you through the progression of steps that will enable you to extract actionable intelligence and maximum value from your business data in terms of marketing, sales, customer relations, decision making, and business strategy. Dr. Manning illustrates the steps in the book with four running case studies of a small online business, an engineering startup, a small legal firm, and a nonprofit organization. Databases for Small Business teaches non-techie entrepreneurs and professionals how to: Design a small business database from scratch Extract the maximum profit from your data Follow guidance on data protection law Effectively use data collection and data cleansing techniques Train staff to leverage your data

Database Development and Management

Database Development and Management
Author: Lee Chao
Publisher: CRC Press
Total Pages: 607
Release: 2006-01-13
Genre: Computers
ISBN: 1420003348

Today's database professionals must understand how to apply database systems to business processes and how to develop database systems for both business intelligence and Web-based applications. Database Development and Management explains all aspects of database design, access, implementation, application development, and management, as well

Beginning Database Design Solutions

Beginning Database Design Solutions
Author: Rod Stephens
Publisher: John Wiley & Sons
Total Pages: 576
Release: 2010-12-30
Genre: Computers
ISBN: 047044052X

The vast majority of software applications use relational databases that virtually every application developer must work with. This book introduces you to database design, whether you're a DBA or database developer. You'll discover what databases are, their goals, and why proper design is necessary to achieve those goals. Additionally, you'll master how to structure the database so it gives good performance while minimizing the chance for error. You will learn how to decide what should be in a database to meet the application's requirements.

Practical Issues in Database Management

Practical Issues in Database Management
Author: Fabian Pascal
Publisher: Addison-Wesley Professional
Total Pages: 296
Release: 2000
Genre: Computers
ISBN:

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

Beginning Database Design

Beginning Database Design
Author: Clare Churcher
Publisher: Apress
Total Pages: 241
Release: 2012-08-08
Genre: Computers
ISBN: 1430242108

Beginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, you’ll learn to discover and represent the details and scope of any design problem you choose to attack. Database design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. Beginning Database Design, Second Edition helps you ask and answer important questions about your data so you can understand the problem you are trying to solve and create a pragmatic design capturing the essentials while leaving the door open for refinements and extension at a later stage. Solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep a design simple, but allow room for development as situations change or resources permit. Provides solid design principles by which to avoid pitfalls and support changing needs Includes numerous examples of good and bad design decisions and their consequences Shows a modern method for documenting design using the Unified Modeling Language