Forum  Xantia Index du Forum Forum Xantia
Pour les amoureux de Xantia
 FAQFAQ   RechercherRechercher   MembresMembres   GroupesGroupes   S’enregistrerS’enregistrer 
 ProfilProfil   Se connecter pour vérifier ses messages privésSe connecter pour vérifier ses messages privés   ConnexionConnexion

Poster un nouveau sujet   Répondre au sujet    Forum Xantia Index du Forum -> Actualité -> Ce que disent les média
Sujet précédent :: Sujet suivant  
Auteur Message

Hors ligne

Inscrit le: 09 Fév 2018
Messages: 140

MessagePosté le: Ven 27 Avr - 09:34 (2018)    Sujet du message: Répondre en citant

The Theory of Meaningless Numbers

Author: Peter A Donovan

August Paul Konerko Jersey , 2007

The Theory Of Meaningless Numbers


Applause Software

Peter A Donovan

What is a meaningless number?

Meaningless numbers are ID and CODE columns which uniquely identify a record in a database table. They were made up by computer programmers, and in traditional programming, they formed the first entry window where you were responsible for remembering that ?means Doctor Ozzie Guillen Jersey , and 

The point?

 meaningless numbers and codes can be totally hidden from users and as a study, I will refer to RoloFlex by Applause Software as a good example where each table is based on a unique meaningless number. [reference: http:www.applausesoftware : free RoloFlex]

What is a meaningful number?

A meaningful number is those database records that are referred to commonly by number such as PO #4067, Sales Order Ozzie Guillen Jersey ,2# and Speeding Ticket #352-4635A. These numbers exist on paper and are the primary way of referring to a record of this type. When you go to look up my speeding ticket, you might indeed look it up under my name also, but when a payment is received [good luck] you want to be able to enter the printed number 352-4635A and quickly locate and apply payment before my check bounces.

Can a meaningful and meaningless number co-exist?

Yes. Numeric meaningless numbers are the foundation of unique identifiers of each record Michael Jordan Jersey , and a meaningful number can co-exist as [both] uniquely indexed [findable] columns in the same data table.

There芒鈧劉s a space here while the programmers hold their heads.

Let芒鈧劉s say you are a database programmer and know that numbers rather than a string which varies in length [throwing off the sort order completely] should be the foundation of the database record [for speed and relationship purposes only], you can program your unique (meaningless) ID column of speeding tickets, and also have a unique (meaningful) column which is ascii [mixed numbers and letters] which is used for finding it.

Why not make the key column a automatic increment number for relation purposes alongside a humanly enterable column consisting of alpha-numeric characters? Hands please? How many programmers have written 200 lines of code to auto-increment ? The role of the meaningless number is to get auto-incremented in 1 line of code Melky Cabrera Jersey , being totally hidden from the user, and the foundation of the relationship to its parent database table. The role of the Speeding Ticket number is to humanly find a record more easily than 12342345345565.

Table Layout Proposed:


Column: Element: Type: Length: Index: Relates To:

1 ID Numeric 16.0 1 (unique)

2 TicketNo Ascii 20 2 (unique)

3 VIN_ID Numeric 10.0 3 VIN.ID Not VIN (Ascii Field)

4 SSN_ID Numeric 10.0 4 SSN.ID Not SSN (Ascii Field)


Column: Element: Type: Length: Index: Relates To:

1 ID Numeric 10.0 1 (unique)

2 VIN Ascii 20 2 (unique)


Column: Element: Type: Length: Index: Relates To:

1 ID Numeric 10.0 1 (unique)

2 SSN Ascii 11 2 (unique)

This structure makes use of meaningless numbers and meaningful numbers side by side, each fulfilling their job.

Hopefully there is a programmer slapping hisher head here like the V-8 commercial.

The ROLE of a meaningless number:

Let芒鈧劉s face it. Meaningless numbers are here to stay. Everybodys got one Luke Appling Jersey , but programmers are still stuck on what to do with them. HIDE THEM! In a relational database model, where the child is related to its parent by the ID, the value will automatically drop down to the child upon a successful save Luis Aparicio Jersey , making display of this number absolutely unnecessary. I should point out that many good programming firms are based on 

s meaningful or meaningless. On a part number, why not both? To programmers Jose Abreu Jersey , here

BEIJING, Aug. 16 (Xinhua) -- Beijing will launch a crackdown on scalpers that camp out at the city's hospitals to book and resell appointments, .

Revenir en haut

MessagePosté le: Ven 27 Avr - 09:34 (2018)    Sujet du message: Publicité

PublicitéSupprimer les publicités ?
Revenir en haut
Montrer les messages depuis:   
Poster un nouveau sujet   Répondre au sujet    Forum Xantia Index du Forum -> Actualité -> Ce que disent les média Toutes les heures sont au format GMT + 1 Heure
Page 1 sur 1

Sauter vers:  

Index | créer un forum | Forum gratuit d’entraide | Annuaire des forums gratuits | Signaler une violation | Conditions générales d'utilisation
Powered by phpBB © 2001, 2018 phpBB Group
Traduction par :