Content Management Systems

1
Content Management Systems
Why use CMS?

• Distributed content creation editing
• Reuse content and components
• Standardized page design
• User accounts and security

2
Content Management Systems
1. Input Once Output Many Formats
HTML
ADA
Content
Print
Content Database
Input Forms
WML
PDA Proprietary
RSS- XML
3
Content Management Systems
Design
Separate Content from Design
HTML
Template CSS
ADA
Template CSS
Content
Print
Template CSS
Content Database
Input Forms
WML
WML Template
PDA Proprietary
Template HTML Clipping CSS
RSS- XML
Template XML CSS
4
Content Management Systems
Separate Content from Design
HTML
ADA
Content
Design
Print
Content Database
Design Database
Input Forms
Template
WML
PDA Proprietary
RSS- XML
5
Content Management Systems
Separate Content
from Design
HTML
ADA
Content
Design
Print
Content Database
Design Database
Input Forms
Template
WML
PDA Proprietary
Design Form
RSS- XML
6
Content Management Systems
HTML
Input Forms
Expert
ADA
Input Forms
Staff
Design
Content
Print
Content Database
Design Database
Input Forms
Template
Faculty
WML
Input Forms
User-driven FAQ
PDA Proprietary
Input Forms
Design Forms
Syndicated News
RSS- XML
7
Content Management Systems
8
Content Management Systems
Separate Content from Design
Queries thispage (Records1, Time0ms) SQL
select from tblPageDefs where pID1
(Records1, Time10ms) pagecontent (Records2,
Time0ms) SQL select from tblPageContent
where pid1 and post1 order by
displayorder menudata (Records1, Time0ms) SQL
select from tblMenuContent where post1 and
pID1 menu (Records41, Time0ms) SQL select
from tblMenuContent where (menulevel1 gt 0) and
(menuID1) order by menulevel1, menulevel2,
menulevel3, menulevel4
9
Content Management Systems
Data Architecture
Content Classes

• News
• Calendar
• Publications
• User data and requests
• FAQs

10
Content Management Systems
Data Architecture Display
Content Classes

• News
• Calendar
• User data and requests
• FAQs

tblNews
tblCalendar
11
Content Management Systems
Data Architecture Display
Content Classes

• News
• Calendar
• User data and requests
• FAQs

tblNews
tblCalendar
Display Modules

• Custom tags, CFCs,

• Query output

cf_News
cf_Calendar
12
Content Management Systems
Data Architecture Display
Banner
Content Module is a query and ltcfoutputgt loop.
Menu
Layout
News
Calendar

13
Content Management Systems
Data Architecture Display
Layout Module is a query and ltcfoutputgt loop
also. It knows what modules to call from the
Page Content table.
Banner
Menu
Layout
News
Calendar

14
Content Management Systems
Data Architecture Display
Banner
The page template queries the design table to
select from available Layout Modules.
Menu
Layout
News
Features
Calendar

15
Content Management Systems
16
Content Management Systems
17
Content Management Systems
18
Content Management Systems
19
Content Management Systems
20
Content Management Systems
Data Architecture Display
Banner
Separate modules for Banner and Menu. The page
template queries the page design table to
determine what banner and menu modules to call.
(Can have no menu)
Menu
Layout
News
Features
Calendar

21
Content Management Systems
Data Architecture Display
Page ID ties all modules, banner and content
Banner
Menu
Layout
The Menu is a separate object !!!
News
Features
Calendar

22
Content Management Systems
Data Architecture Menu

• Separate module
• 4 Nested levels
• Only relationship to content is page ID.
  Can be external URLs.
• Page design and menu
  construction separate

23
Content Management Systems
24
Content Management Systems
25
Content Management Systems
Integrating Web Content Keywords
Contentdatabase
tblNews
26
Content Management Systems
Integrating Web Content Keywords
Contentdatabase
tblNews
tblKeywords
27
Content Management Systems
Integrating Web Content Keywords
select vcTitle,vcImageURL,vcPDFURL,vcHTMLURL
from tblPublications where (bDistributeltgt0) and
(post ltgt0) and (iPublicationID IN (SELECT
iPublicationID FROM tblPublicationsByKeywords
WHERE iKeywordID IN (6))) order by title
Contentdatabase
tblNews
tblNewsX Keywords
tblKeywords
28
Content Management Systems
Integrating Web Content Keywords Meta Data
Meta data(Web search)
Web Search
Contentdatabase
Meta Keywords
Keyword Hierarchy
tblNews
tblNewsX Keywords
tblKeywords
29
Content Management Systems
Integrating Web Content Multiple Queries!
Queries thispage (Records1, Time10ms) SQL
select from tblPageDefs where pID1 menudata
(Records2, Time0ms) SQL select from
tblMenuContent where post1 and pID1 menu
(Records41, Time0ms) SQL select from
tblMenuContent where (menulevel1 gt 0) and
(menuID1) order by menulevel1, menulevel2,
menulevel3, menulevel4 pagecontent (Records5,
Time0ms) SQL select from tblPageContent
where pid1 and post1 order by displayorder
GetImageRecords (Records4, Time10ms) SQL
select imageID from tblRotateImages where post1
and horses1 GetEntry (Records1, Time0ms) SQL
SELECT FROM tblRotateImages WHERE imageID
25 getseminars (Records0, Time10ms) SQL
SELECT FROM tblSeminars WHERE (datediff("d",
getdate(), exdate) gt 0) AND (active 1) ORDER BY
exyear, exmonth, exday getnews (Records52,
Time60ms) SQL SELECT FROM tblNews WHERE
(datediff("d", getdate(), exdate) gt 0) AND (post
1) ORDER BY priority ASC, postDate
DESC getcalendar (Records5, Time20ms) SQL
SELECT FROM tblCalendar WHERE (datediff("d",
getdate(), exdate) gt 0) AND (post 1) ORDER BY
exdate ASC, priority ASC
30
Content Management Systems
Securing Web Content User Accounts
31
Content Management Systems
Securing Web Content User Accounts
SELECT DISTINCT formAccountID, userID, formID,
active FROM tblFormAccounts WHERE formID 17
and userID 'cjohansen'
32
Content Management Systems
Securing Web Content User Accounts
select formAccountID, userID, formID, active
from tblFormAccounts where formAccountID 12
33
Content Management Systems