 Data Processing Languages for Business Intelligence. SQL vs. RMarin Fotache () Informatica Economica, 2016, vol. 20, issue 1, 48-61 Abstract: As data centric approach, Business Intelligence (BI) deals with the storage, integration, processing, exploration and analysis of information gathered from multiple sources in various formats and volumes. BI systems are generally synonymous to costly, complex platforms that require vast organizational resources. But there is also an-other face of BI, that of a pool of data sources, applications, services developed at different times using different technologies. This is “democratic†BI or, in some cases, “fragmented†, “patched†(or “chaotic†) BI. Fragmentation creates not only integration problems, but also supports BI agility as new modules can be quickly developed. Among various languages and tools that cover large extents of BI activities, SQL and R are instrumental for both BI platform developers and BI users. SQL and R address both monolithic and democratic BI. This paper compares essential data processing features of two languages, identifying similarities and differences among them and also their strengths and limits. Keywords: Business Intelligence; Data Processing; SQL; R (search for similar items in EconPapers) Downloads: (external link) Related works: Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text Persistent link: https://EconPapers.repec.org/RePEc:aes:infoec:v:20:y:2016:i:1:p:48-61 Access Statistics for this article Informatica Economica is currently edited by Ion Ivan More articles in Informatica Economica from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC. |
Is your work missing from RePEc? Here is how to contribute.
Questions or problems? Check the EconPapers FAQ or send mail to .
EconPapers is hosted by the
School of Business at Örebro University.