Study
Innovation & DesignHigh ImpactModerate effect

Automated Relational Database Design from Business Forms

Business forms can serve as direct input for automated relational database design, streamlining the process for organizations lacking specialized technical expertise.

International Journal of Database Management Systems · 2015

01

Key Findings

  • 01Business forms can be a viable source for database requirements.
  • 02Automated functional dependency discovery and normalization are feasible.
  • 03User domain knowledge is crucial for accuracy.
02

Application

Design takeaway

Consider form-based interfaces as a primary input method for database design tools, especially when targeting users with less technical expertise.

How to apply

Develop a prototype tool that accepts scanned or digital business forms, extracts relevant fields, and guides the user through a simplified normalization process.

Project actions

  • 01Focus on a specific type of business form for your design project.
  • 02Clearly define the algorithms used for functional dependency and normalization.
  • 03Consider how user feedback will be incorporated to refine the database structure.
03

Method & Evidence

AimCan business forms be effectively utilized as input to automate the relational database design process, including normalization and key/relationship identification?
MethodAlgorithmic processing of input data
ProcedureThe proposed method takes business forms as input, extracts un-normalized data, applies a functional dependency algorithm to discover relationships, and then uses a normalization algorithm to generate a structured, normalized database schema with keys and relationships.
ContextInformation and Communication Technology adoption for small and medium enterprises.

Variables

IVBusiness form structure and content
DVNormalized relational database schema (tables, keys, relationships)
CVFunctional dependency algorithm, normalization algorithm, user domain knowledge input
04

Strengths & Limitations

Strengths

  • +Addresses a practical need for simplified database design.
  • +Utilizes a novel input method (business forms).
  • +Employs established database design principles (normalization).

Limitations

The effectiveness of this method is limited by the complexity and consistency of the business forms used as input. Ambiguous or incomplete forms will lead to inaccurate database designs.

Reliability & validity

Reliability could be assessed by testing the system with multiple similar forms to see if it produces consistent database structures. Validity would depend on comparing the automatically generated schema against a manually designed, expert-validated schema for the same business requirements.

Think critically

To what extent can the 'black box' automation of database design replace the nuanced understanding and strategic decisions made by experienced database architects?

05

Design Principles

"Abstract complex technical processes into intuitive user interfaces."

This approach democratizes database creation by abstracting complex design principles into a more accessible input method. It empowers smaller businesses or teams with limited database administration resources to establish structured data repositories efficiently.

06

What This Means for Your Design

You can use everyday business forms, like order forms or invoices, to help a computer automatically figure out how to set up a database. It's like the computer learns from the forms, but you still need to tell it what the information means.

How to use in your project

  • 1.Reference this study when discussing methods for simplifying complex technical processes in your design project.
  • 2.Use it to justify the development of user-friendly interfaces for data management tools.
07

Add to My Project

08

Quick Cite

(2015). An Approach to Automate the Relational Database Design Process. International Journal of Database Management Systems. https://doi.org/10.5121/ijdms.2015.7604 Retrieved from https://designdex.org/study/54ca9ca4-04f9-439f-b2c1-c04d40d0bb30/automated-relational-database-design-from-business-forms

Paragraph starter

This research proposes an automated approach to relational database design by leveraging business forms as input. By applying functional dependency and normalization algorithms to data extracted from these forms, the system can generate a structured database schema. This method is particularly relevant for organizations seeking to implement information systems without extensive in-house database expertise, though it acknowledges the necessity of user domain knowledge for ensuring design accuracy.

09

Source

International Journal of Database Management Systems

An Approach to Automate the Relational Database Design Process

journal · 2015

View source

Questions about this research

What does the research say about automated relational database design from business forms?
Consider form-based interfaces as a primary input method for database design tools, especially when targeting users with less technical expertise. Evidence: International Journal of Database Management Systems (2015).
Why does "Automated Relational Database Design from Business Forms" matter for design?
This approach democratizes database creation by abstracting complex design principles into a more accessible input method. It empowers smaller businesses or teams with limited database administration resources to establish structured data repositories efficiently.
How can designers apply this research?
Consider form-based interfaces as a primary input method for database design tools, especially when targeting users with less technical expertise.
What were the main findings?
Business forms can be a viable source for database requirements.. Automated functional dependency discovery and normalization are feasible.. User domain knowledge is crucial for accuracy.
What research method was used?
Algorithmic processing of input data.
How strong is the evidence?
Evidence strength is rated Moderate effect, based on a 2015 journal from International Journal of Database Management Systems.
What should I do differently in my next project?
Develop a prototype tool that accepts scanned or digital business forms, extracts relevant fields, and guides the user through a simplified normalization process.
What are the limitations?
The accuracy of the generated database is highly dependent on the completeness and clarity of the input business forms and the user's domain knowledge.
Is there evidence that database design affects design outcomes?
The study demonstrates that by analyzing business forms, it's possible to automatically generate a normalized database structure, though human input is still required for contextual understanding. This approach democratizes database creation by abstracting complex design principles into a more accessible input method. Source: International Journal of Database Management Systems (2015).
Where does this relational database research apply?
Information and Communication Technology adoption for small and medium enterprises. It sits within innovation & design research on designdex.org.

Related research topics

database design design research · evidence on database design · does database design improve design outcomes · relational database studies for designers · database design and relational database findings · innovation & design research evidence