|
KB Article |
|
|
Mike Prestwood
|
1. ANSI
ANSI is an acronym for American National Standards Institute.
18 years ago, and updated 14 years ago
|
 Definition
 10398 Hits
|
Mike Prestwood
|
2. ASCII
ASCII is an acronym for American Standard Code for Information Interchange. The ASCII set consists of 7-bit codes that represent 128 standard characters, including letters, numbers, and symbols. The first 128 characters in the ASCII set, the extended ASCII set, and the ANSI set are the same.
18 years ago, and updated 14 years ago
|
 Definition
 10053 Hits
|
Assignment help
|
3. Assignment help
https://www.ozassignments.com
(4 Comments
, last by Bodymassage. )
|
 Link
 762 Hits
|
Mike Prestwood
|
4. BDE
BDE is an acronym for Borland Database Engine (previously referred to as IDAPI and before that it was ODAPI).
18 years ago, and updated 13 years ago
|
 Definition
 12604 Hits
|
Mike Prestwood
|
5. Common Table Structures
Reference of common table structures
|
 KB Post
 8770 Hits
|
Scott Wehrly
|
6. Concatenation of VARCHAR fields yields NULL
When you have a concatenation of two or more CHAR or VARCHAR fields in a SELECT statement, and one of the fields is NULL, the resulting value will be NULL.
(1 Comments
)
|
 KB Post
 8852 Hits
|
Jeffrey K. Tyzzer
|
7. Corporate Database Administration
Corporate database admin standard first published by Prestwood Software in 1996.
19 years ago, and updated 14 years ago
|
 Article
 20042 Hits
|
Jeffrey K. Tyzzer
|
8. Data Element Naming Standard
This paper articulates the standard for naming data elements (entity attributes).
19 years ago, and updated 14 years ago
(3 Comments
)
|
 Article
 34783 Hits
|
Joshua Delahunty
|
9. Data Migration, Paradox to SQL Server
some tips for data migration, especially with bitfield, or "logical" field types.
15 years ago, and updated 11 years ago
|
 KB Post
 15158 Hits
|
Jeffrey K. Tyzzer
|
10. Data Normalization - The Normal Forms
by Jeffrey K. Tyzzer. In 1970, Dr. E.F. Codd's seminal paper "A Relational Model for Large Shared Databanks" was published in Communications of the ACM. This paper introduced the topic of data normalization, so-named because, at the time, President Nixon was normalizing relations with China.
Data normalization is a technique used during logical data modeling to ensure that there is only one way to know a fact, by removing all structures that provide more than one way to know the same fact as represented in a database relation (table). The goal of normalization is to control and eliminate redundancy, and mitigate the effects of modification anomalies -- which are generally insertion and deletion anomalies. (Insertion anomalies occur when the storage of information about one attribute requires additional information about a second attribute. Deletion anomalies occur when the deletion of one fact results in the loss of a second fact).
Normalization There are six generally recognized normal forms of a relation: first normal form, second normal form, third normal form, Boyce/Codd normal form, fourth normal form, and fifth normal form, also called projection/join normal form. Other normal forms (e.g., Domain/Key) exist but will not be discussed here. The normal forms are hierarchical, i.e., each normal form builds upon its predecessor. Although many people consider a relation to be normalized only when it is in third normal form, technically speaking, a relation in only first normal form can be considered...
19 years ago, and updated 13 years ago
|
 Article
 13217 Hits
|
Wes Peterson
|
12. Databases: Which are Best?
Which databases Prestwood Software prefers - and why.
15 years ago, and updated 13 years ago
(1 Entries
, last by mprestwood )
|
 Blog
 14535 Hits
|
Mike Prestwood
|
14. DBMonster.com
http://www.dbmonster.com/
|
 Link
 6267 Hits
|
Mike Prestwood
|
15. Drop Index
Drop an index with the DROP INDEX statement.
|
 Flashcard
 5513 Hits
|
Wes Peterson
|
16. ElevateDb - The New Kid on the DB Block
For years, Elevate Software has provided the elegant, fast, and stable DBISAM database. They're recently released ElevateDB, an amazing follow-up.
|
 News
 9963 Hits
|
Mike Prestwood
|
17. Finding Duplicate Values Using SQL
To find duplicate values in the same field, you need to use an alias with the same table twice.
19 years ago, and updated 13 years ago
|
 KB Post
 8071 Hits
|
Mike Prestwood
|
18. Learn the Three Normal Forms in One Sentence
The three normal forms can be summed up in the following phrase: All the fields of a table should relate to the key, the whole key, and nothing but the key.
(2 Comments
, last by mprestwood )
|
 Tip
 15676 Hits
|
Mike Prestwood
|
19. Master Table
A master table in a multitable relationship is the primary table. For every record in the master table, there can be many records in the detail table. If you are only dealing with one table, then it is the master table. A detail table in a multitable relationship is the table whose records are subordinate to those of the master table. A detail table is also called a slave table, a child table, or a many table.
(2 Comments
, last by Timmy.F )
|
 Definition
 15756 Hits
|
Mike Prestwood
|
20. Naming Fields: Choose a Context Name
When naming fields/columns in a table, use ONE name for the data in the field. For example, although states are called provinces and other names in other coutries, use one or the other in the database but not both. Use CompanyState, avoid CompanyStateProvince. Use labels in your website or program to switch context.
|
 Tip
 10601 Hits
|
Mike Prestwood
|
21. Not In SQL Select Query
The following selects all the records in Table1 where IDField is not in Table2.
|
 Code
 10727 Hits
|
Wes Peterson
|
22. ODBMS or RDBS?
For several years now, Object Relational databases have intrigued many developers, myself included. Most of us also rely on more traditional RDBMS systems. Well, a debate is raging, and you're invited to join.
14 years ago, and updated 14 years ago
|
 Blog
 8801 Hits
|
Mike Prestwood
|
23. Optimistic Locking
A locking mechanism that allows other users to edit a record that is currently being edited. Essentially, last in wins or edits are discarded usually with an error.
|
 Definition
 9574 Hits
|
pande.dhiraj
|
24. ORA-00900: invalid SQL statement
The ORA-00900 error displays automatically when erp is running properly but may be caused by a constraint violation.
14 years ago, and updated 11 years ago
|
 Error
 15369 Hits
|
Wes Peterson
|
25. Oracle Berkely DB XML
http://www.oracle.com/database/berkeley-db/xml/index.html
14 years ago, and updated 14 years ago
|
 Download
 14152 Hits
|
swawsji
|
26. oracle silent mode installation using response file
You can automate the installation and configuration of Oracle software, either fully or partially, by specifying a response file when you start the Oracle Universal Installer.
13 years ago, and updated 13 years ago
|
 KB Post
 11021 Hits
|
Mike Prestwood
|
27. Pessimistic Locking
A locking mechanism that prevents other users from entering edit mode on a record that is currently locked.
|
 Definition
 9835 Hits
|
Mike Prestwood
|
28. Reverse sort order in a select
Is there a way to reverse order a select statement?
|
 FAQ
 12338 Hits
|
Joshua Delahunty
|
29. SQL Server 2005 Database Diagram caveat
Tip about renaming tables in SQL Server 2005
15 years ago, and updated 15 years ago
|
 KB Post
 7714 Hits
|
Joshua Delahunty
|
30. SQL Server 2005 Database Diagram tool
Tips on use of SQL Server 2005 Database Diagramming Tool
15 years ago, and updated 15 years ago
|
 KB Post
 7718 Hits
|
Joshua Delahunty
|
31. SQL Server Express
Tips on setup of SQL Server Express
15 years ago, and updated 15 years ago
|
 KB Post
 7474 Hits
|
Mike Prestwood
|
32. Standard Delimited Format (SDF)
SDF is an acronym for standard delimited format. An SDF is a text file formatted in a particular style. Each field is enclosed in quotation marks and separated by a comma. Each line ends with a carriage return and a linefeed.
18 years ago, and updated 14 years ago
|
 Definition
 9626 Hits
|
Wes Peterson
|
33. Tab-delimited format (TDF)
In a Tab-delimited format (TDF) file, each field is delimited by a tab character. Each record is delimited with a carriage return and line feed. TDF has the advantages of being immune to commas and quotation marks within the data itself.
14 years ago, and updated 14 years ago
|
 Definition
 11800 Hits
|