Click here to Skip to main content
       

Database

 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly17-Dec-12 23:26 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberMycroft Holmes18-Dec-12 1:11 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly18-Dec-12 1:15 
AnswerRe: On the Naming of Columns for Lookup tables. PinmemberPIEBALDconsult18-Dec-12 4:05 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly18-Dec-12 4:12 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberPIEBALDconsult18-Dec-12 4:46 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly18-Dec-12 5:34 
QuestionOn Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 3:02 
This week I very quickly put together a simply database of some fifty tables and about three hundred columns all told, with every table having at least one foreign key. Then I noticed some spelling mistakes and or typos in some table and column names, and this inspired me to develop a tool that can perform a spelling check on all identifiers used in all database objects.
 
This is no mean feat. My rought draft strategy is to
 
1. Build a list of all identifiers in the database. To start with, I will limit this to table, column, view, and key and index names.
2. Use patterns and heuristics to split identifiers into word parts and ignore parts such as 'FK_' etc.
3. Check spellings of split identifiers, and those not split, and mark possible errors.
4. Where an error is e.g. found and corrected in a column name, correct all other occurrences of that column name in the DB.
 
I know none of these is simple, but I think this could make an interesting hobby project and an article or two, if I start simple and incrementally make the app more intelligent.
 
What warnings, criticisms, suggestions, or general comments do you have?
JokeRe: On Strategies to Spell Check the Structure of a Database. PinmemberChris Meech14-Dec-12 4:31 
AnswerRe: On Strategies to Spell Check the Structure of a Database. PinmemberSimon_Whale14-Dec-12 4:52 
AnswerRe: On Strategies to Spell Check the Structure of a Database. PinmemberMycroft Holmes14-Dec-12 13:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 16:36 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberMycroft Holmes14-Dec-12 16:57 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 17:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberMycroft Holmes14-Dec-12 21:13 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 21:25 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberPIEBALDconsult15-Dec-12 8:49 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly15-Dec-12 18:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberPIEBALDconsult18-Dec-12 10:47 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly18-Dec-12 11:01 
Questionsending images from a SQL database to a user's email as attachment PinmemberMember 946798213-Dec-12 2:16 
QuestionRe: sending images from a SQL database to a user's email as attachment PinmemberEddy Vluggen13-Dec-12 2:29 
QuestionODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 5:23 
AnswerRe: ODBC Returns Wrong Data PinmemberChris Meech12-Dec-12 5:50 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 6:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140922.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid