Saltar al contenido ForoHackers

Information systems: start here

Sistemas de información
#593 · Ophuscado · · Denunciar

Information systems is the field of how organisations collect, store, process and use information with people, processes and software together. It covers the systems a company runs on: records, workflows, reporting, integration. It asks whether the technology fits the work, not only whether it runs.

Key concepts

  • Business processes: the steps by which work really happens, which software should support and not distort.
  • Data modelling: entities, relationships and rules that describe what the organisation needs to remember.
  • Integration: connecting separate systems through interfaces, files or messages without duplicating data.
  • Governance: who owns the data, who may change it, how quality and retention are kept.
  • Lifecycle: analysis, design, build, adoption, operation and eventual retirement.

Vocabulary

  • ERP: enterprise resource planning, an integrated suite for finance, stock, people and operations.
  • Master data: the shared core records, such as customers or products.
  • Legacy system: an old system still doing essential work.
  • Business analyst: the person who turns needs into requirements.

What to study, in order

  1. Map one real process, such as handling an order, as a flow diagram with its actors and records.
  2. Model its data in an entity-relationship diagram and turn it into tables.
  3. Learn SQL well enough to answer questions from that model.
  4. Study integration patterns: batch files, APIs and message queues, with the failures of each.
  5. Write a short data-governance note: owners, quality checks, retention and access.

Related tags

#databases #sql #requirements #data-engineering

Inicia sesión o únete para responder.