Click here to Skip to main content
12,065,756 members (36,813 online)
   

Database

 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 0:26
memberBrady Kelly18-Dec-12 0:26 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes18-Dec-12 2:11
memberMycroft Holmes18-Dec-12 2:11 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 2:15
memberBrady Kelly18-Dec-12 2:15 
AnswerRe: On the Naming of Columns for Lookup tables. Pin
PIEBALDconsult18-Dec-12 5:05
memberPIEBALDconsult18-Dec-12 5:05 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 5:12
memberBrady Kelly18-Dec-12 5:12 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
PIEBALDconsult18-Dec-12 5:46
memberPIEBALDconsult18-Dec-12 5:46 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 6:34
memberBrady Kelly18-Dec-12 6:34 
QuestionOn Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 4:02
memberBrady Kelly14-Dec-12 4: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. Pin
Chris Meech14-Dec-12 5:31
memberChris Meech14-Dec-12 5:31 
AnswerRe: On Strategies to Spell Check the Structure of a Database. Pin
Simon_Whale14-Dec-12 5:52
memberSimon_Whale14-Dec-12 5:52 
AnswerRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 14:12
memberMycroft Holmes14-Dec-12 14:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 17:36
memberBrady Kelly14-Dec-12 17:36 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 17:57
memberMycroft Holmes14-Dec-12 17:57 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 18:12
memberBrady Kelly14-Dec-12 18:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 22:13
memberMycroft Holmes14-Dec-12 22:13 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 22:25
memberBrady Kelly14-Dec-12 22:25 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
PIEBALDconsult15-Dec-12 9:49
memberPIEBALDconsult15-Dec-12 9:49 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly15-Dec-12 19:12
memberBrady Kelly15-Dec-12 19:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
PIEBALDconsult18-Dec-12 11:47
memberPIEBALDconsult18-Dec-12 11:47 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly18-Dec-12 12:01
memberBrady Kelly18-Dec-12 12:01 
Questionsending images from a SQL database to a user's email as attachment Pin
Member 946798213-Dec-12 3:16
memberMember 946798213-Dec-12 3:16 
QuestionRe: sending images from a SQL database to a user's email as attachment Pin
Eddy Vluggen13-Dec-12 3:29
memberEddy Vluggen13-Dec-12 3:29 
QuestionODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 6:23
memberGenJerDan12-Dec-12 6:23 
AnswerRe: ODBC Returns Wrong Data Pin
Chris Meech12-Dec-12 6:50
memberChris Meech12-Dec-12 6:50 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 7:20
memberGenJerDan12-Dec-12 7:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web02 | 2.8.160207.1 | Last Updated 7 Feb 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid