How to check db is OLAP or OLTP?

  • Hi,

    Is there a way to find out database is OLAP or OLTP. By the way I am using SQL 2005 server. Thanks

  • Technically, you can't see if a database is OLTP or OLAP. Both contain tables, indexes etc.

    But because a OLTP is used different compared to an OLAP database, there should be some design differences. These could be: denormalized tables in OLAP, more/other indexes.

    My advice is not to guess how a database is used but contact application engineers or developers about a database use.

    Wilfred
    The best things in life are the simple things

  • OLAP/OLTP isn't a database type distinction. It referes to how the DB is used.

    OLTP - Online transaction processing. So if the DB is constantly getting small requests from a time-critical transaction processing system, then it's more and OLTP database

    OLAP - Online analytical processing. Refers more to the 'datawarehouse' type systems where the bulk of the activity is large reports, aggregations or similar type queries.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Explore OLTP and OLAP difference
    Ranet OLAP is a versatile smart BI product.
    As the amount of data is consistently growing, companies, enterprises, factories, and other businesses managing data need a software to mine and analyze it rapidly and precisely.
    OLAP lets its users stay aware of their business performance, explore tendencies, predict marketing trends so that to come up with strategies for further promotion.
    As well as any OLAP system Ranet OLAP can receive data from an OLTP system and enables businesses to explore all transactions relating to the company.
    Thanks to Ranet OLAP you can be sure that the business will remain under your complete control.

  • The level of normalization can provide some clue about whether it could be an OLAP or OLTP. If you see much denormalized tables and also most queries being read-only, it could be most likely an OLAP.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply