Applied Information Technologies, Inc. (AIT) has a core competency in the area of interactive database websites. Basic services include:

• Database Website Design, Development, Implementation & Consulting
• Technical Training & Support for Web/RDBMS
• SQLweb^TM Software,

Why use AIT :

• Experience: AIT is a Pioneer in database website technology. The company was one of the first to provide RDBMS connectivity to the web. We combined our 10 + years of Client Server and database development experience with the Internet to produce SQLweb^TM, the first HTML interface to SQL Relational Databases.
• Tested By Time: We have successfully implemented the RDBMS/Web technology on websites since the early days of the Web. We continually improve our process to incorporate more functionality as new tested technologies become available for use with the web.
• Full Range of Help: The help available from AIT is a full range

From: providing full service design, development and implementation
To: enabling self sufficiency for your operation.

We have a full suite of services that can help you find the right mix of Development, Consulting and Training to fit your needs.

• Integration With the Latest Technology
  AIT has developed the proven capability to provide you with such features as:
  • Web Database connectivity to your Email Server
  • Web Database connectivity to Fax Server
  • Web Database/Secure Sockets for Secure Transactions
  • SQLweb interactivity with JAVA Applets
  • JavaScript and ActiveX applications
  • WebSite Designer On-Line^TM, an application to design, implement and maintain your own website over the web, without learning costly and complicated software.
• Reduce Costs by Cutting Production Time in Half: AIT and the SQLweb technology can produce Interactive Database Websites in half the time that it takes using other methods, such as "C" Programming Language, Perl Scripting, and PL/SQL. SQLweb technology involves 50% less effort and keystrokes, and is much easier to work with than these other methods.
• Increase Your Staff's Productivity by Cutting Learning Curve in Half: Programmers learn SQLweb development techniques quickly because SQLweb uses imbedded SQL statements within the HTML to interact with the underlying database. For example, an Oracle programmer using SQLweb^TM is able to accomplish in one hour what it takes all day to create using PL/SQL… a considerable improvement in productivity.
• Lower Maintenance Costs: The simple SQLweb^TM code and structure lets you easily maintain and modify the system. Programmers find it much easier to look at the code and figure out what is happening in order to make quick changes since the HTML and SQL tags are in the same source document.

WebSite Development and Consulting Services

AIT is a skilled Technical Partner to help you build your interactive website and integrate your business with the Internet. Listed below are some of the types of services and expertise that AIT can bring to your projects.

• Strategy and Design Session: ( 8 Hours ) AIT Senior Database Architects and Web Designers will facilitate a Strategy and Design Session to map out your website using our proven design methodology. From this session we:
  • Specify the underlying database tables and the integration of hardware and software components needed to bring it all together.
  • Develop data modeling and story boarding to create the blue print for the building of the system.
  • Create an Entity Relationship Diagram (ERD) to show how the pieces fit together.
  • Estimate a budget for the interactive database website based on the specifications that are produced from the Strategy and Design session.

• Rapid Prototyping: AIT database consultants use SQLweb^TM programming and proven templates with modular construction to rapidly build a working prototype of your interactive database website. This allows you to quickly get a first cut of the system into the hands of the users who are the functional experts, best at providing the critical feedback needed for quality assurance and specifying improvements to the system.

• 3 Stage Deployment: The website construction is set up in three staging areas on one or more web servers:
  1. The Development Site is where web modules are first created and tested by developers.
  2. The Integration Site is where the modules are brought together for testing and integration before being promoted to the production website.
  3. The Production WebSite is the working website, the "Live System," available to all who have authorized access.
• Version Control: During construction, the system requires that all web modules get electronically signed out by developers, which prevents overwriting and coordination problems with other developers. As each module is tested and integrated it is promoted to the next staging area. The 3 stage deployment integrates with the ECR System described below.
  
  • Engineering Change Requests: As your project progresses, changes and additions are managed with the ECR System (Engineering Change Request System). ECR's are issued to the development team for each change required for a module (webpage/data table). These requests can then be easily tracked and managed. The ECR system also employs version control and back ups of previous versions for accurate project management, quality assurance, and safeguarding of files. For large projects, an ECR webpage (with ECR database) will be installed on your website to let you interact with the development team and monitor ECR's.

  Database Website Training and Support

  • Database Website Workshop: This workshop allows your staff to get accelerated hands on experience with database website development. An AIT Senior Database Consultant, skilled in RDBMS and SQLweb^TM Development, will provide training in a lecture and lab format. The training can be provided at AIT's training facility or at your location on site (with Internet / Intranet web server and database server access). The most effective workshops are designed to work with your actual database and can often produce tangible deliverables for your project. This method has been highly effective for technical people who need to be jump started on a project, achieving maximum productivity in the shortest period of time. Prerequisites for this course are knowledge of HTML and experience with SQL (Structured Query Language).
  • Technical Support Technical Support is available for all your database website needs including:
    • Database Administration (installation and maintenance)
    • UNIX Administration
    • Back End RDBMS design and development. (table creation, enhancements, and maintenance)
    • SQLweb^TM development
    • Integration of legacy systems with your Database Website
    • "Back Office" development to allow you to maintain your site and process actions "behind the scenes"

  Internet Marketing Services:

  AIT provides Internet Marketing services for the promotion of your organization and website on the Internet to increase traffic on your website and expand your customer/member base. Services include:

  • WebSite Registration with major search engines and specially targeted industry related websites that will list your organization with a description along with the URL for your home page.
  • Wire services for press releases to API and UPI are also available for nation wide and international coverage, targeting major newspapers and or trade magazines by industry segment. Traditional marketing through print and broadcast media are also available.

  AIT Internet Services - Database WebSite Hosting

  AIT Internet Services provides website hosting ranging from a virtual domain on a shared server (with 25,000 hits per day) to a large dedicated server with unlimited bandwidth. Relational Databases available include Just Logic^TM, Sybase^TM and Oracle^TM RDBMS. AIT can help you build your database website on your Internet/ IntraNet server or on one of AIT's Internet hosts.

  • Virtual Domain Hosting includes a relational database license and the SQLweb^TM Software starting at $149 per month plus set up fees.
  • Private Domain Hosting includes a dedicated server with high volume bandwidth; ranging from a fractional T1 to a dedicated T1 Internet connection.
    Prices vary based on bandwidth and storage requirements

  SQLweb^TM Software

  The SQLweb^TM software is an HTML interface for your database that makes your website interact on-line with an underlying SQL RDBMS database, like Oracle^TM, Sybase^TM, and Just Logic^TM. The development process uses standard HTML and SQL tags to rapidly and accurately produce a production environment which saves time and money. SQLweb provides:

  • Code templates that allow for fast modular construction of websites and easy replication of similar functionality.
  • SQLweb development involves 60% less keystrokes and development time when compared with methods using C Code , Perl Scripting and PL/SQL.

  The result is a truly dynamic database website that allows on-line database inserts, updates, deletes, queries and execution of stored database procedures. It changes the appearance of its pages, takes orders, places orders, sends messages and interacts with legacy systems and networks.

  Database Website Expertise

  AIT specializes in database website development, training and hosting, working with Oracle Webserver, CGI Scripting, and the new SQLweb^TM technology. AIT has worked with both large and small database website projects, ranging from Oracle to the Just Logic RDBMS.

  AIT designed and implemented the database websites described below. Demonstrations of some of these websites, created by AIT, can be seen on the world wide web at www.sqlweb.com or at the URL's listed below.

  Interactive Catalogue with Shopping Cart:URL: www.illumine.com

  AIT developed this database driven catalog for an on-line Oracle bookstore, but the data model could fit any on-line catalog requirements. The "Categories" appearing on the home page are dynamically generated from the database, as are the book titles and graphics that appear on the pages that follow. Anyone on the web can order books from the site, which automatically sends email notification to the sales department. The website store owner has password protected access to the administrative area of the site where they can review and maintain the order database and completely maintain the on-line catalog through private interactive web pages.

  Equipment Parts, On-Line Database. URL: www.offhighwayparts.com

  This large Oracle database website is used as a global parts distribution service, bringing buyers and sellers together on an international scale for the off highway equipment industry; serving the Mining, Forestry, Agriculture and Construction industries. Hard to find parts and components are located with easy to use queries from the huge inventory database of over $7,000,000.00 worth of parts. This database architecture will be expanded to other industry segments involving the brokering of parts and equipment.

  Global Information Exchange: An On-line Association for Members Only

  AIT designed and built a private website involving sensitive information for a large industrial association. This large Oracle database website allows association members to enter the Information Exchange where the latest research and news stories for that industry are collected and archived for easy retrieval. Private forums or newsgroups with selected members and public forums open to all members allow members to share information about their industry and their specialty. The Scheduling module allows association members to see all events, seminars, and conferences related to their field on a calendar. Approved members can enter their own news stories, research, and events on-line, making administration of the site easy and affordable.

  Lead Management System: URL : A private, password protected domain not accessible by the general public. AIT developed this Oracle driven site to allow a large company track its sales leads from anywhere in the world. Both field representatives and telesales representatives can access the system to view new leads to accept or reject them and to update the status on existing leads. Supervisors can move leads different sales representatives. Both sales representatives and supervisors have a full range of reports available.