Progress > 实例探究 > MarkLogic Helps Fairfax County Residents Become More Civic-minded

MarkLogic Helps Fairfax County Residents Become More Civic-minded

Progress Logo
公司规模
1,000+
地区
  • America
国家
  • United States
产品
  • MarkLogic's Enterprise NoSQL database platform
技术栈
  • NoSQL
  • Esri
实施规模
  • Enterprise-wide Deployment
影响指标
  • Customer Satisfaction
  • Productivity Improvements
技术
  • 应用基础设施与中间件 - 数据库管理和存储
适用行业
  • 城市与自治市
适用功能
  • 商业运营
服务
  • 系统集成
关于客户
Fairfax County, Virginia is one of the largest counties in the nation, with more than one million residents and a budget larger than that of four states combined. The Fairfax County Department of Information Technology (DIT) uses modern information technologies to improve citizen access to government information and services, including a wide variety of mapping data from the county's geographic information system (GIS). The DIT's goal is to provide the community with convenient access to appropriate information and services through technology.
挑战
Fairfax County wanted to upgrade their existing Police Events application. This application allowed the public to search, filter, and map police service calls by type, location, and date, and access preliminary police investigation data from Fairfax County's 9-1-1 call center. With more than a half-million data points from all over the county, the data overwhelmed the existing Oracle relational database. The county's GIS database contained data from more than 800 different sources, including libraries, schools, hospitals, most of which have unique schemas, making it difficult to sort through and access. Only a small amount of GIS data was available via the previous Fairfax GIS search application, which was JavaScript-based. This legacy application did not provide the flexibility to constrain searches to specific data layers without customization. The existing database had to search layer by layer, one column at a time, making searches slow and difficult. The county has approximately 800 distinct layers in its GIS database and most have their own specific data schema. For non-GIS staff this can make sifting through all of the information very difficult. The ability to add new datasets as they were identified and provide a set of tools for loading and enrichment was tough. Also, returning information in a variety of formats including JSON, XML, and KML was not possible, and data needed to be RESTful to keep in accordance with current practices.
解决方案
Fairfax County wanted to put more geospatial information directly into the hands of county residents. In order to do so, the Police Events app needed an enterprise-grade NoSQL database solution that could handle the volume of data that the old, relational database couldn't. The department tested several NoSQL databases, including various open source solutions. MarkLogic's Enterprise NoSQL database platform outperformed them all, giving Fairfax County DIT the ability to make complicated queries to its GIS database, and making that data easily accessible to users. MarkLogic gave the department the infrastructure it needed to improve query times on GIS database searches, as well as the ability to make more of that data accessible to the public. MarkLogic was an obvious choice for Fairfax County DIT due to its enterprise-level performance, geospatial support, and unrestricted search capabilities across unrelated data in a geographic context.
运营影响
  • MarkLogic's database houses more than a half-million data points about police events and geography. Querying this data from different sources, integrating with existing IT infrastructure at the time, and storing this information in one place was essential.
  • MarkLogic was able to sort and search information from several different GIS tools and make individual queries to each, based on a user's search. It was also compatible with Esri, a spatial database engine that stores geospatial information.
  • County employees and residents now can access real-time information about neighborhood disturbances, thefts, drug or sex offenses, and more, in whichever area they chose.
  • On any given day, there are between 100 and 200 new police service calls that must be integrated into the system from different sources. MarkLogic provides a central repository for all these data sources and easily allows the system to add new datasets as they are identified as well as providing a set of tools for loading and enrichment.
  • MarkLogic made the application more reliable, slashing support time needed, both internally and for users. The department used to field three to four support calls from users per week. Since moving to a MarkLogic database, there have been none.
数量效益
  • MarkLogic increased the Police Events application's search speed, greatly improving user experience and leading to a massive increase in traffic to the site and usage of the application. The old relational database had to search through data from every tool for each search, causing simple searches to take 10 seconds on average. With MarkLogic, searches are returned in sub-seconds, making the system much more useful for the public.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。