DataWrangler:DataWrangler是在LiteDB之上构建的数据管理程序,该LiteDB是需要零配置的快速NoS

  • E9_902308
    了解作者
  • 3.5MB
    文件大小
  • zip
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-06-03 05:31
    上传日期
数据管理软件 受到科罗拉多州一家致力于维护数百年当地历史的非营利组织的启发,Data Wrangler诞生了。 客户需要一种方法,将他们的异类数据从数十个Microsoft Excel电子表格迁移到易于使用的应用程序中,而不会遇到麻烦。 我们创建了Data Wrangler来满足这一需求,并且我们认为其他人可以使用和构建我们的软件来简化,更安全和可靠地管理分散的,不同的数据。 该项目是为科罗拉多大学的学生毕业所需的高级高级课程而创建的。 该项目的主要重点之一是花费大量时间考虑软件的用例,并设计体系结构以支持当前和将来的用例。 这给我们的团队带来了很多启发,对此我深表感谢。 没有团队的其他成员( 和 )将无法使用该软件。 感谢团队提供了这样一种优雅的解决方案,以极少的开销(以及出色的C#集成!)访问NoSQL文档存储。 登陆屏 入门-下载 访问“标签以浏览我们的发布历史记录,或在获取最新版本 功能-模块化数据库 Data Wrangler建立在LiteDB之上,速度很快,可以将数据存储在以.db扩展名结尾的自包含文件中。 这样就可以在必要时轻松地跨基础结构传输数据库文件,或者使用W
DataWrangler-master.zip
内容介绍
# Data Wrangler Software Inspired by a non-profit organization in Colorado focused on preserving local history that spans hundreds of years, Data Wrangler was born. The client needed a way to migrate their dissimilar data from dozens of Microsoft Excel spreadsheets to an easy to use application with little hassle. We created Data Wrangler to fill this need, and we think that others can use and build on our software to make managing scattered, dissimilar data easy, safer, and reliable. This project was created for a senior capstone course required for students to graduate from a Colorado university. One of the primary focuses of the project was to spend a lot of time considering the use cases of the software, and to design the architecture to support current and future use cases. This taught our team a lot, and I am grateful for this experience. This software wouldn't have been possible without the rest of the team ([Aaron Skilling](https://github.com/askilling) and [Hunter Stephens](https://github.com/Agent531C)). Thanks to the [LiteDB](http://www.litedb.org/) team for providing such an elegant solution for accessing NoSQL Document Stores with little overhead (and with great C# integration!). _Landing Screen_ ![Landing](/Screenshots/Landing.PNG) #### **** ## Getting Started - Downloading Visit the [Releases](https://github.com/MarkoH17/DataWrangler/releases) tab to browse our release history, or get the latest release [here](https://github.com/MarkoH17/DataWrangler/releases/latest) ## Features - Modular Database Built atop LiteDB, Data Wrangler is fast and stores data in a self-contained file ending in a .db extension. This makes it easy to transfer the database file across infrastructure when necessary, or share access to multiple users with a Windows SMB file share. Because Data Wrangler was designed to run without a server component (meaning no additional infrastructure is needed to deploy), database reads and writes are not atomically synchronized. However, multiple users are still able to access the same database file so long that the underlying filesystem hosting the database file supports file locks with Windows sharing (e.g. not NFS). Our use case demanded our software to support 5-10 users on the system, and we feel like anything more than this should require a different tool for the job. ## Features - Object Auditing User accounts, Record types, and Records all support the auditing capability build into Data Wrangler. Audit entires are automatically recorded in the database as certain events occur, including: create, update, delete, login success, login failure, add attachment, remove attachment. Audit entries can be viewed at a per-object level, or aggregated by user account. _Record Audit History_ ![Record History](/Screenshots/Audit_Record.PNG) ## Features - Import Data Importing data from Microsoft Excel spreadsheets is made easy and is powered by [EPPlus (v4.5.3)](https://github.com/JanKallman/EPPlus). _Import Excel Data_ ![Import Data](/Screenshots/Import.PNG) ## Features - Managing Schema Managing schema through 'record types' is an easy way to add, update, and delete attributes used to store key-value data in 'records'. _Manage Record Schema_ ![Record Types](/Screenshots/Record_Types.PNG) ## Features - Managing Records Managing records is made possible through a fast UI that supports filtering by keywords. This makes it easy to view all records of a certain type, or only records that match certain criteria. We would like to expand to support advanced queries, allowing users to specify criteria using boolean operators (e.g. 'FirstName' = 'John' AND 'LastName' = 'Doe) through a graphical query builder. Records can also store more than just text data! Files of any kind can also be added to a record as an attachment, which is implemented through LiteDB's FileStorage mechanism, which streams the binary contents into the database for reliable retrieval. _Manage Records_ ![Manage Records](/Screenshots/Records.PNG) ## Features - Managing User Access and Security User accounts make it possible to secure unauthorized access to the database. Passwords are hashed in a function that applies a 16 byte (pseudo) random salt and then 1000 rounds of [PBKDF2,](https://docs.microsoft.com/en-us/dotnet/api/system.security.cryptography.rfc2898derivebytes) which is implemented with HMACSHA1. It is worth mentioning that encryption of the LiteDB database was not implemented in this project - this is easy to accomplish and can be enabled by adding a value to the database connection string. Check out the [LiteDB Encryption Docs](http://www.litedb.org/docs/encryption/) to learn more about encryption. ***We do not recommend using Data Wrangler to store any sensitive information without the proper implementation of access controls or encryption. Use of Data Wrangler at your own risk*** _Manage Users_ ![User Accounts](/Screenshots/Users.PNG) _User Audit History_ ![Import Data](/Screenshots/Audit_Users.PNG) ## Features - Customization Customizing the look and feel of Data Wrangler makes it possible to streamline the user experience to adhere to an organization's branding. _Options_ ![Options](/Screenshots/Options.PNG) _Non-comprehensive collage of look and feels_ ![Themes Collage](/Screenshots/Themed/Themes_Collage.PNG) ## Future Plans Although the development of Data Wrangler is paused at the moment, we encourage others to fork this repository to continue the development of Data Wrangler. Not a Developer? Perhaps download the [latest release](https://github.com/MarkoH17/DataWrangler/releases) to see if it meets your needs.
评论
    相关推荐