Welcome to elreno.org

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.

Better Employees Avoid these Top Five Office Blunders Being a good employee can go a long way when it comes to the workplace and job advancement. When you are working in an office there are certain unspoken rules that you will want to follow. One of the biggest mistakes that one can make when they are working in an office is having romantic relationships with co-workers or their boss. This completely colors the work situation and can cause major problems in the workplace. Although office romances are common, they typically bring about some friction between the couple or the couple and others. The remedy for office romance issues is that usually one or both members of the romance leave the job. Being dishonest is an office blunder that can land you in the unemployment office. Stealing from your job, lying about reports being done and trying to cause conflict by lying to one co-worker about another are all very silly mistakes that employees make. It is not acceptable to borrow money from the float, even if you are intending to pay it back. Pretending like you have completed your work when it is only half done is not wise. Gossiping and stirring up rumors is also not a good idea. All of these things can make you the bosses’ number one most wanted to fire employee. Not following the dress code is another easy to remedy problem that many employees make. The reason why this is such a big deal is because it says that you do not care about your position enough to wear the right clothing. It also can land your boss in hot water if the director or head supervisor comes into the department. Not only will you be reprimanded for not having on proper uniform, your boss will be singled out for not making you comply with uniform standards. The too can make you very unpopular with the boss. Saying incredibly inappropriate things is also a blunder that can easily be avoided. Jokes and comments about the way that people look in their clothing can border on the line of harassment. In fact, just about anything can be proven to be harassment by a good lawyer. That is why it is best to keep jokes and opinions about others to you and you only. You could lose your job and find yourself in a lawsuit otherwise. The number one blunder than employees make on the job is having a bad attitude. People that are very negative bring down a crowd, not just themselves. That means that when the time comes to make cuts, the bad attitude person is the likely candidate. Removing a negative person from the workplace can bring up the morale of everyone else. Even very effective employees with bad attitude are often terminated simply because they bring down the mood and productivity of others. Be thankful that you have a job and keep a positive frame of mind. If you are not happy with your job, search for another one. In addition to these five blunders that better employees avoid, there are a few obvious ones. Being tardy is perhaps one of the most prevalent and easy to prevent blunders employees make. Being tardy on a regular basis is not acceptable. There is no reason to continuously be tardy for work. If you are getting stuck in traffic, leave earlier or take a different route. Being a good employee can take you a long way at work and in your personal life. It feels good to know that you are an effective person be it at work or elsewhere. Be kind to co-workers and go through your days with a positive mindset. With these tools in place you will be able to avoid blunders more effectively.

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.