The increase in electricity consumption coupled with the lack of a convenient way to assist consumers lower their is growing concern. Smart internet things (IoT)-based devices has been developed this regard. However, no specific standards were followed, and problem for consumer as they have own different smart device from brands which results higher cost. To solve these issues, power switch usi...

Does SAS implicit SQL pass-through sometimes fail to meet your needs? Do you sometimes need to communicate directly with your Oracle or DB2 database in that database's native language? Explicit SQL pass-through might be your solution. The author briefly introduces syntax for explicit SQL pass-through queries before showing examples of specific situations when explicit pass-through queries solve...

Data warehousing requires facilities for moving and transforming data and meta-data. This paper describes such facilities that are integrated with Microsoft SQL Server 7.0, particularly as they relate to meta-data and information models in its shared repository. It also discusses the use of XML to move meta-data between tools.

A table to be managed by a Scalable Distributed Database System (SD-DBS) should be able to horizontally scale over several DBMSs. The partitioning and especially its dynamic evolution should remain transparent to the application. We propose an architecture for an SD-DBS. Our architecture aims at SQL Server, but generalizes to other relational DBSs.

We present SVT, a tool for validating database schemas in SQL Server. This is done by means of testing desirable properties that a database schema should satisfy. To our knowledge, no commercial relational DBMS provides yet a tool able to perform such kind of validation.

In this paper we present the results from an analysis focusing on security threats that can arise against an SQL server when included in Web application environments. The approach used is based on the STRIDE classification methodology. The results presented provide also some general guidelines and countermeasures against the different attacks that can exploit the identified

The increasing complexity of Database Management Systems (DBMSs) and the dearth of their experienced administrators make an urgent call for an Autonomic DBMS that is capable of managing and maintaining itself. In this paper, we examine the characteristics that a DBMS should have in order to be considered autonomic and assess the position of today’s commercial DBMSs such as DB2, SQL Server, and ...

The paper presents an approach for plagiarism detection using Microsoft SQL Server platform in a large corpus of documents. The approach was used for participation in the first international plagiarism detection competition that was held as a part of PAN’09 workshop. The main advantages of the proposed approach are its high precision, good performance and readiness for deployment into a product...

The query execution engine in Microsoft SQL Server employs hash-based algorithms for inner and outer joins, semi-joins, set operations (such as intersection), grouping, and duplicate removal. The implementation combines many techniques proposed individually in the research literature but never combined in a single implementation, neither in a product nor in a research prototype. One of the pape...