Saltar al contenido ForoHackers

Information systems: start here

Sistemas de información
#3099 · · Citar · 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

No has iniciado sesión, así que esto se publica como anónimo: no se guarda con ello ninguna cuenta, nombre ni dirección, y no puede llevar enlaces ni imágenes. Inicia sesión o únete para publicar con tu nombre. Los registros de nuestro servidor web guardan la dirección y la hora de cada petición hasta 14 días; para que la tuya no quede en ellos, usa Tor. Para escribir al equipo de forma confidencial, usa el buzón. Firmar como fuente habitual (una clave guardada solo en este navegador)

Enviar tarda unos segundos aquí: tu navegador resuelve antes una prueba de trabajo contra el spam.

Responder