Free eBook Digger

Advanced Data Warehouse Design From Conventional to Spatial and Temporal Applications

A data warehouse stores large volumes of historical data required for analytical purposes. This data is extracted from operational databases; transformed into a coherent whole using a multidimensional model that includes measures, dimensions, and hierarchies; and loaded into a data warehouse during the extraction-transformation-loading (ETL) process.
Malinowski and Zimányi explain in detail conventional data warehouse design, [...]

Tags: Conventional Data, Data Sources, Data Warehouse Design, Data Warehouse Systems, Driving Force, Hierarchies, Hierarchy, Implementations, Malinowski, Multidimensional Model, Olap, Operational Data, Operational Databases, Oracle, Oracle 10g, Real World, Temporal Applications, Three Different Approaches, Transformation, Warehouse Stores

Pro Oracle Spatial for Oracle Database 11g (Hardcover) (Expert’s Voice in Oracle)

Pro Oracle Spatial for Oracle Database 11g (Hardcover), (Expert’s Voice in Oracle)
Pro Oracle Spatial for Oracle Database 11g shows how to take advantage
of Oracle Databases built-in feature set for working with location-based
data. A great deal of the information used in business today is
associated with location in some way, and analysis of that data is
becoming ever [...]

Tags: Business Today, Consumer Applications, Corporate Users, Customer Relations, Data Model, Enterprise Databases, Epsg, Geometry Data, Google, Google Maps, Oracle Clients, Oracle Database 11g, Oracle Databases, Oracles, Spatial Data Management, Spatial Development, Spatial Features, Spatial Information, Standards Group, Support Decisions

Building a Data Warehouse: With Examples in SQL Server (Hardcover)

Building a Data Warehouse: With Examples in SQL Server (Hardcover)
Building a Data Warehouse: With Examples in SQL Server describes how to
build a data warehouse completely from scratch and shows practical
examples on how to do it. Author Vincent Rainardi also describes some
practical issues he has experienced that developers are likely to
encounter in their first data warehousing [...]

Tags: Book Chapters, Business Intelligence, Customer Relationship Management, Data Extraction, Data Models, Data Quality, Data Warehouse Architecture, Data Warehousing Project, Database Design, Extraction Methods, Fact Tables, First Data, Implementation Code, Metadata, Multidimensional Databases, Quality Data, Rdbms, Source Systems, Sql Server 2005, Warehouse Operation

Beginning SQL Queries: From Novice to Professional (Paperback)

Beginning SQL Queries: From Novice to Professional (Paperback)
Clare Churcher’s Beginning SQL Queries is your guide to mastering the
lingua franca of the database industry: the SQL language. Good knowledge
of SQL is crucial to anyone working with databases, because it is with
SQL that you retrieve data, manipulate data, and generate business
results. Knowing how to write good queries [...]

Tags: Business Result, Business Results, Cartesian Products, Churcher, Database Industry, Databases, Examples And Explanations, Lingua Franca, Many Tables, Novice, Null Values, Pitfalls, Relational Algebra And Calculus, Simple Queries, Sql Guide, Sql Language, Sql Queries, Syntax, Traps, Underlying Concepts

SQL Server 2005 Management and Administration (Paperback)

SQL Server 2005 Management and Administration (Paperback)

Microsoft SQL Server 2005 Management and Administration, based on
Service Pack 2, addresses the challenges database administrators
regularly encounter on SQL Server 2005 by providing detailed guidance in
the areas of management, administration, security, and monitoring. With
coverage of the new features and functionality of SQL Server 2005
Service Pack 2, this book is [...]

Tags: Best Practices, Challenges, Database Administrators, Database Engine, Functionality, Guidance, Management Administration, Management Details, Microsoft, Microsoft Server, Microsoft Sql Server, Microsoft Sql Server 2005, New Features, Pdf Server, Real World, Reporting Services, Sams, Service Pack 2, Sql Server 2005, Tactical Solutions

MySQL in a Nutshell Second Edition (In a Nutshell (O’Reilly))

MySQL in a Nutshell, Second Edition (In a Nutshell (O’Reilly))

When you need to find the right SQL keyword or MySQL client command-line
option right away, turn to this convenient reference, known for the same
speed and flexibility as the system it covers so thoroughly. MySQL is
packed with so many capabilities that the odds of remembering a
particular function [...]

Tags: Administrative Utilities, Apis, Command Line Option, Fingertips, Handy Reference, Language Interfaces, Mysql Knowledge Base, New Edition, New Features, Newcomers, Novices, O Reilly, Php Perl, Programming Language, Reilly Nutshell, Replication, Right Moment, Trial And Error, Tutorial Chapters, Unfamiliar Territory

Oracle Automatic Storage Management: Under-the-Hood

Oracle Automatic Storage Management: Under-the-Hood & Practical, Deployment Guide (Oracle) (Paperback)

Build and manage a scalable storage infrastructure with Oracle Automatic
Storage Management
Streamline data management and provisioning using Oracle Automatic
Storage Management (Oracle ASM) and the detailed information contained
in this exclusive Oracle Press resource. Written by a team of database
experts, Oracle Automatic Storage Management: Under-the-Hood & Practical
Deployment Guide [...]

Tags: Automatic Storage, Chinese Oracle, Command Line Interface, Data Redundancy, Data Striping, Database Experts, Database Storage, Deployment Guide, Disk Storage, Distribution Work, Oracle Database, Oracle Press, Oracle Rdbms, Scalable Storage, Storage Environment, Storage Infrastructure, Storage Management, Storage Performance, Storage Platforms, Using Oracle

Oracle Database 11g: New Features for DBAs and Developers (Expert’s Voice in Oracle) (Paperback)

Oracle Database 11g: New Features for DBAs and Developers, (Expert’s Voice in Oracle) (Paperback)
Oracle Database 11g: New Features for DBAs and Developers is a
comprehensive, example-laden review of the most significant new features
and improvements offered by the latest release of Oracle Corporation’s
flagship database product.
- Learn what’s new in Oracle that really counts.
- See actual examples and [...]

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005

Beginners Guide to SQL Server Integration Services Using Visual, Studio 2005

Sql Server Integration Services with the acronym SSIS is a comprehensive ETL tool
that made its debut with SQL Server 2005. It is a tool tightly integrated with the
Visual Studio 2005 having all the functionalities that its forerunner DTS
(Data Transformation Services) had in SQL Server 2000. [...]

Oracle Database 11g New Features (Paperback)

Oracle Database 11g New Features (Paperback)

FOREWORD by Tom Kyte
Your Must-Have Guide to Everything New in Oracle Database 11g
Realize the full potential of Oracle Database 11g with help from the
experts. Written by Robert G. Freeman, and with insightful commentary
throughout from Arup Nanda, this Oracle Press guide offers full details
on the architectural changes, database administration upgrades,
availability and [...]