Welcome to www.msunderestimated.com
|
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.
The Importance of Written Communication (written communication) Written communication is just as important as oral communication. Of course, all communication requires a clear concise flow of ideas, and words that are easily understood by any reader or listener. Written communication is one of the most difficult forms of communication as writers are typically prone to write for themselves, instead of for their audience. It is important for readers to understand what has been written and why it has been written. Writing is very different from oral communication, because words are written they cannot be taken back. Communicating through writing is more concrete than verbal communication with more room for mistakes and misunderstandings. The slightest misunderstanding can cause chaos for many, so it is important to right as clear and concise as possible. This form of communication is defined as a clear expression of ideas in writing. The clear expression of ideas includes grammar, organization, and structure of an essay, book, article, or report. Grammar is a large part of written communication, and writers must always consider spelling, punctuation, writing style, and wording before displaying their work to the world. Proper grammar and form may have a varying importance for different writing jobs, and usually depend on the method of communication used for that job. However, it is always important to strive to use correct grammar, spelling, and punctuation. Most writers use spell check and grammar check on their computers to ensure that the grammar and spelling is suitable. Grammar is also a major factor when writing as a freelance writing and submitting work to an editor. Many editors will reject further submissions from writers who have too many grammar and spelling errors. Organization of a letter, essay, article, or book is also important factors of written communication. Communication should always have a logical organization that is easy for readers to follow. For the reader, it is much easier to read a paragraph with one common theme that relates to the entire work. Most writing requires a clear flow of ideas and proper transitions to indicate when a new idea is being presented. However, transitions are not often needed for pieces of writing that are clearly organized. Ideas should also be expressed in a manner that is easy for the reader to understand and recognize. Data in the writing should also be presented accurately to support conclusions and recommendations given by the writer. The structure is also important in a piece of writing. All writing is organized into five to seven sentence paragraphs that all relate to each other. The number of paragraphs usually depends on the work that is being written. For example, it is common for essay to contain five concise paragraphs that all relate to a common theme. Generally, essays begin with an introductory paragraph, followed by three supporting paragraphs, and ended with a concluding paragraph. The basic structure of a piece of writing is only the beginning of written communication; the words used and the organization of the work is important to the readers understanding of the work. In many cases, the style format, and content must be adjusted to the communication level of the reader. The ability to convey ideas to a certain reader are very important, and a key component of written communication. Like oral communication, written communication can be seen as an aspect of life that makes the world go round, and learning to communicate through written word has become a basic skill for most people. Communication is needed in all aspects of life, and although many people cannot write well, it is important to be able to communicate out loud and on paper. Prayers, Ploys and Passions: The Poetry that Gets Published (published poetry) Some people may tell you that poetry doesn’t get published. Published poetry is only that written by people who have already died. That is not true however. Poetry is not as frequently found as other kinds of writing, but it is a genre that is still alive and well in today’s publishing world. If you are a poetry writer, you are also probably a poetry reader. You of all people know that poetry publishers are still out there. There are specific types of poetry that tend to get published though. There are special interest outlets for other types, but in general, what gets published gets repeatedly published as time goes on. There are three main categories that currently published poetry falls into. Those categories encompass the most important interests of people today. Prayers and Matters of Faith The first category of published poetry involves faith. There are people that subscribe to all different kinds of faith and it is that belief that is at the core of many people’s lives. Atheists are a minority in the world. Since faith is such an important part of so many people’s understandings of the world, it is no surprise that it draws poetic words from those who believe. It started long ago. The Bible, for example, is full of poetry. Those people who first knew God were inclined to speak of him through the illustrative voice of poetry. Today people are the same way. Such is their deep experience with God that they must express their emotions with an emotional type of writing. Since so many people have personal experiences with God, those who do not write are interested in reading the writings of others. For that reason, matters of faith, and especially expressive prayers placed in poetry get published. Ploys and Plans for the Nation National interest is also of major interest to most people. As a group of people head through their lives, united with others of the same nationality, they must want to know where the group as a whole is headed. Much of the published poetry in this category contains hopes and dreams for a country’s future and expected path through history. More of the poetry in this category though is in protest of how a nation has forged its path as it has grown. Frustration with events beyond one’s control elicits words that can only have their full meaning in poetry. Since those of a nation are united with each other, poetic commentaries about that nation are of interest to everyone. They help each person express their feelings and frustrations and hopes for their home country. Passion and the Human Condition of Love People are obviously not only connected to each other as citizens of the same country. People need each other in a much more personal sense than that. A third major category of published poetry is that which contains expressions of love between people. Love poems are a genre that dates back, again, to biblical times. Romantic love has always been a popular theme within poetry because of the passion that can be displayed with poetic devices. Other kinds of love are also well expressed in verse. The love of a mother for her child or that of a friend for another friend is a common topic in poetry. Humans thrive on love. That is why poetry about love gets published. Published poetry does fall into three major categories. It appears in books and anthologies, but also in magazines and even greeting cards. As long as a poem is effective in describing a common human reaction to life, it will probably be passed along from person to person. Poetry is a beloved form of writing that connects people to one another. As long as humanity feels, poetry will continue to be published. |