Results 1 to 5 of 5

Thread: OLTP or DSS

  1. #1
    Join Date
    Dec 2008
    Posts
    19

    Unanswered: OLTP or DSS

    Hi,

    What is the difference between OLTP and DSS database designs ?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    OLTP = OnLine Transaction Processing
    DSS = ..?
    George
    Home | Blog

  3. #3
    Join Date
    Dec 2008
    Posts
    19
    Thanks guys i got the solution

    Online transaction processing(OLTP) database applications are optimal for managing changing data. These applications typically have many users who are performing transactions at the same time that change real-time data, in other words OLTP is a live database (accomodates inserts, deletes, updates etc)


    Decision-support System (DSS) database applications are optimal for data queries that do not change data. For example, a company can periodically summarize its sales data by date, sales region, or product, and store this information in a separate database to be used for analysis by senior management. To make business decisions, users must be able to determine trends in sales quickly by querying the data based on various criteria. However, they do not have to change this data. The tables in a decision-support database are heavily indexed, and the raw data is frequently preprocessed and organized to support the various types of queries to be used. Because the users are not changing data, concurrency and atomicity issues are not a concern; the data is changed only by periodic, bulk updates made during off-hour, low-traffic times in the database.

  4. #4
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    3NF vs Star/Snowflake.

    Get your hands on a good Ralph Kimball book.

  5. #5
    Join Date
    Dec 2008
    Location
    Yangon,Myanmar
    Posts
    10
    OLTP is the online transaction processing
    DSS Decision support system
    This two are not same
    OLTP is use for Daily transaction. DSS is use for to decide for management, etc...............
    http://www.geekinterview.com/Intervi...Data-Warehouse
    use this link for clearly define.


    Tae Jaay

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •