B. Decision support systems (DSS)

Α. On-line transactional processing systems OLTPs are systems which serve transactions with suppliers, partners and customers, as well as internal business transactions. They support operations throughout the value chain of the Organization:

• Supply Chain Management (SCM)
• Production support (e.g. MRP, Advanced Planning & Scheduling)
• Customer interface management (e.g. sales, order management and billing) (CRM)
• Finance and Accounting (ERP)
• Sales force automation
• Web channel operations (eCRM)
• Internal workflow support systems

1. Clearly specified given that the system serves specific functional needs – the predetermined transactions
2. the determination of a complete requirement set is a challenge, given that there are dynamically changing informational requirements.

1. Cur
   Career - A Self Help Guide
   Could you hope to live without a career all life despite inheriting a legacy? Career is not just about living out of inherited money, nor is it limited to earning livelihood. Holistically speaking it is the progression of ones working or professional life. Career indeed means a lot these days. Nowadays, parents start grooming their children from the day one she starts her education, guide and help their children choose the
   ernal business transactions. They support operations throughout the value chain of the Organization:
   • Supply Chain Management (SCM)
   • Production support (e.g. MRP, Advanced Planning & Scheduling)
   • Customer interface management (e.g. sales, order management and billing) (CRM)
   • Finance and Accounting (ERP)
   • Sales force automation
   • Web channel operations (eCRM)
   • Internal workflow support systems
   Β. Decision support systems DSS provide management at all levels of the Organisation, with information which supports understanding of the current Business position and taking informed decisions (fact based management). OLTP vs DSS systems Even though OLTP (on-line transactional processing) and DSS (decision support systems) functionalities may overlap (e.g. an OLTP system may provide some operational reporting functionality used for decision support), it is clear that the purpose of the 2 categories differs, given that they serve different functions and different User groups in the Business. Therefore the development philosophy of the two categories differs radically. Specifically, differences are identified on the following criteria (1 for OLTP, 2 for DSS): System functional requirements:
   1. Clearly specified given that the system serves specific functional needs – the predetermined transactions
   2. the determination of a complete requirement set is a challenge, given that there are dynamically changing informational requirements.
   Capture of current and historical information:
   1. Cu
      You Have a Great Vision and a Perfect Plan! Do You Have the Freedom to Implement It?
      As busy professionals we are always on the lookout for the best way to accomplish our goals. We want more freedom to enjoy the benefits that being our own "master" provides. As we seek to expand our prosperity and productivity we encounter many individuals who help and support us on our path.But what about when we find ourselves going back again and again for help and ... it isn't working. The "answer" always seems
      workflow support systems
   Β. Decision support systems DSS provide management at all levels of the Organisation, with information which supports understanding of the current Business position and taking informed decisions (fact based management). OLTP vs DSS systems Even though OLTP (on-line transactional processing) and DSS (decision support systems) functionalities may overlap (e.g. an OLTP system may provide some operational reporting functionality used for decision support), it is clear that the purpose of the 2 categories differs, given that they serve different functions and different User groups in the Business. Therefore the development philosophy of the two categories differs radically. Specifically, differences are identified on the following criteria (1 for OLTP, 2 for DSS): System functional requirements:
   1. Clearly specified given that the system serves specific functional needs – the predetermined transactions
   2. the determination of a complete requirement set is a challenge, given that there are dynamically changing informational requirements.
   Capture of current and historical information:
   1. Cu
      The Best Franchise Business Opportunities
      The best franchise business opportunities that exist in the world today has many factors in them that makes the franchise become one of the best in the industry. The main factors in the best franchise opportunities in the world today are information, home base business, and work from home companies, small business start up capital, and a turnkey business system that produces results in a company profit margin in today’s ec
      ocessing) and DSS (decision support systems) functionalities may overlap (e.g. an OLTP system may provide some operational reporting functionality used for decision support), it is clear that the purpose of the 2 categories differs, given that they serve different functions and different User groups in the Business. Therefore the development philosophy of the two categories differs radically. Specifically, differences are identified on the following criteria (1 for OLTP, 2 for DSS): System functional requirements:
      1. Clearly specified given that the system serves specific functional needs – the predetermined transactions
      2. the determination of a complete requirement set is a challenge, given that there are dynamically changing informational requirements.
      Capture of current and historical information:
      1. Cu
         How To Write A Headline That Converts More Visitors Into Customers
         In just five minutes you are going to learn how to easily write headlines from scratch with the ease.But first you need a little background.You see, when people look at website conversion statistics they often look at a website's statistics from an analytical perspective.In other words they look at facts, figures and equations instead of looking at increasing website conversions from a holistic standpo
         identified on the following criteria (1 for OLTP, 2 for DSS): System functional requirements:
         1. Clearly specified given that the system serves specific functional needs – the predetermined transactions
         2. the determination of a complete requirement set is a challenge, given that there are dynamically changing informational requirements.
         Capture of current and historical information:
         1. Current state information is captured (some historical data may exist only to serve potential future transactions)
         2. Recent and historical information is captured (current may not be captured, given that data from the OLTP are retrieved at regular intervals)
         Data models used:
         1. Complex, focused on business entities (in terms of relational databases it is called normalized data structure (e.g. 3NF))
         2. Different approaches exist. The simplified denormalised dimensional structure gains momentum, since it allows easier understanding by business users and optimized execution of complex queries.
         Information level of detail:
         1. Detailed data per transaction are kept
         2. Detailed data are kept in a different structure and are enriched by ‘dimensional’ information which allows analytical processing. Moreover, aggregated data like KPIs (key performance indicators), are calculated and stored in persistent storage.
         Volume of data:
         1. The volume of data is relevant to the size of the Business and the penetration of IT in it.
         2. The data volume handled by a DSS, is multiple of that of the OLTP systems on which it is based, given that it maintains multiple historical snapshots
         Copyright 2006 – Kostis Panayotakis