Top-notch Auditing an Impressive Add-on for Pervasive.SQL

Top-notch Auditing an Impressive Add-on for Pervasive.SQL

f you sell a product that needs a database, you have a business quandary on your hands, namely: “What database should I use? Will my customers have SQL Server? Oracle? DB2?”

Some vendors will choose to create and maintain multiple versions of their products?with all the attendant costs?so they can support multiple platforms. But there is another solution. You can choose to bundle an embedded database engine with your product. This way, regardless of what database the customer has, (including possibly none) you only need to support one version of your product. If you are considering the latter alternative, then you need to take a serious look at Pervasive SQL 8.5 from Pervasive Software.

Retrieving Btrieve
While the name Pervasive is quite catchy, the database engine has a much longer and distinguished history under another name. Pervasive SQL was originally Btrieve?the same Btrieve that was used by Novell to support all its internal needs for NetWare. Btrieve had a well-earned reputation for robustness and stability. I personally used Btrieve on one of the first applications I worked on?an in-house application for a major bank. The database ran consistently without any issues. The one issue that arose was actually due to a disk failure, not the software. The Pervasive database is built on that same Btrieve engine, enhanced over the years with new features as each new version was released.

Pervasive supplies a very interesting mix of technologies. On the one hand, you can program against the database using standard ANSI SQL. This is certainly the route you will want to take with queries and reports. But Pervasive also allows you to go under the hood and bypass SQL totally. Normally you would write some SQL that instructs the database to interpret your request, create an optimized plan, and then execute it. With Pervasive you can use low-level operations to access the data directly. These low-level operations allow you to open the database file using a specified index, find the first matching record according to the specified filter, and modify, insert, or delete the given record as you wish. You can also set options at the engine level regarding transaction isolation levels or even choose not to support transactions at all.

Having these choices means that as a product company, you can hand code the core operations of your product and ensure that performance will be consistent with your needs and stay that way, even without a database administrator available to tune the engine and databases (as in other products) over time.

Figure 1. Audit Viewer: Audit Master makes it easy to see what tables have changed and when.

Pervasive also provides a cache on the client side and the ability to reconnect after a broken connection without losing state information. Last but certainly not least, Pervasive comes in versions for NT and for Linux. Not all databases support those platforms.

Because the product is meant to be used as an embedded database engine, the true test of ease of use is when programming against it. On that side, Pervasive provides a full set of printed documentation (enough to fill a decent sized box) with the product. While exhaustingly complete, it’s also quite usable and helpful and is also available online.

The product also comes with a tool to help you add the installation of the Pervasive engine and database files to your product installation.

As regards to actual programming, Pervasive does support standard ANSI SQL and comes with an OBDC driver. But to program against the database at a lower level, you will have to learn Pervasive’s own API. Fortunately, there are only a dozen functions that you need to learn for most situations.

Auditing Changes
If your product handles sensitive data, you will also want to look at a software add-on by Pervasive called Audit Master. With other database engines, creating an audit log requires hand coding of the necessary triggers. But with Audit Master, you can simply point to a Pervasive database and choose the tables you want audited. Once the log has been configured, it will start up automatically whenever the database engine is started.

The Audit Viewer displays the changes to your database in a very easy to understand format (see Figure 1). It also has a Query Builder, that lets you easily set up the auditor to filter for only the specific changes that interest you (see Figure 2). Additionally, you can set up an alert so that when a particular type of change occurs (for example, when a particular column representing an account status in your database is changed), Audit Master sends an e-mail to whatever address you like. This feature is very useful for spotting possible fraud and taking action when it happens vs. finding out about it after the fact.

Given the recent emphasis in both health care and the financial world on accountability and correctness of data, the availability of the Audit Master tool should be a strong selling point for Pervasive. I wish I had this type of tool with other databases that I use, too.

Figure 2. Query Builder: You can easily configure the audit logs to grab whatever specific information you want.

Achilles in Analytics
Because Pervasive is meant to be an embedded database engine, it lacks some of the features now commonly found in other database environments. Both Oracle and SQL Server come with data warehousing, data mining, and reporting services built in. If you need that type of business intelligence and data analysis, Pervasive isn’t the right product for you. And while Pervasive supports replication, you actually need to buy another product from Pervasive (Data Exchange) to implement it.

Pervasive comes in different flavors. The workstation version has a list price of $25 dollars per seat. The server version has a list price of $845 for six concurrent users. Audit Master is an add-on, with a list price of $495 for six users. Call the company for OEM pricing.

devx-admin

devx-admin

Share the Post:
USA Companies

Top Software Development Companies in USA

Navigating the tech landscape to find the right partner is crucial yet challenging. This article offers a comparative glimpse into the top software development companies

Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India,

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor

USA Companies

Top Software Development Companies in USA

Navigating the tech landscape to find the right partner is crucial yet challenging. This article offers a comparative glimpse into the top software development companies in the USA. Through a

Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in and explore the leaders in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India, and kickstart your journey to

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner for your online project. Your

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the state. A Senate committee meeting

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor supply chain and enhance its

Revolutionized Low-Code

You Should Use Low-Code Platforms for Apps

As the demand for rapid software development increases, low-code platforms have emerged as a popular choice among developers for their ability to build applications with minimal coding. These platforms not

Cybersecurity Strategy

Five Powerful Strategies to Bolster Your Cybersecurity

In today’s increasingly digital landscape, businesses of all sizes must prioritize cyber security measures to defend against potential dangers. Cyber security professionals suggest five simple technological strategies to help companies

Global Layoffs

Tech Layoffs Are Getting Worse Globally

Since the start of 2023, the global technology sector has experienced a significant rise in layoffs, with over 236,000 workers being let go by 1,019 tech firms, as per data

Huawei Electric Dazzle

Huawei Dazzles with Electric Vehicles and Wireless Earbuds

During a prominent unveiling event, Huawei, the Chinese telecommunications powerhouse, kept quiet about its enigmatic new 5G phone and alleged cutting-edge chip development. Instead, Huawei astounded the audience by presenting

Cybersecurity Banking Revolution

Digital Banking Needs Cybersecurity

The banking, financial, and insurance (BFSI) sectors are pioneers in digital transformation, using web applications and application programming interfaces (APIs) to provide seamless services to customers around the world. Rising

FinTech Leadership

Terry Clune’s Fintech Empire

Over the past 30 years, Terry Clune has built a remarkable business empire, with CluneTech at the helm. The CEO and Founder has successfully created eight fintech firms, attracting renowned

The Role Of AI Within A Web Design Agency?

In the digital age, the role of Artificial Intelligence (AI) in web design is rapidly evolving, transitioning from a futuristic concept to practical tools used in design, coding, content writing

Generative AI Revolution

Is Generative AI the Next Internet?

The increasing demand for Generative AI models has led to a surge in its adoption across diverse sectors, with healthcare, automotive, and financial services being among the top beneficiaries. These

Microsoft Laptop

The New Surface Laptop Studio 2 Is Nuts

The Surface Laptop Studio 2 is a dynamic and robust all-in-one laptop designed for creators and professionals alike. It features a 14.4″ touchscreen and a cutting-edge design that is over

5G Innovations

GPU-Accelerated 5G in Japan

NTT DOCOMO, a global telecommunications giant, is set to break new ground in the industry as it prepares to launch a GPU-accelerated 5G network in Japan. This innovative approach will

AI Ethics

AI Journalism: Balancing Integrity and Innovation

An op-ed, produced using Microsoft’s Bing Chat AI software, recently appeared in the St. Louis Post-Dispatch, discussing the potential concerns surrounding the employment of artificial intelligence (AI) in journalism. These

Savings Extravaganza

Big Deal Days Extravaganza

The highly awaited Big Deal Days event for October 2023 is nearly here, scheduled for the 10th and 11th. Similar to the previous year, this autumn sale has already created

Cisco Splunk Deal

Cisco Splunk Deal Sparks Tech Acquisition Frenzy

Cisco’s recent massive purchase of Splunk, an AI-powered cybersecurity firm, for $28 billion signals a potential boost in tech deals after a year of subdued mergers and acquisitions in the

Iran Drone Expansion

Iran’s Jet-Propelled Drone Reshapes Power Balance

Iran has recently unveiled a jet-propelled variant of its Shahed series drone, marking a significant advancement in the nation’s drone technology. The new drone is poised to reshape the regional

Solar Geoengineering

Did the Overshoot Commission Shoot Down Geoengineering?

The Overshoot Commission has recently released a comprehensive report that discusses the controversial topic of Solar Geoengineering, also known as Solar Radiation Modification (SRM). The Commission’s primary objective is to

Remote Learning

Revolutionizing Remote Learning for Success

School districts are preparing to reveal a substantial technological upgrade designed to significantly improve remote learning experiences for both educators and students amid the ongoing pandemic. This major investment, which

Revolutionary SABERS Transforming

SABERS Batteries Transforming Industries

Scientists John Connell and Yi Lin from NASA’s Solid-state Architecture Batteries for Enhanced Rechargeability and Safety (SABERS) project are working on experimental solid-state battery packs that could dramatically change the

Build a Website

How Much Does It Cost to Build a Website?

Are you wondering how much it costs to build a website? The approximated cost is based on several factors, including which add-ons and platforms you choose. For example, a self-hosted