Understanding Database/Query Options (Part 2) 
Sunday, April 27, 2014 at 07:25AM
Charlie in Digital Financial Reporting

Continuing on from where I left off in Understanding Database/Query Options (Part 1)...

People tend to agree that there are different types of databases. Another term for this is DBMS (database management system) or database or database model. Now, keep in mind here that you have databases and you have modeling approaches used by databases.  These are different.  For example, a relational database can use a multidimensional approach to representing information within that that database.

People tend to agree that the categories of processing of information can broken down into at least two groups: (this presentation compares and contrasts OLTP and OLAP)

OLTP is what relational database did when they were first created.  OLAP was invented as an approach to making analysis of information, many times from OLTP systems data, easier.  OLAP uses the notion of "cubes".

OLAP can be broken down into categories also:

There seems to be a couple of other data cube models: (data cube)

Ran across a few things which I want to investigate further relating to semantic model:

Most of what I have pointed out so far in Part 1 and Part 2 are facts which few people tend not to dispute.  Some people might add something to a list, change a term, or maybe even remove something from the lists that I have provided.  When you have to choose something from a list, then things change.  There is an interesting phenomenon that I have noticed when one tries to select something on the list.  Specific software vendors always have "the best solution".  Always! It is unreal.  I don't think I have ever run across a software vendor who says, "Yeah, sounds like you need a multidimensional database based on what you are describing and we sell a relational database type system..."  You ever have that experience?

Hadoop is a set of tools for working with "big data".  Hadoop is open source and based on Linux; the direction of Hadoop is not determined by any software vendor.  This video explains hadoop. This also explains hadoop.

Gotta walk the dog again...Guess there will be a Part 3.

Article originally appeared on Intelligent XBRL-based structured digital financial reporting using US GAAP and IFRS (http://xbrl.squarespace.com/).
See website for complete article licensing information.