Posts Tagged ‘Database’

Static Vs Dynamic websites – what’s the difference?

Monday, September 14th, 2009

What are static and dynamic websites?

There are many static websites on the Internet, you won’t be able to tell immediately if it is static, but the chances are, if the site looks basic and is for a smaller company, and simply delivers information without any bells and whistles, it could be a static website. Static websites can only really be updated by someone with a knowledge of website development. Static websites are the cheapest to develop and host, and many smaller companies still use these to get a web presence.

Advantages of static websites

  • Quick to develop
  • Cheap to develop
  • Cheap to host

Disadvantages of static websites

  • Requires web development expertise to update site
  • Site not as useful for the user
  • Content can get stagnant

Dynamic sites on the other hand can be more expensive to develop initially, but the advantages are numerous. At a basic level, a dynamic website can give the website owner the ability to simply update and add new content to the site. For example, news and events could be posted to the site through a simple browser interface. Dynamic features of a site are only limited by imagination. Some examples of dynamic website features could be: content management system, e-commerce system, bulletin / discussion boards, intranet or extranet facilities, ability for clients or users to upload documents, ability for administrators or users to create content or add information to a site (dynamic publishing).

Advantages of dynamic websites

  • Much more functional website
  • Much easier to update
  • New content brings people back to the site and helps in the search engines
  • Can work as a system to allow staff or users to collaborate

Disadvantages of dynamic websites

  • Slower / more expensive to develop
  • Hosting costs a little more

Summary

Many sites from the last decade are static, but more and more people are realising the advantages of having a dynamic website. Dynamic websites can make the most of your site and either use it as a tool or create a professional, interesting experience for your visitors.

This article aimed to tackle some of the questions faced by website owners. If you’d like to comment on this article or have any questions, please contact us.

bg3

Tags:
Posted in Uncategorized | No Comments »

Database Design

Sunday, August 23rd, 2009

Database design is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language, which can then be used to create a database. A fully attributed data model contains detailed attributes for each entity.

The term database design can be used to describe many different parts of the design of an overall database system. Principally, and most correctly, it can be thought of as the logical design of the base data structures used to store the data. In the relational model these are the tables and views. In an object database the entities and relationships map directly to object classes and named relationships. However, the term database design could also be used to apply to the overall process of designing, not just the base data structures, but also the forms and queries used as part of the overall database application within the database management system (DBMS).

Tags:
Posted in Technology | No Comments »

Why MySQL?

Sunday, August 23rd, 2009

MySQL (pronounced /maɪˌɛskjuːˈɛl/ My S-Q-L, or “My sequel” /maɪˈsiːkwəl/) is a relational database management system (RDBMS) which has more than 6 million installations. MySQL stands for “My Structured Query Language”. The program runs as a server providing multi-user access to a number of databases.

The project’s source code is available under terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now a subsidiary of Sun Microsystems,[4] which holds the copyright to most of the codebase.

MySQL is commonly used by free software projects which require a full-featured database management system, such as WordPress, phpBB and other software built on the LAMP software stack. It is also used in very high-scale World Wide Web products including Google and Facebook.

MySQL is used in web applications and acts as the database component of the LAMP software stack. Its popularity for use with web applications is closely tied to the popularity of PHP, which is often combined with MySQL. Several high-traffic web sites (including Flickr, Facebook, Wikipedia, Google (though not for searches), Nokia, Auctionmarts and YouTube) use MySQL for data storage and logging of user data.

Tags:
Posted in Technology | No Comments »