1 / 33

Content Management Systems

Content Management Systems. Why use CMS?. Distributed content creation & editing Reuse content and components Standardized page design User accounts and security. Content Management Systems. 1. Input Once… …Output Many Formats. HTML. ADA. Content. Print. Content Database.

amal-hyde
Download Presentation

Content Management Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 Expert Input Forms ADA Input Forms Staff Content Design Print Content Database Design Database Faculty Input Forms Template 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 (Records=1, Time=0ms) SQL = select * from tblPageDefs where pID=1 (Records=1, Time=10ms) pagecontent (Records=2, Time=0ms) SQL = select * from tblPageContent where pid=1 and post=1 order by displayorder menudata (Records=1, Time=0ms) SQL = select * from tblMenuContent where post=1 and pID=1 menu (Records=41, Time=0ms) SQL = select * from tblMenuContent where (menulevel1 > 0) and (menuID=1) 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 <cfoutput> loop. Menu Layout News Calendar …

  13. Content Management Systems Data Architecture: Display Layout Module is a query and <cfoutput> 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 Features News … 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 Features News … 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 !!! Features News … 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 (bDistribute<>0) and (post <>0) 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 (Records=1, Time=10ms) SQL = select * from tblPageDefs where pID=1 menudata (Records=2, Time=0ms) SQL = select * from tblMenuContent where post=1 and pID=1 menu (Records=41, Time=0ms) SQL = select * from tblMenuContent where (menulevel1 > 0) and (menuID=1) order by menulevel1, menulevel2, menulevel3, menulevel4 pagecontent (Records=5, Time=0ms) SQL = select * from tblPageContent where pid=1 and post=1 order by displayorder GetImageRecords (Records=4, Time=10ms) SQL = select imageID from tblRotateImages where post=1 and horses=1 GetEntry (Records=1, Time=0ms) SQL = SELECT * FROM tblRotateImages WHERE imageID = 25 getseminars (Records=0, Time=10ms) SQL = SELECT * FROM tblSeminars WHERE (datediff("d", getdate(), exdate) > 0) AND (active =1) ORDER BY exyear, exmonth, exday getnews (Records=52, Time=60ms) SQL = SELECT * FROM tblNews WHERE (datediff("d", getdate(), exdate) > 0) AND (post = 1) ORDER BY priority ASC, postDate DESC getcalendar (Records=5, Time=20ms) SQL = SELECT * FROM tblCalendar WHERE (datediff("d", getdate(), exdate) > 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

More Related