Advanced Data Warehouse Design: From Conventional to Spatial by Elzbieta Malinowski

By Elzbieta Malinowski

A info warehouse shops huge volumes of historic info required for analytical reasons. this information is extracted from operational databases; reworked right into a coherent complete utilizing a multidimensional version that comes with measures, dimensions, and hierarchies; and loaded right into a facts warehouse throughout the extraction-transformation-loading (ETL) process.

Malinowski and Zimányi clarify intimately traditional information warehouse layout, overlaying particularly complicated hierarchy modeling. also, they handle leading edge domain names lately brought to increase the features of knowledge warehouse structures, specifically the administration of spatial and temporal info. Their presentation covers various levels of the layout method, similar to specifications specification, conceptual, logical, and actual layout. They comprise 3 assorted ways for standards specification counting on no matter if clients, operational info assets, or either are the motive force within the requisites amassing approach, and so they exhibit how each one method ends up in the production of a conceptual multidimensional version. through the publication the recommendations are illustrated utilizing many real-world examples and accomplished via pattern implementations for Microsoft's research providers 2005 and Oracle 10g with the OLAP and the Spatial extensions.

For researchers this e-book serves as an advent to the cutting-edge on info warehouse layout, with many references to extra designated assets. delivering a transparent and a concise presentation of the most important thoughts and result of information warehouse layout, it will probably even be used because the foundation of a graduate or complicated undergraduate path. The ebook may also help skilled information warehouse designers to amplify their research chances via incorporating spatial and temporal details. ultimately, specialists in spatial databases or in geographical details structures may gain advantage from the knowledge warehouse imaginative and prescient for construction leading edge spatial analytical applications.

Show description

Read Online or Download Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications PDF

Best information systems books

The 3-D global spatial data model: foundation of the spatial data

Conventional tools for dealing with spatial facts are weighted down through the idea of separate origins for horizontal and vertical measurements. sleek dimension structures function in a 3D spatial surroundings. The three-D worldwide Spatial information version: origin of the Spatial facts Infrastructure deals a brand new version for dealing with electronic spatial info, the worldwide spatial information version or GSDM.

iPhone: The Missing Manual: Covers the iPhone 3G

The recent iPhone 3G is right here, and ny occasions tech columnist David Pogue is on best of it with a completely up-to-date version of iPhone: The lacking handbook. With its quicker downloads, touch-screen iPod, and best-ever cellular internet browser, the recent cheap iPhone is choked with chances. yet with out an aim advisor like this one, you are going to by no means liberate all it will probably do for you.

Applied GIS and Spatial Analysis

The recognition of geography as an educational self-discipline is partially defined through its relevance to the true global. Spatial research makes use of geographic details and statistical equipment for the learn of particular functions, starting from company situation research to the size of internal urban deprivation, and while utilized in conjunction with GIS, visible representations and "what if" eventualities will be created.

Additional resources for Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications

Sample text

Since the book covers several research areas, we describe next the contributions of this research to each of them. 1 Conventional Data Warehouses The main contributions of our proposal in the field of conventional data warehouses include the following aspects. , entity types, relationship types, and attributes, with their usual semantics. Therefore, it allows designers to apply the same modeling constructs as those used for operational database design, and it provides a conceptual representation independent of technical details.

SQL (structured query language) is the most common language for creating, manipulating, and retrieving data from relational database management systems. SQL is composed of several sublanguages. The data definition language (DDL) allows the schema of a database to be defined. , to add, update, and delete data in a database). Throughout this book, we consider the latest version of the SQL standard, SQL:2003 [195]. The set of SQL DDL commands defining the relational schema of Fig. 2 is as follows. create table AcademicStaff as ( EmployeeNo integer primary key, FirstName character varying (30) not null, LastName character varying (30) not null, Address character varying (50) not null, Email character varying (30) not null, Homepage character varying (64) not null ); create table AcademicStaffResearchArea as ( EmployeeNo integer not null, ResearchArea character varying (30) not null, primary key (EmployeeNo,ResearchArea), foreign key EmployeeNo references AcademicStaff(EmployeeNo) ); create table Professor as ( EmployeeNo integer primary key, Status character varying (10) not null, TenureDate date, NoCourses integer not null, constraint Professor Status check ( Status in ( ’Assistant’, ’Associate’, ’Full’ ) ), foreign key EmployeeNo references AcademicStaff(EmployeeNo) ); create table Assistant as ( EmployeeNo integer primary key, ThesisTitle character varying (64) not null, 28 2 Introduction to Databases and Data Warehouses ThesisDescription text not null, Advisor integer not null, foreign key EmployeeNo references AcademicStaff(EmployeeNo), foreign key Advisor references Professor(EmployeeNo) ); create table Participates as ( EmployeeNo integer not null, ProjectId integer not null, StartDate date not null, EndDate date not null, primary key (EmployeeNo,ProjectId), foreign key EmployeeNo references AcademicStaff(EmployeeNo), foreign key ProjectId references Project(ProjectId) ); create table Project as ( ProjectId integer primary key, ProjectAcronym character (15) not null, ProjectName character varying (30) not null, Description character varying (30), StartDate date not null, EndDate date not null, Budget character varying (30) not null, FundingAgency character varying (30) not null ); create table Section as ( CourseId integer not null, Semester integer not null, Year integer not null, Homepage character varying (64), EmployeeNo integer not null, primary key (CourseId,Semester,Year), foreign key CourseId references Course(CourseId), foreign key EmployeeNo references Professor(EmployeeNo) ); create table Course as ( CourseId integer primary key, CourseName character varying (30) not null, Level character varying (30) not null ); create table Prerequisite as ( CourseId integer not null, HasPrereq integer not null, primary key (CourseId,HasPrereq), foreign key CourseId references Course(CourseId), foreign key HasPrereq references Course(CourseId) ); As shown in this simple schema excerpt, there is a significant difference in expressive power between the ER model and the relational model.

A referential integrity constraint relates each one of these identifiers to the table associated with the corresponding entity type. The table also contains the simple monovalued attributes and the simple components of the monovalued complex attributes of the relationship type. This table also defines not null constraints for the mandatory attributes. The relationship identifier, if any, may define the key of the table, although a combination of all the role identifiers can also be used. , a relationship instance does not exist without its related entities, not null constraints are defined for all role identifiers.

Download PDF sample

Advanced Data Warehouse Design: From Conventional to Spatial by Elzbieta Malinowski
Rated 4.70 of 5 – based on 25 votes