ADMIN - Explore the new world of system administration! Special introductory offer! Order by September 30th to save 10% off the regular subscription price! Each issue delivers technical solutions to the real-world problems you face every day. Learn the latest techniques for better:
network security
system management
troubleshooting
performance tuning
virtualization
cloud computing
on Windows, Linux, Solaris, and popular varieties of Unix.
If you need a quick and easy solution, try building your own database application in OpenOffice.org 2.0.
OpenOffice.org 2.0 features a new database module based on HyperSonic SQL, a Java-based relational database engine. You can use OOo Base to build anything from a simple recipe collection to a powerful asset management solution. Base is a powerful tool, but for those not familiar with its features, developing even a simple database solution can be a bit overwhelming. This article guides you through the steps of setting up a simple business database application using Base. Planning the Database A Relational Database Management System (RDBMS) typically consists of four parts: • tables • queries • forms • reports Data within a database is stored in tables. Queries are used to extract, view, and manipulate the data. Que- ries can draw together data from many tables, and If you need a quick and easy solution, try building your own database application in OpenOffice.org 2.0. BY DMITRI POPOV that data is then available for forms and reports. Forms allow you to view and edit the data in a table. Think of a form as a GUI for the database. Reports are used to produce formated output from the table, usually for printing.
Watch our free Video Archive from Apachecon US 2009. Archive provided by The Apache Foundation, COLLABNET, and Linux Pro Magazine
Drawing internationally renowned thought-leaders, contributors, and organizations in the Open Source community, ApacheCon offers insight into the culture and community that develops and shepherds industry-leading Open Source projects, including Apache HTTP Server – the world's most popular Web server software for more than 10 years.
Comments