Database Analysis

Database Analysis subject Travis Russell CIS/205 Management Information Systems June 14, 2010 Michael Suder   Database Analysis Paper In this newsprint we go out contend the database applications that argon go for at my legitimate job. Such examples argon Microsoft Access, DB2, and Oracle. We will discuss how they ar used and in conclusion I will propose improvements. shortly two databases are used at Canvas Systems. They are Microsoft SQL server and IBM Lotus Domino. Let us talk a little about Microsoft SQL host it is a relational lay database server produced by Microsoft. According to (2010), It is elementary query languages are T-SQL and ANSI SQL. The following applications use Microsoft SQL innkeeper. Canvas currently has octet SQL servers in production (running SQL 2000 and 2005), and several supporting growing environments. here are the developmental environments: Microsoft Dynamics Nav (our ERP- business critical), Microsoft CRM 4.0 (our sales force automation tool- business critical), SharePoint, BI Reports, and Several customer-facing applications (business critical) Here is some score about Microsoft SQL Server. The code base for MS SQL Server (prior to magnetic declination 7.

0) originated in Sybase SQL Server, and was Microsofts entry to the enterprise-level database market, competing against Oracle, IBM, and, later, Sybase, Microsoft, Sybase and Ashton-Tate in the first place teamed up to create and market the rootage version named SQL Server 1.0 for OS/2 (about 1989) which was essentially the same as Sybase SQL Server 3.0 on U nix, VMS, etc. Microsoft SQL Server 4.2 was ! shipped around 1992 (available bundled with Microsoft OS/2 version 1.3). Later Microsoft SQL Server 4.21 for Windows NT was released at the same quantify as Windows NT 3.1. Microsoft SQL Server v6.0 was the first version designed for NT, and did not include any wariness from Sybase. According to (2010), in the eight years since release of Microsofts prior SQL Server product (SQL Server...If you necessity to get a dear essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper