Bøger af Mark Whitehorn

OLAP (On-Line Analytical Processing) is the most powerful Business Intelligence tool currently available and Microsoft's Analysis Manager makes OLAP cubes incredibly easy to build and deploy. However the real power of OLAP lies in its ability to help you solve real-life business problems; to release that power you need to use the language that controls the cubes and allows them to be queried. That language is MDX (Multi Dimensional eXpressions). Fast Track to MDX gives you all the necessary background to let you to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop your MDX skills to the point where you can solve real business problems. >Second Edition - It was the clarity, precision and sheer readability of the first edition that made it a best-seller. With that firmly in mind the authors have left the original 18 chapters intact (apart from minor updates); meaning that the second edition remains the best introduction to MDX that is available. What they have done is to add three brand new chapters. These introduce the topic of recursion in MDX, walk the reader through the process of creating recursive expressions and finally demonstrate how recursion can be used to effectively solve a series of businessproblems. Forward by Amir Netz, Product Unit Manager, SQL Server - Analysis Services at Microsoft.

The second edition of the best-selling Inside Relational Databases is revised and updated to bring you the most reader-friendly explanation of the relational model and its importance to database designers and builders.Clear explanations make use of examples rather than equations to show you how an understanding of the relational model can make your databases faster, more flexible and thoroughly fit for their purpose.Dr Mark Whitehorn has an extensive understanding of relational database theory and his popular and long running database column in the UK's "Personal Computer World" has already made database theory accessible to thousands.Bill Marklyn has an intimate knowledge of relational databases and was the Development Manager who oversaw the entire design of the first two major releases of Microsoft's highly successful database product, Access.Together they make a great team, illuminating a tricky subject with substance and style.Reviews from the first edition of Inside Relational Databases:"Quite simply - superb. By making relational databases understandable, Mark Whitehorn and Bill Marklyn have achieved far more than most. Making the subject interesting and entertaining as well puts these two authors firmly in a class of their own."- Neil Fawcett, Group Technical Editor, VNU Business Publications"PCW and Amazon.co.uk contributor Mark Whitehorn is that rare combination - an expert in his field, databases, and a fine writer too, with a talent for honing a complex subject down to its essentials."- Tamsin Todd, Computer & Internet Editor, Amazon.co.uk"Inside Relational Databases is excellent. It is clearly and concisely written and full of humorous asides which ease the reader through an otherwise weighty topic. Probably the most engaging technical book I have read."- Paul McGowan

Written by the team which brought you Inside Relational Databases and based on their best-selling book for Access 2000, Accessible Access has been totally re-written for Access 2003.About the authors:Bill Marklyn, as the Development Manager for the first two major releases of Access, oversaw the entire design and so provides an intimate knowledge of the product.Mark Whitehorn's skills lie in making complex ideas easy to understand and entertaining to absorb. In addition he's a professional database developer which probably helps....From the authors:We wrote Accessible Access 2000 for people who were new to the world of building databases. In that book we tried very hard not to simply list everything that we knew about the product. Instead we tried to act as intelligent filters, presenting only the essential information that you need to get started.We were delighted with the reception that the book received and have tried to keep the same philosophy for Accessible Access 2003. However, rather than simply reprinting the book with 2003 in the title, we have gone through it with a fine toothcomb. Every screen shot has been retaken and every section has been re-checked to ensure, not only that it still works, but also that it is actually still relevant. We have re-written parts where the product has changed and also added some. For example, there is a new section on Object Dependencies and a whole new chapter about Data Access Pages - helping you to put your Access database onto an intranet.

This book concentrates on two aspects of business intelligence, together with the associated IBM products: data warehousing with Visual Warehouse, and on-line analytical processing using the DB2 OLAP Server.

Written by the team who brought you "Inside Relational Databases". Tamsin Todd - Computers & Internet Editor, Amazon.co.ukAccessible Access 2000 assumes that you start with no knowledge of Access or databases and takes you to the point where you can create and use a multi-table database.

On the other hand, the six different types that we describe are part of the re- tional world and this book is about that world - we are not trying to teach you how to use Access, we are simply using Access to illustrate the relational model. Incidentally, this is not meant to imply that Access is somehow lacking as a relational database engine.