| A. Eisenberg and J. Melton. SQL standardization: The next steps. SIGMOD Record, 29(1):63--67, 2000. |
....to express in SQL only intercolumn computations are easy to specify. Additionally, transpositions of rows and columns are not easily possible, requiring the manual specification and combination of multiple views. Although extensions of SQL, such as the data cube operator [2] query windows [5], advanced by the standards bodies, will remedy some of the problems, the concept of hierarchical dimensions is still not handled satisfactorily. To summarize, we have seen that neither spreadsheets nor relational databases fully support the requirements for advanced data analysis. To be fair, ....
A. Eisenberg and J. Melton. SQL Standardization: The Next Steps. SIGMOD Record 29(1):63--67, 2000.
....(external) actions in a similar way and integrates them into a transactional execution. It is possible to extend SQL, too, with calls to external systems, but these must happen outside of SQL in a host language program, and are in general outside the scope of transaction control. Recent work [EM00] aims at the extension of the standard w.r.t. management of external data (SQL MED) which then allows to treat external systems as data sources just like the database itself. Yet, it remains to be seen if this also allows the adequate modeling of external actions. SQL is a widely used standard ....
A. Eisenberg and J. Melton. SQL standardization: The next steps. SIGMOD Record, 29(1):63--67, 2000.
....automatically executed when specified events happen and particular conditions are met. Examples of the use of active capabilities are integrity constraint enforcement, authorization and monitoring. Most recent relational and object relational DBMSs and the forthcoming standard SQL:1999 [EIS 00b, EIS 00a] provide those capabilities. Moreover, several proposals for adding triggers to object oriented database systems have been presented [CER 96, PAT 99] In both the relational and the object frameworks active rules provide a comprehensive means to formally state the semantics of data, the ....
EISENBERG A., MELTON J., "SQL Standardization: The Next Steps", ACM SIGMOD Record, vol. 29, num. 1,
No context found.
A. Eisenberg and J. Melton. SQL standardization: The next steps. SIGMOD Record, 29(1):63--67, 2000.
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC