The second level of complexity describes a scenario where a moderate number of databases must be published on the Web. The solution presented can be shared among various agencies depending on the demand. At this level of complexity, it is recommended that the IT staff have specialists in optimized configuration of servers and databases.
Publishing 100 to 1,000 databases may occur on a central server that acts as a database repository for the agency's site. The access is done using a CMS (content management system) such as WordPress or Drupal and data is managed manually in its original format on the same CMS server, or stored in the cloud. The metadata of the databases is stored in a SQL, database, dynamically displayed on the pages generated. The system automatically checks broken links, and the search can be done directly in the metadata database or by using the CMS options or Google custom search. It is recommended that caching be used to deal with high loads, and that the metadata not be stored in the CMS.
● Databases are hosted in their original format on the application server itself or on the websites of the respective agencies in the case of a shared activity.
● Metadata is hosted in SQL databases and calls are done via dynamic page generation.
● Automatic check for broken links.
● Search via text scan in SQL database, CMS search, or Google custom search.
● Perform caching to balance load.
● Do not save metadata in the CMS.