SQLScript: Efficiently analyzing big enterprise data in SAP HANA

Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)

Volumn P-214, Issue , 2013, Pages 363-382

  Binnig, Carsten ^a   May, Norman ^b   Mindnich, Tobias ^b  

^a DHBW Mannheim ^*  (Germany)

^b SAP RESEARCH   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

ARTIFICIAL INTELLIGENCE; DATA WAREHOUSES; FUNCTIONAL PROGRAMMING; INFORMATION SYSTEMS; LEARNING SYSTEMS; SOCIAL NETWORKING (ONLINE);

APPLICATION LAYERS; CURRENCY CONVERSION; ENTERPRISE INFORMATION SYSTEM; FUNCTIONAL EXTENSION; MAIN MEMORY DATABASE; MAP-REDUCE PROGRAMMING; RELATIONAL DATABASE; USER DEFINED FUNCTIONS;

BIG DATA;

EID: 84904332795     PISSN: 16175468     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (16)

1. [ABE+10] Alexander Alexandrov, Dominic Battré, Stephan Ewen, Max Heimel, Fabian Hueske, Odej Kao, Volker Markl, Erik Nijkamp, and Daniel Warneke. Massively Parallel Data Analysis with PACTs on Nephele. PVLDB, 3(2), 2010.
2. [ABPA+09] Azza Abouzeid, Kamil Bajda-Pawlikowski, Daniel J. Abadi, Alexander Rasin, and Avi Silberschatz. HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads. PVLDB, 2(1):922-933, 2009.
3. [BBC+11] Alexander Behm, Vinayak R. Borkar, Michael J. Carey, Raman Grover, Chen Li, Nicola Onose, Rares Vernica, Alin Deutsch, Yannis Papakonstantinou, and Vassilis J. Tsotras. ASTERIX: Towards a scalable, semistructured data platform for evolvingworld models. Distributed and Parallel Databases, 29(3):185-216, 2011.
4. [BHBE10] Yingyi Bu, Bill Howe, Magdalena Balazinska, and Michael D. Ernst. HaLoop: Efficient Iterative Data Processing on Large Clusters. PVLDB, 3(1), 2010.
5. [BPASP11] Kamil Bajda-Pawlikowski, Daniel J. Abadi, Avi Silberschatz, and Erik Paulson. Efficient processing of data warehousing queries in a split execution environment. In SIGMOD, pages 1165-1176, 2011.
6. [BRFR12] Carsten Binnig, Robin Rehrmann, Franz Faerber, and Rudolf Riewe. FunSQL: it is time to make SQL functional. In EDBT/ICDT Workshops, pages 41-46, 2012.
7. [DG08] Jeffrey Dean and Sanjay Ghemawat. MapReduce: Simplified data processing on large clusters. Commun. ACM, 51(1):107-113, 2008.
8. [DQRJ+10] Jens Dittrich, Jorge-Arnulfo Quiané-Ruiz, Alekh Jindal, Yagiz Kargin, Vinay Setty, and Jörg Schad. Hadoop++: Making a Yellow Elephant Run Like a Cheetah (Without It Even Noticing). PVLDB, 3(1):518-529, 2010.
9. [HAD12] Apache Hadoop. http://hadoop.apache.org, 2012.
10. [KST12] Tim Kaldewey, Eugene J. Shekita, and Sandeep Tata. Clydesdale: Structured data processing on MapReduce. In EDBT, pages 15-25, 2012.
11. [Les12] Jure Leskovec. Stanford Large Network Dataset Collection. http://snap.stanford.edu/data/, 2012.
12. [Ord05] Carlos Ordonez. Optimizing recursive queries in SQL. In SIGMOD Conference, pages 834-839, 2005.
13. [ORS+08] Christopher Olston, Benjamin Reed, Utkarsh Srivastava, Ravi Kumar, and Andrew Tomkins. Pig latin: A not-so-foreign language for data processing. In SIGMOD, pages 1099-1110, 2008.
14. [SQL12] SAP HANASQLScript Reference. http://help.sap.com/hana/hana dev sqlscript en.pdf, 2012.
15. [TPC12] TPC-H. http://www.tpc.org/tpch/, 2012.
16. [TSJ+10] Ashish Thusoo, Joydeep Sen Sarma, Namit Jain, Zheng Shao, Prasad Chakka, Ning Zhang, Suresh Anthony, Hao Liu, and Raghotham Murthy. Hive -A petabyte scale data warehouse using Hadoop. In ICDE, pages 996-1005, 2010.