General IT

This tab contains information about all things relating to computers and IT that is not covered elsewhere on this site.

This includes Oracle, Microsoft Windows, Solaris, MySQL, Networking, Storage etc.

Oracle Database Architecture

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components. There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.

The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.

Microsoft Windows

Microsoft Windows is a series of operating systems and environments developed and marketed by Microsoft Corporation. The first version of Windows was released in 1985 as a graphical user interface to MS-DOS, providing multiple document support, mouse support, drop down menus, and color video drivers. Later versions gradually replaced many of MS-DOS's built-in hardware functions with their own enhanced functions, until Windows fully assimilated MS-DOS and became a full-fledged operating system. Microsoft Windows is now often referred to as an integrated operating system due to the high level of integration between the core kernel functions and other Microsoft software such as Outlook, Windows Explorer and Internet Explorer. Despite it's poor security record caused by this integration, Microsoft Windows is today the most widely used OS on personal home computers, laptop computers, and small business machines. The latest version, Windows Vista, was released in late 2006 to large businesses while the consumer version was delayed until early 2007.

As an integrated operating system, all Microsoft Windows versions come with preinstalled software that is ready to use upon installation. Basic text editors and calculators have been available since the first versions of Windows. Windows 98 added Media Player, Internet Explorer and Outlook Express. Windows Vista expands this with the Windows Mobility Center, Photo Gallery, DVD Maker, and the Linux-like Windows Sidebar. Vista is also the first version of Windows to have built-in security features. Although the second Windows XP service pack added a firewall and anti-virus monitoring service, Vista implements these features and more at the kernel level. Individual programs are 'sandboxed' and cannot access each other's memory. Critical drivers are executed in user mode, so crashes and malicious behavior cannot cause system-wide instability or security breaches. Even third-party anti-virus and anti-spyware software runs outside the kernel, further protecting it from bugs and backdoors in those programs.

In addition to the common desktop consumer versions of Microsoft Windows, Microsoft has released server, mobile, and embedded versions of the operating system. Windows Server System is a compete IT administration package that includes the Windows Server operating system, Updates Services, Storage Server, IIS webserver, Windows Media Services, and more. This package is intended for large organizations that must administer local area networks and integrate different types of computers for different purposes. Windows Mobile is a series of operating systems designed for PDA devices and smartphones. This is the only version of Windows to include any version of Microsoft Office bundled with the OS. Microsoft Windows Embedded is a relatively lightweight version of Windows custom tailored to the hardware on which it runs. While closely related to Windows Mobile, Windows Embedded is not targeted at consumer end-user devices. Rather, Windows Embedded is intended for use in portable medical equipment, industrial machinery, third-party automobile controllers, and similar job-specific applications.

Oracle Solaris

Solaris is a Unix operating system originally developed by Sun Microsystems. It superseded their earlier SunOS in 1992. Oracle Solaris, as it is now known, has been owned by Oracle Corporation since Oracle's acquisition of Sun in January 2010.

Solaris is known for its scalability, especially on SPARC systems, and for originating many innovative features such as DTrace, ZFS and Time Slider. Solaris supports SPARC-based and x86-based workstations and servers from Sun and other vendors, with efforts underway to port to additional platforms. Solaris is registered as compliant with the Single Unix Specification.

Solaris was historically developed as proprietary software, then in June 2005 Sun Microsystems released most of the codebase under the CDDL license, and founded the OpenSolaris open source project. With OpenSolaris Sun wanted to build a developer and user community around the software. After the acquisition of Sun Microsystems in January 2010, Oracle decided to discontinue the OpenSolaris distribution and the development model. As a result, the OpenSolaris community forked the OpenIndiana project, as part of the Illumos Foundation. However, starting with Solaris 11, updates to the Solaris source code will still be distributed under the CDDL license, after full binary releases are made. Oracle will also begin a technology partner program, called Oracle Technology Network (OTN), to permit their industry partners access to the in-development Solaris source code.