Welcome!

IoT User Interface Authors: Liz McMillan, Sanjay Zalavadia, Elizabeth White, AppDynamics Blog, Yakov Fain

Related Topics: Microservices Expo, Java IoT, Industrial IoT, Microsoft Cloud, IoT User Interface

Microservices Expo: 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
So you’ve heard how click-to-call widgets can really enhance a website’s potential for customer interaction and you want to try it out for yourself. Or you’re considering offloading pieces of your VoIP infrastructure, but want to see how that would unfold first. Where can you find this technology, that’s free and available to try out? Spotting the potential in a space where customers can experiment with these types of features, Voxbone is launching The Workshop.
When it comes to cloud computing, the ability to turn massive amounts of compute cores on and off on demand sounds attractive to IT staff, who need to manage peaks and valleys in user activity. With cloud bursting, the majority of the data can stay on premises while tapping into compute from public cloud providers, reducing risk and minimizing need to move large files. In his session at 18th Cloud Expo, Scott Jeschonek, Director of Product Management at Avere Systems, discussed the IT and busin...
The Internet of Things will challenge the status quo of how IT and development organizations operate. Or will it? Certainly the fog layer of IoT requires special insights about data ontology, security and transactional integrity. But the developmental challenges are the same: People, Process and Platform and how we integrate our thinking to solve complicated problems. In his session at 19th Cloud Expo, Craig Sproule, CEO of Metavine, will demonstrate how to move beyond today's coding paradigm ...
"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.
The cloud market growth today is largely in public clouds. While there is a lot of spend in IT departments in virtualization, these aren’t yet translating into a true “cloud” experience within the enterprise. What is stopping the growth of the “private cloud” market? In his general session at 18th Cloud Expo, Nara Rajagopalan, CEO of Accelerite, explored the challenges in deploying, managing, and getting adoption for a private cloud within an enterprise. What are the key differences between wh...
The pace of innovation, vendor lock-in, production sustainability, cost-effectiveness, and managing risk… In his session at 18th Cloud Expo, Dan Choquette, Founder of RackN, discussed how CIOs are challenged finding the balance of finding the right tools, technology and operational model that serves the business the best. He also discussed how clouds, open source software and infrastructure solutions have benefits but also drawbacks and how workload and operational portability between vendors ...
"We work in the area of Big Data analytics and Big Data analytics is a very crowded space - you have Hadoop, ETL, warehousing, visualization and there's a lot of effort trying to get these tools to talk to each other," explained Mukund Deshpande, head of the Analytics practice at Accelerite, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
SYS-CON Events has announced today that Roger Strukhoff has been named conference chair of Cloud Expo and @ThingsExpo 2016 Silicon Valley. The 19th Cloud Expo and 6th @ThingsExpo will take place on November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. "The Internet of Things brings trillions of dollars of opportunity to developers and enterprise IT, no matter how you measure it," stated Roger Strukhoff. "More importantly, it leverages the power of devices and the Interne...
The idea of comparing data in motion (at the sensor level) to data at rest (in a Big Data server warehouse) with predictive analytics in the cloud is very appealing to the industrial IoT sector. The problem Big Data vendors have, however, is access to that data in motion at the sensor location. In his session at @ThingsExpo, Scott Allen, CMO of FreeWave, discussed how as IoT is increasingly adopted by industrial markets, there is going to be an increased demand for sensor data from the outermos...
The initial debate is over: Any enterprise with a serious commitment to IT is migrating to the cloud. But things are not so simple. There is a complex mix of on-premises, colocated, and public-cloud deployments. In this power panel at 18th Cloud Expo, moderated by Conference Chair Roger Strukhoff, Randy De Meno, Chief Technologist - Windows Products and Microsoft Partnerships at Commvault; Dave Landa, Chief Operating Officer at kintone; William Morrish, General Manager Product Sales at Interou...
Internet of @ThingsExpo has announced today that Chris Matthieu has been named tech chair of Internet of @ThingsExpo 2016 Silicon Valley. The 6thInternet of @ThingsExpo will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA.
As organizations shift towards IT-as-a-service models, the need for managing and protecting data residing across physical, virtual, and now cloud environments grows with it. Commvault can ensure protection, access and E-Discovery of your data – whether in a private cloud, a Service Provider delivered public cloud, or a hybrid cloud environment – across the heterogeneous enterprise. In his general session at 18th Cloud Expo, Randy De Meno, Chief Technologist - Windows Products and Microsoft Part...
Dialogic has announced that ZVRS chose Dialogic® PowerMedia™ XMS software media server as part of its latest video relay and translation service offering. ZVRS uses Dialogic’s PowerMedia XMS technology to provide a robust solution that supports a broad range of legacy devices and any-to-any video capabilities with its flagship Z70 videophone. ZVRS selected Dialogic’s solution to facilitate a release of Z70 that met its stringent requirements for legacy device support (H.263 and H.264) with high...
Basho Technologies has announced the latest release of Basho Riak TS, version 1.3. Riak TS is an enterprise-grade NoSQL database optimized for Internet of Things (IoT). The open source version enables developers to download the software for free and use it in production as well as make contributions to the code and develop applications around Riak TS. Enhancements to Riak TS make it quick, easy and cost-effective to spin up an instance to test new ideas and build IoT applications. In addition to...
CenturyLink has announced that application server solutions from GENBAND are now available as part of CenturyLink’s Networx contracts. The General Services Administration (GSA)’s Networx program includes the largest telecommunications contract vehicles ever awarded by the federal government. CenturyLink recently secured an extension through spring 2020 of its offerings available to federal government agencies via GSA’s Networx Universal and Enterprise contracts. GENBAND’s EXPERiUS™ Application...
In addition to all the benefits, IoT is also bringing new kind of customer experience challenges - cars that unlock themselves, thermostats turning houses into saunas and baby video monitors broadcasting over the internet. This list can only increase because while IoT services should be intuitive and simple to use, the delivery ecosystem is a myriad of potential problems as IoT explodes complexity. So finding a performance issue is like finding the proverbial needle in the haystack.
You are moving to the Cloud. The question is not if, it’s when. Now that your competitors are in the cloud and lapping you, your “when” better hurry up and get here. But saying and doing are two different things. In his session at @DevOpsSummit at 18th Cloud Expo, Robert Reeves, CTO of Datical, explained how DevOps can be your onramp to the cloud. By adopting simple, platform independent DevOps strategies, you can accelerate your move to the cloud. Spoiler Alert: He also makes sure you don’t...
Edge Hosting has announced a partnership with and the availability of CloudFlare, a web application firewall, CDN and DDoS mitigation service. “This partnership enhances Edge Hosting’s world class, perimeter layer, application (layer 7) defensive mechanism,” said Mark Houpt, Edge Hosting CISO. “The goal was to enable a new layer of customer controlled defense and compliance through the application of DDoS filters and mitigations, the web application firewall (WAF) feature and the added benefit ...
Digital Initiatives create new ways of conducting business, which drive the need for increasingly advanced security and regulatory compliance challenges with exponentially more damaging consequences. In the BMC and Forbes Insights Survey in 2016, 97% of executives said they expect a rise in data breach attempts in the next 12 months. Sixty percent said operations and security teams have only a general understanding of each other’s requirements, resulting in a “SecOps gap” leaving organizations u...
"A lot of times people will come to us and have a very diverse set of requirements or very customized need and we'll help them to implement it in a fashion that you can't just buy off of the shelf," explained Nick Rose, CTO of Enzu, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.