DATABASE & DATA STRUCTURES


All of the data programs, below, can provide data for an application. Which of these tools should be used for a particular application? Learn more about serving data to your application.

DATABASE PROGRAMS

  • SQL Server
  • MS Access
  • MySQL

DATA TOOLS

  • XML
  • Excel
  • Google Spreadsheet

DATA WORKING

  • Import/Export
  • Warehousing
  • Extracting


  • 1- WEB: Aggregating Demographics & Statistics

    Many large web applications have powerful databases behind the curtain. For instance, two applications were created to gather detailed statistical information and contact data input from dozens of remote locations, greatly facilitating reporting.

    MS Access is a well-known database program that serves as a great tool for developing a website, and testing. However, because of the inherent architecture, Access is often not suitable for most large websites beyond the early development stage. SQL Server and mySQL, which are usually available with most hosting services, are designed to handle large amounts of data. In fact, even off the web, the best choice for large multi-user applications are the server-based databases like SQL Server, mySQL, and Oracle.

  • 2- WEB: A Non-Profit Goes Visual

    A website can serve to solicit funds, volunteers and applicants for non-profit causes. However, to be more effective, visually-attractive statistics and metrics can be derived from the database, showing how effectively funds are used. As the database changes, the graphs and pie charts adjust automatically.

    For another website, a CSS stylesheet thermometer was designed that demonstrated how close an agency was to its goals.

  • 3- DESKTOP: Attendance & Billing by Database

    Running a small day care program requires efficient billing and an economical software solution. This program, created in the heyday of MS Access, takes attendance, creates a printable bill, maintains mailing addresses, and receives payments. VBA mechanized the application.

  • 4- DESKTOP: Database Tracks Fund-raising

    SCRIP is a great fund-raising tool used by schools and non-profits. This school had originally done the entire process by hand, then transferring the hand-written data into Excel. Introducing an MS Access database was the best choice, but not all the volunteers were computer-literate.

    Applying user-friendly design helped coax more people to volunteer. Profit margins were calculated automatically. Accurate inventories protected the product, flagging mistakes before a transaction was forgotten. Barcodes and mag strips were read by readers automatically, and entered into the database, which greatly increased the security and accountability of the system. Information needed by the bookkeeper was organized in minutes instead of the hours originally needed.

    The program had another benefit. Most SCRIP programs only offer the supermarkets, superstores, and gas stations, along with a handful of restaurants. Yet, analysis revealed that high-end restaurants brought greater SCRIP profits. Providing SCRIP would only be profitable if a wide range of restaurants was offered, and the SCRIP immediately available, because dining out tended to be more spontaneous. The program design facilitated offering a variety of SCRIP with little effort.

    The SCRIP program created sales history reports that would be helpful for determining recommended maintenance levels for each vendor in the year cycle.


  • Riverside
  • San Bernardino
  • Rancho Cucamonga
  • Ontario
  • Moreno Valley
  • Chino
  • Redlands
  • Fontana