| |||||
Books: Computers: Informix
Access 2003 Bibleby Cary N. Prague, Michael R. Irwin, and Jennifer Reardon List Price: $49.99 Available from Amazon $31.49 On 7-22-2006 
See Item's Page Book Description
Back Cover Copy If Access 2003 can do it, you can do it too Databases can be complex. That’s why you need the expert guidance in this comprehensive reference manual to help you harness their power with a solid understanding of database purpose, construction, and application. If this is your first encounter with Access, you’ll appreciate the thorough attention to database fundamentals and terminology. If you’re familiar with earlier versions, you can jump right into Access 2003 enhancements like wider use of XML and Web services. Inside, you’ll find complete coverage of Access 2003
Bonus CD-ROM and companion Web site!
|
Informix SQL Reference Libraryby Informix Software and Informix Software Available from Amazon $69.31 On 7-22-2006 
See Item's Page Back Cover Copy
Informix® Guide to SQL: Reference and Syntax, Second Edition: the complete guide and syntax reference for the Informix implementation of SQL Informix® Guide to SQL: Tutorial, Second Edition: the start-to-finish SQL tutorial for development on Informix platforms Informix® Guide to Designing Databases and Data Warehouses: the insider's guide to real-world database design — detailed data models, proven step-by-step techniques, and more The total resource for Informix developers & DBAs: 3 authoritative books, direct from Informix! (1)Informix® Guide to SQL: Reference and Syntax, Second Edition The indispensable reference to the Informix implementation of SQL! Informix Guide to SQL: Reference and Syntax, Second Edition contains comprehensive descriptions of every SQL and Stored Procedure Language (SPL) statement, plus extensive SQL syntax coverage not included in the first edition. Detailed syntax diagrams walk you through every clause of each SQL statement, and syntax tables explain the input parameters for each clause. Coverage Includes:
(2)Informix® Guide to SQL: Tutorial, Second Edition Master the Informix implementation of SQL, start-to-finish! Informix Guide to SQL: Tutorial, Second Edition is the authoritative, complete tutorial for learning the Informix implementation of SQL. Starting with the simplest SELECT statements, this complete course walks you through everything you need to know to succeed with SQL. Learn how to build and optimize queries, both simple and advanced. Use SQL statements to insert, delete, or update data, while you maintain data integrity and security. Learn how to call the database server, retrieve rows, embed data, and create and implement efficient data models, step-by-step. Coverage Includes:
(3)Informix® Guide to Designing Databases and Data Warehouses The Informix insider's guide to database and data warehouse design! Informix Guide to Designing Databases and Data Warehousesis the most complete, authoritative guide to database and data warehouse design, implementation, and administration with Informix Dynamic Server.2000 and Informix Enterprise Decision Server. You'll start by walking through the construction of data models that illustrate each key approach to database design. Compare ANSI and non-ANSI compliant databases, learn the fundamentals of entity-relationship modeling, and choose appropriate data types. Next, you'll learn how to use the Informix implementation of SQL to implement and manage your databases. Coverage Includes:
|
Informix Guide to Designing Databases and Data Warehousesby Informix Software Available from Amazon $2.97 On 7-22-2006
See Item's Page Book Info Provides an authoritative database design guide for Informix Dynamic Server 2000 and Informix Enterprise Decision Server. Proven, step-by-step techniques for building your Informix-based data warehouse are included. Softcover. From the Inside Flap INTRODUCTIONIn This Introduction Read this introduction for an overview of the information provided in this book and for an understanding of the documentation conventions used. About This Book This book provides information to help you design, implement, and manage your Informix databases. It includes data models that illustrate different approaches to database design and shows you how to use structured query language (SQL) to implement and manage your databases. This book is one of several manuals that discuss the Informix implementation of SQL. The Informix Guide to SQL: Tutorial, Second Edition shows how to use basic and advanced SQL and SPL routines to access and manipulate the data in your databases. The Informix Guide to SQL: Reference and Syntax, Second Edition provides reference information for aspects of SQL other than the language statements and contains all the syntax descriptions for SQL and Stored Procedure Language (SPL). Types of Users This book is for the following users: Database administrators Database server administrators Database-application programmers This book assumes that you have the following background: A working knowledge of your computer, your operating system, and the utilities that your operating system provides Some experience working with relational databases or exposure to database concepts Some experience with computer programming If you have limited experience with relational databases, SQL, or your operating system, refer to the Getting Started manual for your database server for a list of supplementary titles.Software Dependencies This book assumes that you are using one of the following database servers: Informix Enterprise Decision Server, Version 8.3 Informix Dynamic Server 2000, Version 9.2Assumptions About Your Locale Informix products can support many languages, cultures, and code sets. All culture-specific information is brought together in a single environment, called a Global Language Support (GLS) locale. This book assumes that you use the U.S. 8859-1 English locale as the default locale. The default is en_us.8859-1 (ISO 8859-1) on UNIX platforms or en_us.1252 (Microsoft 1252) for Windows NT environments. This locale supports U.S. English format conventions for dates, times, and currency, and also supports the ISO 8859-1 or microsoft 1252 code set, which includes the ASCII code set plus many 8-bit characters such as é, è, and ñ. If you plan to use nondefault characters in your data or your SQL identifiers, or if you want to conform to the nondefault collation rules of character data, you need to specify the appropriate nondefault locale. If you plan to use nondefault characters in your data or your SQL identifiers, or if you want to conform to the nondefault collation rules of character data, you need to specify the appropriate nondefault locale. Demonstration Databases The DB-Access utility, which is provided with your Informix database server products, includes one or more of the following demonstration databases: The stores_demo database illustrates a relational schema with information about a fictitious wholesale sporting-goods distributor. Many examples in Informix manuals are based on the stores_demo database. The sales_demo database illustrates a dimensional schema for data-warehousing applications. For conceptual information about dimensional data modeling, see Chapter 10, "Building a Dimensional Data Model." The superstores_demo database illustrates an object-relational schema. The superstores_demo database includes examples of extended data types, type and table inheritance, and user-defined routines. For information about how to create and populate the demonstration databases, see the DB-Access User's Manual. For descriptions of the databases and their contents, see the Informix Guide to SQL: Reference. The scripts that you use to install the demonstration databases reside in the $INFORMIXDIR/bin directory on UNIX platforms and in the %INFORMIXDIR%\bin directory in Windows environments.New Features For a comprehensive list of new database server features, see the release notes. This section lists new features relevant to this manual.New Features in Version 8.3 This book describes the following new SQL functionality in Version 8.3 of Enterprise Decision Server: RANGE fragmentation Globally detached indexesNew Features in Version 9.2 This book describes new features in Version 9.2 of Dynamic Server. The features fall into the following areas: Extensibility enhancements Version 9.2 features from Version 7.30 of Dynamic ServerExtensibility Enhancements This book describes the following extensibility enhancements to Version 9.2 of Dynamic Server: General enhancements to SQL: nested dot expressions for row types Enhancements to smart large objects: Round-robin fragmentation for smart large objects ALTER TABLE for smart large objects Data type conversion: BYTE to BLOB and TEXT to CLOB Enhancements to collections: Collection constructors that use arbitrary expression elements Enhancements to row types: Serial types in row types GRANT/REVOKE UNDER on row types Version 9.2 Features from Dynamic Server 7.30 This book also describes features first released in Version 7.30 of Dynamic Server. These features fall into the following areas: Reliability, availability, and serviceability: ALTER FRAGMENT ATTACH/DETACH enhancements In-place ALTER TABLE MODIFY/DROP (for built-in types) Application migration: UNION operator in CREATE VIEW statementAdditional Documentation For additional information, you might want to refer to the following types of documentation: On-line manuals Printed manuals Error message documentation Documentation notes, release notes, and machine notes Related readingOn-Line Manuals An Answers OnLine CD that contains Informix manuals in electronic format is provided with your Informix products. You can install the documentation or access it directly from the CD. For information about how to install, read, and print on-line manuals, see the installation insert that accompanies Answers OnLine. Informix on-line manuals are also available on the following Web site:informix/answersPrinted Manuals To order printed manuals, call 1-800-331-1763 or send email to moreinfo@informix. Please provide the following information when you place your order: The documentation that you need The quantity that you need Your name, address, and telephone numberOn-Line Help Informix provides on-line help with each graphical user interface (GUI) that displays information about those interfaces and the functions that they perform. Use the help facilities that each GUI provides to display the on-line help.Error Message Documentation Informix software products provide ASCII files that contain all of the Informix error messages and their corrective actions. To read error messages and corrective actions on UNIX, use one of the following utilities. Utility Description finderr Displays error messages on line rofferr Formats error messages for printing To read error messages and corrective actions in Windows, use the Informix Find Error utility. To display this utility, choose Start->Programs->Informix from the Task Bar. Instructions for using the preceding utilities are available in Answers OnLine. Answers OnLine also provides a listing of error messages and corrective actions in HTML format.Documentation Notes, Release Notes, Machine Notes In addition to printed documentation, the following sections describe the on-line files that supplement the information in this book. Please examine these files before you begin using your database server. They contain vital information about application and performance issues. On UNIX, the following on-line files appear in the $INFORMIXDIR/release/en_us/0333 directory. Replace x.y in the filenames with the version number of your database server. On-Line File Purpose DDIDOC_x.y The documentation notes file for your version of this manual describes topics that are not covered in the manual or that were modified since publication. SERVERS_x.y The release notes file describes feature differences from earlier versions of Informix products and how these differences might affect current products. This file also contains information about any known problems and their workarounds. IDS_x.y or IDS_EDS_x.y The machine notes file describes any special actions that you must take to configure and use Informix products on your computer. Machine notes are named for the product described. The following items appear in the Informix folder. To display this folder, choose Start->Programs->Informix from the Task Bar. Program Group Item Description Documentation Notes This item includes additions or corrections to manuals and information about features that might not be covered in the manuals or that have been modified since publication. Release Notes This item describes feature differences from earlier versions of Informix products and how these differences might affect current prod
|
The Informix Database Administrator's Survival Guideby Joe Lumbley Available from Amazon $3.80 On 7-22-2006
See Item's Page Book Description Designed to help ease novice Informix OnLine 5.0 database administrators comfortably into the job, this innovative guidebook pulls together information that is scattered across volumes of system documentation and that is based on first-hand experience in the workplace. It covers all aspects of day-to-day database administration -- both technical and political -- and includes everything from samples of helpful source code and tips on using utilities to monitor and tune the database, to suggestions on how to handle different types of people and deal with office politics. Covers DBA job functions, interfacing with peers; understanding the OnLine architecture, logging, archives, and utilities; specific tasks; common DBA tasks; tuning the database; and custom tools for the DBA. Features a collection of programs helpful to the DBA in managing the database -- programs for monitoring the status of the database, for monitoring logfile usage, for running archives in the background, and for monitoring the size and extent usage of database tables. An accompanying diskette contains the source code for all of the programs and scripts in the book. For novice Informix OnLine 5.0 database administrators. The publisher, Prentice-Hall ECS Professional Designed to help ease novice Informix OnLine database administrators comfortably into the job, this innovative guidebook pulls together information that is scattered across volumes of system documentation. Based on first-hand experience in the workplace, it covers all aspects of day-to-day database administration -- both technical and political -- and includes everything from samples of helpful source code and tips on using utilities to monitor and tune the database, to suggestions on how to handle different types of people and deal with office politics. |
Optimizing Informix Applications (Informix Series)by Robert D. Schneider Available from Amazon $67.00 On 7-22-2006
See Item's Page From the Inside Flap Intended audience Informix tools and engines let you quickly build powerful and reliable database applications. This alone is often not enough; users also demand high performance. It takes skill and experience to produce such high- quality systems, but many Information Systems (IS) professionals don't have the time to learn the intricacies of Informix products. Optimizing Informix Applications gives you the insight you need to produce the fast database applications your users want. Optimizing Informix Applications is a tool for application developers, database administrators, systems analysts, and system administrators who are interested in designing, developing, maintaining, and administering efficient applications that use Informix database engines and tools. To get the most out of this book, programmers and analysts should be comfortable with: * Basic Structured Query Language (SQL). * A procedural programming language, such as C, COBOL, or 4GL. Database administrators should understand: * Relational database design concepts. * Intermediate or advanced SQL. * Informix engine architecture. System administrators should understand: * Informix engine architecture. * The UNIX operating system at an intermediate level. Benefits of Using This Book Optimizing Informix Applications provides you with these benefits: * Enhanced productivity. It's hard for a user to be productive if a typical query takes three minutes to return data. End-of-week reports that take 36 hours to run generally don't lead to a more robust bottom line, either. In this book, we cite dozens of specific changes you can make to your applications and systems to upgrade your organization's productivity. * Increased application reliability. Generally, an inefficient application is an unreliable application. At the very least, slow systems are perceived as being less reliable than fast systems. When you increase a system's speed, you will improve its reliability. * Reduced hardware expenditures. Few organizations can afford to continually upgrade their hardware environments to get better performance. Therefore, they expect their IS staff to do more with less. You can use the suggestions in this book to squeeze extra speed out of your existing hardware. * Simpler applications. In many cases, the simplest solution is the fastest solution. You will find many tips in this book to help you increase a system's speed while reducing its complexity. * More satisfied users. In the past, most users were mainly concerned with whether a system worked; performance wasn't a major consideration. Today's users are more sophisticated than ever, and view system speed as the crucial element. Many organizations have learned this painful lesson the hard way, when users don't approve a slow system, no matter how well-designed. How to Use This Book This book is divided into five major sections: 1. Introduction. In this chapter, we discuss how you can best use this book, as well as how to set up the most effective optimization test environment. 2. Creating a Well-Designed Database. Your entire application relies on an efficient database design. In this chapter, we Review some of the most important facets of a good database design. 3. Optimizing Application Code. This chapter describes how to write efficient database application code, using a variety of programming languages. 4. Tuning the Database Engine. Even the most efficient application can be sluggish if the underlying database engine is tuned incorrectly. In this chapter, we Review many techniques you can use to make your database engine run as rapidly as possible. 5. Case Studies. This chapter contains five case studies. Each case study features several interrelated problems. You don't need to read this book from cover to cover. To get the most benefit from our suggestions, Review only those sections that apply to your particular situation. For example, if you are running a distributed ESQL/C application that uses the OnLine engine, you really don't need to spend much time reading the sections about 4GL or Informix-SE. However, there are several sections that deserve your attention, regardless of your situation. These include: * Setting Up an Optimization Test Environment. It is a big mistake to rush in and start making performance enhancement changes to your system without first observing a few very important details. This section covers these details. * General Tips. This section contains numerous suggestions that can help you develop better, faster applications, no matter what engine or tools you use. * Relational Database Design Concepts. A good database design is the foundation of a system that performs well. This section teaches you how to implement the relational model when you design a database. It also covers specific situations where the relational model is not appropriate. * Indexing Strategies. The wrong indexing strategy can wreck an otherwise perfect database design. We list some straightforward indexing techniques you can use to dramatically raise your system's throughput. * SQL Tips. Without SQL, you can't access data. In this section, we cite several ideas you can incorporate to improve your SQL statements. * Case Studies. This chapter contains a number of multi-faceted case studies. Spend some time Reviewing them: chances are, you may already have experienced some of the problems we illustrate. How to Use the Examples You'll find numerous examples in each chapter, which we have made as clear and concise as possible. This will help you implement our suggestions quickly. Because this book is intended as a reference, the examples in one chapter do not rely on another. This will help you concentrate on specific problems and solutions. Keep in mind that while the examples in this book may not exactly match your database design, application software, and/or engine configuration, you can still apply them to your specific problems. Setting Up An Optimization Test Environment When faced with a sluggishly performing application, or an engine that appears out of tune, most administrators and programmers are eager to roll up their sleeves, and begin the optimizing process. Unfortunately, there are a number of potentially tiresome, yet very important steps that you must first take before you begin the "real work" of tuning. If you don't set up a stable, accurate test environment, you face the very real risk of making inaccurate judgments about the root cause(s) of your system's current woeful performance. You might then use these incorrect assumptions as the base of an entire action plan, only to later learn that your original hypotheses were wrong. In this section, we address these important issues. We've divided the section into three major parts. The first deals with the agenda you should cover before you even begin your testing efforts. This includes ensuring that the right hardware, operating system, database, and application software are in place. In addition, we discuss some organizational issues that you should address immediately at the start of the optimization. Next, we spell out some methods that you can use to help point the way while your testing is going on. While the most successful system testers and tuners rely heavily on their test plan to guide them during this process, they also choose the right blend of discipline and creativity when following up on new, promising performance leads. Finally, we illustrate how you can translate the knowledge that you gained during testing process into real performance improvements. While this section is primarily designed for people tuning existing systems and applications, you can still apply these suggestions if you're doing new development. In fact, one way to help guarantee a production system that meets your standards is to treat good performance as one of the most important development deliverables. Steps to follow before testing Hardware considerations Your hardware environment really consists of a number of different components, each of which plays a meaningful role in your overall performance picture. Let's illustrate each of these components in more detail: * CPU. Ideally, both your production and test environment have similar CPU speeds and capacities. If not, you'll always have to wonder which numbers you should believe: those from the production system, or those from the test system. The same problem often arises at multi-processor sites, where the production machine may have 12 CPUs, while the test machine has one. This really becomes a problem if you're tuning the OnLine engine, especially if you're using OnLine 6.00 or newer. * Memory. It's crucial that your test platform have the same amount of memor |
Informix SQL: Tutorial and Referenceby Tony Lacy-Thompson Available from Amazon $5.49 On 7-22-2006
See Item's Page |
The Real Story of Informix Software and Phil White: Lessons in Business and Leadership for the Executive Teamby Steve W. Martin List Price: $24.95 Available from Amazon $15.72 On 7-22-2006 
See Item's Page Book Description The Real Story of Informix software and Phil White chronicles the meteoric rise of Informix Software, how it became a billion-dollar software giant, and the scandal that ultimately led to its spectacular fall. This fascinating behind-the-scenes book offers an insiderOs perspective on the business strategies that succeeded, the products that failed, and how a technology industry titan ended up in jail. |
The Intelligent Investor Rev Ed. (Collins Business Essentials)by Benjamin Graham and Jason Zweig List Price: $19.95 Available from Amazon $11.97 On 7-22-2006 
See Item's Page Product Review Among the library of investment books promising no-fail strategies for riches, Benjamin Graham's classic, The Intelligent Investor, offers no guarantees or gimmicks but overflows with the wisdom at the core of all good portfolio management. The hallmark of Graham's philosophy is not profit maximization but loss minimization. In this respect, The Intelligent Investor is a book for true investors, not speculators or day traders. He provides, "in a form suitable for the laymen, guidance in adoption and execution of an investment policy" (1). This policy is inherently for the longer term and requires a commitment of effort. Where the speculator follows market trends, the investor uses discipline, research, and his analytical ability to make unpopular but sound investments in bargains relative to current asset value. Graham coaches the investor to develop a rational plan for buying stocks and bonds, and he argues that this plan must be a bulwark against emotional behavior that will always be tempting during abrupt bull and bear markets. Since it was first published in 1949, Graham's investment guide has sold over a million copies and has been praised by such luminaries as Warren E. Buffet as "the best book on investing every written." These accolades are well deserved. In its new form--with commentary on each chapter and extensive footnotes prepared by senior Money editor, Jason Zweig--the classic is now updated in light of changes in investment vehicles and market activities since 1972. What remains is a better book. Graham's sage advice, analytical guides, and cautionary tales are still valid for the contemporary investor, and Zweig's commentaries demonstrate the relevance of Graham's principles in light of 1990s and early twenty-first century market trends. --Patrick O'Kelley
|
Additional Pages: 1 2
Other Shops:
Books
Resources
Most Watched Book Auctions
Informix at Sduf
Book Review Directory
Reviewed Authors
Reviewed Titles
Review List
Site Map
