Translating Relational Queries Into Spreadsheets - Coimbatore
Tuesday, 1 December 2015
No photo
Item details
City:
Coimbatore, Tamil Nadu
Offer type:
Offer
Item description
ABSTRACT:
Spreadsheets are among the most commonly used applications for data management and analysis. They combine data processing with very diverse supplementary features: statistics, visualization, reporting, linear programming solvers, Web queries periodically downloading data from external sources, etc. However, the spreadsheet paradigm of computation still lacks sufficient analysis. In this article we demonstrate that a spreadsheet can implement all data transformations definable in SQL, merely by utilizing spreadsheet formulas. We provide a query compiler, which translates any given SQL query into a worksheet of the same semantics, including NULL values. Thereby database operations become available to the users who do not want to migrate to a database. They can define their queries using a high-level language and then get their execution plans in a plain vanilla spreadsheet. The functions available in spreadsheets impose limitations on the algorithms one can implement. In this paper we offer O(n log2 n) sorting spreadsheet, using a non-constant number of rows, and, surprisingly, Depth-First-Search and Breadth-First- Search on graphs.
For more details, Contact
ph:9095395333,9159115969
Office Address:
LansA Informatics Pvt Ltd,
165, 5th Street, Cross cut road,
Gandhipuram, Coimbatore-641012
Spreadsheets are among the most commonly used applications for data management and analysis. They combine data processing with very diverse supplementary features: statistics, visualization, reporting, linear programming solvers, Web queries periodically downloading data from external sources, etc. However, the spreadsheet paradigm of computation still lacks sufficient analysis. In this article we demonstrate that a spreadsheet can implement all data transformations definable in SQL, merely by utilizing spreadsheet formulas. We provide a query compiler, which translates any given SQL query into a worksheet of the same semantics, including NULL values. Thereby database operations become available to the users who do not want to migrate to a database. They can define their queries using a high-level language and then get their execution plans in a plain vanilla spreadsheet. The functions available in spreadsheets impose limitations on the algorithms one can implement. In this paper we offer O(n log2 n) sorting spreadsheet, using a non-constant number of rows, and, surprisingly, Depth-First-Search and Breadth-First- Search on graphs.
For more details, Contact
ph:9095395333,9159115969
Office Address:
LansA Informatics Pvt Ltd,
165, 5th Street, Cross cut road,
Gandhipuram, Coimbatore-641012
Related ads
iConic Translation World is a comprehensive and professional translation company, specializing in…
United Global Soft provides Hyperion Financial Management Online Training course by excellent…
Are you looking for Language Translation Interpretation and Transcription Service? Call on given…
ITGuru Best Tableau Courses Online Training helps you to know the simplification of raw data in an…
M.A Education is a two-year postgraduate program that is divided into 4 semesters. M.A Education…
01204566983 Bengali to English Translation Service in Delhi Punjab Gurgaon Pune (Delhi)
Bengali Language Translation Interpretation and Transcription services by Randawa provide…
BUSINESS OBJECTS ONLINE TRAINING COURSE BUSINESS OBJECTS ENTERPRISE XI R2 AND R3 SAP BUSINESS…
CrowdOp: Query Optimization For Declarative Crowd sourcing Systems (Coimbatore, Tamil Nadu)
ABSTRACT We study the query optimization problem in declarative crowdsourcing systems. Declarative…
SAP BO(XIR/3 & R/4) ONLINE TRAINING * TOTAL JOB SUPPORT ( SAP BO, CRYSTAL, XCELSIUS) * RESUME…
Hai I am Anirudh working for an MNC , having 4 years of experience can teach SAP-BO with real time…
