Thursday, March 25, 2010

Technology Post

STORAGE OF INFORMATION
A very important file that is used throughout every computer in management at Forsgate is the “shared file”. The shared file is a basic intranet in which only management personnel can access the software that are stored within this file, mainly software used for financial and inventory purposes. An executive file is also used, which has a collection of confidential information on every one of our members, information on employees, and payroll information for the accounting department. These files are found in Forsgate's databases which hold a specific collection of files for golf, membership, upcoming banquet events, food and beverage, etc. so that each department has their own database so the duplication of files within other departments does not occur. Database warehouses are used for a collection of many databases. The warehouses Forsgate uses hold archives for banquet bills, daily food and wine items within the restaurants and on the golf courses, comparing purchasing orders from previous months, and so on. The two database software that Forsgate uses to keep track of all their databases and files are ClubTech and Delphi, which is a lead router and database diary that holds all of Forsgate’s archives. Every director from each department (accounting, membership, catering, food and beverage, golf, etc.) is responsible for their own department database. These department head managers decipher the information themselves to generate their own reports, depending on the specific function of the report, so they can keep an update on their databases. For example, some types of reports are ones specific for labor to track productivity, attrition reports on members to update any new members that may be coming in or members that may have dropped their membership, and product mix reports. The managers at Forsgate use OLAP to search through all of the different databases for any specific information on members accounts for billing purposes, upcoming events and who they’re billed to, etc.

Data marts are used on each computer at Forsgate. Specific shared drives on each of the computers in departments are intranets that anyone in those departments can have access to. On an operational level, every department head is a “piece to the puzzle” that have their own tools and intelligent agents for analytical analysis to keep Forsgate together as a team and have everything running on the same page. On an organizational level, the general manager and CEO of Forsgate, Christopher Schiavone, look at the sales from daily sales reports as their query and reporting to determine forecasted sales for the future months and years to come. Department heads like the Food and Beverage Director, Director of Memberships, Director of Catering, Golf and Grounds Director, Events Coordinators, Purchasing Director, etc are responsible for their own data mining on an operational level. The general manager of Forsgate, Det Williams, and CEO Chris Schiavone are responsible for data mining on an organizational level to compare daily sales with the other country clubs that Chris Schiavone and Det Williams run as well. However, not many specific softwares are used for data mining besides Microsoft Access and Microsoft Excel in each department, but one specific software that Food and Beverage Director of Forsgate, Kevin Fitzpatrick, uses is SoftCafe MenuPro which is for the purpose of monthly food and beverage reports.


HARDWARE
Forsgate uses all 6 categories of hardware. Input devices are used such as keyboards on every computer in the building and scanners for a few of the upper management computers. Cameras are also used as input devices so that pictures and videos can be uploaded to update FCC's website and ForsgateTV. Output devices that recognize the results of any information-processing requests throughout building, like a few main printers that are located throughout the building and fax machines are located at the front desk and in the copy machine room. Managers use their own storage devices (flashdrives, CDs, personal DVDs) to store their own information for use at a later date. All computers throughout the building have a central processing unit (CPU) and random access memory (RAM) so that a sufficient amount of memory on each computer is available. Telecommunication is used from office to office such as telephones, fax machines, networks, so that crucial information can be sent from one department to the next. USB ports are used to connect computers to their personal printers or personal fax machines and firewire are used for connecting the computers. The brands of computers that Forsgate uses are Dell and Micros computers throughout the building. All of the Dell computers are PC desktop computers and then there are the Micros terminals (which could be categorized as a minicomputer because of the constant information about food and liquor costs and also the processing power that these terminals have) are used for POS purposes (point of sale). Forsgate's IT manager, Pablo Conteras is responsible for all hardware and software throughout the country club.


SOFTWARE
The types of system software that the computers at Forsgate use is Application Software such as those applications in Windows XP Office. Forsgate also uses Micros 8700 which is considered a "stone age" software, but it's the best that works with all of the Micros systems throughout the club that helps with inventory purposes. Forsgate also has Operating System Software such as Microsoft Windows and Linux. Utility Software are also used throughout the building's computers because they all have anti-virus software, spam blocking software, and installing and uninstalling software. Linux is used for our Micros computers because it helps provide a successful operating environment for the network servers that Micros uses for their high-end workstations.
Some types of application software that are used are spreadsheet applications, database management applications such as Microsoft Access and SoftCafe MenuPro, communication applications such as Outlook, desktop publishing, graphics applications such as Photoshop, and presentation applications such as Powerpoint are all used within the departments computers. The brands of all of these applications are Microsoft's Office Package (Excel, Access, Word, etc), Microsoft Outlook, SoftCafe Menu Pro, Adobe (photoshop, flash).


NETOWRKING
Forsgate uses LAN (local area network) so that the near-by buildings within the property near the clubhouse can still connect to each other and use the same network, and so that buildings that are not near Forsgate cannot use our network for their own uses. Forsgate uses Windows NT Network as their network interface to connect each computer to the network. They also have Wi-Fi set up throughout the building and a wireless access point (WAP) such as Linksys for the computers with broadband routers so that a slew of extra cables are not lying around the office just to be connected to the network. As far as communication software is concerned, Forsgate uses Windows Office XP so that applications such as Microsoft Outlook can be used to communicate from one department to the next department, even if the other department is in a different building located on the premises. To connect these computers to each other routers are used throughout the building so that information and network traffic are passed to smaller subnetworks of the main network. For example any information from a computer in the main clubhouse can be sent to a computer that may be located in the Golf Shop building or the Accounting and Human Resources building.

Digital Subscriber Line (DSL) is used at Forsgate so that the telephone extensions to that particular department can be used while being connected to the network on that departments computer. Although the speed isn't as fast as most managers would like it to be at Forsgate, 2Mbps is the general speed that Forsgate's DSL has. They do not currently use Voice over IP, but it has been something that has been considered for the past year because it would be a lot easier to move a manager into a different office without having to reprogram the phone system every time that happens. Instead they can be easily moved and send voice communications without the extra charge.


PRINCIPLES OF NETWORKING
In terms of confidentiality, specific information such as employee evaluations, credit card reports, business plans, etc. can only be accessed by the General Manager of Forsgate, the Food and Beverage Director, the Human Resource Manager, and any RDC managers that may be on the premises. Specific passwords are used so that no unauthorized individuals can access that information. As far as authenticity is considered, the IT manager Pablo Conteras monitors any foreign emails or website spams that may be trying to come into the network to be sent as an email to the specific computer that department manager is using. The managers have a large amount of trust and integrity to the staff that may be using the computers on downtime or the receptionists, since they are the only personnel to use a computer other than a manager. It is not easy to sit and watch what websites they may be using but the level of trust is there so they do not download any faulty software that may corrupt the network for the other computers. For availability, Pablo Conteras tries to keep blockages on the computers to a minimum so that no outside business is lost.

Forsgate Country Club's domain name is Forsgatecc.com.