System Definition

Section II

System Definition and Procurement of Technology

Candidate Matrix

 

Characteristics

Novell

Microsoft

Portion Of System Computerized

 

Will be subcontracted and customized to satisfy user functions requirements or purchased as a packaged solution.

Same as Novell but Web Assistant. A wizard and formatting option in the release of SQL Server 7.0, is used to customize and enhance the SQL Server Web Assistant, so you can easily generate HTML files from SQL Server data.

Benefits

This Solution: NetWare is developed to meet the emerging e-business needs, NetWare integrates Internet and application server technologies that will extend your business to the Web while leveraging your existing network investments. Using these technologies, you can develop, deploy, and manage Web applications, administer and monitor your server remotely from any Web browser, and strengthen your e-business relationships. You can also use NetWare to quickly download or upload files from remote locations, host multiple Web sites on a single server, and easily search large collections of online information.

http://www.novell.com/catalog/solutions/solution_14101a.html

Scalable Business Solutions SQL Server scales from laptop databases and small business servers all the way up to terabyte-size databases. It integrates well with existing applications, and it provides a cost-effective environment for customizing and building new applications that meet unique requirements.

Scalability

SQL Server 7.0 is designed to accommodate more data, transactions, and users with ease.

http://www.microsoft.com/sql/productinfo/features.htm

Servers and Workstations

NetWare® Cluster Services for NetWare 5 v1.01 is a server clustering system you can use to ensure high availability and manageability of critical network resources, including data (volumes), applications, server licenses, and services. It is a multi-node, Novell Directory Services® (NDS™)-enabled clustering product for NetWare 5 that supports failover, failback, and migration (load balancing) of individually managed cluster resources.

http://webapps.novell.com/catalog/qr/sne20001.html

Workstations should be the equivalent to a 486/33 processor or higher with a minimum of 32mb of RAM pending on Operating System

System design designates Compaq servers and Pentium Pro Windows 2000 workstations

SQL Server 7.0 makes giant strides in performance, reliability, and scalability, giving your organization many opportunities to create intelligent, real-world business solutions:

These innovations, plus many more changes, make SQL Server 7.0 highly scalable and excellent for data warehousing. In addition, organizations that also run Office 2000 can take advantages of new ways that Office and SQL Server work together.

Microsoft Office 2000

SQL Server 7.0 adds Microsoft Office 2000 to its already strong line of integrated products, such as Windows NT Server, BackOffice, and Microsoft Office 97. Making Office 2000 the front-end for your enterprise-level database is a smart choice. You can give customers and employees more ways to access data from any location, using the desktop applications they already know. They can also share reports and easily view and analyze data over the Internet using Office Web Components. Web Components are new in Office 2000, and they offer online, dynamic views of data through spreadsheet, chart, and PivotTable® features.

http://www.microsoft.com/sql/productinfo/features.htm

 

Characteristics

Novell

Microsoft

Software Tools Needed

BorderManager™ Enterprise Edition is a suite of network services you can use to connect your network securely to the Internet or any other network. It improves network performance and security at borders between networks

http://www.novell.com/catalog/qr/sne30005.html

Host Integration Solution is a combination of industry-leading products you can use to safely migrate your host-based enterprise network to an intranet or the Internet. Without costly network upgrades and application rewrites, you can provide secure Web-based access to your corporate data for your clients, business partners, and employees. Integration with Novell Directory Services® (NDS™) and Web server-based application deployment provides a centralized management solution that reduces costs and simplifies access. With NDS authentication, IP filtering, and Secure Sockets Layer encryption you can protect your corporate data and host network from unauthorized access.

http://www.novell.com/catalog/qr/sne34303.html

DeveloperNet Subscription The DeveloperNet Subscription provides you with all the resources and services you need to develop advanced applications that are compatible with Novell products. The DeveloperNet Subscription includes access to products, support, training, co-marketing opportunities, technical and marketing information, and powerful components and interfaces. You can purchase DeveloperNet at five subscription levels: Electronic, Professional, Enterprise, Partner, and Strategic.

http://www.novell.com/catalog/solutions/solution_74410a.html

Internet, Intranet, and Commerce

Cutting-edge features and seamless integration with Microsoft Windows NT® and Microsoft BackOffice® make SQL Server 7.0 a vital factor in your Internet, intranet, and electronic commerce strategy.

  • Full-text search. With SQL Server 7.0, you no longer need expensive add-ons to handle full-text database searches. This new release supports linguistic search, allowing you to create special indexes of pertinent words and phrases in selected columns of selected tables.
  • Web Assistant. A wizard and formatting option in this release enhances the SQL Server Web Assistant, so you can easily generate HTML files from SQL Server data.
  • Internet replication. Replication across the Internet is easier than ever with anonymous subscriptions and built-in support for Internet distribution. SQL Server 7.0 now supports programs using Active Server Pages (ASP).

http://www.microsoft.com/sql/productinfo/features.htm

 

 

 

 

System Definition

Section II

System Definition and Procurement of Technology

Candidate Matrix

Characteristics

Novell

Microsoft

Application Software

SQL Integrator is a data request broker that effectively presents all the relational database information in your organization as a single database. SQL Integrator provides a multiple-tier, multiple-database enterprise environment. With SQL Integrator you can create Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC) applications to access your SQL-based client systems and database servers. By presenting a single logical view of all data, SQL Integrator provides developers and administrators with the ability to access, integrate, and manipulate data regardless of source, location, or type. SQL Integrator eliminates the differences in access language and data types between your varied database engines.

http://www.novell.com/catalog/qr/sne64850.html

SQL Server Desktop. With SQL Server 7.0 for Microsoft Windows® 95, Microsoft Windows 98, and Microsoft Windows NT Workstation, you can count on a fully featured relational database management system (RDBMS) that performs well across workstation and mobile applications. A single code base for all platforms—from a laptop running Windows 95 to clustered systems running Windows NT Server, Enterprise Edition—provides 100-percent application compatibility.

Desktop, Mobile, and Distributed Systems

Microsoft designed SQL Server 7.0 so organizations can give employees and customers the ability to work with data reliably from the office, over the Internet, or on the road.

  • SQL Server Desktop. With SQL Server 7.0 for Microsoft Windows® 95, Microsoft Windows 98, and Microsoft Windows NT Workstation, you can count on a fully featured relational database management system (RDBMS) that performs well across workstation and mobile applications. A single code base for all platforms—from a laptop running Windows 95 to clustered systems running Windows NT Server, Enterprise Edition—provides 100-percent application compatibility.

Method of Data Processing

Client/Server, Workstation/Server, Dialup/Server

Output Devices and Implications

Input Devices and Implicaitons

Keyboard and mouse

Keyboard and mouse

 

 

Characteristics

Novell

Microsoft

Storage Devices and Implications

NetWare Cluster Services requires at least two servers running either NetWare 5 and Support Pack 4 or later, or NetWare 5.1. It also requires that all servers in the cluster be configured with the IP protocol and on the same IP subnet. Each server must have at least 64MB of RAM (128 recommended) and all servers must be in the same NDS tree. In addition, each server must have at least one local disk device (not shared) to be used as volume SYS, and the NDS tree must be replicated on at least two servers in the cluster. On the management workstation Novell Client version 4.50.819 for Windows NT or version 3.0.0.0 for Windows 95 must be installed. The management workstation should also have at least a 300MHz processor and 90 MB of memory.

http://webapps.novell.com/catalog/qr/sne20001.html

Oracle SQL Web Server DBMS with xxx arrayed capacity

     

 

 

Characteristics

Oracle

IBM

Portion Of System Computerized

Benefits

Oracle8i Release 2 is the latest release of the Oracle8i database. In addition to a number of advanced new features, Oracle8i Release 2 includes many bug fixes, performance improvements, and user interface enhancements. The enhancements and new features in Oracle8i Release 2, formerly known as Oracle8i Release 8.1.6, can be categorized as:

  • Data Warehouse Enhancements
  • Enhanced Support for Internet Computing and Java
  • High Availability Enhancements
  • Performance and Quality Improvements
  • Additional Functionality

http://www.oracle.com/database/oracle8i/

 

Servers and Workstations

MAXIMIZING SYSTEM RESOURCES

Oracle’s Multithreaded Server (MTS) can increase the number of simultaneous users accessing a single server. Net8 contains two new features to help sites realize even higher utilization of server resources: connection pooling and the concentrator functionality of the Oracle Connection Manager. When thousands of clients are running interactive applications, many of these sessions may be idle at a given time. Connection pooling enables the server to time-out idle sessions and use that connection to service an active session. The idle logical session remains open and the physical connection is automatically re-established when the next request comes from that session. Connection pooling allows more sessions to the server over a set number of available physical connections. In addition, connection pooling removes the burden of maintaining unused connections, which improves the performance of active sessions. By placing a "hard limit" on the number of physical connections a server must manage, and by using those connections more efficiently, larger numbers of concurrent users can be accommodated with existing hardware for many classes of interactive applications.

http://www.oracle.com/o8i/owa/O8i.Search?string=Networking

 

Characteristics

Oracle

Microsoft

Software Tools Needed

TRANSPARENT NETWORKING

Net8 provides the industry’s broadest support for network transport protocols including TCP/IP, Novell SPX/IPX, IBM LU6.2, and DECnet. All data conversion using Net8 is invisible to the user and the application. This enables Oracle8 to inter-operate across different types of computers, operating systems, and networks to transparently connect any combination of PC, UNIX, legacy, and other systems without expensive changes to the existing infrastructure.

DATA REPRESENTATION AND CHAR-SET INDEPENDENCE

Net8 automatically converts between both national-language character sets, such as those used in European and Asian languages, and different computer-architecture character sets such as ASCII and EBCDIC. Net8 allows machines with different word sizes, bit and byte orderings, and native number formats to transparently inter-operate and share data. Additionally, Net8’s extensive national-language character set allows Oracle applications to be deployed in global environments.

ACCESS ANYWHERE

To enable users to run a client-server application from within a web browser, Net8 offers data access for Java Database Connectivity (JDBC)-based applications that implement a Net8 Java client. Net8 Java client is a small footprint implementation of Net8 that is suitable either for downloading from any web server or for installing on the client machine as a pure Java application.

CONNECTIVITY FOR JAVA APPLETS

Java applets downloaded from a web server normally only establish connectivity to the machine from which they came. By routing connections through Oracle Connection Manager, JDBC-based applications can take advantage of unrestricted and transparent Net8 connectivity to any Oracle8i database in the Internet.

http://www.oracle.com/o8i/owa/O8i.Search?string=Networking

 

 

 

 

Characteristics

Oracle

 

Application Software

   

Method of Data Processing

Output Devices and Implications

Input Devices and Implicaitons

 

 

Characteristics

Oracle

Microsoft

Storage Devices and Implications

     

 

 

 

1