The Oracle Academy’s Hosted Database offering provides web-enabled access to an Oracle database for schools that have experienced IT staff to teach database fundamentals using their own curriculum. Using Oracle’s HTML DB web interface, schools harness the power of the Oracle database to teach students relational database concepts. Because this service is hosted by Oracle, there is no need to install or maintain any hardware or software.
Read the rest of this entry »

• 0 Comments

This IBM® Redpaper gives a example of procedures to restore the Microsoft® SQL 2000 and 2005 using SnapManager®.There are options discussed that depend on the type of disaster, the type of data recovery, and the type of system on which the disaster applies.
Read the rest of this entry »

• 0 Comments

This manual was compiled by Project A Web Development as a project supported by Jim Teece. It was written by Ethan Townsend as a documented means of migrating our ADO ASP application, SIB (Site­in­a­box), from Microsoft SQL Server 7.0 to an open source database. SIB is a large database­ driven application that includes many views, stored procedures, and complex SQL executed from the ASP pages.
Read the rest of this entry »

• 0 Comments

Unisys and Microsoft have dispelled the perception that for high performance ETL, the only alternative is a UNIX-based solution. With SQL Server 2005 Integration Services, Microsoft and Unisys deliver an optimized ETL solution that will support even the most demanding enterprise Business Intelligence (BI) initiatives. They conducted a series of real ETL (Extraction, Transformation and Load) tests with Microsoft SQL Server 2005 Integration Services (SSIS, formerly known as DTS). Performance tests compared throughput, scalability and performance on both 32- and 64-bit processor configurations on a Unisys ES7000. SSIS demonstrated parallelism and the ability to utilize all available CPUs in multiple aggregation, parallel lookup and transformation testing.
Read the rest of this entry »

• 0 Comments

This tutorial demonstrates how to import an Excel file into an Access database. You can also follow these same steps to import other data tables into Access, such as dbf files or txt files, with some minor variation. This document uses some standard database terminology, referring to columns as fields and rows as records.
Read the rest of this entry »

• 0 Comments

Microsoft SQL Server 2008 introduces two new compression features (available in Enterprise and Developer editions) that are of interest to users with large databases. Data compression applies to individual tables and indexes within a database and comes in two options: ROW and PAGE. Backup compression is a new option when backing up a database to external storage. Both compression techniques can be used to reduce the amount of online storage required for databases and their backups.
Read the rest of this entry »

• 0 Comments

This tutorial demonstrates how to import an ESRI shapefile into an Access database using the ArcCatalog. Microsoft Access databases are compatible with ArcGIS, as tables within Access databases can be directly accessed by ArcGIS and added to ArcMap. When geographic boundary files are exported to an Access database, the database can then serve as a personal geodatabase: a container for organizing and storing multiple geographic boundary files and data tables. (see the How to Import Data into Microsoft Access tutorial for importing data tables into Access).
Read the rest of this entry »

• 0 Comments

OpenOffice.org (OOo) is able to read and write from a wide variety of databases, as long as they support one of the standard interface specifications such as ODBC or JDBC. Fortunately, Microsoft Access (MS-Access) supports ODBC. This HOW-TO takes you step by step through the process of linking OOo to MS-Access using ODBC.
Read the rest of this entry »

• 0 Comments