VOOZH about

URL: https://en.wikipedia.org/wiki/Database_publishing

⇱ Database publishing - Wikipedia


Jump to content
From Wikipedia, the free encyclopedia
Automated Media Production
This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these messages)
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.
Find sources: "Database publishing" – news · newspapers · books · scholar · JSTOR
(March 2025) (Learn how and when to remove this message)
You can help expand this article with text translated from the corresponding article in German. (January 2025) Click [show] for important translation instructions.
  • Machine translation, like DeepL or Google Translate, is a useful starting point for translations, but translators must follow the LLM translation guideline, revise errors as necessary and confirm that the translation is accurate, rather than simply copy-pasting machine-translated text into the English Wikipedia.
  • Consider adding a topic to this template: there are already 1,784 articles in the main category, and specifying|topic= will aid in categorization.
  • Do not translate text that appears unreliable or low-quality. If possible, verify the text with references provided in the foreign-language article.
  • You must provide copyright attribution in the edit summary accompanying your translation by providing an interlanguage link to the source of your translation. A model attribution edit summary is Content in this edit is translated from the existing German Wikipedia article at [[:de:Database Publishing]]; see its history for attribution.
  • You may also add the template {{Translated|de|Database Publishing}} to the talk page.
  • For more guidance, see Wikipedia:Translation.
(Learn how and when to remove this message)
👁 Image
BMUG Disk Catalog 1989, the first known example of direct database-to-negative publishing. Programmer Greg Dow and prepress expert Bill Woodcock published the annual catalog of BMUG's software archive using Nashoba FileMaker output display templates on Macintosh computers to image direct to film from which the plates were burned, on a Linotronic 300 imagesetter. Frontispieces were made in Adobe Illustrator 88 and interleaved in plate compositing. It was set in Adobe Bookman, and printed in grayscale at a 60-line screen for an intentionally minimalist effect.

Database publishing is an area of automated media production in which specialized techniques are used to generate paginated documents from source data residing in traditional databases such as product information management (PIM), digital asset management (DAM), and enterprise resource planning (ERP) platforms. Common examples are mail order catalogues, direct marketing, report generation, price lists and telephone directories. The database content can be in the form of text and pictures but can also contain metadata related to formatting and special rules that may apply to the document generation process. Database publishing can be incorporated into larger workflows as a component, where documents are created, approved, revised and released.

The basic idea is using database contents like product information, article and price information to fill out pre-formatted template documents. Templates are typically created in a normal desktop layout application where certain boxes or text are designated as placeholders. These placeholders are then targeted with new content which flows in from the database. This allows for quick generation of final output and, in case of changes to the database, quickly perform updates, with limited or no manual intervention. This process is facilitated by specialized software solutions that automate the integration of database content into templates, like InBetween software solution. Such software automates the creation of documents such as catalogs and price lists by integrating product data from various sources.[1]

Another model of database publishing is found in many web-to-print sites where users browse templates from an online catalog (such as business cards or brochures), personalize the selected template by filling in a form and then view the rendered result. In this case the initial source of data is from user input, but it is captured in a database so that if the same user revisits the site later, they can resume editing where they left off. The form is then pre-filled from the database-stored variables the user entered before.

The main layout applications for this workflow are Datalogics Pager, Adobe FrameMaker / InDesign, QuarkXPress, Xyvision, Arbortext Advanced Print Publisher (formerly 3B2) and priint:suite. Generally, these layout applications have a corresponding server version, which receives commands via web interfaces rather than desktop interaction. QuarkXPress Server and Adobe InDesign Server both take full advantage of the design features available in their respective desktop versions.

These applications make their broad spectrum of features available for extension and integration with vertical products, that can be developed either internally, through some form of scripting (e.g. JavaScript or AppleScript for InDesign), or externally, through some API and corresponding developer kits.

Other variants of database publishing are the rendering of content for direct PDF output. This approach prevents manual intervention on the final output, since PDF is not (comfortably) editable. This may not be perceived as a limitation in situations like report generation where manual editability is not needed or not desired.

See also

[edit]

References

[edit]
  1. ^ Struffmann, Birthe (2024-09-30). "Database Publishing: Printprodukte automatisiert erstellen" (in German). Retrieved 2025-02-26.