0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Why need of separate data warehouse?
3 Main reasons: 1.OLTP systems require high concurrency, reliability, locking which provide good performance for short and simple OLTP queries. An OLAP query is very complex and does not require these properties. Use of OLAP query on OLTP system degrades its performance. 2.An OLAP query reads HUGE amount of data and generates the required result. The query is very complex too. Thus special primitiveshave to provided to support this kind of data access. 3.OLAP systems access historical data and not current volatile data while OLTP systems access current up-to-date data and do not need historical data.
Which function do you use to set up a user's login information?
The Account Setup and Maintenance function
What is the financial management function?
what is financial management function?
What are the function and responsibilty of Cost Accounting?
What are the function and responsiblity of Cost Accounting
What is asset function of money?
The asset function of money is Hope. Hope will help you reach your goals.
What type of software operates with automaticity?
OLTP
What do the letters in oltp stand for?
The acronym OLTP stands for Online Transaction Processing. It's about the processing and the response of the system to the users' request, for example the process that happens in ATM machines.
Difference between data warehouse and OLTP?
A data warehouse differs from OLTP in that the former handles many large and complex queries regarding various rows of a table while the latter retrieves data from single rows. At the same time, a data warehouse is not real time and supports few users at a time compared to OLTP that can support many concurrent users.
Can you use an OLTP backend database for creating a dashboard?
yes, it is nothing but transactional data
Explain the OLAP and OLTP system with example?
OLTP vs. OLAPWe can divide IT systems into transactional (OLTP) and analytical (OLAP). In general we can assume that OLTP systems provide source data to data warehouses, whereas OLAP systems help to analyze it.- OLTP (On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF).- OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations. For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).
Why need of separate data warehouse?
3 Main reasons: 1.OLTP systems require high concurrency, reliability, locking which provide good performance for short and simple OLTP queries. An OLAP query is very complex and does not require these properties. Use of OLAP query on OLTP system degrades its performance. 2.An OLAP query reads HUGE amount of data and generates the required result. The query is very complex too. Thus special primitiveshave to provided to support this kind of data access. 3.OLAP systems access historical data and not current volatile data while OLTP systems access current up-to-date data and do not need historical data.
What is the difference between online transaction processing and online analytical processing?
OLTP : customer oriented. OLAP : Market oriented OLTP : ER based application oriented concern OLAP : subject oriented concern. Current data : Historical data used for detailed for decesion making Access patterns are short. : COCancelMPLEX
What is OLTP database?
Databases tend to get split up into a variety of diffrent catagoies based on their application and requirements. All of these diffrent catagories naturally get nifty buzz words to help classify them and make distinctions in features more apparent. The most popular buzz work (well, acronymn anyway) is OLTP or Online Transaction Proccessing. Other classifications include Descision Support Systems (DSS), Data Warehouses, Data Marts, etc.OLTP databases, as the name implies, handle real time transactions which inherently have some special requirements. If your running a store, for instance, you need to ensure that as people order products they are properly and effiently updating the inventory tables while they are updating the purchases tables, while their updating the customer tables, so on and so forth. OLTP databases must be atomic in nature (an entire transaction either succeeds or fails, there is no middle ground), be consistant (each transaction leaves the affected data in a consistant and correct state), be isolated (no transaction affects the states of other transactions), and be durable (changes resulting from commited transactions are persistant). All of this can be a fairly tall order but is essential to running a successful OLTP database.Because OLTP databases tend to be the real front line warriors, as far as databases go, they need to be extremely robust and scalable to meet needs as they grow. Whereas an undersized DSS database might force you to go to lunch early an undersized OLTP database will cost you customers. No body is going to order books from an online book store if the OLTP database can't update their shopping cart in less than 15 seconds.The OLTP feature you tend to hear most often is "row level locking", in which a given record in a table can be locked from updates by any other proccess until the transaction on that record is complete. This is akin to mutex locks in POSIX threading. In fact OLTP shares a number of the same problems programmers do in concurrent programming. Just as you'll find anywhere, when you've got a bunch of diffrent persons or proccesses all grabbing for the same thing at the same time (or at least the potential for that to occur) your going to run into problems and raw performance (getting your hands in and out as quick as possible) is generally one of the solutions.Several other factors come into place with OLTP databases, and the Oracle10g documentation library even has a whole section dedicated just to OLTP. Find more information in the Oracle10g docs:
What is the difference between olap and oltp?
Hi, The difference can be highlighted by defining the two entities separately, OLTP: Online Transaction Processing is a system normally used in the regular routine of database or User end Transactions (These Transactions are short Transactions). In OLTP, the data is fully normalized in order to avoid redundancy,Duplication of data etc, for achieving normalization various Joins are used that connects the tables. (without these joins OLTP cannot be fully Normalized). Now move on, OLAP: Online Analytical Processing is a system helpful for analysis purposes, it is used in Business Intelligence for analysis reporting, unlike OLTP it doesn't have too many joins in it because in OLAP it is not required to normalize the data, the basic purpose is to make Facts and Dimensions. <<Specifically for reporting purposes the data retrieval should be faster (The joins make the data processing slow) so the basic need of designing OLAP is to make the reporting system faster.>>
What difference between data warehouse and traditional database used OLTP?
{| |+ Differences |- | Data warehouse database OLTP database Designed for analysis of business measures by categories and attributes Designed for real time business operations. Optimized for bulk loads and large, complex, unpredictable queries that access many rows per table. Optimized for a common set of transactions, usually adding or retrieving a single row at a time per table. Loaded with consistent, valid data; requires no real time validation Optimized for validation of incoming data during transactions; uses validation data tables. Supports few concurrent users relative to OLTP Supports thousands of concurrent users. |}http://www.geekinterview.com/question_details/15800
What are the types of Databases?
Here are the basic list of Database Types: OLTP : Online Transaction Processing Database - To store LIVE, Real-time data. Example: LIVE Temperature, LIVE Cricket Match data.. OLAP : Online Analytical Processing Database - To store data for Analysis, Forecasts. Example: Weather Forecasts DWH : Data Warehouse Database - To store Old, Historical Data HTAP Hybrid Transactional Analytical Processing Database OLTP + OLAP + DWH. Example : Google Map For more details, pls reach me.
What is the difference between data warehouse testing and conventional testing?
ETL stands for Extract-Transform-Load and it is a process of how data is loaded from the source system to the data warehouse. Data is extracted from an OLTP database, transformed to match the data warehouse schema and loaded into the data warehouse database.Many data warehouses also incorporate data from non-OLTP systems such as text files, legacy systems and spreadsheets. Conventional testing is a sort of testing in which the test engineers will check the developed application or its related parts are working accordingly to the expectations of customer or not, from coding phase of SDLC to the end
