It wants Oracle or SQL Server. And it all comes at a price. It needs to be built upon. If you are reading this site, you probably have a clue about the system, and if not, there are plenty of links on my sidebar to fill you in. And Manila is Frontier's killer app.
Manila supports static rendering, with automatic cache maintenance.
If you update a page on your site, it gets rendered and stored where it can be statically served, all automatically. I don't know about how Frontier supports workflow. I also know it's possible to tie Frontier to a relational database, but there's so much that can be done before you need to. Zope Zope is dear to my heart. It's an open source application server.