MySQL is currently the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications.
Free-software projects that require a full-featured database management system often use MySQL. For commercial use, several paid editions are available, and offer additional functionality. Some free software project examples: Joomla, WordPress, MyBB, phpBB, Drupal and other software built on the LAMP software stack. MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google and Facebook.
What is a Database?
A database is a structure that comes in two flavors: a flat database and a relational database. A relational database is much more oriented to the human mind and is often preferred over the gabble-de-gook flat database that are just stored on hard drives like a text file. MySQL is a relational database.
In a relational structured database there are tables that store data. The columns define which kinds of information will be stored in the table. An individual column must be created for each type of data you wish to store (i.e. Age, Weight, Height).
On the other hand, a row contains the actual values for these specified columns. Each row will have 1 value for each and every column. For example a table with columns (Name, Age, Weight-lbs) could have a row with the values (Bob, 65, 165). If all this relational database talk is too confusing, don’t despair. We will talk about and show a few examples in the coming lessons.
Why Use a Database?
Databases are most useful when it comes to storing information that fits into logical categories. For example, say that you wanted to store information of all the employees in a company. With a database you can group different parts of your business into separate tables to help store your information logically. Example tables might be: Employees, Supervisors, and Customers. Each table would then contain columns specific to these three areas. To help store information related to each employee, the Employees table might have the following columns: Hire, Date, Position, Age, and Salary.
What it is:
Digital curation is the selection, preservation, maintenance, collection and archiving of digital assets.
Hot to use it:
It is the process of establishing and developing long term repositories of digital assets for current and future reference by researchers, scientists, and historians, and scholars generally.
Use in social media/media/advertising:
In Twitter, people use curation to promote and link to stories, research stories and identify trends.
What is it?
Transparency, essentially meaning openness, means different things to different people, even in the context of social media. It can refer to being transparent about relationships in social media posts, like revealing clients or affiliate link. To other people, it means another opportunity to interact in a customer-seller relationship, by checking each other out before a purchase and having an increased feeling of knowing each other. Still others take it to the extreme of living totally public lives, which might be what social media is leading toward.
How does it work?
Social media makes it a lot easier for all types of people and organizations to be more “out there” in the public. Therefore, there is an opportunity to be a lot more open and transparent about your actions and thoughts.
What’s an example of it used in social media, media or advertising?
One example we discussed in class is Dell linking to their own exploding laptop and acknowledging the problem instead of trying to ignore it. Another example could be a retailer posting about the reasons behind a late delivery in order to make their customers aware.
A few links:
Social media transparency: How realistic is it? [http://socialmediatoday.com/SMC/77818]
Transparency in 140 characters: [http://technomarketer.typepad.com/technomarketer/2009/01/transparency-in-140-characters.html]
How can social media transparency help your business? [http://www.ultimatemarketingonline.com/blog/socialmedia/how-can-social-media-transparency-help-your-business/]
An era of total transparency [http://www.socialmedia.biz/2009/11/16/an-era-of-total-transparency/]
The amount of money that is paid per click by the advertiser when an ad is clicked on a website.
Synonym of pay-per-click.
How to use it:
Websites use advertisements on pages and the number of clicks that an ad receives determines how much money the advertiser has to pay for the ad.
Any of the advertisements in bold underneath the search bar on Google, Bing, Yahoo or on the side of the page in Facebook. (AdSense, adCenter, etc.)
It’s basically a way that you can post your stuff, and license it. With that license, you’re posts are copyrighted but you can allow people to use your work as long as they give you credit.
Creative Commons (CC) is a non-profit organization headquartered in San Francisco, California, United States devoted to expanding the range of creative works available for others to build upon legally and to share. The organization has released several copyright-licenses known as Creative Commons licenses free of charge to the public. These licenses allow creators to communicate which rights they reserve, and which rights they waive for the benefit of recipients or other creators. An easy to understand one-page explanation of rights, with associated visual symbols, explains the specifics of each Creative Commons license. This simplicity distinguishes Creative Commons from an all-rights reserved copyright. Creative Commons was invented to create a more flexible copyright model, replacing “all rights reserved” with “some rights reserved”. Wikipedia is one of the notable web-based projects using one of its licenses.