Results 211 to 220 of about 53,818 (265)
Some of the next articles are maybe not open access.
ACM SIGMOD Record, 1999
For several years now, you've been hearing and reading about an emerging standard that everybody has been calling SQL3. Intended as a major enhancement of the current second generation SQL standard, commonly called SQL-92 because of the year it was published, SQL3 was originally planned to be issued in about 1996…but things didn't go as planned.
Andrew Eisenberg, Jim Melton
openaire +1 more source
For several years now, you've been hearing and reading about an emerging standard that everybody has been calling SQL3. Intended as a major enhancement of the current second generation SQL standard, commonly called SQL-92 because of the year it was published, SQL3 was originally planned to be issued in about 1996…but things didn't go as planned.
Andrew Eisenberg, Jim Melton
openaire +1 more source
Proceedings of the VLDB Endowment, 2014
Current applications, from complex sensor systems (e.g. quantified self) to online e-markets acquire vast quantities of personal information which usually end-up on central servers. This information represents an unprecedented potential for user customized applications and business (e.g., car insurance billing, carbon tax, traffic decongestion ...
Quoc-Cuong To +2 more
openaire +2 more sources
Current applications, from complex sensor systems (e.g. quantified self) to online e-markets acquire vast quantities of personal information which usually end-up on central servers. This information represents an unprecedented potential for user customized applications and business (e.g., car insurance billing, carbon tax, traffic decongestion ...
Quoc-Cuong To +2 more
openaire +2 more sources
Introduction to SQL, SQL*Plus, and SQL Developer
2009This chapter provides an introduction to the SQL language and two tools for working with it. The first section presents a high-level overview of the SQL language, which will give you an idea of the capabilities of this language. Then some important basic concepts of the SQL language are introduced in the second section, such as constants, literals ...
Lex de Haan +4 more
openaire +1 more source
Parallel SQL on Tandem's NonStop SQL
Digest of Papers. COMPCON Spring 89. Thirty-Fourth IEEE Computer Society International Conference: Intellectual Leverage, 2003A comparison is made of a number of different strategies for the concurrent execution of multiple SQL (structured query language) statements on a completely nonsharing multiprocessor system. The author gives some preliminary results in the form of heuristics derived from measurements on a Tandem system.
openaire +1 more source
Data & Knowledge Engineering, 1994
Abstract The relational database model is defined in terms of sets, whereas SQL needs the DISTINCT option for explicit duplicate removal. We define the underlying concept of duplicate tuples, generalize the operators of the relational algebra and study the connection with logic. It is shown that ‘baggy’ operators violate classical equivalences.
Kwast, K.L., van Denneheuvel, S.J.
openaire +3 more sources
Abstract The relational database model is defined in terms of sets, whereas SQL needs the DISTINCT option for explicit duplicate removal. We define the underlying concept of duplicate tuples, generalize the operators of the relational algebra and study the connection with logic. It is shown that ‘baggy’ operators violate classical equivalences.
Kwast, K.L., van Denneheuvel, S.J.
openaire +3 more sources
Computing in Science & Engineering, 2009
In a cloud computing context, the MapReduce algorithm comprises two massively parallel operations linked by a generic sorting and data-distribution process. Although this algorithm is the workhorse in most cloud computing strategies, it's a special case of a more general dataflow.
openaire +1 more source
In a cloud computing context, the MapReduce algorithm comprises two massively parallel operations linked by a generic sorting and data-distribution process. Although this algorithm is the workhorse in most cloud computing strategies, it's a special case of a more general dataflow.
openaire +1 more source
SQL multimedia and application packages (SQL/MM)
ACM SIGMOD Record, 2001Regular readers of this column will have become familiar with database language SQL -- indeed, most readers are already familiar with it. We have also discussed the fact that the SQL standard is being published in multiple parts and have even discussed one of those parts in some detail[l].Another standard, based on SQL and its structured user-defined ...
Jim Melton, Andrew Eisenberg
openaire +1 more source
SQL-G: Efficient Graph Analytics by SQL
IEEE Transactions on Knowledge and Data Engineering, 2019Querying graphs and conducting graph analytics become important in data processing since many real applications are dealing with massive graphs, such as online social networks, Semantic Web, knowledge graphs, etc. Over the years, many distributed graph processing systems have been developed to support graph analytics using various programming models ...
Kangfei Zhao +3 more
openaire +1 more source
2011
Functions are an integral part of any well-designed PL/SQL application. They are an embodiment of programming best practices, such as code modularization, reuse, and the encapsulation of business or application logic. When used as simple building-blocks for larger programs, they can be an elegant and simple way to extend functionality while reducing ...
openaire +1 more source
Functions are an integral part of any well-designed PL/SQL application. They are an embodiment of programming best practices, such as code modularization, reuse, and the encapsulation of business or application logic. When used as simple building-blocks for larger programs, they can be an elegant and simple way to extend functionality while reducing ...
openaire +1 more source
2015
All database activity is conducted in SQL, and therefore database administrators need to be intimately familiar with it. Figure 2-1 illustrates that the greatest potential for performance improvement usually lies within the software application, not within the database where the application stores its data or within the physical infrastructure where ...
openaire +1 more source
All database activity is conducted in SQL, and therefore database administrators need to be intimately familiar with it. Figure 2-1 illustrates that the greatest potential for performance improvement usually lies within the software application, not within the database where the application stores its data or within the physical infrastructure where ...
openaire +1 more source