Filters








3,164 Hits in 2.7 sec

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  
We present examples of typical Business Modeling computations with SQL spreadsheet and compare them with the ones using standard SQL showing performance advantages and ease of programming for the former  ...  This demo presents a scalable, mathematically rigorous, and performant SQL extensions for Relational Business Modeling, called the SQL Spreadsheet.  ...  We will present typical Business Modeling solutions using SQL Spreadsheet and compare their formulations and performance to that of standard SQL.  ... 
doi:10.1016/b978-012722442-8/50119-1 dblp:conf/vldb/WitkowskiBBFGSS03 fatcat:7uivilf6hbf4bg7fjppv6syeji

ES-SQL: Visually querying spreadsheets

Jacome Cunha, Joao Paulo Fernandes, Jorge Mendes, Rui Pereira, Joao Saraiva
2014 2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)  
This paper presents ES-SQL, an embedded tool for visually constructing queries over spreadsheets.  ...  This tool provides an expressive query environment which has knowledge on the business logic of spreadsheets, and by this knowledge it assists the user in defining the intended queries.  ...  The uses of spreadsheets range from simple single user applications to large business oriented decision making calculations.  ... 
doi:10.1109/vlhcc.2014.6883056 dblp:conf/vl/CunhaFMPS14a fatcat:67qgmath3bexbazq5xzo2pleyq

Embedding model-driven spreadsheet queries in spreadsheet systems

Jacome Cunha, Joao Paulo Fernandes, Jorge Mendes, Rui Pereira, Joao Saraiva
2014 2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)  
The result is an expressive and powerful query environment that has knowledge of the business logic defined by the spreadsheet data (the spreadsheet model) to guide end users constructing correct queries  ...  In this work we embed the textual query language in the model-driven spreadsheet environment as a spreadsheet itself.  ...  Using these models, we are able to define the business logic of a spreadsheet in a concise and abstract manner.  ... 
doi:10.1109/vlhcc.2014.6883039 dblp:conf/vl/CunhaFMPS14 fatcat:xlwtntmjkbc6ziolfqzjsnrcuy

Querying model-driven spreadsheets

Jacorne Cunha, Joao Paulo Fernandes, Jorge Mendes, Rui Pereira, Joao Saraiva
2013 2013 IEEE Symposium on Visual Languages and Human Centric Computing  
Our approach builds on a model-driven spreadsheet development environment, and queries are expressed referencing entities in the model of a spreadsheet instead of in its actual data.  ...  Spreadsheets are being used with many different purposes that range from toy applications to complete information systems.  ...  Model-Driven Spreadsheets Because spreadsheets may evolve into complex software systems, Engels and Erwig [9] introduced ClassSheets as a model formalism to express the business logic spreadsheet data  ... 
doi:10.1109/vlhcc.2013.6645247 dblp:conf/vl/CunhaFMPS13 fatcat:iqk5xkx5e5g53bpls3yrl5q3ta

Sigma Worksheet: Interactive Construction of OLAP Queries [article]

James Gale and Max Seiden and Gretchen Atwood and Jason Frantz and Rob Woollen and Çağatay Demiralp
2021 arXiv   pre-print
However, existing tools for analyzing data in CDWs are either limited in ad-hoc transformations or difficult to use for business users, the largest user segment in enterprises.  ...  For this, Sigma Worksheet provides an accessible spreadsheet-like interface for data analysis through direct manipulation.  ...  We also thank the early users of Sigma for teaching us so much and having patience with our bugs. Special thanks to Zack Norton for producing and narrating our demonstration video.  ... 
arXiv:2012.00697v3 fatcat:xezl2ygjrfhghg6tcrzzgegigi

Querying Spreadsheets: An Empirical Study [article]

Jácome Cunha, João Paulo Fernandes, Rui Pereira, João Saraiva
2015 arXiv   pre-print
We investigate the use of the Google Query Function, textual model-driven querying, and visual model-driven querying.  ...  To compare these different querying approaches we present an empirical study whose results show that the end-users' productivity increases when using model-driven queries, specially using its visual representation  ...  In this case model-driven spreadsheet models were used, specifically ClassSheets [3, 4, 10] : a high-level and objectoriented formalism, using the notion of classes and attributes, to express business  ... 
arXiv:1502.07948v1 fatcat:up3hpeukmrfvjpmslkhaipbmxe

Graphical Querying of Model-Driven Spreadsheets [chapter]

Jácome Cunha, João Paulo Fernandes, Rui Pereira, João Saraiva
2014 Lecture Notes in Computer Science  
end-users with little to no knowledge of SQL.  ...  We briefly show our previous text based model-driven querying system.  ...  One of such spreadsheet models is ClassSheets [3, 4] , a highlevel and object-oriented formalism, using the notion of classes and attributes, to express business logic spreadsheet data.  ... 
doi:10.1007/978-3-319-07731-4_42 fatcat:3qwgvb5aqbhofms65fo7g4zog4

QuerySheet: A bidirectional query environment for model-driven spreadsheets

Orlando Belo, Jacorne Cunha, Joao Paulo Femandes, Jorge Mendes, Rui Pereira, Joao Saraiva
2013 2013 IEEE Symposium on Visual Languages and Human Centric Computing  
This paper presents a tool, named QUERYSHEET, to query spreadsheets. We defined a language to write the queries, which resembles SQL, the language to query databases.  ...  This allows to write queries which are more related to the spreadsheet content than with current approaches.  ...  The ClassSheet model defining the business logic of this spreadsheet is shown in Figure 1 (Model worksheet). Suppose that we would like to know: • How much have we profited from each client?  ... 
doi:10.1109/vlhcc.2013.6645267 dblp:conf/vl/BeloCFMPS13 fatcat:tej5cmteojetngpboebdreofzi

Not Economic Informatics but Informatic Economics — The development of the subject Economic Informatics in the commercial colleges in North-Rhine Westphalia, Germany [chapter]

Gregor Kuhlmann
1997 The Place of Information Technology in Management and Business Education  
The contents of this subject are to be increasingly oriented towards the problems of business information economy when employing SQL-database systems and spreadsheet programs.  ...  The Ministry of Education requires extensive use of standard software in economics lessons. As a consequence, some experts demand that the subject Economic Informatics be deleted.  ...  As SQL-capable database systems are increasingly employed in business, the database program used in lessons must also be SQL-capable. SQL-statements can be formulated in different ways.  ... 
doi:10.1007/978-0-387-35089-9_15 fatcat:lvjhpev3drchnfzgosadcizl24

Design and Implementation of Queries for Model-Driven Spreadsheets [chapter]

Jácome Cunha, João Paulo Fernandes, Jorge Mendes, Rui Pereira, João Saraiva
2015 Lecture Notes in Computer Science  
This paper presents a domain-specific querying language for model-driven spreadsheets.  ...  of the language and present in detail its implementation, from the denormalization of data and translation of our user-friendly query language to a more efficient query, to the execution of the query using  ...  Using ClassSheets, we can define the business logic of a spreadsheet in a concise and abstract manner.  ... 
doi:10.1007/978-3-319-15940-9_13 fatcat:2mwmkwamgrfb3kfdapkyl3vht4

Development of datamining software for the city water supply company

O G Orlinskaya, E V Boiko
2018 Journal of Physics, Conference Series  
Data mining with SQL Server has the following advantages: − the ability to use a variety of spreadsheet data as a source for data mining.  ...  We suggest using Microsoft SQL Server to develop Business Intelligence solutions. This DBMS works well with the "1C:Enterprise" platform.  ... 
doi:10.1088/1742-6596/1015/4/042047 fatcat:ppugl6ypd5dmlbdvp5vxkj3rj4

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  
This has created a gap that has 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  ...  This paper presents SQL extensions involving array based calculations for complex modeling.  ...  SQL Spreadsheet experiment. Many SQL Spreadsheet operations can be expressed with standard ANSI SQL using joins and UNIONs.  ... 
doi:10.1145/872757.872767 dblp:conf/sigmod/WitkowskiBBDFGSS03 fatcat:g6f52zdz6jfnja3cneqzhqd2mu

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  
This has created a gap that has 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  ...  This paper presents SQL extensions involving array based calculations for complex modeling.  ...  SQL Spreadsheet experiment. Many SQL Spreadsheet operations can be expressed with standard ANSI SQL using joins and UNIONs.  ... 
doi:10.1145/872766.872767 fatcat:3rlgkitm5vds7f3d3rstnyqtem

A Study on Integrating Business Intelligence into E-Business

Sim Sheng Hooi, Wahidah Husain
2012 International Journal on Advanced Science, Engineering and Information Technology  
Business intelligence tools could be used to extract accurate and useful information about future forecasts, business patterns, and business decision making.  ...  However, a lot of data collected from global and local e-businesses is complex and unstructured and thus of limited use.  ...  brick and mortar business model.  ... 
doi:10.18517/ijaseit.2.6.239 fatcat:ynaird36kbcnll7xi66lv6xaim

Why decision support fails and how to fix it

Ralph Kimball, Kevin Strehlo
1995 SIGMOD record  
The answer: dimensional modeling and new SQL functions.  ...  b A data model optimized for transactions and a language that makes business questions hard to answer cause decision support systems to flounder.  ...  Many of the most basic business questions will still go beyond the capabilities of simple query :ools, requiring tortuous SQL or hand-stitching an-;wers together in a spreadsheet or similar tool.  ... 
doi:10.1145/211990.212023 fatcat:isszunlwn5a4jdsquwej2wor6u
« Previous Showing results 1 — 15 out of 3,164 results