A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2007; you can also visit the original URL.
The file type is application/pdf.
Filters
Business Modeling Using SQL Spreadsheets
[chapter]
2003
Proceedings 2003 VLDB Conference
Preserved Fulltext
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
2014
2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2014
2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2013
2013 IEEE Symposium on Visual Languages and Human Centric Computing
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
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]
2021
arXiv
pre-print
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit the original URL.
The file type is application/pdf.
Other Versions
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]
2015
arXiv
pre-print
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
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]
2014
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2015; you can also visit the original URL.
The file type is application/pdf.
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
2013
2013 IEEE Symposium on Visual Languages and Human Centric Computing
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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]
1997
The Place of Information Technology in Management and Business Education
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2018; you can also visit the original URL.
The file type is application/pdf.
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]
2015
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2018
Journal of Physics, Conference Series
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
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
2003
Proceedings of the 2003 ACM SIGMOD international conference on on Management of data - SIGMOD '03
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2015; you can also visit the original URL.
The file type is application/pdf.
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
2003
Proceedings of the 2003 ACM SIGMOD international conference on on Management of data - SIGMOD '03
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2007; you can also visit the original URL.
The file type is application/pdf.
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
2012
International Journal on Advanced Science, Engineering and Information Technology
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
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
1995
SIGMOD record
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2006; you can also visit the original URL.
The file type is application/pdf.
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