Tuesday, February 2, 2010

How to Install Oracle Client 11g

These instructions apply to Microsoft Windows only. When you install Oracle database software (try installing Enterprise edition), by default it also installs Oracle client. So if you have installed Oracle database software in your machine and want to connect to your local database you simply invoke the Oracle Client and given the necessary login credentials and you are in. You do not have to worry much about setting up your sql*net configuration as the installation process should usually take care of that if you chose to do so.

But for people who want to access an Oracle database that is not local and in a remote machine then you must need to install Oracle client in your machine. Even if You do not want to use SQL*Plus but want to use TOAD or SQL Developer or something like that, you still need Oracle client. Because internally these database access/development tools use Oracle clients software to connect to the target database.

So the most important thing to remember is, you must need Oracle client software in your machine if you want to connect to a remote Oracle database.

Installing Oracle client is not difficult. You just need to be a bit careful. The step by step instructions below should help you to install an Oracle Client in your machine. These instructions assume that you have downloaded the Oracle client software that you desire to install and unzipped the zip file into some folder.

To make the instructions easy to understand I’ll explain what I did here:

1. Downlaoded Oracle Client Software from Oracle (zip file win32_11gR1_client.zip). This file is almost 500MB.

2. Unzipped win32_11gR1_client.zip into C:\win32_11gR1_client folder. A sub folder called “Client” is created under folder “c:\win32_11gR1_client”. Within the Client sub folder there is a file called setup.exe, this is the file I’ll run.

3. I want to install my Oracle Client in my D: disk drive.

System Requirement: Oracle client is not so much of a heavy software but still it needs significant amount of disk space. So make sure that you have at least 1GB free in your disk drive where you want to install your client.

1

Open Windows Explorer and navigate to c:\win32_11gR1_client\client

2

Run setup.exe (double click on it).

3

Wait until the following screen is displayed

Click Next on this screen

4

Select Administrator and then click Click Next button

5

Enter d:\oracle for Oracle Base

Click Next button

6

Click Next button again on this screen.

7

Click Install

8

The installation will now start as shown below.

Wait until the installation is 100% complete

9

The installation process will now try to configure Oracle Net Configuration.

Do not do anything. Wait until you get the following screen

10

Click Next

11

Click Finish

12

Click Exit

13

Click Yes

14

Done

DATA MINING –CONCEPT AND TECHNIQUES

DATA MINING –CONCEPT AND TECHNIQUES

INTRODUCTION
Data mining is the process of analyzing data from different perspectives and summarizing it into useful information - information that can be used to increase revenue, cut costs, or both. It allows users to analyze data from many different dimensions or angles, categorize it and summarize the relationships identified. It is the process of finding correlations or patterns among dozens of fields in large relational databases.

DATA, INFORMATION AND KNOWLEDGE

Data: Any facts, numbers, or text that can be processed by a computer is Data. Large amounts of data are being accumulated by the organizations in different formats and different databases. There are three types of data.

Operational or transactional data: This includes sales, cost, inventory, payroll, and accounting.

Non-operational data: Data from industry sales, forecast data, and macro economic data are considered non-operational.

Meta data: Data about the data itself. This includes logical database design or data dictionary definitions.

Information: Patterns, associations, or relationships among all the above type of data provide information of all the above types of data.

Knowledge: Information can be converted into knowledge about historical patterns and future trends. For example, a manufacturer or retailer could determine which items are most susceptible to promotional efforts.

FOUNDATIONS OF DATA MINING

Data mining techniques are the result of a long process of research and product development. This evolution began when business data was first stored on computers, continued with improvements in data access, and more recently, generated technologies that allow users to navigate through their data in real time. Data mining takes this evolutionary process beyond retrospective data access and navigation to prospective and proactive information delivery. Data mining is ready for application in the business community because it is supported by three technologies that are now sufficiently mature:

⃰ Massive data collection

⃰ Powerful multiprocessor computers

⃰ Data mining algorithms

ROLE OF DATA MINING

Companies with a strong consumer focus - retail, financial, communication and marketing organizations, primarily use data mining today. It enables these companies to analyze the relationships among "internal" factors such as price, product positioning, staff skills ,etc., and "external" factors such as economic indicators, technology, competition, and customer demographics in order to determine the impact on sales, customer satisfaction, and corporate profits.

Data mining helps the retailer to use point-of-sale records of customer purchases to send targeted promotions based on an individual's purchase history. By mining demographic data from comment or warranty cards, the retailer can develop products and promotions to appeal to specific customer segments. Data mining software analyzes relationships and patterns in stored transaction data based on the user queries. Software available for such analysis is: statistical, machine learning and neural networks. Four types of relationships are sought for this purpose. They are:

Classes: Stored data is used to locate data in predetermined groups. For example, a restaurant chain could mine customer purchase data to determine when customers visit and what they typically order. This in­formation can be used to increase traffic by having daily specials.

Clusters: Grouping of data items according to logical relationships or consumer preferences.

Associations: Data mining can be used to identify associations. Example-beer and diaper.

Sequential patterns: Data mining is used to determine behaviour pat­terns and trends. For example, an outdoor equipment retailer can pre­dict the likelihood of a backpack being purchased based on consumers’ purchase of sleeping bags and hiking shoes.

MAJOR ELEMENTS OF DATA MINING

· Extract, transform, and load transaction data

· Store and manage the data

· Provide data access

· Analyze the data by software.

· Present the data.

DATA MINING TECHNIQUES

The most commonly used techniques in data mining are:

Artificial neural networks: Non-linear predictive models that learn through training and resemble biological neural networks in structure.

Decision trees: Tree-shaped structures that represent sets of decisions. These decisions generate rules for the classification of a dataset. Specific decision tree methods include Classification and Regression Trees (CART) and Chi Square Automatic Interaction Detection (CHAID) .

Genetic algorithms: Optimization techniques that use process such as genetic combination, mutation, and natural selection in a design based on the concepts of evolution.

Nearest neighbor method: A technique that classifies each record in a dataset based on a combination of the classes of the k record(s) most similar to it in a historical dataset

Rule induction: The extraction of useful if-then rules from data based on statistical significance.

INFRASTRUCTURE REQUIRED

Today, data mining applications are available on all size systems for mainframe, client/server and PC platforms. System prices range from several thousand dollars for the smallest applications up to $1 million a terabyte for the largest. Enterprise-wide applications generally range in size from 10 gigabytes to over 11 terabytes. The factors that affect the system are:

Size of the database: the more data being processed and maintained, the more powerful the system required.

Query complexity: the more complex the queries and the greater the number of queries being processed, the more powerful the system required.

CONCLUSION

Most companies already collect and refine massive quantities of data. Data mining techniques can be implemented rapidly on existing software and hardware platforms to enhance the value of existing information resources, and can be integrated with new products and systems as they are brought on-line.

Use Of Windows 7 Compatibility Mode For Any Application Program

Now don’t be frustrated, if you have any application from older version which are finding difficult to run on Windows 7.

Windows 7 gives you option to run that program via Compatibility Mode .Many a time we often are caught under condition when our previous version of program don’t suit the new operating system. In that case we find our self very much helpless .To come over the problem use Windows 7 Compatibility Mode as follows .Open the program by making right click on the program’s shortcut, .exe file, or installation program .Open the properties Window .There are different tabs. Select “Compatibility.” Here search the option “Run this program in Compatibility Mode.” Check or uncheck the setting you required for running the program. If you want to rung the privilege level you can modify it.Now apply all these setting and click on "OK."

Implementing Windows 7 for Business Purpose

Most of the people are looking Windows 7as the operating system of this millennium. With the fabulous desktop, ability to upload the complete series of device driver for Vista and network security the new business generation is waiting with their breathe hold.

Hardware configuration: The high demanding configuration and poor driver support of Windows 7 are some of the hurdles in the feasibility. Hard drive of 20 GB and 1 GHZ processor as we know is the minimum. Obviously any business is related to the capital and so much demanding configuration will put some extra burden on their budget. Also the complexity of the operating system is causing slower boot of the system.

But limitations are everywhere. Let’s go into the positive aspects:

What we need in a Business, Simplicity in operating, privacy of our data and adaptability with different software. All these features are meeting the expectation of the user.

Touch-Screen: Now use your finger for working on computer give up the mouse. With Windows 7 and a touch – sensitive screen, you can browse online newspaper, flick through photo albums and shuffle files and folders. We are using the touch screen technology for years, but Windows 7extends it to every corner of your PC. The Start menu and taskbar now sport larger, fingertip-friendly icons. Familiar Windows 7 programs are also touch-ready. You can even finger paint in Paint! Windows Touch—available only in the Home Premium, Professional, and Ultimate editions of Windows 7.Need to zoom in on a picture? Pinch your fingers together. Want to right-click on something? Touch it with one finger and tap the screen with a second on the screen.

As per the windows 7 networks security, you can apply a separate firewall profile to different network connection. Which is dynamic in function?

There are some quite specific tools which can provide extraordinary security, mention below :


Bit Locker : It caps your data from hackers or theft .How can you help protect your data from loss, theft, or hackers? The answer: Bit Locker. Bit Locker keep a security lock on your documents, it keep everything in encrypted form on external drive. You are even safe if you have misplaced your portable storage devices like USB flash drives and external drives.

Direct Access : In the corporate world lots of energy is spend on building Virtual private networks, now Windows 7brings the Direct Access to save your time and energy. It commits secure connection to remote client without dealing with VPNs. This is an quite innovative gift to mobile user and sufficient reason for switching to Windows 7.


App Locker :
Now corporate has a good management over their software. It will inhibit any unauthorized access to any program. Ordinary users will not be able to install new programs however they can run it. It organization can keep a track on their user if they are involved in malpractice such as playing with settings designed for Internet Explorer. App Locker addresses this problem and lets IT centrally configure who can run which application. App Locker checks each program against corporate policies when a user tries to start it. Though it can be difficult to implement in a large organization, IT can get some immediate benefits by rolling App Locker out to highly managed workstations.

User Account Control: In Windows 7, you can turn on User Account Control (UAC) without it displaying warnings for programs you started. This means no more screen-dimming each time you start the Microsoft Management Console — but you’re still alerted if a Web page tries to change system settings or install unauthorized programs. If you disabled UAC in Vista, do yourself a favor and turn it on again once you’ve moved toWindows 7.


Compatibility Mode:
Most of us face problems in Transition period. Because the earlier programs find it difficult to be suited with the new operating system. In such situation don’t lose your temper and make use of "Compatibility Mode" to run that particular software. This is easy to apply.

Wednesday, January 6, 2010

Install a Driver for a Remote Printer on Your PC

Your Printer

is a peripheral which produces a hard copy of your documents that are stored in electronic form, usually on a physical print media such as paper. Do you know how to install a driver for a remote Printer on your PC? If you want to know it just take a little help from these given simple steps and you can install it all by yourself on your computer. You don’t need to drain your money for it. Just sit with it and invest some time from your busy schedule. So before stating you must remember that you must log on as an administrator when you update your Printer driver locally for a remote printer that is on a print server which is running on Microsoft Windows 2000 or Microsoft Windows XP.

Let’s start with Windows XP. You need to follow these steps to install your Printer driver locally on your Windows XP based computer. The steps are as follows:

  1. Firstly click Start, then click Control Panel. From there click Printers and Other Hardware, and then Printers and Faxes.
  2. Secondly, double-click on Add Printer option to start your Add Printer Wizard, and click Next.
  3. Thirdly click on to Local printer, clear, automatically detect and install check box, and click Next.
  4. Fourthly click Create a new port, and click Local Port in your Port type section.
  5. Fifthly in the Port Name box, type the path to the printer in this following format, where your server is the name of the print server and the printer is the name of your printer:

serverprinter

  1. Click Next and select your Windows 2000 or Windows XP driver for your printer.
  2. Click Next and follow the instructions to finish the wizard. You can even get more information about it from Internet.

If you have Windows 2000 based computer, you can follow these steps to install your Printer driver locally on a Windows 2000 computer:

  1. First click Start, point to Settings and Printers.
  2. Double-click on Add Printer to start your Add Printer Wizard.
  3. Click on My Computer and click Next.
  4. Click Add Port, then click Local Port, and click New Port.
  5. In your Port Name box, type your path to the printer in the following format, where your server is the name of your print server and the printer is the name of your printer:

serverprinter

  1. Lastly click OK, and click Close.

Your installation of driver for your remote Printer on your PC is complete. Now, you have to remember that while using this procedure, your print job is printed locally and then it is redirected to your network path. When you are using this procedure, you will not receive Printer updates from the print server when you are updating your Printer driver on the print server. You can get more information about this installation from Internet. Our Printer and Peripheral Support plays an important role in supporting your PC operations

Tuesday, January 5, 2010

Make My Computer Faster Now - Tips to Speed Up Your Computer Right Away With a Few Simple Steps

Buying high end computers is not the only solution to having a fast computer at home or in your office. Not only it is expensive or costly but they slow down too like every other computer does eventually, leaving you wondering how to make my computer run faster.

One of the most effective ways to make your computer faster is by means of maintenance. Maintaining a well organized computer along with the hardware and software will increase the speed of your computer and at the same time save you some large expenses.

How can you make your computer faster through maintenance?

There are things you should remember that will easily help you make your computer faster:

#1 The first step is to make sure that your computer is free of dust. This means to clean the fans and to make sure air is circulating round the case properly. If it is not the system will start to overheat. The first symptom of this is that it will slow down and eventually it will start reporting errors.

#2 The second step is to defragment your files at least once a week depending on the usage of your computer. This will organize all your files properly.

You can do this by clicking on my computer and then right click on your hard drive(s), click on properties, a sub-menu will pop up, then click on tools and finally click on defragment Now. This will allow you to re-arrange your files so that your computer will find all the files quickly and the first time you run this it may take at least an hour to do the job.

#3 The third step is to download a free registry scanner software that will find any errors in the windows registry.

A registry scanner will help you find programs or software that is slowing down your computer. Malicious software like spyware and trojans hide their entries in your registry and even if you have an antivirus software this will not find the registry entries that keep them running.

If your registry becomes too big and as more and more entries are added this will slow your computer and even if you remove programs the registry entries are left behind.

The other problem is that if you have encountered hardware errors caused by overheating or other problems in the past and even caused by a power failure these will cause registry errors and corruption that will not repair itself. A registry scanner will find all these problems in minutes even if they have been sitting on your computer for months, leaving you wondering what is is going on.

#4 The fourth step is to fix and or delete these problems with a registry cleaner and this again will take a few seconds.

#5 The fifth and final step to make sure your PC runs at maximum speed is to close applications that you are not using.

If you have applications like skype, yahoo messenger, windows messenger, or anything else that is is not in use you might as well close them.

This will also make your computer faster, especially if you have multiple windows opened and doing all this will stop you asking how to make my computer run faster now.

If you have a slow computer here is the #1 solution for how to Make My Computer Run Faster this is guaranteed to make your PC faster, just click here.

Article Source: http://EzineArticles.com/?expert=David_S_Marshall

How to Solve Windows Registry Errors and Speed Up Your Computer in Under an Hour

All windows operating systems depend on a registry which contains all the data for your computer, or laptop. If there are errors, corrupted files, or other major problems within the registry windows will eventually have problems operating properly.

Resolving any windows registry errors manually can be very hard unless you know what you are doing

A registry with problems cannot access what it needs immediately and spends time looking for the files, or even loses them altogether because it cannot find where they are or how to run them.

The implication of this is that windows itself will not find the files or programs either and this means that you will see constant errors and programs will fail to run, unless you fix these errors.

How Do you fix these errors quickly?

#1 Run a free registry scanner which you can download off the internet and find the problems.

#2 Remove all the errors with a registry cleaner.

A utility like this will rid your disk of bits of programs that have been left behind in the registry when you have uninstalled them. Even if you remove programs the correct way and with great care bits of data can still be left behind. The cleaner will locate these bits of data and remove them. leaving them there will slow down your PC and generate windows registry errors.

Things like Active X errors and DLL errors can cause no end of problems and the only way to fix these is with a registry cleaner. Things like adware, spyware, malware and even viruses can cause your registry to fill up with errors and malicious entries and these too can be safely removed.

When selecting a registry cleaner it is always advisable to use a good one, or it will do some damage. It needs to be easy to use and offer all the functions that you require. Your choice should also depend on your personal level of computer know how because some registry cleaners expect you to know quite a lot about the computers in order to use them.

There are others that are automated and all you need to do is to press a button and the errors and corruption will be fixed in seconds. There will be no more worry about malicious software or spyware hiding in your computer again.

Doing this will not only remove these errors but will speed up your PC too and make it run like new and error free for good and you will have no more windows registry errors.

If your computer is slow here is the answer by fixing Windows Registry errors this will make your PC faster, just click here.

Article Source: http://EzineArticles.com/?expert=James_Randell

Troubleshooting Video Card Issues With ATI Drivers Download By Logan Albright Platinum Quality Author Article Word Count:

If you have a graphic card installed in your computer, it is likely from ATI, as it is the most common brands of graphic cards out there, or perhaps the most well-known because of its reputation of being one of the best video card brands out there. In fact, if you were to speak to any computer enthusiast you might find that ATI is almost the standard bearer where graphic cards are concerned.

However, despite the praise often lauded by fans of ATI, the one undeniable truth is that ATI is just like any piece of technology out there, and they cannot escape the fact that they too are prone to the occasional faults and errors. This article will show you just how you can troubleshoot video card issues with ATI drivers download.

The truth of the matter is, even their latest Radeon line of video cards is not susceptible to problems. In fact, most users have noted that the problem with that particular line of video cards is mostly compatibility issues.

The symptoms of these issues range from artifacts on screen, to even sudden freezing of the entire system. If you're lucky enough you might find the occasional error message or two. I say lucky, because if you receive an error message then your chances of resolving the issue would be significantly better, because you'd have something to work with.

But if your system freezes up out of the blue or your screen displays abnormally, then you're left scratching your head as you try to figure out what the heck is going on with your computer. It is, without a shadow of a doubt, a frustrating experience to bear, but fret not. The likelihood of the graphic card itself being the problem is statistically quite rare, because ATI is reputed for its advanced chipset manufacturing capability. Most video card issues can be attributed to a faulty driver.

What exactly is a driver? Well, it is the one element that enables the translation of bits of code and data from your computer into a graphical output on your screen. A driver can be considered a common language that bridges the gap between graphic card and the operating system, so that both can have a better understanding of one another and what is expected from them.

Once a driver is compromised, then so too will the output that you'll receive on screen. For the every day user, you need not bother to have an in-depth understanding of the various causes that can compromise a driver, but one of these causes happens to be outdated and incompatible drivers.

One aspect that ATI lacks in comparison to its advanced manufacturing capability is driver development. So one can expect a gap of sorts between the hardware and the driver written for it, and this gap is the primary cause that limits the video card's performance.

Like most reputed companies, ATI have seen fit to provide its customers with regular software updates for its line of graphic cards, and all you would have to do when you encounter video card issues is to go online and find, on their website, the necessary updates for the specific model of your video card.

A quick hassle-free method that you can also consider is to download a driver scan software, which will help you automate the entire process, and keep your computer constantly updated with the latest drivers.

Click Here to download Driver Scan for free and instantly get the Lastest ATI Drivers Download. Logan Albright is an authority on troubleshooting drivers issues at Driverscan.org and has helped many to optimize their computers for peak performance.

Article Source: http://EzineArticles.com/?expert=Logan_Albright

Slow Network - Tips to Fix Slow Network Problems

Have you ever annoyed that the network speed is quite slower than before? For example, it takes more and more time to open a website while there is nothing wrong with the Explorer. Well, in this article, you can learn some useful tips to fix slow network problems.

In the very first place, it is the problem of network itself. The bandwidth of aim website server is not large or overloaded. This is the easiest problem and what you need to do is to change to other websites or change other to visit it.

Secondly, you may have used too many firewalls. If you use too many firewalls, it can slow down network for sure. The simplest way is to uninstall those unnecessary ones and just need to keep a powerful one, it is sufficient to serve very well for computer. You can remove such excessive firewall so as to improve net work speed.

And then, the system resource is too low. It is probably that there are excessive applications running in the background and computer is unable to spare enough resource for network. In order to solve this problem, you should load programs and delete useless applications and files properly so as to free up more space. By doing this, you can speed up network.

Next, computer worms may reduce network speed. Worm virus that is spread through E-mail has affected network more and more seriously. Such virus can force the affected users to send E-mails restlessly. Numerous junk E-mails are sent from your computer every second while millions of them are returned to your server in batches.

In this way, such rubbish is piling up in the server and slows down speed. As a result, you should upgrade anti-virus software and your computer and install patching program in time as well. And do not forget to uninstall those unnecessary services and to close down needless ports so as to improve safety and stability of system.

Besides, slow network problem may be caused by problems in internet cable, loops in the network, malfunction of network equipment and so forth. But they are quite professional for you. If you want to keep high network speed, you should form a good habit of using computer, such as clear up disk regularly.

Article Source: http://EzineArticles.com/?expert=Arial_Green

An Introduction to the World of USB Wireless Cards

The internet seems to be practically everywhere these days. In your phone, in your gaming console, offered as a standard feature in hotel rooms. It's all over the place, and more convenient than ever before, and seemingly getting even more impossibly convenient with every passing year. The latest innovation in this area comes in the form of USB wireless cards. If you've been stuck with a more old-fashioned wireless card taking up space in your computer, then you might want to consider upgrading. The conveniences of a USB card for wireless internet access are many, and all it costs you is a USB port, which are in increasingly more ready supply these days.

USB wireless cards are, in terms of housing and basic function, the same as any other USB device. They're small devices about the size of your thumb that can be simply plugged in to a USB port to function on an appropriate computer. Older computers have the USB plug ports on the back, while newer ones put them in the front for ease of use. When they're not in use, you can keep them in a pocket or small case and carry them around with no real trouble, since they're so small and lightweight. Originally developed as portable hard drives for storing information, they're now advanced enough to contain the software necessary for operating various programs, including the ability to hook your computer up to the internet. Therefore we now have internet in a USB drive, rather than just raw information or files, which blurs the domains between computers and their peripherals substantially.

These internet-connecting devices have many advantages over their forebears. Since they're not permanently installed inside a particular computer, they leave more room in computers for hard drives, graphics and sound cards, and other additions that take up permanent space inside the casing. Also because of this, they can be plugged in to any compatible computer and used whenever and wherever you like, allowing you to separate your internet access from the particular individual computer you're using at any given moment in time. As a part of the modern, mobile technological world, USB wireless cards let you connect to the internet on your own terms rather than being bound to particular computers. And as a part of this mobility focus, these devices will usually search for any available wireless access point in a given area once plugged in, hooking you up with a minimum of trouble.

For all that power and flexibility, though, you can get these peripheral devices at very low prices since advances in technology have made them cheap to produce. It's not unusual to find them below thirty dollars. So don't worry over whether you can afford to take the next step into the internet's new stage of evolution - you probably can.

Please visit USB wireless card or portable printers for laptops for more information.

Article Source: http://EzineArticles.com/?expert=Jennifer_Waller