Schema modeler for generating an efficient database schema

Details Schema modeler for generating an efficient database schema Schema modeler for generating an efficient database schema

2006-11-27

2011-12-13

Timblin, Robert (Department: 2167)

Data processing: database and file management or data structures

Database design

Database and data structure management

C707S804000, C707S805000, C707S807000

Reexamination Certificate

active

08078643

ABSTRACT:
A schema modeler for generating an efficient database schema. Provides intelligent choices for schema structure, generates efficient schemas while minimizing the amount of experience required by a database designer. Architectural elements of a schema design are proposed based on field inputs such as field type or relationship. Schema information is manually entered or imported. Configured for structural compatibility and semantic compatibility checking on fields and relationships for data integrity due to nested structure denormalization, inspection of lookup tables that can hold an unlimited number of records, inspection of taxonomy defined on a non-main table, and inspection of the schema for the existence of a main table. Provide suggested field types or schema structures that allow for a more efficient schema to be generated. Field types may include qualifier, multi-lingual, calculation and may include family or attribute table suggestions as well. Generation of validations and data profiling ensure efficient results.

REFERENCES:
patent: 5717924 (1998-02-01), Kawai
patent: 5963943 (1999-10-01), Cummins et al.
patent: 6618727 (2003-09-01), Wheeler et al.
patent: 2003/0028370 (2003-02-01), Leffert
patent: 2004/0054569 (2004-03-01), Pombo et al.
patent: 2005/0021533 (2005-01-01), Ayachitula et al.

Affiliated with

Also associated with

Rating

Schema modeler for generating an efficient database schema does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Schema modeler for generating an efficient database schema, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Schema modeler for generating an efficient database schema will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4268814