Free eBook Digg

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]