Aug 20

#Sensor: #Canada: #Job/Contract/Project: #Sensor, #Tracking, #Fusion, #Estimation, #Surveillance, #sensor network, #target #tracking, #security 2021-08-21

Date Posted:2021-08-21 .Apply yourself, or submit others as candidates; Build a recruitment team to submit others as candidates; submit RFP to be considered for projects in future; Try to become a vendor so that you are asked to submit consultants/resources in future. If these work for you. This list is posted in this blog everyday provided there are new projects under the criteria

  1. communications-detection-and-fibre-optics-10031
  2. VERMILION – Provincial Building – Security Card Access System
  3. edp-hardware-and-software-10034
  4. Request for Expressions of Interest and Qualifications for Endpoint Security Solutions
  5. Ivanti Security Controls Maintenance Renewal
  6. Ivanti Security Controls Maintenance Renewal
  7. fire-fighting-security-and-safety-equipment-10010
  8. ITQ2021-08-27 for Purchase of Security Safes and Parts
  9. miscellaneous-goods-10019
  10. Design, Fabrication and Installation of Interactive Donor Recognition Wall
  11. custodial-operations-and-related-services-10037
  12. Security Services – Cambridge Bay, NU (3Y004-210026/B)
  13. information-processing-and-related-telecommunications-services-10049
  14. TBIPS – IT Security TRA and C&A Analyst (20210445) (20210445-01)
  15. Digitization of Old Age Security (OAS) files (100018791)
  16. maintenance-repair-modification-rebuilding-and-installation-of-goods-equipment-10054
  17. Renewal of Cisco Subscription, Maintenance and Support for Various Security Related Appliances
  18. WRIC Site Security 2
  19. operation-of-government-owned-facilities-10039
  20. Security Guard Services for Off-Street Operations
  21. professional-administrative-and-management-support-services-10040
  22. Project: tender_15159 – Payment Card Industry Qualified Security Assessor
  23. special-studies-and-analysis-not-r-d-10047
  24. Electronic Supply Chain Tracking and Socio-Economic Impact Reporting Service

    25. Keywords Used:sensor,fusion,sensor network,tracking,target tracking,surveillance,self driving car,self-driving,estimation,security,signal processing,image processing,autonomouse vehicle,facial recognition,signal,recognition,sensor fusion

    Aug 20

    #Sensor: #Canada: #Job/Contract/Project: #Sensor, #Tracking, #Fusion, #Estimation, #Surveillance, #sensor network, #target #tracking, #security 2021-08-20

    Date Posted:2021-08-20 .Apply yourself, or submit others as candidates; Build a recruitment team to submit others as candidates; submit RFP to be considered for projects in future; Try to become a vendor so that you are asked to submit consultants/resources in future. If these work for you. This list is posted in this blog everyday provided there are new projects under the criteria

    1. communications-detection-and-fibre-optics-10031
    2. VERMILION – Provincial Building – Security Card Access System
    3. edp-hardware-and-software-10034
    4. Request for Expressions of Interest and Qualifications for Endpoint Security Solutions
    5. Ivanti Security Controls Maintenance Renewal
    6. Ivanti Security Controls Maintenance Renewal
    7. fire-fighting-security-and-safety-equipment-10010
    8. ITQ2021-08-27 for Purchase of Security Safes and Parts
    9. miscellaneous-goods-10019
    10. Design, Fabrication and Installation of Interactive Donor Recognition Wall
    11. custodial-operations-and-related-services-10037
    12. Security Services – Cambridge Bay, NU (3Y004-210026/B)
    13. information-processing-and-related-telecommunications-services-10049
    14. TBIPS – IT Security TRA and C&A Analyst (20210445) (20210445-01)
    15. Digitization of Old Age Security (OAS) files (100018791)
    16. maintenance-repair-modification-rebuilding-and-installation-of-goods-equipment-10054
    17. Renewal of Cisco Subscription, Maintenance and Support for Various Security Related Appliances
    18. WRIC Site Security 2
    19. operation-of-government-owned-facilities-10039
    20. Security Guard Services for Off-Street Operations
    21. professional-administrative-and-management-support-services-10040
    22. Project: tender_15159 – Payment Card Industry Qualified Security Assessor
    23. special-studies-and-analysis-not-r-d-10047
    24. Electronic Supply Chain Tracking and Socio-Economic Impact Reporting Service

      25. Keywords Used:sensor,fusion,sensor network,tracking,target tracking,surveillance,self driving car,self-driving,estimation,security,signal processing,image processing,autonomouse vehicle,facial recognition,signal,recognition,sensor fusion

      Aug 20

      Passing Parameters from Front end to Access Queries. VB.Net/ASP platform #2

      Just append the parameter values with the query name from the front end.

      For example, say a query in access has the pattern:catId = [categoryId].

      It indicates that categoryId has to be supplied to this query.

      From the front end, you can use:strQuery = ” qry_name ‘ ” & numCategoryID & “‘”

      //VB.Net/ASP platform

      ASP Code:

      Dim numCategoryIDnumCategoryID = Request.Form("CategoryID")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/cats.mdb")
Set objRS = Server.CreateObject("ADODB.Recordset")
strQuery = "qry_name ' " & numCategoryID & "'"
objRS.Open strQuery, objConn, 0, 4

      From: http://sitestree.com/?p=5216
      Categories:2
      Tags:
      Post Data:2007-01-11 23:23:02

          Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

      Aug 20

      Tools to create ER diagrams from a database dynamically #2 

      Microsoft Visio, and dbVisualizer provide features to create ER diagrams from existing database tables.Why needed?ER diagram is very useful to understand the total database structure that helps a new programmer to work on the existing databases more efficiently.Visio:While creating Database diagrams, a menu item named database is displayed. Reverse Engineering option under Database menu helps to create ER diagram from existing database tables. Before that, target database drivers for visio need to be installed. If the database is in db2/mysql/postgresql, then  db2/mysql/postgresql drivers for visio should be installed. From Database/options/drivers, the driver needs to be configured. Afterwards, Reverse Engineering option may be used to create the ER diagram. There is no suitable driver for postgresql databases for Visio. ODBC drivers may be used for the purpose (the ER diagram may not be accurate from ODBC driver for postgresql). dbVisualizer:In dbVisualizer, when the TABLEs group/option is selected in the left pane in the right/middle pane there will be a references option. When the references tab is selected, an ER diagram is displayed using all tables. The ER diagram can be displayed as Hierarchical, circular, orthogonal, or organic. There are options for the purpose.When a single table name is selected, the table and the associated tables are displayed in an ER diagram.In the rightest column, selected tables option allows to create ER diagrams only for the selected tables. When 'selected tables' is clicked a list is displayed in a dialog box. Tables can be selected from this list (use control key). Build graph  option creates and displays the ER diagram.

      From: http://sitestree.com/?p=4785
      Categories:2
      Tags:
      Post Data:2012-08-27 09:57:03

          Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

      Aug 20

      Firebird Stored procedure delphi #2

      In firebird, the syntax to create TRIGGERs and Stored Procedures is as below:

      —

      SET TERM !! ;
      CREATE TRIGGER auto_update_1 FOR DBPATHS
      after INSERT POSITION 0
      AS
      BEGIN
      insert into commission values (100,100);
      END !!
      SET TERM ; !!

      —

      SET TERM !! ;
      CREATE PROCEDURE CountTo10
      RETURNS (Cnt INTEGER)
      AS
      BEGIN
      Cnt = 1;
      WHILE (Cnt < = 10) DO
      Cnt = Cnt + 1;
      END !!

      SET TERM ; !!

      —-
      An example how to use stored procedure from delphi is as follows:
      procedure TForm1.Button1Click(Sender: TObject);
      var

      result : integer;
      begin
      if ibdatabase1.Connected = false then
      begin

      ibdatabase1.Connected := true;

      end;

      with IBStoredProc1 do
      execproc;

      IBStoredProc1.Transaction.Commit;

      result := IBStoredProc1.Params.ParamValues[‘Cnt’];

      showmessage(inttostr(result));

      end;

      From: http://sitestree.com/?p=4727
      Categories:2
      Tags:
      Post Data:2008-07-08 16:53:04

          Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

      Aug 20

      FireBird GUI Tools #2

      GUI Tools for Firebird DB management
      ————————————

      Commercial
      These are very good tools
      IBExpert – Developer Studio
      Interbase firebird development studio – develop/design
      EMS sql mgmt studion for interbase/firebirdails.html — http://www.soft32download.com/software/EMS-SQL-Manager-2005-for-InterBase-Firebird-download-details.html
      xstarter FBIB – good management tools–scheduling of works — http://www.xstarter.com/firebird-interbase-job-scheduler.html

      Free
      —-Development and Administration Tools
      DbVisualizer Free
      JDBStudio
      ibview
      ibexpert free personal edition limited
      IBSQL not great but have some good features
      Crypton firebird database manager — very good
      administration tool
      IBUtils–design tools
      DBManager Professional–good tool design/develop/admin tool
      FIBS Firebird — InterBase Backup Scheduler
      IBEasy+ — not much useful
      Recommendation:
      ——————

      Crypton firebd db manager —- very good administration
      tool — http://www.crypton.co.uk/freetools.html

      DBManager Professional —- good tool design/develop/admin tool http://www.dbtools.com.br/EN/downloads/downloads_file.php?file_id=11http://www.download.com/DBManager-Standard-Edition/3000-2065-10580436.html?part=dl-DBManager&subj=dl&tag=button

      FIBS Firebird-InterBase Backup Scheduler — http://www.talatdogan.com/frees.htm From: http://sitestree.com/?p=4724
      Categories:2
      Tags:
      Post Data:2009-10-08 18:50:36

          Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

      Aug 20

      Speed: Firebird vs. PostGreSql #2

      Please read.According to this article postgresql faster than firebird. But I also got information/tests where firebird is faster than postgresql.

      http://archives.postgresql.org/pgsql-advocacy/2003-06/msg00280.php

      However, Speed may not be the only factor to select a database product. We can improve raw speed in many alternate ways, hardware solutions, ram, faster storage, faster CPU. To compare speed issue, efficiency issue, we need to take a look how the query optimizations are implemented in databases. How, the joins, inner joins, outer joins are implemented. How multiple joins are implemented. Also, indexing is a factor that also affects performance issue. We can try creating same database and using a queries that are simple to complex and run on both databases and see, how well they perform.

      Postgresql supports SMP (multiple processor system) and provides better efficiency in multiprocessor systems. Firebird, is not still matured in SMP environment.

      Firebird supports 32 bit environment, still not stable/reliable enough for 64 bit env. It supports max ram of 2 gb and hence 150 – 450 concurrent users. Postgresql supports 2 TB of ram in a single server. For both of them, we can implement multiple servers with master/slave relation for better performances.

      From: http://sitestree.com/?p=4718
      Categories:2
      Tags:
      Post Data:2010-10-28 19:53:29

          Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

      Aug 20

      Query Optimization in Firebird #2

      Please check: http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1154575297:5422&page=ibp_50_query From: http://sitestree.com/?p=4717
      Categories:2
      Tags:
      Post Data:2012-08-31 08:12:40

          Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

      Aug 20

      Why PostGress better than FireBird: This comparison may not be accurate though. #2

      Postgres Vs Interbase/Firebird (Score:0) By Anonymous Reader on 2004.12.03 18:23 (#102740) http://www.vitavoom.com/postgresql.htmlFirebird has not true text type you must use the clumsy blobs and weird blob subtypes.Postgres is much closer for enterprise use than Firebird.almost all of this applies to Firebird as well as interbase.PostgreSQL vs InterbasePostgreSQL… * … has no “dialects” or other weird features. * … has no “backdoors” which can compromise your whole company’s security and business (check here and here). * … supports unlimited row sizes, unlimited datasebase sizes, tables up to 16TB (!!), unlimited number of rows, unlimited indexes for table and 1Gb per field. * … has a boolean field. * … can cancel a query asynchronously (Interbase 6.5 – the commercial version – seems to support it now). * … has a flexible (not fixed) types system, and supports more types then Interbase. You can always add your own types at your wish, or change existent types behavior. PostgreSQL even has geometrical and IPv4 types support (!!). * … supports inheritance. * .. supports flexible full text indexing through OpenFTS. * … has a much more sofisticated locking mechanism (MVCC). * … has arbitrary precision numeric fileds (numeric type). * … is resistant to crashes and power failures (by using it’s logging system, MVCC and chepoint)). Although it is technically possible that a database gets corrupt, we at Vita voom never saw it (except for corrupt media storage of course). * … supports functions (whose can be used as stored procedures). These functions current can be written on SQL, pl/PgSQL (a language similar to Oracle’s pl/SQL), TCL, Perl, and Python, C, C++ (or other compiled languages) but it’s not limited to them. * … can have functions to define default values for columns (providing ultimate default value flexibility). * … supports much more arrays types then Interbase, they are more flexible and can support much more elements. * … supports rules. * … supports “fetch” SQL command to get only a limited number of rows at a time, making queries more responsive and resource economic. * … has regular expressions support (for searches and operations). * … has a ‘EXPLAIN’ command which will show will how it will perform a query, so that you optimize it. * … has statistics about database usage which can be used to optimize queries and indices. * … has sequences. * … has more built-in functions then Interbase (or any other open source RDBMS). * … supports indexes on functions. * … has broader subselects support then Interbase. * … has a more flexible BLOB fields support. * … can limit the number of rows retrieved at at time (with the ‘LIMIT’ keyword). * … is more standards-compliant then Interbase. * … allo From: http://sitestree.com/?p=4715
      Categories:2
      Tags:
      Post Data:2013-03-14 18:15:43

          Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

      Aug 20

      Important Links for Mysql, PostGreSQL, Firebird, EnterpriseDB, Ingres #2

      Firebird and postgresql:http://www.linuxjournal.com/node/7010
      Important comment: easy to migrate from oracle to firebird than to postgre or mysql. From interbase to firebird will be better as they are similar.

      http://forums.devshed.com/firebird-sql-development-61/mysql–vs–firebird-sql-62269.html : Firebird is far better choice than mysql
      As for Performance, MySQL will outperform Firebird on almost all tests on local machine……
      On a Network Server a properly designed Firebird Server will outperform MySQL on any Test and the network-Traffic generated by Mysql will be many times higher than FirebirdSo you decide the one you need according to your needs …..

      This link also compares fb with potgre and favors fb as the author’s background is borland

      Why Postgress is better than firebird

      Firebird is not as good as PostgresQL (Score:0) By Anonymous Reader on 2004.12.03 2:21 (#102703) And here is why:

      1. Firebird has no temp table support.

      2. Firebird uses several SQL modes i.e DSQL which only works client side and PSQL which only works in procs. All sql works in Postgres functions.Try creating a table or a user in a Firebird proc…ooops can’t be done.

      3. Firebird databases grow out of control and have to be backed up restored on a regular basis.

      4. Firebird has a concept of a OAT (oldest active transaction counter) if this counter gets stuck all transactions get held up and your DB size goes through the roof and performance goes to the basement.

      5. Firebird has virtually no built in functions and flakey UDFs must be used. Postgres on the other hand has every function you can think of.

      6. Postgres has many rich procedural languages including perl,TCL,Java and C# in the works.

      I could go on…. Version 8 of Postgres which will be released soon adds point in time recovery, Try except error handling in functions, table spaces and more.

      I converted all my apps from Firebird 1.5 to Postgresql 7.4 and I would never use Firebird again on Unix or Windows

      From: http://sitestree.com/?p=4714
      Categories:2
      Tags:
      Post Data:2008-08-04 23:03:04

          Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>