February 10, 2012 at 9:28 pm
In general what percentage of individual MS SQL databases are OLTP vs. OLAP vs. none of the above?
Are read-only databases OLAP?
A database that records account balances at a bank, would that be an OLTP database because the amount in the balance can change?
February 11, 2012 at 7:56 am
In general what percentage of individual MS SQL databases are OLTP vs. OLAP vs. none of the above?
Most of the databases are OLTP. But OLAP is emerging trend so many OLAP (DWH databases) are increasing rapidly.
Are read-only databases OLAP?
Not necessarily. OLAP is by nature a 'Read-Mostly' database.
A database that records account balances at a bank, would that be an OLTP database because the amount in the balance can change?
Both. For the Transaction Management Application it would be stored in Normalized OLTP database whereas same would be ETLed to denormalized DWH database (OLAP) for reporting.
P.S. I see you have posted couple of questions within short period of time. Most of them are on broad topics which can't be answered in few lines. Use search engines (Google) for such queries. If you have specific doubt, please feel free to visit here. We would be happy to help you.
February 11, 2012 at 12:42 pm
Rowles (2/10/2012)
In general what percentage of individual MS SQL databases are OLTP vs. OLAP vs. none of the above?
By definition a corporation should have a single DSS - Data Warehouse alike database while any given corporation usually has several OLTP databases serving several day-by-day activities.
Rowles (2/10/2012)
Are read-only databases OLAP?
Nope. In some cases sections of your Data Warehouse consider some data as "archived" or "historic" then those sections are set as read-only.
Rowles (2/10/2012)
A database that records account balances at a bank, would that be an OLTP database because the amount in the balance can change?
It depends on how is done it. If the process is On Line Transaction Processing then it is OLTP while if the process is batch it is not.
In general you wouldn't find a database dedicated exclusively to just record account balances, that sounds more like a table in a more complex (most probably OLTP) database.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 11, 2012 at 9:56 pm
Just my 2 cents on the subject. You can't actually have OLAP without OLTP. The data has to come from somewhere. OLAP is "just" an analysis tool.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply