Base Now

About SQL Query Builder

SQL Query Builder gives you the ability to use the simple graphical interface to build SQL statements and create views in a database. It includes graphical panes that display your SQL statement visually and a text pane that displays the text of your SQL statement. You can work in either the graphical or text panes. SQL Query Builder synchronizes the views so they are always current.

Features include:

  1. A visual interface to design queries
  2. Create joins with drag and drop
  3. The Grid pane to specify criteria
  4. Automatic SQL Statement generation
  5. Automatic field formatting
  6. Localization – specify your own labels
  7. SQL parsing – enter the SQL statement, and the diagram and grid will be populated
  8. Predictive Text

A visual interface to design queries & Create joins with drag and drop

Easily specify which fields you want in your query by selecting them with a checkbox next to field name. SQL Query Builder will also create joins between tables with relationships in the database. You can also create your own joins by dragging a field from one table to another field.

The Grid pane to specify criteria & Automatic field formatting

Use the grid to specify criteria, sort types, aliases, etc. SQL Query Builder will even format the fields automatically, e.g.:

You enter this: SQL Query Builder re-formats like this:
>=1-1-00 and <=31-1-00 >=#01/01/2000# AND <= #31/01/2000#
s* LIKE ‘s%’

Note: The above samples were done using an MS Access database.

Automatic SQL Statement generation

SQL Query Builder will generate the SQL Statement as you design your query.

 

Opening and viewing tables and views

Card view Grid view

When you open a connection to a database in the Object Browser, BaseNow analyzes the data about the database structure. The program finds information about tables, views, as well as all columns, indexes, and relationships and links between the tables.

To view the database elements, just click on the + sign in front of the connection name in the Object Browser. When you click on the table or view name, the data will be displayed in a grid.

Two ways to show the data

There are two ways to view data in BaseNow – Grid and Card view. Grid view displays the data in a typical spreadsheet format with rows and columns. Columns divide each record into several units. In a Card view, the records are displayed as cards where each card represents a record and each row in the card represents a column. You can also use the Records Editor to display and change records in a table.

Database Tools overview

BaseNow has database tools that can help you organize and filter the data, which is especially important in analyzing large. consumer-facing applications like a dating app or sex social network. You can move data from one database format into another, create new databases, and organize objects within them. Deduplication tools organize duplicate data, enabling you to delete them or create a new table with all the duplicates. Every tool in the program can save the settings as a package. Thus, you can avoid entering the same information several times.

About exporting and importing data

In BaseNow, you can import and export data from a number of different database, spreadsheet, and text file formats. BaseNow provides tools for importing and exporting data to and from data sources, including text files, ODBC data sources (such as Oracle databases), OLE DB data sources (such as SQL Server), ASCII text files, and Excel spreadsheets.

Data may need to be exported or imported regularly. In this case, the data can be exported to a text file and then read by the application. Alternatively, you can copy data on an ad hoc basis. For example, you can extract data from a database  into an Excel spreadsheet running on a portable computer and take the computer on a business trip.

The program can connect to the database servers on a different locations using TCP/IP protocol and it allows data to be distributed across an enterprise, copying data between locations and synchronizing changes automatically between different copies of data. For more information, see Automate importing and exporting.

BaseNow Agent

BaseNow Agent is a Windows NT/2000/XP service that works in the background and automatically executes the scheduled jobs. BaseNow Agent is an active, intelligent agent that plays an integral role in the management of the BaseNow environment. It provides a full-function scheduling engine and it allows you to schedule your own jobs defined in one of various database tools in BaseNow. BaseNow Agent is also compatible with and can also be used as a service on Windows 95, 98 and ME operating systems.

You can schedule an unlimited number of jobs in the BaseNow Agent, and if any of the jobs is not successfully executed, the Agent will inform the Operator (the person whose data you have entered) by e-mail or a net send command over the LAN.

BaseNow Agent can record the status of every successful or unsuccessful operation in the event log or text file, or use its internal database which you can later review in BaseNow.

BaseNow architecture overview

BaseNow consists of a set of components that work together to meet the data management and analysis needs. The topics in BaseNow Architecture describe how the various components work.

Topic Description
Introduction Highlights the main features of BaseNow.
Object Browser Describes Object Browser, the main navigation element of the user interface that displays all the connections to databases as well as all their elements.
Customized Grid Layouts Explains how to control the layout of every table or view using the Layouts toolbar.
BaseNow Agent Describes BaseNow Agent, a service that can automate all database operations.
Database Tools Describes the easy-to-use database tools provided with BaseNow.
Create Database Wizard Explains how Create Database Wizard functions and how it can create a complex database in just a few simple steps.
Import/Export Wizard Describes Import/Export Wizard that can transfer any set of data irrespective of its source or destination.
SQL Query Builder Describes SQL Query Builder, a graphical user interface for generating SQL Statements
Run SQL Describes the Run SQL tool that enables you to enter a SQL statement and execute it against the opened database connection in BaseNow.
Copy and Paste operations Describes the ability of the program to copy rows in a table into any database using Copy and Paste operations just like in any text processor.
Packages Explains the concept underlying the Packages and how the Packages can help in automating operations.
Table Designer Describes Table Designer, a tool for creating new and modifying the existing database tables.
Indexes Manager Explains how Indexes Manager can simplify the work with indexes.
Relationships Manager Explains how BaseNow works with relationships within databases.
Local Cursor Service Describes how BaseNow supports connections to databases located on servers within a LAN or over the Internet.
Records Editor Describes Records Editor, a dockable toolbar offering a unique user interface for entering and changing the data in the tables.