Products

Object Relational Mapper

The Object Relational Mapper takes a well designed database and generates all the middle tier objects required to make a working application. That means that it generates stored procedures for create, read, update, delete and search, then creates the objects that use these stored procedures. the ORM will also generate lookups for related data. If you have a database model that details students and classes, the ORM will automaticaly give you student object that takes a class identifier as a paramter and give you back a list of students associated with that class. Microsoft's Model View Controller (MVC) technology will automatically generate web forms based on these objects meaning that we can generate about 80% of a new application in a matter of a few minutes. Most of what is left to do is simply making it pretty.

Information Integrator

The Information Integrator takes any kind of file you have a driver for, checks its data against a list you define for consistency and range, transforms it to your specification and loads it into your database. For a moderate sized table, defining the structure takes 10 to 15 minutes and once it is done, it is simply done. All you have to do going forward is click the button to check and import your data. Almost all of us have to import data from disparate sources. Let's say that you have a file coming in that lists a structure as a single family home, designated "S", or a Duplex, designated "D" or an Apartment designated "A" in a column called Residence. Your database needs "SFH", "DUP" or "APT" in a column called ResType. These are known as discrete values, as opposed to continuous values. The Information Integrator will not only transform your values on the fly, and place them in the proper table in your database with the proper field names, but validate your data and let you know if the source contains things that are not defined. Continuous values are those like height and weight. One of our clients has a data entry person who, every now and again, enters 65.5 inches as 655 inches. We all know she is busy, but we also know that outside a movie theater there are no 50 foot tall women. Information Integrator will catch this typing mistake and alert you before it gets into your database.

Business Information Framework

The Business Information Framework is both a database and middle tier full of generic business entities and objects that get a project jump started with several months or years of development accomplished on the very first day of work. All business have employees and clients and invoices and structures. These entites are rolled up into simliar objects in the middle tier with the use of .NET generics so that they give a concrete object model on which to build your individual business logic. The framework comes with its own security built in so that information can only be added modified or destroyed through stored procedures, giving unprecedented security. The middle tier 'objectizes' these entities into collections of objects making them ready to be consumed by your custom built presentation layer. The advantage of this seeming complication is that when a base entity changes, say a suffix is added, like MFA or PhD. to a name, that change only has to be made in one place to propagate upward through the middle tier to the presentation layer. Another advantage is making your information database agnostic. If someone comes up with the greatest database engine ever, you can port your new application over to it with a minimal rewriting of code in the middle tier. There is also a Graphical User Interface (GUI) or presentation layer component to the framework. We have both Web and Windows forms pre-designed and built for scrolling through your database records, adding, modifying and deleting them as well. This makes the development of your applications literally drag and drop. The benefit to you is that you have a robust, scalable application in record time, saving you money. When you contact us, ask about how the database, middle tier(s) and presentation layers interact.