background preloader

Databases

Facebook Twitter

Read and write Excel data with PHP. Microsoft Office 2003 for the Microsoft Windows® operating system opened a whole new set of opportunities that non-Microsoft engineers have yet to realize.

Read and write Excel data with PHP

Of course, you had the usual set of new features. But the big new advance was the addition of XML file formats. With Office 2003, you can save your Microsoft Excel spreadsheet as XML and use the file just as you would the binary equivalent.

Python

GAIAN Database. XML. LDBN - Learn DataBase Normalization. The Relational Data Model, Normalisation and effective Database Design. IntroductionWhat is a database?

The Relational Data Model, Normalisation and effective Database Design

Introduction I have been designing and building applications, including the databases used by those applications, for several decades now. I have seen similar problems approached by different designs, and this has given me the opportunity to evaluate the effectiveness of one design over another in providing solutions to those problems. It may not seem obvious to a lot of people, but the design of the database is the heart of any system.

If the design is wrong then the whole application will be wrong, either in effectiveness or performance, or even both.