Filters








174 Hits in 1.6 sec

Spreadsheets in RDBMS for OLAP

Andrew Witkowski, Srikanth Bellamkonda, Tolga Bozkaya, Gregory Dorman, Nathan Folkert, Abhinav Gupta, Lei Shen, Sankar Subramanian
2003 Proceedings of the 2003 ACM SIGMOD international conference on on Management of data - SIGMOD '03  
One of the critical deficiencies of SQL is lack of support for ndimensional array-based computations which are frequent in OLAP environments.  ...  In addition, we present optimizations, access structures and execution models for processing them efficiently.  ...  This paper proposes spreadsheet-like computations in RDBMS through extensions to SQL, leaving the user interface aspects to be handled by OLAP tools.  ... 
doi:10.1145/872766.872767 fatcat:3rlgkitm5vds7f3d3rstnyqtem

Spreadsheets in RDBMS for OLAP

Andrew Witkowski, Srikanth Bellamkonda, Tolga Bozkaya, Gregory Dorman, Nathan Folkert, Abhinav Gupta, Lei Shen, Sankar Subramanian
2003 Proceedings of the 2003 ACM SIGMOD international conference on on Management of data - SIGMOD '03  
One of the critical deficiencies of SQL is lack of support for ndimensional array-based computations which are frequent in OLAP environments.  ...  In addition, we present optimizations, access structures and execution models for processing them efficiently.  ...  This paper proposes spreadsheet-like computations in RDBMS through extensions to SQL, leaving the user interface aspects to be handled by OLAP tools.  ... 
doi:10.1145/872757.872767 dblp:conf/sigmod/WitkowskiBBDFGSS03 fatcat:g6f52zdz6jfnja3cneqzhqd2mu

Business Modeling Using SQL Spreadsheets [chapter]

Andrew Witkowski, Srikanth Bellamkonda, Tolga Bozkaya, Nathan Folkert, Abhinav Gupta, Lei Sheng, Sankar Subramanian
2003 Proceedings 2003 VLDB Conference  
One of the critical deficiencies of SQL is the lack of support for array and spreadsheet like calculations which are frequent in OLAP and Business Modeling applications.  ...  The limitations of RDBMS have been filled by spreadsheets and specialized MOLAP engines which are good at formulas for mathematical modeling but lack the formalism of the relational model, are difficult  ...  It stores the Excel data cells in relational tables and Excel formulas in relational views with SQL Spreadsheet clause. 6 References [1] "Spreadsheet in RDBMS for OLAP", SIGMOD 2003, San Diego, USA.  ... 
doi:10.1016/b978-012722442-8/50119-1 dblp:conf/vldb/WitkowskiBBFGSS03 fatcat:7uivilf6hbf4bg7fjppv6syeji

Where is business Intelligence taking today's Database Systems? [chapter]

William O'Connell
2004 Proceedings 2004 VLDB Conference  
their own unique solutions for BI (Spreadsheet in SQL, statistical and window functions in SQL, new join methods for data densification, etc.).  ...  This application provided valuable feedback on performance, functionality, manageability and integration of BI features in RDBMs. Consequently it gave a raise to new trends in BI technologies.  ... 
doi:10.1016/b978-012088469-8.50113-3 dblp:conf/vldb/OConnellWBC04 fatcat:anlkwaxe5bdhtn3c2ng7srcddy

Online Analytical Processing (OLAP) for Decision Support [chapter]

Nenad Jukic, Boris Jukic, Mary Malliaris
2008 Handbook on Decision Support Systems 1  
While OLTP is used in conjunction with traditional databases for operational (day-to-day) purposes, OLAP works (as is described in the next section) with the data from data warehouses and data marts.  ...  In fact an often-used technical term for an operational database is the "OLTP system".  ...  However, those functionalities are found in other non-OLAP applications, such as statistical tools or spreadsheet software.  ... 
doi:10.1007/978-3-540-48713-5_13 fatcat:vtjf5i6osjdf3bwwpyof4se2oy

Life cycle of a data warehousing project in healthcare

R Verma, J Harper
2001 Journal of healthcare information management : JHIM  
The ODS has served its purpose well and has whetted management's appetite for more information and faster, more reliable access, all in one location.  ...  The "classical" approach is being taken: enhancing the ODS, which is largely normalized in structure, and integrating data from various sources, along with enforcing business rules.  ...  The source systems include the OLTP system for membership and many Access databases and Excel spreadsheets for revenue.  ... 
pmid:11452573 fatcat:ig7vyqcgt5gcbbkp3zinactug4

Data Migration From SQL to MongoDB

Nuzhat F. Shaikh
2018 HELIX  
As the Internet related technologies have emerged, a lot of changes were observed in the data collected, stored and processed by the organizations.  ...  The new incoming data was unstructured, available from a number of outside areas and accumulated in large volumes within a small time span.  ...  The tool automatically queries the data from the tables in the databases and outputs them in column form for implementation in spreadsheets.  ... 
doi:10.29042/2018-3701-3704 fatcat:xuu6kf55j5c7hidx7glxjqjdaq

A Review on Business Intelligence and Big Data

Erkan Sirin
2017 International Journal of Intelligent Systems and Applications in Engineering  
This paper overviews the current state of the art of BI and big data, and discuss how big data era affects BI solutions in general context.  ...  As data is growing exponentially, storage, process, and analytics tools and technologies become more important for BI solutions.  ...  OLAP is an amazing tool for multidimensional data exploration. But big data has not yet matured as much as RDBMS in terms of integration of multidimensional data [65] .  ... 
doi:10.18201/ijisae.2017533861 fatcat:56mrk4rtozadxk7krjyws4vm2y

NOSQL Databases

Raj Lalwani
2018 International Journal for Research in Applied Science and Engineering Technology  
NoSql databases are useful for large sets of distributed data. NoSql databases are effective for big data performance issues that relational databases aren't built to solve.  ...  Databases are needed to store data in a standard format and at a proper location. Earlier Flat File System were used to store data, but there was no standard being implemented in Flat Files.  ...  Relational Rdbms C. OLAP Data warehousing Earlier Flat File System were used to store data. But There was no Standard being implemented in Flat Files.  ... 
doi:10.22214/ijraset.2018.6133 fatcat:tqcij6uipbb4bkrbs4ge5jilpa

Dashboards for Progression Analysis of Students

Prabhleen Juneja
2016 IOSR Journal of Computer Engineering  
The dashboard is tailored for a specific role and display metrics are targeted for a single point of view of a department. It is a customizable interface and pulls real-time data from various sources.  ...  The dashboard is a visualization device which shows the present status of metrics and Key Performance Indicators (KPIs) for an endeavor.  ...  The dimensional model empowers Oracle OLAP to bolster top of the line business insight apparatuses and applications, for example, OracleBI Discoverer Plus OLAP,OracleBI Spreadsheet Add-In, OracleBI Suite  ... 
doi:10.9790/0661-15010010113-19 fatcat:zeweigofane2pfu7bdxr3s4s5u

An introduction to data warehousing: what are the implications for the network?

Katherine Jones
1998 International Journal of Network Management  
the needs of management in the that for informational or analytic needs. decision-making process.  ...  In an ideal world, the analyst could analytical data. ¼ The processing characteristics for the oper-simply query the operational database in a corporation to ascertain the long-term effects of ational  ...  Sites retain full control OLAP OLAP (on-line analytical processing) over access and security; the only limit to the database's size is that of the RDBMS.  ... 
doi:10.1002/(sici)1099-1190(199801/02)8:1<42::aid-nem236>3.0.co;2-m fatcat:xbwdy3zig5ffxjujqgt2lygdbu

Managing Metadata in Data Warehouses: Pitfalls and Possibilities

G. Shankaranarayanan, Adir Even
2004 Communications of the Association for Information Systems  
While the benefits of metadata and challenges in implementing metadata solutions are widely addressed in practitioner publications, explicit discussion of metadata in academic literature is rare.  ...  It also describes solutions for addressing some of these challenges.  ...  Unlike OLAP offered by RDBMS vendors, the metadata for Hyperion is not stored in a relational structure, but in a proprietary one.  ... 
doi:10.17705/1cais.01413 fatcat:ws2bovqztrehzh3zhw44c2nuay

Overview of OLAP cubes, importance, build Considerations and querying with MDX

Anil Dundappa Devangavi, Dr Puneet Aggarwal
2010 INTERNATIONAL JOURNAL OF COMPUTERS & TECHNOLOGY  
An OLAP cube is a method of storing data in a multidimensional form, generally for reporting purposes.  ...  The purpose of an OLAP cube is to store data in such a way that an end user can slice and dice through the data and the storage structure itself (multidimensional) while allowing for very fast access to  ...  Mathematical Definition In database theory, an OLAP cube is [7] an abstract representation of a projection of an RDBMS relation.  ... 
doi:10.24297/ijct.v9i1.4163 fatcat:ujbbhqvpgvc3jj4b6zeaactvri

Horizontal Aggregations in SQL to Prepare Data Sets for Data Mining Analysis

V. Pradeep Kumar
2012 IOSR Journal of Computer Engineering  
In fact these aggregate functions are generating vertical aggregations. This paper presents techniques to support horizontal aggregations through SQL queries.  ...  Data mining is widely used domain for extracting trends or patterns from historical data. However, the databases used by enterprises can't be directly used for data mining.  ...  For performing spreadsheet like operations, alternative SQL extensions are proposed in [8] .  ... 
doi:10.9790/0661-0653641 fatcat:uh76aqt4ofethpo7kq3zzm5zgm

On-Line Analytical Processing [chapter]

Alberto Abelló, Oscar Romero
2014 Encyclopedia of Database Systems  
These rules caused heated controversy, and they did not succeed as Codd's earlier proposal for relational database management systems (RDBMS).  ...  Thus, it was in 1993 that Codd et al. [5] , coined the term OLAP. In that report, the authors defined 12 rules for a tool to be considered OLAP.  ... 
doi:10.1007/978-1-4899-7993-3_252-2 fatcat:6b6d66nebvd63mts7fako5xdni
« Previous Showing results 1 — 15 out of 174 results