__

Paramix Datatools: Databases

Databases: Store, Access, Edit Data

Core to every datatool are databases, as these supply all the required data.

Actually a database consist of three parts:

Database engine: This is where data is stored. The design of this engine fixes the way data is structured or modelled, and how efficiently the database can handle large data sets.

User interfaces: These are not only the screens, forms and buttons with which users access all that data. Also included are the numerous templates required for reports, quotes etc. Search engines are another component of user interfaces.

Connections: determine how other programs supply or share data with a database. How easy is exporting data? Can the database be linked to some external program?

Database examples

An ERP (Enterprise Resource Planning) systems consists of diverse databases, each for a specific function such as sales, products, purchase, HR etc.

So a form used by sales has data on products, customers, finances and production databases all united in one view.

CM (Content management) systems are another example of database. Here multiple users can add content to a database, which the CMS publishes on the company's website or in specific catalogs.

PIM (Product Information Management) systems consist of multiple databases, each with a set of information relevant to a product.

One database would have all the drawings, another the markets and the associated discounts. A third database would have details on a product's components: prices, masses, delivery times etc.

PIM systems are in turn connected CM systems to publish product information or to ERP systems.




Your Feedback


Your E-mail