온라인 및 원격으로 비즈니스 데이터베이스에 액세스하는 방법

Databases and the forms generated from them are used daily in many businesses and corporate work. For both organizational and practical reasons, it is increasingly useful to access them alternately online or remotely, as well as directly.

Databases: A Layered Structure

A relational database application is generally made up of three layers. These tiers are the data, the interface and the logic.

  1. Data consists of tables in which data is stored.
  2. Interfaces consist of forms through which your users interact with the data in the tables.
  3. Logic is the code which allows you to automate tasks and manage both data and interface objects.

Tools to Manage Business Databases

For over 30 years, management applications have been developed using 4GL (4th Generation Language) software development kits such as PowerBuilder, WinDev, FoxPro, Uniface, Visual Basic or Delphi.

These tools make it possible to generate Windows applications, installing them on each user PC. That application is what communicates with the company’s centralized data bank. That database can be hosted on company premises or online.

SQL to Manage Databases Online

The Database Management System (DBMS) could be Oracle, MS-SQL, My-SQL, PHP, .net, SQL Server, SQL Azure… The tasks programmed in these classical environments use SQL queries to view, process and transfer information between the graphical app on the user’s workstation and the database on the server which has as primary function the centralization of company data.

Data could also be kept on an IBM proprietary computer, in which case the graphical application would be an IBM terminal emulator (3250 or 3270).

An aside about bringing MS Access databases online

  • Access 2010 and Access Services are no longer in use since 2010 Web Application Service has been removed
  • Access, in its original build, was ONLY viable in a Windows environment. It was meant to be run on a wired LAN and not made to work over Internet. Thus, both Access web databases (Access 2010) and Access web apps (Access 2013), were attempts to add interface objects that would make it possible to manipulate databases on the Web. Hence SharePoint lists (2010 version) and SQL Azure tables (2013 version) which are accessible via the internet. Microsoft clearly stopped its “webification” when it abandoned those paths and deleted them from its servers.
  • If you still have an Access database and wish to access it online, the place to start is by web-enabling the front-end (the application used to access the information in the database). This needs to be done so that the tables are in the “back-end” and the forms, queries, reports, etc. are in the “front-end” and accessible to all. Once that is done, whether you keep the back end on servers on your company’s premises or move everything into the cloud is up to you.

“Front-End” of a Business Database

In a previous article I wrote about the pros and cons of web-enabling apps versus re-writing them for the web. Aside from potential instabilities and the time-consuming aspect of reengineering stable applications, an important point was the risk of ending up with a rather static front-end while most people are now so used to intuitive and fluid interfaces. This can also apply here.

Of course, when you’ve heavily invested in software, it can be difficult to let go of it, not just because it can mean new training investments. The question of migrating a database or changing its front-end can bring up similar issues, still maybe a half-way solution is a better solution in cases where one aspect of the database need not be touched.

“Client-Server” Architecture of a Database

With centralized applications, the Data Server can also act as an Application Server. Nevertheless, most businesses prefer to opt for a “client-server” architecture. Indeed, that enables them to share the load by using the local memory and power for all the “front-end” data treatment, leaving the central server to only handle the back-office tasks. In this configuration, each PC generates a Graphical User Interface (GUI) to enable the data to be processes according to each user’s requirements.

Limitations of a Direct Client-Server Database Structure

This “client-server” structure is the most commonly used method for business administration applications (payroll, accounting, stocks, billing…) but its limitations are beginning to show. Indeed, the client part being by definition Windows based, it cannot be installed on Android tablets or smartphones. Moreover, it forces companies to accordingly manage the PC parks they deploy, with individual updates of each workstation for every new version of the client-side software installed on each PC.

Increased need to Access Databases Remotely

Remote work and mobility are becoming a widely accepted expectation in more and more businesses as well as among employees. Meanwhile, solutions such as Microsoft RDS and Citrix remain complex and costly. They are reserved for large corporations since SMBs seldom have the means to implement them.

Simple Solution to Remotely Access Databases Online

The TSplus Remote Access solution in its Web Access form is ideal to enable all businesses, whatever their size, to address this issue. Indeed, by installing TSplus Remote Access on the one master PC or server where the database front-end client is hosted, you have, in a few minutes, an operational architecture. The advantage is that the way the existing applications are used goes unchanged. The addition of TSplus software leaves it intact, but for the fact you will from then on be able to access your business database online, whether locally or remotely.

Virtually no Change to Access your Business Database Online and Remotely

TSplus Remote Access an amazing way to automatically turn your current field proven IT infrastructure into the most easy to use Web portal-based remote access solution. For your remote staff and users and so you can increase work from home, it is the one truly simple, easily installed and reasonably priced solution.

Lagging in Standard Access to Business Databases

One thing you’ll be interested to know is that TSplus can improve the performance of your Accounting or Retail Access database by making it over ten times faster. Indeed, as the number of users and the size of the file increases, the flat-file structure of the Access database means accessing it directly and manipulating the data will take longer and longer. This slowdown in use of the application is unfortunately not linear but rather, the effect compounds, especially when the file reaches 100MB and more in size.

Speedy Remote Access to Business Databases with TSplus

This is where TSplus Remote Access shines. By turning the host where the Access database is stored, in-house tests on a datafile of 1GB have returned spectacular speed improvements. With a conventional set-up with the data on the server and the accounting application running on the user workstation, a particular report was processed in 8 minutes. Whereas, with the same datafile stored on a Remote Access server, the process was reduced to only about 40 seconds.

Safe Databases Thanks to Remote Access by TSplus

One final perk that is worth noting is file integrity. Clients came to us with problems concerning corrupt data. After switching over to TSplus technology, the performance was not only significantly improved but the database also showed no more signs of corruption issues. So be it for stability or speed, TSplus is at hand and the team is available for advice and help.

To find out more about TSplus Remote Access and our other software, visit our website and TSplus 제품의 15일 평가판 다운로드.

공유하다:
페이스북
트위터
링크드인

TSplus 알아보기

IT 전문가를 위한 간단하고 강력하며 경제적인 Remote Access 솔루션.

영업팀에 문의해야 합니까?

Contact 지역 영업 팀에 도움을 요청하세요.
TSplus 글로벌팀

최신 News 및 기사

500,000개 이상의 기업에 가입하세요

우리는 평가 훌륭한
별 다섯개 녹색 아이콘

5점 만점에 4.8점

TSplus
4.8
106 리뷰 기준
자레드 E.
15:19 6월 22일 10일
여러 사용자를 Windows 서버에 연결하기 위한 훌륭한 제품입니다. Windows Server 라이선스를 구매하는 것보다 훨씬 저렴합니다.
JOEL(조엘 도미닉 D.A.
12:22 09 6월 22일
Windows 앱에 대한 원격 액세스를 위한 최고의 저비용 솔루션입니다.
비날 싱 H.
12:38 06 6월 22일
최근에 우리는 범용 인쇄에 문제가 있었고 TSPLUS 팀이 적시에 문제를 해결했다고 말해야 합니다. TSPLUS 팀원이 원격 로그인을 하는 것도 보고 놀랐습니다.... 우리가 그들의 제품을 구입할 때 무엇을 기대해야 하는지 확신할 수 없었기 때문에 내 문제를 지원하기 위해. 지금까지 나는 그들의 지원에 만족하며 가까운 장래에 또 다른 TSPLUS 구독을 구매할 계획입니다.더 읽기
태양 지.
07:56 03 5월 22일
귀하의 제품과 지원 팀은 훌륭합니다. 많은 도움이 됩니다. 감사합니다.
유진 T.
12:35 4월 22일 28일
TSplus 지원은 아주 좋은 일을 합니다. 그들은 내가 필요하면 항상 나를 도와줍니다.
모하메드 J.
10:21 4월 22일 22일
웹 액세스에 문제가 있었습니다 .. TSPlus 지원이 협력하여 이 문제가 해결되었는지 확인했습니다 .. TSPlus와 협력하게 되어 기쁩니다
아이콘 각도 아이콘 바 아이콘 타임즈