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 »
Microsoft Access is a powerful data-management tool that allows you to input, store, and report data in an attractive and efficient way. Although Access has templates and “wizards” to help you easily set up a database that can suit simple purposes, it can also run extremely advanced functions. This handout is intended to introduce new users to the basic functions of Access.
Read the rest of this entry »
WHAT IS A MySQL DATABASE ?
A MySQL database is just a useful way to store and order a lot of information. “Databases are most useful when it comes to storing information that fits into logical categories. For example, say that you wanted to store information of all the employees in a company. With a database you can group different parts of your business into separate tables to help store your information logically. Example tables might be: Employees, Supervisors, and Customers. Each table would then contain columns specific to these three areas.”
Read the rest of this entry »
MySQL is a Relational Database Management System. A relational database adds speed and flexibility, by storing data in separate tables rather than putting all the data in one area. These tables are linked by defined relations making it possible to combine data fromseveral tables upon request. Using a RDMS means it is possible to add, access, and process the data stored in your database. ‘SQL’ stands for “Structured Query Language” - the most common standardised language used to access databases. MySQL is Open Source software and is freely available at www.mysql.com. Open Source software means that the source code can easily be manipulated and modified by anyone. It is very simple to use.
Read the rest of this entry »
Moscow ML implements Standard ML (SML), as defined in the 1997 Definition of Standard ML, including the SML Modules language and some extensions. Moreover, Moscow ML supports most required parts of the SML Basis Library. It supports separate compilation and the generation of stand-alone executables. This document explains how to use the Moscow ML system. A companion document, the Moscow ML Language Overview, summarizes Moscow ML syntax and the most common built-in functions [9]. Another companion document, the Moscow ML Library Documentation, describes in detail all Moscow ML library modules [10]. Get a copy of the Moscow ML system executables (see Section 20 for instructions) and unpack them in your home directory (under Unix) or in directory C:\ (under MS Windows and DOS).
Read the rest of this entry »