Welcome to www.astralcomputing.net

Web Hosting - Databases, What Are They and Do You Need One? 'Database' is one of the most commonly used terms that one encounters in web site design. Yet, what they really are and whether they're essential is often not clear to novices. A database is a collection of organized data, stored in files that have a specific structure. It's that organization and structure that allows for easy and rapid storage and retrieval. The need for a database generally only arises when you have a certain amount of information and that information needs to have some structure. If you have a half-dozen names and addresses to store, a database is usually overkill. If you have a blob of data with no relationships between any of the items in that blob, maintaining a database is usually more trouble than it's worth. Maintain a database? Yes, like other complex systems a database, to be effective, needs to be designed properly at the outset then kept 'tuned' for good performance. The alternative is to gradually allow the database to become more and more disorganized. That leads to difficulty in use, poor speed of retrieval and more frequent failures. With MySQL, Access or MS SQL Server, the three most common choices of database product for web sites today, setting up a database is relatively simple. Even those with limited technical skill can get one up and running just by following some simple instructions. But some thought should be given to how you want the information organized, and to maintaining the system during its lifetime. Suppose you have a set of names, addresses, email addresses, products purchased, date purchased and amount. If you have only a few dozen records it matters very little how these pieces are arranged and related. A database usually isn't even warranted in this scenario. Once you have several thousand or more records, it matters a lot. Speed, the ease of expanding the set of attributes (like adding, say, product category), and other issues come into play. Even those with little technical expertise, but a willingness to exert logical thought and invest some time, can build a very robust database. Think about how you would organize a set of data (called 'tables'). Should Name, Address, and Product be in the same table? Or should the personal information be stored in one table and any product information (product, price, ...) in another? Some experimentation may be needed to get it right, but the choices have an impact on how easy the tables are to maintain. It also affects the speed with which programs can fetch old data and store the new. Having a database also introduces new maintenance issues for the server administrator, since backups usually need to be done differently. Recovering a failed database is usually more complicated than simply re-copying files from yesterday. Ask your hosting company what tools and skills they have for dealing with any database system you consider. It's true that introducing a database creates more complexity and the need for additional thought and administrative effort. At a certain level, professional expertise will be needed. But clearly the advantages outweigh the costs in many cases. Companies large and small eventually use databases to store and organize data. At some point, you may be fortunate enough to be one of them.

Get Noticed at your Job by Doing it with Flair Doing your job with “37 pieces of flair” may have entered the pop culture vernacular through the famous movie about life working an office, Office Space, but there may just be something to it. You might not need 37 pieces of flair, but doing your job with a little bit of flair and a lot of hard work is a great way to get noticed in the office and to move on to bigger and better things. How do you go about doing your job with flair? The first way to make sure you are doing your job with distinction doesn’t involve much flair at all – it simply involves doing your job and doing it well. Know exactly what your responsibilities are and attend to them every day. Don’t let any of the things that come under your job description fall by the wayside because you think they are unimportant. If you are unsure exactly what all of your responsibilities are, ask your boss for a meeting and discuss your job description with them. You will get noticed simply for your desire to make sure you are covering all of your bases and not letting any of your responsibilities fall by the wayside. Another way to do your job with flair is to add to the good morale in the office. Everyone has at least one person in the office that is like a black cloud hanging in the air. Gloom, doom and pessimism don’t really have a place in the office. Even if you feel like you are heading for a fall with the way a certain project is coming together or because someone on the team is not pulling their weight, look for solutions instead of standing around and complaining about it. When your attitude can help people stay on track with their work and not dread coming into the office every day, you are bound to get noticed. If you really want to add some flair to your work performance, learn how to manage your time and avoid procrastination. Time management is one of the biggest problems all employees face, and when you don’t manage your time efficiently, you are not being as productive as possible for your boss, which never wins you any fans among the management team. If you find yourself always rushing through your work at the last minute trying to meet your deadline, try keeping a journal of all of your activities at work for a few days. When you see how much time you spending doing things like talking with co-workers by the water cooler and surfing the net, you might see ways you can improve your work habits, so you can get things done well before the deadline is pressing down on you. Increasing your productivity by managing your time is a surefire way to earn some praise from the people over your head. Another way to add flair to your work performance is by being a team player. It can be tempting to thing that to have flair you have to go out on a limb and try to do everything yourself, but that is not the case. Employers don’t like to see an employee trying to hog credit for things that everyone has worked on together or trying to one up everyone else on the staff. When you work together with the team, you show your employer that your interests are with making the company a success and not trying to advance you own personal agenda. If your employer understands that you see the bigger picture of making the company succeed, you are sure to get noticed and rewarded.

Web Hosting - The Internet and How It Works In one sense, detailing the statement in the title would require at least a book. In another sense, it can't be fully explained at all, since there's no central authority that designs or implements the highly distributed entity called The Internet. But the basics can certainly be outlined, simply and briefly. And it's in the interest of any novice web site owner to have some idea of how their tree fits into that gigantic forest, full of complex paths, that is called the Internet. The analogy to a forest is not far off. Every computer is a single plant, sometimes a little bush sometimes a mighty tree. A percentage, to be sure, are weeds we could do without. In networking terminology, the individual plants are called 'nodes' and each one has a domain name and IP address. Connecting those nodes are paths. The Internet, taken in total, is just the collection of all those plants and the pieces that allow for their interconnections - all the nodes and the paths between them. Servers and clients (desktop computers, laptops, PDAs, cell phones and more) make up the most visible parts of the Internet. They store information and programs that make the data accessible. But behind the scenes there are vitally important components - both hardware and software - that make the entire mesh possible and useful. Though there's no single central authority, database, or computer that creates the World Wide Web, it's nonetheless true that not all computers are equal. There is a hierarchy. That hierarchy starts with a tree with many branches: the domain system. Designators like .com, .net, .org, and so forth are familiar to everyone now. Those basic names are stored inside a relatively small number of specialized systems maintained by a few non-profit organizations. They form something called the TLD, the Top Level Domains. From there, company networks and others form what are called the Second Level Domains, such as Microsoft.com. That's further sub-divided into www.Microsoft.com which is, technically, a sub-domain but is sometimes mis-named 'a host' or a domain. A host is the name for one specific computer. That host name may or may not be, for example, 'www' and usually isn't. The domain is the name without the 'www' in front. Finally, at the bottom of the pyramid, are the individual hosts (usually servers) that provide actual information and the means to share it. Those hosts (along with other hardware and software that enable communication, such as routers) form a network. The set of all those networks taken together is the physical aspect of the Internet. There are less obvious aspects, too, that are essential. When you click on a URL (Uniform Resource Locator, such as http://www.microsoft.com) on a web page, your browser sends a request through the Internet to connect and get data. That request, and the data that is returned from the request, is divided up into packets (chunks of data wrapped in routing and control information). That's one of the reasons you will often see your web page getting painted on the screen one section at a time. When the packets take too long to get where they're supposed to go, that's a 'timeout'. Suppose you request a set of names that are stored in a database. Those names, let's suppose get stored in order. But the packets they get shoved into for delivery can arrive at your computer in any order. They're then reassembled and displayed. All those packets can be directed to the proper place because they're associated with a specified IP address, a numeric identifier that designates a host (a computer that 'hosts' data). But those numbers are hard to remember and work with, so names are layered on top, the so-called domain names we started out discussing. Imagine the postal system (the Internet). Each home (domain name) has an address (IP address). Those who live in them (programs) send and receive letters (packets). The letters contain news (database data, email messages, images) that's of interest to the residents. The Internet is very much the same.