Microsoft Access 2010

Microsoft Access 2010 is one of the several versions of Microsoft Access that was released in the market with the goal of providing its users with a DBMS that can combine the Microsoft Jet Database Engine with tools being used for software development together with a GUI. It allows its users to use VBA in writing together with user control and manipulation of data. It has a feature which allows the exporting and importing of various formats including dBase, Paradox, Oracle, FoxPro, Outlook, ASCII, and Excel among the other formats available. It has the capacity to link to the data being used in its current location which can be used for different purposes such as editing, reporting, viewing and querying. It uses the format Jet Database which has the ability of containing the data and the application in just a single file.

• 訪問開發者網站

SQLite

SQLite is a database management software with the necessary tools to create and manage SQLite databases. It opens and works with memory databases like te sqlite 2.x, sqlite 3.x and REALSQL Server databases. It creates browse tables, views, triggers and indexes and enables records to be inserted, deleted and updated and it supports arbitrary SQL commands. It features a detailed analyzer, foreign key support, a built-in virtual machine analyzer, built-in optimizer and a built-in language reference. It can display JPEG, BMP and TIFF file formats, as well as QuickTime from BLOB records, and it has the ability to open hidden files or hidden bundles under Mac OS X. It saves frequently used SQL and converts SQLite 2 databases to SQLite 3. It has advanced import and export capabilities and it can generate reports using report templates. It has a spreadsheet-like interface and offers quick access to basic functions. The interface contains all of its main features and complicated command line commands are stored inside a simple button. The same interface is used on MacOS X and Windows version with a multiplatform license for multiplatform databases.

• 訪問開發者網站

Microsoft SQL Server (2008)

SQL Server 2008, formerly codenamed Katmai, was released on August 6, 2008 and goals to make data self organizing, management self-tuning, and self maintaining with the improvement of SQL Server Always On technologies, to give almost-zero downtime. SQL Server 2008 also includes support for structured and semi-structured data, as well as digital media formats for pictures, audio, video and other multimedia data. In present versions, such multimedia data can be saved as BLOBs (binary large objects), but they are generic bit streams. It also natively supports hierarchical data, and includes T-SQL constructs to directly deal with them, without using recursive queries. Basic awareness of multimedia data will permit specialized functions to be performed on them. According to Paul Flessner, senior Vice President, Server Applications, Microsoft Corp., SQL Server 2008 can be a data storage backend for different varieties of data: XML, email, time/calendar, file, document, spatial, etc as well as perform search, query, analysis, sharing, and synchronization across all data types.

• 訪問開發者網站