Using the information provided below, please create a SINGLE COLDFUSION TEMPLATE

Question

Using the information provided below, please create a SINGLE COLDFUSION TEMPLATE to accomplish the required task. You will be given a Database schema and other relevant information to successfully complete the task. Please be sure that all requirements are met. These requirements are the bare minimum of what we are looking for. However, feel free to add your own style and/or personal touches to the layout, functionality, or behavior. Also, keep in mind that we will attempt to execute your template under a CF9 / MySQL 5.0 environment. We will assess your solution and go over the results with you during the in person interview. TASK: We would like a single page that displays news articles - both as a listing page as well as a detailed article page that displays any available image(s). Users are initially shown a snippet of all available articles. Clicking on the title of the article or the “Read More” link will display the article in its entirety along with any available images. REQUIREMENTS: - Display all articles from the current calendar year - ordered by date in descending order. - Each article should only display the first 300 characters of content and a “Read More” link to view the full version. (See screen shot) - Each article should display the title, date, and author. (See screen shot) - Article titles should be displayed with all words capitalized. Upon clicking the title or “read more” link the expected result is a detailed view of that article. - The article should be displayed in it’s entirety. - Display any images associated to the article directly below the content as thumbnails. - Clicking on an image will pop a new window which simply displays the full-size image. You are free to make any assumptions on this task that are not otherwise explicitly stated and/or seem ambiguous. You are also free to interpret these requirements in any way which makes sense to you as the developer. Database Schema: //storage of articles articles{ article_ID int(11) PK, article_title varchar(200), article_author varchar(50), article_content text, article_date datetime, article_archived tinyint(1) default(0) } //storage of image information images { image_ID int(11) PK, image_thumbpath varchar(200), image_fullpath varchar(200) } //mapping table for images to articles. article_image_mapping { aim_id int(11) PK, aim_articleID int(11) FK : articles.article_ID, aim_imageID int(11) FK: images.image_ID, aim_

Explanation / Answer

This can affect the way a DBA manages statistics during testing and upgrade. Certain optimizer statistics are created in response to the optimizer metadata to improve cardinality estimates over time. Specifically, these are histograms (in response to column usage information) and column group statistics (in response to SQL plan directives).

You need to be aware of changes to optimizer statistics and metadata so that you can manage the optimizer successfully during an upgrade.

You may need to:

In the directories below are some experimental scripts to help you manage statistics. The aim here is for you to take and adapt them to you own needs. They are broken down into three categories:

show_stats

These scripts demonstrate how to view extended statistics, histograms, SQL plan directives and column usage information. They also demonstrate how you can see which histograms and extended statistics have been created automatically.

duplicate

These scripts query a database schema to spool scripts that can be used to create matching histograms and extended statistics on another database.

dpump_copy

These scripts demonstrate how easy it is to use Data Pump to copy all relevant statistics from one database schema to another.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.