Create databases to store electronic data
Most of the output can be produced by software today.
Producing the draft is the single thing current models are best at, and it needs no integration at all: a prompt and a couple of reference documents are enough. A person still edits it and takes responsibility for what goes out.
| How automatable | Mostly automatable |
|---|---|
| Kind of work | Drafting and content production |
| Jobs that do it | 12 occupations |
| Tool categories that apply | Generalist agents, Builders |
| O*NET activity | Thinking Creatively (4.A.2.b.2) |
What this looks like on the job
Not our paraphrase. These are real task statements recorded against this activity, spread across the 12 occupations that perform it.
- Create and maintain a database of completed appraisals.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Plan and install upgrades of database management system software to enhance database performance.
- Design and implement warehouse database structures.
- Create or maintain databases of known test defects.
- Develop databases that support Web applications and Web sites.
- Maintain or modify existing Geographic Information Systems (GIS) databases.
- Design and implement data repositories to integrate data.
- Design or maintain databases of biological data.
- Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs.
- Design and validate clinical databases, including designing or testing logic checks.
- Design databases to support healthcare applications, ensuring security, performance and reliability.
- Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
- Design or coordinate the development of integrated Geographic Information Systems (GIS) spatial or non-spatial databases.
- Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
- Develop specialized computer software routines, internet-based Geographic Information Systems (GIS) databases, or business applications to customize geographic information.
- Develop and document database architectures.
What we would actually use
One recommendation rather than a shortlist, because a shortlist is just your problem handed back. This is what we would buy for drafting and content production, and what it costs.
Drafting needs no tools, no integration and no platform. One $20 assistant and two reference documents beat any agent builder here, and every extra thing in this stack is cost with nothing behind it.
Chosen for the cheapest thing that does the job, not the best funded. Nothing on this site is sponsored, and the full landscape is there when you want to disagree with us.
The rest of the category
Context, not alternatives to weigh up. We name the layer rather than promise a named product does your specific task.
Generalist agents
Matched from the kind of work, not from vendor marketing. Check any of them can reach the system your records actually live in — that connection, not the model, is where these projects stall.
How people actually do it
No workflow names this activity yet, but these automate the same kind of work, with the prompts to paste and what to keep for yourself.
Who does this work
12 occupations in the O*NET database perform this activity. Each one has a full breakdown of its other tasks.
- Appraisers of Personal and Business Property
- Biostatisticians
- Blockchain Engineers
- Business Intelligence Analysts
- Clinical Data Managers
- Data Warehousing Specialists
- Database Administrators
- Database Architects
- Geographic Information Systems Technologists and Technicians
- Health Information Technologists and Medical Registrars
- Software Quality Assurance Analysts and Testers
- Web Developers
Work that goes with it
O*NET groups these under “Design databases”. In practice they tend to be done by the same person, in the same sitting.
| Activity | Jobs |
|---|---|
| Develop technical or scientific databases | 8 |
| Develop library or archival databases | 5 |
| Develop database parameters or specifications | 2 |
Method. The activity, its taxonomy placement and the occupations that perform it come straight from the public-domain O*NET 30.3 database. The automatability band is ours: we map each of O*NET’s 41 generalized work activities to how much of its output current software can produce, assuming a person still reviews and owns the result. It is a coarse three-way judgment on purpose. A precise-looking percentage here would be invented.