Welcome!

AJAX & REA Authors: Liz McMillan, Elizabeth White, David H Deans, Pat Romanski, Scott Hirsch

Related Topics: SOA & WOA, Java, XML, .NET, AJAX & REA

SOA & WOA: Blog Post

Intuit QuickBase: Best Practices for Application Clusters

Effectively sharing data across applications

Data Sharing Features
Detailed below are three main ways that applications share data. The purpose of this article is not to detail the technical configuration of these features, but to explain their intended use, benefits, and risks.

  1. Cross Application Relationships (Cross App)

    Cross Apps allow a table in one QuickBase application to be shared to another application. The shared table, in effect, acts like a table in the shared-to application, even though it actually resides in another application. This has the benefit of allowing data into a single table and not having to re-enter or synchronize the data.

  2. Table-to-Table Imports (TTI)

    TTI are imports from one QuickBase table to another. TTIs can be within an application or across applications. The structure of the import can be saved and run manually. There is also an API, so the import can be programmatically executed. This is a great tool to synchronize data if a Cross App is not ideal.

  3. Report Links

    Report Links are used on QuickBase forms to show data from other tables that are related by some key information. In most cases these are directly related tables, but they can also be configured to show data in other applications. This can be a good way to leverage organizational information from various applications on a rich form.

Application Clusters 101
QuickBase operates on a unique and proprietary technology framework. Applications run on a single server process that often has other applications running on it simultaneously. When data sharing features are used they cause the connected applications to act as a single application. This provides the benefit of having access to all of the data in memory and essentially functioning like a homogenous entity. The downside of this is that these application clusters can get very large and complex and may lead to performance challenges. They can also be quite difficult to unravel.

Best Practices
Over the years of developing QuickBase applications in highly complex environments, as well as dealing with some complex applications that have run into clustering issues, we feel a few common sense practices can help ensure the proper benefits of data sharing where appropriate and avoid risks.

  1. Make sure to plan and understand the use of data sharing features as well as clustering risk as part of an overall data architecture.
  2. Keep application clusters to well-defined and managed groups of applications that have a clear benefit from data sharing.
  3. Have other options available, such as programmatic synchronization of data using QuickBase API's where clustering may present a risk.
  4. Communicate clearly to application developers the risks associated with data sharing features and have a process to review and approve their use.
  5. Periodically check applications for clustering by adding ?a=listdependentdatabases to the url on any application home dashboard.
  6. Be cautious when copying applications as Cross Apps may be retained and Report Links will be retained which could cause a substantial increase in cluster size.
  7. Be very careful when adding previously built applications to a cluster as they may have complex networks of sharing in place that could suddenly grow the cluster far beyond what is expected.
  8. Understand that TTI will create what is called an Intermittent Dependency so the clustering only occurs when the TTI is run and will eventually decluster. This can help avoid clustering if planned properly during off-use hours, but can also be a source of unexplained performance issues if not managed properly.

MCFTech is a leading QuickBase Partner and highly experienced at handling complex scalability and system design challenges. For more information please visit our website at www.mcftech.com or complete our contact form and a client solutions representative will reach out to you.

More Stories By Govind Davis

As a Partner in MCF, Govind has played the lead role in designing custom business process solutions for MCF customers. The philosophy behind his methodology is to work closely with clients to develop a deep understanding of their unique business process culture and design solutions to fit their environment. This process has led to the successful deployment of more than 50 custom applications. He spent three years as a Web 2.0 architect in a multi-billion dollar consumer products company driving solutions through out Global Sourcing. His development efforts tied together multiple North American locations with 3rd party suppliers in Asia. Hundreds of millions in purchasing dollars have run through his internally developed web applications. http://www.mcftech.com

@CloudExpo Stories
Leysin American School is an exclusive, private boarding school located in Leysin, Switzerland. Leysin selected an OpenStack-powered, private cloud as a service to manage multiple applications and provide development environments for students across the institution. Seeking to meet rigid data sovereignty and data integrity requirements while offering flexible, on-demand cloud resources to users, Leysin identified OpenStack as the clear choice to round out the school's cloud strategy. Additional...
The major cloud platforms defy a simple, side-by-side analysis. Each of the major IaaS public-cloud platforms offers their own unique strengths and functionality. Options for on-site private cloud are diverse as well, and must be designed and deployed while taking existing legacy architecture and infrastructure into account. Then the reality is that most enterprises are embarking on a hybrid cloud strategy and programs. In this Power Panel at 15th Cloud Expo (http://www.CloudComputingExpo.com...
We are all here because we are sold on the transformative promise of The Cloud. But what good is all of this ephemeral, on-demand infrastructure if your usage doesn't actually improve the agility and speed of your business? How must Operations adapt in order to avoid stifling your Cloud initiative? In his session at DevOps Summit, Damon Edwards, co-founder and managing partner of the DTO Solutions, will highlight the successful organizational, process, and tooling patterns of high-performing c...
The definition of IoT is not new, in fact it’s been around for over a decade. What has changed is the public's awareness that the technology we use on a daily basis has caught up on the vision of an always on, always connected world. If you look into the details of what comprises the IoT, you’ll see that it includes everything from cloud computing, Big Data analytics, “Things,” Web communication, applications, network, storage, etc. It is essentially including everything connected online from ha...
Software-driven innovation is becoming a primary approach to how businesses create and deliver new value to customers. A survey of 400 business and IT executives by the IBM Institute for Business Value showed businesses that are more effective at software delivery are also more profitable than their peers nearly 70 percent of the time (1). DevOps provides a way for businesses to remain competitive, applying lean and agile principles to software development to speed the delivery of software that ...
Docker offers a new, lightweight approach to application portability. Applications are shipped using a common container format and managed with a high-level API. Their processes run within isolated namespaces that abstract the operating environment independently of the distribution, versions, network setup, and other details of this environment. This "containerization" has often been nicknamed "the new virtualization." But containers are more than lightweight virtual machines. Beyond their small...
The move in recent years to cloud computing services and architectures has added significant pace to the application development and deployment environment. When enterprise IT can spin up large computing instances in just minutes, developers can also design and deploy in small time frames that were unimaginable a few years ago. The consequent move toward lean, agile, and fast development leads to the need for the development and operations sides to work very closely together. Thus, DevOps become...
Cloud Expo 2014 TV commercials will feature @ThingsExpo, which was launched in June, 2014 at New York City's Javits Center as the largest 'Internet of Things' event in the world.

ARMONK, N.Y., Nov. 20, 2014 /PRNewswire/ --  IBM (NYSE: IBM) today announced that it is bringing a greater level of control, security and flexibility to cloud-based application development and delivery with a single-tenant version of Bluemix, IBM's

An entirely new security model is needed for the Internet of Things, or is it? Can we save some old and tested controls for this new and different environment? In his session at @ThingsExpo, New York's at the Javits Center, Davi Ottenheimer, EMC Senior Director of Trust, reviewed hands-on lessons with IoT devices and reveal a new risk balance you might not expect. Davi Ottenheimer, EMC Senior Director of Trust, has more than nineteen years' experience managing global security operations and asse...
Explosive growth in connected devices. Enormous amounts of data for collection and analysis. Critical use of data for split-second decision making and actionable information. All three are factors in making the Internet of Things a reality. Yet, any one factor would have an IT organization pondering its infrastructure strategy. How should your organization enhance its IT framework to enable an Internet of Things implementation? In his session at Internet of @ThingsExpo, James Kirkland, Chief Ar...
Technology is enabling a new approach to collecting and using data. This approach, commonly referred to as the "Internet of Things" (IoT), enables businesses to use real-time data from all sorts of things including machines, devices and sensors to make better decisions, improve customer service, and lower the risk in the creation of new revenue opportunities. In his General Session at Internet of @ThingsExpo, Dave Wagstaff, Vice President and Chief Architect at BSQUARE Corporation, discuss the ...
The security devil is always in the details of the attack: the ones you've endured, the ones you prepare yourself to fend off, and the ones that, you fear, will catch you completely unaware and defenseless. The Internet of Things (IoT) is nothing if not an endless proliferation of details. It's the vision of a world in which continuous Internet connectivity and addressability is embedded into a growing range of human artifacts, into the natural world, and even into our smartphones, appliances, a...
"BSQUARE is in the business of selling software solutions for smart connected devices. It's obvious that IoT has moved from being a technology to being a fundamental part of business, and in the last 18 months people have said let's figure out how to do it and let's put some focus on it, " explained Dave Wagstaff, VP & Chief Architect, at BSQUARE Corporation, in this SYS-CON.tv interview at @ThingsExpo, held Nov 4-6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
The 4th International DevOps Summit, co-located with16th International Cloud Expo – being held June 9-11, 2015, at the Javits Center in New York City, NY – announces that its Call for Papers is now open. Born out of proven success in agile development, cloud computing, and process automation, DevOps is a macro trend you cannot afford to miss. From showcase success stories from early adopters and web-scale businesses, DevOps is expanding to organizations of all sizes, including the world's large...
Verizon Enterprise Solutions is simplifying the cloud-purchasing experience for its clients, with the launch of Verizon Cloud Marketplace, a key foundational component of the company's robust ecosystem of enterprise-class technologies. The online storefront will initially feature pre-built cloud-based services from AppDynamics, Hitachi Data Systems, Juniper Networks, PfSense and Tervela. Available globally to enterprises using Verizon Cloud, Verizon Cloud Marketplace provides a one-stop shop fo...
"Our premise is Docker is not enough. That's not a bad thing - we actually love Docker. At ActiveState all our products are based on open source technology and Docker is an up-and-coming piece of open source technology," explained Bart Copeland, President & CEO of ActiveState Software, in this SYS-CON.tv interview at DevOps Summit at Cloud Expo®, held Nov 4-6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
DevOps Summit 2015 New York, co-located with the 16th International Cloud Expo - to be held June 9-11, 2015, at the Javits Center in New York City, NY - announces that it is now accepting Keynote Proposals. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to wait for long development cycles that produce software that is obsolete...
What do a firewall and a fortress have in common? They are no longer strong enough to protect the valuables housed inside. Like the walls of an old fortress, the cracks in the firewall are allowing the bad guys to slip in - unannounced and unnoticed. By the time these thieves get in, the damage is already done and the network is already compromised. Intellectual property is easily slipped out the back door leaving no trace of forced entry. If we want to reign in on these cybercriminals, it's hig...
Infor has announced a new feature Infor CloudSuite™ Aerospace & Defense (A&D) to aid compliance with International Traffic in Arms Regulations (ITAR). The ITAR function will serve as a complementary function for new or existing Infor CloudSuite A&D customers, to facilitate compliance for Infor customers that are creating a US defense article or performing a US defense service and wish to benefit from cloud-services. The ITAR regulation serves to manage handling and access requirements for dat...