Book Image

Alfresco for Administrators

By : Vandana Pal
Book Image

Alfresco for Administrators

By: Vandana Pal

Overview of this book

Alfresco is an open source Enterprise Content Management (ECM) system for Windows and Linux-like operating systems. The year-on-year growth of business connections, contacts, and communications is expanding enterprise boundaries more than ever before. Alfresco enables organizations to collaborate more effectively, improve business process efficiency, and ensure information governance. The basic purpose of Alfresco is to help users to capture and manage information in a better way. It helps you capture, organize, and share binary files. This book will cover the basic building blocks of an Alfresco system, how the components fit together, and the information required to build a system architecture. This book will also focus on security aspects of Alfresco. such as authentication, troubleshooting, managing permissions, and so on. It will also focus on managing content and storage, indexing and searches, setting up clustering for high availability, and so forth.
Table of Contents (17 chapters)
Alfresco for Administrators
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Understanding the database schema


Alfresco has its own standard database schema to store all its information. The database is the heart of the whole CMS system.

External applications, apart from Alfresco, should not perform any write operations in the Alfresco database directly. Always make sure you use the database for reading only. This is a standard practice. Don't make any changes to any values in the database. This schema is only required to understand Alfresco and troubleshoot.

As you know, everything in Alfresco is based around nodes, so the tables are also named in the same pattern. The database schema of Alfresco is very easy to understand. So, here we will not dive into all the tables, only a few important ones will be covered.

Schema of the alf_node table

This table is the main primary reference of the node. This is the first table you will always look for. All the node entries are present in this table. It captures primary node information like UUID, created date, modified date,...