A
A
alexei42015-06-09 11:17:17
SQL
alexei4, 2015-06-09 11:17:17

What means of implementing the Electronic Directory of Technical Documentation would you recommend?

What is required
An electronic reference or database of sensors and measuring systems is required with the functions of searching, editing and conveniently displaying the most complete information about the sensor or measuring system.
Information about each sensor in the directory can be supplemented with related documents: sensor image, sensor drawing, connection diagram, calibration procedure, certificate, etc.
Why is it required
Detailed specifications of sensors are necessary for making design decisions, selecting sensors that meet the conditions of the technical specifications of the developed measurement system. Presentation of data in electronic form will increase the relevance of data, speed up the search for information and simplify the exchange of data when agreeing and accepting products.
Peculiarities

  • Most of the specifications of sensors and measuring systems are now stored on paper in manufacturers' directories and catalogs.
  • Design documentation is created in CAD tools.
  • The company's electronic archive system is at the implementation stage.
  • The enterprise management system is built on the basis of the Oracle DBMS, but does not cover all production processes.
  • The initiative to create the described reference comes from below (from the department developing measurement systems), the implementation is supposed to be transferred to a pair of C # programmers (employees of this department - who asks this question).
  • In case of successful implementation of the system, the subject area will expand (for example, electrical components, connectors and own products - matching devices and measurement systems)
Personal considerations
A system that combines information about different types of sensors from different manufacturers (including foreign ones) must have a flexible data structure.
I would like to solve the problem as simply as possible "without bells and whistles", so that in the future the directory could be integrated into the enterprise management system when they put things in order or introduce the same PDM (a very distant prospect).
Question
Dear Experts, please advise possible means of implementing such a guide, tell us about your personal experience in solving similar problems, and potential problems.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
aleksei4, 2015-07-21
@aleksei4

Once again, many thanks to all respondents for advice and arguments.
I want to unsubscribe about the result of studying the proposed topics and tips (I apologize for the time later, because I was away). The NoSQL
topic turned out to be very interesting, and studying it was not in vain, but at this stage of the implementation of the described electronic reference book, it was decided to make a relational database . Causes:
For the fastest transition from the implementation of the database to filling with data, we chose the simplest Access DBMS (yes, not very serious, but ease of development, familiarity with users and the availability of the Office package take their toll). To reduce the amount of "double work" in the future, when moving to the "final" implementation tool, the development was carried out using the ERwin design automation tool, which will later allow transferring the finished data schema to the target environment, and using Access as a data source for one-time import.
Logical data schema in ERwin:
Data schema in Microsoft Access environment after adding tables under enumerated data types:2f31d37dbdb0426cb72270dd5c53acc9.JPG

A
Alexey Cheremisin, 2015-06-09
@leahch

Well, I don’t even know what to advise here ... Maybe as an elasticsearch option ?! There is a search, it can store documents, nosql, again, you can add different data types too ... try it - habrahabr.ru/company/percolator/blog/222765
PS. I haven’t worked with elasticsearch yet, but at one time, 10 years ago, I worked very closely with lyusina (which is at its core), where we just stored documents in it just for searching. Lucy's impressions are very positive!
ZZY. Directly according to the article, they did so (with lyusina).
And now, along the way, you can keep it in it ....
PPPS.
habrahabr.ru/post/122531 - here to get started.
PPPPS. And don't be afraid of Java, you can work with it in C# as well.

D
des1roer, 2015-06-09
@des1roer

What's the trick?
Postgres + Yii
store data in the database, use yii (to taste) to output to your local site. what does C# have to do with it? on asp.net there is a desire to do this?
UPD
, have you banned many-to-many communications?
and for the same nosql habr, you can read more
habrahabr.ru/post/231213
habrahabr.ru/post/253075
than praise .
and yes - both search and a different number of columns depending on the template are working fine for me now.
Also, how much data do you want to store?
Well, did you find the silver bullet?
I put my thoughts here des1roer.blogspot.com/2015/06/yii.html

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question