In this paper we construct a Star Join Schema and show how this schema can be created using the basic tools delivered with SQL Server 7.0. Major objectives are to keep the operational database unchanged so that data loading can be done without disturbing the business logic of the operational database. The operational database is an expanded version of the Pubs database [Sol96].

En la actualidad existen herramientas que generan código fuente de forma automática. este trabajo se propone un modelo generación enfocada en arquitectura 3 capas abarcando el lado del backend utilizando data driven, adicionalmente construimos una herramienta fuente. La Herramienta permite cargar esquema base datos y a partir genera para lenguaje SQL Server C#, utilizamos archivo .xls importar ...

Inc. coincided with the widespread availability and use of very large memory (VLM) technology on DIGITAL’s Alpha microprocessor-based computer systems. Technological features of the System 11 SQL Server were used to achieve record results of 14,176 transactions-per-minute C (tpmC) at $198/tpmC on the DIGITAL AlphaServer 8400 server product. One of these features, the Logical Memory Manager, pro...

CryptDB is a DBMS that provides provable and practical privacy in the face of a compromised database server or curious database administrators. CryptDB works by executing SQL queries over encrypted data. At its core are three novel ideas: an SQL-aware encryption strategy that maps SQL operations to encryption schemes, adjustable query-based encryption which allows CryptDB to adjust the encrypti...

The Microsoft TerraServer stores aerial and satellite images of the earth in a SQL Server Database served to the public via the Internet. It is the world’s largest atlas, combining five terabytes of image data from the United States Geodetic Survey, Sovinformsputnik, and Encarta Virtual GlobeTM. Internet browsers provide intuitive spatial and gazetteer interfaces to the data. The TerraServer de...

Spatial analysis is a fundamental function for geographic information systems. Although it is popular in many commercial desktop GIS packages, this capability is very limited in a Web-GIS environment, especially when relational database is used for geospatial data management. This paper proposes and prototypes a methodology to enhance spatial analysis capabilities of Web-GIS by extending and en...

We propose a multi-dimensional language called nD-SQL with the following features: (i) nD-SQL supports queries that interoperate amongst multiple relational sources with heterogeneous schemas, including RDBMS and relational data marts, overcoming the mismatch between data and schema; (ii) it supports complex forms of restructuring that permit the visualization of ndimensional data using the thr...

SQL in the IBM® DB2® Universal DatabaseTM for Linux®, UNIX®, and Windows® (DB2 UDB) database management product has been extended to support nested INSERT, UPDATE, and DELETE operations in SELECT statements. This allows database applications additional processing on modified rows. Within a single unit of work, applications can retrieve a result set containing the modified rows from a table or v...

Relational database systems (and the related standards body ANSI/INCITS H2) are busy adding XML support. One of the main components of such XML extensions will be support for the upcoming XML query language XQuery. The presentation will outline how XQuery and XML conceptually fit into a relational database environment. It will cover the organization of the XML in the database, how to type it us...