|By Govind Davis||
|August 7, 2014 03:24 PM EDT||
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.
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.
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.
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.
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.
- Make sure to plan and understand the use of data sharing features as well as clustering risk as part of an overall data architecture.
- Keep application clusters to well-defined and managed groups of applications that have a clear benefit from data sharing.
- Have other options available, such as programmatic synchronization of data using QuickBase API's where clustering may present a risk.
- Communicate clearly to application developers the risks associated with data sharing features and have a process to review and approve their use.
- Periodically check applications for clustering by adding ?a=listdependentdatabases to the url on any application home dashboard.
- 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.
- 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.
- 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.
"When you think about the data center today, there's constant evolution, The evolution of the data center and the needs of the consumer of technology change, and they change constantly," stated Matt Kalmenson, VP of Sales, Service and Cloud Providers at Veeam Software, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Jul. 28, 2016 10:00 PM EDT Reads: 1,436
"There's a growing demand from users for things to be faster. When you think about all the transactions or interactions users will have with your product and everything that is between those transactions and interactions - what drives us at Catchpoint Systems is the idea to measure that and to analyze it," explained Leo Vasiliou, Director of Web Performance Engineering at Catchpoint Systems, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York Ci...
Jul. 28, 2016 10:00 PM EDT Reads: 2,094
As companies gain momentum, the need to maintain high quality products can outstrip their development team’s bandwidth for QA. Building out a large QA team (whether in-house or outsourced) can slow down development and significantly increases costs. This eBook takes QA profiles from 5 companies who successfully scaled up production without building a large QA team and includes: What to consider when choosing CI/CD tools How culture and communication can make or break implementation
Jul. 28, 2016 10:00 PM EDT Reads: 1,715
Internet of @ThingsExpo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with the 19th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world and ThingsExpo Silicon Valley Call for Papers is now open.
Jul. 28, 2016 09:00 PM EDT Reads: 2,701
I wanted to gather all of my Internet of Things (IOT) blogs into a single blog (that I could later use with my University of San Francisco (USF) Big Data “MBA” course). However as I started to pull these blogs together, I realized that my IOT discussion lacked a vision; it lacked an end point towards which an organization could drive their IOT envisioning, proof of value, app dev, data engineering and data science efforts. And I think that the IOT end point is really quite simple…
Jul. 28, 2016 07:15 PM EDT Reads: 1,228
Extreme Computing is the ability to leverage highly performant infrastructure and software to accelerate Big Data, machine learning, HPC, and Enterprise applications. High IOPS Storage, low-latency networks, in-memory databases, GPUs and other parallel accelerators are being used to achieve faster results and help businesses make better decisions. In his session at 18th Cloud Expo, Michael O'Neill, Strategic Business Development at NVIDIA, focused on some of the unique ways extreme computing is...
Jul. 28, 2016 07:15 PM EDT Reads: 368
"We view the cloud not really as a specific technology but as a way of doing business and that way of doing business is transforming the way software, infrastructure and services are being delivered to business," explained Matthew Rosen, CEO and Director at Fusion, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Jul. 28, 2016 06:45 PM EDT Reads: 1,635
Redis is not only the fastest database, but it is the most popular among the new wave of databases running in containers. Redis speeds up just about every data interaction between your users or operational systems. In his session at 19th Cloud Expo, Dave Nielsen, Developer Advocate, Redis Labs, will share the functions and data structures used to solve everyday use cases that are driving Redis' popularity.
Jul. 28, 2016 06:30 PM EDT Reads: 1,661
Aspose.Total for .NET is the most complete package of all file format APIs for .NET as offered by Aspose. It empowers developers to create, edit, render, print and convert between a wide range of popular document formats within any .NET, C#, ASP.NET and VB.NET applications. Aspose compiles all .NET APIs on a daily basis to ensure that it contains the most up to date versions of each of Aspose .NET APIs. If a new .NET API or a new version of existing APIs is released during the subscription peri...
Jul. 28, 2016 06:00 PM EDT Reads: 955
Organizations planning enterprise data center consolidation and modernization projects are faced with a challenging, costly reality. Requirements to deploy modern, cloud-native applications simultaneously with traditional client/server applications are almost impossible to achieve with hardware-centric enterprise infrastructure. Compute and network infrastructure are fast moving down a software-defined path, but storage has been a laggard. Until now.
Jul. 28, 2016 05:30 PM EDT Reads: 1,865
"My role is working with customers, helping them go through this digital transformation. I spend a lot of time talking to banks, big industries, manufacturers working through how they are integrating and transforming their IT platforms and moving them forward," explained William Morrish, General Manager Product Sales at Interoute, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Jul. 28, 2016 05:30 PM EDT Reads: 2,214
To leverage Continuous Delivery, enterprises must consider impacts that span functional silos, as well as applications that touch older, slower moving components. Managing the many dependencies can cause slowdowns. See how to achieve continuous delivery in the enterprise.
Jul. 28, 2016 05:00 PM EDT Reads: 432
You think you know what’s in your data. But do you? Most organizations are now aware of the business intelligence represented by their data. Data science stands to take this to a level you never thought of – literally. The techniques of data science, when used with the capabilities of Big Data technologies, can make connections you had not yet imagined, helping you discover new insights and ask new questions of your data. In his session at @ThingsExpo, Sarbjit Sarkaria, data science team lead ...
Jul. 28, 2016 04:30 PM EDT Reads: 1,191
SYS-CON Events announced today the Kubernetes and Google Container Engine Workshop, being held November 3, 2016, in conjunction with @DevOpsSummit at 19th Cloud Expo at the Santa Clara Convention Center in Santa Clara, CA. This workshop led by Sebastian Scheele introduces participants to Kubernetes and Google Container Engine (GKE). Through a combination of instructor-led presentations, demonstrations, and hands-on labs, students learn the key concepts and practices for deploying and maintainin...
Jul. 28, 2016 04:30 PM EDT Reads: 916
Security, data privacy, reliability, and regulatory compliance are critical factors when evaluating whether to move business applications from in-house, client-hosted environments to a cloud platform. Quality assurance plays a vital role in ensuring that the appropriate level of risk assessment, verification, and validation takes place to ensure business continuity during the migration to a new cloud platform.
Jul. 28, 2016 04:15 PM EDT Reads: 376