Informix Guide to Designing Databases and Data Warehouses
Informix Guide to Designing Databases and Data Warehouses

Author: Informix Software, Inc

Publisher:

Published: 2000

Total Pages: 368

ISBN-13:

DOWNLOAD EBOOK

The complete e-business/e-commerce handbook for every decision-maker The E-Business (R)evolution is a complete handbook and briefing for every entrepreneur and executive making e-business plans. Start by understanding the six phases of e-business, from Hello, Im Online, Too through One World -- One Computer. Discover where you fit today -- and where you should be. Build the case for e-business and e-commerce; then learn how to choose the right technologies, avoid the legal (and other) pitfalls of e-business; and much more. Coverage includes: * Planning for e-business: back office systems, technology choices, ISPs, and architecture * Marketing that works: personalization, content, affiliates, localization, promotion, advertising, measurement, and more * Building sticky sites: how to attract and retain customers * Search engines, corporate portals, intelligent agents, and beyond * Internet-based shopping, procurement, and operations technologies - and their business implications * What you need to know about Web security Daniel Amor offers fresh insight into the significance of each new e-business technology, from Web application servers to XML, open source to Internet chat. He

Data Warehousing with the Informix Dynamic Server
Data Warehousing with the Informix Dynamic Server

Author: Chuck Ballard

Publisher: IBM Redbooks

Published: 2009-12-10

Total Pages: 478

ISBN-13: 0738433845

DOWNLOAD EBOOK

The IBM Informix® Dynamic Server (IDS) has the tools to build a powerful data warehouse infrastructure platform to lower costs and increase profits by doing more with your existing operational data and infrastructure. The Informix Warehouse Feature simplifies the process for design and deployment of a high performance data warehouse. With a state-of-the-art extract, load, and transform (ELT) tool and an Eclipse-based GUI environment that is easy to use, this comprehensive platform provides the foundation you need to cost effectively build and deploy the data warehousing infrastructure, using the IBM Informix Dynamic Server, and needed to enable the development and use of next-generation analytic solutions . This IBM® Redbooks® publication describes the technical information and demonstrates the functions and capabilities of the Informix Dynamic Server Warehouse Feature. It can help you understand how to develop a data warehousing architecture and infrastructure to meet your particular requirements, with the Informix Dynamic Server. It can also enable you to transform and manage your operational data, and use it to populate your data warehouse. With that new data warehousing environment, you can support the data analysis and decision-making that are required as you monitor and manage your business processes, and help you meet your business performance management goals, objectives, and measurements.

Designing Quality Databases with IDEF1X Information Models
Designing Quality Databases with IDEF1X Information Models

Author: Thomas A. Bruce

Publisher: Dorset House Publishing Company, Incorporated

Published: 1992

Total Pages: 592

ISBN-13:

DOWNLOAD EBOOK

In the beginning, when computers were the toys of back-room scientists, there were not databases, no systems architects, no information modelers. Computers did not manage business information, so there was no need for information specification techniques. In today's complex world, precise specification methods are a primary requirement for business success and survival. This book describes how to use information models to specify business information models to specify business information requirements, policies, and rules, and how to use these specifications to design and build database applications. Using IDEF1X, a language for describing information structures, this text provides clear and practical instructions that teach the reader to think about complex data and business rules without being concerned about the particular characteristics of the database management system that will be used for implementation. This text is addressed to both those who want to know the why and those who want to know the how of data-driven design.

Physical Database Design
Physical Database Design

Author: Sam S. Lightstone

Publisher: Morgan Kaufmann

Published: 2010-07-26

Total Pages: 449

ISBN-13: 0080552315

DOWNLOAD EBOOK

The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book. The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, Fourth Edition Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft) Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!

The Informix Handbook
The Informix Handbook

Author: Ron Flannery

Publisher: Prentice Hall

Published: 2000

Total Pages: 1448

ISBN-13:

DOWNLOAD EBOOK

The all-in-one reference for Informix administrators, developers, and DBAs.The Informix Handbook is the most comprehensive Informix desktop reference ever published. No matter what platform or version of Informix you use, here are the complete, results-focused answers you'd have to search through piles of documentation for -- if you could find them at all! Whether you're a developer, DBA, manager, Web professional, or end user, this is the one Informix resource that delivers it all:

Beginning Database Design
Beginning Database Design

Author: Gavin Powell

Publisher: John Wiley & Sons

Published: 2006

Total Pages: 496

ISBN-13: 0764574906

DOWNLOAD EBOOK

From the #1 source for computing information, trusted by more than six million readers worldwide.

Informix Guide to SQL
Informix Guide to SQL

Author: Informix Software, Inc

Publisher: Prentice Hall PTR

Published: 1995

Total Pages: 852

ISBN-13:

DOWNLOAD EBOOK

Designed as a companion volume to the INFORMIX Guide to SQL: Tutorial, this comprehensive reference covers the Structured Query Language (SQL) as it is implemented in Informix products. KEY TOPICS: Outlines the structure and contents of the demonstration database (stores5) and explains the 21 Informix system catalog tables that describe that structure; defines the column data types supported by Informix products and explains data type conversion techniques; describes the various environment variables that can or should be set to properly use Informix products; explains error handling, the system descriptor area and the SQL Descriptor Area (sqlda); details the workings of all the SQL statements supported by Informix products with step-by-step diagrams explaining every clause of each SQL statement; and shows how to create and use stored procedures. MARKET: A reference to SQL for those who already know how to use computers and who rely on them in their daily work.

Data Warehousing Fundamentals
Data Warehousing Fundamentals

Author: Paulraj Ponniah

Publisher: John Wiley & Sons

Published: 2004-04-07

Total Pages: 544

ISBN-13: 0471463892

DOWNLOAD EBOOK

Geared to IT professionals eager to get into the all-importantfield of data warehousing, this book explores all topics needed bythose who design and implement data warehouses. Readers will learnabout planning requirements, architecture, infrastructure, datapreparation, information delivery, implementation, and maintenance.They'll also find a wealth of industry examples garnered from theauthor's 25 years of experience in designing and implementingdatabases and data warehouse applications for majorcorporations. Market: IT Professionals, Consultants.

Building the Data Warehouse
Building the Data Warehouse

Author: W. H. Inmon

Publisher: John Wiley & Sons

Published: 2002-10-01

Total Pages: 434

ISBN-13: 0471270482

DOWNLOAD EBOOK

The data warehousing bible updated for the new millennium Updated and expanded to reflect the many technological advances occurring since the previous edition, this latest edition of the data warehousing "bible" provides a comprehensive introduction to building data marts, operational data stores, the Corporate Information Factory, exploration warehouses, and Web-enabled warehouses. Written by the father of the data warehouse concept, the book also reviews the unique requirements for supporting e-business and explores various ways in which the traditional data warehouse can be integrated with new technologies to provide enhanced customer service, sales, and support-both online and offline-including near-line data storage techniques.

Dimensional Modeling: In a Business Intelligence Environment
Dimensional Modeling: In a Business Intelligence Environment

Author: Chuck Ballard

Publisher: IBM Redbooks

Published: 2012-07-31

Total Pages: 670

ISBN-13: 0738496448

DOWNLOAD EBOOK

In this IBM Redbooks publication we describe and demonstrate dimensional data modeling techniques and technology, specifically focused on business intelligence and data warehousing. It is to help the reader understand how to design, maintain, and use a dimensional model for data warehousing that can provide the data access and performance required for business intelligence. Business intelligence is comprised of a data warehousing infrastructure, and a query, analysis, and reporting environment. Here we focus on the data warehousing infrastructure. But only a specific element of it, the data model - which we consider the base building block of the data warehouse. Or, more precisely, the topic of data modeling and its impact on the business and business applications. The objective is not to provide a treatise on dimensional modeling techniques, but to focus at a more practical level. There is technical content for designing and maintaining such an environment, but also business content. For example, we use case studies to demonstrate how dimensional modeling can impact the business intelligence requirements for your business initiatives. In addition, we provide a detailed discussion on the query aspects of BI and data modeling. For example, we discuss query optimization and how you can determine performance of the data model prior to implementation. You need a solid base for your data warehousing infrastructure . . . . a solid data model.