Telerik blogs
  • Productivity

    Building a Data Warehouse Part III: Location of your data warehouse

    [repost from Stephen Forte's Blog]   See also: Part I: When to build your data warehouse Part II: Building a new schema In Part I we looked at the advantages of building a data warehouse independent of cubes/a BI system and in Part II we looked at how to architect a data warehouse’s table schema. Today we are going to look at where to put your data warehouse tables. Let’s look at the location of your data warehouse. Usually as your system matures, it follows this pattern: Segmenting your data warehouse tables into their own isolated schema inside of the OLTP database Moving the data warehouse...
    September 27, 2010
  • Web

    Building a Data Warehouse Part II: Building a new schema

    [repost from Stephen Forte's Blog] In Part I: When to build your data warehouse we looked at when you should build your data warehouse and concluded that you should build it sooner rather than later to take advantage of reporting and view optimization. Today we will look at your options to build your data warehouse schema. When architecting a data warehouse, you have two basic options: build a flat “reporting” table for each operation you are performing, or build with BI/cubes in mind and implement a “star” or “snowflake” schema. Let’s take a quick look at the first option and then we will take a look at...
    September 22, 2010
  • Productivity

    Building a Data Warehouse Part I: When to build your data warehouse

    [repost from Stephen Forte`s Blog] Most developers are scared of “Business Intelligence” or BI. Most think that BI consists of cubes, pivot/drill down apps, and analytical decision support systems. While those are very typical outcomes of a BI effort, many people forget about the first step, the data warehouse. Typically this is what happens with a BI effort. A system is built, usually a system that deals with transactions. We call this an OLTP or on-line transaction processing system. Some time passes and reports are bolted on and some business analysts build some pivot tables from “raw dumps” of data. As the system grows, reports start to slow...
    September 21, 2010
  • Web ASP.NET AJAX

    RadControls for ASP.NET AJAX Dynamic Data update

    This is just another update of RadControls for ASP.NET AJAX control integration with DynamicData. What's updated: New BinaryImage FieldTemplate - uses RadBinaryImage in view mode and RadAsyncUpload in edit mode. Updated RadGrid support for Dynamic Data - implements IDataBoundControl interface You can download latest bits from...
    July 29, 2010
  • Productivity

    Using LinqPad with Telerik OpenAccess ORM

    LinqPad is a nice and popular query analyzer made to test LINQ queries: whether it is Linq To Sql, Linq to Objects or some other flavor, you will be able to play in a nice way with it. Sadly it does not support Telerik OpenAccess ORM out of the box. However we never said it is impossible – you just have to put some more pressure to it. So, the first step is of course to deploy Telerik OpenAccess ORM and LinqPad on your machine. Then do the following: a) Open LinqPad and press F4 to bring up the Advanced Query...
    July 23, 2009